RE: Problems looking up JNDI Resource

[pkrishnaswami]

Could you tell me in which section this is supposed to go; I modified the
server.xml so that this section goes right after the section
</GlobalNamingResources>. The server came up alright but still ran into the
same problem.

Prabhakar

-----Original Message-----
From: Iran Marcius [mailto:iran@;isic.com.br]
Sent: Wednesday, November 06, 2002 12:37 PM
To: 'Tomcat Users List'; [EMAIL PROTECTED]
Subject: RES: Problems looking up JNDI Resource


Try

<Context...>
        <ResourceLink name="jdbc/Questions" global="jdbc/Questions"
type="javax.sql.DataSource"/>
</Context>


Iran

-----Mensagem original-----
De: pkrishnaswami [mailto:pkrishna@;learnframe.com]
Enviada em: quarta-feira, 6 de novembro de 2002 17:12
Para: 'Tomcat Users List'
Assunto: RE: Problems looking up JNDI Resource


I have configured the server.xml so that I can do a JNDI look up of the
Database. This is the section of server.xml which configures my database
as
a <GlobalNamingResources>.

  <GlobalNamingResources>
    <Environment name="simpleValue" override="true"
type="java.lang.Integer"
value="30"/>
    <Resource name="jdbc/Questions" scope="Shareable"
type="javax.sql.DataSource"/>
    <Resource name="UserDatabase" scope="Shareable"
type="org.apache.catalina.UserDatabase" auth="Container"
description="User
database that can be updated and saved"/>
    <ResourceParams name="jdbc/Questions">
      <parameter>
        <name>validationQuery</name>
        <value></value>
      </parameter>
      <parameter>
        <name>maxWait</name>
        <value>5000</value>
      </parameter>
      <parameter>
        <name>maxActive</name>
        <value>4</value>
      </parameter>
      <parameter>
        <name>password</name>
        <value></value>
      </parameter>
      <parameter>
        <name>url</name>
        <value>jdbc:weblogic:mssqlserver4:Questions@localhost</value>
      </parameter>
      <parameter>
        <name>driverClassName</name>
        <value>weblogic.jdbc.mssqlserver4.Driver</value>
      </parameter>
      <parameter>
        <name>maxIdle</name>
        <value>2</value>
      </parameter>
      <parameter>
        <name>username</name>
        <value>sa</value>
      </parameter>
    </ResourceParams>
    <ResourceParams name="UserDatabase">
      <parameter>
        <name>factory</name>

<value>org.apache.catalina.users.MemoryUserDatabaseFactory</value>
      </parameter>
      <parameter>
        <name>pathname</name>
        <value>conf/tomcat-users.xml</value>
      </parameter>
    </ResourceParams>
  </GlobalNamingResources>

When my application tries to a getConnection() on the DataSource, the
driverClassName does not seem to be initialized and I am getting an
exception. I understand I have to also configure an element resourceLink
which should be part of the Context element. Could somebody tell me how
the
resourceLink for the above database should be configured?



--
To unsubscribe, e-mail:
<mailto:tomcat-user-unsubscribe@;jakarta.apache.org>
For additional commands, e-mail:
<mailto:tomcat-user-help@;jakarta.apache.org>




--
To unsubscribe, e-mail:
<mailto:tomcat-user-unsubscribe@;jakarta.apache.org>
For additional commands, e-mail:
<mailto:tomcat-user-help@;jakarta.apache.org>



--
To unsubscribe, e-mail:   <mailto:tomcat-user-unsubscribe@;jakarta.apache.org>
For additional commands, e-mail: <mailto:tomcat-user-help@;jakarta.apache.org>