Deb Thanks, that works fine in the CFMX Administrator Datasource setup.
But to use the driver with ViennaSQL I need to set its classpath or put a copy of the driver .jar file in /Library/Java/Extensions/. Do you know the name/location of the .jar file? I tried: /opt/coldfusionmx/lib/macromedia_drivers.jar But that didn't work. Dick On Sunday, September 1, 2002, at 07:44 PM, Deb Dickerson wrote: > Here's what I have for MySQL. Haven't tried it myself, so I can't > verify > whether it's accurate or not. > > URL: jdbc:mysql://servername/dbname > Class: org.gjt.mm.mysql.Driver > > Deb > > ----- Original Message ----- > From: "Dick Applebaum" <[EMAIL PROTECTED]> > To: "CF-Linux" <[EMAIL PROTECTED]> > Sent: Sunday, September 01, 2002 4:59 PM > Subject: Re: MySQL jddbc driver for CFMX > > >> Jesse >> >> When you setup a MySQL Datasource using the built-in driver, it >> doesn't >> show a JDBC URL or Driver Class >> >> I need to specify these to ViennaSQL GUI to use the built-in driver -- >> but I Don't know the URL & Class. >> >> The other choice is to install a duplicate Datasource using the MySQL >> driver: >> >> JDBC URL: jdbc:mysql://127.0.0.1:3306/test >> Driver Class: com.mysql.jdbc.Driver >> >> I'd rather avoid this duplication. >> >> Do you know the URL and DriverClass for the built-in MySQL jdbc >> Driver? >> >> TIA >> >> Dick >> >> P.S. Incidentally, the ViennaSQL GUI is a very nice open-source GUI >> for >> all kinds of jdbc-accessable dbs -- it is available at: >> >> http://vienna.sourceforge.net/ >> >> I need to know the >> On Sunday, September 1, 2002, at 01:37 PM, Jesse Noller wrote: >> >>> Dick- >>> >>> CFMX ships with a MYSQL JDBC driver built into the main JDBC drivers >>> package. >>> >>> -----Original Message----- >>> From: Dick Applebaum [mailto:[EMAIL PROTECTED]] >>> Sent: Friday, August 30, 2002 11:44 AM >>> To: CF-Linux >>> Subject: MySQL jddbc driver for CFMX >>> >>> Is the internal driver that installs with CFMX a jdbc driver -- if >>> so, >>> where is the jar file? >>> >>> If not, are there any 3-rd party jdbc drivers for MySQL? >>> >>> The reason I ask, is I want to use the Vienna graphical SQL db >>> interface with all CFMX databases that lack one. >>> >>> So far, PostgreSQL and PouintBase work! >>> >>> >>> Dick >>> >>> >>> >> > ______________________________________________________________________ Get the mailserver that powers this list at http://www.coolfusion.com ------------------------------------------------------------------------------ Archives: http://www.mail-archive.com/cf-linux%40houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_linux or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
