ResultSetMetaData problems (getColumnType() and -TypeName)

From: Þórhallur Hálfdánarson <tolli(at)margmidlun(dot)is>
To: "'pgsql-interfaces(at)postgresql(dot)org'" <pgsql-interfaces(at)postgresql(dot)org>
Subject: ResultSetMetaData problems (getColumnType() and -TypeName)
Date: 2000-07-18 16:21:29
Message-ID: B0D96BEDD558D411ACB200105AD7EAE90A8805@GEMINI
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-interfaces

Hi

I've seen some postings on this subject since ages ago. The code and the
output pretty much says what there has to be said (there was as example
similar to this code somewhere). Sorry for the Icelandic, though. :-)

<code>
int iFjoldi = rsmd.getColumnCount();
System.out.println("Fjöldi dálka í töflunni sjálfri: "+ iFjoldi);
for (int i=1; i <= iFjoldi; i++)
{
System.out.println("Dálkur "+ i);
try
{
rsmd = rs.getMetaData();
System.out.println("Dálkur "+ i +": "+
rsmd.getColumnType(i));
System.out.println("Dálkur "+ i +": "+
rsmd.getColumnTypeName(i));
System.out.println("Ég er gimp");
}
catch (SQLException e)
{
System.out.println("Fönky SQL Exception: "+ e.toString());
}
catch (Exception e)
{
System.out.println("Fönky Exception: "+ e.toString());
e.printStackTrace();
}
}
</code>

<output>
Fjöldi dálka í töflunni sjálfri: 4
Dálkur 1
Fönky Exception: java.lang.NullPointerException:
java.lang.NullPointerException:
at org.postgresql.Connection.ExecSQL(Connection.java:312)
at org.postgresql.Field.getSQLType(Field.java:79)
at
org.postgresql.jdbc2.ResultSetMetaData.getColumnType(ResultSetMetaData.java:
363)
at com.margmidlun.LIN.Upplysingakerfi.Importer.go(Importer.java:132)
at Gagnagaur.main(Gagnagaur.java:13)
Dálkur 2
Fönky Exception: java.lang.NullPointerException:
java.lang.NullPointerException:
at org.postgresql.Connection.ExecSQL(Connection.java:312)
at org.postgresql.Field.getSQLType(Field.java:79)
at
org.postgresql.jdbc2.ResultSetMetaData.getColumnType(ResultSetMetaData.java:
363)
at com.margmidlun.LIN.Upplysingakerfi.Importer.go(Importer.java:132)
at Gagnagaur.main(Gagnagaur.java:13)
Dálkur 3
Fönky Exception: java.lang.NullPointerException:
java.lang.NullPointerException:
at org.postgresql.Connection.ExecSQL(Connection.java:312)
at org.postgresql.Field.getSQLType(Field.java:79)
at
org.postgresql.jdbc2.ResultSetMetaData.getColumnType(ResultSetMetaData.java:
363)
at com.margmidlun.LIN.Upplysingakerfi.Importer.go(Importer.java:132)
at Gagnagaur.main(Gagnagaur.java:13)
Dálkur 4
Fönky Exception: java.lang.NullPointerException:
java.lang.NullPointerException:
at org.postgresql.Connection.ExecSQL(Connection.java:312)
at org.postgresql.Field.getSQLType(Field.java:79)
at
org.postgresql.jdbc2.ResultSetMetaData.getColumnType(ResultSetMetaData.java:
363)
at com.margmidlun.LIN.Upplysingakerfi.Importer.go(Importer.java:132)
at Gagnagaur.main(Gagnagaur.java:13)
</output>

The same has shown up on setups:
Setup A)
Machine S)
RedHat Linux 6.0
PostgreSQL 6.5.1 (with JDBC, other stuff working fine)
Machine J)
RedHat Linux 6.1
Sun JDK:
java version "1.2.2"
Classic VM (build 1.2.2-L, green threads, nojit)
jdbc6.5-1.2.jar

Setup B)
Machine T)
RedHat Linux 6.2
PostgreSQL 7.0.2
$ rpm -qa |grep postgres
postgresql-jdbc-7.0.2-2
postgresql-odbc-7.0.2-2
postgresql-7.0.2-2
postgresql-server-7.0.2-2
postgresql-devel-7.0.2-2
Sun JDK

Now.... do you have any tips ?

Regards,
Tolli
tolli(at)margmidlun(dot)is

Browse pgsql-interfaces by date

  From Date Subject
Next Message John Thorhauer 2000-07-18 18:36:32 jdbc how to get SERIAL
Previous Message Karel Zak 2000-07-18 10:16:18 Re: PostgreSQL & Visual Basic