This week's book giveaway is in the OO, Patterns, UML and Refactoring forum. We're giving away four copies of Refactoring for Software Design Smells: Managing Technical Debt and have Girish Suryanarayana, Ganesh Samarthyam & Tushar Sharma on-line! See this thread for details.
Dear Friends, I'm trying to setup a MSSQL DataSource in WSAD. I have following settings in server-cfg.xml URL Prefix : jdbc:microsoft:sqlserver://MFXE2KSQL01V:4141;DatabaseName=RiskAppetite;selectMethod=cursor Implementation class name : com.microsoft.jdbcx.sqlserver.SQLServerDataSource And the JAVA code is.. Context ctx = (Context) new InitialContext(); DataSource ds = (DataSource) ctx.lookup("jdbc/RiskAppetite"); Connection con = ds.getConnection("RiskAppetiteAppId", "RiskAppetiteAppId"); I'm able to get a DataSource handle from JNDI. While trying to get a connection, I get a following exception java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC]JTA is not support when selectMethod=direct. Switch to selectMethod=cursor. at com.microsoft.jdbc.base.BaseExceptions.createException(Unknown Source) at com.microsoft.jdbc.base.BaseExceptions.getException(Unknown Source) at com.microsoft.jdbcx.sqlserver.SQLServerDataSource.getXAConnection(Unknown Source) at com.ibm.ejs.cm.pool.JTAConnectionFactory.createConnection(JTAConnectionFactory.java:40) at com.ibm.ejs.cm.pool.ConnectionPool.createConnection(ConnectionPool.java:932) at com.ibm.ejs.cm.pool.ConnectionPool.createOrWaitForConnection(ConnectionPool.java:860)
As you can see in my URL Prefix, I specified "selectMethod=cursor" But for some reason, I'm still getting the above error. Please let me know if anyone has a solution on this. Thanks in advance !! Regards Nilesh
I’ve looked at a lot of different solutions, and in my humble opinion Aspose is the way to go. Here’s the link: http://aspose.com
subject: Am I doing anything wrong while setting up SQLServerDataSource.....