Thread: postgresql 8.4 type mapping problem
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.
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
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.