Обсуждение: postgresql 8.4 type mapping problem

Поиск
Список
Период
Сортировка

postgresql 8.4 type mapping problem

От
joiny
Дата:
I defined a filed with "character" type,how to mapping this type to java.
I hava used "char" ,"Character","String","Integer".they are all error.


here is the Exception info
"Caused by: java.lang.IllegalArgumentException: Can't change resolved type
for param: 8 from 1043 to 1042
 at
org.postgresql.core.v3.SimpleParameterList.setResolvedType(SimpleParameterList.java:230)
 at
org.postgresql.core.v3.QueryExecutorImpl.sendOneQuery(QueryExecutorImpl.java:1488)
 at
org.postgresql.core.v3.QueryExecutorImpl.sendQuery(QueryExecutorImpl.java:1062)
 at
org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:255)
 at
org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:479)
 at
org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:367)
 at
org.postgresql.jdbc2.AbstractJdbc2Statement.executeUpdate(AbstractJdbc2Statement.java:321)
 at
org.apache.tomcat.dbcp.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:102)
 at org.apache.commons.dbutils.QueryRunner.update(QueryRunner.java:611)
 at com.spirit.spark.helper.QueryHelper.update(QueryHelper.java:317)
 at com.spirit.spark.models.Users.addUser(Users.java:37)
 at
com.spirit.spark.controllers.SignupController.submit(SignupController.java:60)
 ... 27 more"

--
View this message in context:
http://postgresql.1045698.n5.nabble.com/postgresql-8-4-type-mapping-problem-tp2807499p2807499.html
Sent from the PostgreSQL - jdbc mailing list archive at Nabble.com.

Re: postgresql 8.4 type mapping problem

От
Kris Jurka
Дата:

On Wed, 8 Sep 2010, joiny wrote:

> I defined a filed with "character" type,how to mapping this type to java.
> I hava used "char" ,"Character","String","Integer".they are all error.
>
>
> here is the Exception info
> "Caused by: java.lang.IllegalArgumentException: Can't change resolved type
> for param: 8 from 1043 to 1042
> at
> org.postgresql.core.v3.SimpleParameterList.setResolvedType(SimpleParameterList.java:230)

I believe this has already been fixed.  Please try using a 8.4-702 driver:

http://jdbc.postgresql.org/download.html

Kris Jurka

Re: postgresql 8.4 type mapping problem

От
joiny
Дата:
thank you Kris Jurka.
with your answer , I used the jdbc of 8.4-702 and then resolved this
problem.

--
View this message in context:
http://postgresql.1045698.n5.nabble.com/postgresql-8-4-type-mapping-problem-tp2807499p2826824.html
Sent from the PostgreSQL - jdbc mailing list archive at Nabble.com.