Solved

invalid transaction state

Posted on 2002-07-12
4
606 Views
Last Modified: 2012-06-27
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
Comment
Question by:DoughBoy
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
4 Comments
 
LVL 92

Expert Comment

by:objects
ID: 7167297
Can you post your code thats making the JDBC call.
0
 

Author Comment

by:DoughBoy
ID: 7169961
Hi All,
I solved thr poblem myself. It had to do with getting rid of the statement to "setAutoCommit(false).
Thanks anyway,
DoughBoy
0
 

Expert Comment

by:modulo
ID: 7592085
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
 

Accepted Solution

by:
modulo earned 0 total points
ID: 7609314
PAQ'd and points refunded.

Please check your other Q's too !

modulo

Community Support Moderator
Experts Exchange
0

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
attribute vs parameter and setter vs add method 17 94
issue with pdf generation 2 96
java operators 3 125
null output 3 42
Enabling the Skype for Business Meeting Scheduler in Hybrid OWA
In Part II of this series, I will discuss how to identify all open instances of Excel and enumerate the workbooks, spreadsheets, and named ranges within each of those instances.
In an interesting question (https://www.experts-exchange.com/questions/29008360/) here at Experts Exchange, a member asked how to split a single image into multiple images. The primary usage for this is to place many photographs on a flatbed scanner…

749 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question