http://blogs.usd.edu these are the errors thrown on this live server
-----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Allen Gilliland Sent: Friday, June 08, 2007 1:11 PM To: [email protected] Subject: Re: FW: jdbc error on HitCountQueueProcessor > ERROR 2007-06-07 10:07:07,497 JDBCExceptionReporter:logExceptions - > Cannot create JDBC driver of class '' for connect URL 'null' this error indicates that you have not properly setup your jndi datasource and Roller cannot get any database connections. there are other errors including the one with the hit count processing which are basically happening because the app can't get db connections. i don't know how your app could be working and throwing these errors, that doesn't sound feasible. > my question, if this is applicable to the above error, is where do I > place this other roller-cusom.properties file? the statement in the roller.properties file is correct that you really shouldn't need to put in values for the jdbc.* properties. what you need to be doing is defining a jndi datasource in tomcat which is done via tomcat's configuration the roller-custom.properties file should just be placed at the root of the classpath somewhere, which for tomcat is easiest by putting it in the common/classes directory. -- Allen Johnson, Jason R wrote: > Sorry sent to the wrong list originally :) > > -----Original Message----- > From: Johnson, Jason R [mailto:[EMAIL PROTECTED] > Sent: Thursday, June 07, 2007 11:29 AM > To: [EMAIL PROTECTED] > Subject: jdbc error on HitCountQueueProcessor > > I keep receiving this in my roller.log, though roller itself works: > > WARN 2007-06-07 10:07:07,496 JDBCExceptionReporter:logExceptions - SQL > Error: 0, SQLState: null > ERROR 2007-06-07 10:07:07,497 JDBCExceptionReporter:logExceptions - > Cannot create JDBC driver of class '' for connect URL 'null' > ERROR 2007-06-07 10:07:07,497 > HibernateWeblogManagerImpl:getWeblogEntries - > org.hibernate.exception.GenericJDBCException: Cannot open connection > ERROR 2007-06-07 10:07:07,498 FuturePostingsInvalidationJob:execute - > org.apache.roller.RollerException > WARN 2007-06-07 10:08:45,277 JDBCExceptionReporter:logExceptions - SQL > Error: 0, SQLState: null > ERROR 2007-06-07 10:08:45,277 JDBCExceptionReporter:logExceptions - > Cannot create JDBC driver of class '' for connect URL 'null' > ERROR 2007-06-07 10:08:45,278 WorkerThread:run - Error executing job. > Worker = HitCountQueueProcessor, Job = > org.apache.roller.business.runnable.HitCountProcessingJob > org.hibernate.exception.GenericJDBCException: Cannot open connection > at > org.hibernate.exception.SQLStateConverter.handledNonSpecificException(SQ > LStateConverter.java:91) > at > org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java > :79) > at > org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper. > java:43) > at > org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper. > java:29) > at > org.hibernate.jdbc.ConnectionManager.openConnection(ConnectionManager.ja > va:363) > at > org.hibernate.jdbc.ConnectionManager.getConnection(ConnectionManager.jav > a:122) > at > org.hibernate.jdbc.JDBCContext.connection(JDBCContext.java:125) > at > org.hibernate.transaction.JDBCTransaction.begin(JDBCTransaction.java:57) > at > org.hibernate.impl.SessionImpl.beginTransaction(SessionImpl.java:1309) > at sun.reflect.GeneratedMethodAccessor38.invoke(Unknown Source) > at > sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessor > Impl.java:25) > at java.lang.reflect.Method.invoke(Method.java:585) > at > org.hibernate.context.ThreadLocalSessionContext$TransactionProtectionWra > pper.invoke(ThreadLocalSessionContext.java:301) > at $Proxy0.beginTransaction(Unknown Source) > at > org.apache.roller.business.hibernate.HibernatePersistenceStrategy.getSes > sion(HibernatePersistenceStrategy.java:212) > at > org.apache.roller.business.hibernate.HibernatePersistenceStrategy.flush( > HibernatePersistenceStrategy.java:220) > at > org.apache.roller.business.hibernate.HibernateRollerImpl.flush(Hibernate > RollerImpl.java:109) > at > org.apache.roller.business.runnable.HitCountProcessingJob.execute(HitCou > ntProcessingJob.java:108) > at > org.apache.roller.business.runnable.WorkerThread.run(WorkerThread.java:6 > 8) > at > org.apache.roller.business.runnable.ContinuousWorkerThread.run(Continuou > sWorkerThread.java:76) > Caused by: org.apache.tomcat.dbcp.dbcp.SQLNestedException: Cannot create > JDBC driver of class '' for connect URL 'null' > at > org.apache.tomcat.dbcp.dbcp.BasicDataSource.createDataSource(BasicDataSo > urce.java:780) > at > org.apache.tomcat.dbcp.dbcp.BasicDataSource.getConnection(BasicDataSourc > e.java:540) > at > org.hibernate.connection.DatasourceConnectionProvider.getConnection(Data > sourceConnectionProvider.java:69) > at > org.hibernate.jdbc.ConnectionManager.openConnection(ConnectionManager.ja > va:360) > ... 15 more > Caused by: java.sql.SQLException: No suitable driver > at java.sql.DriverManager.getDriver(DriverManager.java:243) > at > org.apache.tomcat.dbcp.dbcp.BasicDataSource.createDataSource(BasicDataSo > urce.java:773) > ... 18 more > WARN 2007-06-07 10:09:57,506 JDBCExceptionReporter:logExceptions - SQL > Error: 0, SQLState: null > ERROR 2007-06-07 10:09:57,506 JDBCExceptionReporter:logExceptions - > Cannot create JDBC driver of class '' for connect URL 'null' > ERROR 2007-06-07 10:09:57,507 > HibernateWeblogManagerImpl:getWeblogEntries - > org.hibernate.exception.GenericJDBCException: Cannot open connection > ERROR 2007-06-07 10:09:57,507 FuturePostingsInvalidationJob:execute - > org.apache.roller.RollerException > WARN 2007-06-07 10:11:45,284 JDBCExceptionReporter:logExceptions - SQL > Error: 0, SQLState: null > ERROR 2007-06-07 10:11:45,285 JDBCExceptionReporter:logExceptions - > Cannot create JDBC driver of class '' for connect URL 'null' > ERROR 2007-06-07 10:11:45,285 WorkerThread:run - Error executing job. > Worker = HitCountQueueProcessor, Job = > org.apache.roller.business.runnable.HitCountProcessingJob > org.hibernate.exception.GenericJDBCException: Cannot open connection > at > org.hibernate.exception.SQLStateConverter.handledNonSpecificException(SQ > LStateConverter.java:91) > at > org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java > :79) > at > org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper. > java:43) > at > org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper. > java:29) > at > org.hibernate.jdbc.ConnectionManager.openConnection(ConnectionManager.ja > va:363) > at > org.hibernate.jdbc.ConnectionManager.getConnection(ConnectionManager.jav > a:122) > at > org.hibernate.jdbc.JDBCContext.connection(JDBCContext.java:125) > at > org.hibernate.transaction.JDBCTransaction.begin(JDBCTransaction.java:57) > at > org.hibernate.impl.SessionImpl.beginTransaction(SessionImpl.java:1309) > at sun.reflect.GeneratedMethodAccessor38.invoke(Unknown Source) > at > sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessor > Impl.java:25) > at java.lang.reflect.Method.invoke(Method.java:585) > at > org.hibernate.context.ThreadLocalSessionContext$TransactionProtectionWra > pper.invoke(ThreadLocalSessionContext.java:301) > at $Proxy0.beginTransaction(Unknown Source) > at > org.apache.roller.business.hibernate.HibernatePersistenceStrategy.getSes > sion(HibernatePersistenceStrategy.java:212) > at > org.apache.roller.business.hibernate.HibernatePersistenceStrategy.flush( > HibernatePersistenceStrategy.java:220) > at > org.apache.roller.business.hibernate.HibernateRollerImpl.flush(Hibernate > RollerImpl.java:109) > at > org.apache.roller.business.runnable.HitCountProcessingJob.execute(HitCou > ntProcessingJob.java:108) > at > org.apache.roller.business.runnable.WorkerThread.run(WorkerThread.java:6 > 8) > at > org.apache.roller.business.runnable.ContinuousWorkerThread.run(Continuou > sWorkerThread.java:76) > Caused by: org.apache.tomcat.dbcp.dbcp.SQLNestedException: Cannot create > JDBC driver of class '' for connect URL 'null' > at > org.apache.tomcat.dbcp.dbcp.BasicDataSource.createDataSource(BasicDataSo > urce.java:780) > at > org.apache.tomcat.dbcp.dbcp.BasicDataSource.getConnection(BasicDataSourc > e.java:540) > at > org.hibernate.connection.DatasourceConnectionProvider.getConnection(Data > sourceConnectionProvider.java:69) > at > org.hibernate.jdbc.ConnectionManager.openConnection(ConnectionManager.ja > va:360) > ... 15 more > Caused by: java.sql.SQLException: No suitable driver > at java.sql.DriverManager.getDriver(DriverManager.java:243) > at > org.apache.tomcat.dbcp.dbcp.BasicDataSource.createDataSource(BasicDataSo > urce.java:773) > ... 18 more > WARN 2007-06-07 10:12:47,513 JDBCExceptionReporter:logExceptions - SQL > Error: 0, SQLState: null > ERROR 2007-06-07 10:12:47,514 JDBCExceptionReporter:logExceptions - > Cannot create JDBC driver of class '' for connect URL 'null' > ERROR 2007-06-07 10:12:47,515 > HibernateWeblogManagerImpl:getWeblogEntries - > org.hibernate.exception.GenericJDBCException: Cannot open connection > ERROR 2007-06-07 10:12:47,515 FuturePostingsInvalidationJob:execute - > org.apache.roller.RollerException > > > In roller.properties it states the below. > > # JDBC configuration parameters ONLY NEEDED FOR RUNNING STANDALONE TASKS > # Don't override these in the roller-custom.properties file you use with > the > # Roller webapp, but for the standalone tasks that you run outside of > Roller > # (e.g. refresh entries) you'll need to override these properties. Do it > in a > # separate roller-custom.properties file. > jdbc.driverClass= > jdbc.connectionURL= > jdbc.username= > jdbc.password= > > my question, if this is applicable to the above error, is where do I > place this other roller-cusom.properties file? > > Thanks, > > jason
