|
| Problem of reading DB2 CLOB column |
 |
Mon, 31 Dec 2007 15:45:14 +080 |
Dear all,
My TDI version is 6.1 (Fixpack 2)
I have a problem during using JDBCconnector to read db2 table. When the
connector read the CLOB field with null value in the record, it throws the
following exception:
java.lang.NullPointerException
at com.ibm.di.connector.JDBCConnector$SqlMap.buildEntry(Unknown Source)
at com.ibm.di.connector.JDBCConnector.getNextEntry(Unknown Source)
at com.ibm.di.server.AssemblyLineComponent.getnext(Unknown Source)
at com.ibm.di.server.AssemblyLine.msGetNextIteratorEntry(Unknown Source)
at com.ibm.di.server.AssemblyLine.executeMainStep(Unknown Source)
at com.ibm.di.server.AssemblyLine.executeMainLoop(Unknown Source)
at com.ibm.di.server.AssemblyLine.executeMainLoop(Unknown Source)
at com.ibm.di.server.AssemblyLine.executeAL(Unknown Source)
at com.ibm.di.server.AssemblyLine.run(Unknown Source)
15:23:03 CTGDIS266E Error in NextIteratorEntry. Exception occurred:
java.lang.NullPointerException
java.lang.NullPointerException
at com.ibm.di.connector.JDBCConnector$SqlMap.buildEntry(Unknown Source)
at com.ibm.di.connector.JDBCConnector.getNextEntry(Unknown Source)
at com.ibm.di.server.AssemblyLineComponent.getnext(Unknown Source)
at com.ibm.di.server.AssemblyLine.msGetNextIteratorEntry(Unknown Source)
at com.ibm.di.server.AssemblyLine.executeMainStep(Unknown Source)
at com.ibm.di.server.AssemblyLine.executeMainLoop(Unknown Source)
at com.ibm.di.server.AssemblyLine.executeMainLoop(Unknown Source)
at com.ibm.di.server.AssemblyLine.executeAL(Unknown Source)
at com.ibm.di.server.AssemblyLine.run(Unknown Source)
Is it a bug of TDI 6.1?
Thanks and Regards,
Jacky
|
| Post Reply
|
| Re: Problem of reading DB2 CLOB column |
 |
Mon, 07 Jan 2008 14:40:10 +010 |
Jacky,
I can see that TDI 6.1 Fixpack 2 fixes a problem around reading NULL BLOBs.
Are you running TDI 6.1 or 6.1.1? What is your fixpack level?
Also, can you try using the JDBC drivers provided by your DB2 database
(instead of those provided by TDI?)
Cheers,
Christian
Jacky Cheung wrote:
> Dear all,
>
> My TDI version is 6.1 (Fixpack 2)
>
> I have a problem during using JDBCconnector to read db2 table. When the
> connector read the CLOB field with null value in the record, it throws the
> following exception:
>
> java.lang.NullPointerException
> at com.ibm.di.connector.JDBCConnector$SqlMap.buildEntry(Unknown Source)
> at com.ibm.di.connector.JDBCConnector.getNextEntry(Unknown Source)
> at com.ibm.di.server.AssemblyLineComponent.getnext(Unknown Source)
> at com.ibm.di.server.AssemblyLine.msGetNextIteratorEntry(Unknown Source)
> at com.ibm.di.server.AssemblyLine.executeMainStep(Unknown Source)
> at com.ibm.di.server.AssemblyLine.executeMainLoop(Unknown Source)
> at com.ibm.di.server.AssemblyLine.executeMainLoop(Unknown Source)
> at com.ibm.di.server.AssemblyLine.executeAL(Unknown Source)
> at com.ibm.di.server.AssemblyLine.run(Unknown Source)
> 15:23:03 CTGDIS266E Error in NextIteratorEntry. Exception occurred:
> java.lang.NullPointerException
> java.lang.NullPointerException
> at com.ibm.di.connector.JDBCConnector$SqlMap.buildEntry(Unknown Source)
> at com.ibm.di.connector.JDBCConnector.getNextEntry(Unknown Source)
> at com.ibm.di.server.AssemblyLineComponent.getnext(Unknown Source)
> at com.ibm.di.server.AssemblyLine.msGetNextIteratorEntry(Unknown Source)
> at com.ibm.di.server.AssemblyLine.executeMainStep(Unknown Source)
> at com.ibm.di.server.AssemblyLine.executeMainLoop(Unknown Source)
> at com.ibm.di.server.AssemblyLine.executeMainLoop(Unknown Source)
> at com.ibm.di.server.AssemblyLine.executeAL(Unknown Source)
> at com.ibm.di.server.AssemblyLine.run(Unknown Source)
>
> Is it a bug of TDI 6.1?
>
> Thanks and Regards,
> Jacky
>
>
|
| Post Reply
|
| Re: Problem of reading DB2 CLOB column |
 |
