iBatis issues when running new version of archetypes
31 views
Skip to first unread message
Gabriele Columbro
Jun 4, 2012, 5:05:59 AM6/4/12
to maven-a...@googlegroups.com
Hey guys,
I'm trying to run
http://maven-alfresco-archetypes.googlecode.com/svn/branches/experimental/alfresco-lifecycle-aggregator/
with mvn clean install -Prun (either from root project and from runner subproject).
While, after some struggling, now it all works with one command, when I log in in Share and try to remove the help dashlet, the click fails silently and in the log I get the ugly iBatis exception below.
I'm guessing it's something related to being running an unsupported, embedded Jetty against H2 emulation of Postgres via [1]. Am I on the right track....Carlo ?
:)))
Thanks,
Gab
[1] https://github.com/skuro/alfresco-h2-support
~~~o0 alfresco.log 0o~~~
2012-06-04 10:52:52,872 ERROR [extensions.webscripts.AbstractRuntime] [317099593@qtp-1830123223-13] Exception from executeScript - redirecting to status template error: 05040101 Failed to execute query:
Namespace: alfresco.node
queryName: select_GetChildrenCannedQueryWithoutProps
Parameter: org.alfresco.repo.node.getchildren.FilterSortNodeEntity@4179e322
Offset: 0
Limit: 2147483647
org.alfresco.repo.domain.query.QueryException: 05040101 Failed to execute query:
Namespace: alfresco.node
queryName: select_GetChildrenCannedQueryWithoutProps
Parameter: org.alfresco.repo.node.getchildren.FilterSortNodeEntity@4179e322
Offset: 0
Limit: 2147483647
at org.alfresco.repo.domain.query.ibatis.CannedQueryDAOImpl.executeQuery(CannedQueryDAOImpl.java:218)
at org.alfresco.repo.node.getchildren.GetChildrenCannedQuery.queryAndFilter(GetChildrenCannedQuery.java:274)
at org.alfresco.query.AbstractCannedQuery.execute(AbstractCannedQuery.java:81)
at org.alfresco.repo.model.filefolder.FileFolderServiceImpl.listImpl(FileFolderServiceImpl.java:493)
at org.alfresco.repo.model.filefolder.FileFolderServiceImpl.list(FileFolderServiceImpl.java:467)
at sun.reflect.GeneratedMethodAccessor511.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:309)
at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:183)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:150)
at org.alfresco.repo.model.ml.MLContentInterceptor.invoke(MLContentInterceptor.java:125)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
at org.alfresco.repo.model.filefolder.MLTranslationInterceptor.invoke(MLTranslationInterceptor.java:267)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
at net.sf.acegisecurity.intercept.method.aopalliance.MethodSecurityInterceptor.invoke(MethodSecurityInterceptor.java:80)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
at org.alfresco.repo.security.permissions.impl.ExceptionTranslatorMethodInterceptor.invoke(ExceptionTranslatorMethodInterceptor.java:46)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
at org.alfresco.repo.audit.AuditMethodInterceptor.invoke(AuditMethodInterceptor.java:147)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
at org.alfresco.repo.model.filefolder.FilenameFilteringInterceptor.invoke(FilenameFilteringInterceptor.java:275)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:110)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:202)
at $Proxy76.list(Unknown Source)
at org.alfresco.repo.web.scripts.bean.ADMRemoteStore.outputFileNodes(ADMRemoteStore.java:842)
at org.alfresco.repo.web.scripts.bean.ADMRemoteStore.access$600(ADMRemoteStore.java:80)
at org.alfresco.repo.web.scripts.bean.ADMRemoteStore$6.doWork(ADMRemoteStore.java:566)
at org.alfresco.repo.web.scripts.bean.ADMRemoteStore$6.doWork(ADMRemoteStore.java:524)
at org.alfresco.repo.security.authentication.AuthenticationUtil.runAs(AuthenticationUtil.java:519)
at org.alfresco.repo.web.scripts.bean.ADMRemoteStore.listDocuments(ADMRemoteStore.java:523)
at org.alfresco.repo.web.scripts.bean.BaseRemoteStore.execute(BaseRemoteStore.java:276)
at org.alfresco.repo.web.scripts.RepositoryContainer$2.execute(RepositoryContainer.java:393)
at org.alfresco.repo.transaction.RetryingTransactionHelper.doInTransaction(RetryingTransactionHelper.java:388)
at org.alfresco.repo.web.scripts.RepositoryContainer.transactionedExecute(RepositoryContainer.java:462)
at org.alfresco.repo.web.scripts.RepositoryContainer.transactionedExecuteAs(RepositoryContainer.java:500)
at org.alfresco.repo.web.scripts.RepositoryContainer.executeScript(RepositoryContainer.java:275)
at org.springframework.extensions.webscripts.AbstractRuntime.executeScript(AbstractRuntime.java:372)
at org.springframework.extensions.webscripts.AbstractRuntime.executeScript(AbstractRuntime.java:209)
at org.springframework.extensions.webscripts.servlet.WebScriptServlet.service(WebScriptServlet.java:118)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:820)
at org.mortbay.jetty.servlet.ServletHolder.handle(ServletHolder.java:511)
at org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1221)
at org.alfresco.web.app.servlet.GlobalLocalizationFilter.doFilter(GlobalLocalizationFilter.java:58)
at org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1212)
at org.mortbay.jetty.servlet.ServletHandler.handle(ServletHandler.java:399)
at org.mortbay.jetty.security.SecurityHandler.handle(SecurityHandler.java:216)
at org.mortbay.jetty.servlet.SessionHandler.handle(SessionHandler.java:182)
at org.mortbay.jetty.handler.ContextHandler.handle(ContextHandler.java:766)
at org.mortbay.jetty.webapp.WebAppContext.handle(WebAppContext.java:450)
at org.mortbay.jetty.handler.ContextHandlerCollection.handle(ContextHandlerCollection.java:230)
at org.mortbay.jetty.handler.HandlerCollection.handle(HandlerCollection.java:114)
at org.mortbay.jetty.handler.HandlerWrapper.handle(HandlerWrapper.java:152)
at org.mortbay.jetty.Server.handle(Server.java:326)
at org.mortbay.jetty.HttpConnection.handleRequest(HttpConnection.java:542)
at org.mortbay.jetty.HttpConnection$RequestHandler.headerComplete(HttpConnection.java:928)
at org.mortbay.jetty.HttpParser.parseNext(HttpParser.java:549)
at org.mortbay.jetty.HttpParser.parseAvailable(HttpParser.java:212)
at org.mortbay.jetty.HttpConnection.handle(HttpConnection.java:404)
at org.mortbay.io.nio.SelectChannelEndPoint.run(SelectChannelEndPoint.java:410)
at org.mortbay.thread.QueuedThreadPool$PoolThread.run(QueuedThreadPool.java:582)
Caused by: org.springframework.dao.DataIntegrityViolationException:
### Error querying database. Cause: org.h2.jdbc.JdbcSQLException: Error in LIKE ESCAPE: "\\"; SQL statement:
select
childNode.id as id,
childStore.protocol as protocol,
childStore.identifier as identifier,
childNode.uuid as uuid
from
alf_child_assoc assoc
join alf_node childNode on (childNode.id = assoc.child_node_id)
join alf_store childStore on (childStore.id = childNode.store_id)
join alf_node_properties prop4 on (prop4.node_id = childNode.id)
join alf_qname qname on (prop4.qname_id = qname.id and qname.id = ?)
where
assoc.parent_node_id = ?
and childNode.type_qname_id in
(
?
,
?
,
?
,
?
,
?
,
?
)
and prop4.string_value like ?
escape '\\'
order by
assoc.assoc_index ASC,
assoc.id ASC [22025-158]
### The error may involve alfresco.node.select_GetChildrenCannedQueryWithoutProps-Inline
### The error occurred while setting parameters
### Cause: org.h2.jdbc.JdbcSQLException: Error in LIKE ESCAPE: "\\"; SQL statement:
select
childNode.id as id,
childStore.protocol as protocol,
childStore.identifier as identifier,
childNode.uuid as uuid
from
alf_child_assoc assoc
join alf_node childNode on (childNode.id = assoc.child_node_id)
join alf_store childStore on (childStore.id = childNode.store_id)
join alf_node_properties prop4 on (prop4.node_id = childNode.id)
join alf_qname qname on (prop4.qname_id = qname.id and qname.id = ?)
where
assoc.parent_node_id = ?
and childNode.type_qname_id in
(
?
,
?
,
?
,
?
,
?
,
?
)
and prop4.string_value like ?
escape '\\'
order by
assoc.assoc_index ASC,
assoc.id ASC [22025-158]
; SQL []; Error in LIKE ESCAPE: "\\"; SQL statement:
select
childNode.id as id,
childStore.protocol as protocol,
childStore.identifier as identifier,
childNode.uuid as uuid
from
alf_child_assoc assoc
join alf_node childNode on (childNode.id = assoc.child_node_id)
join alf_store childStore on (childStore.id = childNode.store_id)
join alf_node_properties prop4 on (prop4.node_id = childNode.id)
join alf_qname qname on (prop4.qname_id = qname.id and qname.id = ?)
where
assoc.parent_node_id = ?
and childNode.type_qname_id in
(
?
,
?
,
?
,
?
,
?
,
?
)
and prop4.string_value like ?
escape '\\'
order by
assoc.assoc_index ASC,
assoc.id ASC [22025-158]; nested exception is org.h2.jdbc.JdbcSQLException: Error in LIKE ESCAPE: "\\"; SQL statement:
select
childNode.id as id,
childStore.protocol as protocol,
childStore.identifier as identifier,
childNode.uuid as uuid
from
alf_child_assoc assoc
join alf_node childNode on (childNode.id = assoc.child_node_id)
join alf_store childStore on (childStore.id = childNode.store_id)
join alf_node_properties prop4 on (prop4.node_id = childNode.id)
join alf_qname qname on (prop4.qname_id = qname.id and qname.id = ?)
where
assoc.parent_node_id = ?
and childNode.type_qname_id in
(
?
,
?
,
?
,
?
,
?
,
?
)
and prop4.string_value like ?
escape '\\'
order by
assoc.assoc_index ASC,
assoc.id ASC [22025-158]
at org.springframework.jdbc.support.SQLErrorCodeSQLExceptionTranslator.doTranslate(SQLErrorCodeSQLExceptionTranslator.java:245)
at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:72)
at org.mybatis.spring.MyBatisExceptionTranslator.translateExceptionIfPossible(MyBatisExceptionTranslator.java:71)
at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:346)
at $Proxy16.select(Unknown Source)
at org.mybatis.spring.SqlSessionTemplate.select(SqlSessionTemplate.java:210)
at org.alfresco.repo.domain.query.ibatis.CannedQueryDAOImpl.executeQuery(CannedQueryDAOImpl.java:204)
... 62 more
Caused by: org.h2.jdbc.JdbcSQLException: Error in LIKE ESCAPE: "\\"; SQL statement:
select
childNode.id as id,
childStore.protocol as protocol,
childStore.identifier as identifier,
childNode.uuid as uuid
from
alf_child_assoc assoc
join alf_node childNode on (childNode.id = assoc.child_node_id)
join alf_store childStore on (childStore.id = childNode.store_id)
join alf_node_properties prop4 on (prop4.node_id = childNode.id)
join alf_qname qname on (prop4.qname_id = qname.id and qname.id = ?)
where
assoc.parent_node_id = ?
and childNode.type_qname_id in
(
?
,
?
,
?
,
?
,
?
,
?
)
and prop4.string_value like ?
escape '\\'
order by
assoc.assoc_index ASC,
assoc.id ASC [22025-158]
at org.h2.message.DbException.getJdbcSQLException(DbException.java:329)
at org.h2.message.DbException.get(DbException.java:169)
at org.h2.message.DbException.get(DbException.java:146)
at org.h2.expression.CompareLike.getEscapeChar(CompareLike.java:143)
at org.h2.expression.CompareLike.optimize(CompareLike.java:113)
at org.h2.expression.ConditionAndOr.optimize(ConditionAndOr.java:127)
at org.h2.expression.ConditionAndOr.optimize(ConditionAndOr.java:126)
at org.h2.command.dml.Select.prepare(Select.java:797)
at org.h2.command.CommandContainer.recompileIfRequired(CommandContainer.java:61)
at org.h2.command.CommandContainer.query(CommandContainer.java:77)
at org.h2.command.Command.executeQuery(Command.java:181)
at org.h2.jdbc.JdbcPreparedStatement.execute(JdbcPreparedStatement.java:177)
at org.apache.commons.dbcp.DelegatingPreparedStatement.execute(DelegatingPreparedStatement.java:172)
at org.apache.commons.dbcp.DelegatingPreparedStatement.execute(DelegatingPreparedStatement.java:172)
at org.apache.commons.dbcp.DelegatingPreparedStatement.execute(DelegatingPreparedStatement.java:172)
at org.apache.ibatis.executor.statement.PreparedStatementHandler.query(PreparedStatementHandler.java:39)
at org.apache.ibatis.executor.statement.RoutingStatementHandler.query(RoutingStatementHandler.java:55)
at org.apache.ibatis.executor.SimpleExecutor.doQuery(SimpleExecutor.java:41)
at org.apache.ibatis.executor.BaseExecutor.query(BaseExecutor.java:120)
at org.apache.ibatis.executor.CachingExecutor.query(CachingExecutor.java:75)
at org.apache.ibatis.session.defaults.DefaultSqlSession.select(DefaultSqlSession.java:94)
at org.apache.ibatis.session.defaults.DefaultSqlSession.select(DefaultSqlSession.java:84)
at sun.reflect.GeneratedMethodAccessor218.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
--
Gabriele Columbro
Principal Architect, Consulting Services
I'm trying to run
http://maven-alfresco-archetypes.googlecode.com/svn/branches/experimental/alfresco-lifecycle-aggregator/
with mvn clean install -Prun (either from root project and from runner subproject).
While, after some struggling, now it all works with one command, when I log in in Share and try to remove the help dashlet, the click fails silently and in the log I get the ugly iBatis exception below.
I'm guessing it's something related to being running an unsupported, embedded Jetty against H2 emulation of Postgres via [1]. Am I on the right track....Carlo ?
:)))
Thanks,
Gab
[1] https://github.com/skuro/alfresco-h2-support
~~~o0 alfresco.log 0o~~~
2012-06-04 10:52:52,872 ERROR [extensions.webscripts.AbstractRuntime] [317099593@qtp-1830123223-13] Exception from executeScript - redirecting to status template error: 05040101 Failed to execute query:
Namespace: alfresco.node
queryName: select_GetChildrenCannedQueryWithoutProps
Parameter: org.alfresco.repo.node.getchildren.FilterSortNodeEntity@4179e322
Offset: 0
Limit: 2147483647
org.alfresco.repo.domain.query.QueryException: 05040101 Failed to execute query:
Namespace: alfresco.node
queryName: select_GetChildrenCannedQueryWithoutProps
Parameter: org.alfresco.repo.node.getchildren.FilterSortNodeEntity@4179e322
Offset: 0
Limit: 2147483647
at org.alfresco.repo.domain.query.ibatis.CannedQueryDAOImpl.executeQuery(CannedQueryDAOImpl.java:218)
at org.alfresco.repo.node.getchildren.GetChildrenCannedQuery.queryAndFilter(GetChildrenCannedQuery.java:274)
at org.alfresco.query.AbstractCannedQuery.execute(AbstractCannedQuery.java:81)
at org.alfresco.repo.model.filefolder.FileFolderServiceImpl.listImpl(FileFolderServiceImpl.java:493)
at org.alfresco.repo.model.filefolder.FileFolderServiceImpl.list(FileFolderServiceImpl.java:467)
at sun.reflect.GeneratedMethodAccessor511.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:309)
at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:183)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:150)
at org.alfresco.repo.model.ml.MLContentInterceptor.invoke(MLContentInterceptor.java:125)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
at org.alfresco.repo.model.filefolder.MLTranslationInterceptor.invoke(MLTranslationInterceptor.java:267)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
at net.sf.acegisecurity.intercept.method.aopalliance.MethodSecurityInterceptor.invoke(MethodSecurityInterceptor.java:80)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
at org.alfresco.repo.security.permissions.impl.ExceptionTranslatorMethodInterceptor.invoke(ExceptionTranslatorMethodInterceptor.java:46)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
at org.alfresco.repo.audit.AuditMethodInterceptor.invoke(AuditMethodInterceptor.java:147)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
at org.alfresco.repo.model.filefolder.FilenameFilteringInterceptor.invoke(FilenameFilteringInterceptor.java:275)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:110)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:202)
at $Proxy76.list(Unknown Source)
at org.alfresco.repo.web.scripts.bean.ADMRemoteStore.outputFileNodes(ADMRemoteStore.java:842)
at org.alfresco.repo.web.scripts.bean.ADMRemoteStore.access$600(ADMRemoteStore.java:80)
at org.alfresco.repo.web.scripts.bean.ADMRemoteStore$6.doWork(ADMRemoteStore.java:566)
at org.alfresco.repo.web.scripts.bean.ADMRemoteStore$6.doWork(ADMRemoteStore.java:524)
at org.alfresco.repo.security.authentication.AuthenticationUtil.runAs(AuthenticationUtil.java:519)
at org.alfresco.repo.web.scripts.bean.ADMRemoteStore.listDocuments(ADMRemoteStore.java:523)
at org.alfresco.repo.web.scripts.bean.BaseRemoteStore.execute(BaseRemoteStore.java:276)
at org.alfresco.repo.web.scripts.RepositoryContainer$2.execute(RepositoryContainer.java:393)
at org.alfresco.repo.transaction.RetryingTransactionHelper.doInTransaction(RetryingTransactionHelper.java:388)
at org.alfresco.repo.web.scripts.RepositoryContainer.transactionedExecute(RepositoryContainer.java:462)
at org.alfresco.repo.web.scripts.RepositoryContainer.transactionedExecuteAs(RepositoryContainer.java:500)
at org.alfresco.repo.web.scripts.RepositoryContainer.executeScript(RepositoryContainer.java:275)
at org.springframework.extensions.webscripts.AbstractRuntime.executeScript(AbstractRuntime.java:372)
at org.springframework.extensions.webscripts.AbstractRuntime.executeScript(AbstractRuntime.java:209)
at org.springframework.extensions.webscripts.servlet.WebScriptServlet.service(WebScriptServlet.java:118)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:820)
at org.mortbay.jetty.servlet.ServletHolder.handle(ServletHolder.java:511)
at org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1221)
at org.alfresco.web.app.servlet.GlobalLocalizationFilter.doFilter(GlobalLocalizationFilter.java:58)
at org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1212)
at org.mortbay.jetty.servlet.ServletHandler.handle(ServletHandler.java:399)
at org.mortbay.jetty.security.SecurityHandler.handle(SecurityHandler.java:216)
at org.mortbay.jetty.servlet.SessionHandler.handle(SessionHandler.java:182)
at org.mortbay.jetty.handler.ContextHandler.handle(ContextHandler.java:766)
at org.mortbay.jetty.webapp.WebAppContext.handle(WebAppContext.java:450)
at org.mortbay.jetty.handler.ContextHandlerCollection.handle(ContextHandlerCollection.java:230)
at org.mortbay.jetty.handler.HandlerCollection.handle(HandlerCollection.java:114)
at org.mortbay.jetty.handler.HandlerWrapper.handle(HandlerWrapper.java:152)
at org.mortbay.jetty.Server.handle(Server.java:326)
at org.mortbay.jetty.HttpConnection.handleRequest(HttpConnection.java:542)
at org.mortbay.jetty.HttpConnection$RequestHandler.headerComplete(HttpConnection.java:928)
at org.mortbay.jetty.HttpParser.parseNext(HttpParser.java:549)
at org.mortbay.jetty.HttpParser.parseAvailable(HttpParser.java:212)
at org.mortbay.jetty.HttpConnection.handle(HttpConnection.java:404)
at org.mortbay.io.nio.SelectChannelEndPoint.run(SelectChannelEndPoint.java:410)
at org.mortbay.thread.QueuedThreadPool$PoolThread.run(QueuedThreadPool.java:582)
Caused by: org.springframework.dao.DataIntegrityViolationException:
### Error querying database. Cause: org.h2.jdbc.JdbcSQLException: Error in LIKE ESCAPE: "\\"; SQL statement:
select
childNode.id as id,
childStore.protocol as protocol,
childStore.identifier as identifier,
childNode.uuid as uuid
from
alf_child_assoc assoc
join alf_node childNode on (childNode.id = assoc.child_node_id)
join alf_store childStore on (childStore.id = childNode.store_id)
join alf_node_properties prop4 on (prop4.node_id = childNode.id)
join alf_qname qname on (prop4.qname_id = qname.id and qname.id = ?)
where
assoc.parent_node_id = ?
and childNode.type_qname_id in
(
?
,
?
,
?
,
?
,
?
,
?
)
and prop4.string_value like ?
escape '\\'
order by
assoc.assoc_index ASC,
assoc.id ASC [22025-158]
### The error may involve alfresco.node.select_GetChildrenCannedQueryWithoutProps-Inline
### The error occurred while setting parameters
### Cause: org.h2.jdbc.JdbcSQLException: Error in LIKE ESCAPE: "\\"; SQL statement:
select
childNode.id as id,
childStore.protocol as protocol,
childStore.identifier as identifier,
childNode.uuid as uuid
from
alf_child_assoc assoc
join alf_node childNode on (childNode.id = assoc.child_node_id)
join alf_store childStore on (childStore.id = childNode.store_id)
join alf_node_properties prop4 on (prop4.node_id = childNode.id)
join alf_qname qname on (prop4.qname_id = qname.id and qname.id = ?)
where
assoc.parent_node_id = ?
and childNode.type_qname_id in
(
?
,
?
,
?
,
?
,
?
,
?
)
and prop4.string_value like ?
escape '\\'
order by
assoc.assoc_index ASC,
assoc.id ASC [22025-158]
; SQL []; Error in LIKE ESCAPE: "\\"; SQL statement:
select
childNode.id as id,
childStore.protocol as protocol,
childStore.identifier as identifier,
childNode.uuid as uuid
from
alf_child_assoc assoc
join alf_node childNode on (childNode.id = assoc.child_node_id)
join alf_store childStore on (childStore.id = childNode.store_id)
join alf_node_properties prop4 on (prop4.node_id = childNode.id)
join alf_qname qname on (prop4.qname_id = qname.id and qname.id = ?)
where
assoc.parent_node_id = ?
and childNode.type_qname_id in
(
?
,
?
,
?
,
?
,
?
,
?
)
and prop4.string_value like ?
escape '\\'
order by
assoc.assoc_index ASC,
assoc.id ASC [22025-158]; nested exception is org.h2.jdbc.JdbcSQLException: Error in LIKE ESCAPE: "\\"; SQL statement:
select
childNode.id as id,
childStore.protocol as protocol,
childStore.identifier as identifier,
childNode.uuid as uuid
from
alf_child_assoc assoc
join alf_node childNode on (childNode.id = assoc.child_node_id)
join alf_store childStore on (childStore.id = childNode.store_id)
join alf_node_properties prop4 on (prop4.node_id = childNode.id)
join alf_qname qname on (prop4.qname_id = qname.id and qname.id = ?)
where
assoc.parent_node_id = ?
and childNode.type_qname_id in
(
?
,
?
,
?
,
?
,
?
,
?
)
and prop4.string_value like ?
escape '\\'
order by
assoc.assoc_index ASC,
assoc.id ASC [22025-158]
at org.springframework.jdbc.support.SQLErrorCodeSQLExceptionTranslator.doTranslate(SQLErrorCodeSQLExceptionTranslator.java:245)
at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:72)
at org.mybatis.spring.MyBatisExceptionTranslator.translateExceptionIfPossible(MyBatisExceptionTranslator.java:71)
at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:346)
at $Proxy16.select(Unknown Source)
at org.mybatis.spring.SqlSessionTemplate.select(SqlSessionTemplate.java:210)
at org.alfresco.repo.domain.query.ibatis.CannedQueryDAOImpl.executeQuery(CannedQueryDAOImpl.java:204)
... 62 more
Caused by: org.h2.jdbc.JdbcSQLException: Error in LIKE ESCAPE: "\\"; SQL statement:
select
childNode.id as id,
childStore.protocol as protocol,
childStore.identifier as identifier,
childNode.uuid as uuid
from
alf_child_assoc assoc
join alf_node childNode on (childNode.id = assoc.child_node_id)
join alf_store childStore on (childStore.id = childNode.store_id)
join alf_node_properties prop4 on (prop4.node_id = childNode.id)
join alf_qname qname on (prop4.qname_id = qname.id and qname.id = ?)
where
assoc.parent_node_id = ?
and childNode.type_qname_id in
(
?
,
?
,
?
,
?
,
?
,
?
)
and prop4.string_value like ?
escape '\\'
order by
assoc.assoc_index ASC,
assoc.id ASC [22025-158]
at org.h2.message.DbException.getJdbcSQLException(DbException.java:329)
at org.h2.message.DbException.get(DbException.java:169)
at org.h2.message.DbException.get(DbException.java:146)
at org.h2.expression.CompareLike.getEscapeChar(CompareLike.java:143)
at org.h2.expression.CompareLike.optimize(CompareLike.java:113)
at org.h2.expression.ConditionAndOr.optimize(ConditionAndOr.java:127)
at org.h2.expression.ConditionAndOr.optimize(ConditionAndOr.java:126)
at org.h2.command.dml.Select.prepare(Select.java:797)
at org.h2.command.CommandContainer.recompileIfRequired(CommandContainer.java:61)
at org.h2.command.CommandContainer.query(CommandContainer.java:77)
at org.h2.command.Command.executeQuery(Command.java:181)
at org.h2.jdbc.JdbcPreparedStatement.execute(JdbcPreparedStatement.java:177)
at org.apache.commons.dbcp.DelegatingPreparedStatement.execute(DelegatingPreparedStatement.java:172)
at org.apache.commons.dbcp.DelegatingPreparedStatement.execute(DelegatingPreparedStatement.java:172)
at org.apache.commons.dbcp.DelegatingPreparedStatement.execute(DelegatingPreparedStatement.java:172)
at org.apache.ibatis.executor.statement.PreparedStatementHandler.query(PreparedStatementHandler.java:39)
at org.apache.ibatis.executor.statement.RoutingStatementHandler.query(RoutingStatementHandler.java:55)
at org.apache.ibatis.executor.SimpleExecutor.doQuery(SimpleExecutor.java:41)
at org.apache.ibatis.executor.BaseExecutor.query(BaseExecutor.java:120)
at org.apache.ibatis.executor.CachingExecutor.query(CachingExecutor.java:75)
at org.apache.ibatis.session.defaults.DefaultSqlSession.select(DefaultSqlSession.java:94)
at org.apache.ibatis.session.defaults.DefaultSqlSession.select(DefaultSqlSession.java:84)
at sun.reflect.GeneratedMethodAccessor218.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
--
Gabriele Columbro
Principal Architect, Consulting Services
Reply all
Reply to author
Forward
0 new messages