Is that possible for Applet to access the Oracle? - 未名空间MITBBS历史存档

国际科技财经博客移民网络热点娱乐民生时事公众号

Redian新闻

>未名空间

>Database - 数据库

Is that possible for Applet to access the Oracle?

Is that possible for Applet to access the Oracle?# Database - 数据库

u*d2099-09-23 07:09

1 楼

The problem present by me:
some people including Vadim told me that it is not possible to use an applet
to access Oracle, since then the web server and the DBMS server need to run
on the same host. It's a situtation that I like to avoid.
Answer I get:
Regarding the applet access issue, restriction that an applet can only open
TCP connections to the server it came from. You can get around the problem
by using a servlet on the Web server side that acts as a proxy between the
applet and the Oracle

G*T2099-09-23 07:09

2 楼

pls go to www.javasoft.com to search DOC

【在 u*******d 的大作中提到】

: The problem present by me:
: some people including Vadim told me that it is not possible to use an applet
: to access Oracle, since then the web server and the DBMS server need to run
: on the same host. It's a situtation that I like to avoid.
: Answer I get:
: Regarding the applet access issue, restriction that an applet can only open
: TCP connections to the server it came from. You can get around the problem
: by using a servlet on the Web server side that acts as a proxy between the
: applet and the Oracle

B*n2099-09-23 07:09

3 楼

I suppose you know JDBC. If you write a stand-alone JDBC program, say A,
it will be able to connect to any Oracle server running on any host,
as long as there is a listener listening for jdbc connections, right?
Now suppose you install A along-side with a web-server. If you can
auto-magically ask the web server to invoke your JDBC program A;
inside A you can still connect to any database on any server,
right?
Now if your applet issues a request to web server in such a way that
the web-server kno

【在 u*******d 的大作中提到】

m*a2099-09-23 07:09

4 楼

No, not that easy. If you have applet activated in your java program which
also take care of the JDBC connection. the JDBC will deal the user as
untrusted and refuse connection. The prob is sill resolvable, but use i/o
stream instead.
Yeah, I totally agree though my servlet pissing on me. These days I'm
hammering on it. My server won't install. clueless :(

【在 B*****n 的大作中提到】

: I suppose you know JDBC. If you write a stand-alone JDBC program, say A,
: it will be able to connect to any Oracle server running on any host,
: as long as there is a listener listening for jdbc connections, right?
: Now suppose you install A along-side with a web-server. If you can
: auto-magically ask the web server to invoke your JDBC program A;
: inside A you can still connect to any database on any server,
: right?
: Now if your applet issues a request to web server in such a way that
: the web-server kno