JDBC install on windows Oracle & MS SQL Server
JDBC install on windows Oracle & MS SQL Server
- Subject: JDBC install on windows Oracle & MS SQL Server
- From: Franck Leveneur <email@hidden>
- Date: Mon, 15 Dec 2003 14:53:08 -0800
Chuck,
I finally got it to work.
I had to uninstall J2SE SKD 1.4.1 and JRE 1.4.1 (on Windows).
I did not know that it was not supported on Windows. Seems to be
supported on OSX though.
Anyway, I found an article from Apple Knowledge based: WebObjects 5:
How to Use Oracle JDBC drivers
http://docs.info.apple.com/article.html?artnum=75145
I followed all the instruction and it works.
I learnt that:
(from article)
When doing development on Windows 2000, the situation is somewhat more
complicated. The WebObjects 5 runtime uses a Java 2 VM and requires a
JDK 1.3.x compatible JDBC driver just like Mac OS X and other
platforms. However, EOModeler uses the Java Bridge, which only supports
JDK 1.1 on Windows and therefore requires a JDK 1.1 compatible driver.
Consequently, in order to do development and testing on Windows 2000,
two versions of a particular JDBC driver are needed. One that is JDK
1.3 compatible for the WebObjects 5 runtime, and another that is JDK
1.1 compatible for use by EOModeler and the Java Bridge.
To use a JDBC 1.1 driver with EOModeler on Windows 2000, you should add
it to the JavaConfig.plist. This is the Oracle driver classes111.zip in
this case. If your WebObjects installation is not inC:/Apple,
substitute the appropriate path below. The Unix notation of "/" for the
directory separator is used in the samples
1. Log in with an administrator account.
2. Copy classes111.zip to C:/Apple/Library/Java/
3. Edit the file C:/Apple/Library/Java/JavaConfig.plist
4. Add $NEXT_ROOT/Library/Java/classes111.zip to the entry for the
"DefaultClasspath". Items in the list should be separated by a
semicolon ";". Use the term "$NEXT_ROOT" literally, following the
pattern of the other entries.
So for SQL Server JDBC, I did the same thing. I copied the jar files
(msbase.jar, msutil.jar, mssqlserver.jar) into /Apple/Library/Java/.
changed the extension to .zip.
Edited /Apple/Library/Java/JavaConfig.plist
And added:
$NEXT_ROOT/Library/Java/msbase.zip
$NEXT_ROOT/Library/Java/msutil.zip
$NEXT_ROOT/Library/Java/mssqlserver.zip
I was able to use EOModeler to connect to both MS SQL and Oracle.
I havent' created anything yet.
Thanks for all your help.
On Dec 12, 2003, at 10:04 PM, Chuck Hill wrote:
> At 05:41 PM 12/12/2003 -0800, Franck Leveneur wrote:
>> Chuck,
>>
>> I think I made some progress because now I'm getting a different
>> error:
>> com/microsoft/jdbc/base/BaseMessages
>>
> I'd guess this means that msbase.jar needs to be unzipped into
> C:\Apple\Library\Java
>
>
>> I don't know if you use MS SQL JDBC (there are 3 files: msutil.jar,
>> mssqlserver.jar, and msbase.jar).
>>
> No, I don't use it. Jonathan Rochkind is the expert in this area but I
> think he is away on holidays. Search the Omni list for past postings
> of his.
>
>
>> Should I Unzip all 3 files into C:\Apple\Library\Java?
>>
> I think that is a good idea. It certainly will not hurt anything.
>
>
>> I checked ..JRE\lib\ext directory and it does contain these 3 files.
>> I believe I have only 1 JRE installed.
>>
> I'd check closely. IE often installs its own under c:\program
> files\JavaSoft. WO uses a different location and the JDK downloads
> from
> Sun appear to favour yet another location.
>
>
>> This is really frustrating?
>>
> Yes, it can be frustrating the first time. This site might help some:
> http://www.tetlabors.de/wo/setup_webobjects_on_windows.html
>
>
>> Looks like MS does not make it easy on purpose.
>>
>> THe install on the mac was no problem.
>>
> The big problem with Windows is the lack of a standard install
> location and
> the resulting multiple installations of the same version. However,
> IMHO
> Apple has really screwed up the Java environment trying to make it
> "easier". While a straight forward JRE install is easier, if you try
> to
> use multiple JRE versions it quickly becomes a nightmare. At least
> Windows
> follows the Sun standard conventions and closely matches Solaris. I've
> spent an equal amount of time cursing both operating systems for
> different
> reasons. :-(
>
>
> Chuck
>
>
> --
>
> Chuck Hill email@hidden
> Global Village Consulting Inc.
> http://www.global-village.net
_______________________________________________
webobjects-dev mailing list | email@hidden
Help/Unsubscribe/Archives: http://www.lists.apple.com/mailman/listinfo/webobjects-dev
Do not post admin requests to the list. They will be ignored.