• 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 all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Liutauras Vilda
  • Bear Bibeault
  • Junilu Lacar
  • Martin Vashko
Sheriffs:
  • Jeanne Boyarsky
  • Tim Cooke
  • Knute Snortum
Saloon Keepers:
  • Ron McLeod
  • Tim Moores
  • Stephan van Hulst
  • Tim Holloway
  • Carey Brown
Bartenders:
  • Scott Selikoff
  • salvin francis
  • Piet Souris

SQLException while connecting to db... Help needed!

 
Ranch Hand
Posts: 173
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi i m trying to connect to Oracle 9i using websphere. The URL String in the datasource setting is as follows
jdbc racle:thin:@127.0.0.1:1521:RTGS
the user name and password both are "rtgs" and are valid in database. but when i try to run the client it throws an SQLException about invalid username/password. Here is some of the client code.

Any Kind of help regarding this is appreciated. Thanks
 
Gul Khan
Ranch Hand
Posts: 173
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Can some one plz give me some links where i can find resources about datasources with websphere 5.0. i couldnt find enough help from info center.
Thanks
 
Ranch Hand
Posts: 1551
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Have you searched the old posts in this forum?
The fine folks in the JDBC and the Oracle/OAS may have some ideas too.
 
Ranch Hand
Posts: 179
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
See chapters 4/5 of "IBM WebSphere Application Server Version 5.0.2: Applications" pdf manual. This was in the Library section of WAS5 but it's been "moved" so you will have to search for it.
 
Gul Khan
Ranch Hand
Posts: 173
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Thanks for the help. i tried to search but couldnt find so i put up the problem to IBM online support. Will put solution here once i get it from them.
Thanks again
Gul
 
Gul Khan
Ranch Hand
Posts: 173
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Found out that must specify the user name, password etc in the container J2C authetication for it to work.
 
Doody calls. I would really rather that it didn't. Comfort me wise and sterile tiny ad:
Java file APIs (DOC, XLS, PDF, and many more)
https://products.aspose.com/total/java
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!