My Oracle Support Banner

Loading XML File to Oracle Table using J2EE Agent is Failing with "oracle.odi.runtime.agent.execution.connection.DataServerConnectionCustomizer$IScriptingConnection is not visible from class loader" (Doc ID 2620450.1)

Last updated on AUGUST 21, 2023

Applies to:

Oracle Data Integrator - Version 12.2.1.3.0 and later
Oracle Data Integrator on Marketplace - Version 1.0.2 and later
Information in this document applies to any platform.

Symptoms

An Oracle Data Integrator (ODI) mapping that loads a XML File to an Oracle table using a J2EE Agent is failing with following error:

oracle.odi.runtime.agent.exception.ExecutionEngineException: java.lang.IllegalArgumentException: interface oracle.odi.runtime.agent.execution.connection.DataServerConnectionCustomizer$IScriptingConnection is not visible from class loader
   at oracle.odi.runtime.agent.execution.sql.concurrent.FastJDBCRecordSet.(FastJDBCRecordSet.java:153)
   at oracle.odi.runtime.agent.execution.sql.SQLDataProvider.getJDBCRecordSet(SQLDataProvider.java:133)
   at oracle.odi.runtime.agent.execution.sql.SQLDataProvider.readData(SQLDataProvider.java:105)
   at oracle.odi.runtime.agent.execution.sql.SQLDataProvider.readData(SQLDataProvider.java:38)
   at oracle.odi.runtime.agent.execution.Executor.handleDataMovementTask(Executor.java:309)
   at oracle.odi.runtime.agent.execution.DataMovementTaskExecutionHandler.handleTask(DataMovementTaskExecutionHandler.java:51)
   at oracle.odi.runtime.agent.execution.SessionTask.processTask(SessionTask.java:216)
   at oracle.odi.runtime.agent.execution.SessionTask.doExecuteTask(SessionTask.java:127)
   at oracle.odi.runtime.agent.execution.AbstractSessionTask.execute(AbstractSessionTask.java:886)
   at oracle.odi.runtime.agent.execution.SessionExecutor$SerialTrain.runTasks(SessionExecutor.java:2225)
   at oracle.odi.runtime.agent.execution.SessionExecutor.executeSession(SessionExecutor.java:610)
   at oracle.odi.runtime.agent.processor.TaskExecutorAgentRequestProcessor$1.doAction(TaskExecutorAgentRequestProcessor.java:718)
   at oracle.odi.runtime.agent.processor.TaskExecutorAgentRequestProcessor$1.doAction(TaskExecutorAgentRequestProcessor.java:611)
   at oracle.odi.core.persistence.dwgobject.DwgObjectTemplate.execute(DwgObjectTemplate.java:203)
   at oracle.odi.runtime.agent.processor.TaskExecutorAgentRequestProcessor.doProcessStartAgentTask(TaskExecutorAgentRequestProcessor.java:800)
   at oracle.odi.runtime.agent.processor.impl.StartSessRequestProcessor.access$1400(StartSessRequestProcessor.java:74)
   at oracle.odi.runtime.agent.processor.impl.StartSessRequestProcessor$StartSessTask.doExecute(StartSessRequestProcessor.java:702)
   at oracle.odi.runtime.agent.processor.task.AgentTask.execute(AgentTask.java:180)
   at oracle.odi.runtime.agent.support.DefaultAgentTaskExecutor$2.run(DefaultAgentTaskExecutor.java:108)
   at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)
   at oracle.odi.runtime.agent.execution.job.OdiJob.call(OdiJob.java:73)
   at oracle.odi.runtime.agent.execution.job.OdiJob.call(OdiJob.java:73)
   at java.util.concurrent.FutureTask.run(FutureTask.java:266)
   at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
   at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
   at java.lang.Thread.run(Thread.java:748)
Caused by: java.lang.IllegalArgumentException: interface oracle.odi.runtime.agent.execution.connection.DataServerConnectionCustomizer$IScriptingConnection is not visible from class loader
   at java.lang.reflect.Proxy$ProxyClassFactory.apply(Proxy.java:581)
   at java.lang.reflect.Proxy$ProxyClassFactory.apply(Proxy.java:557)
   at java.lang.reflect.WeakCache$Factory.get(WeakCache.java:230)
   at java.lang.reflect.WeakCache.get(WeakCache.java:127)
   at java.lang.reflect.Proxy.getProxyClass0(Proxy.java:419)
   at java.lang.reflect.Proxy.newProxyInstance(Proxy.java:719)
   at oracle.odi.runtime.agent.execution.connection.DataServerConnectionCustomizer.customize(DataServerConnectionCustomizer.java:51)
   at com.sunopsis.sql.SnpsConnection$CacheMetaDataConnection.customizeConnection(SnpsConnection.java:229)
   at com.sunopsis.sql.SnpsConnection.customizeConnection(SnpsConnection.java:385)
   at oracle.odi.runtime.agent.execution.AbstractSessionTask.proxyConnection(AbstractSessionTask.java:746)
   at oracle.odi.runtime.agent.execution.AbstractSessionTask.getSrcDwgConnectConnection(AbstractSessionTask.java:682)
   at oracle.odi.runtime.agent.execution.sql.concurrent.FastJDBCRecordSet.validateColumnName(FastJDBCRecordSet.java:194)
   ...

Cause

To view full details, 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 a vibrant support community of peers and Oracle experts.