Solved

JDBC error - Access -Operation invalid on setAutoCommit

Posted on 2000-02-26
2
210 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

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Systems talking to each other 5 126
What is the latest versions eclipse neon 2 140
Error with Java/Cache JDBC Classpath 2 31
backtracking recursion  code 19 54
Are you developing a Java application and want to create Excel Spreadsheets? You have come to the right place, this article will describe how you can create Excel Spreadsheets from a Java Application. For the purposes of this article, I will be u…
Go is an acronym of golang, is a programming language developed Google in 2007. Go is a new language that is mostly in the C family, with significant input from Pascal/Modula/Oberon family. Hence Go arisen as low-level language with fast compilation…
Viewers will learn about the different types of variables in Java and how to declare them. Decide the type of variable desired: Put the keyword corresponding to the type of variable in front of the variable name: Use the equal sign to assign a v…
Viewers will learn about the regular for loop in Java and how to use it. Definition: Break the for loop down into 3 parts: Syntax when using for loops: Example using a for loop:

896 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

18 Experts available now in Live!

Get 1:1 Help Now