[
https://issues.jboss.org/browse/TEIID-5363?page=com.atlassian.jira.plugin...
]
Pranav K commented on TEIID-5363:
---------------------------------
I updated to 10.3.2 after which I could create the source model, deploy the VDB atop that.
But I am getting that similar error when I try to run a 'select * from
<tableNameContainingHyphen>' query on the VDB. I am using Teiid embedded here
and querying using the TeiidDriver (not that that makes a difference in this case). Are
you getting this too?
Stacktrace:
[CONNECTOR] Connector worker process failed for atomic-request=0KTrLms0orhj.0.1.0
org.teiid.translator.TranslatorException: The specified query expression syntax is not
valid. (Service: AmazonSimpleDB; Status Code: 400; Error Code: InvalidQueryExpression;
Request ID: a1cd638d-9563-746f-a51a-fbd1c6e244fd)
at
org.teiid.resource.adapter.simpledb.SimpleDBConnectionImpl.performSelect(SimpleDBConnectionImpl.java:151)
at
com.testapp.simpledb.SimpleDBMetadataConnection.performSelect(SimpleDBMetadataConnection.java:100)
at
org.teiid.translator.simpledb.SimpleDBQueryExecution.executeDirect(SimpleDBQueryExecution.java:77)
at
org.teiid.translator.simpledb.SimpleDBQueryExecution.execute(SimpleDBQueryExecution.java:69)
at
org.teiid.dqp.internal.datamgr.ConnectorWorkItem.execute(ConnectorWorkItem.java:358)
Caused by: com.amazonaws.services.simpledb.model.InvalidQueryExpressionException: The
specified query expression syntax is not valid. (Service: AmazonSimpleDB; Status Code:
400; Error Code: InvalidQueryExpression; Request ID:
a1cd638d-9563-746f-a51a-fbd1c6e244fd)
at
com.amazonaws.http.AmazonHttpClient.handleErrorResponse(AmazonHttpClient.java:1305)
at
com.amazonaws.http.AmazonHttpClient.executeOneRequest(AmazonHttpClient.java:852)
at com.amazonaws.http.AmazonHttpClient.executeHelper(AmazonHttpClient.java:630)
at com.amazonaws.http.AmazonHttpClient.doExecute(AmazonHttpClient.java:405)
at
com.amazonaws.http.AmazonHttpClient.executeWithTimer(AmazonHttpClient.java:367)
at com.amazonaws.http.AmazonHttpClient.execute(AmazonHttpClient.java:318)
at
com.amazonaws.services.simpledb.AmazonSimpleDBClient.doInvoke(AmazonSimpleDBClient.java:1039)
at
com.amazonaws.services.simpledb.AmazonSimpleDBClient.invoke(AmazonSimpleDBClient.java:1009)
at
com.amazonaws.services.simpledb.AmazonSimpleDBClient.select(AmazonSimpleDBClient.java:958)
at
org.teiid.resource.adapter.simpledb.SimpleDBConnectionImpl.performSelect(SimpleDBConnectionImpl.java:149)
SimpleDB connector not quoting table names in internal Select
queries
---------------------------------------------------------------------
Key: TEIID-5363
URL:
https://issues.jboss.org/browse/TEIID-5363
Project: Teiid
Issue Type: Bug
Components: Misc. Connectors
Reporter: Pranav K
Assignee: Steven Hawkins
Fix For: 11.0, 10.3.2
Facing an issue while querying the Simple DB connector for a specific type of tables -
the tables that contain a hyphen in the name.
According to the SimpleDB documentation:
Attribute and domain names may appear without quotes if they contain only letters,
numbers, underscores (_), or dollar symbols ($) and do not start with a number. You must
quote all other attribute and domain names with the backtick (`).
(
https://docs.aws.amazon.com/AmazonSimpleDB/latest/DeveloperGuide/QuotingR...)
--
This message was sent by Atlassian JIRA
(v7.5.0#75005)