tomcat - problems deploying project in Worklight 5.0.6 -
running worklight 5.0.6 on tomcat 7 mysql 5.6
i dropped previous databases , let install manager recreate them. console runs fine , able upload wlapp , adapetrs. however, after deploying myproject.war following error every 5 seconds:
severe: persistency data access problem com.worklight.core.exceptions.persistentdataaccessexception: persistency data access problem @ com.worklight.core.exceptions.defaultexceptionhandler.handleexception(defaultexceptionhandler.java:50) @ com.worklight.core.tasks.taskthread.run(taskthread.java:100) caused by: org.springframework.dao.invaliddataaccessapiusageexception: can perform operation while transaction active.; nested exception <openjpa-1.2.2-r422266:898935 nonfatal user error> org.apache.openjpa.persistence.transactionrequiredexception: can perform operation while transaction active.
os: windows server 2008 r2 standard
databases: appcntr, wlreport, wrklght
content of context.xml
<context> <resource name="jdbc/worklightds" auth="container" type="javax.sql.datasource" maxactive="100" maxidle="30" maxwait="10000" username="worklight" password="***" driverclassname="com.mysql.jdbc.driver" url="jdbc:mysql://localhost:3306/wrklght"/> <resource name="jdbc/worklightreportsds" auth="container" type="javax.sql.datasource" maxactive="100" maxidle="30" maxwait="10000" username="worklight" password="***" driverclassname="com.mysql.jdbc.driver" url="jdbc:mysql://localhost:3306/wlreport"/> <resource name="jdbc/appcenterds" auth="container" type="javax.sql.datasource" maxactive="100" maxidle="30" maxwait="10000" username="worklight" password="***" driverclassname="com.mysql.jdbc.driver" url="jdbc:mysql://localhost:3306/appcntr"/> </context>
tomcat's web.xml
<resource-ref> <res-ref-name>jdbc/worklightds</res-ref-name> <res-type>javax.sql.datasource</res-type> <res-auth>container</res-auth> </resource-ref> <resource-ref> <res-ref-name>jdbc/worklightreportsds</res-ref-name> <res-type>javax.sql.datasource</res-type> <res-auth>container</res-auth> </resource-ref>
worklight.properties
wl.db.jndi.name=java:comp/env/jdbc/worklightds wl.db.type=mysql
here steps in more details: yes, here steps:
use im install worklight 5.0.6.1 - puts 3 webapps in tomcat folder: appcenterconsole.war, applicationcenter.war, , worklight.war
run console (runs successfully):
http://hostname:8080/worklight/console
create hybrid project in eclipse generates myprojectname.war file in /bin folder
update publicworklightcontext, publicworklightport, wl.db.type, wl.db.jndi.name variables found in workllight.properties file in server/conf folder of project.
rename myproject.war myappname.war match value of publicworklightcontext variable
manually drop myappname.war file under webapps folder of tomcat (this when error starts appearing)
additionaly upload adapter , wlapp files through worklight console. step works fine , can see respective records created in databases
make sure there 1 worklight .war file deployed.
per steps you've mentioned, seems did not remove current worklight .war file tomcat prior dropping new .war file. there can 1 worklight .war file @ time.
- go
http://yourhost:8080/manager
, make sure disable , undeploy current worklight .war file. - using tomcat manager, deploy new .war file
- go
http://yourhost:8080/yourcontext/console
, deploy apps related worklight project
Comments
Post a Comment