Hi, Welcome to Derby!
On Tue, Feb 1, 2011 at 10:42 PM, Siddharth Srivastava (JIRA) <[email protected]> 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 >> 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/
