I put in in my application context :
<Context path="/test" docBase="test" debug="200"
reloadable="true">
<Logger className="org.apache.catalina.logger.FileLogger"
prefix="localhost_feedback." suffix=".log"
timestamp="true"/>
<Environment name="maxExemptions" type="java.lang.Integer"
value="16"/>
<Parameter name="context.param.name" value="context.param.value"
override="false"/>
<Resource name="jdbc/TestDb" auth="CONTAINER"
type="javax.sql.DataSource"/>
<ResourceParams name="jdbc/TestDb">
<parameter><name>user</name><value>fred</value></parameter>
<parameter><name>password</name><value>fred</value></parameter>
<parameter><name>driverClassName</name>
<value>org.gjt.mm.mysql.MysqlDataSource</value></parameter>
<parameter><name>driverName</name>
<value>jdbc:mysql://localhost:3306/test</value></parameter>
</ResourceParams>
<!-- JNDI Resource for sending email using SMTP -->
<Resource name="mail/send" auth="CONTAINER"
type="javax.mail.internet.MimePartDataSource"/>
<ResourceParams name="mail/send">
<parameter><name>factory</name>
<value>org.apache.naming.factory.SendMailFactory</value>
</parameter>
<parameter><name>mail.smtp.host</name>
<value>vers-mail.vers.eu.fciconnect.com</value>
</parameter>
<parameter><name>mail.smtp.user</name>
<value>fjacquet</value>
</parameter>
<parameter><name>mail.from</name>
<value>[EMAIL PROTECTED]</value>
</parameter>
</ResourceParams>
</Context>
-----Original Message-----
From: Frederic Monclar [mailto:[EMAIL PROTECTED]]
Sent: Friday, February 15, 2002 5:17 PM
To: Tomcat Users List; [EMAIL PROTECTED]
Subject: Re: Datasources context ?
May be you have defined at a wrong place your resource in your
server.xml file.
Fred.
> "Jacquet, Frederic" wrote:
>
> I have got this error
> Name java:comp is not bound in this Context
>
> When I try the following code :
> try {
> Context initCtx = new InitialContext();
> Context envCtx = (Context)
> initCtx.lookup("java:comp/env");
> DataSource ds = (DataSource) envCtx.lookup("jdbc/TestDb");
>
> Connection conn = ds.getConnection();
>
> Statement st = conn.createStatement();
> ResultSet rs = st.executeQuery("SELECT prenom,nom FROM
> annuaire;");
> while (rs.next()) {
> out.println("<p>" + rs.getString("prenom"));
> out.println(" " + rs.getString("nom"));
> }
>
> conn.close();
> } catch (Exception e) {
> out.print(e.getMessage());
> }
> And the declarations
> server.xml
> <Resource name="jdbc/TestDb" auth="CONTAINER"
> type="javax.sql.DataSource"/>
> <ResourceParams name="jdbc/TestDb">
>
> <parameter><name>user</name><value>user</value></parameter>
>
> <parameter><name>password</name><value>passwd</value></parameter>
> <parameter><name>driverClassName</name>
> <value>org.gjt.mm.mysql.Driver</value></parameter>
> <parameter><name>driverName</name>
> <value>jdbc:mysql://localhost/test</value></parameter>
> </ResourceParams>
> web.xml
> <resource-ref>
> <description>Test database.</description>
> <res-ref-name>jdbc/TestDb</res-ref-name>
> <res-type>javax.sql.DataSource</res-type>
> <res-auth>CONTAINER</res-auth>
> </resource-ref>
>
> What is wrong ???
>
> Regards / Cordialement
>
> Frederic Jacquet
>
> ---------------------------------------------------------------
> --
> To unsubscribe: <mailto:[EMAIL PROTECTED]>
> For additional commands: <mailto:[EMAIL PROTECTED]>
> Troubles with the list: <mailto:[EMAIL PROTECTED]>
--
To unsubscribe: <mailto:[EMAIL PROTECTED]>
For additional commands: <mailto:[EMAIL PROTECTED]>
Troubles with the list: <mailto:[EMAIL PROTECTED]>
-- To unsubscribe: <mailto:[EMAIL PROTECTED]> For additional commands: <mailto:[EMAIL PROTECTED]> Troubles with the list: <mailto:[EMAIL PROTECTED]>
