Frequently asked questions (FAQs) specific to database server or JDBC driver (updated June 06, 2010)

Technote (FAQ)


Question

Which technote describes frequently asked questions specific to database server or JDBC driver in detail?

Cause

Some technotes that describe problems specific to database or JDBC driver are always dispersive and it is difficult to search for expected technotes.

Answer

Here is a technote which summarizes frequently asked questions specific to database server or jdbc driver and will be refreshed every two months.The last update is 2 June 2010.

Below is the download links related to jdbc drivers.

database type subject link
Generic Database JDBC Overview http://java.sun.com/products/jdbc/overview.html
MS SQL Server SQL Server 2008 JDBC Driver 2.0 http://www.microsoft.com/downloads/details.aspx?FamilyID=99b21b65-e98f-4a61-b811-19912601fdc9&displaylang=en
SQL Server 2000 Driver for JDBC Service Pack 3 http://www.microsoft.com/downloads/details.aspx?familyid=07287B11-0502-461A-B138-2AA54BFDC03A&displaylang=en
SQL Server 2000 Driver for JDBC Service Pack 2 http://www.microsoft.com/downloads/details.aspx?familyid=9F1874B6-F8E1-4BD6-947C-0FC5BF05BF71&displaylang=en
jTDS jdbc driver http://jtds.sourceforge.net/
Frequently Asked Questions: http://msdn.microsoft.com/en-us/data/cc325721.aspx
the supportability matrix for the Microsoft SQL Server JDBC Driver http://msdn.microsoft.com/en-us/data/cc325721.aspx
DB2 DB2 database product documentation http://www.ibm.com/support/docview.wss?uid=swg27009474
DB2 Application Development Site http://www.ibm.com/software/data/db2/ad/
JDBC Driver for Linux, Unix, Windows http://www.ibm.com/support/docview.wss?uid=swg21363866
http://www.ibm.com/support/docview.wss?uid=swg27007053
JDBC Driver for iSeries https://www-03.ibm.com/systems/i/software/toolbox/index.html
http://jt400.sourceforge.net/
Informix Informix product family http://www.ibm.com/software/data/informix/
JDBC Driver for Informix http://www14.software.ibm.com/webapp/download/search.jsp?go=y&rs=ifxjdbc
Oracle JDBC Driver for Oracle http://www.oracle.com/technology/software/tech/java/sqlj_jdbc/index.html
Sybase JDBC Driver for Sybase (jConnect) http://downloads.sybase.com/swd/summary.do?client=support&baseprod=63
jTDS jdbc driver http://jtds.sourceforge.net/
postgresql JDBC Driver for Postgresql http://jdbc.postgresql.org/download.html
MySQL JDBC Driver for MySQL http://dev.mysql.com/downloads/connector/j/5.1.html

Here is some technotes which describes frequently asked questions specific to database server or jdbc driver.

