aspose file tools*
The moose likes Websphere and the fly likes Specifying Database url in datasource Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Products » Websphere
Bookmark "Specifying Database url in datasource" Watch "Specifying Database url in datasource" New topic
Author

Specifying Database url in datasource

Ashutosh Shinde
Ranch Hand

Joined: Jun 07, 2001
Posts: 42
Hello everyone,
I am working on Websphere version 5.0. I am trying to connect to a Lotus Database. However, I am unable to locate the place where I can set the database URL along with the user name and the password while creating the datasource. Any pointers in this regard would be most helpful. Thanks in advance.

-- Ashutosh
david dhavan
Ranch Hand

Joined: Dec 16, 2002
Posts: 38
there are 3 steps to it.
1. create a JDBC Driver.
- specify implementation class.
(If your driver is not listed you can add your own custom driver with an implementation class provided by vendor.)
2. create a DataSource.
3. Click on custom properties. You can now add all the properties as specified by the vendor in the key-value form one by one.
4. Click Apply-Ok and then at the end save master configuration for that to take effect.
Hope this helps
David
Scott Duncan
Ranch Hand

Joined: Nov 01, 2002
Posts: 363
data source should be set up on the box as well


No more rhymes! I mean it!<br /> <br />Does anybody want a peanut?
Kevin Black
Greenhorn

Joined: Jan 30, 2003
Posts: 12
Hi, David and William,
I am having problem in create a database connection to Access DB using WSAD 4.03. And when I see your post, I think maybe I can use the same way for Lotus to Access DB.

Question:
When you say: "create a JDBC Driver.
- specify implementation class.
(If your driver is not listed you can add your own custom driver with an implementation class provided by vendor.)", MS-Access driver is not listed, so, which driver should I use?

2. create a DataSource.
I can only create a datasource after I setup the driver. What happen if I don't have a driver, can I still setup this.
Thanks for your help!
Kevin
Scott Duncan
Ranch Hand

Joined: Nov 01, 2002
Posts: 363
OK Kevin,
When I say make sure the datasource is set up on the box, I mean do you have a datasource instance configured on your machine? If you go to the ODBC Data Source Administrator (Start->settings->contol Panel->ODBC Data Sources). Here, you will see under the drivers tab Driver do Microsoft Access (*.mdb) if MS Access is installed. This ODBC Data Source Administrator is where you need to set up your datasource for MS Access. As far as connection pooling goes, you are wasting your time unless you can find a proprietary JDBC driver as Kyle mentioned in the other thread.
[ February 04, 2003: Message edited by: William Duncan ]
Ashutosh Shinde
Ranch Hand

Joined: Jun 07, 2001
Posts: 42
Hello everyone,
Thanks everyone. I could connect to SQL server with the inbuilt driver provided by Websphere. My main aim was to connect to Lotus (-- this is how I started with the exercise before moving to SQL Server). However, since the Driver that I have (Lotus Driver for JDBC) does not implement the ConnectionPoolDataSource interface,, I was not able to connect to the database using the datasource! Is anyone aware of a JDBC driver for Lotus that implements the interface ? Thanks..
-- Ashutosh
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Specifying Database url in datasource