Tue, 8 Jan 2008 09:41:09 +0800 |
Dear Christian,
My TDI version is 6.1. I have installed Fixpack 2 and can't solve the
problem. I think the fixpack only fixes BLOB problem but not CLOB problem.
I have tried to copy the db2jcc.jar from IBM DB2 (/sqllib/java/db2jcc.jar)
to replace db2jcc.jar of TDI but it doesn't solve the problem.
Thanks and Regards,
Jacky
"Christian Chateauvieux" <christian.chateauvieux@fr.ibm.com>
wrote in
message news:fltah6$1ms7i$1@news.boulder.ibm.com...
> Jacky,
>
> I can see that TDI 6.1 Fixpack 2 fixes a problem around reading NULL
> BLOBs.
> Are you running TDI 6.1 or 6.1.1? What is your fixpack level?
> Also, can you try using the JDBC drivers provided by your DB2 database
> (instead of those provided by TDI?)
>
> Cheers,
>
> Christian
>
> Jacky Cheung wrote:
>> Dear all,
>>
>> My TDI version is 6.1 (Fixpack 2)
>>
>> I have a problem during using JDBCconnector to read db2 table. When
the
>> connector read the CLOB field with null value in the record, it throws
>> the
>> following exception:
>>
>> java.lang.NullPointerException
>> at com.ibm.di.connector.JDBCConnector$SqlMap.buildEntry(Unknown
Source)
>> at com.ibm.di.connector.JDBCConnector.getNextEntry(Unknown Source)
>> at com.ibm.di.server.AssemblyLineComponent.getnext(Unknown Source)
>> at com.ibm.di.server.AssemblyLine.msGetNextIteratorEntry(Unknown
Source)
>> at com.ibm.di.server.AssemblyLine.executeMainStep(Unknown Source)
>> at com.ibm.di.server.AssemblyLine.executeMainLoop(Unknown Source)
>> at com.ibm.di.server.AssemblyLine.executeMainLoop(Unknown Source)
>> at com.ibm.di.server.AssemblyLine.executeAL(Unknown Source)
>> at com.ibm.di.server.AssemblyLine.run(Unknown Source)
>> 15:23:03 CTGDIS266E Error in NextIteratorEntry. Exception occurred:
>> java.lang.NullPointerException
>> java.lang.NullPointerException
>> at com.ibm.di.connector.JDBCConnector$SqlMap.buildEntry(Unknown
Source)
>> at com.ibm.di.connector.JDBCConnector.getNextEntry(Unknown Source)
>> at com.ibm.di.server.AssemblyLineComponent.getnext(Unknown Source)
>> at com.ibm.di.server.AssemblyLine.msGetNextIteratorEntry(Unknown
Source)
>> at com.ibm.di.server.AssemblyLine.executeMainStep(Unknown Source)
>> at com.ibm.di.server.AssemblyLine.executeMainLoop(Unknown Source)
>> at com.ibm.di.server.AssemblyLine.executeMainLoop(Unknown Source)
>> at com.ibm.di.server.AssemblyLine.executeAL(Unknown Source)
>> at com.ibm.di.server.AssemblyLine.run(Unknown Source)
>>
>> Is it a bug of TDI 6.1?
>>
>> Thanks and Regards,
>> Jacky
>>
>>
|
| Post Reply
|
| Re: Problem of reading DB2 CLOB column |
 |
