setting up datasource in tomcat & glassfish appserv

Notes to setup mysql datasource in tomcat/sunappserv (for my cs9323 assignment):

1. copy mysql-connector-java-5.1.8-bin.jar to c:\\tomcat6\lib or c:\\sun\appserv\lib

2. Add the following section to c:\\tomcat6\conf\context.xml
<br /><Resource name="jdbc/mydb" auth="Container" type="javax.sql.DataSource" <br /> maxActive="100" maxIdle="30" maxWait="10000" <br /> username="root" password="pass" driverClassName="com.mysql.jdbc.Driver" <br /> url="jdbc:mysql://localhost:3306/mydb"/><br />
For glassfish, go to http://localhost:4848 and create a pool under 'Resource/Connection Pools' then create a jdbc resource called 'jdbc/mydb' in 'Resources/JDBC Resouces'. (you need to specific host,port, user, pass,db in the pool settings)

3. Under webcontent\META-INF, edit context.xml to include the following section:

<br /><Context><br /><Resource name="jdbc/mydb" auth="Container"<br />type="javax.sql.DataSource"<br />username="root" password="pass"<br />driverClassName="com.mysql.jdbc.Driver"<br />url="jdbc:mysql://localhost:3306/mydb"<br />maxActive="8" /><br /></Context><br />

Alternatively, this can be done via adding the following section into WEB-INF/web.xml:

<br /> <resource-ref><br /> <description>DB Connection</description><br /> <res-ref-name>jdbc/mydb</res-ref-name><br /> <res-type>javax.sql.DataSource</res-type><br /> <res-auth>Container</res-auth><br /> </resource-ref> <br />

4. for tomcat, use the following code to do the lookup:
<br /> Context initContext = new InitialContext();<br /> Context envContext = (Context)initContext.lookup("java:/comp/env");<br /> DataSource ds = (DataSource)envContext.lookup("jdbc/mydb");<br /> Connection conn = ds.getConnection();<br />

For glassfish:
<br /> InitialContext context = new InitialContext();<br /> DataSource ds= (DataSource) context.lookup("jdbc/mydb");<br /> Connection conn = ds.getConnection();<br />