I am trying to set up existing java application with mysql 5.1.20.
We are using BEA WL 7.0 as application server (provides EJB container - EJB 2.0)
Everything works fine except inserting new records via EJBs.
I can insert new records into db via mysql command line, so it should not be security issue (same credentials used to connect to mysql from command line and in WL).
I tried different mysql jdbc drivers: 3.1.12, 5.0.7 and latest, beta release – 5.1.2.
I am getting same exceptions with all three drivers:
================
<Aug 14, 2007 2:20:12 PM EDT> <Info> <EJB> <010049> <EJB Exception in method: ejbPostCreate: java.lang.Exception: Failed to CREATE Bean. Primary Key Value: 'com.mtrilogix.server.ejb.hierarchy.HierarchyPK@273c92'
java.lang.Exception: Failed to CREATE Bean. Primary Key Value: 'com.mtrilogix.server.ejb.hierarchy.HierarchyPK@273c92'
at com.mtrilogix.server.ejb.hierarchy.HierarchyBean_qy9zs5__WebLogic_CMP_RDBMS.__WL_create(HierarchyBean_qy9zs5__WebLogic_CMP_RDBMS.java:1599)
at com.mtrilogix.server.ejb.hierarchy.HierarchyBean_qy9zs5__WebLogic_CMP_RDBMS.ejbPostCreate(HierarchyBean_qy9zs5__WebLogic_CMP_RDBMS.java:1516)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
....
=================
Note that the system works fine with mysql 5.0 and previous versions.
Any hints would be appreciated.
Thanks, Greg