> 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
