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.
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