Mysql error when trying to log in on new installation

Hi!

I installed odkaggregate (1.3.4) on a linux box running mysql, tomcat7

When going to hostname/ODKAggregate only the anonymous accessible page is
shown.
Clicking on 'Login' hangs the system and nothing happens.

Studying the catalina.out file reveals that there is a problem with an sql
query.

.....
org.springframework.jdbc.BadSqlGrammarException: PreparedStatementCallback;
bad SQL grammar [SELECT _URI, _CREATOR_URI_USER, _CREATION_DATE,
_LAST_UPDATE_URI_USER, _LAST_UPDATE_DATE, TABLE_ID, TABLE_KEY,
DB_TABLE_NAME, TYPE, TABLE_ID_ACCESS_CONTROLS FROM
odk.__ODKTABLES__TABLE_DEFINITIONS WHERE TABLE_ID IN ();]; nested
exception is com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You
have an error in your SQL syntax; check the manual that corresponds to your
MySQL server version for the right syntax to use near ')' at line 1
at
org.springframework.jdbc.support.SQLErrorCodeSQLExceptionTranslator.doTranslate(SQLErrorCodeSQLExceptionTranslator.java:233)
......

I could not find anything in the documentation nor in this googlegroup

       Any help appreciated

              Christian

Christian,

ODK Aggregate is not tested on Tomcat 7. You can probably make it
work, but I don't know anyone who has successfully done it. Try Tomcat
6 and see if that works.

Yaw

··· -- Need ODK services? http://nafundi.com provides form design, professional support, custom reporting, and software development for ODK.

On Tue, Sep 10, 2013 at 5:01 AM, Christian Steinebach eidemsnesset@gmail.com wrote:

Hi!

I installed odkaggregate (1.3.4) on a linux box running mysql, tomcat7

When going to hostname/ODKAggregate only the anonymous accessible page is
shown.
Clicking on 'Login' hangs the system and nothing happens.

Studying the catalina.out file reveals that there is a problem with an sql
query.

.....
org.springframework.jdbc.BadSqlGrammarException: PreparedStatementCallback;
bad SQL grammar [SELECT _URI, _CREATOR_URI_USER, _CREATION_DATE,
_LAST_UPDATE_URI_USER, _LAST_UPDATE_DATE, TABLE_ID, TABLE_KEY,
DB_TABLE_NAME, TYPE, TABLE_ID_ACCESS_CONTROLS FROM
odk.__ODKTABLES__TABLE_DEFINITIONS WHERE TABLE_ID IN ();]; nested
exception is com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You
have an error in your SQL syntax; check the manual that corresponds to your
MySQL server version for the right syntax to use near ')' at line 1
at
org.springframework.jdbc.support.SQLErrorCodeSQLExceptionTranslator.doTranslate(SQLErrorCodeSQLExceptionTranslator.java:233)
......

I could not find anything in the documentation nor in this googlegroup

       Any help appreciated

              Christian

--

Post: opendatakit@googlegroups.com
Unsubscribe: opendatakit+unsubscribe@googlegroups.com
Options: http://groups.google.com/group/opendatakit?hl=en


You received this message because you are subscribed to the Google Groups
"ODK Community" group.
To unsubscribe from this group and stop receiving emails from it, send an
email to opendatakit+unsubscribe@googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.

Hi Yaw,

thank you for your anser. the exception is actually from the tomcat6
installation.
I tested tomcat7 (without success), then tried tomcat 6 and got the
exceptions.
My fault to mention tomcat7. :frowning:

I've also installed a version on appspot, which works fine.
But I would like to have controll over the database, i.e. read the data
myself
without having to export to csv files or Fusion Tables.

In the log, catalina.out
The query is obviously wrong ... WHERE TABLE_ID IN ()...

The exception occurs also when accessing the program for the first time,
i.e.
http://..../ODKAggregate/index.html but the Form management and Submission
page
is displayed anyway.

I have configured odk to use a valid google account.

Here is more of the stack trace.

     Cheers
          Christian

