Parsing error thrown when connecting to Teiid via ODBC

Solution Verified - Updated -

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.

Current Customers and Partners

Log in for full access

Log In

New to Red Hat?

Learn more about Red Hat subscriptions

Using a Red Hat product through a public cloud?

How to access this content