[jboss-user] [IronJacamar] - Re: using Cloudscape/Derby as Datasource

[Sakari Isoniemi]

Sakari Isoniemi [http://community.jboss.org/people/isonisak] created the discussion

"Re: using Cloudscape/Derby as Datasource"

To view the discussion, visit: http://community.jboss.org/message/578154#578154

--------------------------------------------------------------
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  mailto:BaseClassLoader at 7c3e4b{vfs:///C:/Programs/Java/JBoss/jboss-6.0.0.Final/server/default/deploy/ElectrWireGen2-ds.xml BaseClassLoader at 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 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>
--------------------------------------------------------------

Reply to this message by going to Community
[http://community.jboss.org/message/578154#578154]

Start a new discussion in IronJacamar at Community
[http://community.jboss.org/choose-container!input.jspa?contentType=1&containerType=14&container=2098]

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.jboss.org/pipermail/jboss-user/attachments/20110103/c2eba1ba/attachment.html