Hi On 1 February 2011 09:22, Nirmal Fernando <[email protected]> wrote:
> 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 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
