Postgres Pro
Downloads
Home   >   mailing lists

Thread: java.sql.Types problem

java.sql.Types problem

From
"Tom Jenkins"
Date:
Howdy,
I'm getting a java.sql.Types value of 16 for varchar field instead of the 12 
I expected.

I'm also getting a 15 for timestamp field instead of 93.

I don't have a clue as to why they are returning those values, does 
anyone have a hint?

Platform: jdk1.1, PostgreSQL 6.5.1

Where can I get the source for the jdbc driver; I seem to only have the 
class files.
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
Tom Jenkins                    DevIS (http://www.devis.com)
python is executable pseudo-code; perl is executable line-noise,
java is, well, java

Re: [INTERFACES] java.sql.Types problem

From
Jens Glaser
Date:
Hi,

On Thu, 23 Sep 1999, Tom Jenkins wrote:
> I'm getting a java.sql.Types value of 16 for varchar field instead of the 12 
> I expected.

which function are you using? getColumnDisplaySize()?

If so, please try the latest JDBC revision. It should return you the
correct values for varchar fields.

> Where can I get the source for the jdbc driver; I seem to only have the 
> class files.

>From the CVS repository. Have a look at the postgresql
website.

regards,

-- 
Jens Glaser     Am Holderstrauch 13, 36041 Fulda, 0661/9429507    jens@jens.de

Re: [INTERFACES] java.sql.Types problem

From
Peter Mount
Date:
On Thu, 23 Sep 1999, Tom Jenkins wrote:

> Howdy,
> I'm getting a java.sql.Types value of 16 for varchar field instead of the 12 
> I expected.

The code returns using the constants defined in the java.sql.Types field.
You should not be using the actual values incase they change in the JDK.

The driver is returning the value java.sql.Types.VARCHAR

> I'm also getting a 15 for timestamp field instead of 93.

The value is not the OID value.

> I don't have a clue as to why they are returning those values, does 
> anyone have a hint?
> 
> Platform: jdk1.1, PostgreSQL 6.5.1
> 
> Where can I get the source for the jdbc driver; I seem to only have the 
> class files.

It's with the postgresql src. The file in question is
src/interfaces/src/jdbc/postgresql/Field.java

I've checked the 6.5.2 version, and it's fine.

Peter

--      Peter T Mount peter@retep.org.uk     Main Homepage: http://www.retep.org.uk
PostgreSQL JDBC Faq: http://www.retep.org.uk/postgresJava PDF Generator: http://www.retep.org.uk/pdf