Re: Specifying default table type - Gabriel Bauman - com.mysql.lists.java

7 messages in com.mysql.lists.javaRe: Specifying default table type

From	Sent On	Attachments
Gabriel Bauman	25 May 2004 11:03
Jeff Mathis	25 May 2004 11:10
Gabriel Bauman	25 May 2004 11:22
Jeff Mathis	25 May 2004 11:27
Mark Matthews	25 May 2004 11:41
Mark Matthews	25 May 2004 11:57
Gabriel Bauman	25 May 2004 12:23

Subject:	Re: Specifying default table type
From:	Gabriel Bauman (ga...@bravenet.com)
Date:	05/25/2004 11:22:46 AM
List:	com.mysql.lists.java

On Tue, 2004-05-25 at 11:10, Jeff Mathis wrote:

my first question would be do you know if your mysql server even supports InnoDB tables? The install probably does, but data and log files need to be created for InnoDB tables, which are separate from MyISAM files. Do you have permission to do this on your install?

Yes. InnoDB tables can indeed be created on my MySQL server. They work correctly when I add "TYPE=InnoDB" to my CREATE TABLE statements. I'm not having trouble setting up InnoDB.

The problem is, my EJB container writes the "CREATE TABLE ..." statements for me, and uses the server default table type, which is MyISAM. The EJB container does not allow me to specify table type. So, I am looking for a way to set the default table type at the Connector/J level. Is that possible?