VisualBuilder
  Home > Java > Tutorials > Connection pooling And Data Sources - JDBC Tutorial
Tell a friend
Link to us
Total Members
      Members: 84648
     
Sitemap Forum Chat
Home
JDBC Tutorial Home
1 . Introduction To JDBC
2 . Connection Interface
3 . The Data Model For the Examples
4 . Basic CRUD functionality using Statements
5 . Handling Data with Result Sets
6 . Using PreparedStatements
7 . Scrollable and Updateable ResultSets
8 . Adding, Updating and Deleting Rows using ResultSets.
9 . Using Joins in JDBC Quries.
10 . Calling procedures with Callable Statement
11 . Transaction Management Part-1
12 . Transaction Management Part-2
13 . Connection pooling And Data Sources
14 . Batch Updates Using Statements
15 . Handling Batch/SQL Errors and Warnings
16 . Handling Blob and CLOB data using JDBC
17 . Basics for Rowsets and JdbcRowSet Example
18 . CachedRowSet
19 . JoinRowSet
20 . FilterRowSet
21 . WebRowSet
22 . Next steps
 
Java Group Home
Java Discussion (273)
Java Members (27593)
Java Resources
Java Source Code (1095)
Java Articles (5)
Java Blogs
Java Jobs
Java Components (84)
Java Books
Java Websites (126)
Java News (103)
Java Q & A (114)
- Java Ask Question
- Java Questions
- Java Unanswered Questions
 
GROUPS
.NET
ASP.NET
.NET
C#
ASP
Visual Basic
Java
Java
JSP
EJB
Other
Delphi
C++
Ajax
UML
JavaScript
PHP
Web Design
Web Hosting
SQL Server
Oracle
Project Management
More Groups

 
LEARNING CENTER
TUTORIALS
.NET
.NET Tutorial
ASP Tutorial
ASP.NET Database Tutorial
ASP.NET Development Tips
ASP.Net Security,Internationalisation And Deployment
ASP.NET Server Controls Tips
ASP.NET Tutorial
C Sharp Tutorial
Web Development
Flex Tutorial
HTML Tutorial
Learn AJAX Tutorial
PHP Tutorial
Software Development
Database Tutorial
SQL Tutorial
UML Tutorial
Java
Ant Tutorial
EJB 3 Tutorial
Grails Tutorial
Hibernate Tutorial
Java 1.6 Tutorial
Java Tutorial
Java Web Component Tutorial
Java XML Tutorial
JDBC Tutorial
JDK1.5 Tutorial
JSF Tutorial
JSP And J2EE Design Tutorial
JSP Tutorial
Service-Oriented Architecture (SOA) Using Java Web Services Tutorial
Spring Tutorial
Struts Tutorial

RESOURCES
Q & A (436 )
Source Code (3275 )
Articles (11 )
Components (1589 )
News (888 )
Websites (1207 )

SUBMISSIONS
Submit Article
Submit Website
Submit News
Submit Source Code
Submit Component

COMMUNITY
Members Directory
Discussion Forum
Chat

SITE
About Us
Sitemap
Search
Contact Us
Link To Us
Feedback
Tell a Friend
Partners
Advertise


Java jdbc Tutorial
 Connection pooling And Data Sources
  << Prev: Transaction Management Part-2 Next: Batch Updates Using Statements >>

A DataSource object represents a particular DBMS or some other data source, such as a file. If a company uses more than one data source, it will deploy a separate DataSource object for each of them. In a native SQL environment the most of the response time is used in creating and managing the connections in the database. So the architects has introduced the connection pooling mechanism in which a pool of active connection is created at the startup of server or application and then all java programs will borrow the connection as and when required. The freeing or connections will be taken care by the pool itself so if user will not close the connection objects then it is done implicitly.


The below example will call the datasource in the weblogic server.


 


package com.visualbuilder;
import java.sql.Connection;
import java.util.Hashtable;


import javax.naming.Context;
import javax.naming.InitialContext;
import javax.sql.DataSource;


public class DataSourceExample {
    public static void main(String[] args) {
            Context ctx = null;
    try {
                Hashtable ht = new Hashtable();
        ht.put(Context.INITIAL_CONTEXT_FACTORY,
                    "weblogic.jndi.WLInitialContextFactory");
        ht.put(Context.PROVIDER_URL, "t3://localhost:7001");
        ctx = new InitialContext(ht);
                DataSource ds = (DataSource)ctx.lookup("DataSourcePool");
                Connection con = ds.getConnection();
                System.out.println("Connection Established");
        con.close();
                }catch(Exception exp)
                {
            exp.printStackTrace();
                }
        }
}


Output:-


Connection Established

  << Prev: Transaction Management Part-2 Next: Batch Updates Using Statements >>
Java Jdbc Tutorial Home
Give feedback and win a prize.

 
   Printer Friendly
   Email to a friend
   Add to my Favourites    
  Download PDF version
   Report Bad Submissions
   Submit Feedback
 
  Delicious   Digg   Technorati   Blink   Furl   Reddit   Newsvine   Google Click each image to add
this page to each site.
 
 
Welcome Guest Signup
MEMBER'S PANEL
EMAIL
PASSWORD
Forgot your password?
New User? Click Here!
 
Resend Activation Email!
 
SEARCH
 
 
LINKS
Montignac Shop
motorola phone tools
online fax server
Video Surveillance
Gift to Pakistan
 
ADVERTISEMENT
 
PARTNER LIST

More
 
 
 

Home | Login | About Us | Contact Us | Privacy Policy | Advertising