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
