BioInvIndex icon indicating copy to clipboard operation
BioInvIndex copied to clipboard

Table "PROPERTY_VALUE" not found

Open daimh opened this issue 10 years ago • 3 comments

I tried mysql, and then h2 without any modification, but my jboss always gives me this error when I was trying to access the bioinvindex web address for the first time.

52:36,483 WARN [InterceptorsFactory] EJBTHREE-1246: Do not use InterceptorsFactory with a ManagedObjectAdvisor, InterceptorRegistry should be used via the bean container 12:52:36,484 WARN [InterceptorsFactory] EJBTHREE-1246: Do not use InterceptorsFactory with a ManagedObjectAdvisor, InterceptorRegistry should be used via the bean container 12:52:37,456 WARN [JDBCExceptionReporter] SQL Error: 42102, SQLState: 42S02 12:52:37,456 ERROR [JDBCExceptionReporter] Table "PROPERTY_VALUE" not found; SQL statement: select distinct propertyva0_.value as col_0_0_ from property_value propertyva0_, PROPERTY property1_ where propertyva0_.PROPERTY_ID=property1_.id and lower(property1_.value)='organism' [42102-150] 12:52:37,462 ERROR [FiltersProvider] Cannot read a list of Organisms from the DB javax.persistence.PersistenceException: org.hibernate.exception.SQLGrammarException: could not execute query at org.hibernate.ejb.AbstractEntityManagerImpl.throwPersistenceException(AbstractEntityManagerImpl.java:614) at org.hibernate.ejb.QueryImpl.getResultList(QueryImpl.java:76) .....

daimh avatar Jul 30 '13 17:07 daimh