Cannot invoke commit when AutoCommit mode is set to true

[Maruda]

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?

 

[John C. Bollinger]

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.