Close the connection properly you made in the first line in your groovy script then the error goes away.
What are the Java, Teiid, JBoss EAP, Groovy and OS versions that you are using? I can not seem to re-create it.
Java(TM) SE Runtime Environment (build 1.6.0_18-b07)
Groovy Version: 1.8.5 JVM: 1.6.0_18 Vendor: Sun Microsystems Inc. OS: Linux
Red Hat Enterprise Linux Server release 5.5 (Tikanga)
What is the Teiid version? May be you are using mixed versions, like client is one version and server is another. From your stack you are not using Teiid, but the DV version, not sure if you used the same version of the client with your groovy. Check and make sure you use same versions.
You also try to see if you can reproduce this with java 1.7, then we can trace back.
Using teiid-8.8.1-jdbc.jar for jdbc driver. I am using teiid 8.8.1. I got that version from looking at the admin console and saw teiid-odata-8.8.1.war. Will upgrade to java 1.7 and try that.
The code stack looked like it is *not* JBoss EAP 6.1.0 Alpha, thus my question
Not sure if it is Alpha, but it is DEFINITELY 6.1 JBoss EAP.
At the end of the log I found this:
11:22:06,742 WARN [org.teiid.CONNECTOR] (Worker0_QueryProcessorQueue0) oftbc6+u/zZK TEIID30003 Without required support property SelfJoins, pushdown will not be enabled for TableAlias on translator [mongodb, java:/mongoDS].
11:22:06,865 INFO [org.teiid.CONNECTOR] (Worker1_QueryProcessorQueue1) oftbc6+u/zZK SELECT Record.record_id AS c_0, Record.position AS c_1, Record.contig AS c_2, Record.reference AS c_3, Record.alternate AS c_4, Record.variant AS c_5, Record.ordered AS c_6, Record.version AS c_7 FROM Record
Would the SelfJoins cause teiid to not work? The jdbc is throwing no errors and I am not seeing errors in the log. I have tried this with java 6 and 7 and both show no symptoms but don't run any queries.
I have attached all pieces I am using
Ok, you are running JBoss EAP 6.1.0.GA. Not EAP 6.1.Alpha. But I do not see any errors in startup, which is good. The VDB looks good, resource-adapter configuration looks good. I do not see the errors you had in the previous logs that is good. Now, when you say "don't run any queries" what do you mean by that? Do do not see any data coming back? you see errors when you execute?
BTW, the "record" table you are working with does it have any data? Try a "insert" first then a "select" query. Or you can also use "mongo" command line shell to insert the values too, but need to be in the form that is expected by Teiid.
got it working thanks!