Sep 12, 2013 9:47:12 AM org.opendatakit.aggregate.task.WatchdogWorkerImpl
checkMiscTasks
INFO: Done checking miscellaneous tasks
Sep 12, 2013 9:47:12 AM org.opendatakit.aggregate.task.WatchdogWorkerImpl
checkTasks
INFO: ---------------------END Watchdog
EXITING WATCHDOG TASK IN TOMCAT
Sep 12, 2013 9:56:25 AM
org.opendatakit.common.security.spring.RoleHierarchyImpl
refreshReachableGrantedAuthorities
INFO: Executing: refreshReachableGrantedAuthorities
Sep 12, 2013 9:56:25 AM
org.opendatakit.common.security.spring.UserServiceImpl reloadPermissions
INFO: Executing: reloadPermissions
Sep 12, 2013 9:56:28 AM
org.opendatakit.common.persistence.engine.mysql.DatastoreImpl assertRelation
INFO: before updateRelation: _security_revisions
Sep 12, 2013 9:56:29 AM
org.opendatakit.common.persistence.engine.mysql.DatastoreImpl assertRelation
INFO: before updateRelation: __ODKTABLES__TABLE_ENTRY
Sep 12, 2013 9:56:29 AM
org.opendatakit.common.persistence.engine.mysql.DatastoreImpl assertRelation
INFO: before updateRelation: __ODKTABLES__TABLE_DEFINITIONS
Sep 12, 2013 9:56:29 AM org.opendatakit.aggregate.form.FormFactory
internalGetForms
INFO: FormCache: fetching new list of Forms
Sep 12, 2013 9:56:29 AM
org.opendatakit.common.persistence.engine.mysql.DatastoreImpl assertRelation
INFO: before updateRelation: _form_info
Sep 12, 2013 9:56:29 AM org.opendatakit.aggregate.util.BackendActionsTable
logValues
INFO: incoming- last Fetch: -1378972589356 [S: -556484 Eq: -1378972589356 Fs: -1378972589356]
futureMillis: 0
Sep 12, 2013 9:56:29 AM org.opendatakit.aggregate.util.BackendActionsTable
logValues
INFO: -fetched- last Fetch: 0 [S: -557356 Eq: -158637356 Fs: -157737356]
futureMillis: -1
Sep 12, 2013 9:56:29 AM org.opendatakit.aggregate.util.BackendActionsTable
logValues
INFO: Eq-update last Fetch: 0 [S: -557356 Eq: 0 Fs: -157737356]
futureMillis: 0 requested: 0
Sep 12, 2013 9:56:29 AM
org.springframework.beans.factory.xml.XmlBeanDefinitionReader
loadBeanDefinitions
INFO: Loading XML bean definitions from class path resource
[org/springframework/jdbc/support/sql-error-codes.xml]
Sep 12, 2013 9:56:29 AM org.opendatakit.aggregate.form.FormFactory
internalGetForms
INFO: FormCache: using cached list of Forms
Sep 12, 2013 9:56:29 AM
org.springframework.jdbc.support.SQLErrorCodesFactory
INFO: SQLErrorCodes loaded: [DB2, Derby, H2, HSQL, Informix, MS-SQL, MySQL,
Oracle, PostgreSQL, Sybase]
org.springframework.jdbc.BadSqlGrammarException: PreparedStatementCallback;
bad SQL grammar [SELECT _URI, _CREATOR_URI_USER, _CREATION_DATE,
_LAST_UPDATE_URI_USER, _LAST_UPDATE_DATE, TABLE_ID, TABLE_KEY,
DB_TABLE_NAME, TYPE, TABLE_ID_ACCESS_CONTROLS FROM
odk.__ODKTABLES__TABLE_DEFINITIONS WHERE TABLE_ID IN ();]; nested
exception is com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You
have an error in your SQL syntax; check the manual that corresponds to your
MySQL server version for the right syntax to use near ')' at line 1
at
org.springframework.jdbc.support.SQLErrorCodeSQLExceptionTranslator.doTranslate(SQLErrorCodeSQLExceptionTranslator.java:233)
at
org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:72)
at
org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:603)
at
org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:637)
at
org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:666)
at
org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:674)
at
org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:714)
at
org.opendatakit.common.persistence.engine.mysql.QueryImpl.executeQuery(QueryImpl.java:259)
at org.opendatakit.common.ermodel.simple.Query.execute(Query.java:267)
at
org.opendatakit.aggregate.odktables.TableManager.getTableEntries(TableManager.java:141)
at
org.opendatakit.aggregate.odktables.TableManager.getTables(TableManager.java:84)
at
org.opendatakit.aggregate.odktables.TableManager.getTables(TableManager.java:119)
at
org.opendatakit.aggregate.server.ServerTableServiceImpl.getTables(ServerTableServiceImpl.java:69)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:616)
at
com.google.gwt.user.server.rpc.RPC.invokeAndEncodeResponse(RPC.java:561)
at
com.google.gwt.user.server.rpc.RemoteServiceServlet.processCall(RemoteServiceServlet.java:208)
at
com.google.gwt.user.server.rpc.RemoteServiceServlet.processPost(RemoteServiceServlet.java:248)
at
com.google.gwt.user.server.rpc.AbstractRemoteServiceServlet.doPost(AbstractRemoteServiceServlet.java:62)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:637)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at
org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:330)
at
org.springframework.security.web.access.intercept.FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:118)
at
org.springframework.security.web.access.intercept.FilterSecurityInterceptor.doFilter(FilterSecurityInterceptor.java:84)
at
org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)
at
org.springframework.security.web.access.ExceptionTranslationFilter.doFilter(ExceptionTranslationFilter.java:113)
at
org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)
at
org.springframework.security.web.session.SessionManagementFilter.doFilter(SessionManagementFilter.java:103)
at
org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)
at
org.opendatakit.common.security.spring.SecurityContextHolderAwareAuthPreservingRequestFilter.doFilter(SecurityContextHolderAwareAuthPreservingRequestFilter.java:66)
at
org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)
at
org.springframework.security.web.authentication.AnonymousAuthenticationFilter.doFilter(AnonymousAuthenticationFilter.java:113)
at
org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)
at
org.springframework.security.web.savedrequest.RequestCacheAwareFilter.doFilter(RequestCacheAwareFilter.java:45)
at
org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)
at
org.springframework.security.web.authentication.AbstractAuthenticationProcessingFilter.doFilter(AbstractAuthenticationProcessingFilter.java:183)
at
org.opendatakit.common.security.spring.OpenIDAuthenticationFilter.doFilter(OpenIDAuthenticationFilter.java:40)
at
org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)
at
org.springframework.security.web.authentication.www.DigestAuthenticationFilter.doFilter(DigestAuthenticationFilter.java:115)
at
org.opendatakit.common.security.spring.DigestAuthenticationFilter.doFilter(DigestAuthenticationFilter.java:40)
at
org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)
at
org.opendatakit.common.security.spring.OutOfBandUserFilter.doFilter(OutOfBandUserFilter.java:105)
at
org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)
at
org.opendatakit.common.security.spring.Oauth2ResourceFilter.doFilter(Oauth2ResourceFilter.java:351)
at
org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)
at
org.springframework.security.web.authentication.logout.LogoutFilter.doFilter(LogoutFilter.java:105)
at
org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)
at
org.springframework.security.web.context.SecurityContextPersistenceFilter.doFilter(SecurityContextPersistenceFilter.java:87)
at
org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)
at
org.springframework.security.web.access.channel.ChannelProcessingFilter.doFilter(ChannelProcessingFilter.java:144)
at
org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)
at
org.springframework.security.web.FilterChainProxy.doFilterInternal(FilterChainProxy.java:192)
at
org.springframework.security.web.FilterChainProxy.doFilter(FilterChainProxy.java:160)
at
org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:346)
at
org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:259)
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
at
org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
at
org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:470)
at
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
at
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
at
org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
at
org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:300)
at
org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:859)
at
org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:588)
at
org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489)
at java.lang.Thread.run(Thread.java:679)
Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You
have an error in your SQL syntax; check the manual that corresponds to your
MySQL server version for the right syntax to use near ')' at line 1
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at
sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57)
at
sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
at java.lang.reflect.Constructor.newInstance(Constructor.java:532)
at com.mysql.jdbc.Util.handleNewInstance(Util.java:409)
at com.mysql.jdbc.Util.getInstance(Util.java:384)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1054)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3566)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3498)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1959)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2113)
at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2568)
at
com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2113)
at
com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:2275)
at
com.jolbox.bonecp.PreparedStatementHandle.executeQuery(PreparedStatementHandle.java:172)
at
org.springframework.jdbc.core.JdbcTemplate$1.doInPreparedStatement(JdbcTemplate.java:644)
at
org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:587)
... 69 more