Tue, 08 Jan 2008 10:04:49 +010 |
Jacky,
can you open a PMR with IBM support? This looks like a product defect
and the best way to get it fixed is via the support team.
Thanks,
Christian
Jacky wrote:
> Dear Christian,
>
> My TDI version is 6.1. I have installed Fixpack 2 and can't solve the
> problem. I think the fixpack only fixes BLOB problem but not CLOB problem.
>
> I have tried to copy the db2jcc.jar from IBM DB2 (/sqllib/java/db2jcc.jar)
> to replace db2jcc.jar of TDI but it doesn't solve the problem.
>
> Thanks and Regards,
> Jacky
>
>
> "Christian Chateauvieux"
<christian.chateauvieux@fr.ibm.com> wrote in
> message news:fltah6$1ms7i$1@news.boulder.ibm.com...
>
>>Jacky,
>>
>>I can see that TDI 6.1 Fixpack 2 fixes a problem around reading NULL
>>BLOBs.
>>Are you running TDI 6.1 or 6.1.1? What is your fixpack level?
>>Also, can you try using the JDBC drivers provided by your DB2 database
>>(instead of those provided by TDI?)
>>
>>Cheers,
>>
>>Christian
>>
>>Jacky Cheung wrote:
>>
>>>Dear all,
>>>
>>>My TDI version is 6.1 (Fixpack 2)
>>>
>>>I have a problem during using JDBCconnector to read db2 table. When
the
>>>connector read the CLOB field with null value in the record, it
throws
>>>the
>>>following exception:
>>>
>>>java.lang.NullPointerException
>>> at com.ibm.di.connector.JDBCConnector$SqlMap.buildEntry(Unknown
Source)
>>> at com.ibm.di.connector.JDBCConnector.getNextEntry(Unknown Source)
>>> at com.ibm.di.server.AssemblyLineComponent.getnext(Unknown Source)
>>> at com.ibm.di.server.AssemblyLine.msGetNextIteratorEntry(Unknown
Source)
>>> at com.ibm.di.server.AssemblyLine.executeMainStep(Unknown Source)
>>> at com.ibm.di.server.AssemblyLine.executeMainLoop(Unknown Source)
>>> at com.ibm.di.server.AssemblyLine.executeMainLoop(Unknown Source)
>>> at com.ibm.di.server.AssemblyLine.executeAL(Unknown Source)
>>> at com.ibm.di.server.AssemblyLine.run(Unknown Source)
>>>15:23:03 CTGDIS266E Error in NextIteratorEntry. Exception
occurred:
>>>java.lang.NullPointerException
>>>java.lang.NullPointerException
>>> at com.ibm.di.connector.JDBCConnector$SqlMap.buildEntry(Unknown
Source)
>>> at com.ibm.di.connector.JDBCConnector.getNextEntry(Unknown Source)
>>> at com.ibm.di.server.AssemblyLineComponent.getnext(Unknown Source)
>>> at com.ibm.di.server.AssemblyLine.msGetNextIteratorEntry(Unknown
Source)
>>> at com.ibm.di.server.AssemblyLine.executeMainStep(Unknown Source)
>>> at com.ibm.di.server.AssemblyLine.executeMainLoop(Unknown Source)
>>> at com.ibm.di.server.AssemblyLine.executeMainLoop(Unknown Source)
>>> at com.ibm.di.server.AssemblyLine.executeAL(Unknown Source)
>>> at com.ibm.di.server.AssemblyLine.run(Unknown Source)
>>>
>>>Is it a bug of TDI 6.1?
>>>
>>>Thanks and Regards,
>>>Jacky
>>>
>>>
>
|
| Post Reply
|
| Re: Problem of reading DB2 CLOB column |
 |
