jdbc code not returning any errors but log showing errors

[afrieden]

Not getting any problems with code but errors in log.  I have one vdb named 'vcf' and is a database on mongodb through mongodb-vdb.xml which is deployed.  Attached is my server log and my code, where are these reset by peer errors coming from?  Thanks!

[rareddy]

Close the connection properly you made in the first line in your groovy script then the error goes away.

[afrieden]

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

[rareddy]

What are the Java, Teiid, JBoss EAP, Groovy and OS versions that you are using? I can not seem to re-create it.

[afrieden]

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)

[rareddy]

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.

[afrieden]

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. 

[rareddy]

The code stack looked like it is *not* JBoss EAP 6.1.0 Alpha, thus my question

[afrieden]

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

[rareddy]

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..

[afrieden]

got it working thanks!