dcsimg
How to interact with database using Applet
2 posts in topic
Flat View  Flat View
TOPIC ACTIONS:
 

Posted By:   Abdul_Moyeed
Posted On:   Tuesday, November 20, 2001 07:52 AM

How to interact with the database using Applet like VB form or Oracle Developer/2000 forms and report for querying and updating the tables in oracle (using Oracle JDBC driver)?

Is it possible through APPLET to display the result of resultset extracted through JDBC.

Re: How to interact with database using Applet

Posted By:   John_Zukowski  
Posted On:   Sunday, November 25, 2001 02:39 PM

This question is already addressed in several FAQs if you search for applet and JDBC.


As already mentioned, untrusted applets can only communicate from the server from which it came. Thus, the web server must serve double duty as the database server, too.

Re: How to interact with database using Applet

Posted By:   Bozidar_Dangubic  
Posted On:   Tuesday, November 20, 2001 08:47 AM

sure, it is possible. make sure your driver is loaded into the JVM of where applet is loaded (which means you will need to jar the applet), import the class, load the driver, get the connection, execute a statement and get the resultset to display. if you have an application server that is managing your connections through the connection pool, you will need to do JNDI lookup for the datasource in order to obtain a connection. if this is the case in your design, you will need your app server client jar in the applet's JVM. most app server provide this jar file in the installation.
About | Sitemap | Contact