Skip site navigation (1) Skip section navigation (2)

Is a way avoiding the driver crash with unicode data?

From: Vernon <vwu725(at)yahoo(dot)com>
To: pgsql-jdbc(at)postgresql(dot)org
Subject: Is a way avoiding the driver crash with unicode data?
Date: 2005-04-29 05:28:41
Message-ID: 20050429052841.89121.qmail@web40508.mail.yahoo.com (view raw or flat)
Thread:
Lists: pgsql-jdbc
The following exception occures when the select
statement is issued through the Hibernate. The table
contains some unicode data. After I remove one entry
with the data:

&#25830;&#20142;&#30524;&#30555; 
&#21704;&#36798;
&#25289;&#24110;&#32467;&#27966;

No exception occurs. No error message is in the PG log
file. How can I avoid such exception happend again? 



org.springframework.jdbc.UncategorizedSQLException:
(Hibernate operation): encountered SQLException [An
I/O error occured while sending to the backend.];
nested exception is org.postgresql.util.PSQLException:
An I/O error occured while sending to the backend.
org.postgresql.util.PSQLException: An I/O error
occured while sending to the backend.
	at
org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:198)
	at
org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:387)
	at
org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:328)
	at
org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:238)
	at
org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:92)
	at
net.sf.hibernate.impl.BatcherImpl.getResultSet(BatcherImpl.java:88)
	at
net.sf.hibernate.loader.Loader.getResultSet(Loader.java:875)
	at
net.sf.hibernate.loader.Loader.doQuery(Loader.java:269)
	at
net.sf.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:133)
	at
net.sf.hibernate.loader.Loader.doList(Loader.java:1033)
	at
net.sf.hibernate.loader.Loader.list(Loader.java:1024)
	at
net.sf.hibernate.hql.QueryTranslator.list(QueryTranslator.java:854)
	at
net.sf.hibernate.impl.SessionImpl.find(SessionImpl.java:1553)
	at
net.sf.hibernate.impl.QueryImpl.list(QueryImpl.java:39)
	at
org.springframework.orm.hibernate.HibernateTemplate$27.doInHibernate(HibernateTemplate.java:588)
	at
org.springframework.orm.hibernate.HibernateTemplate.execute(HibernateTemplate.java:243)
	at
org.springframework.orm.hibernate.HibernateTemplate.executeFind(HibernateTemplate.java:263)
	at
org.springframework.orm.hibernate.HibernateTemplate.findByNamedParam(HibernateTemplate.java:582)
	at org.springframework.orm.hibernate.HibernateTemplate.findByNamedParam(HibernateTemplate.java:570)

__________________________________________________
Do You Yahoo!?
Tired of spam?  Yahoo! Mail has the best spam protection around 
http://mail.yahoo.com 

Responses

pgsql-jdbc by date

Next:From: Oliver JowettDate: 2005-04-29 05:46:22
Subject: Re: Is a way avoiding the driver crash with unicode data?
Previous:From: Markus SchaberDate: 2005-04-28 17:35:34
Subject: Re: Statement Timeout and Locking

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group