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
|