Re: getColumns()

Hi Dave,

As far as you known it works? Sounds good!

BTW, I'm using Postgresql 7.1.3 and the 'incriminated' code is:

####### Code example ########
...
private DatabaseMetaData dma;
private Connection dbCon;
...
/**
the schema is set to "%"
*/
public void setSchema(String schema) {
this.schema = schema;
}
/**
* This function is used to get the current used schema name to
perform table and fields checks in the right schema.
private String getSchema() {
return schema;
}

private String getCatalog() throws SQLException {
String catalog = dbCon.getCatalog();
if (catalog != null && catalog.length() == 0) {
catalog = null;
}
return catalog;
}
...
public int getFieldSize(String tableName, String fieldName, String
schema) throws BDEException {
int ret = -1;
try {
//->>>>>>>>>>>>the following returns no rows!
ResultSet rs = dma.getColumns(getCatalog(),
getSchema(), tableName.toUpperCase(),
fieldName.toUpperCase());

rs.next();
//So this throws an exception...
ret = rs.getInt("COLUMN_SIZE");
} catch (Exception e) {
trace.fail(e);
}
//...and this returns null
return ret;
}
############# EO Code sample ############

TIA, Auri

On 3 Apr 2002, Dave Cramer wrote:

> Auri,
>
> AFAIK this works, can you give me specifics?
>
> ie db version, columns, code sample, etc.
>
> Dave