RE: Struts DB example

[Bill G]

Title: RE: Struts DB example

Hi Bret/Francisco,

 

I appreciate the info, but that does not help me.

 

PLEASE READ - I was hoping that someone out there could point me to a REAL working Struts/Database example. For me, as long as the sample works with a modern RDBMS with JDBC is sufficient. Could be Sybase, Oracle, MS/SQL Server, Ingres, MySql whatever. I do not care about app server, db choices or jdbc choices. All I'm looking for is a simple struts application utilizing a real relational database that inserts, updates and deletes a record into a table.

 

Thanks!

 

[Bill Gfroehrer] 

 -----Original Message-----
From: Brett Porter [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, October 03, 2001 5:31 PM
To: '[EMAIL PROTECTED]'
Subject: RE: Struts DB example

The struts example struts-config.xml file has an example of how to create a connection pool. However, from what I now understand that is deprecated. The struts-documentation webapp does have details about it though if you are interested.

I thought there was a struts taglib example that shows how to use the JDBC features from JSP pages, but I think I was mistaken there - it must be in the commons project.

That being the case this isn't really a struts issue - you should look at the jakarta-commons (it has DB connection pooling with good examples, although it isn't really up to a release, you'll have to check out the CVS).

Specific database examples will depend on which database you use, and which JDBC driver you use, and anything else you choose to layer on that (app server, connection pooling, etc.).

You should consult those sources and the web for more examples.

 

Cheers,

Brett

-----Original Message-----
From: Bill G [mailto:[EMAIL PROTECTED]]
Sent: Thursday, 4 October 2001 10:19 AM
To: [EMAIL PROTECTED]
Subject: RE: Struts DB example

Bret,

 

Sorry, I should be more specific.

 

The sample app that you and Francisco refer to does not illustrate connecting to a real RDMS nor does not illustrate connection pooling, where the connection logic goes etc...

 

That's the kind of stuff I'm interested in. A sample struts app that works with a real RDMS and illustrates CRUD would be great.

 

 

-----Original Message-----
From: Brett Porter [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, October 03, 2001 4:53 PM
To: '[EMAIL PROTECTED]'
Subject: RE: Struts DB example

have a closer look.

-----Original Message-----
From: Bill G [mailto:[EMAIL PROTECTED]]
Sent: Thursday, 4 October 2001 9:50 AM
To: [EMAIL PROTECTED]
Subject: RE: Struts DB example

Francisco,

That is not a database example.

Thanks though.

-----Original Message-----
From: Francisco Hernandez [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, October 03, 2001 4:43 PM
To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Subject: Re: Struts DB example

check out the struts example, its very simple
----- Original Message -----
From: "Bill G" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, October 03, 2001 3:19 PM
Subject: Struts DB example

> I'm looking for a working Struts DB example that demonstrates the
following;
>
> Four screens - insert a record, update a record, delete a record and
select
> records
> >From one table with 3 columns ID, FirstName, LastName.
>
> I've looked around various places and cannot find this.
>
> Thanks!
>
>
>
>