Re: FW: JDBC for SQL Server on Windows

Keating, Katherine wrote:
> Hi All
> =20
> I've installed WebObjects 5.2 with updates 1,2 and 3 on Windows 2000
> Server using JRE 1.4.2_11.
> =20
> Everything looks good, monitor is running and my instances are running.
> However, the apps can't connect to the database. I know the apps are
> fine as I've deployed them on another server and they work perfectly.
> I think is problem lies with the JDBC for SQL Server install on the
> server.
> =20
> My Apple/Libary/Java directory does not contain a JavaConfig.plist file
> (we normally add the paths to the JDBC Jar files to the
> DefaultClassPath). Do I have to have this file?
> =20
> Any help would be greatly appreciated...
> =20
> Regards,
> Katherine
>
>  =20
Hi,

No need to have a Classpath nor a JavaConfig.plist  file;
You have to put your JDBC jars (and others like mail.jar) in the
jre\lib\ext directory of the JVM being used.
You may also need to add 2 environment variables (system wide):
_  WEBOBJECTS_JAVA_EXTENSIONS set to jre\lib\ext directory (for me it is
C:/PROGRA~1/Java/j2re/lib/ext).
_  WEBOBJECTS_JAVA_HOME set to the directory where you install  j2ee sdk
( for me it is C:/J2SDK).
both paths must be in MSDOS notation (no space + 8 chars)

Aur=E9lien Minet

------------------
Direction des syst=E8mes d'information
Universit=E9 R=E9ne Descartes Paris 5=20