ISA-tools / BioInvIndex

The web application, model, database persistence, services package and web services for the BII. Led by Eamonn Maguire (Uni. of Oxford) & Philippe Rocca-Serra (Uni. of Oxford).
http://www.isa-tools.org
16 stars 13 forks source link

Table "PROPERTY_VALUE" not found #57

Open daimh opened 11 years ago

daimh commented 11 years ago

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 "PROPERTYVALUE" not found; SQL statement: select distinct propertyva0.value as col_00 from propertyvalue propertyva0, PROPERTY property1 where propertyva0.PROPERTYID=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 commented 11 years ago

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 commented 11 years ago

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.

eamonnmag commented 11 years ago

We would have responded quicker had the email notification been switched on. You can also email us via isatools@googlegroups.com 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 notifications@github.com 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

OX1 3QG, UK