Changes for page Glassfish Connection Pool for MySQL
on 2012/03/15 22:22
on 2012/03/15 21:23
Summary
-
Page properties (1 modified, 0 added, 0 removed)
Details
- Page properties
-
- Content
-
... ... @@ -6,18 +6,17 @@ 6 6 1. Extract the contents and locate mysql-connector-java-x.x.x-bin.jar (where x.x.x is the current version) 7 7 1. Copy this file to GLASSFISH_INSTALL_DIR/bin on my system this is: /home/ken/glassfish-3.1.2/glassfish/lib\\ 8 8 9 -== 10 -Configuration Starting in Netbeans 7.1.1 == 9 +== Configuration Starting in Netbeans 7.1.1 == 11 11 12 12 1. Click on the Services tab -> Servers -> Right click "GlassFish Server 3.1.2.1" and select "Start" (**NOTE**: If the server was already running when the mysql connector jar was moved into the lib folder, restart glassfish now) 13 13 1. Right click "GlassFish Server 3.1.2.1" and select "View Domain Admin Console"\\ 14 14 15 -== 16 -Glassfish domain console 17 - == 14 +== Glassfish domain console == 18 18 19 -Resources -> JDBC -> JDBC Connection Pools -> Click "New..." 20 -\\Enter the following values 16 +Resources -> JDBC -> JDBC Connection Pools -> Click "New..."\\ 17 + 18 + 19 +Enter the following values 21 21 **Pool Name** = Name for your pool (ie: Gallery) 22 22 **Resource Type** = javax.sql.ConnectionPoolDataSource 23 23 **Database Driver Vendor** = MySql ... ... @@ -36,8 +36,7 @@ 36 36 \\Under the General tab, test the connection with "Ping" if we see "Ping Succeeded" we are good so far, if not check values 37 37 we just entered.\\ 38 38 39 -=== Create a JNDI name for the connection pool 40 - === 38 +=== Create a JNDI name for the connection pool === 41 41 42 42 Resources -> JDBC -> JDBC Resources -> click "New..." 43 43 \\**JNDI Name** = (what you want to call the pool, ie: jdbc/gallery )