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