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/