Configuring JDBC DataSources in Struts
By: Barbara
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();
Archived Comments
1. WOW just what I was looking for. Came here by searching for
Configuring JDBC DataSources in
View Tutorial By: motos de agua tenerife norte at 2017-08-06 20:20:58
2. Hi, everyone, i found a full tutorial with program Storing data using JDBC and Struts. You can <a
View Tutorial By: Mdhar at 2013-07-05 06:46:28
3. 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
4. pls tell how to insert,delete and update the database use struts
View Tutorial By: vinoth at 2012-05-30 06:44:49
5. hello, I want to know how to connect drop down in jsp to database using struts framework, n i m also
View Tutorial By: sanjana at 2011-10-13 17:57:52
6. I know core java jsp and sql. I want to retrieve date from database using servlet. Give me some exam
View Tutorial By: Vinoth at 2011-08-16 07:22:15
7. Hi I too need the full program for understanding
View Tutorial By: Sumanth at 2010-10-03 16:02:46
8. i need full program for connect oracle to struts like html page,java class file,interface,implementa
View Tutorial By: Munaver Basha at 2010-09-30 01:28:10
9. Can u tell me more about struts related to database connectivity, & how to store & retrieve
View Tutorial By: archana at 2010-09-15 04:38:54
10. 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
11. can u pls tell me how to retrive data from database in struts
View Tutorial By: yogesg desai at 2010-05-27 08:28:10
12. 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
13. pls tell me how to insert data in database .
View Tutorial By: sankar at 2009-10-22 05:37:45
14. Please tell me the full program for insert values in database.
View Tutorial By: Mohamed Ussain at 2009-08-28 23:14:47
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
Related Tutorials
Configuring JDBC DataSources in Struts
When is the best time to validate input in Struts
Simple example of using the requiredif Validator rule in Struts
How to prepopulate a form in Struts
Using JavaScript to submit a form in Struts
FAQ: Why are my checkboxes not being set from ON to OFF?
FAQ: Why was reload removed from Struts (since 1.1)?
What is a Plug-in and how to use Java plug-ins with Struts?
Origin and Architecture of Struts
Handling multiple buttons in HTML Form in Struts