FreeTDS Development Group

["vageesh" <vsetty AT ussearch.com>]

I see bad error message "Bad transaction level" either as warning or error
when I try to get a connection or list the SQLServer (2000/7.0) tables.

SQLException "Bad transaction level" is thrown at
com.internetcds.jdbc.tds.Connection_base.sqlStatementToSetTransactionIsolationLevel(Connection_base.java:244)
when the transaction level is TRANSACTION_NONE. Can I take out the check
for TRANSACTION_NONE case in Connection_base.. I don't know the
implications of this...

Thanks in advance for any help

 24416:37:56 [INFO] WARNING: Failed to set 'TransactionIsolation' for cfc:
16:37:56 [INFO]    Bad transaction level
16:53:26 [INFO] cfc
16:53:35 [INFO] Connecting: cfc
16:53:35 [INFO] Load driver using CLASSPATH:
com.internetcds.jdbc.tds.Driver
java.sql.SQLException: Bad transaction level
        at
com.internetcds.jdbc.tds.Connection_base.sqlStatementToSetTransactionIsolationLevel(Connection_base.java:244)

        at
com.internetcds.jdbc.tds.Connection_base.setTransactionIsolation(Connection_base.java:892)

        at se.pureit.dbvis.Database.setTransactionIsolation(Database.java:891)
        at se.pureit.dbvis.Database.doConnect(Database.java:191)
        at se.pureit.dbvis.Database.access$000(Database.java:35)
        at 
se.pureit.dbvis.Database$ConnectionCommand.execute(Database.java:1038)
        at se.pureit.util.ThreadCommand.runExecute(Unknown Source)
        at se.pureit.util.ThreadCommand.run(Unknown Source)
        at java.lang.Thread.run(Unknown Source)
DriverManager.getConnection("jdbc:freetds://ussearch.accuan.com:50001/TU;TDS=7.0")

    trying
driver[className=com.internetcds.jdbc.tds.Driver,com.internetcds.jdbc.tds.Driver@bb9829]


getConnection returning
driver[className=com.internetcds.jdbc.tds.Driver,com.internetcds.jdbc.tds.Driver@bb9829]

16:53:35 [INFO] WARNING: Failed to set 'TransactionIsolation' for cfc:
16:53:35 [INFO]    Bad transaction level
16:53:50 [DEBUG] Db=cfc Cat=null Sch=null Tab=null TableTypes=