Currency Certification Notes for
IBM WebSphere Process Server (WPS), Version 6.1.2.3 to support
Oracle 11g Enterprise Edition Release 2 – 11.2.0.1

The certification notes contain the following sections:

Completed Currency Certification Requests

Upgrade Instructions

Additional Discussion

Completed Currency Certification Requests

This Currency Certification contains fixes for the following CRs based on customer requirement.

Problem tracking numbers

As of Version

Problem

 

V6.1.2.3

         WPS 6.1.2.3 to support Oracle 11g Enterprise Edition Release 2 – 11.2.0.1

 Upgrade Instructions

1. Follow WPS V6.1.2.3 upgrading guide to upgrade to WPS6.1.2.3 from either WPS6.1.0.x or WPS6.1.2.x versions.

2. Follow Oracle 11g Enterprise Edition Release 2 – 11.2.0.1 installation guide to install Oracle 11g Enterprise Edition Release 2 – 11.2.0.1.

Additional Discussion

1.      When you use Oracle jdbc driver 11.2.0.1 you might encounter the following exceptions during server startup:

SpaceDataAcce E com.ibm.bspace.manager.services.dbhelper.SpaceDataAccess getSpacesWithEditorRights() <Null Message>

                                 java.sql.SQLException: Invalid column type: getString not implemented for class oracle.jdbc.driver.T4CBlobAccessor

            at oracle.jdbc.driver.Accessor.unimpl(Accessor.java:412)

            at oracle.jdbc.driver.BlobAccessor.getString(BlobAccessor.java:335)

            at oracle.jdbc.driver.OracleResultSetImpl.getString(OracleResultSetImpl.java:1118)

            at oracle.jdbc.driver.OracleResultSet.getString(OracleResultSet.java:424)

            at com.ibm.ws.rsadapter.jdbc.WSJdbcResultSet.getString(WSJdbcResultSet.java:1848)

            at com.ibm.bspace.manager.services.dbhelper.SpaceDataAccess.getSpacesWithEditorRights(SpaceDataAccess.java:1394)

            at com.ibm.bspace.manager.services.dbhelper.SpaceDataAccess.isSpaceEditor(SpaceDataAccess.java:1099)

            at com.ibm.bspace.manager.services.dbhelper.PageDataAccess.createPage(PageDataAccess.java:951)

            at com.ibm.bspace.manager.services.templates.UpdateTemplates.saveTemplateFile(UpdateTemplates.java:386)

            at com.ibm.bspace.manager.services.templates.UpdateTemplates.processTemplateFile(UpdateTemplates.java:272)

            at com.ibm.bspace.manager.services.templates.UpdateTemplates.run(UpdateTemplates.java:66)

            at java.lang.Thread.run(Thread.java:810)

SystemOut     O Exception: java.sql.SQLException: Invalid column type: getString not implemented for class oracle.jdbc.driver.T4CBlobAccessor

 

Solution: Use Oracle jdbc driver 11.1.0.6 or 10.1.0.4 that is compatible with WPS v6.1.2.