Bug 780544 (SOA-2977)

Summary: In Designer, the default data type length could cause issues when accessing EDS via ODBC
Product: [JBoss] JBoss Enterprise SOA Platform 5 Reporter: Van Halbert <vhalbert>
Component: Tooling, EDSAssignee: Ted Jones <tejones>
Status: CLOSED NEXTRELEASE QA Contact:
Severity: urgent Docs Contact:
Priority: urgent    
Version: 5.1.0 GA   
Target Milestone: ---   
Target Release: JBDS, 5.2.0 ER1   
Hardware: Unspecified   
OS: Unspecified   
URL: http://jira.jboss.org/jira/browse/SOA-2977
Whiteboard:
Fixed In Version: Doc Type: Bug Fix
Doc Text:
Story Points: ---
Clone Of: Environment:
Last Closed: 2011-11-07 16:07:37 UTC Type: Bug
Regression: --- Mount Type: ---
Documentation: --- CRM:
Verified Versions: Category: ---
oVirt Team: --- RHEL 7.3 requirements from Atomic Host:
Cloudforms Team: --- Target Upstream Version:

Description Van Halbert 2011-03-15 15:42:37 UTC 
project_key: SOA

Customers that are building VDB's to be accessed via ODBC will be wrong when the MAX_INT default is used.   The following exception will be seen in the server log when this occurs:

1 [FunctionExecutionException] ERR.015.001.0033: Error Code:ERR.015.001.0033 Message:Error converting [2,097,152] of type integer to type short
2 [TransformationException]The Integer value '2,097,152' is outside the of range for Short
	at org.teiid.query.function.FunctionDescriptor.invokeFunction(FunctionDescriptor.java:259)
	at org.teiid.query.eval.Evaluator.evaluate(Evaluator.java:969)
	at org.teiid.query.eval.Evaluator.internalEvaluate(Evaluator.java:633)
	at org.teiid.query.eval.Evaluator.evaluate(Evaluator.java:603)
	... 39 more
Comment 1 Van Halbert 2011-03-16 15:56:01 UTC 
Link: Added: This issue Cloned to SOA-2980
Comment 2 Van Halbert 2011-03-17 13:28:56 UTC 
Link: Added: This issue depends TEIID-1506
Comment 3 Van Halbert 2011-05-11 19:33:49 UTC 
With the completion of TEIID-1506, this issue is resolved.
Comment 4 David Le Sage 2011-09-01 03:45:33 UTC 
Release Notes Docs Status: Added: Documented as Resolved Issue
Writer: Added: dlesage
Release Notes Text: Added: https://issues.jboss.org/browse/SOA-2977

Customers that built virtual databases that were accessed via ODBC would see the following Exception in the error logwhen the MAX_INT default was used: FunctionExecutionException. A code fix has been applied to resolve this issue.
Comment 5 Paul Nittel 2011-11-07 16:07:37 UTC 
Tested and closed.