Hi, since 3 weeks i try and retry (and retry) to deploy jasperreports-server-cp-5.1.0 in glassfish with Mysql Database 5.5.
Each time that i try to deploy war file i receive the following error:
:Error occurred during deployment: Exception while loading the app : java.lang.IllegalStateException: ContainerBase.addChild: start: org.apache.catalina.LifecycleException: com.jaspersoft.jasperserver.api.JSExceptionWrapper: could not execute query; SQL [select this_.id as id2_0_, this_.version as version2_0_, this_.uri as uri2_0_, this_.hidden as hidden2_0_, this_.name as name2_0_, this_.label as label2_0_, this_.description as descript7_2_0_, this_.parent_folder as parent8_2_0_, this_.creation_date as creation9_2_0_, this_.update_date as update10_2_0_ from JIResourceFolder this_ where (this_.uri=?)]; nested exception is org.hibernate.exception.SQLGrammarException: could not execute query. Please see server.log for more details.]]
Someone have an idea ?
Have tested connexion manually, tested glassfigh jdbc successfully, try qurey (with succes) into Mysql Database ... All work properly except when deploy.
I try too to generate my own jasperserver.war from jasperreports-server-cp-5.1.0-src and i got the exacte same result.
Please Help.
David
