Whoops,
Forgot to add that the servlets were developed on win95 and deployed onto
linux, which is where the .profile file gets changed. Thus it should read:
I got my win95 servlets to access the linux based mySQL db via the following
method:
step 1) add a line to the .profile file on the linux system to ensure the
mm.mysql drivers are
accessed,
"export
CLASSPATH=/usr/local/JSDK2.0/lib/jsdk.jar:/usr/local/mm.mysql.jdbc-1.2b/mysq
l_comp.jar/" Needless to say, this must be modified according to where the
JSDK and mm.mysql driver are held.
step 2) use the proper url, user, password combination for the connection.
'jdbc:mysql://<yourdomain.com>/<dbName>?user=<userName>&password=<password>'
.
Then it all fell into place.
Cheers
Bruce
Scharlau Prints and Maps http://www.scharlau.co.uk/
Scharlau Websites http://www.scharlau.co.uk/website.html
----- Original Message -----
From: Bruce Scharlau <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, December 21, 1999 6:43 AM
Subject: mm.mySQL driver
> Hi all,
>
> This is just for the record, in case anyone else looks up the
problem/hurdle
> I got over.
>
> I got my win95 servlets to access the mySQL db via the following method:
>
> step 1) add a line to the .profile to ensure the mm.mysql drivers are
> accessed,
> "export
>
CLASSPATH=/usr/local/JSDK2.0/lib/jsdk.jar:/usr/local/mm.mysql.jdbc-1.2b/mysq
> l_comp.jar/" Needless to say, this must be modified according to where the
> JSDK and mm.mysql driver are held.
>
> step 2) use the proper url, user, password combination for the connection.
>
'jdbc:mysql://<yourdomain.com>/<dbName>?user=<userName>&password=<password>'
> .
>
> Then it all fell into place.
>
> Cheers
> Bruce
>
>
___________________________________________________________________________
> To unsubscribe, send email to [EMAIL PROTECTED] and include in the
body
> of the message "signoff SERVLET-INTEREST".
>
> Archives: http://archives.java.sun.com/archives/servlet-interest.html
> Resources: http://java.sun.com/products/servlet/external-resources.html
> LISTSERV Help: http://www.lsoft.com/manuals/user/user.html
>
>
___________________________________________________________________________
To unsubscribe, send email to [EMAIL PROTECTED] and include in the body
of the message "signoff SERVLET-INTEREST".
Archives: http://archives.java.sun.com/archives/servlet-interest.html
Resources: http://java.sun.com/products/servlet/external-resources.html
LISTSERV Help: http://www.lsoft.com/manuals/user/user.html
