Bug 780829 (SOA-3279)

Summary: Executing an SQL statement over ODBC interface does not respond
Product: [JBoss] JBoss Enterprise SOA Platform 5 Reporter: Pavel Macik <pmacik>
Component: EDSAssignee: Van Halbert <vhalbert>
Status: CLOSED NEXTRELEASE QA Contact:
Severity: urgent Docs Contact:
Priority: urgent    
Version: 5.2.0.ER2, 5.2.0.ER3CC: pmacik
Target Milestone: ---   
Target Release: 5.2.0 GA, 5.2.0.ER4   
Hardware: Unspecified   
OS: Unspecified   
URL: http://jira.jboss.org/jira/browse/SOA-3279
Whiteboard:
Fixed In Version: Doc Type: Bug Fix
Doc Text:
Story Points: ---
Clone Of: Environment:
Last Closed: 2011-10-05 12:53:07 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:
Attachments:
Description Flags
odbc-reproducer.zip
none
teiid-520ER2.log.zip none

Description Pavel Macik 2011-08-18 14:04:00 UTC 
project_key: SOA

When one tries to execute an SQL query using ODBC interface of EDS it the execution get stuck in the phase of waiting for results from EDS.

An ODBC connection from client is established, a query is sent to EDS, EDS executes the query against the underlying Oracle DB, EDS receives the response from the DB, but does not return the response back to the ODBC client...

To reproduce:

1) deploy perf.vdb from resources into SOA-P
2) start SOA-P
3) unzip odbc-reproducer.zip
4) execute clean.sh
5) execute build.sh
6) configure SERVER and ODBC_DRIVER according to your SOA-P and ODBC installation in the run-test.sh script file
7) execute run-test.sh

Resources (*-ds.xml, *.sql schema and perf.vdb) can be found here https://svn.devel.redhat.com/repos/jboss-soa/trunk/qa/tests/teargas/performance/eds/resources/
Comment 1 Pavel Macik 2011-08-18 14:05:04 UTC 
Attaching the reproducer and Teiid (EDS) log from the test.
Comment 2 Pavel Macik 2011-08-18 14:05:04 UTC 
Attachment: Added: odbc-reproducer.zip
Attachment: Added: teiid-520ER2.log.zip
Comment 3 Van Halbert 2011-08-18 14:41:59 UTC 
Link: Added: This issue Cloned to SOA-3280
Comment 4 Pavel Macik 2011-08-18 14:43:29 UTC 
I also tried to use JDBC-ODBC bridge (sun.jdbc.odbc.JdbcOdbcDriver) and it behaves the same.
Comment 6 David Le Sage 2011-08-25 23:12:35 UTC 
Release Notes Docs Status: Added: Not Required
Writer: Added: dlesage
Comment 7 Pavel Macik 2011-10-05 12:53:07 UTC 
Verified with 520ER4