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

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 (view raw or flat)
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

pgsql-jdbc by date

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

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