• 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
  • Tim Cooke
  • paul wheaton
  • Jeanne Boyarsky
  • Ron McLeod
Sheriffs:
  • Paul Clapham
  • Liutauras Vilda
  • Devaka Cooray
Saloon Keepers:
  • Tim Holloway
  • Roland Mueller
Bartenders:

Entity bean is not able to connect to Database

 
Greenhorn
Posts: 14
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
I am trying to deploy the Account Enity bean of websphere eg., I have changed the finder helper class query like the following one
select * from ejb.Accounttable where accountname=? to
select * from myoracleusername.Accounttable where accountname=?

My bean is deployed successfully but when I start the bean I am getting error saying permission denied for user "ejb", can any one help me out by going thro' the same eg.
 
Ranch Hand
Posts: 1871
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Mey Mey
Have you given these rights to ejb user
grant connect,resource,dba to EJB;
just check it out.

 
Rahul Mahindrakar
Ranch Hand
Posts: 1871
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Also check out the log files for any additional data that it may contain. This log data will be very helpful. Just check it out.
Also try out if you can execute the sql command from the sql plus command prompt. If you can't then it is defenite that it is not a problem of WAS and that insufficient privilages exist for the user.
Keep us posted.
 
Ranch Hand
Posts: 202
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Hi
Could you put down all steps to connect to a Database(Oracle 8i)for deploying an Entity bean?
Suneel
 
Mey Mey
Greenhorn
Posts: 14
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Hi Rahul,
Thanks, now I am able to do the same, the problem is I have given the my oracle dba user id in configuration file, I found in a document when u deploy bean thro' admin console u should compulsorily have a user identified in the name EJB in oracle database, after creating the user with same name and giving previlages now I am able to deploy the bean and access the same thro' RMI client.
I hope if I use Visual age for dev. and deploying, I can have my own user id in database.
After Installation of WAS I found some 43 tables created for maintaining bean inforamtion, the number of tables keep on increasing when I deploy more beans, can any one explain now I am having 60 tables.
 
Rahul Mahindrakar
Ranch Hand
Posts: 1871
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Mey Mey,
The Administrative repository is the place where the Application server keeps its data. As an when need arises in my opnion it creates additional tables. For example there may be a need for a security table and it may create an additional one as needed. It is said that there are some 43 (I do not rembember for sure) tables required in version 3. More may be required in 3.5.
 
Today's lesson is that you can't wear a jetpack AND a cape. I should have read this tiny ad:
We need your help - Coderanch server fundraiser
https://coderanch.com/wiki/782867/Coderanch-server-fundraiser
reply
    Bookmark Topic Watch Topic
  • New Topic