thanks anyway for taking a look.
Ros
----- Original Message -----
From: "Hélène JOANIN" <[EMAIL PROTECTED]>
To: "Ros" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Thursday, March 08, 2001 4:00 PM
Subject: Re: Still Cannot load JDBC driver....
>
> Too bad.....
> I have no other ideas for the moment :-(
>
> Hélène.
>
> Ros wrote:
> >
> > I've got just the one, in the JONAS_ROOT directory....
> >
> > ----- Original Message -----
> > From: "Hélène JOANIN" <[EMAIL PROTECTED]>
> > To: "Ros" <[EMAIL PROTECTED]>
> > Cc: <[EMAIL PROTECTED]>
> > Sent: Thursday, March 08, 2001 3:11 PM
> > Subject: Re: Still Cannot load JDBC driver....
> >
> > > 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".
>
> --
> -=- 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".
