• 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:
  • Tim Cooke
  • Campbell Ritchie
  • Ron McLeod
  • Liutauras Vilda
  • Jeanne Boyarsky
Sheriffs:
  • Junilu Lacar
  • Rob Spoor
  • Paul Clapham
Saloon Keepers:
  • Tim Holloway
  • Tim Moores
  • Jesse Silverman
  • Stephan van Hulst
  • Carey Brown
Bartenders:
  • Al Hobbs
  • Piet Souris
  • Frits Walraven

Datasource Configuration

 
Greenhorn
Posts: 2
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
How do I configure datasource using Oracle type 4 driver in a J2EE1.3 project developed in WSAD5.1
 
Bartender
Posts: 10336
Hibernate Eclipse IDE Java
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
You do it as per the documentation. What problems are you experiencing when you try this?
 
Sheriff
Posts: 67620
173
Mac Mac OS X IntelliJ IDE jQuery TypeScript Java iOS
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
"Smitha GS",

We're pleased to have you here with us on the Ranch, but there are a few rules that need to be followed, and one is that proper names are required. Please take a look at the JavaRanch Naming Policy and adjust your display name to match it.

In particular, your display name must be a first and a last name separated by a space character, and must not be obviously fictitious.

Thanks!
bear
Forum Bartender
 
Ranch Hand
Posts: 1143
1
Eclipse IDE Oracle Java
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Bear,
Maybe "GS" is the guy's last name?

How would you like it if some bartender asked you to change your display name -- because he thought that "Bear" can't be used as a first name?

Good Luck,
Avi.
 
author & internet detective
Posts: 40913
840
Eclipse IDE VI Editor Java
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Avi,
Names typically contain vowels. If there is a language where this isn't the case, Smitha can point it out.

If someone questioned Bear's name, he would reply that Bear is his name.
 
Bear Bibeault
Sheriff
Posts: 67620
173
Mac Mac OS X IntelliJ IDE jQuery TypeScript Java iOS
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
If you have issues with the naming policy, please feel free to bring it up in the JavaRanch forum which is the appropriate place for discussion regarding site policies.

With regards to my own name, it was validated long long ago. It appears on my business card and on my office nameplate.

bear
Forum bartender
 
Smitha GS
Greenhorn
Posts: 2
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Following is the error I get on trying to connect to a Oracle datasource .
Component-managed authentication alias not specified for connection factory or datasource Data source 1.

Mine is a J2EE1.3 project with Oracle thin driver , Oracle version 8.1.7 .
I have created a v5 datasource .
My code is as below:
InitialContext ctx = null;
javax.sql.DataSource ds = null;
ctx = new InitialContext();
ds = (javax.sql.DataSource) ctx.lookup("java:comp/env/jdbc/ds1");
Connection conn = ds.getConnection("<userId>","<password>");
return con;

I have also tried using com.ibm.websphere.naming.WsnInitialContextFactory
That too doesn't work .
Please let me know the solution in case any of you have faced this earlier.

Thanks
PS: GS is just my initials . I am sorry I did not go through naming policy.I shall do that .
 
Bear Bibeault
Sheriff
Posts: 67620
173
Mac Mac OS X IntelliJ IDE jQuery TypeScript Java iOS
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator

I am sorry I did not go through naming policy.I shall do that .



Please do so. Accounts with invalid display names are subject to removal and I'd hate to see that happen.

thanks,
bear
Forum bartender
[ March 17, 2005: Message edited by: Bear Bibeault ]
 
Ranch Hand
Posts: 1087
Oracle Spring Java
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator

Originally posted by Smitha GS:

Following is the error I get on trying to connect to a Oracle datasource .
Component-managed authentication alias not specified for connection factory or datasource Data source 1.



Smitha

error itself is telling reason.

how did you define your connection string in WSAD data source

either provide a connection string like

jdbc racle:thin:UserId/Password@IP_ADDRESS:1521:service_name
or
if you have provided it as

jdbc racle:thin:@IP_ADDRESS:1521:service_name

create a j2c entry in WSAD where you can provide an alias name with user id and password , then you can choose same alias in your data source configuration.

hope this will help

Originally posted by Smitha GS:
PS: GS is just my initials . I am sorry I did not go through naming policy.I shall do that



This is my personal opinion that many of us don't like to reply on a post who dont have name according to naming policy.
 
With a little knowledge, a cast iron skillet is non-stick and lasts a lifetime.
reply
    Bookmark Topic Watch Topic
  • New Topic