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/rmiregist
> 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".
