Concurrent Tcp Client Server Program In Java' title='Concurrent Tcp Client Server Program In Java' />Java Data. Source, JDBC Data. Source Example. Java Data. Source and JDBC Data. Source programming is the way to work with database in our java programs. Concurrent Tcp Client Server Program In Java' title='Concurrent Tcp Client Server Program In Java' />IBM WebSphere Application Server provides periodic fixes for the base and Network Deployment editions of release V8. The following is a complete listing of fixes. The C10K problem Help save the best Linux news source on the web subscribe to Linux Weekly News Its time for web servers to handle ten thousand clients. We have already seen that JDBC Driver. Manager can be used to get relational database connections. But when it comes to actual programming, we want more than just connections. Java Data. Source. Most of the times we are looking for loose coupling for connectivity so that we can switch databases easily, connection pooling for transaction management and distributed systems support. JDBC Data. Source is the preferred approach if you are looking for any of these features in your application. Java Data. Source interface is present in javax. Connection and get. ConnectionString str. String str. 2. JDBC Data. Source. It is the responsibility of different Database vendors to provide different kinds of implementation of Data. Source interface. For example My. SQL JDBC Driver provides basic implementation of Data. Source interface with com. Mysql. Data. Source class and Oracle database driver implements it with oracle. Jar Of Beans Emulator For Windows there. Oracle. Data. Source class. These implementation classes provide methods through which we can provide database server details with user credentials. Some of the other common features provided by these JDBC Data. Source implementation classes are Caching of Prepared. Statement for faster processing. Connection timeout settings. Logging features. Result. Set maximum size threshold. JDBC Data. Source Example. Lets create a simple JDBC Data. Source example project and learn how to use My. SQL and Oracle Data. Source basic implementation classes to get the database connection. Our final project will look like below image. Java JDBC Data. Source Database Setup. Concurrent Tcp Client Server Program In Java' title='Concurrent Tcp Client Server Program In Java' />Tandem Computers FAQs HP NonStop server Frequently Asked Questions, Tandem Computer FAQs. WebLogic Server Application Architecture. WebLogic Server is an application server a platform for developing and deploying multitier distributed enterprise applications. Oracle acquired Sun Microsystems in 2010, and since that time Oracles hardware and software engineers have worked sidebyside to build fully integrated systems and. Before we get into our example programs, we need some database setup with table and sample data. Installation of My. SQL or Oracle database is out of scope of this tutorial, so I will just go ahead and setup table with sample data. Create Employee table. CREATE TABLE Employee. Id int1. 0 unsigned NOT NULL. DEFAULT NULL. PRIMARY KEY emp. Id. ENGINEInno. DB DEFAULT CHARSETutf. INSERT INTO Employee emp. Id, name. 1, Pankaj. CREATE TABLE EMPLOYEE. EMPID NUMBER NOT NULL ENABLE. NAME VARCHAR21. Modbus TCPIP Unplugged An introduction to Modbus TCPIP Addressing, Function Codes and Modbus TCPIP Networking. OVERVIEW MODBUS TCPIP is a variant of the. BYTE DEFAULT NULL. PRIMARY KEY EMPID. Insert into EMPLOYEE EMPID,NAME values 1. Pankaj. Insert into EMPLOYEE EMPID,NAME values 5,Kumar. Insert into EMPLOYEE EMPID,NAME values 1,Pankaj. Now lets move on to our java programs. For having database configuration loosely coupled, I will read them from property file. DB properties. MYSQLDBDRIVERCLASScom. Driver. MYSQLDBURLjdbc mysql localhost 3. User. DB. MYSQLDBUSERNAMEpankaj. MYSQLDBPASSWORDpankaj. Oracle DB Properties. ORACLEDBDRIVERCLASSoracle. Oracle. Driver. ORACLEDBURLjdbc oracle thin localhost 1. ORACLEDBUSERNAMEhr. ORACLEDBPASSWORDoracle. Make sure that above configurations match with your local setup. Also make sure you have My. SQL and Oracle DB JDBC jars included in the build path of the project. Java JDBC Data. Source My. SQL, Oracle Example. Lets write a factory class that we can use to get My. SQL or Oracle Data. Source. package com. File. Input. Stream. IOException. import java. SQLException. import java. Properties. import javax. Data. Source. import oracle. Oracle. Data. Source. Mysql. Data. Source. My. Data. Source. Factory. public static Data. Source get. My. SQLData. Source. Properties props new Properties. File. Input. Stream fis null. Mysql. Data. Source mysql. DS null. fis new File. Input. Streamdb. DS new Mysql. Data. Source. mysql. DS. URLprops. get. PropertyMYSQLDBURL. DS. set. Userprops. PropertyMYSQLDBUSERNAME. DS. set. Passwordprops. PropertyMYSQLDBPASSWORD. IOException e. Stack. Trace. return mysql. DS. public static Data. Source get. Oracle. Data. Source. Properties props new Properties. File. Input. Stream fis null. Oracle. Data. Source oracle. DS null. fis new File. Input. Streamdb. DS new Oracle. Data. Source. oracle. DS. set. URLprops. PropertyORACLEDBURL. DS. set. Userprops. PropertyORACLEDBUSERNAME. DS. set. Passwordprops. PropertyORACLEDBPASSWORD. IOException e. Stack. Trace. catch SQLException e. Stack. Trace. return oracle. DS. Notice that both Oracle and My. SQL Data. Source implementation classes are very similar, lets write a simple test program to use these methods and run some test. Connection. import java. Result. Set. import java. SQLException. import java. Statement. import javax. Data. Source. public class Data. Source. Test. public static void mainString args. Data. Sourcemysql. System. out. println. Data. Sourceoracle. Data. SourceString db. Type. Data. Source ds null. Type. ds My. Data. Source. Factory. My. SQLData. Source. Type. My. Data. Source. Factory. Oracle. Data. Source. System. out. Connection con null. Statement stmt null. Result. Set rs null. Connection. stmt con. Statement. rs stmt. Queryselect empid, name from Employee. System. out. printlnEmployee IDrs. Intempid, Namers. Stringname. catch SQLException e. Stack. Trace. ifrs null rs. SQLException e. Stack. Trace. Notice that the client class is totally independent of any Database specific classes. This helps us in hiding the underlying implementation details from client program and achieve loose coupling and abstraction benefits. When we run above test program, we will get below output. Employee ID1, NamePankaj. Employee ID2, NameDavid. Employee ID1. 0, NamePankaj. Employee ID5, NameKumar. Employee ID1, NamePankaj. Apache Commons DBCP Example. If you look at above Java Data. Source factory class, there are two major issues with it. The factory class methods to create the My. SQL and Oracle Data. Source are tightly coupled with respective driver API. If we want to remove support for Oracle database in future or want to add some other database support, it will require code change. Most of the code to get the My. SQL and Oracle Data. Source is similar, the only different is the implementation class that we are using. Apache Commons DBCP API helps us in getting rid of these issues by providing Java Data. Source implementation that works as an abstraction layer between our program and different JDBC drivers. Apache DBCP library depends on Commons Pool library, so make sure they both are in the build path as shown in the image. Here is the Data. Source factory class using Basic. Data. Source that is the simple implementation of Data. Source. package com. File. Input. Stream. IOException. import java. Properties. import javax. Data. Source. import org. Basic. Data. Source. DBCPData. Source. Factory. public static Data. Source get. Data. SourceString db. Type. Properties props new Properties. File. Input. Stream fis null. Basic. Data. Source ds new Basic. Data. Source. fis new File. Input. Streamdb. IOException e. Stack. Trace. return null. Type. ds. set. Driver. Class. Nameprops. PropertyMYSQLDBDRIVERCLASS. Urlprops. get. PropertyMYSQLDBURL. Usernameprops. get. PropertyMYSQLDBUSERNAME. Passwordprops. get. PropertyMYSQLDBPASSWORD. Type. ds. set. Driver. Class. Nameprops. PropertyORACLEDBDRIVERCLASS. Urlprops. get. PropertyORACLEDBURL. Usernameprops. get. PropertyORACLEDBUSERNAME. Passwordprops. get. PropertyORACLEDBPASSWORD.