JDBC Driver for Microsoft SQL Server

July 24, 2009 at 8:22 am

[] [] [] [] [] [] [] [] [] [] [] [] [] [] []

Symptom
You want to download and install a current version of the JDBC Driver for Microsoft SQL Server in your SAP system.
Other terms
MSS, MSSQL, Microsoft SQL, MS SQL Server, Java Database Connectivity, JDBC Driver
Reason and Prerequisites
You must regularly update the JDBC Driver for Microsoft SQL Server used in a Java system.
Solution
General Remarks
A branded DataDirect JDBC Driver [...]

Support for CIDX -> JMS & CIDX -> JDBC scenarios

July 10, 2009 at 3:53 am

[] [] [] [] [] [] [] [] []

Symptom
The documentation of the “SAP Business Package for CIDX” (see SAP Service Marketplace, Downloads, Installations and Upgrades->SAP Industry-specific Components->SAP BUSINESS PACKAGE FOR CIDX->SAP BP FOR CIDX 1.0 and directly: http://service.sap.com/~form/sapnet?_SHORTKEY=01100035870000621820& ) specifies the CIDX adapter usage in the Order2Invoice scenario together with the SAP PI IDoc adapter only.
In your business scenarios you [...]

J2EE on Oracle: Updating the JDBC drivers

July 2, 2009 at 7:17 am

[] [] [] [] [] [] [] [] []

Symptom
You want to localize and update the JDBC driver in your Oracle-based J2EE engine system, or:You imported a patch into the Oracle database software on the central instance. However, the system response of the SAP J2EE applications with respect to JDBC has not been changed by this import, in particular possible errors are [...]

Configuring Maximum Message Size Limits for OOM Error

June 30, 2009 at 9:12 am

[] [] [] [] [] [] [] [] [] [] [] [] [] []

Symptom
You notice that the J2EE Engine restarts frequently, due to an Out Of Memory Error(OOM) (i.e., “java.lang.OutOfMemoryError” ). Traces and thread dumps will exhibit, the following error message: “java.lang.OutOfMemoryError. The JVM(Java Virtual Machine) will exit with an exit code of 666″
Other terms
JDBC, JDBC Adapter, OutOfMemoryError, OOM , Message Size Limit, Limit Number of [...]

Configuring timeout for dummy SQL query in advanced mode

June 30, 2009 at 9:09 am

[] [] [] [] [] [] [] [] [] [] [] []

Symptom
You are using JDBC adapter in your scenarios with QoS(Quality of Service) as Synchronous(Best Effort/BE). However, messages report a “MessageExpiredException”.
Other terms
JDBC, JDBC Adapter, Dummy Query, timeout, dummySQLQueryTimeout, timeout, synchronous, best effort
Reason and Prerequisites
Any delay in the response to a blocking synchronous request, results in the above exception. In this case, the delay is [...]

Several open connections noticed in DB2

June 25, 2009 at 3:51 am

[] [] [] [] [] [] [] []

Symptom
During the processing of JDBC receiver communication channels, too many open connections are noticed in the DB2 logs, which in turn lead to performance problems.
Other terms
JDBC, DB2, open connections, JDBC Adapter
Reason and Prerequisites
This issue occured due to a programmatic error.
Solution
The issue has been solved by changes in the code. The archives and the
support package [...]