Setting up container datasource w/ Maven

[Eric Pugh]

Hi all,

I have an application where I configured the javax.sql.DataSource in my
server.xml or in a /webapps/myapp.xml context file, and referenced it from
my web.xml.  Pretty standard stuff.

Now, in cactus land using the Maven plugin and tomcat4x, I can't seem to get
things to properly load.  If I wanted to use a myapp.xml context file that
had the definition of the javax.sql.DataSource, where would I place that?
Could I roll everything into web.xml?

I tried pasting the parameters into the web.xml, but no go.  It seems like I
need either the context file or server.xml.  But I don't want to muck around
with server.xml cause I think it is better to use the default server.xml
from Cactus.  So, does the myapp.xml context file go in the root tomcat
webapps dir or in where cactus is building everything to?

Thanks,
Eric

My params..

<Resource name="jdbc/portal" scope="Shareable" type="javax.sql.DataSource"
/>
  <ResourceParams name="jdbc/portal">
      <parameter>
        <name>validationQuery</name>
        <value>SELECT 1</value>
      </parameter>
      <parameter>
        <name>url</name>

<value>jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=eFrontOffice;S
electMethod=cursor</value>
      </parameter>
      <parameter>
        <name>password</name>
        <value>somepassword</value>
      </parameter>
      <parameter>
        <name>maxActive</name>
        <value>4</value>
      </parameter>
      <parameter>
        <name>maxWait</name>
        <value>5000</value>
      </parameter>
      <parameter>
        <name>driverClassName</name>
        <value>com.microsoft.jdbc.sqlserver.SQLServerDriver</value>
      </parameter>
      <parameter>
        <name>username</name>
        <value>someuser</value>
      </parameter>
      <parameter>
        <name>maxIdle</name>
        <value>2</value>
      </parameter>
    </ResourceParams>


---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]