i install mysql , jdk and tomcat.
when i run java file it give message that no database connection available .
where to put mysql connector and how to set class path in environment variable .
plz help me
on 03/07/2010 – Made popular on 03/07/2010
I have been trying to deploy one of my projects that uses jsp for the front end, tomcat7 for the server and a mysql database. I tried integrating the mysql database with the libreoffice database because I had to copy a lot of data from existing excel sheets and then paste it into the database. I downloaded the connector from the MySQL site and put it in the library of tomcat7.
Using Ubuntu 13.10 on virtual server hosted by OVH (France), Server version: Apache/2.4.6 (Ubuntu), OpenJDK Runtime Environment (IcedTea6 1.13.3) OpenJDK 64-Bit Server VM (build 23.25-b01, mixed mode), TOMCAT 6, and MySQL 5.5.37-0ubuntu0.13.10.1.
When trying to connect to mysql from a java class, i get this : javax.servlet.ServletException: java.lang.UnsupportedClassVersionError: com/mysql/jdbc/D
I've got MySQL Connector/ODBC 5.1 installed on my Windows Vista laptop. I have MySQL 5.5.19 installed on the laptop, and was able to connect to it via the Windows Data Source Administrator app and the MySQL Connector/ODBC using a TCP/IP connection to 'localhost'.