problem with bonita and mysql 5

[César-16]

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

[dparisek]

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

[César-16]

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

[dparisek]

César,

I have tried using the same configuration as you (5.0.7 jar) and modified
classname parameter but still have no problem.  If I remove the 5.0.7 jar
file with only the original mysql.jar in the ext directory then I too have
the same problem as you do.  Have you removed the original mysql.jar file
from ext altogether ?  I have both jars (old and new) in the ext directory
but somehow jonas is able to recognize the newer files.  If you haven't
done so already, try removing (or renaming) the original mysql.jar file in
the ext dir.

-Doug




                                                                       
             "César"                                                
             <cesar.fg@...                                        
             om>                                                        To
                                       "Doug.Parisek@..."        
             10/03/2007 11:49          <Doug.Parisek@...>        
             PM                                                         cc
                                       bonita@...            
                                                                   Subject
                                       Re: [bonita] problem with bonita
                                       and mysql 5                    
                                                                       
                                                                       
                                                                       
                                                                       
                                                                       
                                                                       




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





--
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

[César-16]

hello, thank you, i reinstall mysql (maybe chage to default charset configuration) ant install new bonita 3.1 and works with mysql 5.

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

César,

I have tried using the same configuration as you (5.0.7 jar) and modified
classname parameter but still have no problem.  If I remove the 5.0.7 jar
file with only the original mysql.jar in the ext directory then I too have
the same problem as you do.  Have you removed the original mysql.jar file
from ext altogether ?  I have both jars (old and new) in the ext directory
but somehow jonas is able to recognize the newer files.  If you haven't
done so already, try removing (or renaming) the original mysql.jar file in
the ext dir.

-Doug





             "César"
             <cesar.fg@...
             om>                                                        To
                                       "Doug.Parisek@..."
             10/03/2007 11:49          < Doug.Parisek@...>
             PM                                                         cc
                                       bonita@...
                                                                   Subject
                                       Re: [bonita] problem with bonita
                                       and mysql 5










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

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