4 posts in topic
Flat View  Flat View

Posted By:   Sarbjot_Singh
Posted On:   Monday, December 24, 2001 09:30 AM

we have created a database application in java with backhand oracle.It runs very well. but we want to make the application portable.i.e. we dont want to create the new database and tables in oracle every where we run the application. is there any soution or way by which we actually dont need to install oracle. is there any plugin availabe or some different funda...


Posted By:   Bernie_Acs  
Posted On:   Monday, December 24, 2001 12:52 PM

You should be able to expose your Oracle database to your client base over a network making a single database instance available for use by an number of clients from any number of locations. In general java applications would use a centralized database instance as a data store and normally would not require a database per client installation.

Assuming you have internet capability on you service network you could even expose a single instance of your database server to the net and have all clients interact with the same database sharing a common set of tables. There really should not be a need to have a distinct database per java client or even a distinct set of tables per java client, this implied requirement seems to go against the grain of common practices.

Perhaps your question is concerned with the client-side requirements of using an Oracle based application that employs OCI drivers ( which requires an Oracle client install ) in which case the answer would be as simple as rewriting the database url in your application to use the thin driver which requires no Oracle client software on the java client.

Perhaps you have not configured your Oracle service to support network clients which might lead you to the conclusion that you require a database on each client workstation. If this is the case then you should just make the necessary administrative adjustments to the DB service and then insure that you java clients are using a DB URL which identifies a network accessable database.

If your application's protability requires a standalone database per client then it seems that you would have no choose but to investigate some freeware alternative for database engine, because if nothing else there could be a considerable licensing issues with using a commercial db engine for this kind of deployment. Your Oracle license arrangement certainly would not accomidate your outlined requirements without using some centeralized db deployment which seems to be lacking in your design based on your description in your question.

There must be something more to your question which is not apparent at least to me. If there is something more you could add to help flesh out what your circumstances are I would be glad to try to help you, if I can.


Posted By:   Douglas_Michael  
Posted On:   Monday, December 24, 2001 12:46 PM

Check out the product called PeerDirect at http://www.peerdirect.com

It's a very robust, clean and powerful distributed database replication product that works across heterogeneous database products. It has certain capability to generate and replicate between all or even parts of database tables dynamically for you. If tables or data get deleted, it's capable of recreating and/or repopulating the data.

Your database application can run across servers, desktops, laptops and even PDAs using various database products. Your application can even run off-line with the network down and then sync up later.

We used it for a fraud buster application where the users couldn't afford to be down during network outages.

The company we did the project for became interested after someone told them that the United Nations use it as well as the U.S. Military.

Doug Pan...


Posted By:   Jim_Chios  
Posted On:   Monday, December 24, 2001 10:50 AM

Also, If connectivity is a problem.

Check out SQL Anywhere by Sybase, It has a small footprint and you can get runtime versions that require very easy installations.


Posted By:   Jim_Chios  
Posted On:   Monday, December 24, 2001 10:48 AM

If your application uses an Oracle Database, you have no choice but installing Oracle, but what you could do is have a centralized Oracle Installation with all your java apps pointing to the centralized DB and have it set up to handle multiple system users.
This will mean changes in your security architecture. Each user will only be able to select his own info, in other words , add some more where clause parameters and new fields.

Does that answer your question?
About | Sitemap | Contact