[
https://issues.jboss.org/browse/TEIID-5363?page=com.atlassian.jira.plugin...
]
Pranav K commented on TEIID-5363:
---------------------------------
Thanks Steve. But I am not really sure whether this workaround would solve the problem,
looking at where exactly I am facing the issue. I am facing the issue in
SimpleDBConnectionImpl.getAttributeNames. This method gets called from my class (which is
similar to SimpleDBMetadataProcessor) with domain names which are obtained from a previous
call SimpleDBConnectionImpl.getDomains (which returns non-quoted domain names). When this
non-quoted domain name gets passed to getAttributeNames, it leads to a failure -- so when
I essentially don't have the attributeNames yet, I can't quote them in the
nameInSource property and proceed.
Here's the stacktrace for the error I am talking about:
Caused by: com.amazonaws.services.simpledb.model.InvalidQueryExpressionException: The
specified query expression syntax is not valid. (Service: AmazonSimpl
eDB; Status Code: 400; Error Code: InvalidQueryExpression; Request ID:
b8d60ae4-9488-6f0e-214c-da4ff404dbb3)
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.getAttributeNames(SimpleDBConnectionImpl.java:90)
at
com.test.simpledb.SimpleDBMetadataProvider.getColumnMetadata(SimpleDBMetadataProvider.java:100)
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)