Frequently asked questions (FAQs) for WebSphere Adapter for JDBC (updated October 25, 2010)

Technote (FAQ)


Question

What are the frequently asked questions for WebSphere Adapter for JDBC?

Answer

This is a technote which summarizes frequently asked questions for WebSphere Adapter for JDBC and will be refreshed every two months. The last update is 2 June 2010.

General Questions:

title keywords technote link
MustGather: Read first for WebSphere Adapters and WebSphere Business Integration Adapters mustgather materials.trace and log. http://www.ibm.com/support/docview.wss?uid=swg21240322
Supported software for IBM WebSphere Adapters and IBM WebSphere Business Integration Adapters required software an hardware http://www.ibm.com/support/docview.wss?uid=swg27006249
Adapter support site support site http://www.ibm.com/software/integration/wbiadapters/support/
Recommended fixes for WebSphere Adapters recommended fixes http://www.ibm.com/support/docview.wss?uid=swg27010397
How to submit and track new product requirements or enhancements for IBM WebSphere Adapters new requirements or enhancements http://www.ibm.com/support/docview.wss?uid=swg21386764
Compatibility Matrix: WebSphere Business Integration Adapters and WebSphere Adapters (JCA) supported releases and their corresponding compatible products. http://www.ibm.com/support/docview.wss?uid=swg21252626
Installing Adapter Fixes on WebSphere Process Server, WebSphere Application Server, WebSphere Integration Developer and WebSphere Message Broker/ -Toolkit upgrade or install adapter.install Ifix, upgrade, AFC jars update. deployment. migration. http://www.ibm.com/support/docview.wss?uid=swg21407128
Frequently asked questions specific to database server or JDBC driver problem specific to databases http://www.ibm.com/support/docview.wss?uid=swg21399321
Business Process Management Samples & Tutorials Samples , Tutorials http://publib.boulder.ibm.com/bpcsamp/
JDBC Adapter Info Center adapter infocenter http://www.ibm.com/software/integration/wbiadapters/library/infocenter/
redbooks redbooks http://www.redbooks.ibm.com
developerWorks developerWorks http://www.ibm.com/developerworks/
Download IBM Support Assistant (ISA) Lite for WebSphere Adapters ISA. troubleshooting tool. http://www.ibm.com/support/docview.wss?uid=swg24026382

Questions for external service discovery:

title keywords technote link
WebSphere Adapter for JDBC 6.2 export did not build correctly java.lang.NoClassDefFoundError: org.aspectj.lang.JoinPoint$StaticPart http://www.ibm.com/support/docview.wss?uid=swg21417836
Sharing a JDBC adapter with one or more modules in an ear file sharing adapter. http://www.ibm.com/support/docview.wss?uid=swg21404234
How to change the schema where the tables are stored without regenerating the inbound/outbound from Enterprise Service Discovery wizard? changing schema , business object. http://www.ibm.com/support/docview.wss?uid=swg21383179
Websphere Adapter for JDBC does not support Struct and Array data types for DB2 DB2, struct, array, complex type http://www.ibm.com/support/docview.wss?uid=swg21321639
Validation of store procedures that have complex types (STRUCT/ARRAY) as parameters complex type. validation. stored procedure. struct, array. http://www.ibm.com/support/docview.wss?uid=swg21423002
IBM WebSphere Adapters for JDBC cannot retrieve the metadata from Oracle remote table synonyms Oracle.remote table synonym, http://www.ibm.com/support/docview.wss?uid=swg21431600
JDBC Adapter unable to create business object artifacts not create BO http://www.ibm.com/support/docview.wss?uid=swg21432063


Questions for both inbound and outbound:

