Обсуждение: java.sql.Types problem
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
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
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