The context.xml file is under your WebRoot/META-INF directory. When you application is deployed it gets copied to the conf/Catalina/[host name]/ directory then renamed to be the same as your web application. (Which BTW, if it is NOT being copied could also be part of the problem). 5.0.27 has a problem on Windows doing the copy so you have to do it manually, I believe it has been fixed in 5.0.28.
Keith -----Original Message----- From: muhammed soyer [mailto:[EMAIL PROTECTED] Sent: Monday, September 06, 2004 5:58 AM To: Tomcat Users List Subject: Re: Using JDBC Data source from a business class Hello Where is this context.xml file .should I create a file in web-inf directory named context.xml . I put a ResourceLink line in my webapp.xml files which is at "jakarta-tomcat-5.0.28/conf/Catalina/localhost" -ms ----- Original Message ----- From: "Keith Bottner" <[EMAIL PROTECTED]> To: "'Tomcat Users List'" <[EMAIL PROTECTED]> Sent: Monday, September 06, 2004 1:48 PM Subject: RE: Using JDBC Data source from a business class I believe you also need an entry in your web.xml file that looks something like this (obviously changed for your DB settings). <resource-ref> <description>postgreSQL Datasource</description> <res-ref-name>jdbc/postgres</res-ref-name> <res-type>javax.sql.DataSource</res-type> <res-auth>Container</res-auth> </resource-ref> You also need the ResourceLink entry in your context.xml <ResourceLink name="jdbc/database" global="jdbc/postgres" type="javax.sql.DataSource" /> I use JNDI to retrieve the DB connection with private static final String JNDI_CONTEXT = "java:comp/env"; private static final String DATASOURCE_DB_NAME = "jdbc/database"; try { Context initCtx = new InitialContext(); Context envCtx = (Context) initCtx.lookup(JNDI_CONTEXT); datasource = (DataSource) envCtx.lookup(DATASOURCE_DB_NAME); } catch ( NamingException e ) { if ( log.isEnabledFor(Level.ERROR) ) log.error(sm.getString("DAO.creation"), e); } Hope that helps. Keith -----Original Message----- From: muhammed soyer [mailto:[EMAIL PROTECTED] Sent: Monday, September 06, 2004 5:06 AM To: Peng Tuck Kwok; Tomcat Users List Subject: Re: Using JDBC Data source from a business class For my web applications(servlets) I add the following lines in the webapp.xml .For my classes what should I do ..These classes is not directly called from the browser .My JSP files use them .. <ResourceLink name="jdbc/gp" type="javax.sql.DataSource" global="jdbc/gp"/> <Resource type="javax.sql.DataSource" description="Oracle Datasource example" auth="Container" name="jdbc/gp"/> -ms ----- Original Message ----- From: "Peng Tuck Kwok" <[EMAIL PROTECTED]> To: "muhammed soyer" <[EMAIL PROTECTED]> Sent: Monday, September 06, 2004 12:11 PM Subject: Re: Using JDBC Data source from a business class You should be able to access the datasource from your classes. You said earlier you had problems doing so, could you describe the problems ? On Mon, 6 Sep 2004 11:31:04 +0300, muhammed soyer <[EMAIL PROTECTED]> wrote: > Yes they are in my web-inf/classes directory .I use them to do my db > jobs ..from jsp pages .. these classes access db .so I want to make > them use Tomcats conneciton pooling machanism . I can do this from > servlets .. > > -ms > > ----- Original Message ----- > From: "Peng Tuck Kwok" <[EMAIL PROTECTED]> > To: "Tomcat Users List" <[EMAIL PROTECTED]> > Sent: Monday, September 06, 2004 10:44 AM > Subject: Re: Using JDBC Data source from a business class > > On Mon, 6 Sep 2004 09:12:51 +0300, muhammed soyer > <[EMAIL PROTECTED]> > wrote: > > > My servlets are using the ds without a problem ..But I have some > > classes > which are >POJO classes to make my job easier whie accessing the DB ..these > classes couldnt use > my JDBC definition ..As I guess its from context > problems ..But I couldnt solve the >problem > > What's the exact problem? You don't exactly say where your POJO > classes are, so I assume they are in your webapp right, then it should > be ok. > > > > > What should I do to use tomcat's ds from a POJO class ? > > > > thnx > > > > -ms > > > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > > << Bu mail GESNET sunucusu tarafindan virus kontrolunden > gecirilmistir.>> > > << Bu mail GESNET sunucusu tarafindan virus kontrolunden gecirilmistir.>> --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] << Bu mail GESNET sunucusu tarafindan virus kontrolunden gecirilmistir.>> --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
