1. Please take a little time for this simple survey! Thank you for participating!
    Dismiss Notice
  2. Dear Pleskians, please read this carefully! New attachments and other rules Thank you!
    Dismiss Notice
  3. Dear Pleskians, I really hope that you will share your opinion in this Special topic for chatter about Plesk in the Clouds. Thank you!
    Dismiss Notice

Setting up Struts/Tomcat to work with MySQL. Not working from Plesk!

Discussion in 'Plesk for Linux - 8.x and Older' started by coglethorpe, Aug 8, 2005.

  1. coglethorpe

    coglethorpe Guest

    I have a Tomcat (struts) applicaiton that I am deploying from Plesk. I have a user set up in MySQL that the app can connect to and everything works fine on my test box. However, I can't connect from my Tomcat application after I deploy it to my web server with Plesk.

    I have even connected to MySQL with a regular Java application via JDBC, but my connection pool does not work. I get this exception--"java.security.AccessControlException: access denied (java.lang.RuntimePermission accessDeclaredMembers)"

    Any ideas? I can login to MySQL just fine from the command line or a JDBC appication. But no-go from Struts/Tomcat!

    Here's the chunk of my strtus-config.xml file that does the data source:

    <data-source key="mykey" type="org.apache.commons.dbcp.BasicDataSource">
    <set-property property="description" value="Ubilik Database"/>
    <set-property property="driverClassName" value="com.mysql.jdbc.Driver"/>
    <set-property property="username" value="myuser"/>
    <set-property property="password" value="mypass"/>
    <set-property property="url" value="jdbc:mysql://localhost/test" />
    <set-property property="maxCount" value="3"/>
    <set-property property="minCount" value="2"/>
  2. coglethorpe

    coglethorpe Guest

    Solving my own problem.

    The issue is the catalina.policy file. On the server I am using Tomcat runs with the security policy in place. I have made a few changes there and I think I'm going in the right direction. I have to make one more change to get JDBC ok to run.