Link to home
Start Free TrialLog in
Avatar of xiaoxiangz
xiaoxiangz

asked on

jdbc problem?

Hi, I download Oracle thin jdbc driver. First I made a simple application(JDK 1.1), it works.
Then I tried to make an applet, no compile errors. Has the same connecion
string and so on, but when I load it from IE 4.0, it say error, "cannot access
"199.81.96.83":1521", when I load it from Netscape4.01, it even has
problem to load the oracle jdbc driver and stops there before trying to
connect. What's wrong with my program. Thanks.
Shane
Avatar of shchuka
shchuka

Can you provide a bit more details?  What is the connect string you're using to connect to oracle?  I have written applets that communicate with an oracle database.

The main thing you must remember is that your applet can only connect to the database which is residing on the same PHYSICAL machine as your web server, where the applet is loaded from.  I.e. if your applet is loaded from www.yoursite.com then it can only connect to the Oracle database residing on www.yoursite.com  (unless you're dealing with trusted signed applets and oracle version 8.0.0 or later)

Avatar of xiaoxiangz

ASKER

Yeah, that may be my problem. The web server(IIS 3.0) is under NT 4.0, and the
Oracle 7.0 is under unix. How to generate trusted signed applets. I don't
understand why java impose such limitation. When I use asp, there
is no such reqirement.
Thanks.
Shane
ASKER CERTIFIED SOLUTION
Avatar of aziz061097
aziz061097

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
We are currently setting up a simular environment testing 1.1.6 jdk and 1.2beta4 jdk.
I have information from oracle that if you use conection manager as a router for
socket request that you can run applets/applications on a different platform from
the database.  Once we have this up and working (wed 8/3/98) I will post the
CM config file and a sample applet/application with connection info.  There are
several bugs in the CM GUI module and we are working trying to resolve these
issues.  Oracle has forwarded some docs and said they had it working there.