Re: roller 2.0 initialization problem

[Anil Gangolli]

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:43b95008309632128190681!