This week's book giveaway is in the Design forum.
We're giving away four copies of Building Microservices and have Sam Newman on-line!
See this thread for details.
The moose likes JDBC and Relational Databases and the fly likes How to actually create a Datasource Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Building Microservices this week in the Design forum!
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "How to actually create a Datasource" Watch "How to actually create a Datasource" New topic
Author

How to actually create a Datasource

Fergus Red
Ranch Hand

Joined: Apr 25, 2002
Posts: 42
Hi,
I've installed a MS SQL Server JDBC driver and got it working using a connection driver manager as in the following example.
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
Connection conn = DriverManager.getConnection
("jdbc:microsoft:sqlserver://server1:1433;User=test;Password=secret");

Now I want to use a Datasource.
To access a Datasource from my Java class I can do so by using the code:
Context ctx = new InitialContext();
DataSource ds = (DataSource)ctx.lookup("jdbc/EmployeeDB");
Connection con = ds.getConnection("matt", "wwf");

However what I want to know is how do you actually create the datasource that I will be referencing in my code as above.
Jamie Robertson
Ranch Hand

Joined: Jul 09, 2001
Posts: 1879

have a look at Frank Carver's general implementation of the Connection Pool here
Jamie
Ken Robinson
Ranch Hand

Joined: Jul 25, 2002
Posts: 52
Usually, code that requires a DataSource is running from within a web/app server. These servers have tools (usually a GUI tool or a config file) that allow you to configure the properties of the DataSource, including JDBC driver class, URL, username, password and so on.
Each vendor most likely has a subclass of the DataSource class that implements the DataSource as they see fit. Basically, you just need to know that it is there and how to look it up. In most instances, you will not need to explicitly create it yourself.
 
I’ve looked at a lot of different solutions, and in my humble opinion Aspose is the way to go. Here’s the link: http://aspose.com
 
subject: How to actually create a Datasource
 
It's not a secret anymore!