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
