| Connecting to Derby 10.1.3.1 Network Server [message #20452] |
Tue, 22 August 2006 22:31  |
Eclipse User |
|
|
|
I am trying to connect to a 10.1.3.1 Derby Network Server using DTP
0.9.0.200607281. I have tried using both the Embedded Derby Database and
SQL Model-JDBC Connection and both give me the ClassNotFoundException
below when I press Test Connection. I am able to connect with the same
configurations in SQL and I am able to connect to an Embedded Derby
database using DTP.
Does anybody know why I would be getting a class not found exception?
Connection Info:
Database: SAMPLE
URL: jdbc:derby://localhost:1527/sample;create=true
user: sa
password: sa
driver files: F:\java\db-derby=10.1.3.1-bin\lib\derbyclient.jar
java.lang.ClassNotFoundException:
at java.net.URLClassLoader$1.run(Unknown Source)
at java.security.AccessController.doPrivileged(Native Method)
at java.net.URLClassLoader.findClass(Unknown Source)
at java.lang.ClassLoader.loadClass(Unknown Source)
at java.net.FactoryURLClassLoader.loadClass(Unknown Source)
at java.lang.ClassLoader.loadClass(Unknown Source)
at
org.eclipse.datatools.connectivity.db.generic.JDBCConnection .createConnection(JDBCConnection.java:87)
at
org.eclipse.datatools.connectivity.db.derby.DerbyEmbeddedJDB CConnection.createConnection(DerbyEmbeddedJDBCConnection.jav a:136)
at
org.eclipse.datatools.connectivity.DriverConnectionBase.inte rnalCreateConnection(DriverConnectionBase.java:103)
at
org.eclipse.datatools.connectivity.DriverConnectionBase.open (DriverConnectionBase.java:53)
at org.eclipse.datatools.connectivity.db.generic.JDBCConnection .
(JDBCConnection.java:48)
at
org.eclipse.datatools.connectivity.db.derby.DerbyEmbeddedJDB CConnection.
(DerbyEmbeddedJDBCConnection.java:55)
at
org.eclipse.datatools.connectivity.db.derby.DerbyJDBCConnect ionFactory.createConnection(DerbyJDBCConnectionFactory.java: 31)
at
org.eclipse.datatools.connectivity.internal.ConnectionFactor yProvider.createConnection(ConnectionFactoryProvider.java:85 )
at
org.eclipse.datatools.connectivity.internal.ConnectionFactor yProvider.createConnection(ConnectionFactoryProvider.java:69 )
at
org.eclipse.datatools.connectivity.internal.ConnectionProfil e.createConnection(ConnectionProfile.java:304)
at org.eclipse.datatools.connectivity.ui.PingJob.run(PingJob.ja va:57)
at org.eclipse.core.internal.jobs.Worker.run(Worker.java:58)
|
|
|
| Re: Connecting to Derby 10.1.3.1 Network Server [message #21122 is a reply to message #20452] |
Tue, 29 August 2006 17:04  |
| Eclipse User |
|
|
|
Originally posted by: john.graham.sybase.com
Christopher M. Judd wrote:
> I am trying to connect to a 10.1.3.1 Derby Network Server using DTP
> 0.9.0.200607281. I have tried using both the Embedded Derby Database and
> SQL Model-JDBC Connection and both give me the ClassNotFoundException
> below when I press Test Connection. I am able to connect with the same
> configurations in SQL and I am able to connect to an Embedded Derby
> database using DTP.
> Does anybody know why I would be getting a class not found exception?
> Connection Info:
> Database: SAMPLE
> URL: jdbc:derby://localhost:1527/sample;create=true
> user: sa
> password: sa
> driver files: F:javadb-derby=10.1.3.1-binlibderbyclient.jar
> java.lang.ClassNotFoundException:
>snip<
Hi Christopher:
There's something strange going wrong with the Derby Client driver
template -- it is returning an empty string for the driver class, which is
why you're getting a ClassNotFound exception.
I was able to connect to a Derby network server using a "Generic JDBC"
driver template (in the template pref page, highlight "Database" and click
on "Add")and the SQL Model - JDBC connection profile though, so that
should work for you too.
HTH,
John Graham
Eclipse Data Tools Platform PMC Chair
|
|
|
| Re: Connecting to Derby 10.1.3.1 Network Server [message #582024 is a reply to message #20452] |
Tue, 29 August 2006 17:04 |
| Eclipse User |
|
|
|
Christopher M. Judd wrote:
> I am trying to connect to a 10.1.3.1 Derby Network Server using DTP
> 0.9.0.200607281. I have tried using both the Embedded Derby Database and
> SQL Model-JDBC Connection and both give me the ClassNotFoundException
> below when I press Test Connection. I am able to connect with the same
> configurations in SQL and I am able to connect to an Embedded Derby
> database using DTP.
> Does anybody know why I would be getting a class not found exception?
> Connection Info:
> Database: SAMPLE
> URL: jdbc:derby://localhost:1527/sample;create=true
> user: sa
> password: sa
> driver files: F:javadb-derby=10.1.3.1-binlibderbyclient.jar
> java.lang.ClassNotFoundException:
>snip<
Hi Christopher:
There's something strange going wrong with the Derby Client driver
template -- it is returning an empty string for the driver class, which is
why you're getting a ClassNotFound exception.
I was able to connect to a Derby network server using a "Generic JDBC"
driver template (in the template pref page, highlight "Database" and click
on "Add")and the SQL Model - JDBC connection profile though, so that
should work for you too.
HTH,
John Graham
Eclipse Data Tools Platform PMC Chair
|
|
|
Powered by
FUDForum. Page generated in 0.02694 seconds
Home