First of all if it were me I would be using Weblogic maybe Websphere.
in Weblogic it is much easier to set this up. However, you can try the
following
Classpath (for Oracle 8i)
%ORACLE_HOME%\jdbc\lib\classes111.zip;
then
try{
Context context = new InitialContext ( );
javax.sql.DataSource ds = ( javax.sql.DataSource ) context.lookup
(oracleDataSource" );
conn = ds.getConnection ( );
}catch ( NamingException n){
}catch ( SQLException s){
}catch ( Exception ex ){
}
----- Original Message -----
From: Pawan Aggarwal <[EMAIL PROTECTED]>
Date: Saturday, November 4, 2000 0:21 am
Subject: Urgent
> Hi All,
>
> I have some database connectivity problem
> with J2EE App Server and Oracle.
> I searched the whole archives but didn't get
> the solution to this problem..
>
> As suggested by J2EE documention i placed the classes111.zip
> in the J2EE_HOME\lib\system..gave its path in the J2EE_CLASSPATH
> and CLASSPATH in enviro..variables..
>
> default.properties have
> jdbc.drivers=oracle.jdbc.driver.OracleDriver
> jdbc.datasources=jdbc/Oracle|jdbc:oracle:thin:@SRV:1521:AppDB
>
> Now the Resource Ref's have a coded name as "jdbc/Oracle",type
> datasource,authentication as container
> User Name as Scott and Password as Tiger
> When i give the JNDI name as "jdbc/Oracle" then the deployment
> works but i get SQLException while getting connection.
> and when i give JNDI name as "Oracle" the bean doesnot deploy
> sucessfullygiving errors..
> Suggest me what am i doing wrong?
>
> Thanks in advance\
>
________________________________________________________________________
_
> Get Your Private, Free E-mail from MSN Hotmail at
> http://www.hotmail.com.
> Share information about yourself, create your own public profile at
> http://profiles.msn.com.
>
>
========================================================================
===
> To unsubscribe, send email to [EMAIL PROTECTED] and include in
> the body
> of the message "signoff EJB-INTEREST". For general help, send
> email to
> [EMAIL PROTECTED] and include in the body of the message "help".
>
>
===========================================================================
To unsubscribe, send email to [EMAIL PROTECTED] and include in the body
of the message "signoff EJB-INTEREST". For general help, send email to
[EMAIL PROTECTED] and include in the body of the message "help".
