Re: Tomcat 4.0 (Oracle connection)

[mike dizon]

Nevermind, I figured it out. It was the strangest thing, all the documentation I've read on the internet lead me to believe I needed to edit the server.xml file. It turns out however that what I needed to do was rename the classes12.zip file -- which contained the drivers -- to classes.jar and it worked fine. Is this some kind of bug?   MD ----- Original Message ----- From: Luis Condado To: [EMAIL PROTECTED] Sent: Sunday, December 16, 2001 12:46 AM Subject: Re: Tomcat 4.0 (Oracle connection) 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:   http://localhost:8080/personal/getname   See you. ----- Original Message ----- From: mike dizon To: [EMAIL PROTECTED] 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" />