Hi,

I'm trying to reverse engineer a sybase table. In my reveng.xml, I include only the table name, "hts_sec_master". When I run the ant task, I get this output:
----------------------------------------------------------------------------------------
[hibernatetool] 11:16:32,539 DEBUG JDBCBinder:600 - Adding table org.hibernate.mapping.Table(derivatives.dbo.hts_sec_master) of type TABLE
[hibernatetool] 11:16:32,571 DEBUG JDBCBinder:731 - Finding columns for derivatives.dbo.hts_sec_master
[hibernatetool] 11:16:32,665 DEBUG DriverManagerConnectionProvider:129 - returning connection to pool, pool size: 1

BUILD FAILED
----------------------------------------------------------------------------------------
It fails because it can't read the necessary meta data for the table.

Notice the table name the output shows: "derivatives.dbo.hts_sec_master". But in my reveng.xml file, I had to specify "hts_sec_master".

Do I somehow need to configure the hibernate task to use the relative table names rather than the absolute names in order for it to get meta data on the table? BTW, I'm already looking into possible permission issues, too.

Thanks!
-Edgar

The problem is in the way they Sybase JDBC driver (Jconnect) interprets the null passed into JDBC DatabaseMetaData.getColumns() method. The Hibernate tools JDBCBinder class passes null as the last argument to DatabaseMetaData.getColumns(). Jconnect turns that into an empty string before calling the corresponding Sybase stored proc. This causes the call to fail and no columns to be returned.

I don't know what to do about this situation - probably abandon Hibernate reverse engineering for Sybase... :-(