TD,
I'm a little confused. I test drove Merant's drivers, before deciding to
purchase from another vendor. I had no problems setting up JRUN via JDBC
Connection Manager Wizard to use Merant's drivers. You have to choose Not
Listed in the drop down box for RDBMS server name (at least I did). The
driver will NOT show up the drop down boxes of the Wizard, as it is an
external driver. So follow's Merant's instructions on how to register the
driver (this is part of the wizard), the URL to use, whether or not to use
ConnectionPooling, and the userID and password. Most of the other
parameters can be left blank by default.
Did you also test the connection after running thru the wizard? If that
doesn't show that you have "made" a connection, then you will not be able to
use the driver in your servlets/JSP's.
Otherwise, with the exception of later learning that the jar files had to be
placed in the classpath (under Java Settings) for BOTH the admin server AND
the default server, the drivers worked fine for me. I later decided to go
with another vendor, and I had no problems setting them up via the JDBC
Connection Manger Wizard either.
Celeste
-----Original Message-----
From: tdavis [mailto:[EMAIL PROTECTED]]
Sent: Monday, June 04, 2001 12:41 PM
To: JRun-Talk
Subject: Re: JRun-Talk-List V1 #8
Hi Celeste. Thanks for your suggestion.
Actually, I already placed the paths to the jar files in both Admin and
Default classpaths (see my original message below). In addition, I cannot
use JMC's Create JDBC Connections since JRun cannot even see the jar files
for the Merant drivers - so you get the same error using JRun's Create JDBC
Connections utility as you do explicitly writing servlets/JSP's calling the
drivers/URL directly.
See the rest of the thread for more info on what was attempted.
TD
>----------------------------------------------------------------------
>
>Date: Mon, 04 Jun 2001 09:40:24 -0500
>From: "Celeste Haseltine" <[EMAIL PROTECTED]>
>To: [EMAIL PROTECTED]
>Subject: RE: JDBC Connect classpath problem
>Message-ID: <[EMAIL PROTECTED]>
>
>Did you define a JDBC datasouce in JRUN? If not, open up your JRUN Admin
>Server, select your default server -> JDBC DataSources, and define your new
>JDBC datasource. Make sure that you also set the classpath for the jar
>files in your JRUN default AND JRUN Admin server. Go to
>JavaSettings->Classpath to do this.
>
>Celeste
>
>-----Original Message-----
>From: Toby Davis [mailto:[EMAIL PROTECTED]]
>Sent: Saturday, June 02, 2001 1:55 AM
>To: JRun-Talk
>Subject: JDBC Connect classpath problem
>
>
>Using JRun 3.0sp2 Developer Edition, win 2k, with Merant's latest JDBC
>Connect driver for SQLServer 7/2k, I keep getting "No valid JDBC driver is
>specified" when trying to create a JDBC Data Source in Default Server's
JMC.
>Also, if I explicitly call a Class.forName("driver") in a servlet or jsp
>using JRun as the container, it cannot find the driver class.
>
>Note that I did put the paths to the three Merant jar files (base.jar,
>util.jar, sqlserver.jar) explicitly in both the system CLASSPATH and the
>Classpaths in the JMC Java Settings (Admin and Default servers).
>
>Also note that my driver and URL string (as well as username/password)
>connect fine in an outside Java application (not going through JRun) and
>also through Merant's JDBCTest.
>
>Help! Thanks.
>TD
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
