Looking for same information.
I have troubles with Derby JDBC Urls.
In some tools the Derby database path in system must be spesified in jdbc url for ex.
jdbc:derby://localhost:1527/C:\Programs\Java\db-derby-10.5.3.0-bin\CustomerDB
Currently I have a problem with JBoss AS 6 Final Derby datasource definitions.
The exception below "java.lang.ClassNotFoundException: org.jboss.jdbc.DerbyDatabase"
claims that driver class is not found although I have put the derby jars to server lib directory
( derby.jar, derbyclient.jar, derby-plugin.jar )
2010-12-30 23:42:32,419 ERROR [org.jboss.kernel.plugins.dependency.AbstractKernelController] (HDScanner) Error installing to Instantiated:
name=jboss:service=Derby state=Described mode=Manual requiredState=Configured: java.lang.ClassNotFoundException: org.jboss.jdbc.DerbyDatabase from BaseClassLoader@7c3e4b{vfs:///C:/Programs/Java/JBoss/jboss-6.0.0.Final/server/default/deploy/ElectrWireGen2-ds.xml}
at org.jboss.classloader.spi.base.BaseClassLoader.loadClass(BaseClassLoader.java:480) [jboss-classloader.jar:2.2.0.GA]
at java.lang.ClassLoader.loadClass(ClassLoader.java:248) [:1.6.0_17]
at org.jboss.mx.server.MBeanServerImpl.instantiate(MBeanServerImpl.java:1216) [:6.0.0.GA]
at org.jboss.mx.server.MBeanServerImpl.instantiate(MBeanServerImpl.java:288) [:6.0.0.GA]
at org.jboss.system.ServiceCreator.installPlainMBean(ServiceCreator.java:217) [:6.0.0.Final (Build SVNTag:JBoss_6.0.0.Final date: 20101228)]
at org.jboss.system.ServiceCreator.install(ServiceCreator.java:133) [:6.0.0.Final (Build SVNTag:JBoss_6.0.0.Final date: 20101228)]
at org.jboss.system.microcontainer.InstantiateAction.installAction(InstantiateAction.java:73) [:2.2.0.GA]
at org.jboss.system.microcontainer.InstantiateAction.installAction(InstantiateAction.java:46) [:2.2.0.GA]
at org.jboss.dependency.plugins.action.SimpleControllerContextAction.simpleInstallAction(SimpleControllerContextAction.java:62) [jboss-dependency.jar:2.2.0.GA]
at org.jboss.dependency.plugins.action.AccessControllerContextAction.install(AccessControllerContextAction.java:71) [jboss-dependency.jar:2.2.0.GA]
at org.jboss.dependency.plugins.AbstractControllerContextActions.install(AbstractControllerContextActions.java:51) [jboss-dependency.jar:2.2.0.GA]
The datasource definition in ../server/default/deploy directory is
<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE datasources
PUBLIC "-//JBoss//DTD JBOSS JCA Config 1.5//EN"
"http://www.jboss.org/j2ee/dtd/jboss-ds_1_5.dtd">
<datasources>
<local-tx-datasource>
<jndi-name>ElectrWireGen2Datasource</jndi-name>
<use-java-context>false</use-java-context>
<connection-url>jdbc:derby://localhost:1527/C\:/Programs/Java/db-derby-10.5.3.0-bin/ElectricWiringsDB</connection-url>
<driver-class>org.apache.derby.jdbc.EmbeddedDriver</driver-class>
<user-name>me</user-name>
<password>mine</password>
</local-tx-datasource>
<mbean code="org.jboss.jdbc.DerbyDatabase" name="jboss:service=Derby">
<attribute name="Database">C\:/Programs/Java/db-derby-10.5.3.0-bin/ElectricWiringsDB</attribute>
</mbean>
</datasources>