Problem with JDBC Connection

2006-06-03 Thread VenuGopal Papasani
Hi all, I have got a problem with the jdbc connection while connecting to Mysql.I have written an XML file.The following is the code for giving the database connection com.mysql.jdbc.Driver<\driver> jdbc:mysql:\\localhost\\test<\location> root<\u

Problem with JDBC and Unicode

2004-10-25 Thread Barley
Hi all, I have been struggling to get MySql to accept Unicode characters for a while now with no success. I am attaching a small example program as well as a mySql dump in hopes that someone can help. The expected behavior is that the program should insert a curly quote and a 'one quarter' symbol

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

Re: problem with jdbc

2001-04-09 Thread Sasha Pachev
On Sunday 08 April 2001 12:59, Kamil Yildirim wrote: > --- Sasha Pachev <[EMAIL PROTECTED]> wrote: > > On Saturday 07 April 2001 17:59, Kamil Yildirim > > wrote: > > > Hi > > > > > > I have a problem with SQL UPDATE statement within > > a > > > Java programm which establish a connection to a > >

Re: problem with jdbc

2001-04-07 Thread Sasha Pachev
On Saturday 07 April 2001 17:59, Kamil Yildirim wrote: > Hi > > I have a problem with SQL UPDATE statement within a > Java programm which establish a connection to a Mysql > Server over JDBC. The SQL UPDATE statement looks like > that: UPDATE tableX set x = x + ? where rowx = ? > where the wal

problem with jdbc

2001-04-07 Thread Kamil Yildirim
Hi I have a problem with SQL UPDATE statement within a Java programm which establish a connection to a Mysql Server over JDBC. The SQL UPDATE statement looks like that: UPDATE tableX set x = x + ? where rowx = ? where the walue of ? on the x = x + ? part my some times be - values and some tim