File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
The moose likes EJB and other Java EE Technologies and the fly likes Configure datasource with oracle8i in Websphere Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of EJB 3 in Action this week in the EJB and other Java EE Technologies forum!
JavaRanch » Java Forums » Java » EJB and other Java EE Technologies
Bookmark "Configure datasource with oracle8i in Websphere " Watch "Configure datasource with oracle8i in Websphere " New topic
Author

Configure datasource with oracle8i in Websphere

Jyotisree Dhar
Ranch Hand

Joined: Sep 15, 2001
Posts: 30
hi,
I have created datasource in websphere with oracle8i using classes12.zip dirver.
After that i deployed the ejb(Entity Bean) in the default container.......up till here everything is OK.

But once i start the default server it's giving the following error message :
Exception:
ORA-01918: user 'EJB' does not exist
java.sql.SQLException: ORA-01918: user 'EJB' does not exist
--------
com.ibm.ejs.sm.client.command.ExecutionException: Command Default Server.start Sub-command Error.
at com.ibm.ejs.sm.client.RepositoryOpException.<init>(RepositoryOpException.java:51)
at com.ibm.ejs.sm.client.command.ExecutionException.<init>(ExecutionException.java:63)
at com.ibm.ejs.sm.client.command.AbstractCommand.handleAct(AbstractCommand.java:223)
at com.ibm.ejs.sm.client.command.StartCommand.execute(StartCommand.java:93)
at com.ibm.ejs.sm.client.command.CommandManager$ExecutionThread.run(CommandManager.java:282)
-----------------------
and the server starts but the ejb dosent .
The details of the Datasource which i created are "
Data Source Name : oracle12
Database Name racle


Can somebody tell me where am i going wrong.
Jyotisree
Ranjith R
Greenhorn

Joined: Sep 18, 2001
Posts: 22
it will be useful if you provide the DB connection URL details,

or is there any problem with the url?


Take care<BR>r@njith
Jyotisree Dhar
Ranch Hand

Joined: Sep 15, 2001
Posts: 30
hi Ranjith, all this things are made by websphere application console.Because i am making a CMP.The class and url is:
Classs Name :-new oracle.jdbc.driver.OracleDriver())
Url :- jdbc: oracle:thin:@192.168.1.29:1521: oracle
(the last oracle word is my database name)
User id: scott
password:tiger
Please help
Jyotisree

[This message has been edited by jyotisree (edited October 03, 2001).]
Ranjith R
Greenhorn

Joined: Sep 18, 2001
Posts: 22
sorry for that smiley.. and small font..
here is the actual story:

<a href=" <A HREF="http://www-4.ibm.com/software/webservers/appserv/doc/v40/ae/infocenter/was/060705_advanced.html" rel="nofollow">Click" TARGET=_blank>http://www-4.ibm.com/software/webservers/appserv/doc/v40/ae/infocenter/was/060705_advanced.html">Click Here


-R@njith
Jyotisree Dhar
Ranch Hand

Joined: Sep 15, 2001
Posts: 30
Ranjith, i am working on Webspher3.5 the steps you mentioned earlier are for Websphere4 i guess.Any suggestion for Websphere3.5
Jyotisree

[This message has been edited by jyotisree (edited October 03, 2001).]
Ranjith R
Greenhorn

Joined: Sep 18, 2001
Posts: 22
Sorry..never worked on that version..
------------------
Take care
r@njith
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Configure datasource with oracle8i in Websphere
 
Similar Threads
websphere exception StaleActiveObject ..
WAS4.0 Repository and Application Databases
Problem in running a CMP URGENT
Websphere default user
WebSphere default server