Hi, Dave. You are right. Thank you very much for the information. I am testing Apache Roller 4.0.1 with WebSphere 7.0.0.1, which is using OpenJPA 1.2.1 snapshot. I tried to replace file com.ibm.ws.jpa.jar with openjpa-0.9.7-incubating.jar, and I could not start up the server. I tried adjusting classloading to fix the problems, still failed. WebSphere 6.1 uses OpenJPA 1.0.3. I replaced its JPA jar file with openjpa-0.9.7 and started the server, but then I got some other problem. The following is the error message: 62 EST] 00000020 JPAProperties E org.apache.roller.weblogger.business.jpa.JPAPropertiesManagerImpl initialize Failed to initialize runtime configuration properties.Please check that the database has been upgraded! <0.9.7-incubating fatal user error> org.apache.openjpa.persistence.ArgumentException: The type "class org.apache.roller.weblogger.pojos.RuntimeConfigProperty" has not been enhanced. at org.apache. [2/11/09 22:15:51:677 EST] 00000020 WebApp E Exception caught while initializing context java.lang.RuntimeException: <0.9.7-incubating fatal user error> org.apache.openjpa.persistence.ArgumentException: The type "class org.apache.roller.weblogger.pojos.RuntimeConfigProperty" has not been enhanced. at org.apache.roller.weblogger.business.jpa.JPAPropertiesManagerImpl.initialize(JPAPropertiesManagerImpl.java:92) Could you provide me some information about Roller 5? When it will be available and what version of OpenJPA it will support? Thank you very much. David Thank you very much. David
--- On Wed, 2/11/09, Dave <[email protected]> wrote: From: Dave <[email protected]> Subject: Re: I got database error on Roller 4.0.1 To: [email protected], [email protected] Date: Wednesday, February 11, 2009, 10:31 AM Looks like you are running on Websphere and Websphere is using OpenJPA 1.2. Roller 4.0.1 requres OpenJPA 0.9.7 and will not work with 1.2. - Dave On Tue, Feb 10, 2009 at 11:09 PM, (David) Ming Xia <[email protected]> wrote: > 1. Although I did not see anywhere in installation guide mentioning we should work on roller-custom.vm, I got error error message for missing roller-custom.vm file. I finally have to change the name of roller.vm in <apache-roller-4.0.1 binary>\webapp\roller\WEB-INF\velocity\deprecated to the name roller-custom.vm and put it into directory <Roller401 workspace>\ApacheRollerWeb\src, and the error is gone. Is this the same situation to you? Or I got something wrong? > > 2. I am using DB2 9. Now when I tried to create account or blog I constantly got the following errors. Do you know what's wrong with this? > > -------------------------------------------------------------- > Caused by: <openjpa-1.2.1-SNAPSHOT-r422266:707222 fatal general error> org.apache.openjpa.persistence.PersistenceException: The transaction has been rolled back. See the nested exceptions for details on the errors that occurred. > at org.apache.openjpa.kernel.BrokerImpl.newFlushException(BrokerImpl.java:2163) > at org.apache.openjpa.kernel.BrokerImpl.flush(BrokerImpl.java:2010) > at org.apache.openjpa.kernel.BrokerImpl.flushSafe(BrokerImpl.java:1908) > at org.apache.openjpa.kernel.BrokerImpl.beforeCompletion(BrokerImpl.java:1826) > at org.apache.openjpa.kernel.LocalManagedRuntime.commit(LocalManagedRuntime.java:81) > at org.apache.openjpa.kernel.BrokerImpl.commit(BrokerImpl.java:1350) > at org.apache.openjpa.kernel.DelegatingBroker.commit(DelegatingBroker.java:877) > at org.apache.openjpa.persistence.EntityManagerImpl.commit(EntityManagerImpl.java:512) > ... 184 more > Caused by: <openjpa-1.2.1-SNAPSHOT-r422266:707222 nonfatal general error> org.apache.openjpa.persistence.PersistenceException: The insert or update value of the FOREIGN KEY "DAVIDXIA.BOOKMARK.BM_FOLDERID_FK" is not equal to any value of the parent key of the parent table.. SQLCODE=-530, SQLSTATE=23503, DRIVER=3.50.152 {prepstmnt 701376974 INSERT INTO bookmark (id, description, feedurl, image, name, priority, url, weight, folderid) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?) [params=(String) 43638a80-354d-4caf-8c3e-f6ecb7d4fcb1, (String) , (null) null, (null) null, (String) Lance Lavandowska, (int) 0, (String) http://rollerweblogger.org/lance, (int) 0, (String) c26615a2-cb52-4f28-aa6c-3ad76d4874e7]} [code=-530, state=23503]SQLCA OUTPUT[Errp=SQLRI079, Errd=-2145779603, 0, 0, 0, -100, 0] > The insert or update value of the FOREIGN KEY "DAVIDXIA.BOOKMARK.BM_FOLDERID_FK" is not equal to any value of the parent key of the parent table.. SQLCODE=-530, SQLSTATE=23503, DRIVER=3.50.152 > FailedObject: org.apache.roller.weblogger.pojos.weblogbookm...@21e321e3 > at org.apache.openjpa.jdbc.sql.DBDictionary.narrow(DBDictionary.java:4232) > at org.apache.openjpa.jdbc.sql.DBDictionary.newStoreException(DBDictionary.java:4197) > at org.apache.openjpa.jdbc.sql.DB2Dictionary.newStoreException(DB2Dictionary.java:503) > at org.apache.openjpa.jdbc.sql.SQLExceptions.getStore(SQLExceptions.java:102) > at org.apache.openjpa.jdbc.sql.SQLExceptions.getStore(SQLExceptions.java:72) > at org.apache.openjpa.jdbc.kernel.PreparedStatementManagerImpl.flushAndUpdate(PreparedStatementManagerImpl.java:131) > at org.apache.openjpa.jdbc.kernel.BatchingPreparedStatementManagerImpl.batchOrExecuteRow(BatchingPreparedStatementManagerImpl.java:102) > at org.apache.openjpa.jdbc.kernel.BatchingPreparedStatementManagerImpl.flushAndUpdate(BatchingPreparedStatementManagerImpl.java:86) > at org.apache.openjpa.jdbc.kernel.PreparedStatementManagerImpl.flushInternal(PreparedStatementManagerImpl.java:89) > at org.apache.openjpa.jdbc.kernel.PreparedStatementManagerImpl.flush(PreparedStatementManagerImpl.java:72) > at org.apache.openjpa.jdbc.kernel.ConstraintUpdateManager.flush(ConstraintUpdateManager.java:543) > at org.apache.openjpa.jdbc.kernel.ConstraintUpdateManager.flush(ConstraintUpdateManager.java:105) > at org.apache.openjpa.jdbc.kernel.BatchingConstraintUpdateManager.flush(BatchingConstraintUpdateManager.java:59) > at com.ibm.ws.persistence.jdbc.kernel.ConstraintUpdateManager.flush(ConstraintUpdateManager.java:78) > at com.ibm.ws.persistence.jdbc.kernel.ConstraintUpdateManager.flush(ConstraintUpdateManager.java:60) > at org.apache.openjpa.jdbc.kernel.JDBCStoreManager.flush(JDBCStoreManager.java:655) > at org.apache.openjpa.kernel.DelegatingStoreManager.flush(DelegatingStoreManager.java:130) > ... 191 more > Caused by: org.apache.openjpa.lib.jdbc.ReportingSQLException: The insert or update value of the FOREIGN KEY "DAVIDXIA.BOOKMARK.BM_FOLDERID_FK" is not equal to any value of the parent key of the parent table.. SQLCODE=-530, SQLSTATE=23503, DRIVER=3.50.152 {prepstmnt 701376974 INSERT INTO bookmark (id, description, feedurl, image, name, priority, url, weight, folderid) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?) [params=(String) 43638a80-354d-4caf-8c3e-f6ecb7d4fcb1, (String) , (null) null, (null) null, (String) Lance Lavandowska, (int) 0, (String) http://rollerweblogger.org/lance, (int) 0, (String) c26615a2-cb52-4f28-aa6c-3ad76d4874e7]} [code=-530, state=23503] > at org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator.wrap(LoggingConnectionDecorator.java:192) > at org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator.access$700(LoggingConnectionDecorator.java:57) > at org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator$LoggingConnection$LoggingPreparedStatement.executeUpdate(LoggingConnectionDecorator.java:866) > at org.apache.openjpa.lib.jdbc.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:269) > at org.apache.openjpa.jdbc.kernel.JDBCStoreManager$CancelPreparedStatement.executeUpdate(JDBCStoreManager.java:1504) > at org.apache.openjpa.jdbc.kernel.PreparedStatementManagerImpl.executeUpdate(PreparedStatementManagerImpl.java:151) > at org.apache.openjpa.jdbc.kernel.PreparedStatementManagerImpl.flushAndUpdate(PreparedStatementManagerImpl.java:120) > ... 202 more > [2/10/09 22:35:25:355 EST] 0000002c LocalizedText W com.opensymphony.xwork2.util.LocalizedTextUtil findText Trying to find text with null key! > [2/10/09 22:35:25:676 EST] 0000002e servlet E com.ibm.ws.webcontainer.servlet.ServletWrapper service SRVE0068E: Uncaught exception created in one of the service methods of the servlet PreviewThemeImageServlet in application ApacheRoller. Exception created : java.lang.NullPointerException > at com.ibm.ws.webcontainer.srt.SRTServletResponse.setContentType(SRTServletResponse.java:1241) > at org.apache.roller.weblogger.ui.rendering.servlets.PreviewThemeImageServlet.doGet(PreviewThemeImageServlet.java:109) > at javax.servlet.http.HttpServlet.service(HttpServlet.java:718) > at javax.servlet.http.HttpServlet.service(HttpServlet.java:831) > at com.ibm.ws.webcontainer.servlet.ServletWrapper.service(ServletWrapper.java:1449) > at com.ibm.ws.webcontainer.servlet.ServletWrapper.service(ServletWrapper.java:1384) > --------------------------------------------------------------------------------------------------------------------------- > > > Thank you. > > > David > >
