db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Patrick Meyer" <meyer...@gmail.com>
Subject CREATE TABLE lexical error
Date Sat, 19 Apr 2014 01:34:53 GMT
I have an application that allows users to import data into Derby. As such, the users specify
the column names. A user encountered a lexical error message that I have been able to reproduce
with the following CREATE TABLE statements. Can anyone explain why the column names appear
to be causing a lexical error and how to avoid it? I am using 10.9.1.

 

These two statements result in errors:

 

CREATE TABLE TBLPAT1 (xb1x DOUBLE, xb2x DOUBLE) 

Error: Lexical error at line 1, column 24.  Encountered: "\ufeff" (65279), after : "".

 

CREATE TABLE TBLPAT2 (xb1x VARCHAR(50), xb2x VARCHAR(50)) 

Error: Lexical error at line 1, column 24.  Encountered: "\ufeff" (65279), after : "".

SQLState:  42X02

ErrorCode: 30000

 

 

These statements work just fine.

 

CREATE TABLE TBLPAT3 (xvar1x DOUBLE, xvar2x DOUBLE) 

 

CREATE TABLE TBLPAT4 (xvar1x VARCHAR(50), xvar2x DOUBLE) 

 

CREATE TABLE TBLPAT5 (xvar1x VARCHAR(50), xvar2x VARCHAR(50))

 

 

Thanks,

Patrick

 


Mime
View raw message