wsad and oracle -SOS

[sandeep_saluja]

hi
I am trying to have my jsp connect to oracle using websphere.
I want to do this task using jndi mapping.
can u please help me with the steps.how to configure or where to give the jndi name and datasource etc ..and the url required to do the connection in jsp
i am using
InitialContext ic = new InitialContext();
DataSource ds = (DataSource) ic.lookup("jdbc/Con1");
Connection con = ds.getConnection();
now from where can i make jndi mapping and where the datasource refernce is to be given.
please help ..i need it very urgently.
Regards
Sandeep

[Baba Batsha]

You can do it via Admin console.
Refer to section 16.1.2 in the RedBook
B.Batsha
Chennai

[sandeep_saluja]

Hi
thanks for the reply.
i am new to Websphere and got a very urgent assignemnt.
Can u please let me know the steps to create a jndi and datasource configuration so i can connect with my oracle db in wsad.
i will make a db connection in my jsp using jndi lookup.
Many thanks
Best Regards
Sandeep
[ July 16, 2002: Message edited by: sandeep_saluja ]

[Simon Song]

You should be at least familiar with WSAD, you have to open the Server Perspective and create a Server Configuration for your project.
Then you will see the DataSource tab for your Server Instance, after that it is very normal way to define a DataSource(same as what you will do in WebSphere AppServer).
Check out this redbook(Chap16 Server Instances and Server Configurations):
http://www.redbooks.ibm.com/redpieces/pdfs/sg246585.pdf

[sandeep_saluja]

hi
thanks for reply.i have done all that .added all entries for datasource username password database name etc .
but still connection is not created.
regards
sandeep