Hi Ros,
Could you check that the MySql.properties file seen by the JOnAS server
is the one you think ?
Are you several MySql.properties files ?
(current directory, user's home directory, jonas root directory)
Hélène.
Ros wrote:
>
> 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
> > >
--
-=- 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".
