create table setting with ms-sql setting buggy

meyer_michael Jun 2, 2003 4:27 AM

Hi, when using a ms-sql 2k db with Microsofts driver I encounterd that I have incomplete deployments of my Entities when JBoss should create tables that already exists.

I changed the db to Postgres or my-sql everything and everything works fine. I just see a warning in the log that the table does already exists.

The incomplete deployments results in a half usable Entity. I can create and delete Entities. But the custom finder methods are not available.

Solutions for the moment:
1.) drop all tables
2.) or better: <create-table>false</create-table>

Different database behaviors make me worry a bit.

Michael.

1. Re: create table setting with ms-sql setting buggy

juhalindfors Jun 3, 2003 5:51 AM (in response to meyer_michael)

Try a production quality drivers for your MS SQL server, the ones Microsoft provides are not very reliable.
Actions
2. Re: create table setting with ms-sql setting buggy

kanagawa Jun 13, 2003 1:44 PM (in response to meyer_michael)

Do you have any suggestions as to which drivers are production quality and where they can be obtained?
Actions
3. Re: create table setting with ms-sql setting buggy

kanagawa Jun 14, 2003 2:21 PM (in response to meyer_michael)

On your recommendation, I downloaded the data direct drivers and tried them -- same problem. I'm not 100% sure these drivers are any different from the Microsoft drivers, though. I seem to recall MS's free drivers were OEM from some other company. It may be something about my application, however. I have another application that deploys into a jboss 3.2.0 container with no problems.
Actions

Go to original post