ref: connection to derby failed

Pranav Aggarwal Thu, 08 Feb 2007 19:36:49 -0800

Hi all,

I am new to Derby, just trying a small program which makes connection toderby DB.

Following program I have written:
import java.sql.*;

class derby_connect
{
      void connect() throws Exception
      {
              String driver="org.apache.derby.jdbc.EmbeddedDriver";
              String dbName="mydb";
              String connectionURL="jdbc:derby:"+dbName;

              Connection conn=null;
              try
              {
                      Class.forName(driver);
              }catch(java.lang.ClassNotFoundException e)
              {
                      e.printStackTrace();
              }
              try
              {
                      conn=DriverManager.getConnection(connectionURL);
                      System.out.println("Connection established!!!");
              }
              catch(Throwable e)
              {e.printStackTrace();}
              finally {conn.close();}

      }//end of connect()
      public static void main(String args[]) throws Exception
      {
              derby_connect dc=new derby_connect();
              dc.connect();
      }
}//end of class

The program resides in same directory where DB is residing. Now when Irun, I get the following error:


$ java derby_connect

java.sql.SQLException: Failed to start database 'mydb', see the nextexception for details.atorg.apache.derby.impl.jdbc.SQLExceptionFactory40.getSQLException(UnknownSource)at org.apache.derby.impl.jdbc.Util.newEmbedSQLException(UnknownSource)at org.apache.derby.impl.jdbc.Util.newEmbedSQLException(UnknownSource)at org.apache.derby.impl.jdbc.Util.generateCsSQLException(UnknownSource)atorg.apache.derby.impl.jdbc.EmbedConnection.newSQLException(Unknown Source)atorg.apache.derby.impl.jdbc.EmbedConnection.bootDatabase(Unknown Source)

      at org.apache.derby.impl.jdbc.EmbedConnection.<init>(Unknown Source)

at org.apache.derby.impl.jdbc.EmbedConnection30.<init>(UnknownSource)at org.apache.derby.impl.jdbc.EmbedConnection40.<init>(UnknownSource)at org.apache.derby.jdbc.Driver40.getNewEmbedConnection(UnknownSource)

      at org.apache.derby.jdbc.InternalDriver.connect(Unknown Source)
      at org.apache.derby.jdbc.AutoloadedDriver.connect(Unknown Source)
      at java.sql.DriverManager.getConnection(DriverManager.java:582)
      at java.sql.DriverManager.getConnection(DriverManager.java:207)
      at derby_connect.connect(derby_connect.java:21)
      at derby_connect.main(derby_connect.java:32)

Caused by: java.sql.SQLException: Failed to start database 'mydb', seethe next exception for details.atorg.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(UnknownSource)atorg.apache.derby.impl.jdbc.SQLExceptionFactory40.wrapArgsForTransportAcrossDRDA(UnknownSource)

      ... 16 more
Exception in thread "main" java.lang.NullPointerException
      at derby_connect.connect(derby_connect.java:26)
      at derby_connect.main(derby_connect.java:32)

Can any one help me with this?

--
Thanks
Pranav Aggarwal
Altair Engineering
www.altair.com

ref: connection to derby failed

Reply via email to