db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From siddharth srivastava <akssps...@gmail.com>
Subject Re: [jira] Commented: (DERBY-4907) EmbeddedXADataSource with ;create=true attribute set in setDatabaseName fails with java.sql.SQLException: Database not available
Date Tue, 01 Feb 2011 17:25:58 GMT
Hi

On 1 February 2011 09:22, Nirmal Fernando <nirmal070125@gmail.com> wrote:

> Hi,
>
> Welcome to Derby!
>
> On Tue, Feb 1, 2011 at 10:42 PM, Siddharth Srivastava (JIRA)
> <jira@apache.org> wrote:
> >
> >    [
> https://issues.apache.org/jira/browse/DERBY-4907?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12989283#comment-12989283]
> >
> > Siddharth Srivastava commented on DERBY-4907:
> > ---------------------------------------------
> >
> > What coding and naming conventions need to be followed for Derby ? Is
> there any documentation related to the same.
> >
>
> This contains some:
> http://wiki.apache.org/db-derby/DerbyContributorChecklist


Thanks Nirmal :)

>
>
> >> EmbeddedXADataSource with ;create=true attribute set in setDatabaseName
> fails with java.sql.SQLException: Database not available
> >>
> --------------------------------------------------------------------------------------------------------------------------------
> >>
> >>                 Key: DERBY-4907
> >>                 URL: https://issues.apache.org/jira/browse/DERBY-4907
> >>             Project: Derby
> >>          Issue Type: Bug
> >>          Components: JDBC
> >>    Affects Versions: 10.1.3.1, 10.2.2.0, 10.3.3.0, 10.4.2.0, 10.5.3.0,
> 10.6.2.1
> >>            Reporter: Kathey Marsden
> >>            Assignee: Siddharth Srivastava
> >>            Priority: Minor
> >>
> >> Setting the ;create=true attribute in setDatabaseName with
> EmbededXADataSource and EmbeddedXADataSource40  fails with
> >> $ java TestDerbyCreate
> >> Exception in thread "main" java.sql.SQLException: Database not available
> >>         at
> org.apache.derby.jdbc.EmbeddedXADataSource.setupResourceAdapter(Embe
> >> dedXADataSource.java:175)
> >>         at
> org.apache.derby.jdbc.EmbeddedXADataSource.getXAConnection(EmbeddedX
> >> DataSource.java:101)
> >>         at TestDerbyCreate.main(TestDerbyCreate.java:18)
> >>
> >> using the create attributie in databaseName works fine with
> EmbeddedDataSource.
> >> Using setCreateDatabase("create") with EmbeddedXADataSource is a good
> work around and I think generally preferable.
> >> import java.sql.*;
> >> import javax.sql.*;
> >> public class TestDerbyCreate
> >> {
> >>     public static void main(String[] args) throws Throwable
> >>     {
> >>         org.apache.derby.jdbc.EmbeddedXADataSource ds =
> >>             new
> >> org.apache.derby.jdbc.EmbeddedXADataSource();
> >>         ds.setDatabaseName("TestDB;create=true");
> >>         ds.setUser("dbuser1");
> >>         ds.setPassword("dbpwd1");
> >>       PooledConnection pooledConn = ds.getXAConnection();
> >>         Connection conn = pooledConn.getConnection();
> >>         System.out.println("Database product: " +
> >> conn.getMetaData().getDatabaseProductName());
> >>         System.out.println("Database version: " +
> >> conn.getMetaData().getDatabaseProductVersion());
> >>         System.out.println("Driver name:      " +
> >> conn.getMetaData().getDriverName());
> >>         System.out.println("Driver version:   " +
> >> conn.getMetaData().getDriverVersion());
> >>         System.out.println("JDBC driver major ve
> >
> > --
> > This message is automatically generated by JIRA.
> > -
> > For more information on JIRA, see:
> http://www.atlassian.com/software/jira
> >
> >
> >
>
>
>
> --
> Best Regards,
> Nirmal
>
> C.S.Nirmal J. Fernando
> Department of Computer Science & Engineering,
> Faculty of Engineering,
> University of Moratuwa,
> Sri Lanka.
> Blog: http://nirmalfdo.blogspot.com/
>



-- 
Regards
Siddharth Srivastava

Mime
View raw message