Re: Tomcat 4.0 (Oracle connection)

Sat, 15 Dec 2001 21:56:57 -0800

I don�t know centainly if it is possible to get a connection to Oracle from the file server.xml (I think is not possible).
 
Here is a little example:
 
You must compile the servlet personal.java (sent as attachment), then you must create the directory structure to deploy the servlet in Tomcat 4.0 (sent as attachment) an then yo want to add a context in the file server.xml:
 
        <!-- Define properties for each web application.  This is only needed
             if you want to set non-default properties, or have web application
             document roots in places other than the virtual host's appBase
             directory.  -->
 
<Context path="/personal"  docBase="d:\webapps\personal"  debug="0" />
        <!-- Tomcat Root Context -->
        <!--
          <Context path="" docBase="ROOT" debug="0"/>
        -->
 
This is the structure of the table PERSONAL:
 
SVRMGR> desc personal
Column Name                    Null?    Type
------------------------------ -------- ----
RFC                            NOT NULL VARCHAR2(12)
NOMBRE                         NOT NULL VARCHAR2(30)
APE_PAT                                 VARCHAR2(30)
APE_MAT                                 VARCHAR2(30)
Finally, you must request this little servlet in your internet navigator keyin the line:
 
 
See you.
----- Original Message -----
From: mike dizon
Sent: Saturday, December 15, 2001 09:36
Subject: Tomcat 4.0

I'm having some trouble getting a connection to my oracle database in Tomcat. What do I enter into the server.xml to enable to connection?
 
 I tried this, with no luck:
 
      <Realm  className="org.apache.catalina.realm.JDBCRealm" debug="99"
             driverName="oracle.jdbc.driver.OracleDriver"
          connectionURL="jdbc:oracle:thin:@ntserver:1521:ORCL?user=scott;password=tiger"
              userTable="users" userNameCol="user_name" userCredCol="user_pass"
          userRoleTable="user_roles" roleNameCol="role_name" />

Reply via email to