Fw: JDBC Transactions

2002-05-30 Thread Arul
- Original Message - From: "Luca Lafranchi" <[EMAIL PROTECTED]> To: "Arul" <[EMAIL PROTECTED]> Sent: Thursday, May 30, 2002 5:10 PM Subject: Re: JDBC Transactions > Hi Arul, this is not a direct answer to your question, only a note about > foreig

Re: JDBC Transactions

2002-05-30 Thread Arul
rom: "Mark Matthews" <[EMAIL PROTECTED]> To: "Arul" <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]>; "MySQL" <[EMAIL PROTECTED]> Sent: Thursday, May 30, 2002 4:47 PM Subject: Re: JDBC Transactions > Arul wrote: > > >Hi All, > > &g

Re: JDBC Transactions

2002-05-30 Thread Mark Matthews
Arul wrote: >Hi All, > >We are currently running a website which is running on Weblogic and Oracle >DB.I just thought of porting it to JBoss and MySQL. > >Well..i am not sure how far does MySQL supports Transactions.. >I am currently using 3.23.49 Max on Win 2K. > >Does this version of MySQL Supp

JDBC Transactions

2002-05-30 Thread Arul
Hi All, We are currently running a website which is running on Weblogic and Oracle DB.I just thought of porting it to JBoss and MySQL. Well..i am not sure how far does MySQL supports Transactions.. I am currently using 3.23.49 Max on Win 2K. Does this version of MySQL Supports transaction... -

RE: innodb problem (with JDBC/transactions)

2002-04-24 Thread Jean-Baptiste Gadenne
Hi, We are currently facing the same problem (Deadlock found when trying to get lock; Try restarting transaction) in our production environnement. We are using InnoDB tables (mysqk 3.23.48-max) with Jboss 2.4.4 and JDBC driver mm.mysql-2.0.11-bin.jar / RedHat 7.1. Could you please tell me how to f

RE: innodb problem (with JDBC/transactions)

2001-10-28 Thread Heikki Tuuri
all COMMIT to release the locks. > JDBC Driver: mm.mysql-2.0.6.1.jar > MySQL: mysql-max-3.23.42-win > >Thanks, > >Erik Regards, Heikki http://www.innodb.com >-Original Message- >From: Heikki Tuuri [mailto:[EMAIL PROTECTED]] >Sent: Friday, October 19, 2

RE: innodb problem (with JDBC/transactions)

2001-10-27 Thread Erik
e. PLEASE HELP! JDBC Driver: mm.mysql-2.0.6.1.jar MySQL: mysql-max-3.23.42-win Thanks, Erik -Original Message- From: Heikki Tuuri [mailto:[EMAIL PROTECTED]] Sent: Friday, October 19, 2001 3:11 AM To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Subject: Re: innodb problem (

Re: innodb problem (with JDBC/transactions)

2001-10-19 Thread Heikki Tuuri
Erik, run the MySQL server mysqld from a command prompt and do with the mysql client: mysql>create table innodb_lock_monitor(a int) type = innodb; (assuming you run a recent version). Then mysqld will print lock information to the standard output and you see what is happening. Regards, Heikk

RE: innodb problem (with JDBC/transactions)

2001-10-18 Thread Erik
Has anyone encountered locking problems using JDBC with InnoDB tables and transactions? I am wondering if the MySQL JDBC was designed to handle transactions properly since InnoDB is a relatively recent addition to MySQL. The problem I am running into is the 100 locking error, as if the previ