Hi, Everyone.
I got two problems.
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
