Solved

JDBC error - Access -Operation invalid on setAutoCommit

Posted on 2000-02-26
2
209 Views
Last Modified: 2012-05-04
I am using Access (jdbc-odbc bridge) and Oracle (Thin driver) to connect to these databases.

But, at one particular point in my application , when i do :

con.setAutoCommit(false);
where con is an Connection object.

I get the msg :
[Microsoft][ODBC Microsoft Access 97 Driver]Operation invalid at this time.

This happens only when i am connected to Access DB, not when i use Oracle DB connection.

Why is this so ?
0
Comment
Question by:Jitu
2 Comments
 

Accepted Solution

by:
VAlain earned 25 total points
ID: 2561345
Hello,

As far as I know, Access 97, and especially its ODBC drivers, don't know about the concept of "Transactions". That's why the function call returns an error.
0
 
LVL 7

Expert Comment

by:Ravindra76
ID: 2567385

Why won't U ask it in database section?
0

Featured Post

Threat Intelligence Starter Resources

Integrating threat intelligence can be challenging, and not all companies are ready. These resources can help you build awareness and prepare for defense.

Join & Write a Comment

This was posted to the Netbeans forum a Feb, 2010 and I also sent it to Verisign. Who didn't help much in my struggles to get my application signed. ------------------------- Start The idea here is to target your cell phones with the correct…
Basic understanding on "OO- Object Orientation" is needed for designing a logical solution to solve a problem. Basic OOAD is a prerequisite for a coder to ensure that they follow the basic design of OO. This would help developers to understand the b…
Viewers learn about the “while” loop and how to utilize it correctly in Java. Additionally, viewers begin exploring how to include conditional statements within a while loop and avoid an endless loop. Define While Loop: Basic Example: Explanatio…
This tutorial will introduce the viewer to VisualVM for the Java platform application. This video explains an example program and covers the Overview, Monitor, and Heap Dump tabs.

759 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

Need Help in Real-Time?

Connect with top rated Experts

21 Experts available now in Live!

Get 1:1 Help Now