Problem with InnoDB - Dorel Vaida - com.mysql.lists.java

13 messages in com.mysql.lists.javaProblem with InnoDB

From	Sent On	Attachments
Dorel Vaida	02 Dec 2002 02:49
Luca Lafranchi	02 Dec 2002 03:21
Peter Brawley	02 Dec 2002 06:15
Luca Lafranchi	02 Dec 2002 06:41
Dorel Vaida	02 Dec 2002 07:53
Sean Hager	02 Dec 2002 08:38
A. Berger -- Onlynux	02 Dec 2002 11:39
Andi S. Giri	02 Dec 2002 18:16
Antoni Unkovich	02 Dec 2002 18:40
Mark Matthews	02 Dec 2002 19:26
Peter T. Abplanalp	02 Dec 2002 22:29
Dorel Vaida	02 Dec 2002 23:57
Dorel Vaida	03 Dec 2002 07:29

Subject:	Problem with InnoDB
From:	Dorel Vaida (Dore...@ags.ro)
Date:	12/02/2002 02:49:59 AM
List:	com.mysql.lists.java

Hi all

This might be annoying because I suppose lots of you have passed this problem but ... I have to ask, I tried all that I know of.

I cannot create a InnoDB table . I'm using MySQL 4.0.5 (testin it hard) on win XP with Java, MySQL Connector J/2.0.14 and all goes well with BDB. It creates it, commits/rollback all stuff. but when I try to create InnoDB the table is silently turned into MyISAM. Please, at least, point me to the right doc so I can figure out on my own what's happening ...

I use the following code (Java)

stmt.execute("CREATE TABLE IF NOT EXISTS trades_active (" + "id INTEGER(11) PRIMARY KEY NOT NULL auto_increment," + "tradeType INTEGER(11) NOT NULL," + "sellerId INTEGER(11) NOT NULL," + "buyerId INTEGER(11) NOT NULL," + "prodId INTEGER(11) NOT NULL," + ")TYPE=InnoDB;");

It work well if I replace InnoDB with BDB

thanks in advance