[matthias.marti]

I try to connect with hibernate to a paradox database through the ODBC-JDBC Bridge. I connected the db successfiully in the DB explorer and generated the hibernate files.
If I run the application (on JBoss 3.0), I get a “net.sf.hibernate.JDBCException: Cannot open connection” error, caused by “[Microsoft][ODBC Paradox Driver] optional feature not implemented”.
With that information, I did a ODBC trace, that showed the following:

crimson.jar -Xd 7a0-824 EXIT SQLSetConnectOption with return code -1 (SQL_ERROR)
HDBC 1E2915E8
SQLINTEGER 102 <SQL_AUTOCOMMIT>
SQLPOINTER 0x00000000

After searching google, I found in the paradox ODBC driver manual, that the autoconnect option has to be true, but I can’t find, where to set that option.

Thx in advance for your help.
Matt

[Riyad Kalla]

Matt, this sounds like a Hibernate issue, unless I’m understanding you wrong?

[Author]

Posts