Win a copy of The Little Book of Impediments (e-book only) this week in the Agile and Other Processes forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

How can i close a connection to Access97?

 
Janine Guenther
Greenhorn
Posts: 3
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
hello,
i think, i have a smal problem, but i can't see the solution.
i created a connection to access97, i can read the datas in the tables, but the connection doesn't close.

in line connection.close(); access is sending an error: "[Microsoft][ODBC Microsoft Access 97 -Treiber]Ung´┐Żltiger Transaktions-Zustand." (invalid transaction condition)
have i forgotten something?
regards,
janine
[ Edited by Dave to format code and remove smilies ]
[ January 08, 2003: Message edited by: David O'Meara ]
 
Younes Essouabni
Ranch Hand
Posts: 479
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hello,
just a suggestion, you set Autocommit to false, maybe you inserted something and forgot to commit?
Try to remove the setAutocommit(false) since it seems that you are only reading data, or try to commit
I hope it helps
 
David O'Meara
Rancher
Posts: 13459
Android Eclipse IDE Ubuntu
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
"Janine",
The Java Ranch has thousands of visitors every week, many with surprisingly similar names. To avoid confusion we have a naming convention, described at http://www.javaranch.com/name.jsp.
We require names to have at least two words, separated by a space, and strongly recommend that you use your full real name. Please edit your profile and select a new name which meets the requirements.
Thanks.
Dave
 
Janine Guenther
Greenhorn
Posts: 3
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Thanks, it was the autocommit
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic