aspose file tools*
The moose likes Websphere and the fly likes Doubt on specifying Data source Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Products » Websphere
Bookmark "Doubt on specifying Data source" Watch "Doubt on specifying Data source" New topic
Author

Doubt on specifying Data source

Mey Mey
Greenhorn

Joined: May 17, 2001
Posts: 14
Hi,
I am trying to deploy Account EJB of websphere examples, I am working on linux machine having oracle database on solaris, database configuration are ok, How to specify data source while creating container, when I click change button on admin console I am getting only NONE, I am not able to deploy the bean without specifying data source can anybody help me out in this regard.
Tony Chen
Ranch Hand

Joined: Jan 29, 2001
Posts: 286
You need to create a "Data Source" first!
------------------
Tony Chen
SCJP, ICS & ICSD (WebSphere)


SCJP Java 2 - IBM Certified Enterprise Developer - WebSphere V4.0 & V5.0 - IBM Certified System Administrator - WebSphere Network Deployment V6.0 - Canadian Securities Course (CSC) Certification
daman sidhu
Ranch Hand

Joined: Aug 19, 2000
Posts: 184
Hi,
From the types tab u first need to create a jdbc driver for oracle, then u need to create a datasource from that driver and then u need to install that driver from the topology tab, then u will get it in the container selection of datasource.
Rahul Mahindrakar
Ranch Hand

Joined: Jul 28, 2000
Posts: 1859
Mey Mey,
I have sucessfully been able to create a ORACLE Datasource and a JDBC driver. If you want any further details do get in touch over here.
Its easy once you know how
daman sidhu
Ranch Hand

Joined: Aug 19, 2000
Posts: 184
i created the jdbc driver with the thin client for oracle, the url ull have to specify is jdbc racle:thin:@pcname ort
dont specify the db name after this, as the driver is database specific
daman sidhu
Ranch Hand

Joined: Aug 19, 2000
Posts: 184
oh i didnot disable the similies, it is
oracle:jdbc:thin:@pcname:port
Mey Mey
Greenhorn

Joined: May 17, 2001
Posts: 14
Thanks a lot now I am able to connect with oracle thro' bean, its due to the problem of not specifying datasource.
 
Consider Paul's rocket mass heater.
 
subject: Doubt on specifying Data source