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
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 |