Bug and Bugfix for the jdbc-driver

In the datamodeller of JBuilder 4, only the systemtables are shown.
The Problem is in the funtion

getTableTypes() in the file
src/interfaces/jdbc/org/postgresql/jdbc2/DatabaseMetaData.java

This function should return a list of TableTypes. But it resturns a list of
6 Identical entries
(SYSTEM INDEX) instead.

I exchanged 2 lines of code to fix the problem. it works fine at my place.

here is the modified funtion:

public java.sql.ResultSet getTableTypes() throws SQLException
{
Field f[] = new Field[1];
Vector v = new Vector();
f[0] = new Field(connection,new String("TABLE_TYPE"),iVarcharOid,32);
for(int i=0;i<getTableTypes.length;i++) {
byte[][] tuple = new byte[1][0];
tuple[0] = getTableTypes[i][0].getBytes();
v.addElement(tuple);
}
return new ResultSet(connection,f,v,"OK",1);
}

The lines
for(int i=0;i<getTableTypes.length;i++) {
byte[][] tuple = new byte[1][0];
are exchanged.

This Fix doesn't solve all problems with JBuilder4.

Gretings

tilo
tilo(at)levante(dot)de