SQLX (SQL-XML) Support

2006-07-22 Thread Alain Pannetier
Dear all, I'm migrating a db grom Oracle 9ir2 to mysql 5.0. The data migrates smoothly. Some queries in my Legacy database have been developed using SQLX standard. I do not dare to hope that mySQL will (let alone does) support SQLX. Is there a way to work something out ( a layer on top of Conn

mysql/syslog - 100,000s of log messages on restart

2006-07-22 Thread Adam Rosi-Kessel
I'm running MySQL 4.0.23 on a Debian Sarge system. Often, when I reboot twice in a short time period, MySQL doesn't seem to shut down gracefully -- it takes a long time for it to come up fully, and if I reboot before that, I get a lot of log messages. I think it takes about an hour to come up ful

Re: transaction

2006-07-22 Thread Pooly
Hi, 2006/7/22, João Cândido de Souza Neto <[EMAIL PROTECTED]>: Ok Dan. Thanks a lot for your answer. An other doubt about transaction is in the foreign key case. If in a transaction i insert a certain register and get the last insert id and after i try to insert another register using this id

Re: transaction

2006-07-22 Thread Jo�o C�ndido de Souza Neto
Ok Dan. Thanks a lot for your answer. An other doubt about transaction is in the foreign key case. If in a transaction i insert a certain register and get the last insert id and after i try to insert another register using this id because this table has a foreign key, it gives me a contstraint