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

Re: strange jdbc problem moving to 8.1 database

From: kevin(at)mtel(dot)co(dot)uk
To: pgsql-jdbc(at)postgresql(dot)org
Subject: Re: strange jdbc problem moving to 8.1 database
Date: 2005-11-12 11:56:03
Message-ID: 1131796562.971303.100990@z14g2000cwz.googlegroups.com (view raw or flat)
Thread:
Lists: pgsql-jdbc
duhh,
sorry guys.

This one took me a long time to find. I changed the original table that
supplies these fields from char(10) to char varying (10) in the test
system and have made a demo area from the live system still with the
char(10) fields.
the data is actually
'ADMIN     ' not
'ADMIN'
simply dump to sql, alter tabledef to varying, reload and to set field
= trim(field)

noooow it works.
thanks to Kris Jurka


In response to

pgsql-jdbc by date

Next:From: Assad JarrahianDate: 2005-11-12 17:21:32
Subject: passing array as parameters to PrepareStatement or callable statement.[setObject() or setArray()]
Previous:From: kevinDate: 2005-11-12 10:47:21
Subject: Re: strange jdbc problem moving to 8.1 database

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