users@glassfish.java.net

Re: And yet another Websphere 5.x to Glassfish App Conversion - JDBC naming

From: <glassfish_at_javadesktop.org>
Date: Thu, 13 Nov 2008 12:30:52 PST

Another tickler - in the past, on a different project, using Tomcat, I know I had a "context.xml" file that defined my database JDBC information and identified the name. It was something like this:<BR>[code]
<Context path="<application path>"
        <Resource name="jdbc/{DSN}" auth="Container"
                type="javax.sql.DataSource"
                username="{username}"
                password="{password}"
                driverClassName="com.microsoft.jdbc.sqlserver.SQLServerDriver"
                url="jdbc:microsoft:sqlserver://{DSNServerName}:1433"
                maxActive="8"
                maxIdle="4" />
</Context>[/code]<BR><BR>
AND, there would be an entry in the web.xml file identifying the resource having a <resource-ref> tag, something like this:<BR>[code]
        <resource-ref>
                <res-ref-name>jdbc/{DSN}</res-ref-name>
                <res-type>javax.sql.DataSource</res-type>
                <res-auth>Container</res-auth>
        </resource-ref>[/code]<BR><BR>
BUT, I don't see anyhting like this in any of the Glassfish samples I've looked at.<BR><BR>So, again, how do I establish a datasource reference (keeping in mind my code already shown earlier) so that a JNDI lookup would retrieve it?<BR><BR>da Lizard
[Message sent by forum member 'loungelizard' (loungelizard)]

http://forums.java.net/jive/thread.jspa?messageID=316651