Here is my working solution to connect MySQL with SUN J2EE 1.4 application server. I used this one and it works in my machine. I am sure two things you may need to take into consideration.
1, the property , I just put the url into the property name and the value is the followings,
2, make sure you use the correct username and password.
Database classname: com.mysql.jdbc.jdbc2.optional.MysqlConnectionPoolDataSource
You can also use: com.mysql.jdbc.jdbc2.optional.MysqlDataSource
Hope this can help!
And ive added the property:
url = jdbc:mysql://localhost:3306/stocks?user=stocks&password=stocks