Wed, 9 Jan 2008 11:29:37 +0800 |
Dear Christian,
I have asked my client to open a PMR.
Thank you very much
Regards,
Jacky
"Christian Chateauvieux" <christian.chateauvieux@fr.ibm.com>
wrote in
message news:flvecp$1ro3i$1@news.boulder.ibm.com...
> Jacky,
>
> can you open a PMR with IBM support? This looks like a product defect
> and the best way to get it fixed is via the support team.
>
> Thanks,
>
> Christian
>
> Jacky wrote:
> > Dear Christian,
> >
> > My TDI version is 6.1. I have installed Fixpack 2 and can't solve the
> > problem. I think the fixpack only fixes BLOB problem but not CLOB
problem.
> >
> > I have tried to copy the db2jcc.jar from IBM DB2
(/sqllib/java/db2jcc.jar)
> > to replace db2jcc.jar of TDI but it doesn't solve the problem.
> >
> > Thanks and Regards,
> > Jacky
> >
> >
> > "Christian Chateauvieux"
<christian.chateauvieux@fr.ibm.com> wrote in
> > message news:fltah6$1ms7i$1@news.boulder.ibm.com...
> >
> >>Jacky,
> >>
> >>I can see that TDI 6.1 Fixpack 2 fixes a problem around reading
NULL
> >>BLOBs.
> >>Are you running TDI 6.1 or 6.1.1? What is your fixpack level?
> >>Also, can you try using the JDBC drivers provided by your DB2
database
> >>(instead of those provided by TDI?)
> >>
> >>Cheers,
> >>
> >>Christian
> >>
> >>Jacky Cheung wrote:
> >>
> >>>Dear all,
> >>>
> >>>My TDI version is 6.1 (Fixpack 2)
> >>>
> >>>I have a problem during using JDBCconnector to read db2 table.
When the
> >>>connector read the CLOB field with null value in the record, it
throws
> >>>the
> >>>following exception:
> >>>
> >>>java.lang.NullPointerException
> >>> at
com.ibm.di.connector.JDBCConnector$SqlMap.buildEntry(Unknown
Source)
> >>> at com.ibm.di.connector.JDBCConnector.getNextEntry(Unknown
Source)
> >>> at com.ibm.di.server.AssemblyLineComponent.getnext(Unknown
Source)
> >>> at
com.ibm.di.server.AssemblyLine.msGetNextIteratorEntry(Unknown
Source)
> >>> at com.ibm.di.server.AssemblyLine.executeMainStep(Unknown
Source)
> >>> at com.ibm.di.server.AssemblyLine.executeMainLoop(Unknown
Source)
> >>> at com.ibm.di.server.AssemblyLine.executeMainLoop(Unknown
Source)
> >>> at com.ibm.di.server.AssemblyLine.executeAL(Unknown Source)
> >>> at com.ibm.di.server.AssemblyLine.run(Unknown Source)
> >>>15:23:03 CTGDIS266E Error in NextIteratorEntry. Exception
occurred:
> >>>java.lang.NullPointerException
> >>>java.lang.NullPointerException
> >>> at
com.ibm.di.connector.JDBCConnector$SqlMap.buildEntry(Unknown
Source)
> >>> at com.ibm.di.connector.JDBCConnector.getNextEntry(Unknown
Source)
> >>> at com.ibm.di.server.AssemblyLineComponent.getnext(Unknown
Source)
> >>> at
com.ibm.di.server.AssemblyLine.msGetNextIteratorEntry(Unknown
Source)
> >>> at com.ibm.di.server.AssemblyLine.executeMainStep(Unknown
Source)
> >>> at com.ibm.di.server.AssemblyLine.executeMainLoop(Unknown
Source)
> >>> at com.ibm.di.server.AssemblyLine.executeMainLoop(Unknown
Source)
> >>> at com.ibm.di.server.AssemblyLine.executeAL(Unknown Source)
> >>> at com.ibm.di.server.AssemblyLine.run(Unknown Source)
> >>>
> >>>Is it a bug of TDI 6.1?
> >>>
> >>>Thanks and Regards,
> >>>Jacky
> >>>
> >>>
> >
> >
|
| Post Reply
|
|
|
|
|
|
|
|
|
|