You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@eagle.apache.org by "ASF GitHub Bot (JIRA)" <ji...@apache.org> on 2016/06/03 13:41:59 UTC
[jira] [Commented] (EAGLE-319) java.sql.SQLSyntaxErrorException
caught when querying from table topologyExecutionEntity
[ https://issues.apache.org/jira/browse/EAGLE-319?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15314121#comment-15314121 ]
ASF GitHub Bot commented on EAGLE-319:
--------------------------------------
GitHub user anyway1021 opened a pull request:
https://github.com/apache/incubator-eagle/pull/222
EAGLE-319 modify java to jdbc data type mapping to be compatible with derby DB
modify java to jdbc data type mapping: long-varchar to varchar, to avoid comparison error for derby DB
You can merge this pull request into a Git repository by running:
$ git pull https://github.com/anyway1021/incubator-eagle EAGLE-319
Alternatively you can review and apply these changes as the patch at:
https://github.com/apache/incubator-eagle/pull/222.patch
To close this pull request, make a commit to your master/trunk branch
with (at least) the following in the commit message:
This closes #222
----
commit ca944896722511153767e794b035266277f0057e
Author: ziwu <zi...@ebay.com>
Date: 2016-05-27T12:20:15Z
modify java to jdbc data type mapping: long-varchar to varchar, to avoid comparison error for derby DB
----
> java.sql.SQLSyntaxErrorException caught when querying from table topologyExecutionEntity
> ----------------------------------------------------------------------------------------
>
> Key: EAGLE-319
> URL: https://issues.apache.org/jira/browse/EAGLE-319
> Project: Eagle
> Issue Type: Bug
> Reporter: Michael Wu
> Assignee: Michael Wu
>
> When querying from table topology_execution, met below error in eagle service log:
> Error log with stacktrace:
> ***************
> [ERROR] [05/27/2016 06:26:34.971] [application-manager-scheduler-akka.actor.default-dispatcher-19] [akka://application-manager-scheduler/user/$a/command-worker] Fail to load any topologyExecutionEntity due to Exception: java.io.IOException: org.apache.torque.TorqueException: java.sql.SQLSyntaxErrorException: Comparisons between 'LONG VARCHAR (UCS_BASIC)' and 'LONG VARCHAR (UCS_BASIC)' are not supported. Types must be comparable. String types must also have matching collation. If collation does not match, a possible solution is to cast operands to force them to the default collation (e.g. SELECT tablename FROM sys.systables WHERE CAST(tablename AS VARCHAR(128)) = 'T1')
> org.apache.eagle.storage.jdbc.JdbcStorage.query(JdbcStorage.java:179)
> org.apache.eagle.storage.operation.QueryStatement.execute(QueryStatement.java:47)
> org.apache.eagle.service.generic.GenericEntityServiceResource.search(GenericEntityServiceResource.java:443)
> sun.reflect.GeneratedMethodAccessor45.invoke(Unknown Source)
> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
> java.lang.reflect.Method.invoke(Method.java:606)
> com.sun.jersey.spi.container.JavaMethodInvokerFactory$1.invoke(JavaMethodInvokerFactory.java:60)
> com.sun.jersey.server.impl.model.method.dispatch.AbstractResourceMethodDispatchProvider$TypeOutInvoker._dispatch(AbstractResourceMethodDispatchProvider.java:185)
> com.sun.jersey.server.impl.model.method.dispatch.ResourceJavaMethodDispatcher.dispatch(ResourceJavaMethodDispatcher.java:75)
> com.sun.jersey.server.impl.uri.rules.HttpMethodRule.accept(HttpMethodRule.java:288)
> ***************
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)