web.xml  Creating a database element using a JNDI data source resource

Chapter 1: Developer Features

server.xml

Here is the entry in server.xml for the portal database:

    <Resource name="jdbc/portaldb" auth="Container"         type="javax.sql.DataSource"/>
            <ResourceParams name="jdbc/portaldb">
                <parameter>
                    <name>driverClassName</name>
                    <value>com.sybase.jdbc2.jdbc.SybDriver</value>
                </parameter>
                <parameter>
                    <name>driverName</name>
                    <value>jdbc:sybase:Tds:localhost:4747?
                        ServiceName=portaldatabase</value>
                </parameter>
                <parameter>
                    <name>user</name>
                    <value>dba</value>
                </parameter>
                <parameter>
                    <name>password</name>
                    <value>SQL</value>
                </parameter>
                <parameter>
                    <name>maxActive</name>
                    <value>20</value>
                </parameter>
                <parameter>
                    <name>maxIdle</name>
                    <value>10</value>
                </parameter>
                <parameter>
                    <name>maxWait</name>
                    <value>20000</value>
                </parameter>
            </ResourceParams>

On Tomcat, server.xml is located in x:\infoedition\tomcat\conf\server.xml on Windows, where “x” is the drive where EP is installed. To create a new entry, see the instructions.





Copyright © 2004. Sybase Inc. All rights reserved. Creating a database element using a JNDI data source resource

View this book as PDF