File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
The moose likes JDBC and Relational Databases and the fly likes creating table on client side Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login

Win a copy of REST with Spring (video course) this week in the Spring forum!
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "creating table on client side" Watch "creating table on client side" New topic

creating table on client side

deepak borole

Joined: Nov 13, 2005
Posts: 25
i am developing one application in which my main database will be on server and i need to create one table on the client side. how can i do that.....

Winners Dont Do Different Things, They Do Things Differently !!!
Ulf Dittmer

Joined: Mar 22, 2005
Posts: 42959
Do you mean you want a database on the client as well? There are a few Java databases that can be embedded, like HSQLDB.
Joel McNary

Joined: Aug 20, 2001
Posts: 1824

Or, perhaps, you want the database to create a temparary table for a specific user. (I think Oracle can do that -- you'd have to check the Oracle documentation/consult an Oracle DBA for exactly how).

Otherwise, I would suggest using something like HSQL or some such. If you can explain why you need it, we might be able to come up with more practical suggestions.

Piscis Babelis est parvus, flavus, et hiridicus, et est probabiliter insolitissima raritas in toto mundo.
deepak borole

Joined: Nov 13, 2005
Posts: 25
wat i want to do is that....i have a main database on the server...and when some client will access my site the selected records should be stored at the client can this be done..
Hemant Agarwal
Ranch Hand

Joined: Nov 21, 2005
Posts: 138
Use javascript. For table use multi dimensional arrays
Jeanne Boyarsky
author & internet detective

Joined: May 26, 2003
Posts: 32815

You mean you want a GUI table to represent your real database table? For a webpage, use HTML/Javascript/JSP. For an applet or client application, use Swing.

Either way, you use JDBC to get the data from the database table.

[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:
subject: creating table on client side
It's not a secret anymore!