OVD Manager Exception From Database Adapter: (500); nested exception is: java.io.IOException
(Doc ID 785208.1)
Last updated on JANUARY 30, 2022
Applies to:Oracle Virtual Directory - Version 10.1.4.3 and later
Information in this document applies to any platform.
OVD 10.1.4.3.0 Build 8001 with merge <Patch 7597530>.
Trying to relocate multivalue comment attributes from an LDAP server to a backend Oracle Database server and use OVD to restore those attributes to the LDAP entry. Had the DB admin create a table to place each comment into a separate row so that it would match how OVD maps them into multivalued
attributes. Also had the table indexed to the LDAP entry's CN column.
Using Oracle Thin Driver connecting to Oracle 10.2.0.3 RDBMS server. The Adapter Source Data viewer reports the error below in a pop-up window:
Dialog box titled "Could not retrieve database results" with error:
(500); nested exception is: java.io.IOException
Note: The complete error message shows truncated, i.e.:
The Client View simply locks up waiting for data from the DB Adapter. A separate/3rd party LDAP browser likewise halts waiting for a result from the OVD server. An application such as Oracle SQL Developer has no trouble reading the table structure or the data inside the table.
Tried a couple of jdbc drivers but neither seems to do anything different. The version of the odbc14.jar file is 10.2.0.3 but the 10.2.0.4 version produces similar results.
Getting the "nested exception" message in Directory Manager when attempting to view the table. Can expand the table structure and see the columns inside and each column responds with its datatype information. The vde.log.exception file shows no error messages. And the vde.log file shows:
[2009-02-03 20:24:54,108] DEBUG - AdminLoggingService: 'cn=Admin' Performed getResults [PoolThread-1]
[2009-02-03 20:24:54,116] WARN - JettyLogger: Exception for /services/VDEDatabaseBrowserService: java.io.IOException: No serializer found for class oracle.sql.TIMESTAMP in registry org.apache.axis.encoding.TypeMappingImpl@7b4189d0 1233692694116 [PoolThread-1]
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document