Post a reply

Write your message and submit

Options

Click in the dark area of the image to send your post.

Go back

Topic review (newest first)

mhirt
2007-06-22 23:18:06

Great post.
I have created [Bugtracker] bug 1344 to resolve this issue globally.

Thanks for your support.
Michaël.

hawnnguyen
2007-06-22 21:28:01

I found the problem.  In the following directory:

<install directory>\TOS-Win32-r3483-V2.1.0M1\plugins\org.talend.designer.components.localprovider_2.1.0.M1_r3483\components\tDB2Input

The file "tDB2Input_java.xml" did not include the db2jcc_license_cisuz.jar and db2jcc_license_cu.jar in the CodeGeneration node under Imports.  Those two jar files should be in the directory already. I added the lines and in the <CODEGENERATION> node it should look like this.


  <CODEGENERATION>
     <IMPORTS>
        <IMPORT NAME="Driver-DB2" MODULE="db2jcc.jar" REQUIRED="true" />
        <IMPORT NAME="Driver-DB2" MODULE="db2jcc_license_cisuz.jar" REQUIRED="true" />
        <IMPORT NAME="Driver-DB2" MODULE="db2jcc_license_cu.jar" REQUIRED="true" />
     </IMPORTS>
   </CODEGENERATION>

After that, the program runs fine.  We are running DB2 version 8.1.7.445

hawnnguyen
2007-06-22 15:04:47

Hello,
     I'm testing out the talend software to out data from a table from one of our db2 database into a tFileOutputDelimited file.  I'm able to setup and connect to my db2 database from the "Metadata -> DB Connection" and connected just fine and was able to use the SQL editor and query the database fine from Talend.  However, when I run my Job Design Process, it gives the following error.  In my tDB2Input, I am pulling from the Repository and I also pulled in one of the tables in the schema to pull from.   Is there an additional setup that I need to do to have recognize the db2 licenses .jar files?

[statistics] connecting to socket on port 3334
[statistics] connected
[trace] connecting to socket on port 4334
[trace] connected
Exception in component tDB2Input_1
com.ibm.db2.jcc.a.SqlException: The version of the IBM Universal JDBC driver in use is not licensed for connectivity to QDB2/6000 databases.  To connect to this DB2 server, please obtain a licensed copy of the IBM DB2 Universal Driver for JDBC and SQLJ.  An appropriate license file db2jcc_license_*.jar for this target platform must be installed to the application classpath.  Connectivity to QDB2/6000 databases is enabled by any of the following license files: { db2jcc_license_cu.jar, db2jcc_license_cisuz.jar }[statistics] disconnected
[trace] disconnected

    at com.ibm.db2.jcc.a.p.fb(p.java:3311)
    at com.ibm.db2.jcc.a.p.a(p.java:3252)
    at com.ibm.db2.jcc.b.b.a(b.java:618)
    at com.ibm.db2.jcc.b.b.<init>(b.java:333)
    at com.ibm.db2.jcc.DB2Driver.connect(DB2Driver.java:165)
    at java.sql.DriverManager.getConnection(Unknown Source)
    at java.sql.DriverManager.getConnection(Unknown Source)
    at etl_fedad.myfristdb2job.MyFristDB2Job.tDB2Input_1Process(MyFristDB2Job.java:291)
    at etl_fedad.myfristdb2job.MyFristDB2Job.main(MyFristDB2Job.java:1411)

Board footer

Powered by FluxBB