Skip to Content.
Sympa Menu

freetds - Bad transaction level

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: "vageesh" <vsetty AT ussearch.com>
  • To: freetds AT franklin.oit.unc.edu
  • Subject: Bad transaction level
  • Date: Thu, 10 Oct 2002 20:02:33 -0400


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=



  • Bad transaction level, vageesh, 10/10/2002

Archive powered by MHonArc 2.6.24.

Top of Page