aspose file tools*
The moose likes EJB and other Java EE Technologies and the fly likes exception running with SQL server 2000 Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Spring in Action this week in the Spring forum!
JavaRanch » Java Forums » Java » EJB and other Java EE Technologies
Bookmark "exception running with SQL server 2000" Watch "exception running with SQL server 2000" New topic
Author

exception running with SQL server 2000

vivien siu
Ranch Hand

Joined: Nov 10, 2005
Posts: 143
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?


I'm not available, my BF's name is WORK.
vivien siu
Ranch Hand

Joined: Nov 10, 2005
Posts: 143
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?
 
It is sorta covered in the JavaRanch Style Guide.
 
subject: exception running with SQL server 2000