I don't know. It's there because when I looked in the JNDI DataSource How-to, it was there. Originally, I had the database Resource (not the Realm) in the <GlobalResources> (which didn't work either; I then had a ResourceLink in the Context). I moved the Resource to the Context in an attempt to figure out why it wasn't working. As I mentioned in a previous post, this is the first time I've tried to use JNDI and I suspect I've got some minor detail wrong.
I'm beginning to be suspicious that somehow the context isn't really getting tied to the webapp directory. I did move the webapps directory (per Moczar) and maybe I've screwed that up. Is there someway to get Tomcat to give more error details about missing stuff? Do I need to configure log4j and check the debug/info stuff as well as errors? Suggestions? -----Original Message----- From: Arshad Mahmood [mailto:[EMAIL PROTECTED] Sent: Friday, April 14, 2006 6:37 PM To: users@tomcat.apache.org Subject: FW: Tomcat 5.5.16 configuration problem--THIRD RESEND Hi, Do you really need that resource-ref in the web.xml. Your resource is defined under Context so you shouldn't need one. Other than that Your code looks fine and I can't see any problems with it. Regards. On 4/14/06, Filip Hanik - Dev Lists <[EMAIL PROTECTED]> wrote: > > check your log files upon startup, your myapp.xml doesn't have a docBase > attribute to associate it with the app itself. > <Context docBase="${catalina.home}/server/webapps/myapp" > path="/myapp">..... > > Scott Smith wrote: > > Sorry, I sent this so many times. Hopefully, I have all of the typos > > out of it this time... > > > > > > > > I have specified the following as myapp.xml in the > > conf\Catalina\locahost directory: > > > > > > > > <Context path="/myapp"> > > > > > > > > <Resource name="jdbc/MyDB" auth="Container" > > > > type="javax.sql.DataSource" > > > > username="user" password="pswd" > > > > > > driverClassName="net.sourceforge.jtds.jdbc.Driver" > > > > > > url="jdbc:jtds:sqlserver://127.0.0.1:1433;DatabaseName=MyDB;SelectMethod > > =cursor" > > > > maxActive="30" maxIdle="20" minIdle="10" > > maxWait="20000" /> > > > > <Realm className="org.apache.catalina.realm.DataSourceRealm" > > debug="99" > > > > dataSourceName="jdbc/MyDB" > > > > userTable="zUsers" userNameCol="zUserName" > > userCredCol="zPassword" > > > > userRoleTable="wsViewRoles" roleNameCol="zRole" > > /> > > > > </Context> > > > > > > > > In my web.xml file I have: > > > > > > > > <resource-ref> > > > > <res-ref-name>jdbc/MyDB</res-ref-name> > > > > <res-type>javax.sql.DataSource</res-type> > > > > <res-auth>Container</res-auth> > > > > </resource-ref> > > > > > > > > But, when I execute the code > > > > > > > > DataSource ds = null; > > > > try > > > > { > > > > Context initCtx = new InitialContext(); > > > > Context envCtx = (Context) > > initCtx.lookup("java:comp/env"); > > > > ds = (DataSource) envCtx.lookup("jdbc/MyDB"); > > > > } > > > > catch (NamingException e) > > > > { > > > > _log.error("Unable to retrieve MyDB DataSource", > > e); > > > > ds = null; > > > > } > > > > > > > > The exception is caught and I get an error message which says > > "javax.naming.NamingException: Name is not bound to a Context". I > > verified that the name in the <Resource>, <resource-ref> and the > > context lookup are the same. > > > > > > > > I suspect I understand the message. I just don't know what I've done > > wrong. Any suggestions? > > > > > > > > Scott > > > > > > > > > > > > > > > > > > > > > --------------------------------------------------------------------- > 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] --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]