on 07-18-2007 10:41 AM
Hi
I am using the JDBC adpapter to call a stored procedure on a SQL database.
In the adapter configuration I am using 'com.microsoft.jdbc.sqlserver.SQLServerDriver' as the JDBC Driver parameter and 'jdbc:microsoft:sqlserver://LIBOEE01:1433;DatabaseName=DEV_OEE;SelectMethod=cursor;' as the connection string.
My payload is as follows:
<?xml version="1.0" encoding="UTF-8" ?>
<root>
<Statement>
<PL101_SAPR3_SKU_OBJ action="EXECUTE">
<p_verb isInput="true" type="varchar">CREATE</p_verb>
<p_site_id isInput="true" type="varchar">GPK</p_site_id>
<p_sap_line_id isInput="true" type="varchar">LN005</p_sap_line_id>
<p_sku_id isInput="true" type="varchar">4014847</p_sku_id>
<p_sku_desc isInput="true" type="varchar">Klipdrift Exp - 12x750ml</p_sku_desc>
<p_bottles_in_sku isInput="true" type="float">12</p_bottles_in_sku>
<p_bps_sap isInput="true" type="float">2.083</p_bps_sap>
</PL101_SAPR3_SKU_OBJ>
</Statement>
</root>
However, when I cal lthe interface I receive the follwoing error in the adapter:
2007-07-18 11:25:03 Error MP: Exception caught with cause com.sap.aii.af.ra.ms.api.RecoverableException: JDBC Adapter configuration not initialized: null
2007-07-18 11:25:03 Error Exception caught by adapter framework: JDBC Adapter configuration not initialized: null
2007-07-18 11:25:03 Error Delivery of the message to the application using connection failed, due to: com.sap.aii.af.ra.ms.api.RecoverableException: JDBC Adapter configuration not initialized: null.
Is this possibly casued by the driver being the incorrect version?
Regards
Michael
Dear Michael,
follow the steps which are mentioned in SIVA MARANANI
stored procedures
<u><b>/people/siva.maranani/blog/2005/05/21/jdbc-stored-procedures by siva
jdbc sender(theory)
/people/saravanakumar.kuppusamy2/blog/2005/01/19/rdbms-system-integration-using-xi-30-jdbc-senderreceiver-adapter
JDBC receiver
/people/bhavesh.kantilal/blog/2006/07/03/jdbc-receiver-adapter--synchronous-select-150-step-by-step
Best Regards,
Srikanth
Reward the useful answers and you will get one point yourself
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Kanth,
Thanks for your response, but the blog by Siva Maranani is actually where I got my code from. Upon further research I think have found the problem as experienced in this blog --> . There are 2 jar files missing from our SQL JDBC driver --> msbase.jar and msutil.jar, I think once I have added these to the driver it might work. Strange that when you download the driver from microsoft's website that these 2 files are only available in the UNIX download though!
Regards
Michael
User | Count |
---|---|
80 | |
24 | |
11 | |
9 | |
7 | |
6 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.