Saturday, December 17, 2011

ATG - atg.service.idgen.IdGeneratorException java.sql.SQLException: java.lang.ClassNotFoundException: oracle.jdbc.driver.OracleDriver

Problem
    Are you getting the following error when you start your dynamo server ?

**** Error      Thu Mar 19 23:46:20 CST 2009    1237527980062   /atg/dynamo/service/IdGenerator ---     CONTAINER:atg.service.idgen.IdGeneratorException; SOURCE:java.sql.SQLException: atg.service.resourcepool.ResourcePoolException: java.sql.SQLException: java.lang.ClassNotFoundException: oracle.jdbc.driver.OracleDriver
**** Error      Thu Mar 19 23:46:20 CST 2009    1237527980062   /atg/dynamo/service/IdGenerator         at atg.service.idgen.SQLIdGenerator.getConnection(SQLIdGenerator.java:624)
**** Error      Thu Mar 19 23:46:20 CST 2009    1237527980062   /atg/dynamo/service/IdGenerator         at atg.service.idgen.SQLIdGenerator.initializeIdSpaces(SQLIdGenerator.java:810)
**** Error      Thu Mar 19 23:46:20 CST 2009    1237527980062   /atg/dynamo/service/IdGenerator         at atg.service.idgen.PersistentIdGenerator.initialize(PersistentIdGenerator.java:305)
**** Error      Thu Mar 19 23:46:20 CST 2009    1237527980062   /atg/dynamo/service/IdGenerator         at atg.service.idgen.AbstractSequentialIdGenerator.doStartService(AbstractSequentialIdGenerator.java:621)
**** Error      Thu Mar 19 23:46:20 CST 2009    1237527980062   /atg/dynamo/service/IdGenerator         at atg.nucleus.GenericService.startService(GenericService.java:495)
**** Error      Thu Mar 19 23:46:20 CST 2009    1237527980062   /atg/dynamo/service/IdGenerator         at atg.nucleus.NucleusNameResolver.startService(NucleusNameResolver.java:1229)
**** Error      Thu Mar 19 23:46:20 CST 2009    1237527980062   /atg/dynamo/service/IdGenerator         at atg.nucleus.NucleusNameResolver.configureAndStartService(NucleusNameResolver.java:1002)
**** Error      Thu Mar 19 23:46:20 CST 2009    1237527980062   /atg/dynamo/service/IdGenerator         at atg.nucleus.NucleusNameResolver.createFromName(NucleusNameResolver.java:705)
**** Error      Thu Mar 19 23:46:20 CST 2009    1237527980062   /atg/dynamo/service/IdGenerator         at atg.nucleus.NucleusNameResolver.createFromName(NucleusNameResolver.java:576)
**** Error      Thu Mar 19 23:46:20 CST 2009    1237527980062   /atg/dynamo/service/IdGenerator ....stack trace CROPPED after 10 lines.

Solution
     By default ATG adds Solid database driver to the classpath. But I changed the JTDatasource/FakeXA configurations to point to my oracle express and changed it to use the the Oracle JDBC Driver. So I had to add Oracle JDBC driver jar file ojdbc14.jar to classpath. So I edited the home/localconfig/postEnvironment.bat and added the path to ojdbc14.jar to the CLASSPATH environment variable and restarted the server to fix the issue.

No comments:

Post a Comment