Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
HomeAnnouncementsWhite Papers
Discussion GroupsFirst AidDatabasesJavaBeansGUIJava 3DVirtual MachineCORBASecurityToolsGeneral
Java DirectoryOpen Source ProjectsSample Book ChaptersUser GroupsWeb Resources
Related Topics
Databases.NETMore Topics ...

Java Forum / General / November 2007

Tip: Looking for answers? Try searching our database.

JNDI Database connection in webapp

Thread view: 
francan00@yahoo.com - 09 Nov 2007 01:00 GMT
I have JNDI working with my Oracle 9i database using my server.xml
file in my local Tomcat 4.1.27.   Now I need to put my webapp on the
server and I wont get access or be able to touch server.xml on the
server.

Please advise how I can do that?  I tried putting the <context> info I
had in server.xml into the webapp root and call it
[b]mywebappname.xml[/b] and that didnt work.  I also tried that with
creating a [b]context.xml[/b] and that didnt work.  Both gave me back
error message: [b]Cannot create JDBC driver of class '' for connect
URL 'null' [/b].

Is this something that can be done in Tomcat 4.1.27??

server.xml(C:\jakarta-tomcat-4.1.27\conf)

<Context path="/DBTest" docBase="DBTest"
       debug="5" reloadable="true" crossContext="true">

 <Logger className="org.apache.catalina.logger.FileLogger"
            prefix="localhost_DBTest_log." suffix=".txt"
            timestamp="true"/>

 <Resource name="jdbc/TestDB"
              auth="Container"
              type="javax.sql.DataSource"/>

<Resource name="jdbc/myoracle" auth="Container"
             type="javax.sql.DataSource"/>

<ResourceParams name="jdbc/myoracle">
 <parameter>
   <name>factory</name>
   <value>org.apache.commons.dbcp.BasicDataSourceFactory</value>
 </parameter>
 <parameter>
   <name>driverClassName</name>
   <value>oracle.jdbc.OracleDriver</value>
 </parameter>
 <parameter>
   <name>url</name>
   <value>jdbc:oracle:thin:@127.0.0.1:1521:mysid</value>
 </parameter>
 <parameter>
   <name>username</name>
   <value>scott</value>
 </parameter>
 <parameter>
   <name>password</name>
   <value>tiger</value>
 </parameter>
 <parameter>
   <name>maxActive</name>
   <value>20</value>
 </parameter>
 <parameter>
   <name>maxIdle</name>
   <value>10</value>
 </parameter>
 <parameter>
   <name>maxWait</name>
   <value>-1</value>
 </parameter>
</ResourceParams>
</Context>

web.xml:
<resource-ref>
<description>Oracle Datasource example</description>
<res-ref-name>jdbc/myoracle</res-ref-name>
<res-type>javax.sql.DataSource</res-type>
<res-auth>Container</res-auth>
</resource-ref>[/PHP]

database connection part:
Context initContext = new InitialContext();
Context envContext  = (Context)initContext.lookup("java:/comp/env");
DataSource ds = (DataSource)envContext.lookup("jdbc/myoracle");
Connection conn = ds.getConnection();
//etc.
lyallex - 09 Nov 2007 09:28 GMT
> I have JNDI working with my Oracle 9i database using my server.xml
> file in my local Tomcat 4.1.27.   Now I need to put my webapp on the
> server and I wont get access or be able to touch server.xml on the
> server.
...

You'll probably do better on the Tomcat mailing list

Have a look here

http://tomcat.apache.org/lists.html#tomcat-users


Free Magazines

Get these publications absolutely FREE for up to 12 months. There are no hidden fees and no obligation. Simply choose a title, complete the application form and submit it. Read more ...

Oracle MagazineNetwork ComputingComputer WorldBio-IT WorldeWeekInformation WeekInfosecurity
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2009 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.