Solution : https://service.sap.com/sap/support/notes/831162 (SAP Service marketplace login required)
Summary :
This SAP Note addresses various issues and configurations related to the SAP XI 3.0 / PI 7.0 / PI 7.1 J2EE JDBC Adapter. It provides a comprehensive FAQ section covering common questions and operational configurations. Key areas detailed in the document include JDBC Driver Deployment, Unicode Handling, Date Field Handling, and Apostrophe Escraping for SQL_QUERY/SQL_DML with Placeholders. Additional content includes handling of transaction processes for both sender and receiver channels, database-specific configurations, and tips for optimizing performance and troubleshooting, such as dealing with various exceptions and errors like SQLExceptions, connection resets, and issues with specific JDBC driver versions. Updates to the information will be made as necessary to address emerging user needs and software compatibility concerns.
Key words :
components bc-xi-con connectivity priority recommendations / additional info category faq validity software componentfrom rel, > <table>realdbtablename< /table> <access> <col1>val1< /col1> <col2>val2< /col2> </access> </dbtablename> </statementname> </root>, 10 support packages & patches support package patchessoftware componentsupport packagepatch levelxi adapter framework 7, deploy external drivers jdbc/jms adapters 941317 xi / pi jdbc adapter, customer component bc-xi-con-jdb jdbc adapter, > n'val2'</col2> </access> </dbtablename> </statementname> </root> 28, books online -> contents -> transact-sql reference -> cast, > <table>realdbtablename< /table> <access> <col1 hasquot=, > n'val1'</col1> <col2 hasquot=, connection reset/error establishing socket/connection reset
Related Notes :
| 1138877 | How to Deploy External Drivers JDBC/JMS Adapters |
| 941317 | XI / PI JDBC Adapter: Known Problems / Incompatibilities |
| 850116 | XI 3.0 / PI 7.0 JDBC Adapter: Type 2 JDBC Driver Deployment |
| 846079 | XI 3.0 JDBC Receiver: # of Retries on SQL Error w/o Effect |
| 841704 | XI File & JDBC Adapter: Operating system command |
| 823809 | XI 3.0 JDBC Adapter: Rollback not performed on DB error |
| 821268 | XI 3.0 / PI 7.0 AF: Overview of available FAQ notes |
| 801367 | XI 3.0 JDBC Adapter: Additional Parameters |
| 1983983 | Using Date functions with SQL Bind Mode |
| 2072891 | How-to use database standard functions in query to database using Receiver Communicaiton Channel |