Postgres Pro
Downloads
Home   >   mailing lists

JDBC & custom type of variable types (!) - Mailing list pgsql-jdbc

From Marc Mamin
Subject JDBC & custom type of variable types (!)
Date
Msg-id B6F6FD62F2624C4C9916AC0175D56D880CE4B473@jenmbs01.ad.intershop.net
Whole thread Raw
Responses Re: JDBC & custom type of variable types (!)  (Dave Cramer <pg@fastcrypt.com>)
Re: JDBC & custom type of variable types (!)  (David Johnston <polobo@yahoo.com>)
List pgsql-jdbc
Tree view
Hello,
 
I'd like to retrieve a custom type from a result set,
but problem: I don't know exactly the structure.
It may be float/text or int/text, so I'd need to map it to one of those java custom types:
 
   deciType <Double,String>;
   intType  <Long, String>;
 
 
Can I rely on a ClassCastException  as below to find the correct matching?
even when the custom type has NULL(s) in it ?
 
Or is there a better approach ?
 
case Types.STRUCT:
 
            try
            {
                foo = (intType)resultset1.getObject(1);
            }
            catch (ClassCastException e)
            {
                blah = (deciType)resultset1.getObject(1);
            }
 
(Postgres 9.3 , JDBC4 Postgresql Driver, Version 9.3-1100)
 
many thanks,
 
Marc Mamin
 

pgsql-jdbc by date:

Previous
From: Dave Cramer
Date:
Subject: Re: DatabaseMetaData - schemaPattern
Next
From: Dave Cramer
Date:
Subject: Re: JDBC & custom type of variable types (!)