Hi Sameera, In order to create derby databases, those three jars should be present in the /repository/components/extensions directory. Secondly, the same set of drivers should be present in /repository/components/lib directory where dblookup mediator will pick them up. The first purpose is clearly mentioned in [1]. I think the same thing should be mentioned in [2] as well.
@Isuru, Can you please confirm this? [1] https://docs.wso2.org/display/ESB481/Setting+up+with+Remote+Derby [2] https://docs.wso2.org/display/ESB481/Setting+Up+the+ESB+Samples Thanks, On Wed, Apr 9, 2014 at 9:28 PM, Sameera Kannangara <[email protected]>wrote: > Hi all, > > When running ESB 4.8.1 - sample 360 > [1]<https://docs.wso2.org/display/ESB481/Sample+360%3A+Introduction+to+dblookup+Mediator>, > I got the following exception and stack trace. > > ERROR - DBLookupMediator Error executing statement : select * from company > where name =? against DataSource : > jdbc:derby://localhost:1527/esbdb;create=false > org.apache.commons.dbcp.SQLNestedException: Cannot load JDBC driver class > 'org.apache.derby.jdbc.ClientDriver' > at > org.apache.commons.dbcp.BasicDataSource.createConnectionFactory(BasicDataSource.java:1429) > at > org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:1371) > at > org.apache.commons.dbcp.BasicDataSource.getConnection(BasicDataSource.java:1044) > at > org.apache.synapse.mediators.db.DBLookupMediator.processStatement(DBLookupMediator.java:44) > at > org.apache.synapse.mediators.db.AbstractDBMediator.mediate(AbstractDBMediator.java:143) > at > org.apache.synapse.mediators.AbstractListMediator.mediate(AbstractListMediator.java:77) > at > org.apache.synapse.mediators.AbstractListMediator.mediate(AbstractListMediator.java:47) > at > org.apache.synapse.mediators.filters.InMediator.mediate(InMediator.java:61) > at > org.apache.synapse.mediators.AbstractListMediator.mediate(AbstractListMediator.java:77) > at > org.apache.synapse.mediators.AbstractListMediator.mediate(AbstractListMediator.java:47) > at > org.apache.synapse.mediators.base.SequenceMediator.mediate(SequenceMediator.java:131) > at > org.apache.synapse.core.axis2.Axis2SynapseEnvironment.injectMessage(Axis2SynapseEnvironment.java:228) > at > org.apache.synapse.core.axis2.SynapseMessageReceiver.receive(SynapseMessageReceiver.java:83) > at org.apache.axis2.engine.AxisEngine.receive(AxisEngine.java:180) > at > org.apache.synapse.transport.passthru.ServerWorker.processEntityEnclosingRequest(ServerWorker.java:411) > at > org.apache.synapse.transport.passthru.ServerWorker.run(ServerWorker.java:183) > at > org.apache.axis2.transport.base.threads.NativeWorkerPool$1.run(NativeWorkerPool.java:172) > at > java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:895) > at > java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:918) > at java.lang.Thread.run(Thread.java:662) > Caused by: java.lang.ClassNotFoundException: > org.apache.derby.jdbc.ClientDriver > at java.net.URLClassLoader$1.run(URLClassLoader.java:202) > at java.security.AccessController.doPrivileged(Native Method) > at java.net.URLClassLoader.findClass(URLClassLoader.java:190) > at java.lang.ClassLoader.loadClass(ClassLoader.java:306) > at sun.misc.Launcher$AppClassLoader.loadClass(Launcher.java:301) > at java.lang.ClassLoader.loadClass(ClassLoader.java:247) > at > org.eclipse.core.runtime.internal.adaptor.ContextFinder.loadClass(ContextFinder.java:131) > at java.lang.ClassLoader.loadClass(ClassLoader.java:247) > at > org.apache.commons.dbcp.BasicDataSource.createConnectionFactory(BasicDataSource.java:1420) > ... 19 more > > When searching for fixes for above problem I came across a youtube video > explaining how to run ESB sample 360 at > [2]<https://www.youtube.com/watch?v=gStDjnS0JTw> > . > According the video, jar files derby.jar, derbyclient.jar and derbynet.jar > should be added to both <ESB_HOME>/repository/components/extensions and > <ESB_HOME>/repository/components/lib directories. > But the instruction to add above jars to the > <ESB_HOME>/repository/components/extensions directory seems to be missing > in the documentation. > After adding jars to both directories ESB 4.8.1 - sample 360 runs > correctly and provides expected outputs. > > Is there another way to fix this problem? > > Thank you, > -- > Sameera Kannangara, > Software Engineer, > WSO2 Inc. > > [1] > https://docs.wso2.org/display/ESB481/Sample+360%3A+Introduction+to+dblookup+Mediator > [2] https://www.youtube.com/watch?v=gStDjnS0JTw > > _______________________________________________ > Dev mailing list > [email protected] > http://wso2.org/cgi-bin/mailman/listinfo/dev > > -- *Gayan Kaushalya Yalpathwala* Software Engineer WSO2 Inc.; http://wso2.com lean.enterprise.middleware mobile: +94 71 8682704 <http://asia14.wso2con.com/> <http://asia14.wso2con.com/>
_______________________________________________ Dev mailing list [email protected] http://wso2.org/cgi-bin/mailman/listinfo/dev
