You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@roller.apache.org by markomega <m....@gmail.com> on 2008/11/24 12:22:37 UTC

OpenJPA - Weblogic 10 - Integrity constraint error Creating a new WebLog.

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.


Problems with UTF-8 encoding in Glassfish

Posted by Kristoffer Larsson <we...@kristoffer.nu>.
Ever since I deployed Roller on Glassfish/SJAS 9.1, I've had problems with
UTF-8 URIEncoding. If I write a blog entry which have special characters in
the title, I get a 404 when I try to access that entry later on. It shows up
on the main page, but you cannot access it directly.

Example:

http://www.kristoffer.nu/blogg/kristoffer/entry/milj%C3%B6medvetenhet_in_abs
urdum

I have tried lots of things, like this thread:

http://forums.java.net/jive/message.jspa?messageID=264027

But to no avail. Is there something wrong with Roller? I use version 4.0.

Kristoffer




Re: OpenJPA - Weblogic 10 - Integrity constraint error Creating a new WebLog.

Posted by markomega <m....@gmail.com>.
After a number of tries I realized that I'm not able to find the cause of
this problem 
on weblogic..and without the cause I can't find a solution...
So I found a workaround to it...that is just to customize the
 'newuser.blogroll' property in roller-custom.properties and left it blank
That property contains the 'list of links to include in root bookmark folder
of each new blog'

This solution avoids the creation bookmark list at weblog creation time.
The bookmarks can be however added via weblog settings page.
-- 
View this message in context: http://www.nabble.com/OpenJPA---Weblogic-10---Integrity-constraint-error-Creating-a-new-WebLog.-tp20658979s12275p20704667.html
Sent from the Roller - Dev mailing list archive at Nabble.com.