··· On Wed, Sep 11, 2013 at 8:52 PM, Yaw Anokwa wrote:

Christian,

ODK Aggregate is not tested on Tomcat 7. You can probably make it
work, but I don't know anyone who has successfully done it. Try Tomcat
6 and see if that works.

Yaw

Need ODK services? http://nafundi.com provides form design,
professional support, custom reporting, and software development for
ODK.

On Tue, Sep 10, 2013 at 5:01 AM, Christian Steinebach eidemsnesset@gmail.com wrote:

Hi!

I installed odkaggregate (1.3.4) on a linux box running mysql, tomcat7

When going to hostname/ODKAggregate only the anonymous accessible page is
shown.
Clicking on 'Login' hangs the system and nothing happens.

Studying the catalina.out file reveals that there is a problem with an
sql
query.

.....
org.springframework.jdbc.BadSqlGrammarException:
PreparedStatementCallback;
bad SQL grammar [SELECT _URI, _CREATOR_URI_USER, _CREATION_DATE,
_LAST_UPDATE_URI_USER, _LAST_UPDATE_DATE, TABLE_ID, TABLE_KEY,
DB_TABLE_NAME, TYPE, TABLE_ID_ACCESS_CONTROLS FROM
odk.__ODKTABLES__TABLE_DEFINITIONS WHERE TABLE_ID IN ();]; nested
exception is com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException:
You
have an error in your SQL syntax; check the manual that corresponds to
your
MySQL server version for the right syntax to use near ')' at line 1
at

