ISA-tools
Table "PROPERTY_VALUE" not found
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) .....
You need to initialise the database using the BII Data Manager. This will create all the tables you need and the query will not fail. It will be empty though until you load something.
Thanks a million for your quick reply!
will try that soon, and hopefully won't need bother you more
Best, Manhong On 07/31/2013 02:00 PM, Eamonn Maguire wrote:
You need to initialise the database using the BII Data Manager. This will create all the tables you need and the query will not fail. It will be empty though until you load something.
— Reply to this email directly or view it on GitHub https://github.com/ISA-tools/BioInvIndex/issues/57#issuecomment-21882406.
We would have responded quicker had the email notification been switched on. You can also email us via [email protected] if you have questions. Issues are generally good too though since it allows us to keep track of everything :)
On 31 July 2013 19:07, daimh [email protected] wrote:
Thanks a million for your quick reply!
will try that soon, and hopefully won't need bother you more
Best, Manhong On 07/31/2013 02:00 PM, Eamonn Maguire wrote:
You need to initialise the database using the BII Data Manager. This will create all the tables you need and the query will not fail. It will be empty though until you load something.
— Reply to this email directly or view it on GitHub < https://github.com/ISA-tools/BioInvIndex/issues/57#issuecomment-21882406>.
— Reply to this email directly or view it on GitHubhttps://github.com/ISA-tools/BioInvIndex/issues/57#issuecomment-21882902 .
Eamonn Maguire
Lead Software Engineer - ISA tools http://www.isa-tools.org
University of Oxford Tel: +44(0)1865 610788
Oxford e-Research Center
7 Keble Road, Oxford skype: maguire1986