Four Stars

Null values when reading DateTime2 Field

Hello,

When reading datetime2 fields with tMSSqlInput, all the date values come as null.

I even specify the date pattern "yyyy-MM-dd HH:mm:ss.SSS" in the schema definition, but to no avail.

I have also tried the tMSSqlRow component and it produces the same results.

 

I would appreciate your help in fixing this issue.

 

Best regards

  • Data Integration
1 ACCEPTED SOLUTION

Accepted Solutions
Employee Ram
Employee

Re: Null values when reading DateTime2 Field

You might using Microsoft driver. With jtds you might get Not null
2 REPLIES
Employee Ram
Employee

Re: Null values when reading DateTime2 Field

You might using Microsoft driver. With jtds you might get Not null
Four Stars

Re: Null values when reading DateTime2 Field

Yes i'm using the Microsoft jdbc driver as required per the MSSqlInput component. There is data in the table that I'm querying, but it simply comes as null. 

 

Another odd, perhaps unrelated, behaviour, is that when I press guess schema based on the query, Talend produces the following error "class not found net.sourceforge.jtds.jdbc.driver". Is there something wrong with the installation?

 

Edit: Using a jtds jdbc connection to the MsSqlServer fixes the datetime related issue.