Hi,
I'm new to this forum. I'm having trouble in connecting my web application to the oracle database. Can anyone guide me on the steps i need to follow to do the same? Also, does connecting to the database have any connection with the server i'm using? I was earlier using the Tomcat server, but now i'm using JBoss application server. I would appreciate if someone can answer my query at the earliest. I'm in need of urgent help. Thanks in advance!
Manvi

Hi manvi,
Please If u get answer let me know. Actualy i want to connect to oracle database and i have tomcat server. I am getting error. What jar file is needed? How to connect? Its urgent can u send me steps to connect?

I use oracle-jdbc-8.1.7.1.jar and Class.forName("oracle.jdbc.driver.OracleDriver").n ewInstance() for classloading.

Jon Emerson
http://blogs.adobe.com/jon.emerson/

Hi ,u can use following code to get connection with oracle database



public Connection getDBConnection(String dataSourceName, String dbName)
        throws PasskeyException {
        java.sql.Connection connection = null;
        long timeNowiS = System.currentTimeMillis();

        try {
            logger.debug("Just entering getdbcon get App Name "+timeNowiS);
            javax.sql.DataSource dataSource = null;

            if (dbContextlist.containsKey(dataSourceName)) {
                dataSource = (javax.sql.DataSource) dbContextlist.get(dataSourceName);
            } else {
                Context context = new InitialContext();
                dataSource = (javax.sql.DataSource) context.lookup(dataSourceName);
                dbContextlist.put(dataSourceName, dataSource);
                context.close();
            }
            //PerformanceTimer time1=new PerformanceTimer();
            String appName = PasskeyUtils.getAppName();
            logger.debug("getdbcon get App Name "+appName);
            String username = PropertyFileReader.getPasskeyProperty(dbName +"."+appName+
            ".username");
          String password = PropertyFileReader.getPasskeyProperty(dbName + "."+appName+
          ".pwd");
            if ((password == null) || password.trim().equals("")) {
                throw new SQLException("no password --for db " + dbName+"user****"+username+"=="+appName);
            }

            connection = dataSource.getConnection(username, password);
            connection.setCatalog(dbName);
        } catch (java.sql.SQLException sqlEx) {
            throw new PasskeyException("in servicelocator.getDBConnection",
                sqlEx);
        } catch (Exception genericEx) {
            throw new PasskeyException("in servicelocator.getDBConnection",
                genericEx);
        }
        logger.debug("Just exiting getdbcon get App Name "+timeNowiS+" and now it is "+System.currentTimeMillis());
        return connection;
    }


Thanks and Regards,
SACHIN S.TATHOD
Patni Computer System Ltd.
Magarpatta City, Cyber City,
Tower 3,Level I & II,
Hadapsar,Pune - 411028
Mobile No:- +91-9881239401
Email ID:- [email protected]