Configuring JDBC DataSources in Struts

By: Barbara Emailed: 1675 times Printed: 2156 times    

Latest comments
By: rohit kumar - how this program is work
By: Kirti - Hi..thx for the hadoop in
By: Spijker - I have altered the code a
By: ali mohammed - why we use the java in ne
By: ali mohammed - why we use the java in ne
By: mizhelle - when I exported the data
By: raul - no output as well, i'm ge
By: Rajesh - thanx very much...
By: Suindu De - Suppose we are executing

You can define any number of JDBC javax.sql.DataSource objects for the application in the configuration file under the element <data-sources>. Every data source is defined within the <data-sources> element using the <data-source> element. The <data-source> element defines a number of attributes, the most important of which are listed in Table below.

<data-source> Attributes

Element Attribute

Description

key

The name used by Action classes for looking up this connection. The default is org.apache.struts.action.DATA_SOURCE (defined in the constant org.apache.struts.Globals.DATA_SOURCE_KEY).

type

The name of the actual class that implements the DataSource interface.

You supply any further configuration information using nested <set-property> tags. You can use these tags to set JavaBeans properties on the DataSource; they take property and value attributes to specify the property to set and the value to which to set it.

The default attribute values for <data-source> cause it to instantiate a GenericDataSource and give it the key. The GenericDataSource class wraps an ordinary JDBC Driver and turns it into a DataSource with a database connection pool. This class has a number of JavaBean properties to configure, the most important of which are listed in Table below.

<data-source> Attributes

Element Attribute

Description

description

A description of this DataSource.

driverClass

The fully qualified JDBC Driver class used to access the database.

url

The JDBC URL used to access the database.

user

The username used to log into the database.

password

The password used to log into the database.

maxCount

The maximum number of connections in the connection pool.

readOnly

If true, the Connections returned by the DataSource re read-only; this has performance advantages with some databases.

autoCommit

If true, the Connections returned by the DataSource automatically commit the transaction after every SQL statement.

The following excerpt illustrates how you'll use these attributes to define a DataSource for the pizza MySQL database:

<data-sources>
  <data-source key="pizza">
    <set-property property="driverClass"
                   value="com.mysql.jdbc.Driver" />
    <set-property property="url"
                   value="jdbc:mysql://localhost/pizza" />
  </data-source>
</data-sources>

The DataSource will be bound in the application context under the name pizza. You can use it in the JSTL <sql:query>, <sql:update>, and <sql:transaction> tags:

<sql:query var="myobject"
            dataSource="${applicationScope.pizza}">

You can also retrieve it from within a Struts action using the getDataSource() method:

DataSource ds = getDataSource(request, "pizza");
Connection con = ds.getConnection();

Struts Home | All Struts Tutorials | Latest Struts Tutorials

Sponsored Links

If this tutorial doesn't answer your question, or you have a specific question, just ask an expert here. Post your question to get a direct answer.



Bookmark and Share

Comments(9)


1. View Comment

Please tell me the full program for insert values in database.

View Tutorial          By: Mohamed Ussain at 2009-08-28 23:14:47
2. View Comment

pls tell me how to insert data in database .

View Tutorial          By: sankar at 2009-10-22 05:37:45
3. View Comment

can u pls tell me how to retrive data from database in struts

View Tutorial          By: yogesg desai at 2010-05-27 08:26:24
4. View Comment

can u p-lease tell me the clear idea of how to store and retrive the data from database

View Tutorial          By: osman at 2010-08-19 04:33:37
5. View Comment

Can u tell me more about struts related to database connectivity, & how to store & retrieve data in database using struts, & what are the changes made in struts-config.xml & web.xml file

View Tutorial          By: archana at 2010-09-15 04:38:54
6. View Comment

i need full program for connect oracle to struts like html page,java class file,interface,implementation and configration file ......please help me....

View Tutorial          By: Munaver Basha at 2010-09-30 01:28:10
7. View Comment

Hi I too need the full program for understanding

View Tutorial          By: Sumanth at 2010-10-03 16:02:46
8. View Comment

I know core java jsp and sql. I want to retrieve date from database using servlet. Give me some example program for better understanding.

View Tutorial          By: Vinoth at 2011-08-16 07:22:15
9. View Comment

Hi I am new to struts framework. Can u tell how to use JDBC in struts1.3

View Tutorial          By: Nithya at 2012-11-27 14:03:46

Your name (required):


Your email(required, will not be shown to the public):


Your sites URL (optional):


Your comments:



More Tutorials by Barbara
Configuring JDBC DataSources in Struts
What are the different scopes in JSP?
Drawbacks of the JSP Model 1 Architecture
Struts Classes

More Tutorials in Struts
Configuring JDBC DataSources in Struts
Struts Classes
FAQ: Why was reload removed from Struts (since 1.1)?
FAQ: Why are my checkboxes not being set from ON to OFF?
Using JavaScript to submit a form in Struts
How to prepopulate a form in Struts
Simple example of using the requiredif Validator rule in Struts
Chaining actions in Struts
When is the best time to validate input in Struts
What is a Plug-in and how to use Java plug-ins with Struts?
7 Best Practices of Struts
Origin and Architecture of Struts
ActionErrors and ActionError in Struts
Tutorial on Struts Configuration File - struts-config.xml in Struts - from the book: Struts Survival Guide. Basics to Best Practices
Handling multiple buttons in HTML Form in Struts

More Latest News
Most Viewed Articles (in Struts )
Tutorial on Struts Configuration File - struts-config.xml in Struts - from the book: Struts Survival Guide. Basics to Best Practices
Struts 1 vs Struts 2
What is Struts? Which Version of Struts to use?
ActionErrors and ActionError in Struts
Handling Duplicate Form Submissions in Struts
7 Best Practices of Struts
Handling multiple buttons in HTML Form in Struts
Struts-GUI and Struts Console
Protecting JSPs from direct access in Struts
DispatchAction in Struts
Using JavaScript to submit a form in Struts
Struts Classes
History of Struts
Configuring JDBC DataSources in Struts
Introduction to Struts Architecture
Most Emailed Articles (in Struts)
What is Struts? Which Version of Struts to use?
What is a Model View Controller (MVC) Model?
Is Struts the most popular web application framework for Java?
WebWork 2 is now Apache Struts 2
MVC Architecture (Model 2 Architecture)
Struts Classes
Creating Struts Modules
ActionErrors and ActionError in Struts
Handling multiple buttons in HTML Form in Struts
Handling Duplicate Form Submissions in Struts
Guidelines for Struts Application Development
Chaining actions in Struts
History of Struts
Configuring JDBC DataSources in Struts
Downloading and installing Struts