I have been through tons of threads (and various blogs) on JDBC and cannot figure out my issue.
I am creating a Proxy -> PI 7.0 -> JDBC scenario. The JDBC channel seems to be set up fine, we have the SQL Server drivers set up, we have the firewall configured to allow the call. The SQL Server 2000 database is hosted at a 3rd party.
I have tried both "XML SQL Format" and "Native SQL String" in the IB-Directory message protocol config. I have tried both mapping a SELECT action and a SQL_QUERY action (with SQL code mapped to Access).
There are no errors in SXMB_MONI or the comm channel, but the database provider tells me he does not see PI coming in. When I watch the time stamp in the CC log, it looks to me like the query would be processing (since I can do a larger query and it takes longer to complete).
Here is the CC log.
Time Stamp Status Description
2010-04-09 14:01:22 Success Message successfully received by messaging system. Profile: XI URL: http://xxxxxx:50000/MessagingSystem/receive/AFW/XI Credential (User): PIISUSER
2010-04-09 14:01:22 Success Using connection JDBC_http://sap.com/xi/XI/System. Trying to put the message into the receive queue.
2010-04-09 14:01:22 Success Message successfully put into the queue.
2010-04-09 14:01:22 Success The message was successfully retrieved from the receive queue.
2010-04-09 14:01:22 Success The message status set to DLNG.
2010-04-09 14:01:22 Success Delivering to channel: Bourque_Rateserver_UmlerRailcar_Server_JDBC
2010-04-09 14:01:22 Success MP: Entering module processor
2010-04-09 14:01:22 Success MP: Processing local module localejbs/CallSapAdapter
2010-04-09 14:01:22 Success Receiver JDBC adapter: processing started; QoS required: ExactlyOnce
2010-04-09 14:01:22 Success JDBC adapter receiver channel Bourque_Rateserver_UmlerRailcar_Server_JDBC: processing started; party , service Bourque_Rateserver_BusinessService
2010-04-09 14:01:46 Success Database request processed successfully
2010-04-09 14:01:46 Success MP: Leaving module processor
2010-04-09 14:01:46 Success The message was successfully delivered to the application using connection JDBC_http://sap.com/xi/XI/System.
2010-04-09 14:01:46 Success The message status set to DLVD.
Where else can I check? I am able to connect and query the database using Excel and the Import functionality, so the id/password, etc should be fine.
Thanks in advance!
Keith