# Payara Server Pool de Conexiones MySQL Fuente {% embed url="" %} Isntalar Payara Server Bajarlo desde {% embed url="" %} Obtenemos un archivo .zip ![](https://1214129823-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-Lc1Wg6KboeH6fWlkEGS%2F-MkdzdA6CKLYUplq1JqL%2F-Mke-A2-6O4KcEOwlyS1%2Fzz.png?alt=media\&token=98bede5e-8304-4c90-893b-1a7adbfe0afc) descomprimir el archivo ![](https://1214129823-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-Lc1Wg6KboeH6fWlkEGS%2F-MkdzdA6CKLYUplq1JqL%2F-Mke-RNsEx3xM0zBh8bG%2Fsd.png?alt=media\&token=e64b7fee-c6c4-480e-9f10-30a1e21cfa0a) dentro de el tenemos la carpeta ![](https://1214129823-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-Lc1Wg6KboeH6fWlkEGS%2F-MkdzdA6CKLYUplq1JqL%2F-Mke-afDjvYJdolaNHbt%2Fpayara4.png?alt=media\&token=fd7cad46-c45d-4c36-82d1-875c05c8089b) la movemos a un directorio superior ![](https://1214129823-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-Lc1Wg6KboeH6fWlkEGS%2F-MkdzdA6CKLYUplq1JqL%2F-Mke-mdxtFTlPLhmGL70%2Fad.png?alt=media\&token=759f4329-3467-48f8-aead-713a294da757) ## Agregar Payara a NetBeans **Ingresar al directorio bin** ``` cd payara5/glassfish/bin/ ``` Ingresar a NetBeans en la seccion Server dar clic derecho y seleccionar Add Server ![](https://1214129823-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-Lc1Wg6KboeH6fWlkEGS%2F-Mke0dxgF8jxfr_FRcd2%2F-Mke1-8p9OZ4vtMfrwea%2Fadd.png?alt=media\&token=318de9df-1c1d-429d-a3c2-02da323ffb39) seleccionar Payara Server ![](https://1214129823-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-Lc1Wg6KboeH6fWlkEGS%2F-Mke0dxgF8jxfr_FRcd2%2F-Mke1BfrmPLXvfcH4soy%2Fsd.png?alt=media\&token=f95d689e-40ea-437b-b0e4-143ae9b1d75c) buscamos la ruta de instalación ![](https://1214129823-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-Lc1Wg6KboeH6fWlkEGS%2F-Mke0dxgF8jxfr_FRcd2%2F-Mke1MaBf-c_RqVi7B-h%2Fasd.png?alt=media\&token=5acbf984-cb66-4fdb-9d61-2d99a2c4660c) luego indicamos el dominio y user y password si lo hemos configurado ![](https://1214129823-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-Lc1Wg6KboeH6fWlkEGS%2F-Mke0dxgF8jxfr_FRcd2%2F-Mke1c7_lxNtZwosAobK%2Fda.png?alt=media\&token=9e634c22-6ee6-49c0-b533-3b366ea2b8a8) al finalizar nos queda agregado al proyecto ![](https://1214129823-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-Lc1Wg6KboeH6fWlkEGS%2F-Mke1j4NiifW6EjivDcG%2F-Mke2gzEf9mBYsz933j0%2Fads.png?alt=media\&token=20b6b71e-aba8-4b3a-9cc3-392f7700e5a8) ## **Crear el pool de conexiones** **Ingresar al directorio bin** ``` cd payara5/glassfish/bin/ ``` Iniciar Payara ``` ./asadmin start-domain domain1 ``` Descargar el driver jdbc de mysql y copiarlo en la carpeta de su elección. ![](https://1214129823-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-Lc1Wg6KboeH6fWlkEGS%2Fuploads%2FsJRVZXun3osp8SPUzZlY%2Fd.png?alt=media\&token=90f09f40-ad04-4db2-b008-6e08ff619777) Ejecutar ```shell-session ./asadmin add-library /home/avbravo/software/java/mysql-connector-java-8.0.26.jar ``` Si exitoso el driver se muestra en /payara5/glassfish/domains/domain1/lib ![](https://1214129823-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-Lc1Wg6KboeH6fWlkEGS%2Fuploads%2FDO7HjJazktLDkGuBcMsI%2Fd.png?alt=media\&token=8d30cd84-7017-4668-84b8-6ebb82d382ee) Detener Payara ``` ./asadmin stop-domain domain1 ``` Iniciar Payara ``` ./asadmin start-domain domain1 ``` Crear el pool de conexiones manual No recomendado (desde consola para mysql 5.7) No utilice esta opción es solo un ejemplo ``` ./asadmin create-jdbc-connection-pool --datasourceclassname com.mysql.jdbc.jdbc2.optional.MysqlDataSource --restype javax.sql.DataSource --property user=avbravo:password=denver16:DatabaseName=rigemdb:ServerName=localhost:port=3306 rigemdbpool ``` **Creación de Pool de Conexion desde Interface Web** Entrar desde el browser http;//localhost:4848 Ingresar a Resources-->JDBC --> JDBC Connections Pools ![](https://1214129823-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-Lc1Wg6KboeH6fWlkEGS%2Fuploads%2FbrJIjXfqLQZYtOO6FJAF%2Ff.png?alt=media\&token=73dbd2da-a9de-4944-8728-d6548aeee8c1) dar clic en nuevo | | | | | ----------------------- | -------------------- | - | | Pool Name | rigemdbPool | | | Resource Type: | javax.sql.Datasource | | | Database Driver Vendor: | MySql8 | | ![](https://1214129823-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-Lc1Wg6KboeH6fWlkEGS%2Fuploads%2FTtGjSXoUTPHn7Ame8WmR%2Fdd.png?alt=media\&token=8cb4c865-8529-478e-9d9f-5e773643ea56) dar clic en Next y en la siguiente pantalla eliminar todas las propiedades ![](https://1214129823-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-Lc1Wg6KboeH6fWlkEGS%2Fuploads%2FpzLjoTsCVp5NLtNSWIxl%2Fd.png?alt=media\&token=821e61cd-3142-4de5-bb94-b8a6b31a65d1) Agregar las Propiedades | | | | | ------------ | ---------- | - | | ServerName | localhost | | | PortNumber | 3306 | | | User | avbravo | | | Password | mypassword | | | DatabaseName | rigemdb | | | UseSSL | false | | ![](https://1214129823-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-Lc1Wg6KboeH6fWlkEGS%2Fuploads%2F89IMZvSJhTHlKFxOQPGp%2Fimage.png?alt=media\&token=c5a408af-83fc-4ca9-8349-440070e23fce) Dar clic en Finalizar Guardar los cambios y dar clic en Ping para asegurarnos que funciona correctamente ![](https://1214129823-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-Lc1Wg6KboeH6fWlkEGS%2Fuploads%2F89m76xYv12TQx4dQoRZb%2Fsd.png?alt=media\&token=d98377dc-eec4-4573-8b22-4f8bef60ea51) ![](https://1214129823-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-Lc1Wg6KboeH6fWlkEGS%2Fuploads%2FNcL6ehksAZrWbEqFQK47%2Fping.png?alt=media\&token=2a5e99ca-f129-459d-905c-8ceceb79c6be) Ahora crear el jndi Ingresar Resources --> JDBC --> JDBC Resources ![](https://1214129823-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-Lc1Wg6KboeH6fWlkEGS%2F-Mk-woI14P-gK5cu4gRN%2F-Mk-x95GkjXwnSxCRH34%2Fadd.png?alt=media\&token=2f7fd1db-346b-4adb-a7f1-0d86bf8bbe94) dar clic en New\.. en jndi indicar: jdbc/rigemdb y en Pool Name: rigemdbPool ![](https://1214129823-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-Lc1Wg6KboeH6fWlkEGS%2F-Mk-woI14P-gK5cu4gRN%2F-Mk-xVUlMNCr3Md_3BDS%2Fjdn.png?alt=media\&token=c29d895b-a9a2-4de7-8e9b-547a4c6bdd4e) y ![](https://1214129823-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-Lc1Wg6HsWAzyOSRs0Cb%2Fuploads%2FmvwoSKnrVq0W6ietUfyl%2Fimage%20\(1\).png?alt=media\&token=a970d409-43da-42bf-9cd8-848d56c2ec12)