db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Kathey Marsden (JIRA)" <j...@apache.org>
Subject [jira] Created: (DERBY-4907) EmbeddedXADataSource with ;create=true attribute set in setDatabaseName fails with java.sql.SQLException: Database not available
Date Thu, 18 Nov 2010 23:51:13 GMT
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.6.2.1, 10.5.3.0, 10.4.2.0, 10.3.3.0, 10.2.2.0, 10.1.3.1
            Reporter: Kathey Marsden
            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.
-
You can reply to this email to add a comment to the issue online.


Mime
View raw message