db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Nirmal Fernando <nirmal070...@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:22:57 GMT
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

>> 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/

Mime
View raw message