title keywords technote link
Managing WebSphere Adapters more effectively through wsadmin in WebSphere Process Server wsadmin , managing resource adapter, http://www.ibm.com/developerworks/websphere/library/techarticles/0910_xing/0910_xing.html
Managing WebSphere Adapters more effectively through wsadmin in WebSphere Process Server wsadmin , managing resource adapter, http://www.ibm.com/developerworks/websphere/library/techarticles/1001_yu/1001_yu.html
Ensuring high availability and performance of events delivery with WebSphere Process Server and WebSphere JDBC Adapter inbound mechanism, event delivery performance. http://www.ibm.com/developerworks/websphere/library/techarticles/0912_yuan/0912_yuan.html
Monitoring business database changes with a WebSphere Adapter all kinds of inbound usage. http://www.ibm.com/developerworks/websphere/library/techarticles/1003_xing/1003_xing.html
Deploying and configuring WebSphere Adapters in a clustered environment clustered environment, adapter deployment, embedded, standalone, http://www.ibm.com/developerworks/websphere/library/techarticles/0909_jain/0909_jain.html
http://www.ibm.com/support/docview.wss?uid=swg21383694
http://www.ibm.com/support/docview.wss?uid=swg21407128
Deployment of WebSphere JCA Adapters in a clustered environment on WebSphere Process Server V6.1 and V6.2 clustered environment, adapter deployment http://www.ibm.com/support/docview.wss?uid=swg21383694
Use WebSphere Adapter in WebSphere High Availability Environment clustered environment. adapter deployment. High Availability https://www14.software.ibm.com/webapp/iwm/web/signup.do?source=sw-app&S_PKG=wpswasadapt&S_TACT=105AGX10&S_CMP=LC
IBM WebSphere Adapter for JDBC, V6.2: software requirements required software http://www.ibm.com/support/docview.wss?uid=swg27013377
Adapter for JDBC and MySQL database support MySQL http://www.ibm.com/support/docview.wss?uid=swg21257790
Sample SQL script for generating tables and triggers on i5/OS i5/OS, sample sql script http://www.ibm.com/support/docview.wss?uid=swg21248010
WebSphere Adapter could not deal with control characters control characters, special characters, invalid characters, xml 1.0 http://www.ibm.com/support/docview.wss?uid=swg21422693
How to correctly use Microsoft SQL Server JDBC driver for WebSphere JDBC adapter under WID 6.2 and WPS 6.2 environment JDK1.5, JRE1.5, JRE1.6, JDK1.6. MS SQL Server JDBC driver. http://www.ibm.com/support/docview.wss?uid=swg21408978
WebSphere Adapter for JDBC ASI change does not take effect in Runtime ASI cache http://www.ibm.com/support/docview.wss?uid=swg21432630
Finding Adapter Foundation Class version for a WebSphere Adapter adapter version http://www.ibm.com/support/docview.wss?uid=swg21391962
WebSphere Adapter for JDBC fails when database object names contain a database reserved keyword database reserved keyword http://www.ibm.com/support/docview.wss?uid=swg21433726


Questions for only outbound:

title keywords technote link
How does the WebSphere Adapter for JDBC deal with Null, null string (empty string), blank string, null value, default value and skip over some field(s) Null,null, null string,empty string, blank string, null value http://www.ibm.com/support/docview.wss?uid=swg21441154
Frequently asked questions about how the Date, Time, DateTime and TimeStamp data types are handled in WebSphere Adapter for JDBC date,time,datetime,timestamp, data type http://www.ibm.com/support/docview.wss?uid=swg21456634
Date type application-specific information for business object attributes refers to columns of type Date and Time date , datetime, timestamp, date format http://www.ibm.com/support/docview.wss?uid=swg21242044
Configuring dynamic authentication in WebSphere Adapter for SAP dynamic authentication http://www.ibm.com/developerworks/websphere/library/techarticles/0608_martinez/0608_martinez.html
Error "Missing IN or OUT parameter at index:: 1, error code: 17041" when using Query BO QueryBO http://www.ibm.com/support/docview.wss?uid=swg21318360
Using WebSphere Adapter for JDBC to generate query business objects from nested select queries is not supported QueryBO, nested sql http://www.ibm.com/support/docview.wss?uid=swg21305328
WebSphere JDBC adapter outbound fails due to transaction timeout, lock timeout, or deadlock. transaction timeout. deadlock, locktimeout. concurrent problem. http://www.ibm.com/support/docview.wss?uid=swg21408625
WebSphere JDBC adapter is locking rows on database table and causing other applications to timeout accessing same tables transaction. deadlock, locktimeout. concurrent problem. http://www.ibm.com/support/docview.wss?uid=swg21316337

http://publib.boulder.ibm.com/infocenter/wasinfo/v7r0/index.jsp?topic=/com.ibm.websphere.soafep.multiplatform.doc/info/ae/ae/cdat_isolevel.html

http://publib.boulder.ibm.com/infocenter/wasinfo/v6r1/index.jsp?topic=/com.ibm.websphere.base.doc/info/aes/ae/cdat_isolevel.html

