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:

  1. use im install worklight 5.0.6.1 - puts 3 webapps in tomcat folder: appcenterconsole.war, applicationcenter.war, , worklight.war

  2. run console (runs successfully): http://hostname:8080/worklight/console

  3. create hybrid project in eclipse generates myprojectname.war file in /bin folder

  4. update publicworklightcontext, publicworklightport, wl.db.type, wl.db.jndi.name variables found in workllight.properties file in server/conf folder of project.

  5. rename myproject.war myappname.war match value of publicworklightcontext variable

  6. manually drop myappname.war file under webapps folder of tomcat (this when error starts appearing)

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

  1. go http://yourhost:8080/manager , make sure disable , undeploy current worklight .war file.
  2. using tomcat manager, deploy new .war file
  3. go http://yourhost:8080/yourcontext/console , deploy apps related worklight project

Comments

Popular posts from this blog

linux - xterm copying to CLIPBOARD using copy-selection causes automatic updating of CLIPBOARD upon mouse selection -

c++ - qgraphicsview horizontal scrolling always has a vertical delta -