Table "PROPERTY_VALUE" not found

[daimh]

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)
.....

[eamonnmag]

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.

[daimh]

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
#57 (comment).

[eamonnmag]

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//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

OX1 3QG, UK