OVD Manager Exception From Database Adapter: (500); nested exception is: java.io.IOException

(Doc ID 785208.1)

Last updated on MARCH 08, 2017

Applies to:

Oracle Virtual Directory - Version: and later   [Release: 10gR3 and later ]
Information in this document applies to any platform.
***Checked for relevance on 18-Oct-2011***


OVD Build 8001 (with merge <>.

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 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 but the 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]


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