Creating Tables in InnoDB and non MyISAM

Asked By briannacortez 0 points N/A Posted on - 10/26/2011

I want to make tables in InnoDB and non MyISAM. I generally prefer using InnoDB so I don’t have to worry on recovering my tables when it crash or the statements that are partially executed.

I have CMP (Container Managed Persistence) enterprise bean in which my JBoss AS application server can create tables. 

I want to know how I can redirect JBoss in creating tables with ENGINE=InnoDB. Can you help me?

• Status: Open
• Question Views: 787
• Answer Count: 1
• Vote Up 0 Vote Down

• Answer Accepted: No
• Question Category: MS SQL Server

Answered By Michelle Bang 55 points N/A #96633

Creating Tables in InnoDB and non MyISAM

There is a lot of mess doing this because the jboss features are quite different from the innodb application. You need to be more reliable on the innodb instead of jboss.

Because i have performed some tests and i have found a problem. It is in-fact seem that the table names are being refused that have underscore in their name after the first one.

This is a major drawback that is withholding you and me not to use it.

However there is a chance that if you use an intermediate software to link the two then you can achieve your purpose of connecting both.

I would prefer you not to do this but if you want to do it then install the addons for both components and then integrate it.

About Michelle Bang

Questions
2

Answers
515

Best Answers
73

• Vote Up 0 Vote Down

• Posted on - 02/12/2012
• Question Category: MS SQL Server