Velocity Reviews - Computer Hardware Reviews

Velocity Reviews > Newsgroups > Programming > Java > Cannot invoke commit when AutoCommit mode is set to true

Reply
Thread Tools

Cannot invoke commit when AutoCommit mode is set to true

 
 
Maruda
Guest
Posts: n/a
 
      12-30-2005
Hi,

I have a problem connecting WebSphere Rational Application
Developer through the Microsoft newest JDBC driver to
SQLServer Express 2005.

I'd like to use the database meta data while working
on the project in the Developer.

The connection is established but then I get the
error.

JDBC Catalog Loader
Problems encountered while importing from catalog.
Reason:
One or more problems were reported while accessing
the database.
Problem reading database ...
Cannot invoke commit when AutoCommit mode is set to true.

And no metadata is imported.
Does someone know how to avoid this problem?

--
Thnx,
Maruda
--
Pozdrawiam,
Maruda
 
Reply With Quote
 
 
 
 
John C. Bollinger
Guest
Posts: n/a
 
      12-31-2005
Maruda wrote:
> Hi,
>
> I have a problem connecting WebSphere Rational Application
> Developer through the Microsoft newest JDBC driver to
> SQLServer Express 2005.
>
> I'd like to use the database meta data while working
> on the project in the Developer.
>
> The connection is established but then I get the
> error.
>
> JDBC Catalog Loader
> Problems encountered while importing from catalog.
> Reason:
> One or more problems were reported while accessing
> the database.
> Problem reading database ...
> Cannot invoke commit when AutoCommit mode is set to true.
>
> And no metadata is imported.
> Does someone know how to avoid this problem?


Did this ever work for you? With an earlier driver, for instance? If
so, then the quickest thing to do would be to revert to a configuration
that is known to work. If not, then you could still try different JDBC
drivers (don't neglect the possibility of third-party drivers) on the
theory that the driver is buggy. You might want to test that theory by
writing a little program that opens a connection to the DB via the
driver you're using, and then invokes getMetadata() on it.

If you do determine that the driver is buggy then it is probably
worthwhile to send a bug report to Redmond. Don't expect a fix any time
soon, though.

--
John Bollinger
http://www.velocityreviews.com/forums/(E-Mail Removed)
 
Reply With Quote
 
 
 
Reply

Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
[False,True] and [True,True] --> [True, True]????? bdb112 Python 45 04-29-2009 02:35 AM
how to make autocommit=false harryos Java 2 11-14-2008 02:19 AM
Re: Pysqlite issue no attribute 'autocommit' Paul McNett Python 1 02-05-2008 03:30 PM
How to turn AUTOCOMMIT ON with cx_Oracle Jia Lu Python 2 12-01-2006 09:41 AM
MySql autocommit off? Chris Python 0 07-15-2003 02:20 PM



Advertisments