http://publib.boulder.ibm.com/infocenter/db2luw/v9r5/index.jsp?topic=/com.ibm.db2.luw.admin.perf.doc/doc/c0007870.html
Generating wrapper business object and executing operations on wrapper business object Wrapper BO. http://www.ibm.com/support/docview.wss?uid=swg21422891
JDBC adapter is passing null into BO when calling stored procedure which uses defaults stored procedure with default parameters, Oracle http://www.ibm.com/support/docview.wss?uid=swg21447379
Incorrect binary data is returned when WebSphere JDBC adapter performing a query against DB2/AS400 DB2/AS400, binary data. http://www.ibm.com/support/docview.wss?uid=swg21375412
Instruct how to implement an auto-generated/identity column by means of a database sequence when JDBC adapter connects to Oracle database identity column, sequence, auto-generated column http://www.ibm.com/support/docview.wss?uid=swg21379876
WebSphere Adapter for JDBC throws RecordNotFoundException retrieveAll, RecordNotFoundException, errorOnEmptyResultset http://www.ibm.com/support/docview.wss?uid=swg21388384
JR29348: JDBC JCA ADAPTER 6.X JDBC ADAPTER THROWS EXCEPTION IF RETRIEVINGDATA DOES NOT FIND ANY RECORD. retrieveAll, RecordNotFoundException, errorOnEmptyResultset http://www.ibm.com/support/docview.wss?uid=swg1JR29348
RecordNotFoundException may occur when performing a RetrieveAll/Retrieve operation in the WebSphere Integration Developer test client retrieve, retrieveAll, RecordNotFoundException, unset properties http://www.ibm.com/support/docview.wss?uid=swg21281884
Using XA transactions for Outbound support with a remote DB2 database XA transactions, remote DB2 database.XA DataSource name http://www.ibm.com/support/docview.wss?uid=swg21236865
Error occurs while starting a transaction on Oracle starting XA transaction. Oracle http://www.ibm.com/support/docview.wss?uid=swg21240695
ESD of JDBC JCA Adapter can not save the MaxNumOfRetRS and ResultSet ASI during generate the BO ESD, EMD, stored procedure validation, MaxNumOfRetRS. ResultSet ASI http://www.ibm.com/support/docview.wss?uid=swg21322802
WebSphere Adapter for JDBC does not support multiple stored procedures with the same name in one schema EMD, ESD, multiple stored procedures with the same name and different parameters. http://www.ibm.com/support/docview.wss?uid=swg21321642
ResultSet ASI for stored procedures requires manual intervention for returning a result set EMD,ESD, stored procedure with resultsets. http://www.ibm.com/support/docview.wss?uid=swg21248243
How J2CA Adapter works with XML datatype in DB2 XML datatypes, XQuery , DB2 http://www.ibm.com/support/docview.wss?uid=swg21312805
How to support Business Faults BPEL, Business Fault http://www.ibm.com/support/docview.wss?uid=swg21322942
Configuring WSDL file for business faults in JCA Adapter V6.1 adding Business faults. http://www.ibm.com/support/docview.wss?uid=swg21376614
Using Batch BO with sequence value larger than 2147483647 causes "Invalid Conversion" problem using Oracle database oracle, sequence, greater than 2147483647 http://www.ibm.com/support/docview.wss?uid=swg21416771
WebSphere Adapter for JDBC fails to initialize cursor when receiving null Business Object initialize cursor, bo is null. http://www.ibm.com/support/docview.wss?uid=swg21433008


Questions for only inbound :

title keywords technote link
WebSphere Adapters do not poll for events on WebSphere Process Server 6.1/6.2 with WebSphere Application Server 6.1.0.23/6.1.0.25 stop polling events http://www.ibm.com/support/docview.wss?uid=swg21412128

http://www.ibm.com/support/docview.wss?uid=swg21394864

http://www.ibm.com/support/docview.wss?uid=swg1PK79133
WebSphere adapter stops polling when WebSphere Process Server only has the default trace specification "*=info" stop polling events http://www.ibm.com/support/docview.wss?uid=swg21417294
Unable to start more than 20 JCA adapters using WebSphere Process Server stop polling events, threadpool. http://www.ibm.com/support/docview.wss?uid=swg21358534
Multiple connections should be specified for "UNORDERED" event delivery in WebSphere Adapter for JDBC unordered, maximumConnections, minimumConnections http://www.ibm.com/support/docview.wss?uid=swg21390860
Could Multiple JDBC Adapter export components coexist in the same SCA module? multiple inbound in a module, EventTypeFilter http://www.ibm.com/support/docview.wss?uid=swg21382383
How to use the WebSphere Adapter for JDBC with the WebSphere Business Integration Adapter for JDBC event table for the user-defined event query dynamic inbound, custom inbound http://www.ibm.com/support/docview.wss?uid=swg21380141
Implementing archive events function for inbound service of WebSphere Adapter for JDBC archive events,dynamic inbound. custom inbound. http://www.ibm.com/support/docview.wss?uid=swg21399056
JDBC adapter cannot find method for native method during inbound process native method, not find method. http://www.ibm.com/support/docview.wss?uid=swg21377324
Date and time format for object_key column in event table of WebSphere Adapter for JDBC object_key column, date, time. http://www.ibm.com/support/docview.wss?uid=swg21240920
Authentication alias applied on ActivationSpec is not being used ActivationSpec, Auth Alias http://www.ibm.com/support/docview.wss?uid=swg21216512
ClassCastException and CNTR0020E issued in JDBC adapter inbound process StructuredDataFunctionSelector incompatible with FunctionSelector, classloader, ClassCastException http://www.ibm.com/support/docview.wss?uid=swg21417527

Rate this page:

(0 users)Average rating

Document information


More support for:

WebSphere Adapters
Adapter for JDBC

Software version:

6.0.2, 6.1, 6.2

Operating system(s):

AIX, HP Itanium, HP-UX, Linux, Solaris, Windows, i5/OS, z/OS

Software edition:

WebSphere

Reference #:

1416246

Modified date:

2013-10-28

Translate my page

Machine Translation

Content navigation