Just to add on, Here is a quick code I use to connect to Drill. Hope it helps-
https://gist.github.com/yssharma/8b72557ad23f080e7c1f Best On Sun, Jul 26, 2015 at 9:44 PM, Yash Sharma <[email protected]> wrote: > Hi Ahmed, > Could you paste the code here or in pastebin/gist. > Mail attachments do not work. > > Best > > On Sun, Jul 26, 2015 at 9:22 PM, Anas Mesrah <[email protected]> > wrote: > >> Hi All, >> >> We have been able to connect peacefully to drill 0.8.0 using JDBC. When >> we tried to upgrade and use the latest jsdbc driver, we got the following >> eception: >> >>> Exception in thread "main" java.lang.ClassCastException: >>> org.apache.drill.jdbc.impl.DrillJdbc41Factory$DrillJdbc41PreparedStatement >>> cannot be cast to org.apache.drill.jdbc.impl.DrillStatementImpl >>> at org.apache.drill.jdbc.impl.DrillJdbc41Factory.newResultSet( >>> DrillJdbc41Factory.java:106) >>> at org.apache.drill.jdbc.impl.DrillJdbc41Factory.newResultSet( >>> DrillJdbc41Factory.java:1) >>> at net.hydromatic.avatica.AvaticaConnection.executeQueryInternal( >>> AvaticaConnection.java:397) >>> at net.hydromatic.avatica.AvaticaPreparedStatement.executeQuery( >>> AvaticaPreparedStatement.java:77) >>> at com.incorta.trails.DrillTest.query(DrillTest.java:33) >>> at com.incorta.trails.DrillTest.main(DrillTest.java:12) >> >> The original code still connects to 0.8.0 without errors. Attached the >> java test file that I used to replicate the problem. >> >> Appreciate anyone's help to resolve this issue. >> >> Thanks >> -- >> >> *Best Regards,* >> >> *Anas Mosaad ** <https://eg.linkedin.com/pub/anas-mesrah/1b/93/60a>* >> *Senior Software Engineer, * >> *Incorta Inc* >> *Mob. +201007434510* >> >> >> >
