hi, i want to delete a task instance from my database (mysql).

this is my source code:

| Connection connection=jbpmContext.getConnection();
|      Statement statement=connection.createStatement();
|      
| //      ??criture de la requ??te de recherche
|      request="DELETE "
|        + "FROM jbpm_taskinstance "
|        + "WHERE id_='"
|        + taskInstanceId + "'";
|      
| //      execution de la requ??te
|      statement.execute(request);
|      
| //      fermeture de la connection ?? la base de donn??es
|      statement.close();
|      connection.close();
|      
|

but i doesn't work because, i think it doesn't execute query :

| statement.execute(request);
|
i tried statement.executeUpDate(request);
but i have the same error:


|
| com.mysql.jdbc.exceptions.MySQLIntegrityConstraintViolationException: Cannot delete or update a parent row: a foreign key constraint fails (`paolo/jbpm_log`, CONSTRAINT `FK_LOG_TASKINST` FOREIGN KEY (`TASKINSTANCE_`) REFERENCES `jbpm_taskinstance` (`ID_`))
|  at com.mysql.jdbc.SQLError.createSQLException (SQLError.java:931)
|  at com.mysql.jdbc.MysqlIO.checkErrorPacket (MysqlIO.java:2934)
|  at com.mysql.jdbc.MysqlIO.sendCommand (MysqlIO.java:1616)
|  at com.mysql.jdbc.MysqlIO.sqlQueryDirect (MysqlIO.java:1708)
|  at com.mysql.jdbc.Connection.execSQL (Connection.java:3249)
|  at com.mysql.jdbc.Connection.execSQL (Connection.java:3178)
|  at com.mysql.jdbc.Statement.execute (Statement.java:711)
|  at BesoinJBpm.deleteTaskInstance(BesoinJBpm.java:361)
|  at BesoinJBpm.Test(BesoinJBpm.java:55)
|  at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
|  at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
|  at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
|  at java.lang.reflect.Method.invoke(Unknown Source)
|  at junit.framework.TestCase.runTest (TestCase.java:154)
|  at junit.framework.TestCase.runBare (TestCase.java:127)
|  at junit.framework.TestResult$1.protect(TestResult.java:106)
|  at junit.framework.TestResult.runProtected (TestResult.java:124)
|  at junit.framework.TestResult.run (TestResult.java:109)
|  at junit.framework.TestCase.run (TestCase.java:118)
|  at org.eclipse.jdt.internal.junit.runner.junit3.JUnit3TestReference.run(JUnit3TestReference.java:128)
|  at org.eclipse.jdt.internal.junit.runner.TestExecution.run(TestExecution.java:38)
|  at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.runTests (RemoteTestRunner.java:460)
|  at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.runTests (RemoteTestRunner.java:673)
|  at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.run (RemoteTestRunner.java:386)
|  at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.main (RemoteTestRunner.java:196)
|
|

how can i delete this ?

View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=4071667#4071667

Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=4071667

_______________________________________________
jboss-user mailing list
jboss-user@(protected)
https://lists.jboss.org/mailman/listinfo/jboss-user