database type subject technote
Generic Database Connecting to database server on Windows using existing ODBC Data Source for WebSphere adapter for JDBC http://www.ibm.com/support/docview.wss?uid=swg21399636
WebSphere JDBC adapter is locking rows on database table and causing other applications to timeout accessing same tables http://www.ibm.com/support/docview.wss?uid=swg21316337
WebSphere Adapter for JDBC does not support multiple stored procedures with the same name in one schema http://www.ibm.com/support/docview.wss?uid=swg21321642
MS SQL Server How to correctly use Microsoft SQL Server JDBC driver for WebSphere JDBC adapter under WID 6.2 and WPS 6.2 environment http://www.ibm.com/support/docview.wss?uid=swg21408978
JDBC adapter fails to get resultsets returned by stored procedure http://www.ibm.com/support/docview.wss?uid=swg21389550
WebSphere Adapter for JDBC 6.2 receives "unable to switch the encoding, error code:9402" error message when calling Stored Procedure on SQL Server 2005 database http://www.ibm.com/support/docview.wss?uid=swg21398797
JDBC JCA 6.0.2.2 outbound adapter to MS SQLServer database query takes longer than when query is run with SQL client tool. http://www.ibm.com/support/docview.wss?uid=swg21293911
Resultset doesnot contain any values when the 'Validate the Syntax' Check box is selected http://www.ibm.com/support/docview.wss?uid=swg21382619
WebSphere Adapter for JDBC Adapter fails with SQL Server 2000 JDBC driver http://www.ibm.com/support/docview.wss?uid=swg21377748
When using languages other than English in the database used with JDBC enterprise service discovery, set database locale to corresponding values http://www.ibm.com/support/docview.wss?uid=swg21225154
Cannot connect to SQL Server 2000 running on Windows Server 2003 when using XA data source http://www.ibm.com/support/docview.wss?uid=swg21187844
http://www.ibm.com/support/docview.wss?uid=swg21221370
SQL Server 2000 JDBC driver cannot support connection parameter DatabaseName if it includes globalized characters http://www.ibm.com/support/docview.wss?uid=swg21240939
DB2 WebSphere Adapter for JDBC Stored Procedure Business Object was not built correctly through Enterprise Metadata Discovery http://www.ibm.com/support/docview.wss?uid=swg21406286
JDBC adapter fails to get resultsets returned by stored procedure http://www.ibm.com/support/docview.wss?uid=swg21389550
Problem creating business object through Enterprise Services Discovery http://www.ibm.com/support/docview.wss?uid=swg21385062
DB2ConnectionCorrelator exception is generated when connecting to DB2 in the Taiwan Chinese locale http://www.ibm.com/support/docview.wss?uid=swg21283128
Server process might crash using DB2 in XA transactions http://www.ibm.com/support/docview.wss?uid=swg21251867
Clob and Blob types are not supported with DB2 on RedHat and SUSE 64 bit OS http://www.ibm.com/support/docview.wss?uid=swg21252498
Sample SQL script for generating tables and triggers on i5/OS http://www.ibm.com/support/docview.wss?uid=swg21248010
Websphere Adapter for JDBC does not support Struct and Array data types for DB2 http://www.ibm.com/support/docview.wss?uid=swg21321639
Incorrect binary data is returned when WebSphere JDBC adapter performing a query against DB2/AS400 http://www.ibm.com/support/docview.wss?uid=swg21375412
Oracle How to configure WBI JDBC Adapter connect to ORACLE RAC https://www-304.ibm.com/support/docview.wss?uid=swg21422094
WebSphere JDBC 6.2.0.3 adapter Enterprise Discovery Service is slow discovering schemas on Oracle database http://www.ibm.com/support/docview.wss?uid=swg21411903
JDBC adapter fails to get resultsets returned by stored procedure http://www.ibm.com/support/docview.wss?uid=swg21389550
ESD of JDBC JCA Adapter can not save the MaxNumOfRetRS and ResultSet ASI during generate the BO http://www.ibm.com/support/docview.wss?uid=swg21322802
WebSphere Adapter for JDBC did not support execute the store procedure of Oracle with RECORD type paramters http://www.ibm.com/support/docview.wss?uid=swg21322402
Attribute not created in business object for Oracle column of NCHAR type http://www.ibm.com/support/docview.wss?uid=swg21218777
Error occurs while starting a transaction on Oracle http://www.ibm.com/support/docview.wss?uid=swg21240695
http://www.ibm.com/support/docview.wss?uid=swg21215890
Sybase Enterprise Service Discovery with Sybase jConnect driver generates wrong Business Objects : ASI 'ReturnValue' undefined. http://www.ibm.com/support/docview.wss?uid=swg21291707
Using WebSphere Adapter for JDBC V6.0.2 and 6.1 with Sybase database stored procedures http://www.ibm.com/support/docview.wss?uid=swg21298596
JDBC JCA Adapter Enterprise Service Discovery fails when trying to import a stored procedure from a Sybase database http://www.ibm.com/support/docview.wss?uid=swg21292988
Progress Using WebSphere Adapter for JDBC to retrieve objects from a Progress database http://www.ibm.com/support/docview.wss?uid=swg21266591
MySQL Adapter for JDBC and MySQL database support http://www.ibm.com/support/docview.wss?uid=swg21257790

Product Alias/Synonym

Websphere JDBC adapter
JDBC adapter
WBI JDBC adapter

Rate this page:

(0 users)Average rating

Add comments

Document information


More support for:

WebSphere Adapters
Adapter for JDBC

Software version:

6.0, 6.0.0.1, 6.0.0.2, 6.0.1, 6.0.2, 6.0.2.1, 6.0.2.2, 6.0.2.3, 6.0.3, 6.0.4, 6.0.5, 6.0.6, 6.1, 6.2, 6.2.0.1, 6.2.0.2

Operating system(s):

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

Reference #:

1399321

Modified date:

2010-10-27

Translate my page

Machine Translation

Content navigation