[ GlassFish 4 ] How to create a connection pool for MS SQL Server?
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...