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, because paradox doesn't support transactions.
Any ideas, how to resolve this problem?
Thx in advance for your help.
Matt
|