Configuring JDBC DataSources in Struts
By: Barbara Printer Friendly Format
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.
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.
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();
Comment on this tutorial
- Data Science
- Android
- AJAX
- ASP.net
- C
- C++
- C#
- Cocoa
- Cloud Computing
- HTML5
- Java
- Javascript
- JSF
- JSP
- J2ME
- Java Beans
- EJB
- JDBC
- Linux
- Mac OS X
- iPhone
- MySQL
- Office 365
- Perl
- PHP
- Python
- Ruby
- VB.net
- Hibernate
- Struts
- SAP
- Trends
- Tech Reviews
- WebServices
- XML
- Certification
- Interview
categories
Subscribe to Tutorials
Related Tutorials
Configuring JDBC DataSources in Struts
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
When is the best time to validate input in Struts
What is a Plug-in and how to use Java plug-ins with Struts?
Origin and Architecture of Struts
Archived Comments
1. Please tell me the full program for insert values
View Tutorial By: Mohamed Ussain at 2009-08-28 23:14:47
2. pls tell me how to insert data in database .
View Tutorial By: sankar at 2009-10-22 05:37:45
3. can u pls tell me how to retrive data from databas
View Tutorial By: yogesg desai at 2010-05-27 08:26:24
4. can u pls tell me how to retrive data from databas
View Tutorial By: yogesg desai at 2010-05-27 08:28:10
5. can u p-lease tell me the clear idea of how to sto
View Tutorial By: osman at 2010-08-19 04:33:37
6. Can u tell me more about struts related to databas
View Tutorial By: archana at 2010-09-15 04:38:54
7. i need full program for connect oracle to struts l
View Tutorial By: Munaver Basha at 2010-09-30 01:28:10
8. Hi I too need the full program for understanding
View Tutorial By: Sumanth at 2010-10-03 16:02:46
9. I know core java jsp and sql. I want to retrieve d
View Tutorial By: Vinoth at 2011-08-16 07:22:15
10. hello, I want to know how to connect drop down in
View Tutorial By: sanjana at 2011-10-13 17:57:52
11. pls tell how to insert,delete and update the datab
View Tutorial By: vinoth at 2012-05-30 06:44:49
12. Hi I am new to struts framework. Can u tell how to
View Tutorial By: Nithya at 2012-11-27 14:03:46
13. Hi, everyone, i found a full tutorial with program
View Tutorial By: Mdhar at 2013-07-05 06:46:28
14. WOW just what I was looking for. Came here by sear
View Tutorial By: motos de agua tenerife norte at 2017-08-06 20:20:58