Unable to Load the Driver!

[Somnath Mallick]

Hi Everyone,

I am getting this error when i am loading the JDBC class driver code. The funny thing is the code was taken from a working JDBC code written compiled and run successfully. But now its throwing an error:

java.lang.ClassNotFoundException: oracle.jdbc.xa.client.OracleXADataSource
	at org.apache.catalina.loader.WebappClassLoader.loadClass(WebappClassLoader.java:1387)
	at org.apache.catalina.loader.WebappClassLoader.loadClass(WebappClassLoader.java:1233)
	at java.lang.ClassLoader.loadClassInternal(ClassLoader.java:320)
	at java.lang.Class.forName0(Native Method)
	at java.lang.Class.forName(Class.java:169)
	at com.techm.bt.b2b.or.ivvtPortal.reportServlet.InputServlet.doPost(InputServlet.java:37)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:637)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
	at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
	at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
	at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:128)
	at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
	at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
	at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:293)
	at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:849)
	at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:583)
	at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:454)
	at java.lang.Thread.run(Thread.java:619)

[Somnath Mallick]

The code that throws the error is:

Class.forName("oracle.jdbc.xa.client.OracleXADataSource").newInstance();

[Sebastian Janisch]

You should not use newInstance. You simply load the class once using Class.forName () so the static block runs doing whatever it is doing.

You obtain a Connection using the DriverManager.

[Somnath Mallick]

Even without newInstance() method its throwing the error. I first coded without it, then as it was throwing the error i added the newInstance() in the end to check!

[Sebastian Janisch]

well it's throwing a CNF error meaning that either the you got the wrong path to the driver or the jar is not in the classpath.

[Somnath Mallick]

I have the jar added in the classpath. The thing is i guess its something to do with Tomcat rather the jars and classpaths. I have made a post in the Tomcat section as well about this:
http://www.coderanch.com/t/476492/Tomcat/Tomcat-Throwing-java-lang-ClassNotFoundException

[Somnath Mallick]

Issue resolved.