RE: Struts DB example
Title: RE: Struts DB example Castor has a mailing list you can subscribe to from http://www.exolab.org. The examples it comes with are quite good, and the list will be helpful in getting them configured for you. As far as using it with Struts (as I do), I've placed a wrapper around the persistence mechanism and retrieving/updating the business objects from my action classes, then calling methods on them. This is because most of the actions are simple and there was no need to shadow business classes with a data object. Cheers, Brett -Original Message- From: Viet Kevin [mailto:[EMAIL PROTECTED]] Sent: Thursday, 4 October 2001 7:56 PM To: [EMAIL PROTECTED] Subject: Re: Struts DB example On Thu, 4 Oct 2001 14:03:04 +0530 "Amitkumar J Malhotra" <[EMAIL PROTECTED]> wrote: > > > Micheal > please could you tell me something more about castor JDO > > Thanx > Amit > I'm interested too in Castor JDO, it will be cool i can have real-code examples to understand the whole thing
RE: Struts DB example
Title: RE: Struts DB example Michael, Is there a .WAR file for TeaTimeJ that you'd be willing to let people play with as an example of DB access and Castor JDO with Struts? Nathan Anderson -Original Message-From: Michael Mok [mailto:[EMAIL PROTECTED]]Sent: Thursday, October 04, 2001 12:34 AMTo: [EMAIL PROTECTED]; [EMAIL PROTECTED]Cc: [EMAIL PROTECTED]Subject: RE: Struts DB example Bill Check out TeaTimeJ Web TimeSheet www.teatimej.com . It is a STRUTS 1.0+ based application and it uses Castor JDO to maintain records in a MySQL database. Regards Michael Mok -Original Message-From: Bill G [mailto:[EMAIL PROTECTED]]Sent: Thursday, 4 October 2001 13:20To: [EMAIL PROTECTED]Subject: 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 PMTo: '[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 AMTo: [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 PMTo: '[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! > > > >
Re: Struts DB example
On Thu, 4 Oct 2001 14:03:04 +0530 "Amitkumar J Malhotra" <[EMAIL PROTECTED]> wrote: > > > Micheal > please could you tell me something more about castor JDO > > Thanx > Amit > I'm interested too in Castor JDO, it will be cool i can have real-code examples to understand the whole thing
RE: Struts DB example
Micheal please could you tell me something more about castor JDO Thanx Amit
RE: Struts DB example
Title: RE: Struts DB example Thanks Michael! I'll check it out. Bill... -Original Message-From: Michael Mok [mailto:[EMAIL PROTECTED]]Sent: Thursday, October 04, 2001 12:34 AMTo: [EMAIL PROTECTED]; [EMAIL PROTECTED]Cc: [EMAIL PROTECTED]Subject: RE: Struts DB example Bill Check out TeaTimeJ Web TimeSheet www.teatimej.com . It is a STRUTS 1.0+ based application and it uses Castor JDO to maintain records in a MySQL database. Regards Michael Mok -Original Message-From: Bill G [mailto:[EMAIL PROTECTED]]Sent: Thursday, 4 October 2001 13:20To: [EMAIL PROTECTED]Subject: 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 PMTo: '[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 AMTo: [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 PMTo: '[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! > > > >
RE: Struts DB example
Title: RE: Struts DB example Bill Check out TeaTimeJ Web TimeSheet www.teatimej.com . It is a STRUTS 1.0+ based application and it uses Castor JDO to maintain records in a MySQL database. Regards Michael Mok -Original Message-From: Bill G [mailto:[EMAIL PROTECTED]]Sent: Thursday, 4 October 2001 13:20To: [EMAIL PROTECTED]Subject: 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 PMTo: '[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 AMTo: [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 PMTo: '[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! > > > >
RE: Struts DB example
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 PMTo: '[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 AMTo: [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 PMTo: '[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! > > > >
Re: Struts DB example
Title: RE: Struts DB example check out http://java.sun.com/j2ee/blueprints/design_patterns/data_access_object/index.html lots of people like use a DAO as illustrated in that page. for larger source check out this DAO too: http://java.sun.com/j2ee/blueprints/jps11/src/com/sun/j2ee/blueprints/customer/order/dao/OrderDAOOracle.java.html - Original Message - From: Bill G To: [EMAIL PROTECTED] Sent: Wednesday, October 03, 2001 5:19 PM 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 PMTo: '[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! > > > >
RE: Struts DB example
Title: 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 AMTo: [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 PMTo: '[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! > > > >
RE: Struts DB example
Title: 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 PMTo: '[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! > > > >
RE: Struts DB example
Title: 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! > > > >
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! > > > >
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! > > > >