Hi Mike! I'm experiencing the *same behaviour* using ORACLE database caused by the *same reason*. I was planning to post this issue, but you have jumped the queue Mike:)) Anybody know about this bug ? Thx. $kala.
----- Original Message ----- From: "EMike" <[EMAIL PROTECTED]> To: "Jetspeed Users List" <[EMAIL PROTECTED]> Sent: Monday, September 30, 2002 4:12 PM Subject: Re: MySQL : problem removing user > (Suite) > > The problem is that jetspeed tries to remove a user in the TURBINE_USER > table, without removing first the foreign key dependencies in the > TUBINE_USER_GROUP_ROLE table. > > Does Jetspeed rely on a "cascade delete" done by MySQL ? (i don't know if > it's possible and how to configure that) > > Help would be really appreciated ;o) > > Thanks > > Mike > > > > Hi all ! > > (English is not my native language, so please forgive my grammar errors...) > > I just configured Jetspeed to talk MySQL for user authentication, using the > scripts found in the distribution (1.4b1). > I am able to create users via the administrative portlets, i can see them in > the MySQL tables, but i can't delete them... > > In Jetspeed, i got "Database Delete Failure. Please report this error to > your Database Administrator.". > > In the logs, i see : > java.sql.SQLException: General error: Cannot delete a parent row: a foreign > key constraint fails > at org.gjt.mm.mysql.MysqlIO.sendCommand(Unknown Source) > at org.gjt.mm.mysql.MysqlIO.sqlQueryDirect(Unknown Source) > at org.gjt.mm.mysql.Connection.execSQL(Unknown Source) > at org.gjt.mm.mysql.PreparedStatement.executeUpdate(Unknown Source) > at org.gjt.mm.mysql.PreparedStatement.executeUpdate(Unknown Source) > at com.workingdogs.village.Record.saveWithDelete(Unknown Source) > at com.workingdogs.village.Record.save(Unknown Source) > at com.workingdogs.village.Record.save(Unknown Source) > at org.apache.torque.util.BasePeer.doDelete(BasePeer.java:700) > at org.apache.torque.util.BasePeer.doDelete(BasePeer.java:563). > > Is it a MySQL configuration problem ? > Anyone can help ? > > Thanks in advance > > Mike > > > > > > > > > > -- > To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]> > For additional commands, e-mail: <mailto:[EMAIL PROTECTED]> > > -- To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]> For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>
