Sure. (JDBC username and password changed for public)
jdbc.testds.display-name=testds
jdbc.testds.driver=com.merant.datadirect.jdbc.sqlserver.SqlServerDriver
jdbc.testds.url=jdbc.sqlserver://testdev:1433
jdbc.testds.description=
jdbc.testds.pooling=true
jdbc.testds.timeout=5
jdbc.testds.interval=60
jdbc.testds.param.user=fake
jdbc.testds.param.password=fakepw
user.classpath={jrun.rootdir}/servers/lib;{jrun.server.rootdir}/lib;D:/MERAN
T/JDBC/lib/base.jar;D:/MERANT/JDBC/lib/sqlserver.jar;D;/MERANT/JDBC/lib/util
.jar
Note that on the classpath, I used different combos (Win and UNIX-style
slashes) and none worked, from just indicating the directory only (which you
should be able to do) and explicitly listing each jar file.
D:\MERANT\JDBC\lib\sqlserver.jar
D:\\MERANT\\JDBC\\lib\\sqlserver.jar
etc
etc
etc
Also note that the driver and URL tested fine outside the JRun environment.
The error I get when testing the JDBC Data Source through JMC is "No valid
JDBC driver is specified".
See anything missing or incorrect?
Thanks
TD
>
>> Date: Mon, 4 Jun 2001 10:41:21 -0700
>> From: "tdavis " <[EMAIL PROTECTED]>
>> To: <[EMAIL PROTECTED]>
>> Subject: Re: JRun-Talk-List V1 #8
>> Message-ID: <[EMAIL PROTECTED]>
>>
>> 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
> Setting these up can be a real bother I know. You can't tell when
> you're getting close.
>
> Could you post a copy of your 'user.classpath' line(s) from
> local.properties? And along with that the jdbc.* lines from
> the data source you're trying to set up? i.e.
>
>
user.classpath={jrun.rootdir}/servers/lib;{jrun.server.rootdir}/lib;D:\\Prog
ra> m
> Files\\SQLLIB\\java\\db2java.zip
> ...
> jdbc.testdb.driver=COM.ibm.db2.jdbc.app.DB2Driver
> jdbc.testdb.url=jdbc:db2:testdb
>
> and the exception you're getting? It seems like you've done all of the
> obvious things right, but we're still missing something.
>
> Robert Merrill
> Software Engineer
> Berbee
> 5520 Research Park Drive Madison, WI 53711
> [EMAIL PROTECTED]
> 608.298.1036 Fax 608.278.8539
>
> Berbee...putting the E in business
>
> ------------------------------
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
