Databases
StackOverflow2013
Postsdbo
POdbf CREATE TABLE throws java.sql.SQLException: Syntax error: Stopped parse at
Body
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POdbf CREATE TABLE throws java.sql.SQLException: Syntax error: Stopped parse at
    text
    copied!<p>I have a dbf file, and I can see in the view that types of intersting fields are L ( I suppose it is logical type ) and M (I suppose it's a Memo type)</p> <p>I try to recreate dbf template using dbf_jdbc, like table:</p> <pre><code> private static final String TABLE = "create table SAMPLE ( " + " SM Logical, " + " PRIM MEMO " + ")"; ... String url = "jdbc:DBF:/C:\\TEST"; Connection dbfConn = null; PreparedStatement ps = null; ... // instantiate it Class.forName( "com.hxtt.sql.dbf.DBFDriver" ).newInstance(); dbfConn = DriverManager.getConnection( url, properties ); Statement stmt = dbfConn.createStatement(); stmt.executeUpdate(TABLE); </code></pre> <p>But i'm getting the following error:</p> <pre><code>java.sql.SQLException: Syntax error: Stopped parse at MEMO java.sql.SQLException: Syntax error: Stopped parse at LOGICAL </code></pre> <p>The reason - type names, because when I use varchar, everythins is fine.</p> <p>Dbf_jdbc version (from jar manifest file):</p> <pre><code>Manifest-Version: 1.0 Created-By: HXTT Version Robot Main-Class: com.hxtt.sql.admin.Admin Name: com/hxtt/sql/dbf/ Specification-Title: HXTT DBF JDBC 3.0 Package Implementation-Title: com.hxtt.sql.dbf Specification-Version: 4.2.056 on April 01, 2009 Specification-Vendor: Hongxin Technology &amp; Trade Ltd. Comment: JDBC 3.0 Package for Xbase database Implementation-Version: 4.2.056 on April 01, 2009 Implementation-Vendor: Hongxin Technology &amp; Trade Ltd. Implementation-URL: http://www.hxtt.com/dbf.html Name: com/hxtt/sql/admin/ Specification-Title: HXTT Database Admin Implementation-Title: com.hxtt.sql.admin Specification-Vendor: Hongxin Technology &amp; Trade Ltd. Specification-Version: 0.5 on April 01, 2009 Comment: HXTT Database Admin Implementation-Version: 0.5 on April 01, 2009 Implementation-Vendor: Hongxin Technology &amp; Trade Ltd. Implementation-URL: http://www.hxtt.com/dbf/dbadmin.html </code></pre> <p>So my question is <strong>which sql type should I use so I could create dbf template using code and when I open a file using dbf viewer I could see letters M and L as type shortnames.</strong></p>
 

Querying!

 
Guidance
An individual column

Larger individual text columns get their own page to allow for proper reading.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload