Update: I erased the .war file, replacet the version 8 of the ConnectorJ with mysql-connector-java-5.1.47-bin.jar, uploaded and deployed. Now there is no deployment error, yet the connection with the MySql database is not working. Here is (part of) the error stack:
org.apache.jasper.JasperException: An exception occurred processing JSP page [/index.jsp] at line [65]
62: String mysql_database = "joomleex_idara";
63: String mysql_username = "joomleex_admin";
64: String mysql_password = "<removed>";
65: Connection connection = DriverManager.getConnection(
66: "jdbc:mysql://127.0.0.1/" + mysql_database,
67: mysql_username,
68: mysql_password
Root Cause
javax.servlet.ServletException: java.sql.SQLException: No suitable driver found for jdbc:mysql://127.0.0.1/joomleex_idara
I can figure out the error depends from either [a] the connection string (which I copied from the example on heliohost) or the lack of suitable driver on tomcat/lib and java/(jdk/jre)/lib/ext on heliohost server. If anybody has a clue that changing the connection string might solve the issue, please send me suggestions. Case is possible, since I got the same error on my local pc before copying the connector jar on both tomcat and java lib folders.
In the latter case, a possible solution would be to upload in the .war WEB-INF/lib folder another connector which matches exactly what is in tomcat (and java) lib folders on the server. Since I have no access to those folders, I can only imagine. Please give me some hint if that could be a solution.
Any help will be very appreciated.
Thank you,
Giuliano