your main problem is: java.lang.ClassNotFoundException: org.hsql.jdbcDriver be sure the jdbcDriver is in your tomcats (or your applications) classpath!
put the hpyersonic jdbc driver jar in your <tomcat-home>/common/lib
OR
put the hpyersonic jdbc driver jar in your web application (into the WEB-INF/lib directory)
Anoop Verma wrote:
Hi,
I have a requirement in which i need to load the servlet on startup. The Servlet then performs some database activities.
But when i try to it, my servlet loads twice and later on give the following error.
TyrexDataSourceFactory: Cannot create DataSource, Exception java.lang.ClassNotFoundException: org.hsql.jdbcDriver at org.apache.catalina.loader.StandardClassLoader.loadClass(StandardClass Loader.java:1127) at org.apache.catalina.loader.StandardClassLoader.loadClass(StandardClass Loader.java:992) at java.lang.ClassLoader.loadClassInternal(ClassLoader.java:322) at java.lang.Class.forName0(Native Method) at java.lang.Class.forName(Class.java:130) at org.apache.naming.factory.TyrexDataSourceFactory.getObjectInstance(Tyr exDataSourceFactory.java:210) at org.apache.naming.factory.ResourceFactory.getObjectInstance(ResourceFa ctory.java:165) at javax.naming.spi.NamingManager.getObjectInstance(NamingManager.java:31 1) at org.apache.naming.NamingContext.lookup(NamingContext.java:835) at org.apache.naming.NamingContext.lookup(NamingContext.java:181) at org.apache.naming.NamingContext.lookup(NamingContext.java:822) at org.apache.naming.NamingContext.lookup(NamingContext.java:194) at com.necpc.db.ConnectionManager.createConnection(ConnectionManager.java :44) at com.necpc.store.ServiceStore.getDBConnection(ServiceStore.java:52) at com.necpc.store.ServiceStore.<init>(ServiceStore.java:41) at com.necpc.util.requestInfoValidation.VerifyService(requestInfoValidati on.java:92) at com.necpc.util.TimerHttpTest.run(TimerHttpTest.java:51) at java.util.TimerThread.mainLoop(Timer.java:432) at java.util.TimerThread.run(Timer.java:382) javax.naming.NamingException: Exception creating DataSource: org.hsql.jdbcDriver at org.apache.naming.factory.TyrexDataSourceFactory.getObjectInstance(Tyr exDataSourceFactory.java:233) at org.apache.naming.factory.ResourceFactory.getObjectInstance(ResourceFa ctory.java:165) at javax.naming.spi.NamingManager.getObjectInstance(NamingManager.java:31 1) at org.apache.naming.NamingContext.lookup(NamingContext.java:835) at org.apache.naming.NamingContext.lookup(NamingContext.java:181) at org.apache.naming.NamingContext.lookup(NamingContext.java:822) at org.apache.naming.NamingContext.lookup(NamingContext.java:194) at com.necpc.db.ConnectionManager.createConnection(ConnectionManager.java :44) at com.necpc.store.ServiceStore.getDBConnection(ServiceStore.java:52) at com.necpc.store.ServiceStore.<init>(ServiceStore.java:41) at com.necpc.util.requestInfoValidation.VerifyService(requestInfoValidati on.java:92) at com.necpc.util.TimerHttpTest.run(TimerHttpTest.java:51) at java.util.TimerThread.mainLoop(Timer.java:432) at java.util.TimerThread.run(Timer.java:382)
I feel this problem could be because the servlet is loading twice on Start up.
In case u have the solution or fix i would be obliged if you provide me with the same.
Thanks and Regards
Anoop Verma
Senior Consultant Quinnox Consultancy Services
--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
