[JBoss JIRA] (TEIID-5726) java.lang.NullPointerException when calling a stored procedure via Teiid
by Christoph John (Jira)
Christoph John created TEIID-5726:
-------------------------------------
Summary: java.lang.NullPointerException when calling a stored procedure via Teiid
Key: TEIID-5726
URL: https://issues.jboss.org/browse/TEIID-5726
Project: Teiid
Issue Type: Enhancement
Components: OData
Affects Versions: 12.1
Reporter: Christoph John
Assignee: Steven Hawkins
Attachments: log3.txt, srcProc.txt, svc-vdb.ddl
I try to create a function import for a stored procedure which I have in my sql database. When executing the stored procedure via mysql workbench, the stored procedure does fine.
I have described the issue in my first message in
https://developer.jboss.org/message/989044#989044
in detail. Attached you find the excerpt from the teiid error log and my vdb file. The relevant stored procedure is named srcProc and is also attached.
--
This message was sent by Atlassian Jira
(v7.12.1#712002)
5 years, 8 months
[JBoss JIRA] (TEIID-5724) Issues with Informix Date/Time types
by Steven Hawkins (Jira)
[ https://issues.jboss.org/browse/TEIID-5724?page=com.atlassian.jira.plugin... ]
Steven Hawkins edited comment on TEIID-5724 at 4/19/19 4:24 PM:
----------------------------------------------------------------
Corrected the type mappings and updated the calendar methods to either not use a calendar or to use a cloned one.
The informix client will keep date/time/timestamp values consistent with respect to calendar fields for a given client timezone - that is regardless of what the client timezone is in, a value of 2000-01-01 01:01:01 will always be displayed in the local timezone.
The database timezone property should only be set if that is not the desired behavior, and instead want the values adjusted to assume a fixed timezone.
However as noted in the older issue the informix driver for some reason seems to adjust timestamps and time values in the opposite direction. With the Teiid server in GMT (or really any timezone) a given set of row values for a query are:
Date
2000-02-19
Time
01:00:00
Timestamp
2000-01-01 00:00:49.0
With the client in GMT and the DatabaseTimezone set to GMT-1, you see:
Date
2000-02-19
Time
00:00:00
Timestamp
2000-01-01 01:00:49.0
Note the time and timestamp moved in opposite directions. I did a second commit to account for this by switching to our logic for the adjustment.
was (Author: shawkins):
Corrected the type mappings and updated the calendar methods to either not use a calendar or to use a cloned one.
The informix client will keep date/time/timestamp values consistent with respect to calendar fields for a given client timezone - that is regardless of what the client timezone is in, a value of 2000-01-01 01:01:01 will always be displayed in the local timezone.
The database timezone property should only be set if that is not the desired behavior, and instead want the values adjusted to assume a fixed timezone. However as noted in the older issue the informix driver for some reason seems to adjust timestamps and time values in the opposite direction. With the Teiid server in GMT (or really any timezone) a given set of row values for a query are:
Date
2000-02-19
Time
01:00:00
Timestamp
2000-01-01 00:00:49.0
With the client in GMT and the DatabaseTimezone set to GMT-1, you see:
Date
2000-02-19
Time
00:00:00
Timestamp
2000-01-01 01:00:49.0
Note the time and timestamp moved in opposite directions. I did not yet try to account for this assuming for now that most will want the default behavior.
> Issues with Informix Date/Time types
> ------------------------------------
>
> Key: TEIID-5724
> URL: https://issues.jboss.org/browse/TEIID-5724
> Project: Teiid
> Issue Type: Bug
> Components: JDBC Connector
> Reporter: Steven Hawkins
> Assignee: Steven Hawkins
> Priority: Major
> Fix For: 12.2, 11.2.3, 12.1.1
>
>
> Informix date/time issues include:
> Timestamp/Time are mapped to the same conversion - datetime hour to second
> The Timestamp mapping needs to be fully specified - datetime year to fraction(5), not just datetime
> Usage of the getXXX Resultset methods passing a Calendar result in odd behavior as Informix modifies that Calendar.
--
This message was sent by Atlassian Jira
(v7.12.1#712002)
5 years, 8 months
[JBoss JIRA] (TEIID-5724) Issues with Informix Date/Time types
by Steven Hawkins (Jira)
[ https://issues.jboss.org/browse/TEIID-5724?page=com.atlassian.jira.plugin... ]
Steven Hawkins resolved TEIID-5724.
-----------------------------------
Resolution: Done
Corrected the type mappings and updated the calendar methods to either not use a calendar or to use a cloned one.
The informix client will keep date/time/timestamp values consistent with respect to calendar fields for a given client timezone - that is regardless of what the client timezone is in, a value of 2000-01-01 01:01:01 will always be displayed in the local timezone.
The database timezone property should only be set if that is not the desired behavior, and instead want the values adjusted to assume a fixed timezone. However as noted in the older issue the informix driver for some reason seems to adjust timestamps and time values in the opposite direction. With the Teiid server in GMT (or really any timezone) a given set of row values for a query are:
Date
2000-02-19
Time
01:00:00
Timestamp
2000-01-01 00:00:49.0
With the client in GMT and the DatabaseTimezone set to GMT-1, you see:
Date
2000-02-19
Time
00:00:00
Timestamp
2000-01-01 01:00:49.0
Note the time and timestamp moved in opposite directions. I did not yet try to account for this assuming for now that most will want the default behavior.
> Issues with Informix Date/Time types
> ------------------------------------
>
> Key: TEIID-5724
> URL: https://issues.jboss.org/browse/TEIID-5724
> Project: Teiid
> Issue Type: Bug
> Components: JDBC Connector
> Reporter: Steven Hawkins
> Assignee: Steven Hawkins
> Priority: Major
> Fix For: 12.2, 11.2.3, 12.1.1
>
>
> Informix date/time issues include:
> Timestamp/Time are mapped to the same conversion - datetime hour to second
> The Timestamp mapping needs to be fully specified - datetime year to fraction(5), not just datetime
> Usage of the getXXX Resultset methods passing a Calendar result in odd behavior as Informix modifies that Calendar.
--
This message was sent by Atlassian Jira
(v7.12.1#712002)
5 years, 8 months
[JBoss JIRA] (TEIID-5724) Issues with Informix Date/Time types
by Steven Hawkins (Jira)
Steven Hawkins created TEIID-5724:
-------------------------------------
Summary: Issues with Informix Date/Time types
Key: TEIID-5724
URL: https://issues.jboss.org/browse/TEIID-5724
Project: Teiid
Issue Type: Bug
Components: JDBC Connector
Reporter: Steven Hawkins
Assignee: Steven Hawkins
Fix For: 12.2, 11.2.3, 12.1.1
Informix date/time issues include:
Timestamp/Time are mapped to the same conversion - datetime hour to second
The Timestamp mapping needs to be fully specified - datetime year to fraction(5), not just datetime
Usage of the getXXX Resultset methods passing a Calendar result in odd behavior as Informix modifies that Calendar.
--
This message was sent by Atlassian Jira
(v7.12.1#712002)
5 years, 8 months