• Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other Pie Elite all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Jeanne Boyarsky
  • Ron McLeod
  • Paul Clapham
  • Liutauras Vilda
Sheriffs:
  • paul wheaton
  • Rob Spoor
  • Devaka Cooray
Saloon Keepers:
  • Stephan van Hulst
  • Tim Holloway
  • Carey Brown
  • Frits Walraven
  • Tim Moores
Bartenders:
  • Mikalai Zaikin

Problem creating datasource in Websphere Test Environment

 
Greenhorn
Posts: 4
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Hi,
I am using hit.db2.Db2Driver to access DB2 . I want to create a datasource in websphere test environment but the problem is in Add Datasource window of WSTE ,i am not able to specify the database driver as hit.db2.Db2Driver . It gives a drop down list of the ibm drivers available and i can't type my driver name there.
Is there any way of getting the hitdriver in that drop down list?
I have included teh .jar files(for driver) in the workspace
classpath .
Please help.
thanks
Rashmi
 
Greenhorn
Posts: 3
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Hi Rashmi,
I have created a Datasource using an oracle driver. But, as far as creating a datasource is concerned, U need to create a Datasource by clicking on the tasks -> create DataSource -> install new driver. Here u can give the DataBase name, and other details. Once u created ur own driver then automatically this driver will also appear in the drivers drop down. Hope this is helpful.
 
Greenhorn
Posts: 2
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Hi Rashmi,
in WTE of Websphere 3.5 we don't have
the tasks -> create DataSource -> install new driver
when creating a DataSource.
Do you have another version, a special fixpack or patch
installed?
thanx
Joachim

Originally posted by prasadh raju:
Hi Rashmi,
I have created a Datasource using an oracle driver. But, as far as creating a datasource is concerned, U need to create a Datasource by clicking on the tasks -> create DataSource -> install new driver. Here u can give the DataBase name, and other details. Once u created ur own driver then automatically this driver will also appear in the drivers drop down. Hope this is helpful.


 
Ranch Hand
Posts: 74
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
From WebSphere 3.5 HandBook, page 579

14.4.1 Create a JDBC driver
To create a JDBC driver, switch to Type View. Right-click JDBC Drivers and
select Create... option as shown in Figure 423 on page 580.
The JDBC driver properties dialog box will appear as shown in Figure 424 on
page 581. Specify the properties for the JDBC driver:
� Name
This is the name by which to administer the driver. Any value can be used.
Specify DB2 JDBC Driver as the name.
� Class Name
This is the implementation class of the driver code.
Specify the DB2 driver choice as com.ibm.db2.jdbc.app.DB2Driver.
� URL prefix
This is the URL prefix with which this driver is associated. The URL prefix
is comprised of the protocol and subprotocol, separated by a colon (":"). It
is followed by the database name of the data source to compose the full
JDBC URL of the database.
Accept the default jdbc:db2.
� JTA Enable
JTA is a transaction API for Java applications. This property specifies
whether the driver can handle Java-based two-phase commit transactions.
If not performing distributed transactions, set this value to False.
For WebSphere Application Server V3.0x, if JTA Enabled is selected as
True, the URL prefix has to be set to jdbc:jta:db2. But for WebSphere V3.5,
selecting JTA Enabled is sufficient, since the URL Prefix value is
independent of whether JTA is enabled.
If you want to create a JDBC driver for other databases, you will need to
specify the proper implementation class name and the URL prefix.
WebSphere provides four more choices for Class Name. When you select
one, the URL prefix will be changed automatically as shown in Figure 425 on
page 582. For example, if you choose oracle.jdbc.driver.OracleDriver,the
URL prefix will be set as jdbc:oracle:thin:@hostname:1521 at the same time,
you will need to change �hostname� to the real host name (Oracle Server).
After you specify all information, click OK to create JDBC Driver. An
information dialog box will show that the command was completed
successfully.

I followed this steps and it seems to be configured ok, but I'm trying to make a client to test DB access through WAS, so if anyone has such a client, please tell me.
Thank you,
Horaci Macias
[This message has been edited by Horaci Macias (edited November 13, 2001).]
 
Joachim Spehl
Greenhorn
Posts: 2
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Hi,
in order not to disturb our WAS environment I need to use the Websphere Test Environment.
We want to test database access using the merant driver for working with distributed transactions.
So we want to use these driver within our WTE
but so far I didn't find a solution for it.
thanx.
Joachim
 
Ranch Hand
Posts: 300
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
I have written a class to create a data source for the
WTE

I hope this helps if you need furtehr assistance feel free to ask
 
Don't get me started about those stupid light bulbs.
reply
    Bookmark Topic Watch Topic
  • New Topic