Parsing error thrown when connecting to Teiid via ODBC
Issue
Connecting to Teiid using isql as follows:
isql DSN-NAME [USERNAME PASSWORD] < commands.sql
The following error is seen at client machine.
/opt/app/mi>isql dsn_name < a.sql
Segmentation fault
On server logs, its shows error as:
2012-09-24 05:48:20,866 DEBUG [xxxx] (New I/O server worker #3-3) sucessfully logged
2012-09-24 05:48:20,866 DEBUG [xxxx] (New I/O server worker #3-3) sucessfully logged
2012-09-24 05:48:20,861 DEBUG [org.teiid.COMMAND_LOG] (New I/O server worker #3-3) START USER COMMAND: startTime=2012-09-24 05:48:20.861 requestID=1RYQcmJLCLA3.1 txID=null sessionID=1RYQcmJLCLA3 applicationName=ODBC principal=app-xxx@teiid-security vdbName=xxx vdbVersion=1 sql=set extra_float_digits to 2
2012-09-24 05:48:20,872 DEBUG [xxxx] (Worker12_QueryProcessorQueue215) sucessfully logged
2012-09-24 05:48:20,872 DEBUG [xxxx] (Worker12_QueryProcessorQueue215) sucessfully logged
2012-09-24 05:48:20,867 DEBUG [org.teiid.COMMAND_LOG] (Worker12_QueryProcessorQueue215) ERROR USER COMMAND: endTime=2012-09-24 05:48:20.867 requestID=1RYQcmJLCLA3.1 txID=null sessionID=1RYQcmJLCLA3 principal=app-xxx@teiid-security vdbName=xxx vdbVersion=1 finalRowCount=null
2012-09-24 05:48:20,873 WARN [org.teiid.PROCESSOR] (Worker12_QueryProcessorQueue215) Processing exception 'Parsing error: Encountered "set" at line 1, column 1.
Was expecting one of:
"alter" ...
"call" ...
"create" ...
"delete" ...
"drop" ...
"exec" ...
"execute" ...
"insert" ...
"select" ...
"table" ...
"update" ...
"with" ...
"(" ...
"{" ...
' for request 1RYQcmJLCLA3.1. Exception type org.teiid.api.exception.query.QueryParserException thrown from org.teiid.query.parser.QueryParser.convertParserException(QueryParser.java:189). Enable more detailed logging to see the entire stacktrace.
2012-09-24 05:48:20,919 DEBUG [xxxx] (New I/O server worker #3-3) sucessfully logged
The same error is seen even if the commands.sql file is empty.
Environment
JBoss Enterprise Data Services Platform
5.2/5.3
Subscriber exclusive content
A Red Hat subscription provides unlimited access to our knowledgebase, tools, and much more.