[jboss-user] [jBPM] - [JDBCExceptionReporter] Large Objects may not be used in auto-commit mode.

[nick tan]

nick tan [http://community.jboss.org/people/missedone] created the discussion

"[JDBCExceptionReporter] Large Objects may not be used in auto-commit mode."

To view the discussion, visit: http://community.jboss.org/message/603311#603311

--------------------------------------------------------------
hi, folks

i'm getting an error about "[JDBCExceptionReporter] Large Objects may not be used in auto-commit mode."
when i use postgresql instead of h2

i modified the source code, and configure it with postgresql
things works fine, but when i open  http://localhost:8080/jbpm-console http://localhost:8080/jbpm-console, and click "process -> process overview", no process at all (but in fact, i have uploaded 2 process into guvnor, and build the package, can run with the API)
i went to the terminal and find there is exception: [JDBCExceptionReporter] Large Objects may not be used in auto-commit mode.
(see attached log file for more detail, line: 171)

I googled, and people said “BLOB must be accessed in a transaction when using postgresql”, I’m not really sure how to fix this in jBPM/Drools.

can anyone help? thanks
--------------------------------------------------------------

Reply to this message by going to Community
[http://community.jboss.org/message/603311#603311]

Start a new discussion in jBPM at Community
[http://community.jboss.org/choose-container!input.jspa?contentType=1&containerType=14&container=2034]

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.jboss.org/pipermail/jboss-user/attachments/20110503/7a3ed28f/attachment-0001.html