13 messages in com.mysql.lists.javaRe: Problem with InnoDB
FromSent OnAttachments
Dorel Vaida02 Dec 2002 02:49 
Luca Lafranchi02 Dec 2002 03:21 
Peter Brawley02 Dec 2002 06:15 
Luca Lafranchi02 Dec 2002 06:41 
Dorel Vaida02 Dec 2002 07:53 
Sean Hager02 Dec 2002 08:38 
A. Berger -- Onlynux02 Dec 2002 11:39 
Andi S. Giri02 Dec 2002 18:16 
Antoni Unkovich02 Dec 2002 18:40 
Mark Matthews02 Dec 2002 19:26 
Peter T. Abplanalp02 Dec 2002 22:29 
Dorel Vaida02 Dec 2002 23:57 
Dorel Vaida03 Dec 2002 07:29 
Subject:Re: Problem with InnoDB
From:Peter Brawley (pete@artfulsoftware.com)
Date:12/02/2002 06:15:41 AM
List:com.mysql.lists.java

Which server are you running? Did you uncomment skip-innodb and other innodb settings in my.ini?

PB

-----

----- Original Message ----- From: "Dorel Vaida" <Dore@ags.ro> To: <ja@lists.mysql.com> Sent: Monday, December 02, 2002 2:50 AM Subject: Problem with InnoDB

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

--------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/doc/ (the manual) http://lists.mysql.com/ (the list archive)

To request this thread, e-mail <java@lists.mysql.com> To unsubscribe, e-mail <java-unsubscribe-peter.brawley=artf@lists.mysql.com>