« Return to Thread: problem with bonita and mysql 5

Re: problem with bonita and mysql 5

by César-16 :: Rate this Message:

Thanks Doug,

I had try with newwer conector mysql-connector-java-5.0.7-bin.jar,
i try reinstall again in windows:

rewrite bonita.properties :
datasource.name            bonita
datasource.url            jdbc:mysql://bbdd:3306/bonita
#datasource.classname        org.gjt.mm.mysql.Driver (i try this too)
datasource.classname        com.mysql.jdbc.Driver
datasource.username ...
datasource.password ...
datasource.mapper         rdb.mysql

rewrite jiap.properties:
datasource.name            jiap
datasource.url            jdbc:mysql://bbdd:3306/jiap
#datasource.classname        org.gjt.mm.mysql.Driver (i try this too)
datasource.classname        com.mysql.jdbc.Driver
datasource.username ...
datasource.password ...datasource.mapper        rdb.mysql

start jonas (to create tables) and run initDb ok

import an xpdl, and the exception persist:
java.lang.Throwable : java.rmi.RemoteException: RuntimeException thrown by an enterprise Bean; nested exception is: javax.ejb.TransactionRolledback

LocalException : Failed to create bean: General error message from server: "Incorrect string value: '\xAC\xED\x00\x05sr...' for column 'possiblevalues' at row 1"

any parameter in mysql to change?
thanks in advance,
César.

On 03/10/2007, Doug.Parisek@... <Doug.Parisek@...> wrote:

César,

I was able to get around this problem by replacing the mysql connector
(that comes with the Workflow installation) with a newer connector.  The
connector name is:

mysql-connector-java-5.0.5-bin.jar

which is contained in the downloadable zip (for Windows in my case):

mysql-connector-java-5.0.5.zip

Place it in the JONAS_BASE/lib/ext folder/directory.

-Doug

             "César"
             <cesar.fg@...
             om>                                                        To
                                       bonita@...
             10/03/2007 12:54                                           cc
             AM
                                                                   Subject
                                       [bonita] problem with bonita and
                                       mysql 5

Hello,

i have working bonita with mysql 4.1 and jdbc driver
mysql-connector-java-3.0.14-production-bin.jar (when i update driver don't
works)
i need to use mysql 5.0.45-community-nt. it's supported?

when i import a xpdl from repository in jiapAdmin:

with drivers mysql-connector-java-3.0.14-production-bin.jar throw:
java.lang.Throwable : java.rmi.RemoteException: RuntimeException thrown by
an enterprise Bean; nested exception is:
javax.ejb.TransactionRolledbackLocalException: Failed to create bean: null,
message from server: "Data too long for column 'anticipable' at row 1"

with dirvers mysql.jar Bonita dristribution throw:
java.lang.Throwable: java.rmi.RemoteException: RuntimeException thrown by
an enterprise Bean; nested exception is:
javax.ejb.TransactionRolledbackLocalException : Failed to create bean:
General error message from server: "Incorrect string value:
'\xAC\xED\x00\x05sr...' for column 'possiblevalues' at row 1"

any idea?

thanks in advance,
   César.
--
You receive this message as a subscriber of the bonita@...
mailing list.
To unsubscribe: mailto:bonita-unsubscribe@...
For general help: mailto:sympa@...?subject=help
ObjectWeb mailing lists service home page: http://www.objectweb.org/wws

--
You receive this message as a subscriber of the bonita@... mailing list.
To unsubscribe: mailto:bonita-unsubscribe@...
For general help: mailto:sympa@...?subject=help
ObjectWeb mailing lists service home page: http://www.objectweb.org/wws

« Return to Thread: problem with bonita and mysql 5