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 Dev@wso2.org http://wso2.org/cgi-bin/mailman/listinfo/dev