Cannot invoke commit when AutoCommit mode is set to true

Discussion in 'Java' started by Maruda, Dec 30, 2005.

  1. Maruda

    Maruda Guest

    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
     
    Maruda, Dec 30, 2005
    #1
    1. Advertising

  2. 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
     
    John C. Bollinger, Dec 31, 2005
    #2
    1. Advertising

Want to reply to this thread or ask your own question?

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads
  1. Chris

    MySql autocommit off?

    Chris, Jul 15, 2003, in forum: Python
    Replies:
    0
    Views:
    990
    Chris
    Jul 15, 2003
  2. Jia Lu
    Replies:
    2
    Views:
    534
    Jia Lu
    Dec 1, 2006
  3. Paul McNett
    Replies:
    1
    Views:
    382
    Gerhard Häring
    Feb 5, 2008
  4. harryos

    how to make autocommit=false

    harryos, Nov 13, 2008, in forum: Java
    Replies:
    2
    Views:
    4,302
    Arne Vajhøj
    Nov 14, 2008
  5. bdb112
    Replies:
    45
    Views:
    1,417
    jazbees
    Apr 29, 2009
Loading...

Share This Page