Skip to main content

[ GlassFish 4 ] How to create a connection pool for MS SQL Server?

Please note these forums are being decommissioned and use the new and improved forums at
No replies
Joined: 2014-07-15


in JDeveloper I developed a Web ADF application and I would like to deploy it to GlassFish 4, on a server different from the development-PC.

On the development-PC the application uses a database connection configured in the IDE, this connection uses the C:\Program Files\Microsoft JDBC Driver 4.0 for SQL Server\sqljdbc_4.0\sqljdbc4.jar library.

Could you kindly tell me which are the values to insert in the fields when in GlassFish I create the connection pool?

Have I to copy (in which folder?) sqljdbc4.jar also on the server where GlassFish resides?

In GlassFish, after having created the connection pool I will have to create the JDBC resource. How have I to do to make my application to use this JDBC resource? As I said above the application uses a connection configured in the IDE...