Re: EOModeler JDBC connection help in Windows
Re: EOModeler JDBC connection help in Windows
- Subject: Re: EOModeler JDBC connection help in Windows
- From: "Adam Chan" <email@hidden>
- Date: Thu, 11 Sep 2003 09:55:27 -0600
IMO, setting up the JDBC is pain in the xxx. It took me some extensive
reading/research to get it done right.
First, you will need the right JDBC driver for the right Java SDK. In some
rare cases, you will need a JDBC plugin.
Than somehow the EOModelder still uses an older version of Java and thus you
may need two different version of JDBC drivers, one for EOModelder and
another for the project(code).
Next you will need to put the right driver into the right place. Remember
one for EOModelder(path under Apple/Library/JavaConfig.plist), another for
the project (where your Java Ext, I tried 1.3.1, 1.4.1, 1.4.2 they all
installed in a different directory).
At last, the URL. You will need to find the URL that "find" the driver.
My suggestion is
1. Forget about WebObjects at start and make sure the JDBC driver and Java
is working. Use a small SQL utility to test the connection.
2. Work on the EOModelder.
3. Work on the project.
----- Original Message -----
From: "Emilio Murillo" <email@hidden>
To: <email@hidden>
Sent: Wednesday, September 10, 2003 6:33 PM
Subject: EOModeler JDBC connection help in Windows
> I am new to WebObjects and trying to learn Java with WO 5.2. I also
> want to encourage my manager at work to start using Java technology
> and other OS's, not only .Net and Windows. I have started with myself
> switching to use Apple at home, because there are too many viruses
> attacking Windows(ok, enough of this). The following is my issue:
>
> I have read Apple's documentation regarding WebObjects JBC drivers
> and instructions on how to connect to several databases using
> EOModeler. I have also searched for books, but none explain in detail
> how to connect to SQL Server using EOModeler. I have trouble
> connecting to Microsoft SQL Server using EOModeler in Windows.
> Someone, please guide me or advise on what am I doing wrong with the
> following (thanks in advance for any help - Emilio Murillo):
>
> When I try to create a new EO Model, I enter the following on the
> JDBC Connection form:
>
> Username: sa
> Password: zzzzz
> URL: jdbc:microsoft:sqlserver://COMPASSW:1433
>
> After I click the "OK" buttton to advance to the next screen, I get
> the following messagebox:
>
> JDBC connection failed for driver
> :'com.microsoft.jdbc.sqlserver.SQLServerDriver'. Driver not found in
> Java Runtime! Please verify your CLASSPATH environment variable. The
> current CLASSPATH for your application is :
C:\Apple\Library\Frameworks\JDBCEOAdaptor.framework\Resources\Java\.;"\QTJav
a.zip";/Library/Java;C:/Apple/Local/Library/Java;C:/Apple/Library/Java;C:/Ap
ple/Library/JDK/lib/classes.zip;C:/Apple/Library/Frameworks/JavaVM.framework
/Classes/awt.jar;C:/Apple/Library/JDK/lib/swingall.jar
>
> __________________________________
> Do you Yahoo!?
> Yahoo! SiteBuilder - Free, easy-to-use web site design software
> http://sitebuilder.yahoo.com
> _______________________________________________
> 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.
_______________________________________________
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.