Re: Cannot invoke commit when AutoCommit mode is set to true



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
jobollin@xxxxxxxxxxx
.



Relevant Pages

  • RE: New JDBC 1.2 driver runs slower than JDBC 1.1; my db definitio
    ... If the support incident ends up verifying a slowdown in the new driver, ... New JDBC 1.2 driver runs slower than JDBC 1.1; ... I do think this would happen in general, not just for my database; ...
    (microsoft.public.sqlserver.jdbcdriver)
  • Re: Problem with JDBC MSSQL
    ... >> JDBC from an applet. ... > classes and you can easily use another persistent storage instead of JDBC. ... > JDBC driver talks to the database. ...
    (comp.lang.java.databases)
  • Re: JDBC URL
    ... within the context of JDBC. ...  That is, when the database, in this case ... in the connection which, if not present, would cause sqlserver to ... buzz on over to Aunt Mathilda's house. ...
    (comp.lang.java.help)
  • Re: JDBC Connection Help
    ... database in VBS. ... I have the correct driver 0jdbc.jar which from what I can tell contains ... trying to establish a JDBC connection. ...
    (microsoft.public.scripting.vbscript)
  • Re: SAP direct JDBC access
    ... > data with JDBC. ... > SQL Server. ... you can use a data source to hide the actual database ... driver used. ...
    (comp.lang.java.programmer)