ITDI710 exception 'java.sql.SQLException: Invalid Oracle URL

Technote (troubleshooting)


Problem(Abstract)

Using ITDI 7.1 and the IBM Connections product the IBM Connection Assembly Line

"process_ad_changes" may display the following message:



error java.sql.SQLException: Invalid Oracle URL specified.

Symptom

The ibmdi.log will show the following error:

2013-07-10 15:47:18,469 INFO [AssemblyLine.AssemblyLines/XXXXXX_process_ad_changes.1] - [get_ad_updates] CTGDJF014E Error on access to the System Store: java.sql.SQLException: The exception 'java.sql.SQLException: Invalid Oracle URL specified' was thrown while evaluating an expression.
2013-07-10 15:47:18,470 INFO [AssemblyLine.AssemblyLines/XXXXXX_process_ad_changes.1] - [get_ad_updates] CTGDIS495I handleException , initialize, java.sql.SQLException: The exception 'java.sql.SQLException: Invalid Oracle URL specified' was thrown while evaluating an expression.
2013-07-10 15:47:18,471 DEBUG [server] - CTGDIS802I Getting reconnect choice for connector class = class com.ibm.di.connector.ADChangelogConnectorv2, connector name = get_ad_updates, error = java.sql.SQLException: The exception 'java.sql.SQLException: Invalid Oracle URL specified' was thrown while evaluating an expression.. No matching rule found. Using default action - error.
2013-07-10 15:47:18,471 INFO [AssemblyLine.AssemblyLines/XXXXXX_process_ad_changes.1] - [get_ad_updates] CTGDIS057I Hook initialize_fail not enabled.
2013-07-10 15:47:18,472 ERROR [AssemblyLine.AssemblyLines/XXXXXX_process_ad_changes.1] - [get_ad_updates] CTGDIS810E handleException - cannot handle exception , initialize
java.sql.SQLException: The exception 'java.sql.SQLException: Invalid Oracle URL specified' was thrown while evaluating an expression.
at org.apache.derby.client.am.SQLExceptionFactory40.getSQLException(Unknown Source)
at org.apache.derby.client.am.SqlException.getSQLException(Unknown Source)
at org.apache.derby.client.am.Blob.length(Unknown Source)
at com.ibm.di.store.StoreFactory.deserializeObject(StoreFactory.java:655)
at com.ibm.di.store.PropertyStore.getProperty(PropertyStore.java:237)
at com.ibm.di.connector.ADChangelogConnectorv2.getStartUsnValues(ADChangelogConnectorv2.java:510)
at com.ibm.di.connector.ADChangelogConnectorv2.selectEntries(ADChangelogConnectorv2.java:552)
at com.ibm.di.server.AssemblyLineComponent.executeOperation(AssemblyLineComponent.java:3181)
at com.ibm.di.server.AssemblyLineComponent.doConnectorSelectEntries(AssemblyLineComponent.java:1243)
at com.ibm.di.server.AssemblyLineComponent.doInitialize(AssemblyLineComponent.java:1185)
at com.ibm.di.server.AssemblyLineComponent.initialize(AssemblyLineComponent.java:1139)
at com.ibm.di.server.AssemblyLine.initConnectors(AssemblyLine.java:1886)
at com.ibm.di.server.AssemblyLine.msInitConn(AssemblyLine.java:3477)
at com.ibm.di.server.AssemblyLine.executeMainStep(AssemblyLine.java:3292)
at com.ibm.di.server.AssemblyLine.executeMainLoop(AssemblyLine.java:2944)
at com.ibm.di.server.AssemblyLine.executeMainLoop(AssemblyLine.java:2927)
at com.ibm.di.server.AssemblyLine.executeAL(AssemblyLine.java:2896)
at com.ibm.di.server.AssemblyLine.run(AssemblyLine.java:1296)
Caused by: org.apache.derby.client.am.SqlException: The exception 'java.sql.SQLException: Invalid Oracle URL specified' was thrown while evaluating an expression.
at org.apache.derby.client.am.Statement.completeExecute(Unknown Source)
at org.apache.derby.client.net.NetStatementReply.parseEXCSQLSTTreply(Unknown Source)
at org.apache.derby.client.net.NetStatementReply.readExecuteCall(Unknown Source)
at org.apache.derby.client.net.StatementReply.readExecuteCall(Unknown Source)
at org.apache.derby.client.net.NetStatement.readExecuteCall_(Unknown Source)
at org.apache.derby.client.am.Statement.readExecuteCall(Unknown Source)
at org.apache.derby.client.am.PreparedStatement.flowExecute(Unknown Source)
at org.apache.derby.client.am.PreparedStatement.executeX(Unknown Source)
at org.apache.derby.client.am.CallableLocatorProcedures.blobGetLength(Unknown Source)
at org.apache.derby.client.am.Blob.getLocatorLength(Unknown Source)
at org.apache.derby.client.am.Lob.sqlLength(Unknown Source)


Diagnosing the problem

Review the ibmdi.log file for the following exception:

'java.sql.SQLException: Invalid Oracle URL specified' was thrown while evaluating an expression.


Resolving the problem

Check if you have the oracle jdbc jar file in the <ITDI_Installed>/jvm/jre/lib/ext/ as per the IBM Connections documentation. If so then do the following:

1. Move the ojdbc6.jar from <ITDI_Installed>/jvm/jre/lib/ext/ to the <ITDI_Installed>/jars/3rdparty/others/
2. Reboot or restart the derby database using derby.sh


Rate this page:

(0 users)Average rating

Add comments

Document information


More support for:

IBM Security Directory Integrator
General

Software version:

7.1

Operating system(s):

Linux

Reference #:

1646355

Modified date:

2013-08-12

Translate my page

Machine Translation

Content navigation