Problem:
<Console encountered the following error java.sql.SQLException: [FMWGEN][SQLServer JDBC Driver][SQLServer]Could not find stored procedure ‘master..xp_jdbc_open2’.
Workaround:
Go to your Data Source configuration on Weblogic Console and change the Driver Class Name to following:
weblogic.jdbc.sqlserver.
These are the drivers for NonXA data source.
However if you want to create an XA connection with MS SQL server then some configuration are required at MS SQL side.
Go to /fmwinfra/oracle_common/modules/datadirect of your weblogic installation directory. Copy these two files instjdbc.sql and x64sqljdbc.dll if you are using 64 bit SQL server otherwise select as per version from the same directory to MS SQL Installation bin directory.
Execute instjdbc.sql in MS SQL server. Now create XA data source in your weblogic server. It should work. If there are multiple SQL servers then you will have to do the same configuration on all SQL servers. Hope this will help.
However if you want to create an XA connection with MS SQL server then some configuration are required at MS SQL side.
Go to /fmwinfra/oracle_common/modules/datadirect of your weblogic installation directory. Copy these two files instjdbc.sql and x64sqljdbc.dll if you are using 64 bit SQL server otherwise select as per version from the same directory to MS SQL Installation bin directory.
Execute instjdbc.sql in MS SQL server. Now create XA data source in your weblogic server. It should work. If there are multiple SQL servers then you will have to do the same configuration on all SQL servers. Hope this will help.
Comments
4 responses to “[SQLServer]Could not find stored procedure ‘master..xp_jdbc_open2’.”
Hi
I am having issues with a ms sql datasource when calling stored procedures. we keep getting JCA-11800. It work when dealing with tables but not with stored procedures. Not sure if you have any ideas.
Thanks
Hi,
Can you please share complete error here?
The error is as follows:-
BINDING.JCA-11800
Unimplemented object conversion.
Conversion of type A whose JDBC type is OTHER to a Java object is not supported.
An attempt was made to convert type A to a Java object using an unsupported JDBC type: OTHER.
Use a data type with a supported JDBC type.
Please check below my post for this
http://technasir.blogspot.ae/2017/05/conversion-of-type-whose-jdbc-type-is.html