Blog

You may find here solutions for some common problems that our fast growing community members faced. If you don’t find an answer here do not hesitate to contact tinyPM support.

Installation

For the detailed instructions about tinyPM installation please refer to How to install tinyPM? page and INSTALL.txt/UPDATE.txt files which are always included with the tinyPM distributions.

1. I’ve copied my MySQL JDBC driver .jar file to %CATALINA_HOME%/lib but I’m getting the org.apache.tomcat.dbcp.dbcp.SQLNestedException: Cannot load JDBC driver class ‘com.mysql.jdbc.Driver’ exception. Why is that?

Make sure that all the tinyPM dependency files you’ve copied have proper rights set. Problably you need to change the owner/group and/or add a read access to the same user that other files in this directory have, otherwise Tomcat that you run will not be able to read and load the MySQL driver and that is causing the exception.

2. I’ve changed the META-INF/context.xml to contain my valid MySQL user and password for my tinyPM database, but I’m getting the [ERROR,org.hibernate.util.JDBCExceptionReporter] Cannot create PoolableConnectionFactory (Access denied for user ‘tinypm’@'localhost’ (using password: NO)) exception. Why is tinyPM not using the user/password I’ve set?

Tomcat sometimes copies the file from META-INF/context.xml before you make your changes. Especialy when letting Tomcat to unpack the tinypm.war file or doing the installation on the running Tomcat. Do the following steps:

• make sure you have a valid user/password information set in the %CATALINA_HOME%/webapps/tinypm/META-INF/context.xml
• stop Tomcat
• remove the file %CATALINA_HOME%/conf/Catalina/localhost/tinypm.xml (this is a copy of the original context.xml file that Tomcat does, and it might be copied by Tomcat before you’ve made changes to the one in the application directory).
• start Tomcat (Tomcat will copy the context.xml file once again, but it should now contain the valid connection settings)
• take a look at the newly created %CATALINA_HOME%/conf/Catalina/localhost/tinypm.xml and check if it contains the valid user and password now
• access the tinyPM application

3. I have a problem when running tinyPM in shared Tomcat instance with Security Manager turned on. I get the exception com.sun.faces.config.ConfigurationException: CONFIGURATION FAILED! access denied (java.lang.RuntimePermission modifyThread)

The problem is caused by the JSF RI implemention, which requires modifyThread persmission. Add the followin permission in your catalina.policy file for tinyPM webapp:

permission java.lang.RuntimePermission “modifyThread”;