OFBiz › OFBiz - Dev

FW: ERROR sql

_‹ Previous Topic Next Topic _›

Classic

List

Threaded

5 messages Options

Jose Diaz-3

FW: ERROR sql

Please, any idea?

jose
----- Original Message -----
From: Jose Diaz <[hidden email]>
Sent: Sat, 10/20/2007 2:07am
To: [hidden email]
Subject: ERROR sql

Hello:

I am with problems in mysql 5.0.

I can do updates, inserts, selects from the console of mysql
but when I in webtools schedule my service it throws the following error:

SQL Exception occurred on commit (Cannot commit a transactional connection: See JDBC 2.0 Optional Package Specification section 7.1

Please, any idea?

Jose.

Jacques Le Roux

Re: ERROR sql

Administrator

I have any ideas (I mostly use Postgres), but you coud maybe go thru
http://www.nabble.com/forum/Search.jtp?local=y&forum=2740&query=mysql

Jacques

De : "Jose Diaz" <[hidden email]>

> Please, any idea?
>
> jose
> ----- Original Message -----
> From: Jose Diaz <[hidden email]>
> Sent: Sat, 10/20/2007 2:07am
> To: [hidden email]
> Subject: ERROR sql
>
> Hello:
>
> I am with problems in mysql 5.0.
>
> I can do updates, inserts, selects from the console of mysql
> but when I in webtools schedule my service it throws the following error:
>
> SQL Exception occurred on commit (Cannot commit a transactional connection: See JDBC 2.0 Optional Package Specification section

7.1
>
> Please, any idea?
>
> Jose.
>

Jose Diaz-3

RE: ERROR sql

What database error code is customized according to this message:

"SQL Exception occurred on commit (Cannot commit a transactional connection: See JDBC 2.0 Optional Package Specification section
7.1"

We DBA is asking it and no have answers for it issue.

We work with a mysql database (innodb)

Please, I am searching in the Internet but if someone can help us, please let us know your suggestion.

Jose.

----- Original Message -----
From: Jacques Le Roux <[hidden email]>
Sent: Tue, 10/23/2007 11:13am
To: [hidden email]
Subject: Re: ERROR sql

I have any ideas (I mostly use Postgres), but you coud maybe go thru
http://www.nabble.com/forum/Search.jtp?local=y&forum=2740&query=mysql

Jacques

De : "Jose Diaz" <[hidden email]>

7.1
>
> Please, any idea?
>
> Jose.
>

BJ Freeman

Re: ERROR sql

did a google search on
See JDBC 2.0 Optional Package Specification section 7.1
got lots of hits.

My guess is that you don't have the correct driver for the mysql your using.

Jose Diaz sent the following on 10/23/2007 9:51 AM:

> What database error code is customized according to this message:
>
> "SQL Exception occurred on commit (Cannot commit a transactional connection: See JDBC 2.0 Optional Package Specification section
> 7.1"
>
> We DBA is asking it and no have answers for it issue.
>
> We work with a mysql database (innodb)
>
> Please, I am searching in the Internet but if someone can help us, please let us know your suggestion.
>
> Jose.
>
>
>
> ----- Original Message -----
> From: Jacques Le Roux <[hidden email]>
> Sent: Tue, 10/23/2007 11:13am
> To: [hidden email]
> Subject: Re: ERROR sql
>
> I have any ideas (I mostly use Postgres), but you coud maybe go thru
> http://www.nabble.com/forum/Search.jtp?local=y&forum=2740&query=mysql
>
> Jacques
>
> De : "Jose Diaz" <[hidden email]>
>> Please, any idea?
>>
>> jose
>> ----- Original Message -----
>> From: Jose Diaz <[hidden email]>
>> Sent: Sat, 10/20/2007 2:07am
>> To: [hidden email]
>> Subject: ERROR sql
>>
>> Hello:
>>
>> I am with problems in mysql 5.0.
>>
>> I can do updates, inserts, selects from the console of mysql
>> but when I in webtools schedule my service it throws the following error:
>>
>> SQL Exception occurred on commit (Cannot commit a transactional connection: See JDBC 2.0 Optional Package Specification section
> 7.1
>> Please, any idea?
>>
>> Jose.
>>
>
>
>

Jacques Le Roux

Re: ERROR sql

Administrator

BTW this is not the good thread for this type of questions please use rather user ML. You should have much more answers.

http://docs.ofbiz.org/display/OFBADMIN/Mailing+Lists

Jacques

De : "BJ Freeman" <[hidden email]>

> did a google search on
> See JDBC 2.0 Optional Package Specification section 7.1
> got lots of hits.
>
> My guess is that you don't have the correct driver for the mysql your using.
>
>
> Jose Diaz sent the following on 10/23/2007 9:51 AM:
> > What database error code is customized according to this message:
> >
> > "SQL Exception occurred on commit (Cannot commit a transactional connection: See JDBC 2.0 Optional Package Specification section
> > 7.1"
> >
> > We DBA is asking it and no have answers for it issue.
> >
> > We work with a mysql database (innodb)
> >
> > Please, I am searching in the Internet but if someone can help us, please let us know your suggestion.
> >
> > Jose.
> >
> >
> >
> > ----- Original Message -----
> > From: Jacques Le Roux <[hidden email]>
> > Sent: Tue, 10/23/2007 11:13am
> > To: [hidden email]
> > Subject: Re: ERROR sql
> >
> > I have any ideas (I mostly use Postgres), but you coud maybe go thru
> > http://www.nabble.com/forum/Search.jtp?local=y&forum=2740&query=mysql
> >
> > Jacques
> >
> > De : "Jose Diaz" <[hidden email]>
> >> Please, any idea?
> >>
> >> jose
> >> ----- Original Message -----
> >> From: Jose Diaz <[hidden email]>
> >> Sent: Sat, 10/20/2007 2:07am
> >> To: [hidden email]
> >> Subject: ERROR sql
> >>
> >> Hello:
> >>
> >> I am with problems in mysql 5.0.
> >>
> >> I can do updates, inserts, selects from the console of mysql
> >> but when I in webtools schedule my service it throws the following error:
> >>
> >> SQL Exception occurred on commit (Cannot commit a transactional connection: See JDBC 2.0 Optional Package Specification section
> > 7.1
> >> Please, any idea?
> >>
> >> Jose.
> >>
> >
> >
> >
>