Could not find stored procedure 'master..xp_jdbc_open2'

If you see the following error while using MS SQL Server data source in WAS the solution is simple:

java.sql.SQLException: [IBM][SQLServer JDBC Driver][SQLServer]Could not find stored procedure 'master..xp_jdbc_open2'.DSRA0010E: SQL State = HY000, Error Code = 2,812

When creating a SQL datasource via the WAS Admin Console, you'll notice that certain custom properties are added 'out of the box'.  Above error will occur when enable2Phase custom property is true. Try changing this property to true in your script or add the property manually via the console.

Another resolution: http://www-01.ibm.com/support/docview.wss?uid=swg21168355

---

This e-mail, including any attachments, may be confidential, privileged or otherwise legally protected. It is intended only for the addressee. If you received this e-mail in error or from someone who was not authorized to send it to you, do not disseminate, copy or otherwise use this e-mail or its attachments. Please notify the sender immediately by reply e-mail and delete the e-mail from your system.

Posted via email from shaker's posterous