I'm having some trouble getting Apache Derby embedded inside Tomcat 6 so I can access a database threw my webapp. I am receiving the following error in the catalina.out log file: /Class Not Found: java.lang.ClassNotFoundException: jdbc:derby/. This is generated in the log when the webapp is accessed. I have set the classpath locally with derbys setEmbeddedCP command. I am thinking I also have to specify the classpath in Tomcat too. Is this done by modifying the server.xml globally or the web.xml for each webapp? When I look online for help, most of what I'm finding says all you have to do is copy the derby.jar to $CATALINA_HOME/lib and tomcat will automatically load any jar files it finds, is that true? Any help or feedback on this will be much appreciated, thank you.
Software running on server - RHEL4u3 - Java6u7 - Tomcat6.0 - Derby 10.4.2.0 Directory structure - /usr/apache-tomcat-6.0.18 (CATALINA_HOME) - /usr/apache-tomcat-6.0.18/lib/derby.jar (copied in from DERBY_HOME/lib, figuring tomcat would automatically load it on startup for each webapp) - /usr/java/jdk1.6.0_07 (JAVA_HOME) - /usr/db-derby-10.4.2.0-bin (DERBY_HOME) Robert
