Bug 780829 (SOA-3279) - Executing an SQL statement over ODBC interface does not respond
Summary: Executing an SQL statement over ODBC interface does not respond
Keywords:
Status: CLOSED NEXTRELEASE
Alias: SOA-3279
Product: JBoss Enterprise SOA Platform 5
Classification: JBoss
Component: EDS
Version: 5.2.0.ER2,5.2.0.ER3
Hardware: Unspecified
OS: Unspecified
urgent
urgent
Target Milestone: ---
: 5.2.0 GA,5.2.0.ER4
Assignee: Van Halbert
QA Contact:
URL: http://jira.jboss.org/jira/browse/SOA...
Whiteboard:
Depends On:
Blocks:
TreeView+ depends on / blocked
 
Reported: 2011-08-18 14:04 UTC by Pavel Macik
Modified: 2011-10-05 12:53 UTC (History)
1 user (show)

Fixed In Version:
Doc Type: Bug Fix
Doc Text:
Clone Of:
Environment:
Last Closed: 2011-10-05 12:53:07 UTC
Type: Bug

Attachments (Terms of Use)
odbc-reproducer.zip (10.95 KB, application/zip)
2011-08-18 14:05 UTC, Pavel Macik 		no flags Details
teiid-520ER2.log.zip (21.96 KB, application/zip)
2011-08-18 14:05 UTC, Pavel Macik 		no flags Details
View All Add an attachment (proposed patch, testcase, etc.)


Links
System ID Private Priority Status Summary Last Updated
Red Hat Issue Tracker SOA-3279 0 None None None Never
Red Hat Issue Tracker TEIID-1719 0 None None None Never

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
Note You need to log in before you can comment on or make changes to this bug.