Best method to connect client and database?

Best method to connect client and database?

Post by Burkhard Perkens-Golo » Tue, 28 Oct 1997 04:00:00



I'm quite new to this stuff and the more I'm
reading about connecting a java-client to a
database the more I'm getting confused.

I want to write a system with:

- Java clients
- The IBM Web Server ICSS
- Database DB2 V5 on an IBM mainframe with OS/390

What's the best method to communicate between
server on host and clients?

Should I write a 3-layer architecture with Java
servlets and JDBC? Should I use CORBA? Should
I use RMI? Anything else?

And the most important question: *Why* should I
use or don't use these things? Performance,
security, reliability, scalability etc. etc.?

Greetings,

        Burkhard

 
 
 

Best method to connect client and database?

Post by Enrique Travies » Wed, 29 Oct 1997 04:00:00


Quote:> Should I write a 3-layer architecture with Java
> servlets and JDBC? Should I use CORBA? Should
> I use RMI? Anything else?

A three-tier architecture is definitely more maintainable than the
traditional client/server model. All three choices above can be used to
implement it.

Which one is better ? You are probably going to get a different opinion
depending on who you talk to. Which one you chose will largely depend on
your application requirements. Do a little research and see how well each
one fits your requirements.

--
Enrique Travieso

http://www.objectmatter.com
Home of BSF, an object-relational framework that allows Java objects to be
easily saved and retrieved from relational databases.



Quote:> I'm quite new to this stuff and the more I'm
> reading about connecting a java-client to a
> database the more I'm getting confused.

> I want to write a system with:

> - Java clients
> - The IBM Web Server ICSS
> - Database DB2 V5 on an IBM mainframe with OS/390

> What's the best method to communicate between
> server on host and clients?

> Should I write a 3-layer architecture with Java
> servlets and JDBC? Should I use CORBA? Should
> I use RMI? Anything else?

> And the most important question: *Why* should I
> use or don't use these things? Performance,
> security, reliability, scalability etc. etc.?

> Greetings,

>    Burkhard


 
 
 

Best method to connect client and database?

Post by Ward Mullin » Wed, 29 Oct 1997 04:00:00


You should look at our CocoBase product.  We tie all of the technology
you've mentioned into one very high level easy to use API.  We help you
to manage security, reliability, scalability, maintenance, source code
building, etc.  We also work around a lot of common problems and
pitfalls with JDBC and Corba as well.

Just my $.02!

Ward Mullins
THOUGHT Inc.

http://www.thoughtinc.com


> I'm quite new to this stuff and the more I'm
> reading about connecting a java-client to a
> database the more I'm getting confused.

> I want to write a system with:

> - Java clients
> - The IBM Web Server ICSS
> - Database DB2 V5 on an IBM mainframe with OS/390

> What's the best method to communicate between
> server on host and clients?

> Should I write a 3-layer architecture with Java
> servlets and JDBC? Should I use CORBA? Should
> I use RMI? Anything else?

> And the most important question: *Why* should I
> use or don't use these things? Performance,
> security, reliability, scalability etc. etc.?

> Greetings,

>         Burkhard

 
 
 

Best method to connect client and database?

Post by Paul Whit » Thu, 30 Oct 1997 04:00:00



> I'm quite new to this stuff and the more I'm
> reading about connecting a java-client to a
> database the more I'm getting confused.

> I want to write a system with:

> - Java clients
> - The IBM Web Server ICSS
> - Database DB2 V5 on an IBM mainframe with OS/390

> What's the best method to communicate between
> server on host and clients?

USe JDBC drivers or JDBC compatible drivers

Quote:> Should I write a 3-layer architecture with Java
> servlets and JDBC? Should I use CORBA? Should
> I use RMI? Anything else?

The 3-layer architecture is more secure, flexible and more open and has
more scalebelity options.

The other benefit with 3-tier architectures is that if you use
JDBC-compatible middleware you don't need drivers on the client, whch
may be important to you. Using Type 4 JDBC drivers may be faster if
you're using just one database server and can control the client
software.

Take a look at the JDBC info on the sun website.
You might also like to look at Visual Cafe for Java 2.0 Database
Development Edition on the site below.
--
Paul White - IPM Symantec Internet Tools
The opinions expressed herein are those of the author and not of
Symantec corporation
*NEW Visual Cafe 2.0 for Java products announced*
Website:   http://cafe.symantec.com
FTP site:  ftp://itools.symantec.com

 
 
 

1. Best method to connect a client application?

This question may seem incredibly novice, but I am most familiar with
web-based applications in which you are constantly created and destroying
connections (and often, the shorter the connection time, the better).

In a desktop Visual Basic application, is it best to create one connection
per client when they start the application ... and merely destroy it when
the application is closed? Or, should I connect and disconnect whenever I
need to interact with the database?... this latter method seems as though it
would be much slower and incur much more overhead, but I simply do not know.
(BTW: this app will be running with approx. 50 concurrent users connected)

Thanks.
John Duffy

2. Urgent Help

3. Best method to connect a client to DB...?

4. ADO MD Cellset Object

5. Best Method to connect to database

6. US,NY,Upstate: COBOL Programmer/Analysts

7. Can anyone suggest the best method of distributing Open Client

8. Position Vacancy : Manchester, England

9. Best Method to Identify a Database?

10. Best methods to open/edit dBase databases?

11. Best method for moving a database

12. Best method to Version a database

13. database of object hierachy? best method