Context Param issue in sun-web.xml

I am using netbeans 6.9.1 with Glassfish 3 to create a web application consisting of a handful of servlets. I need to store a value in the config file for the database connection string.

From what I could find, this is done using the web.xm开发者_C百科l file (sun-web.xml being what is auto-generated):

<context-param>
<param-name>connectionString</param-name>
<param-value>connection string value in here</param-value>

and subsequently read in during servlet init() using

String conString = context.getInitParameter("connectionString");

However, when netbeans deploys the application I get the following error

SEVERE: DPL8007: Invalid Deployment Descriptors element param-name value connectionString SEVERE: DPL8007: Invalid Deployment Descriptors element param-value valu

Any idea what I am doing wrong here? Here is the full contents of the file:

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE sun-web-app PUBLIC "-//Sun Microsystems, Inc.//DTD GlassFish Application Server 3.0 Servlet 3.0//EN" "http://www.sun.com/software/appserver/dtds/sun-web-app_3_0-0.dtd">
<sun-web-app error-url="">
<context-param>
<param-name>connectionString</param-name>
<param-value>Con value</param-value>
 </context-param> 
<context-root>/FQEX</context-root>
<class-loader delegate="true"/>
<jsp-config>
<property name="keepgenerated" value="true">
<description>Keep a copy of the generated servlet class' java code.</description>
</property>
  </jsp-config>
</sun-web-app>

Thanks in advance.

---

I don't see <context-param> in the sun-web.xml DTD. So I guess you are not supposed to do this there. Place this in the regular web.xml, it will work there.

---

Here are two more options, you can include it in your sun-resources.xml, or you can do it through the GlassFish DAS console.

Netbeans lets you create the sun-resources.xml through a wizard. You select it from New File -> GlassFish -> JDBC Resource. This is what the file looks like:

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE resources PUBLIC "-//Sun Microsystems, Inc.//DTD Application Server 9.0 Resource Definitions //EN" "http://www.sun.com/software/appserver/dtds/sun-resources_1_3.dtd">
<resources>
<jdbc-resource enabled="true" jndi-name="jdbc/something" object-type="user" pool-name="something_pool">
<description/>
</jdbc-resource>
<jdbc-connection-pool allow-non-component-callers="false" associate-with-thread="false" connection-creation-retry-attempts="5" connection-creation-retry-interval-in-seconds="10" connection-leak-reclaim="false" connection-leak-timeout-in-seconds="0" connection-validation-method="table" validation-table-name="something_pool.sometable" datasource-classname="com.mysql.jdbc.jdbc2.optional.MysqlDataSource" fail-all-connections="false" idle-timeout-in-seconds="120" is-connection-validation-required="true" is-isolation-level-guaranteed="true" lazy-connection-association="false" lazy-connection-enlistment="false" match-connections="false" max-connection-usage-count="0" max-pool-size="100" max-wait-time-in-millis="60000" name="something_pool" non-transactional-connections="false" pool-resize-quantity="8" res-type="javax.sql.DataSource" statement-timeout-in-seconds="180" steady-pool-size="32" validate-atmost-once-period-in-seconds="5" wrap-jdbc-objects="false">
<property name="URL" value="jdbc:mysql://localhost:3306/something"/>
<property name="User" value="root"/>
<property name="Password" value="admin"/>
</jdbc-connection-pool>
</resources>