-->
These old forums are deprecated now and set to read-only. We are waiting for you on our new forums!
More modern, Discourse-based and with GitHub/Google/Twitter authentication built-in.

All times are UTC - 5 hours [ DST ]



Forum locked This topic is locked, you cannot edit posts or make further replies.  [ 1 post ] 
Author Message
 Post subject: hibernate+jboss+liferay+utf-8
PostPosted: Wed Nov 30, 2005 12:10 pm 
Newbie

Joined: Wed Nov 30, 2005 12:08 pm
Posts: 1
Hi there!
I've been "fighting" with a strange problem for about 5 days now and I can't find the sollution!
The problem is, that wherever I try to put Polish signs in Portal i get a hybernate error:

12:37:03,484 WARN [JDBCExceptionReporter] SQL Error: -99999, SQLState: null
12:37:03,484 ERROR [JDBCExceptionReporter]
12:37:03,484 ERROR [[jsp]] Servlet.service() for servlet jsp threw exception
com.liferay.portal.SystemException: org.hibernate.exception.GenericJDBCException: could not execute query
at com.liferay.portlet.journal.service.persistence.JournalArticlePersistence.findByArticleId(JournalArticlePer...

and so on...lots of errors
Portal in configured to UTF-8, jboss is run with parameter -dFile.encoding=utf-8
Database is created with UTF-8, at least I hope so, in environment I see:CODESET=utf-8, CODEPAGE= -> nothing there.

I used db2-portal.sql script. It had problems filling journalarticle and image but I don't really need this data.
When I enter data to tables using eclipse they are allright, I can even see them in portal, everything is ok.
So liferay successfully reads data form DB2, the problem araises when it tries to insert data to tables.
I get an error, and there appear data in database but not with polish signs, I can see strange signs there like "squares" or sometimes "question marks". When I try to read this data using portlets, e.g. journal I get a message "table_name is temporarily unavailable". I can't even delete these rows using DB2 center, All I can do i so use query delete * from table.
What can cause this situatuion?
Do you need any more specifica data?
I use db2jcc driver with liferay-jdbc - in jdbc.properties it uses "db2=com.ibm.db2.jcc.DB2Driver" entry.
My liferay-ds.xml file looks like this:

<datasources>
<local-tx-datasource>
<jndi-name>jdbc/LiferayPool</jndi-name>
<connection-url>jdbc:db2://localhost:50000/final7</connection-url>
<driver-class>com.liferay.jdbc.LiferayDriver</driver-class>
<user-name>user</user-name>
<password>pass</password>
<min-pool-size>0</min-pool-size>
</local-tx-datasource>
</datasources>

Ps. Everything works fine with unicode when using mysql database, but I need to use db2
Would be very grateful for any ideas.
Thanks
frustrated....Adam M


Top
 Profile  
 
Display posts from previous:  Sort by  
Forum locked This topic is locked, you cannot edit posts or make further replies.  [ 1 post ] 

All times are UTC - 5 hours [ DST ]


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum

Search for:
© Copyright 2014, Red Hat Inc. All rights reserved. JBoss and Hibernate are registered trademarks and servicemarks of Red Hat, Inc.