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@levante.de