org.springframework.jdbc.support.SQLErrorCodeSQLExceptionTranslator.doTranslate(SQLErrorCodeSQLExceptionTranslator.java:233)

......

I could not find anything in the documentation nor in this googlegroup

       Any help appreciated

              Christian

--

Post: opendatakit@googlegroups.com
Unsubscribe: opendatakit+unsubscribe@googlegroups.com
Options: http://groups.google.com/group/opendatakit?hl=en


You received this message because you are subscribed to the Google Groups
"ODK Community" group.
To unsubscribe from this group and stop receiving emails from it, send an
email to opendatakit+unsubscribe@googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.

--

Post: opendatakit@googlegroups.com
Unsubscribe: opendatakit+unsubscribe@googlegroups.com
Options: http://groups.google.com/group/opendatakit?hl=en


You received this message because you are subscribed to a topic in the
Google Groups "ODK Community" group.
To unsubscribe from this topic, visit
https://groups.google.com/d/topic/opendatakit/ULKkwHnZ0rc/unsubscribe.
To unsubscribe from this group and all its topics, send an email to
opendatakit+unsubscribe@googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.

This should not prevent your server from starting up, as this was
introduced in 1.3.2 and clean integration tests did not reveal this as an
issue. It will be fixed in the next ODK Aggregate release.

There is likely another error that is preventing your server from starting.

To confirm that, you can download and install ODK Aggregate 1.3.1. It is
available from here: http://code.google.com/p/opendatakit/downloads/list
Search 'All downloads' and leave the for field blank.

··· On Thu, Sep 12, 2013 at 1:06 AM, Christian Steinebach < eidemsnesset@gmail.com> wrote:

Hi Yaw,

thank you for your anser. the exception is actually from the tomcat6
installation.
I tested tomcat7 (without success), then tried tomcat 6 and got the
exceptions.
My fault to mention tomcat7. :frowning:

I've also installed a version on appspot, which works fine.
But I would like to have controll over the database, i.e. read the data
myself
without having to export to csv files or Fusion Tables.

In the log, catalina.out
The query is obviously wrong ... WHERE TABLE_ID IN ()...

