exception running with SQL server 2000

[vivien siu]

hello guys,

I got this exception when I am running my EJB application:

javax.transaction.TransactionRolledbackException: CORBA TRANSACTION_ROLLEDBACK 9998 Maybe; nested exception is: .....

The application is fine, deployable, however while building the deployment it shows this error in the build console:

Error in invokeServer Operation 'setProperty' failed in 'jdbc-connection-pool' Config Mbean.
Target exception message: Property Password can not be removed.

the database I connected to is SQL Server 2000. I'm using the JTDS driver only for this application. And I got a warning while trying to create the CMP entity beans:

driver provided for JDBC datasource : jdbc/jdbc_jtds_sqlserver_localhost_1433_databasename_ejb is not supported for CMP Entity Beans in Sun Java System Application Server 8.1

Can anyone please tell me exactly why am I getting the CORBA Transaction Rolledback exception?

Also if I intend to use SQL Server 2000 in my EJB application, what drivers should I get instead? And what are the steps I should follow to map the driver to NetBeans?

[vivien siu]

erm... I just realised something. Maybe Sun Application Server cannot be used with JTDS driver after all. But I must insist on using free JDBC driver for SQL server 2000. So can I use JDBC-ODBC bridge to connect to sql server instead? Any other tips?