asked on

Applet to Servlet Communication

I'm trying to write a database aware applet that does not depend on the JDBC/ODBC bridge (as each client would need ODBC installed). Are there any code examples of how to actually do this ?

Any help much appreciated !

heyhey_

use pure JDBC driver.
read the JDBC tutorial at www.javasoft.com

.... and so on .. (you'll get hundered of links very soon)

gng

ASKER

A pure Java driver would be a solution but financially is not possible. I am familiar with the types of java database drivers around. It's the way to do it but to many $$$. I'd really like an example of where a servlet makes the db interactions but the clients (running an applet in a browser) can interact with the servlet. By using this approach, you have complete control on the servlet implementation (using the cheap [free] JDBC/ODBC bridge. Thanks again !

heyhey_

I just saw you question title inside the e-mail notification (you don't mention the word 'servlet' inside your question at all)

check the RMIJdbc driver for a very quick solution:

http://dyade.inrialpes.fr/membres/gibello/

ASKER CERTIFIED SOLUTION

blairdye

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

Ravindra76

Hi gng,

If you want cost effective solution,

1. Write all the database code in java servlets. If you want free webserver,use apache web server. Other wise you can buy any webserver capable of running servlets

2.Call servlets from applets through URLConnection class.
Use parameters to call different functions of same servlet.

In servlets, you can use any jdbc driver types ( 1,2,3,4 i.e jdbc-odbc bridge also)

Best of luck

vladi21

gng - r u still have questions?