Anil -
Thanks a lot, greate product!
Starting over with the 3.0.17 Connector/J jdbc driver solved the
problem. It certainly brought a smile to my face when I saw the
"Register" link.
Cheers, best wishes for the new year :o)
- Bert
Anil Gangolli wrote:
Judging from the messages, the bad drivers may also have resulted in
actually inserting at least one property with the key '?' literally.
So once your sub in the 3.0.x drivers, you probably want to start with
a freshly created database. --a.
Bert Heymans wrote:
Anil, thanks!
I was trying to set up Roller with 3.1.12 Connector/J. On the mysql
website I found version 3.0.17, couldn't find the 3.0.16 version
anymore but they should have the same effect. I'll try and let you
know if it does the trick.
- Bert
Anil Gangolli wrote:
This one looks like a problem with the version of the mysql jdbc
driver you are using. Some versions of the drivers have problems
with certain versions of the server, particularly with server-side
prepared statements. Try using the 3.0.16 Connector/J drivers;
another workaround involves disabling server-prepared statements.
See also:
http://www.rollerweblogger.org/wiki/Wiki.jsp?page=InstallationFAQs#ref-InstallationFAQs-13
--a
Bert Heymans wrote:
Hi -
I installed Roller 2.0 like the installation guide describes. After
restarting Tomcat I noticed there was no registration link on the
roller page. I checked the mailinglist archives and restarted
Tomcat a few times like Anil Gangolli suggested for someone
experiencing a similar problem.
The dstest.jsp tells me "SUCCESS: Got datasource and connection,
class is org.apache.commons.dbcp.BasicDataSource" but nothing gets
written to the db at startup, all tables are empty (The errors I
get in the roller.log file are at the bottom of this mail) I
googled on the exception messages and I wish I could solve this by
myself but I'm not familiar with Hibernate. Any help or a direction
in wich I could search would be greatly appreciated.
These are my system details:
- Ubuntu Breezy
- Tomcat 5.0.28
- Sun java version 1.5.0_06
- MySQL Distrib 4.1.12, for pc-linux-gnu on i486
If can provide any other information that can help, just say so,
these are the errormessage snippets from the roller.log file:
ERROR 2005-12-26 16:14:11,328 JDBCExceptionReporter:logExceptions -
Duplicate entry '?' for key 1
ERROR 2005-12-26 16:14:11,336
AbstractFlushingEventListener:performExecutions - Could not
synchronize database state with session
org.hibernate.exception.ConstraintViolationException: could not
insert: [org.roller.pojos.RollerPropertyData]
at
org.hibernate.exception.ErrorCodeConverter.convert(ErrorCodeConverter.java:74)
at
org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)
at
org.hibernate.persister.entity.BasicEntityPersister.insert(BasicEntityPersister.java:1869)
at
org.hibernate.persister.entity.BasicEntityPersister.insert(BasicEntityPersister.java:2200)
at
org.hibernate.action.EntityInsertAction.execute(EntityInsertAction.java:46)
at
org.hibernate.engine.ActionQueue.execute(ActionQueue.java:239)
at
org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:223)
at
org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:136)
at
org.hibernate.event.def.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:274)
at
org.hibernate.event.def.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:27)
at org.hibernate.impl.SessionImpl.flush(SessionImpl.java:730)
at
org.roller.business.hibernate.HibernateStrategy.commit(HibernateStrategy.java:428)
at
org.roller.business.hibernate.HibernateRollerImpl.commit(HibernateRollerImpl.java:115)
at
org.roller.presentation.RollerContext.contextInitialized(RollerContext.java:192)
...
...
Caused by: java.sql.BatchUpdateException: Duplicate entry '?' for
key 1
at
com.mysql.jdbc.ServerPreparedStatement.executeBatch(ServerPreparedStatement.java:647)
at
org.apache.commons.dbcp.DelegatingStatement.executeBatch(DelegatingStatement.java:294)
at
org.hibernate.jdbc.BatchingBatcher.doExecuteBatch(BatchingBatcher.java:57)
at
org.hibernate.jdbc.BatchingBatcher.addToBatch(BatchingBatcher.java:33)
at
org.hibernate.persister.entity.BasicEntityPersister.insert(BasicEntityPersister.java:1853)
... 26 more
FATAL 2005-12-26 16:14:11,349 RollerContext:contextInitialized -
RollerContext initialization failed
org.roller.RollerException
at
org.roller.business.hibernate.HibernateStrategy.commit(HibernateStrategy.java:440)
at
org.roller.business.hibernate.HibernateRollerImpl.commit(HibernateRollerImpl.java:115)
at
org.roller.presentation.RollerContext.contextInitialized(RollerContext.java:192)
at
org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:3827)
at
org.apache.catalina.core.StandardContext.start(StandardContext.java:4343)
at
org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1083)
at
org.apache.catalina.core.StandardHost.start(StandardHost.java:789)
at
org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1083)
at
org.apache.catalina.core.StandardEngine.start(StandardEngine.java:478)
at
org.apache.catalina.core.StandardService.start(StandardService.java:480)
at
org.apache.catalina.core.StandardServer.start(StandardServer.java:2313)
at org.apache.catalina.startup.Catalina.start(Catalina.java:556)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:585)
at
org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:287)
at
org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:425)
--- ROOT CAUSE ---
org.hibernate.exception.ConstraintViolationException: could not
insert: [org.roller.pojos.RollerPropertyData]
at
org.hibernate.exception.ErrorCodeConverter.convert(ErrorCodeConverter.java:74)
at
org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)
at
org.hibernate.persister.entity.BasicEntityPersister.insert(BasicEntityPersister.java:1869)
...
...
Caused by: java.sql.BatchUpdateException: Duplicate entry '?' for
key 1
at
com.mysql.jdbc.ServerPreparedStatement.executeBatch(ServerPreparedStatement.java:647)
at
org.apache.commons.dbcp.DelegatingStatement.executeBatch(DelegatingStatement.java:294)
at
org.hibernate.jdbc.BatchingBatcher.doExecuteBatch(BatchingBatcher.java:57)
...
...
...
...
...
WARN 2005-12-26 16:14:35,477 RollerRuntimeConfig:getProperty -
Trouble accessing property: users.registration.enabled
java.lang.NullPointerException
at
org.roller.config.RollerRuntimeConfig.getProperty(RollerRuntimeConfig.java:51)
...
WARN 2005-12-26 16:14:38,286 RollerRuntimeConfig:getProperty -
Trouble accessing property: site.name
java.lang.NullPointerException
at
org.roller.config.RollerRuntimeConfig.getProperty(RollerRuntimeConfig.java:51)
at
org.apache.jsp.theme.tiles_002dfrontpage_jsp._jspService(tiles_002dfrontpage_jsp.java:141)
...
WARN 2005-12-26 16:14:38,294 RollerRuntimeConfig:getProperty -
Trouble accessing property: site.description
java.lang.NullPointerException
at
org.roller.config.RollerRuntimeConfig.getProperty(RollerRuntimeConfig.java:51)
at
org.apache.jsp.theme.tiles_002dfrontpage_jsp._jspService(tiles_002dfrontpage_jsp.java:144)
...
... etc etc for every property from the rollerconfig table.
Thank you very much for taking a look at this.
- Bert
!DSPAM:43b96457314626946214340!
