postgresql 8.4 type mapping problem

From: joiny <jbakwd(at)gmail(dot)com>
To: pgsql-jdbc(at)postgresql(dot)org
Subject: postgresql 8.4 type mapping problem
Date: 2010-09-08 08:03:30
Message-ID: 1283933010011-2807499.post@n5.nabble.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-jdbc


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.

Responses

Browse pgsql-jdbc by date

  From Date Subject
Next Message Kris Jurka 2010-09-08 09:10:41 Re: JDBC driver method setClob always uses getAsciiStream()
Previous Message Jochen Terstiege 2010-09-07 15:31:49 JDBC driver method setClob always uses getAsciiStream()