Hello guys...
I'm trying to let roller to work on weblogic 10 and I had a lot of issues. 
This is my env configuration:
SO: Windows Vista
AS: Weblogic Server 10.2
JRoller Version: 4.0
DB: Oracle 10  (also tried with mysql 5)
db connection: jdbc (also tried using datasource)

I resolved the 'getRealPath()' problem, that in weblogic is null,
pointing to an external dir where is available the themes folder.
My problem now is with openjpa...I spent a lot of time on a
NoClassDefFoundError
for org.apache.log.LogFactory raised by openjpa..at the end I realized that 
is a classpath issue since also weblogic uses openjpa (1.0.0) and the only 
way to avoid this cp issue is to add commons-logging in the server startup 
classpath (I don't like this solution...but it works).

Now the real problem: I'm able tu create users but every time I try to 
create a new weblog I get this error (this is a stack trace summary): 

ERROR 2008-11-24 11:50:26,538 CreateWeblog:save - ERROR adding weblog
org.apache.roller.weblogger.WebloggerException
        at
org.apache.roller.weblogger.business.jpa.JPAPersistenceStrategy.flush(JPAPersistenceStrategy.java:140)
        at
org.apache.roller.weblogger.business.jpa.JPAWebloggerImpl.flush(JPAWebloggerImpl.java:99)
        at
org.apache.roller.weblogger.ui.struts2.core.CreateWeblog.save(CreateWeblog.java:133)
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
[...........]    
--- ROOT CAUSE ---
<0.9.7-incubating fatal store error>
org.apache.openjpa.persistence.RollbackException: The transaction has been
rolled back.  See the nested exceptions for details on the errors that
occurred.
        at
org.apache.openjpa.persistence.EntityManagerImpl.commit(EntityManagerImpl.java:420)
        at
org.apache.roller.weblogger.business.jpa.JPAPersistenceStrategy.flush(JPAPersistenceStrategy.java:138)
        at
org.apache.roller.weblogger.business.jpa.JPAWebloggerImpl.flush(JPAWebloggerImpl.java:99)
        at
org.apache.roller.weblogger.ui.struts2.core.CreateWeblog.save(CreateWeblog.java:133)
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
[...........]    
Caused by: <0.9.7-incubating 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:2118)
        at org.apache.openjpa.kernel.BrokerImpl.flush(BrokerImpl.java:1965)
        at org.apache.openjpa.kernel.BrokerImpl.flushSafe(BrokerImpl.java:1863)
        at
org.apache.openjpa.kernel.BrokerImpl.beforeCompletion(BrokerImpl.java:1781)
        at
org.apache.openjpa.kernel.LocalManagedRuntime.commit(LocalManagedRuntime.java:80)
        at org.apache.openjpa.kernel.BrokerImpl.commit(BrokerImpl.java:1311)
        at kodo.kernel.KodoBroker.commit(KodoBroker.java:103)
        at
org.apache.openjpa.kernel.DelegatingBroker.commit(DelegatingBroker.java:866)
        at
org.apache.openjpa.persistence.EntityManagerImpl.commit(EntityManagerImpl.java:409)
        ... 162 more
Caused by: <0.9.7-incubating nonfatal general error>
org.apache.openjpa.persistence.PersistenceException: ORA-02291: integrity
constraint (LANABLOG.BM_FOLDERID_FK) violated - parent key not found
 {prepstmnt 20314066 INSERT INTO bookmark (id, description, feedurl, image,
name, priority, url, weight, folderid) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?)
[params=(String) f5779e23-946a-40d4-b895-f1c7697cb0dc, (String) , (null)
null, (null) null, (String) blogs.sun.com, (int) 0, (String)
http://blogs.sun.com, (int) 0, (String)
1cd1dda8-1bfd-485e-a250-c3e21a2c4128] [reused=0]} [code=2291, state=23000]
FailedObject: [{f5779e23-946a-40d4-b895-f1c7697cb0dc, http://blogs.sun.com},
{18155488-9f04-402d-91fe-f15e12ae1812, http://blogs.sun.com/jtb},
{7108d188-66ad-426f-a398-b1496100ffd1, http://rollerweblogger.org/roller},
{12f77cda-ae15-4f79-b57e-5274c8ac50cd, http://torrez.us/},
{8a3681af-bb46-447e-9a54-f1875365b543, http://jroller.com},
{bed79761-bec2-4667-a188-73df4378f485, http://raibledesigns.com/page/rd},
{5ad29b47-391c-4e34-b1b0-af68c88117d9, http://rollerweblogger.org/lance}]
[java.util.LinkedList]
        at
org.apache.openjpa.jdbc.sql.DBDictionary.newStoreException(DBDictionary.java:3782)
        at
org.apache.openjpa.jdbc.sql.SQLExceptions.getStore(SQLExceptions.java:97)
        at
org.apache.openjpa.jdbc.sql.SQLExceptions.getStore(SQLExceptions.java:67)
        at
kodo.jdbc.kernel.BatchingPreparedStatementManager.executeBatch(BatchingPreparedStatementManager.java:304)
[...........]    
Caused by: org.apache.openjpa.lib.jdbc.ReportingSQLException: ORA-02291:
integrity constraint (LANABLOG.BM_FOLDERID_FK) violated - parent key not
found
 {prepstmnt 20314066 INSERT INTO bookmark (id, description, feedurl, image,
name, priority, url, weight, folderid) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?)
[params=(String) f5779e23-946a-40d4-b895-f1c7697cb0dc, (String) , (null)
null, (null) null, (String) blogs.sun.com, (int) 0, (String)
http://blogs.sun.com, (int) 0, (String)
1cd1dda8-1bfd-485e-a250-c3e21a2c4128] [reused=0]} [code=2291, state=23000]
        at
org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator.wrap(LoggingConnectionDecorator.java:191)
        at
org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator.access$800(LoggingConnectionDecorator.java:56)
        at
org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator$LoggingConnection$LoggingPreparedStatement.executeBatch(LoggingConnectionDecorator.java:903)
        at
org.apache.openjpa.lib.jdbc.DelegatingPreparedStatement.executeBatch(DelegatingPreparedStatement.java:244)
        at
org.apache.openjpa.jdbc.kernel.JDBCStoreManager$CancelPreparedStatement.executeBatch(JDBCStoreManager.java:1381)
        at
kodo.jdbc.kernel.BatchingPreparedStatementManager.executeBatch(BatchingPreparedStatementManager.java:237)
        ... 181 more
WARN  2008-11-24 11:50:26,551 LocalizedTextUtil:findText - Trying to find
text with null key!
    
I can't figure out what's appening.........
I attach the full stack trace (
http://www.nabble.com/file/p20658979/FullStackTrace.txt FullStackTrace.txt 
) that is very verbose...

Any suggestion is appreciated.....
I lose my hope...
Thanks 

-- 
View this message in context: 
http://www.nabble.com/OpenJPA---Weblogic-10---Integrity-constraint-error-Creating-a-new-WebLog.-tp20658979s12275p20658979.html
Sent from the Roller - Dev mailing list archive at Nabble.com.

Reply via email to