Thanks for your response.
I have indeed got
datasource.classname org.gjt.mm.mysql.Driver
in the MySql.properties file...
----- Original Message -----
From: "Hélène JOANIN" <[EMAIL PROTECTED]>
To: "Rosalind Wilson" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Thursday, March 08, 2001 2:08 PM
Subject: Re: Still Cannot load JDBC driver....
> Hi,
>
> Is the 'datasource.classname' property in the properties file defining
> the datasource, really correct ?
>
> It should be
> datasource.classname org.gjt.mm.mysql.Driver
> instead of
> datasource.classname org/gjt/mm/mysql/Driver
>
> Kind regards.
> Hélène.
>
> Rosalind Wilson wrote:
> >
> > I'm still entirely unable to load the mysql driver to run the Jonas
examples.
> > I would be extremely grateful for help.
> >
> > I added a test class (JdbcTest - see below) to the EJBServer script, and
it
> > happily finds and loads the driver. The EJBServer however fails to find
it.
> > Here is my EJBServer script:
> >
> > -----------------------------------------------------
> >
> > if [ ! -f $JONAS_ROOT/bin/unix/config_env ]
> > then
> > echo "JONAS_ROOT must be set"
> > exit 1
> > fi
> >
> > . $JONAS_ROOT/bin/unix/config_env
> >
> > echo $CLASSPATH
> >
> > java JdbcTest
> >
> > java -Djava.naming.provider.url=rmi://localhost:1099
> > -Djava.naming.factory.url.pkgs=org.objectweb.jonas/naming
>
> -Dinstall.root=$JONAS_ROOT -Djava.security.policy=$JONAS_ROOT/java.policy
"$@"
> > org.objectweb.jonas.server.Server
> >
> > --------------------------------------------------------------
> >
> > and here is the output I get:
> >
> > --------------------------------------------------------------
> >
> > rozwilson:/usr/JONAS/examples/src/sb # EJBServer
> >
> >
/usr/JONAS/examples/classes:/usr/JONAS:/usr/local/lib/mysql_both_uncomp.jar:
/u
> >
sr/local/lib/jndi.jar:/usr/local/lib/providerutil.jar:/usr/local/lib/rmiregi
st
> > ry.jar:/usr/JONAS/lib/RMI_jonas.jar:
> >
> > DriverManager.getConnection("jdbc:mysql://localhost/test")
> > trying
> >
driver[className=org.gjt.mm.mysql.Driver,org.gjt.mm.mysql.Driver@c1825d19]
> > getConnection returning
> >
driver[className=org.gjt.mm.mysql.Driver,org.gjt.mm.mysql.Driver@c1825d19]
> >
> > Connected to jdbc:mysql://localhost/test
> > Driver Mark Matthews' MySQL Driver
> > Version 2.0pre4
> >
> > accno,customer,balance
> > 101,Antoine de St Exupery,200.0000
> > 102,alexandre dumas fils,400.0000
> > 103,conan doyle,500.0000
> > 104,alfred de musset,100.0000
> > 105,phileas lebegue,350.0000
> > 106,alphonse de lamartine,650.0000
> >
> > JOnAS Server, version 2.2.7, running on rmi.
> > Cannot load JDBC driver : java.lang.ClassNotFoundException:
> > org/gjt/mm/mysql/Driver
> > Mapping ConnectionManager jdbc:mysql://localhost/test on jdbc_1
> > EJBHome:sb.JOnASOpHome for Op available
> > EJBServer is ready
> >
> > ------------------------------------------------------------------
> >
> > I'm using SuSE Linux 7, Sun JDK 1.2.2, (I've also tried 1.3 but it makes
no
> > difference), Jonas 2.2.7. Please help!!!
> >
> > -------------------------- JdbcTest.java ---------------------
> > import java.net.URL;
> > import java.sql.*;
> > import javax.sql.*;
> >
> > public class JdbcTest {
> >
> > public static void main (String args[]) {
> > String url = "jdbc:mysql://localhost/test";
> > String query = "SELECT * FROM accountsample";
> > try {
> >
> > //DriverManager.registerDriver(new
org.gjt.mm.mysql.Driver());
> > // Load the driver
> >
> > Class.forName ("org.gjt.mm.mysql.Driver");
> >
> > DriverManager.setLogStream(System.out);
> >
> > Connection con = DriverManager.getConnection (
> > url, "XXXX", "XXXX");
> >
> > checkForWarning (con.getWarnings ());
> >
> > DatabaseMetaData dma = con.getMetaData ();
> >
> > System.out.println("\nConnected to " +
dma.getURL());
> > System.out.println("Driver " +
> > dma.getDriverName());
> > System.out.println("Version " +
> > dma.getDriverVersion());
> > System.out.println("");
> >
> > Statement stmt = con.createStatement ();
> >
> > ResultSet rs = stmt.executeQuery (query);
> >
> > [etc etc....]
> >
> > -------------------------------------------------------
> >
> > >===== Original Message From Rosalind Wilson
<[EMAIL PROTECTED]>
> > =====
> > I have *exactly* the same problem as
> >
> > http://www.objectweb.org/messages/JonasUsers/2000/09/msg00031.html
> >
> > except that I'm using mysql rather than sybase, so my datasource
classname in
> > my MySql.properties file is set to:
> >
> > datasource.classname org.gjt.mm.mysql.Driver
> >
> > Just like in the above archive message, sourcing config_env and
executing
> > javap org.gjt.mm.mysql.Driver outside of the EJBServer script returns
success.
> >
> > Any ideas would be much appreciated.
> >
> > Ros
> >
> > -----------------------
> > InterMutual Healthcare from Totalise. Peace of mind at an affordable
price.
> > Visit http://www.intermutual.com/health/
> >
> > ----
> > To unsubscribe, send email to [EMAIL PROTECTED] and
> > include in the body of the message "unsubscribe jonas-users".
> > For general help, send email to [EMAIL PROTECTED] and
> > include in the body of the message "help".
>
> --
> -=- Hélène JOANIN -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
> mailto:[EMAIL PROTECTED] http://www.evidian.com
> Phone: 33.4.76.29.73.53 Fax: 33.4.76.29.76.00
> Download our EJB Server JOnAS at http://www.objectweb.org
> ----
> To unsubscribe, send email to [EMAIL PROTECTED] and
> include in the body of the message "unsubscribe jonas-users".
> For general help, send email to [EMAIL PROTECTED] and
> include in the body of the message "help".
----
To unsubscribe, send email to [EMAIL PROTECTED] and
include in the body of the message "unsubscribe jonas-users".
For general help, send email to [EMAIL PROTECTED] and
include in the body of the message "help".
