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... :-(

This is a clear break of the JDBC API. Complain to Sybase or use another decent driver (jTDS should work I imagine)

jTDS - what's that? Will that work against a Sybase database? What other driver options do I have against a Sybase database?

Use Google and call Sybase.

I tried jTDS and saw the exact same behavior!

then provide a patch to what you think the getColumns call should do instead