com.ibm.ws.rsadapter.jdbc.WSJdbcPreparedStatement incompatible with oracle.jdbc.OraclePreparedStatement (Doc ID 1903319.1)

Last updated on FEBRUARY 08, 2017

Applies to:

Oracle Fusion Middleware MapViewer - Version 11.1.1.7.0 and later
Information in this document applies to any platform.

Symptoms

Using Oracle MapViewer version 11_1_1_7_2_B131022 running on WebSphere Application Server (WAS) version 7.0.0.27.

Defining datasources in the application's mapViewerConfig.xml, everything works fine.

However, using a container data source defined in WebSphere Application Server (WAS), using Oracle JDBC driver version 11.2.0.32 and when MapViewer client submits request to retrieve data from Mapviewer Server, we get the following error/warning in the MapViewer log:


WARNING: com.ibm.ws.rsadapter.jdbc.WSJdbcPreparedStatement incompatible with oracle.jdbc.OraclePreparedStatement

Exception while querying spatial index metadata for theme NETWORK MEDIUM LEVEL: com.ibm.ws.rsadapter.jdbc.WSJdbcResultSet incompatible with oracle.jdbc.OracleResultSet

It seems like WebSphere wraps the ResultSet objects with its own WSJdbcResultSet and the application doesnt like it.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms