-
1. Re: jdbc code not returning any errors but log showing errors
Close the connection properly you made in the first line in your groovy script then the error goes away.
-
2. Re: Re: jdbc code not returning any errors but log showing errors
Thanks, added that but still no results. I am also not seeing any errors, just what looks like a command to run a query in the logs. I have attached updated log and code. Thanks
-
3. Re: Re: jdbc code not returning any errors but log showing errors
What are the Java, Teiid, JBoss EAP, Groovy and OS versions that you are using? I can not seem to re-create it.
-
4. Re: Re: jdbc code not returning any errors but log showing errors
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
jboss-eap-6.1
Red Hat Enterprise Linux Server release 5.5 (Tikanga)
-
5. Re: Re: jdbc code not returning any errors but log showing errors
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.
-
6. Re: Re: jdbc code not returning any errors but log showing errors
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.
-
7. Re: Re: jdbc code not returning any errors but log showing errors
The code stack looked like it is *not* JBoss EAP 6.1.0 Alpha, thus my question
-
8. Re: Re: Re: jdbc code not returning any errors but log showing errors
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
-
9. Re: Re: Re: jdbc code not returning any errors but log showing errors
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.
Ramesh..
-