The exception occurs also when accessing the program for the first time,
i.e.
http://..../ODKAggregate/index.html but the Form management and
Submission page
is displayed anyway.

I have configured odk to use a valid google account.

Here is more of the stack trace.

     Cheers
          Christian

Sep 12, 2013 9:47:12 AM org.opendatakit.aggregate.task.WatchdogWorkerImpl
checkMiscTasks
INFO: Done checking miscellaneous tasks
Sep 12, 2013 9:47:12 AM org.opendatakit.aggregate.task.WatchdogWorkerImpl
checkTasks
INFO: ---------------------END Watchdog
EXITING WATCHDOG TASK IN TOMCAT
Sep 12, 2013 9:56:25 AM
org.opendatakit.common.security.spring.RoleHierarchyImpl
refreshReachableGrantedAuthorities
INFO: Executing: refreshReachableGrantedAuthorities
Sep 12, 2013 9:56:25 AM
org.opendatakit.common.security.spring.UserServiceImpl reloadPermissions
INFO: Executing: reloadPermissions
Sep 12, 2013 9:56:28 AM
org.opendatakit.common.persistence.engine.mysql.DatastoreImpl assertRelation
INFO: before updateRelation: _security_revisions
Sep 12, 2013 9:56:29 AM
org.opendatakit.common.persistence.engine.mysql.DatastoreImpl assertRelation
INFO: before updateRelation: __ODKTABLES__TABLE_ENTRY
Sep 12, 2013 9:56:29 AM
org.opendatakit.common.persistence.engine.mysql.DatastoreImpl assertRelation
INFO: before updateRelation: __ODKTABLES__TABLE_DEFINITIONS
Sep 12, 2013 9:56:29 AM org.opendatakit.aggregate.form.FormFactory
internalGetForms
INFO: FormCache: fetching new list of Forms
Sep 12, 2013 9:56:29 AM
org.opendatakit.common.persistence.engine.mysql.DatastoreImpl assertRelation
INFO: before updateRelation: _form_info
Sep 12, 2013 9:56:29 AM org.opendatakit.aggregate.util.BackendActionsTable
logValues
INFO: incoming- last Fetch: -1378972589356 [S: -556484 Eq: -1378972589356 Fs: -1378972589356]
futureMillis: 0
Sep 12, 2013 9:56:29 AM org.opendatakit.aggregate.util.BackendActionsTable
logValues
INFO: -fetched- last Fetch: 0 [S: -557356 Eq: -158637356 Fs: -157737356]
futureMillis: -1
Sep 12, 2013 9:56:29 AM org.opendatakit.aggregate.util.BackendActionsTable
logValues
INFO: Eq-update last Fetch: 0 [S: -557356 Eq: 0 Fs: -157737356]
futureMillis: 0 requested: 0
Sep 12, 2013 9:56:29 AM
org.springframework.beans.factory.xml.XmlBeanDefinitionReader
loadBeanDefinitions
INFO: Loading XML bean definitions from class path resource
[org/springframework/jdbc/support/sql-error-codes.xml]
Sep 12, 2013 9:56:29 AM org.opendatakit.aggregate.form.FormFactory
internalGetForms
INFO: FormCache: using cached list of Forms
Sep 12, 2013 9:56:29 AM
org.springframework.jdbc.support.SQLErrorCodesFactory
INFO: SQLErrorCodes loaded: [DB2, Derby, H2, HSQL, Informix, MS-SQL,
MySQL, Oracle, PostgreSQL, Sybase]

