{"id":898,"date":"2016-09-15T06:00:57","date_gmt":"2016-09-15T09:00:57","guid":{"rendered":"https:\/\/www.erudio.com.br\/blog\/?p=898"},"modified":"2022-12-21T13:44:00","modified_gmt":"2022-12-21T16:44:00","slug":"configurando-uma-conexao-mysql-no-jboss-com-mysql-connector-jdbc-driver","status":"publish","type":"post","link":"https:\/\/www.erudio.com.br\/blog\/configurando-uma-conexao-mysql-no-jboss-com-mysql-connector-jdbc-driver\/","title":{"rendered":"Configurando uma Conex\u00e3o MySQL no JBoss com MySQL Connector JDBC Driver"},"content":{"rendered":"

 <\/p>\n

Em um posts anterior aprendemos como criar uma conex\u00e3o via JBoss<\/strong> e um banco MSQL Server<\/strong> usando o JTDS Driver<\/strong> e Microsoft JDBC Driver<\/strong>. Neste post falaremos do MySQL Connector JDBC Driver<\/strong>. Para configurar ele no JBoss<\/strong> seguiremos alguns passos similares aos outros posts:<\/p>\n

 <\/p>\n

1. Baixe o driver no site do MySQL<\/strong><\/a>.<\/p>\n

 <\/p>\n

2. Extraia o arquivo recem baixado e localize o arquivo mysql-connector-java-5.1.38-bin.jar<\/strong>.<\/p>\n

 <\/p>\n

3. No seu JBOSS_HOME<\/strong> crie diret\u00f3rios respeitando a seguinte hierarquia “modules\\com\\mysql\\main”<\/strong>. Dentro desse diret\u00f3rio coloque o arquivo rec\u00e9m baixado mysql-connector-java-5.1.38-bin.jar<\/strong> e crie um novo arquivo chamado module.xml<\/strong> com o seguinte conte\u00fado:<\/p>\n

 <\/p>\n

\n<!--?xml version="1.0" encoding="UTF-8"?-->\n<module xmlns="urn:jboss:module:1.1" name="com.mysql">\n  <resources>\n    <resource-root path="mysql-connector-java-5.1.38-bin.jar">\n  <\/resource-root><\/resources>\n  <dependencies>\n    <module name="javax.api">\n    <module name="javax.transaction.api">\n  <\/module><\/module><\/dependencies>\n<\/module>\n<\/pre>\n
 <\/p>\n
3. Agora precisamos modificar nosso standalone.xml<\/strong> adicionando as configura\u00e7\u00f5es abaixo \u00e0 se\u00e7\u00e3o de datasources<\/strong>. Diferente dos posts anteriores adicionei novas configura\u00e7\u00f5es para que voc\u00ea saiba que pode definir novos par\u00e2metros al\u00e9m do b\u00e1sico. No geral podemos definir par\u00e2metros para o pool de conex\u00f5es, valida\u00e7\u00f5es, cache dentre outros. Essas configura\u00e7\u00f5es s\u00e3o padr\u00e3o e com exce\u00e7\u00e3o das configura\u00e7\u00f5es de valida\u00e7\u00e3o se aplicam \u00e0 maioria dos bancos de dados.<\/p>\n
 <\/p>\n
\n<datasource jndi-name="java:jboss\/datasources\/SeuDatabase" pool-name="SeuDatabase" enabled="true" use-java-context="true" use-ccm="true">\n   <connection-url>jdbc:mysql:\/\/localhost:3306\/SeuDatabase<\/connection-url>\n   <driver>mysql<\/driver>\n   <transaction-isolation>TRANSACTION_READ_COMMITTED<\/transaction-isolation>\n\n   <!-- Configura\u00e7\u00e3o opcional pra definir os par\u00e2metros do pool de conex\u00f5es -->\n   <pool>\n      <min-pool-size>10<\/min-pool-size>\n      <max-pool-size>100<\/max-pool-size>\n      <prefill>true<\/prefill>\n   <\/pool>\n   <security>\n      <user-name>seu_usuario<\/user-name>\n      <password>sua_senha<\/password>\n   <\/security>\n\n   <!-- Configura\u00e7\u00e3o opcional para valida\u00e7\u00e3o de conex\u00f5es e tratamento de exceptions -->\n   <validation>\n      <valid-connection-checker class-name="org.jboss.jca.adapters.jdbc.extensions.mysql.MySQLValidConnectionChecker">\n      <exception-sorter class-name="org.jboss.jca.adapters.jdbc.extensions.mysql.MySQLExceptionSorter">\n   <\/exception-sorter><\/valid-connection-checker><\/validation>\n\n   <!-- Configura\u00e7\u00e3o opcional com os par\u00e2metros de de cache -->\n   <statement>\n      <prepared-statement-cache-size>100<\/prepared-statement-cache-size>\n      <share-prepared-statements>true<\/share-prepared-statements>\n   <\/statement>\n<\/datasource>\n<\/pre>\n
 <\/p>\n
E na se\u00e7\u00e3o drivers<\/strong>:<\/p>\n
 <\/p>\n
\n<driver name="mysql" module="com.mysql">\n   <datasource-class>com.mysql.jdbc.jdbc2.optional.MysqlDataSource<\/datasource-class>\n<\/driver>\n<\/pre>\n
 <\/p>\n
O resultado final deve ser similar a configura\u00e7\u00e3o abaixo:<\/p>\n
 <\/p>\n
\n<subsystem xmlns="urn:jboss:domain:datasources:1.1">\n   <datasources>\n      <datasource jndi-name="java:jboss\/datasources\/SeuDatabase" pool-name="SeuDatabase" enabled="true" use-java-context="true" use-ccm="true">\n         <connection-url>jdbc:mysql:\/\/localhost:3306\/SeuDatabase<\/connection-url>\n         <driver>mysql<\/driver>\n         <transaction-isolation>TRANSACTION_READ_COMMITTED<\/transaction-isolation>\n\n         <!-- Configura\u00e7\u00e3o opcional pra definir os par\u00e2metros do pool de conex\u00f5es -->\n         <pool>\n            <min-pool-size>10<\/min-pool-size>\n            <max-pool-size>100<\/max-pool-size>\n            <prefill>true<\/prefill>\n         <\/pool>\n         <security>\n            <user-name>seu_usuario<\/user-name>\n            <password>sua_senha<\/password>\n         <\/security>\n\n         <!-- Configura\u00e7\u00e3o opcional para valida\u00e7\u00e3o de conex\u00f5es e tratamento de exceptions -->\n         <validation>\n            <valid-connection-checker class-name="org.jboss.jca.adapters.jdbc.extensions.mysql.MySQLValidConnectionChecker">\n            <exception-sorter class-name="org.jboss.jca.adapters.jdbc.extensions.mysql.MySQLExceptionSorter">\n         <\/exception-sorter><\/valid-connection-checker><\/validation>\n\n         <!-- Configura\u00e7\u00e3o opcional com os par\u00e2metros de de cache -->\n         <statement>\n            <prepared-statement-cache-size>100<\/prepared-statement-cache-size>\n            <share-prepared-statements>true<\/share-prepared-statements>\n         <\/statement>\n      <\/datasource>\n      <drivers>\n         <driver name="mysql" module="com.mysql">\n            <datasource-class>com.mysql.jdbc.jdbc2.optional.MysqlDataSource<\/datasource-class>\n         <\/driver>\n      <\/drivers>\n   <\/datasources>\n<\/subsystem>\n<\/pre>\n
 <\/p>\n
Complementando as postagens sobre os datasources MSQL Server<\/strong> dessa vez aprendemos a criar uma conex\u00e3o com uma base MySQL<\/strong> . Mais uma vez para solu\u00e7\u00f5es mais complexas use o Google e sua criatividade.<\/p>\n
 <\/p>\n
Treinamentos relacionados com este post<\/h2>\n
<\/p>\n

\n<\/a><\/p>\n
<\/p>\n

\n<\/a><\/p>\n

\n        
\n<\/a><\/p>\n

\n        
\n<\/a><\/p>\n

\n        
\n<\/a><\/p>\n

\n        
\n<\/a><\/p>\n

\n        
\n<\/a><\/p>\n

\n        
\n<\/a><\/p>\n

\n        
\n<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"
  Em um posts anterior aprendemos como criar uma conex\u00e3o via JBoss e um banco MSQL Server usando o JTDS Driver e Microsoft JDBC Driver. Neste post falaremos do MySQL Connector JDBC Driver. Para configurar ele no JBoss seguiremos alguns passos similares aos outros posts:   1. Baixe o driver no site do MySQL.   […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[25,46,47,68,69,70],"tags":[173,174,196,197],"_links":{"self":[{"href":"https:\/\/www.erudio.com.br\/blog\/wp-json\/wp\/v2\/posts\/898"}],"collection":[{"href":"https:\/\/www.erudio.com.br\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.erudio.com.br\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.erudio.com.br\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.erudio.com.br\/blog\/wp-json\/wp\/v2\/comments?post=898"}],"version-history":[{"count":3,"href":"https:\/\/www.erudio.com.br\/blog\/wp-json\/wp\/v2\/posts\/898\/revisions"}],"predecessor-version":[{"id":1539,"href":"https:\/\/www.erudio.com.br\/blog\/wp-json\/wp\/v2\/posts\/898\/revisions\/1539"}],"wp:attachment":[{"href":"https:\/\/www.erudio.com.br\/blog\/wp-json\/wp\/v2\/media?parent=898"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.erudio.com.br\/blog\/wp-json\/wp\/v2\/categories?post=898"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.erudio.com.br\/blog\/wp-json\/wp\/v2\/tags?post=898"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}