• Introducing WebPros Cloud - a fully managed infrastructure platform purpose-built to simplify the deployment of WebPros products !  WebPros Cloud enables you to easily deliver WebPros solutions — without the complexity of managing the infrastructure.
    Join the pilot program today!
  • Support for BIND DNS has been removed from Plesk for Windows due to security and maintenance risks.
    If a Plesk for Windows server is still using BIND, the upgrade to Plesk Obsidian 18.0.70 will be unavailable until the administrator switches the DNS server to Microsoft DNS.

MySQL JDBC

F

fparvini

Guest
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
 
Just the same problem here.
It works out of the box with a standart tomcat setup....
 
Back
Top