org.springframework.jdbc.BadSqlGrammarException:
PreparedStatementCallback; bad SQL grammar [SELECT _URI,
_CREATOR_URI_USER, _CREATION_DATE, _LAST_UPDATE_URI_USER,
_LAST_UPDATE_DATE, TABLE_ID, TABLE_KEY, DB_TABLE_NAME, TYPE,
TABLE_ID_ACCESS_CONTROLS FROM odk.__ODKTABLES__TABLE_DEFINITIONS
WHERE TABLE_ID IN ();]; nested exception is
com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an
error in your SQL syntax; check the manual that corresponds to your MySQL
server version for the right syntax to use near ')' at line 1
at
org.springframework.jdbc.support.SQLErrorCodeSQLExceptionTranslator.doTranslate(SQLErrorCodeSQLExceptionTranslator.java:233)
at
org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:72)
at
org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:603)
at
org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:637)
at
org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:666)
at
org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:674)
at
org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:714)
at
org.opendatakit.common.persistence.engine.mysql.QueryImpl.executeQuery(QueryImpl.java:259)
at org.opendatakit.common.ermodel.simple.Query.execute(Query.java:267)
at
org.opendatakit.aggregate.odktables.TableManager.getTableEntries(TableManager.java:141)
at
org.opendatakit.aggregate.odktables.TableManager.getTables(TableManager.java:84)
at
org.opendatakit.aggregate.odktables.TableManager.getTables(TableManager.java:119)
at
org.opendatakit.aggregate.server.ServerTableServiceImpl.getTables(ServerTableServiceImpl.java:69)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:616)
at
com.google.gwt.user.server.rpc.RPC.invokeAndEncodeResponse(RPC.java:561)
at
com.google.gwt.user.server.rpc.RemoteServiceServlet.processCall(RemoteServiceServlet.java:208)
at
com.google.gwt.user.server.rpc.RemoteServiceServlet.processPost(RemoteServiceServlet.java:248)
at
com.google.gwt.user.server.rpc.AbstractRemoteServiceServlet.doPost(AbstractRemoteServiceServlet.java:62)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:637)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at
org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:330)
at
org.springframework.security.web.access.intercept.FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:118)
at
org.springframework.security.web.access.intercept.FilterSecurityInterceptor.doFilter(FilterSecurityInterceptor.java:84)
at
org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)
at
org.springframework.security.web.access.ExceptionTranslationFilter.doFilter(ExceptionTranslationFilter.java:113)
at
org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)
at
org.springframework.security.web.session.SessionManagementFilter.doFilter(SessionManagementFilter.java:103)
at
org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)
at
org.opendatakit.common.security.spring.SecurityContextHolderAwareAuthPreservingRequestFilter.doFilter(SecurityContextHolderAwareAuthPreservingRequestFilter.java:66)
at
org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)
at
org.springframework.security.web.authentication.AnonymousAuthenticationFilter.doFilter(AnonymousAuthenticationFilter.java:113)
at
org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)
at
org.springframework.security.web.savedrequest.RequestCacheAwareFilter.doFilter(RequestCacheAwareFilter.java:45)
at
org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)
at
org.springframework.security.web.authentication.AbstractAuthenticationProcessingFilter.doFilter(AbstractAuthenticationProcessingFilter.java:183)
at
org.opendatakit.common.security.spring.OpenIDAuthenticationFilter.doFilter(OpenIDAuthenticationFilter.java:40)
at
org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)
at
org.springframework.security.web.authentication.www.DigestAuthenticationFilter.doFilter(DigestAuthenticationFilter.java:115)
at
org.opendatakit.common.security.spring.DigestAuthenticationFilter.doFilter(DigestAuthenticationFilter.java:40)
at
org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)
at
org.opendatakit.common.security.spring.OutOfBandUserFilter.doFilter(OutOfBandUserFilter.java:105)
at
org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)
at
org.opendatakit.common.security.spring.Oauth2ResourceFilter.doFilter(Oauth2ResourceFilter.java:351)
at
org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)
at
org.springframework.security.web.authentication.logout.LogoutFilter.doFilter(LogoutFilter.java:105)
at
org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)
at
org.springframework.security.web.context.SecurityContextPersistenceFilter.doFilter(SecurityContextPersistenceFilter.java:87)
at
org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)
at
org.springframework.security.web.access.channel.ChannelProcessingFilter.doFilter(ChannelProcessingFilter.java:144)
at
org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)
at
org.springframework.security.web.FilterChainProxy.doFilterInternal(FilterChainProxy.java:192)
at
org.springframework.security.web.FilterChainProxy.doFilter(FilterChainProxy.java:160)
at
org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:346)
at
org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:259)
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
at
org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
at
org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:470)
at
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
at
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
at
org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
at
org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:300)
at
org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:859)
at
org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:588)
at
org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489)
at java.lang.Thread.run(Thread.java:679)
Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You
have an error in your SQL syntax; check the manual that corresponds to your
MySQL server version for the right syntax to use near ')' at line 1
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native
Method)
at
sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57)
at
sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
at java.lang.reflect.Constructor.newInstance(Constructor.java:532)
at com.mysql.jdbc.Util.handleNewInstance(Util.java:409)
at com.mysql.jdbc.Util.getInstance(Util.java:384)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1054)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3566)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3498)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1959)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2113)
at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2568)
at
com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2113)
at
com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:2275)
at
com.jolbox.bonecp.PreparedStatementHandle.executeQuery(PreparedStatementHandle.java:172)
at
org.springframework.jdbc.core.JdbcTemplate$1.doInPreparedStatement(JdbcTemplate.java:644)
at
org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:587)
... 69 more

