[b]My system version:[/b]
MacOSX 10.5.5 Intel
[b]
Glassfish V3 Prelude Bundle[/b] taken from :
https://glassfish.dev.java.net/downloads/v3-prelude.html
I have tried with all these below bundles available in this download site:
-- self-extracting installer (glassfish-v3-prelude-unix-ml.sh)
--Netbeans6.5 bundle
-- "Sun Glassfish Enterprise Server" (
http://www.sun.com/software/products/glassfishv3_prelude/get.jsp. i.e sges-v3-prelude-unix-ml.sh which you get here.)
All have the problem explained below.
[b]STEPS TO REPRODUCE:[/b]
(1) install GlassfishV3 prelude. (configured successfully, domain started fine)
(2) login to admin console.
(3) go to connection pool > new: give a name , choose javax.sql.DataSource , & then MySQL .
(4) click Next
Problem :
you will see the exception "java.lang.ClassNotFoundException: com.mysql.jdbc.jdbc2.optional.MysqlDataSource" in the server log file .
attachment : server log attached.
NEXT STEPS :
(5)downloaded the mysql-connector (3.1 or 5.1) & copy that jar file to the lib/ dir , under your Glassfish installation
(6)restart the server
(7)again try the same connection pool configuration as shown in step (3) above.
Problem:
you will see the HTTP 500 error on the admin console
attachment : see the snapshot attached of the admin console screen.
This is a[b] P1 issue[/b] as the above scenario of Connection pool configuration absolutely does not work on MacOSX.
[Message sent by forum member 'mangalalobo' (mangalalobo)]
http://forums.java.net/jive/thread.jspa?messageID=327499