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

MySQL JDBC

Discussion in 'Plesk for Linux - 8.x and Older' started by fparvini, Jan 16, 2006.

  1. fparvini

    fparvini Guest

    0
     
    I wrote a small code for connection to MySQL trhough JDBC

    <%@ page import="java.sql.*" %>

    <%!
    // mysql driver
    String driver = "com.mysql.jdbc.Driver";

    // the "url" to our DB, the last part is the name of the DB
    String url = "jdbc:mysql://localhost/test";

    // the default DB username and password may be the same as your control panel login

    String name = "my_user";
    String pass = "my_pass";
    %>

    <%

    try
    {
    // Test the DB connection by making an empty table
    String sql_command = "select * from test where id=1;";
    Class.forName( driver );

    // initialize the Connection, with our DB info ...
    Connection con = DriverManager.getConnection( url, name, pass );

    Statement stat = con.createStatement();

    stat.executeQuery( sql_command );
    %>


    I have also downloaded mysql-connector-java-3.1.12.tar ,

    Put it in /var/tomcat4/server/lib , changed /etc/rc.d/init.d/tomcat4 and added these lines to it

    CLASSPATH=/var/tomcat4/server/lib/mysql-connector-java-3.1.10-bin.jar:$CLASSPATH
    export CLASSPATH

    and restart tomcat by /etc/rc.d/init.d/tomcat4 restart
    but still get this error message


    jdbc:mysql://localhost/test
    Error opening JDBC, cause:
    java.lang.ClassNotFoundException: com.mysql.jdbc.Driver
     
  2. ktulur

    ktulur Guest

    0
     
    Just the same problem here.
    It works out of the box with a standart tomcat setup....
     
Loading...