On Wed, Sep 11, 2013 at 8:52 PM, Yaw Anokwa yanokwa@nafundi.com wrote:

Christian,

ODK Aggregate is not tested on Tomcat 7. You can probably make it
work, but I don't know anyone who has successfully done it. Try Tomcat
6 and see if that works.

Yaw

Need ODK services? http://nafundi.com provides form design,
professional support, custom reporting, and software development for
ODK.

On Tue, Sep 10, 2013 at 5:01 AM, Christian Steinebach eidemsnesset@gmail.com wrote:

Hi!

I installed odkaggregate (1.3.4) on a linux box running mysql, tomcat7

When going to hostname/ODKAggregate only the anonymous accessible page
is
shown.
Clicking on 'Login' hangs the system and nothing happens.

Studying the catalina.out file reveals that there is a problem with an
sql
query.

.....
org.springframework.jdbc.BadSqlGrammarException:
PreparedStatementCallback;
bad SQL grammar [SELECT _URI, _CREATOR_URI_USER, _CREATION_DATE,
_LAST_UPDATE_URI_USER, _LAST_UPDATE_DATE, TABLE_ID, TABLE_KEY,
DB_TABLE_NAME, TYPE, TABLE_ID_ACCESS_CONTROLS FROM
odk.__ODKTABLES__TABLE_DEFINITIONS WHERE TABLE_ID IN ();]; nested
exception is com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException:
You
have an error in your SQL syntax; check the manual that corresponds to
your
MySQL server version for the right syntax to use near ')' at line 1
at

org.springframework.jdbc.support.SQLErrorCodeSQLExceptionTranslator.doTranslate(SQLErrorCodeSQLExceptionTranslator.java:233)

......

I could not find anything in the documentation nor in this googlegroup

       Any help appreciated

              Christian

--

Post: opendatakit@googlegroups.com
Unsubscribe: opendatakit+unsubscribe@googlegroups.com
Options: http://groups.google.com/group/opendatakit?hl=en


You received this message because you are subscribed to the Google
Groups
"ODK Community" group.
To unsubscribe from this group and stop receiving emails from it, send
an
email to opendatakit+unsubscribe@googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.

--

Post: opendatakit@googlegroups.com
Unsubscribe: opendatakit+unsubscribe@googlegroups.com
Options: http://groups.google.com/group/opendatakit?hl=en


You received this message because you are subscribed to a topic in the
Google Groups "ODK Community" group.
To unsubscribe from this topic, visit
https://groups.google.com/d/topic/opendatakit/ULKkwHnZ0rc/unsubscribe.
To unsubscribe from this group and all its topics, send an email to
opendatakit+unsubscribe@googlegroups.com.

For more options, visit https://groups.google.com/groups/opt_out.

--

Post: opendatakit@googlegroups.com
Unsubscribe: opendatakit+unsubscribe@googlegroups.com
Options: http://groups.google.com/group/opendatakit?hl=en


You received this message because you are subscribed to the Google Groups
"ODK Community" group.
To unsubscribe from this group and stop receiving emails from it, send an
email to opendatakit+unsubscribe@googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.

--
Mitch Sundt
Software Engineer
University of Washington
mitchellsundt@gmail.com