Configurando o Datasource e Drives de Banco

antes de criar um datasource, é necessário adicionar um módulo de um banco de dados ao sistema cada banco tem seu próprio driver de conexão, mas as configurações de todos partem do mesmo princípio fazer o download do driver do fabricante, copiá lo para o wildfly, configurar no sistema as configurações serão feitas via jboss cli, mas todas elas podem ser feitas também via xml no arquivo standalone full xml caso deseje no exemplo abaixo usaremos o driver do postgresql cada banco de dados possui seu próprio método de configuração, recomendamos procurar na documentação do fabricante do banco de dados de sua escolha caso seja diferente de nossa documentação o download do driver jdbc do postgresql pode ser encontrado no endereço https //jdbc postgresql org https //jdbc postgresql org no link downloads a versão do driver utilizado pela citsmart é a 4 1 build 9 3 build 1104 \[root\@server /tmp]# wget https //jdbc postgresql org/download/postgresql 9 3 1104 jdbc41 jar acesse novamente o jboss cli para adicionar o driver com comando abaixo (considerando que você tenha feito o download para pasta /tmp ) \[standalone\@localhost 9990 /] module add name=org postgres resources=/tmp/postgresql 9 3 1104 jdbc41 jar dependencies=javax api,javax transaction api com esse comando, o driver será adicionado automaticamente a pasta /opt/wildfly 12 0 0 final/modules/org/postgres/main/ continue no cli e execute o comando abaixo para incluir um datasource \[standalone\@localhost 9990 /] /subsystem=datasources/jdbc driver=postgres\ add(driver name="postgres",driver module name="org postgres",driver xa datasource class name=org postgresql xa pgxadatasource criando o banco de dados do citsmart independente da arquitetura do banco (se instalado no nesmo servidor ou separado) os passos abaixo servem para se criar um banco de dados e um usuário para o citsmart no procedimento partimos do pressuposto que você tenha acesso ao sgbd acesse o postgresql com comando abaixo \[root\@server /tmp]# su postgres bash 4 2$ bash 4 2$ psql psql (9 6 15) type "help" for help postgres=# crie um usuário e senha para acesso ao banco do citsmart (substitua a sua senha com uma senha de preferência) postgres=# create user citsmartdbuser with password 'sua senha'; create role postgres=# crie um banco de dados para o citsmart postgres=# create database citsmart db with owner citsmartdbuser encoding 'utf8' tablespace pg default; create database postgres=# dê permissão para o usuário do citsmart postgres=# alter role citsmartdbuser superuser; alter role postgres=# saia do psql e do shell do usuário postgres postgres=# \q bash 4 2$ exit exit \[root\@server /tmp]# caso o banco esteja rodando no mesmo servidor, é necessário liberar a conexão para o usuário do citsmart edite o arquivo /var/lib/pgsql/9 6/data/pg hba conf e inclua a seguinte linha \# database administrative login by unix domain socket local all postgres ident perigo não altere a linha local all postgres peer que vem por padrão, inclua a linha acima logo abaixo desta se o banco de dados estiver rodando em outro servidor é necessário liberar a conexão a partir do wildfly para isso inclua a seguinte linha no mesmo arquivo pg hba conf, substituindo o pelo endereço de ip do servidor wildfly host citsmart db citsmartdbuser wildfly ip address/32 md5 configurando o datasource para o citsmart existem oito entradas de datasource para o citsmart db, sendo que quatro são para o citsmart e quatro para o citsmart neuro o usuário e senha é citsmartdbuser e sua senha criados no passo anterior caso tenha criado usuário, senha e banco de nomes diferentes, altere nos comandos abaixo conecte no jboss cli e execute os seguintes comandos datasource citsmart /subsystem=datasources/data source="/jdbc/citsmart"\ add(jndi name="java /jdbc/citsmart",driver name="postgres",connection url="jdbc\ postgresql //pgdata citsmart com 5432/citsmart db",user name="citsmartdbuser",password="exemplo123",driver class="org postgresql driver", enabled=true, use java context=true) /subsystem=datasources/data source="/jdbc/citsmart"\ write attribute(name=min pool size,value=10) /subsystem=datasources/data source="/jdbc/citsmart"\ write attribute(name=max pool size,value=300) /subsystem=datasources/data source="/jdbc/citsmart"\ write attribute(name=pool prefill,value=true) /subsystem=datasources/data source="/jdbc/citsmart"\ write attribute(name=flush strategy,value=failingconnectiononly) /subsystem=datasources/data source="/jdbc/citsmart"\ write attribute(name=blocking timeout wait millis,value=60000) /subsystem=datasources/data source="/jdbc/citsmart"\ write attribute(name=idle timeout minutes,value=5) datasource citsmartflow /subsystem=datasources/data source="/jdbc/citsmartfluxo"\ add(jndi name="java /jdbc/citsmartfluxo",driver name="postgres",connection url="jdbc\ postgresql //pgdata citsmart com 5432/citsmart db",user name="citsmartdbuser",password="exemplo123",driver class="org postgresql driver", enabled=true, use java context=true) /subsystem=datasources/data source="/jdbc/citsmartfluxo"\ write attribute(name=min pool size,value=10) /subsystem=datasources/data source="/jdbc/citsmartfluxo"\ write attribute(name=max pool size,value=300) /subsystem=datasources/data source="/jdbc/citsmartfluxo"\ write attribute(name=pool prefill,value=true) /subsystem=datasources/data source="/jdbc/citsmartfluxo"\ write attribute(name=flush strategy,value=failingconnectiononly) /subsystem=datasources/data source="/jdbc/citsmartfluxo"\ write attribute(name=blocking timeout wait millis,value=60000) /subsystem=datasources/data source="/jdbc/citsmartfluxo"\ write attribute(name=idle timeout minutes,value=5) datasourece citsmart reports /subsystem=datasources/data source="/jdbc/citsmart reports"\ add(jndi name="java /jdbc/citsmart reports",driver name="postgres",connection url="jdbc\ postgresql //pgdata citsmart com 5432/citsmart db",user name="citsmartdbuser",password="exemplo123",driver class="org postgresql driver", enabled=true, use java context=true) /subsystem=datasources/data source="/jdbc/citsmart reports"\ write attribute(name=min pool size,value=10) /subsystem=datasources/data source="/jdbc/citsmart reports"\ write attribute(name=max pool size,value=300) /subsystem=datasources/data source="/jdbc/citsmart reports"\ write attribute(name=pool prefill,value=true) /subsystem=datasources/data source="/jdbc/citsmart reports"\ write attribute(name=flush strategy,value=failingconnectiononly) /subsystem=datasources/data source="/jdbc/citsmart reports"\ write attribute(name=blocking timeout wait millis,value=60000) /subsystem=datasources/data source="/jdbc/citsmart reports"\ write attribute(name=idle timeout minutes,value=5) datasource citsmartbpmeventos /subsystem=datasources/data source="/jdbc/citsmartbpmeventos"\ add(jndi name="java /jdbc/citsmartbpmeventos",driver name="postgres",connection url="jdbc\ postgresql //pgdata citsmart com 5432/citsmart db",user name="citsmartdbuser",password="exemplo123",driver class="org postgresql driver", enabled=true, use java context=true) /subsystem=datasources/data source="/jdbc/citsmartbpmeventos"\ write attribute(name=min pool size,value=10) /subsystem=datasources/data source="/jdbc/citsmartbpmeventos"\ write attribute(name=max pool size,value=300) /subsystem=datasources/data source="/jdbc/citsmartbpmeventos"\ write attribute(name=pool prefill,value=true) /subsystem=datasources/data source="/jdbc/citsmartbpmeventos"\ write attribute(name=flush strategy,value=failingconnectiononly) /subsystem=datasources/data source="/jdbc/citsmartbpmeventos"\ write attribute(name=blocking timeout wait millis,value=60000) /subsystem=datasources/data source="/jdbc/citsmartbpmeventos"\ write attribute(name=idle timeout minutes,value=5 datasource citsmart neuro /subsystem=datasources/data source="/env/jdbc/citsmart neuro"\ add(jndi name="java /env/jdbc/citsmart neuro",driver name="postgres",connection url="jdbc\ postgresql //pgdata citsmart com 5432/citsmart db",user name="citsmartdbuser",password="exemplo123",driver class="org postgresql driver", enabled=true, use java context=true) /subsystem=datasources/data source="/env\\/jdbc\\/citsmart neuro"\ write attribute(name=min pool size,value=10) /subsystem=datasources/data source="/env\\/jdbc\\/citsmart neuro"\ write attribute(name=max pool size,value=300) /subsystem=datasources/data source="/env\\/jdbc\\/citsmart neuro"\ write attribute(name=pool prefill,value=true) /subsystem=datasources/data source="/env\\/jdbc\\/citsmart neuro"\ write attribute(name=flush strategy,value=failingconnectiononly) /subsystem=datasources/data source="/env\\/jdbc\\/citsmart neuro"\ write attribute(name=blocking timeout wait millis,value=60000)# datasource citsmart neuro app1 /subsystem=datasources/data source="/env/jdbc/citsmart neuro app1"\ add(jndi name="java /env/jdbc/citsmart neuro app1",driver name="postgres",connection url="jdbc\ postgresql //pgdata citsmart com 5432/citsmart db",user name="citsmartdbuser",password="exemplo123",driver class="org postgresql driver", enabled=true, use java context=true) /subsystem=datasources/data source="/env\\/jdbc\\/citsmart neuro"\ write attribute(name=min pool size,value=10) /subsystem=datasources/data source="/env\\/jdbc\\/citsmart neuro"\ write attribute(name=max pool size,value=300) /subsystem=datasources/data source="/env\\/jdbc\\/citsmart neuro"\ write attribute(name=pool prefill,value=true) /subsystem=datasources/data source="/env\\/jdbc\\/citsmart neuro"\ write attribute(name=flush strategy,value=failingconnectiononly) /subsystem=datasources/data source="/env\\/jdbc\\/citsmart neuro"\ write attribute(name=blocking timeout wait millis,value=60000) datasource citsmart neuro app2 /subsystem=datasources/data source="/env/jdbc/citsmart neuro app2"\ add(jndi name="java /env/jdbc/citsmart neuro app2",driver name="postgres",connection url="jdbc\ postgresql //pgdata citsmart com 5432/citsmart db",user name="citsmartdbuser",password="exemplo123",driver class="org postgresql driver", enabled=true, use java context=true) /subsystem=datasources/data source="/env\\/jdbc\\/citsmart neuro"\ write attribute(name=min pool size,value=10) /subsystem=datasources/data source="/env\\/jdbc\\/citsmart neuro"\ write attribute(name=max pool size,value=300) /subsystem=datasources/data source="/env\\/jdbc\\/citsmart neuro"\ write attribute(name=pool prefill,value=true) /subsystem=datasources/data source="/env\\/jdbc\\/citsmart neuro"\ write attribute(name=flush strategy,value=failingconnectiononly) /subsystem=datasources/data source="/env\\/jdbc\\/citsmart neuro"\ write attribute(name=blocking timeout wait millis,value=60000) datasource citsmart neuro app3 /subsystem=datasources/data source="/env/jdbc/citsmart neuro app3"\ add(jndi name="java /env/jdbc/citsmart neuro app3",driver name="postgres",connection url="jdbc\ postgresql //pgdata citsmart com 5432/citsmart db",user name="citsmartdbuser",password="exemplo123",driver class="org postgresql driver", enabled=true, use java context=true) /subsystem=datasources/data source="/env\\/jdbc\\/citsmart neuro"\ write attribute(name=min pool size,value=10) /subsystem=datasources/data source="/env\\/jdbc\\/citsmart neuro"\ write attribute(name=max pool size,value=300) /subsystem=datasources/data source="/env\\/jdbc\\/citsmart neuro"\ write attribute(name=pool prefill,value=true) /subsystem=datasources/data source="/env\\/jdbc\\/citsmart neuro"\ write attribute(name=flush strategy,value=failingconnectiononly) /subsystem=datasources/data source="/env\\/jdbc\\/citsmart neuro"\ write attribute(name=blocking timeout wait millis,value=60000) antes de sair do jboss cli, execute o comando reload para aplicar as alterações e faça um teste de conexão com a base de dados \[standalone\@localhost 9990 /] reload e faça um teste de conexão com todos os bancos com os comandos abaixo lembrando que o resultado precisa ser "outcome" => "success" /subsystem=datasources/data source="/jdbc/citsmart"\ test connection in pool /subsystem=datasources/data source="/jdbc/citsmartfluxo"\ test connection in pool /subsystem=datasources/data source="/jdbc/citsmart reports"\ test connection in pool /subsystem=datasources/data source="/jdbc/citsmartbpmeventos"\ test connection in pool /subsystem=datasources/data source="/jdbc/citsmart neuro"\ test connection in pool /subsystem=datasources/data source="/jdbc/citsmart neuro app1"\ test connection in pool /subsystem=datasources/data source="/jdbc/citsmart neuro app2"\ test connection in pool /subsystem=datasources/data source="/jdbc/citsmart neuro app3"\ test connection in pool