# JDBC driver keyword/syntax issue

**URL:** <https://forum.inductiveautomation.com/t/jdbc-driver-keyword-syntax-issue/7755>\
**Category:** Ignition\
**Created:** [December 23, 2013, 3:50pm UTC](https://forum.inductiveautomation.com/t/jdbc-driver-keyword-syntax-issue/7755 "2013-12-23T15:50:49Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![markdobtech](https://avatars.discourse-cdn.com/v4/letter/m/71e660/32.png) [@markdobtech](https://forum.inductiveautomation.com/u/markdobtech)\
**Post date:** [December 23, 2013, 3:50pm UTC](https://forum.inductiveautomation.com/t/jdbc-driver-keyword-syntax-issue/7755/1 "2013-12-23T15:50:49Z")

</div>

Using FoxPro connected via JDataConnect, the following error is returned. Test was performed with Designer db tool. Also noted, the schema does not return the column names as keyword ‘COLUMN\_SIZE’ is not recognized. Any ideas?

`ERROR [QueryBrowser$5$3-AWT-EventQueue-0] <HTML>Error running query:<br>SELECT * FROM mmrawmat<br>ServerException:[ODBC Error], SQLExecDirect DBVendorCode:219:, DBState:37000:. [Microsoft][ODBC Visual FoxPro Driver]Command contains unrecognized phrase/keyword. 
com.inductiveautomation.ignition.client.gateway_interface.GatewayException: ServerException:[ODBC Error], SQLExecDirect DBVendorCode:219:, DBState:37000:. [Microsoft][ODBC Visual FoxPro Driver]Command contains unrecognized phrase/keyword. 
                at com.inductiveautomation.ignition.client.gateway_interface.GatewayInterface.newGatewayException(GatewayInterface.java:313)
                at com.inductiveautomation.ignition.client.gateway_interface.GatewayInterface.sendMessage(GatewayInterface.java:287)
                at com.inductiveautomation.ignition.client.gateway_interface.GatewayInterface.sendMessage(GatewayInterface.java:244)
                at com.inductiveautomation.ignition.client.gateway_interface.GatewayInterface.runLimitQuery(GatewayInterface.java:712)
               at com.inductiveautomation.ignition.designer.querybrowser.QueryBrowser$5.run(QueryBrowser.java:401)
                at java.lang.Thread.run(Unknown Source)
Caused by: java.sql.SQLException: ServerException:[ODBC Error], SQLExecDirect DBVendorCode:219:, DBState:37000:. [Microsoft][ODBC Visual FoxPro Driver]Command contains unrecognized phrase/keyword. 
                at JData4_0.sql.$Connection.FromServer(null)
                at JData4_0.sql.$Connection.ToServer(null)
                at JData4_0.sql.$Statement.Send(null)
                at JData4_0.sql.$Statement.DoExecute(null)
                at JData4_0.sql.$Statement.executeQuery(null)
                at org.apache.commons.dbcp.DelegatingStatement.executeQuery(DelegatingStatement.java:208)
                at com.inductiveautomation.ignition.gateway.datasource.DelegatingStatement.executeQuery(DelegatingStatement.java:63)
                at com.inductiveautomation.ignition.gateway.datasource.SRConnectionWrapper$SRStatement.executeQuery(SRConnectionWrapper.java:655)
                at com.inductiveautomation.ignition.gateway.servlets.gateway.functions.RunQuery.run(RunQuery.java:98)
                at com.inductiveautomation.ignition.gateway.servlets.gateway.functions.AbstractDBAction.invoke(AbstractDBAction.java:76)
                at com.inductiveautomation.ignition.gateway.servlets.Gateway.doPost(Gateway.java:373)
                at javax.servlet.http.HttpServlet.service(HttpServlet.java:637)
                at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
                at com.inductiveautomation.ignition.gateway.bootstrap.MapServlet.service(MapServlet.java:85)
                at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
                at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
                at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
                at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
                at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
                at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:103)
                at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
                at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:293)
                at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:861)
                at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:606)
                at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489)
                at java.lang.Thread.run(null)
`

---

<div class="post-metadata">

**Author:** ![greg.simpson](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/greg.simpson/32/3135_2.png) [@greg.simpson](https://forum.inductiveautomation.com/u/greg.simpson)\
**Post date:** [December 31, 2013, 2:39pm UTC](https://forum.inductiveautomation.com/t/jdbc-driver-keyword-syntax-issue/7755/2 "2013-12-31T14:39:54Z")

</div>

I did a little poking around in the forums and came up with this thread. I don’t know if you have seen it or not, but it may be of some use.

[inductiveautomation.com/forum/vi … =70&t=5960](http://inductiveautomation.com/forum/viewtopic.php?f=70&t=5960)

In this thread Carl suggests using a JDBC driver versus going the ODBC route. You might want to give this a try.

---

<div class="post-metadata">

**Author:** ![markdobtech](https://avatars.discourse-cdn.com/v4/letter/m/71e660/32.png) [@markdobtech](https://forum.inductiveautomation.com/u/markdobtech)\
**Post date:** [January 2, 2014, 4:44pm UTC](https://forum.inductiveautomation.com/t/jdbc-driver-keyword-syntax-issue/7755/3 "2014-01-02T16:44:53Z")

</div>

I think what you are saying is to use a JDBC Type 4 vs any other JDBC Type (1-3) driver? Thanks for the clarification.