I can't get many of the Sample Test Drive examples included with Livecycle Data Services ES 2.5.1 to work properly with Tomcat (both version 5.5.25 and 6.0.14). I've tried both on Windows XP SP2 and Mac OSX (10.4), but I get the same errors on both platforms. I can however get the Sample Test Drive from LCDS to work fine with the JRun server on Windows (included with the Windows version of LCDS). I've setup the JRun server in a similar fashion as Tomcat (see my steps below) and everything works fine. I haven't been as successful with Tomcat. Can anyone point out where I'm going wrong with my Tomcat setup?
I am using Java 1.5.0.
Here are the error messages I get when trying out the LCDS Test Drive examples on Tomcat:
Sample 1 - Accessing data using an HTTP service (after pressing the "Get Data" button):
[RPC Fault faultString="Unable to invoke a fill operation on destination 'inventory' due to the following error: class flex.samples.DAOException:java.sql.SQLException: Connection is broken." faultCode="Server.Processing" faultDetail="null"]
3a. Add Java Open Transaction Manager (JOTM) from http://jotm.objectweb.org/. Copy the JAR files from [jotm-root]/lib to [tomcat-root]/common/lib/.
3b. Create a context file for your web application and register JOTM using the Transaction element, e.g. for the samples WAR create a [tomcat-root]/conf/Catalina/localhost/samples.xml file and add the following lines:
3c. Increase the maximum memory to at least 512MB. For Tomcat, this is achieved by specifying the maximum heap size for the JVM in the JAVA_OPTS variable in [tomcat-root]/bin/catalina.sh:
4. Run the tomcat server ([tomcat-root]/bin/startup.sh for Mac OS or [tomcat-root]\bin\startup.bat for WinXP) which extracts the 3 .war files into their respective directories in [tomcat-root]/webapps/