• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 620
  • Last Modified:

invalid transaction state

Hi All,
I am using JDBC in a JSP page to query a MS Access DB.
I get an error:
"sql error in con.close:java.sql.SQLExcelption: [Microsoft][ODBC Microsoft Access Driver]Invalid transaction state"

What does this mean?
And how do I fix this?

TIA DoughBoy

0
DoughBoy
Asked:
DoughBoy
  • 2
1 Solution
 
objectsCommented:
Can you post your code thats making the JDBC call.
0
 
DoughBoyAuthor Commented:
Hi All,
I solved thr poblem myself. It had to do with getting rid of the statement to "setAutoCommit(false).
Thanks anyway,
DoughBoy
0
 
moduloCommented:
Hi DoughBoy,

I see you can have this Q closed, I also see that there are 13 other rather old Q's waiting for an answer.
Can you please check them in your user profile and:
1) Reward an expert that gave the correct answer or
2) Ask with a zero points Q at: http://www.experts-exchange.com/Community_Support/ to finalize Q's like these

I'll check upon your actions after 72 hrs.

modulo

Community Support Moderator
Experts Exchange
0
 
moduloCommented:
PAQ'd and points refunded.

Please check your other Q's too !

modulo

Community Support Moderator
Experts Exchange
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Upgrade your Question Security!

Your question, your audience. Choose who sees your identity—and your question—with question security.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now