JDBC for SQL Server on Windows

[Keating, Katherine]

Hi All

I've installed WebObjects 5.2 with updates 1,2 and 3 on Windows 2000
Server using JRE 1.4.2_11.

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.

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?

Any help would be greatly appreciated...

Regards,
Katherine


________________________________________________________________________
This email has been scanned for all viruses by the MessageLabs SkyScan
service.

[Aurelien Minet]

Post by Keating, Katherine
Hi All
I've installed WebObjects 5.2 with updates 1,2 and 3 on Windows 2000
Server using JRE 1.4.2_11.
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.
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?
Any help would be greatly appreciated...
Regards,
Katherine

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élien Minet

------------------
Direction des systèmes d'information
Université Réne Descartes Paris 5

[Keating, Katherine]

The only thing I didn't have was WEBOBJECTS_JAVA_HOME which I added and this hasn't made any difference.

The apps keep generating NSForwardException's.

Regards,
Katherine

-----Original Message-----
From: Aurelien Minet [mailto:***@univ-paris5.fr]
Sent: 23 May 2006 14:50
To: Keating, Katherine
Cc: webobjects-***@omnigroup.com
Subject: Re: FW: JDBC for SQL Server on Windows

Post by Keating, Katherine
Hi All
I've installed WebObjects 5.2 with updates 1,2 and 3 on Windows 2000
Server using JRE 1.4.2_11.
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.
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?
Any help would be greatly appreciated...
Regards,
Katherine

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élien Minet

------------------
Direction des systèmes d'information
Université Réne Descartes Paris 5





________________________________________________________________________
This email has been scanned for all viruses by the MessageLabs SkyScan
service.