[resolved] Execute a jobscript makes Sybase component throw an exception

Anonymous — Sat, 16 Nov 2024 12:58:26 GMT

I have a job that executes successfuly inside the TOS suite, but when I export as a jobscript and try to execute on a remote machine I get the following:
Exception in component tSybaseRow_1
java.sql.SQLException: JZ0D5: Error loading protocol com.sybase.jdbc3.tds.Tds.
at com.sybase.jdbc3.jdbc.ErrorMessage.raiseError(Unknown Source)
at com.sybase.jdbc3.jdbc.ProtocolManager.getProtocol(Unknown Source)
at com.sybase.jdbc3.jdbc.SybUrlManager.loadProtocol(Unknown Source)
at com.sybase.jdbc3.jdbc.SybUrlManager.init(Unknown Source)
at com.sybase.jdbc3.jdbc.SybUrlManager.getUrlProvider(Unknown Source)
at com.sybase.jdbc3.jdbc.SybDriver.acceptsURL(Unknown Source)
at java.sql.DriverManager.getDriver(libgcj.so.7rh)
at java.sql.DriverManager.getConnection(libgcj.so.7rh)
at java.sql.DriverManager.getConnection(libgcj.so.7rh)
at sicpa.j01_carga_nagios_sybase_0_1.j01_carga_nagios_sybase.tSybaseRow_1Process(j01_carga_nagios_sybase.java:270)
at sicpa.j01_carga_nagios_sybase_0_1.j01_carga_nagios_sybase.runJobInTOS(j01_carga_nagios_sybase.java:2156)
at sicpa.j01_carga_nagios_sybase_0_1.j01_carga_nagios_sybase.main(j01_carga_nagios_sybase.java:2051)
Exception in thread "main" java.lang.NullPointerException
at sicpa.j01_carga_nagios_sybase_0_1.j01_carga_nagios_sybase$TalendException.printStackTrace(j01_carga_nagios_sybase.java:155)
at sicpa.j01_carga_nagios_sybase_0_1.j01_carga_nagios_sybase.runJobInTOS(j01_carga_nagios_sybase.java:2160)
at sicpa.j01_carga_nagios_sybase_0_1.j01_carga_nagios_sybase.main(j01_carga_nagios_sybase.java:2051)
I think the problem is that the code doesn't find the jdbc driver, but how can I point the correct location?

Re: [resolved] Execute a jobscript makes Sybase component throw an exception

Anonymous — Wed, 20 Apr 2011 14:42:41 GMT

Found the solution:
java version "1.4.2"
gij (GNU libgcj) version 4.1.2 20080704 (Red Hat 4.1.2-50)
Installed the 1.6 version and it worked.

Re: [resolved] Execute a jobscript makes Sybase component throw an exception

Anonymous — Thu, 21 Apr 2011 14:01:19 GMT

Hello anselmo,
Thank you for the feedback.
Best,
Pcoffre.

topic Re: [resolved] Execute a jobscript makes Sybase component throw an exception in Talend Studio

[resolved] Execute a jobscript makes Sybase component throw an exception

Re: [resolved] Execute a jobscript makes Sybase component throw an exception

Re: [resolved] Execute a jobscript makes Sybase component throw an exception