pg.ddx.io  pgsql-interfaces@postgresql.org mailing list archive  
help / color / mirror / Atom feed
Re: [INTERFACES] java.sql.Types problem
3+ messages / 3 participants
[nested] [flat]

* Re: [INTERFACES] java.sql.Types problem
@ 1999-09-23 05:07  Jens Glaser <jens@helena.jens.de>
  parent: Tom Jenkins <TomJenkins@zentuit.com>
  1 sibling, 0 replies; 3+ messages in thread

From: Jens Glaser @ 1999-09-23 05:07 UTC (permalink / raw)
  To: Tom Jenkins <TomJenkins@zentuit.com>; +Cc: pgsql-interfaces

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




^ permalink  raw  reply  [nested|flat] 3+ messages in thread

* java.sql.Types problem
@ 1999-09-23 12:22  Tom Jenkins <TomJenkins@zentuit.com>
  0 siblings, 2 replies; 3+ messages in thread

From: Tom Jenkins @ 1999-09-23 12:22 UTC (permalink / raw)
  To: pgsql-interfaces

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



^ permalink  raw  reply  [nested|flat] 3+ messages in thread

* Re: [INTERFACES] java.sql.Types problem
@ 1999-09-25 10:04  Peter Mount <peter@retep.org.uk>
  parent: Tom Jenkins <TomJenkins@zentuit.com>
  1 sibling, 0 replies; 3+ messages in thread

From: Peter Mount @ 1999-09-25 10:04 UTC (permalink / raw)
  To: Tom Jenkins <TomJenkins@zentuit.com>; +Cc: pgsql-interfaces

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/postgres
 Java PDF Generator: http://www.retep.org.uk/pdf




^ permalink  raw  reply  [nested|flat] 3+ messages in thread


end of thread, other threads:[~1999-09-25 10:04 UTC | newest]

Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
1999-09-23 12:22 java.sql.Types problem Tom Jenkins <TomJenkins@zentuit.com>
1999-09-23 05:07 ` Jens Glaser <jens@helena.jens.de>
1999-09-25 10:04 ` Peter Mount <peter@retep.org.uk>

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox