Hi, "Table not found" usually means that you are using an empty database.
You are using an in-memory database. I suggest to try with a persistent database first, and if that works, see the documentation about in-memory databases. Regards, Thomas On Tue, Aug 13, 2013 at 1:42 AM, <[email protected]> wrote: > Still a blocker... Any ideas? > > > On Thursday, August 8, 2013 11:00:24 PM UTC-5, [email protected] wrote: >> >> I'm getting this >> >> Caused by: org.h2.jdbc.JdbcSQLException: Table "ACCOUNT" not found; SQL >> statement: >> >> >> The table is there and database connection is active >> >> Here is the url >> >> >> jdbc:h2:mem:xyz;DB_CLOSE_**DELAY=-1;LOCK_TIMEOUT=2500;**AUTOCOMMIT=OFF;DATABASE_TO_**UPPER=true; >> >> >> >> Running liquibase changesets..etc. works on macosx, fails on jenkins(ubuntu) >> >> >> here is more output >> >> >> Caused by: org.h2.jdbc.JdbcSQLException: Table "ACCOUNT" not found; SQL >> statement: >> select account0_.id as id1_0_, account0_.date_created as date2_0_, >> account0_.email as email3_0_, account0_.enabled as enabled4_0_, >> account0_.firstname as firstnam5_0_, account0_.lastname as lastname6_0_, >> account0_.password as password7_0_, account0_.username as username8_0_ from >> account account0_ where account0_.username=? [42102-173] >> at >> org.h2.message.DbException.**getJdbcSQLException(**DbException.java:331) >> at org.h2.message.DbException.**get(DbException.java:171) >> at org.h2.message.DbException.**get(DbException.java:148) >> at org.h2.command.Parser.**readTableOrView(Parser.java:**4864) >> at org.h2.command.Parser.**readTableFilter(Parser.java:**1107) >> at org.h2.command.Parser.**parseSelectSimpleFromPart(**Parser.java:1713) >> at org.h2.command.Parser.**parseSelectSimple(Parser.java:**1821) >> at org.h2.command.Parser.**parseSelectSub(Parser.java:**1707) >> at org.h2.command.Parser.**parseSelectUnion(Parser.java:**1550) >> at org.h2.command.Parser.**parseSelect(Parser.java:1538) >> at org.h2.command.Parser.**parsePrepared(Parser.java:405) >> at org.h2.command.Parser.parse(**Parser.java:279) >> at org.h2.command.Parser.parse(**Parser.java:251) >> at org.h2.command.Parser.**prepareCommand(Parser.java:**218) >> at org.h2.engine.Session.**prepareLocal(Session.java:428) >> at org.h2.engine.Session.**prepareCommand(Session.java:**377) >> at >> org.h2.jdbc.JdbcConnection.**prepareCommand(JdbcConnection.**java:1138) >> at >> org.h2.jdbc.**JdbcPreparedStatement.<init>(**JdbcPreparedStatement.java:70) >> at >> org.h2.jdbc.JdbcConnection.**prepareStatement(**JdbcConnection.java:267) >> at >> org.hibernate.engine.jdbc.**internal.**StatementPreparerImpl$5.**doPrepare(**StatementPreparerImpl.java:**161) >> at >> org.hibernate.engine.jdbc.**internal.**StatementPreparerImpl$**StatementPreparationTemplate.**prepareStatement(**StatementPreparerImpl.java:**182) >> at >> org.hibernate.engine.jdbc.**internal.**StatementPreparerImpl.**prepareQueryStatement(**StatementPreparerImpl.java:**159) >> at >> org.hibernate.loader.Loader.**prepareQueryStatement(Loader.**java:1859) >> at >> org.hibernate.loader.Loader.**executeQueryStatement(Loader.**java:1836) >> at >> org.hibernate.loader.Loader.**executeQueryStatement(Loader.**java:1816) >> at org.hibernate.loader.Loader.**doQuery(Loader.java:900) >> at >> org.hibernate.loader.Loader.**doQueryAndInitializeNonLazyCol**lections(Loader.java:342) >> at org.hibernate.loader.Loader.**doList(Loader.java:2526) >> at org.hibernate.loader.Loader.**doList(Loader.java:2512) >> at >> org.hibernate.loader.Loader.**listIgnoreQueryCache(Loader.**java:2342) >> at org.hibernate.loader.Loader.**list(Loader.java:2337) >> at org.hibernate.loader.hql.**QueryLoader.list(QueryLoader.**java:495) >> at >> org.hibernate.hql.internal.**ast.QueryTranslatorImpl.list(**QueryTranslatorImpl.java:356) >> at >> org.hibernate.engine.query.**spi.HQLQueryPlan.performList(**HQLQueryPlan.java:195) >> at org.hibernate.internal.**SessionImpl.list(SessionImpl.**java:1269) >> at org.hibernate.internal.**QueryImpl.list(QueryImpl.java:**101) >> at org.hibernate.ejb.QueryImpl.**getSingleResult(QueryImpl.**java:285) >> at >> org.hibernate.ejb.criteria.**CriteriaQueryCompiler$3.**getSingleResult(**CriteriaQueryCompiler.java:**258) >> 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:606) >> at >> org.springframework.orm.jpa.**SharedEntityManagerCreator$**DeferredQueryInvocationHandler**.invoke(**SharedEntityManagerCreator.**java:311) >> at com.sun.proxy.$Proxy68.**getSingleResult(Unknown Source) >> at >> org.springframework.data.jpa.**repository.query.**JpaQueryExecution$**SingleEntityExecution.**doExecute(JpaQueryExecution.**java:123) >> at >> org.springframework.data.jpa.**repository.query.**JpaQueryExecution.execute(**JpaQueryExecution.java:55) >> at >> org.springframework.data.jpa.**repository.query.**AbstractJpaQuery.doExecute(**AbstractJpaQuery.java:95) >> at >> org.springframework.data.jpa.**repository.query.**AbstractJpaQuery.execute(**AbstractJpaQuery.java:85) >> at >> org.springframework.data.**repository.core.support.**RepositoryFactorySupport$**QueryExecutorMethodInterceptor**.invoke(**RepositoryFactorySupport.java:**312) >> at >> org.springframework.aop.**framework.**ReflectiveMethodInvocation.**proceed(**ReflectiveMethodInvocation.**java:172) >> at >> org.springframework.**transaction.interceptor.**TransactionInterceptor$1.**proceedWithInvocation(**TransactionInterceptor.java:**96) >> at >> org.springframework.**transaction.interceptor.**TransactionAspectSupport.**invokeWithinTransaction(**TransactionAspectSupport.java:**260) >> at >> org.springframework.**transaction.interceptor.**TransactionInterceptor.invoke(**TransactionInterceptor.java:**94) >> at >> org.springframework.aop.**framework.**ReflectiveMethodInvocation.**proceed(**ReflectiveMethodInvocation.**java:172) >> at >> org.springframework.dao.**support.**PersistenceExceptionTranslatio**nInterceptor.invoke(**PersistenceExceptionTranslatio**nInterceptor.java:155) >> at >> org.springframework.aop.**framework.**ReflectiveMethodInvocation.**proceed(**ReflectiveMethodInvocation.**java:172) >> at >> org.springframework.data.jpa.**repository.support.**LockModeRepositoryPostProcesso**r$**LockModePopulatingMethodInterc**ceptor.invoke(**LockModeRepositoryPostProcesso**r.java:92) >> at >> org.springframework.aop.**framework.**ReflectiveMethodInvocation.**proceed(**ReflectiveMethodInvocation.**java:172) >> at >> org.springframework.aop.**interceptor.**ExposeInvocationInterceptor.**invoke(**ExposeInvocationInterceptor.**java:91) >> at >> org.springframework.aop.**framework.**ReflectiveMethodInvocation.**proceed(**ReflectiveMethodInvocation.**java:172) >> at >> org.springframework.aop.**framework.JdkDynamicAopProxy.**invoke(JdkDynamicAopProxy.**java:204) >> at com.sun.proxy.$Proxy60.**findByUsername(Unknown Source) >> at >> com.xyz.project.service.**account.AccountServiceImpl.**init(AccountServiceImpl.java:**52) >> 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:606) >> at >> org.springframework.beans.**factory.annotation.**InitDestroyAnnotationBeanPostP**rocessor$LifecycleElement.**invoke(**InitDestroyAnnotationBeanPostP**rocessor.java:344) >> at >> >> >> -- > You received this message because you are subscribed to the Google Groups > "H2 Database" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to [email protected]. > To post to this group, send email to [email protected]. > Visit this group at http://groups.google.com/group/h2-database. > For more options, visit https://groups.google.com/groups/opt_out. > > > -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at http://groups.google.com/group/h2-database. For more options, visit https://groups.google.com/groups/opt_out.
