tomcat-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Mark Koscak" <m...@logichip.com.au>
Subject Re: mm JDBC driver
Date Thu, 28 Dec 2000 22:15:50 GMT
On my system I added the classpath to my mm.mysql installation directory or
/usr/local/mm.mysql.jdbc-1.2c  This was enough to give me access to my
database.

Here is some sample code that you can modify to retrive data from your
database.

import java.sql.*;
import java.io.*;

public class newjavadb
{

        public static void main( String [ ] args )
        {
                String username = "avaliduser";
                String password = "avalidpwd";
                String url = "jdbc:mysql://domain.com.au/databasename";
                String queryString = "SELECT ves_ref FROM
lbs_web_ves_sched";
                int count = 0;
                // Load the driver
                try
                {

Class.forName("org.gjt.mm.mysql.Driver").newInstance();
                        System.out.println("Success Driver Loaded" );
                }
                catch(java.lang.ClassNotFoundException e)
                {
                        System.err.print("ClassNotFoundException: ");
                        System.err.println( e.getMessage() );
                }
                catch( Exception e )
                {
                        System.err.print("Exception : " + e );
                }

                try
                {
                        System.out.println("Inside Connection Try block" );
                        Connection con;
                        Statement stmt;
                        System.out.println("url is :" + url );

                        // Establish connection to the database
                        con = DriverManager.getConnection(url, username,
password);
                        System.out.println("Ok, connection to the DB
worked.");
                        System.out.println("Let's see can retrieve something
with : " +
                                        queryString );

                        // Create a Statement object
                        stmt = con.createStatement();
                        // Send the query and bind the result to a set
                        ResultSet rs = stmt.executeQuery(queryString);
                        while( rs.next() )
                        {
                                count++;
                                String s = rs.getString("ves_ref");
                                System.out.println( s + "is the FIELD value.
Count is:" + count );
                        }

                        // Close resources
                        stmt.close();
                        con.close();
                }// end try block
                catch( SQLException ex)
                {
                        System.err.println("==> SQLException: ");
                        while(ex != null)
                        {
                                System.out.println("Message:  " +
ex.getMessage() );
                                System.out.println("SQLState: " +
ex.getSQLState() );
                                System.out.println("ErrorCode: " +
ex.getErrorCode() );
                                ex = ex.getNextException();
                                System.out.println(" ");
                        }
                }// end catch block
        }// end main
}// end class newjavadb


----- Original Message -----
From: Shailaja Someshwar <shailasum@yahoo.com>
To: <tomcat-user@jakarta.apache.org>
Sent: Thursday, December 28, 2000 10:27 PM
Subject: mm JDBC driver


> Hello
>
> Where do I need to place the mm.jdbc driver for MySQL
> in tomcat directory so that its available system wide
> and all of the Apache virtual hosts.
>
> Also can someone direct me to a sample application to
> test my JDBC connection is working or not, as I do not
> know much about Java.
>
> Thanks in advance.
>
> Regards,
> Shailaja
>
> __________________________________________________
> Do You Yahoo!?
> Yahoo! Photos - Share your holiday photos online!
> http://photos.yahoo.com/


Mime
View raw message