connection pool and DataSource in the sun app server for mysql+java

 /* String userName = "root";
            String password1 = "root";
            String url = "jdbc:mysql://localhost/employees";
            Class.forName("com.mysql.jdbc.Driver").newInstance();
            conn = DriverManager.getConnection(url, userName, password1);*/

First put the .jar in the domain/lib/ext folder
For DataSource put this:
com.mysql.jdbc.jdbc2.optional.MysqlDataSource
Next, populate:
user: yourUserName
password: yourPassword
serverName: localhost or whever server name you have
port: 3306
databaseName: databaseNameONLY (NOT the whole URL!!!), like testDB or something like that
datasourceName: MysqlDataSource

>I modified the web.xml add

                        <resource-ref>

                                    <description>Application DataSource Reference</description>

                                    <res-ref-name>jdbc/MySqlPool</res-ref-name>

                                      <res-type>javax.sql.DataSource</res-type>

                                     <res-auth>Container</res-auth>

                          </resource-ref>

>I modified the sun-web.xml

                          <resource-ref>

                                     <res-ref-name>jdbc/MySqlPool</res-ref-name>

                                      <jndi-name>jdbc/MySqlPool</jndi-name>

                         </resource-ref>

>The code in the program is

                        InitialContext ctx = new InitialContext();

                        DataSource ds = (DataSource)ctx.lookup("java:comp/env/jdbc/MySqlpool");

                        conn = ds.getConnection();

----------------------------------------------------------------------------

in the netbeans IDE we can configure the pool and jdni name for a application very convenient.

server reaources
new file
choose sun resources JDBC pool confingure it
new file
choose sun resources JDBC resource configure it