|
Before I forget, the MySQL driver dependency may need to remain until Hibernate supports the MariaDB driver (or a workaround is implemented). I'm not 100% sure about this – it will require verification (from memory, I received an exception if the MySQL dependency was removed from the build.gradle file – I'm just not sure if this was really Hibernate or Flyway that caused it – if Flyway, the fix above should resolve the exception).
For reference, this is the exception received when MariaDB was used before the changes (as sent via email earlier):
11:44:38.986 http-bio-8443-exec-3 INFO o.m.i.s.f.TenantAwareBasicAuthenticationFilter - {"startTime":1380653078917,"totalTime":68,"method":"GET","url":"https://localhost:8443/mifosng-provider/api/v1/runreports/FullReportList","parameters":{"parameterType":["true"]}}
Servlet.service() for servlet jersey-serlvet in context with path /mifosng-provider threw exception
org.springframework.jdbc.BadSqlGrammarException: StatementCallback; bad SQL grammar select x.* from (select parameter_sql as the_sql from stretchy_parameter where parameter_name = 'FullReportList') x; nested exception is com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'mifostenant-default.x' doesn't exist
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:407)
at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:456)
at org.springframework.jdbc.core.JdbcTemplate.queryForRowSet(JdbcTemplate.java:499)
at org.mifosplatform.infrastructure.dataqueries.service.ReadReportingServiceImpl.getSql(ReadReportingServiceImpl.java:221)
at org.mifosplatform.infrastructure.dataqueries.service.ReadReportingServiceImpl.getSQLtoRun(ReadReportingServiceImpl.java:193)
at org.mifosplatform.infrastructure.dataqueries.service.ReadReportingServiceImpl.retrieveGenericResultset(ReadReportingServiceImpl.java:182)
at org.mifosplatform.infrastructure.dataqueries.api.RunreportsApiResource.runReport(RunreportsApiResource.java:107)
...
Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'mifostenant-default.x' doesn't exist
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)
at java.lang.reflect.Constructor.newInstance(Constructor.java:513)
at com.mysql.jdbc.Util.handleNewInstance(Util.java:411)
at com.mysql.jdbc.Util.getInstance(Util.java:386)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1054)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4187)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4119)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2570)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2731)
at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2809)
at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2758)
at com.mysql.jdbc.StatementImpl.executeQuery(StatementImpl.java:1612)
at com.mysql.jdbc.Field.getCollation(Field.java:493)
at com.mysql.jdbc.ResultSetMetaData.isCaseSensitive(ResultSetMetaData.java:567)
at com.sun.rowset.CachedRowSetImpl.initMetaData(CachedRowSetImpl.java:704)
at com.sun.rowset.CachedRowSetImpl.populate(CachedRowSetImpl.java:621)
at org.springframework.jdbc.core.SqlRowSetResultSetExtractor.createSqlRowSet(SqlRowSetResultSetExtractor.java:84)
at org.springframework.jdbc.core.SqlRowSetResultSetExtractor.extractData(SqlRowSetResultSetExtractor.java:67)
at org.springframework.jdbc.core.SqlRowSetResultSetExtractor.extractData(SqlRowSetResultSetExtractor.java:1)
at org.springframework.jdbc.core.JdbcTemplate$1QueryStatementCallback.doInStatement(JdbcTemplate.java:446)
at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:396)
|
