Analytics Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

ODI 11g procedure using Jython fail

User729543-OracleJul 15 2011 — edited Jul 18 2011

I have a sample ODI procedure below using Jython. It failed with the following message.
com.sunopsis.tools.core.exception.SnpsSimpleMessageException: Error during task interpretation
Task:1
java.lang.Exception: The application script threw an exception: java.lang.NullPointerException BSF info: Check To Run at line: 0 column: columnNo
at com.sunopsis.dwg.codeinterpretor.SnpCodeInterpretor.transform(SnpCodeInterpretor.java:635)

import java.sql as sql
import java.lang as lang

# Connection for Odi on Oracle

driver, url, user, passwd = (
'<%=odiRef.getInfo("DEST_JAVA_DRIVER")%>',
'<%=odiRef.getInfo("DEST_JAVA_URL")%>',
'<%=odiRef.getInfo("DEST_USER_NAME")%>',
'<%=odiRef.getInfo("DEST_PASS")%>')

# Register driver
lang.Class.forName(driver)
# Create a connection object
myConSnp = sql.DriverManager.getConnection(url, user, passwd)

Locked Post

New comments cannot be posted to this locked post.

Locked on Aug 15 2011

Added on Jul 15 2011

#business-intelligence-applications, #data-integrator, #system-management-and-integration

8 comments

760 views