jQuery in Action, 3rd edition
The moose likes JDBC and Relational Databases and the fly likes CachedRowSet JavaApp-Servlet Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "CachedRowSet JavaApp-Servlet" Watch "CachedRowSet JavaApp-Servlet" New topic

CachedRowSet JavaApp-Servlet

Philipp Helle

Joined: Jul 19, 2005
Posts: 1

I have a Java Application (with Swing) which has to do DB-queries.
Currently the application connects directly to the DB which isn't the best solution because the Application shall also work through firewalls.
My idea is to build a servlet which takes the queries and passes back the results in a CachedRowSet.
Unfortunately I don't have a clue on how to build the servlet especially on how to access the servlets methods from the application.
I'm using Tomcat 5, Java 1.5 and MySQL with Connector/J 3.1 as JDBC driver.
Can anybody please give me a hint on how to start?

Jeanne Boyarsky
author & internet detective

Joined: May 26, 2003
Posts: 33130

Welcome to JavaRanch!

I'm not sure if I understand what you are trying to do. Have the application call a servlet? The servlet runs on the server so it wouldn't be able to pass back an object as the result.

In any event, this is more of a servlets question. I'll move it to the servlets forum for you.

[OCA 8 book] [Blog] [JavaRanch FAQ] [How To Ask Questions The Smart Way] [Book Promos]
Other Certs: SCEA Part 1, Part 2 & 3, Core Spring 3, TOGAF part 1 and part 2
I agree. Here's the link: http://aspose.com/file-tools
subject: CachedRowSet JavaApp-Servlet
It's not a secret anymore!