Re: Specifying default table type - Jeff Mathis - 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:	Jeff Mathis (jmat...@predict.com)
Date:	05/25/2004 11:10:28 AM
List:	com.mysql.lists.java

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?

jeff Gabriel Bauman wrote:

Hello,

I am deploying an EJB application based using MySQL Connector/J 3.0.11. The database server I will be using has its default table type set to MyISAM. Since my application takes advantage of transactions and foreign key constraints, I need to use the InnoDB storage engine.

Unfortunately, since my tables are auto-created by the EJB container, they end up defaulting to MyISAM. I do not have the option of modifying the server configuration, since other applications depend on the MyIsam being the server default table type. As far as I can see, my EJB container does not allow me to configure table type for CREATE statements, either.

Is there any way to specify default table type as a connection property? http://dev.mysql.com/doc/connector/j/en/index.html#id2801179 doesn't seem to have that option. List archives don't appear to have any solutions to this.

Can anyone help?