Árvore de páginas

Versões comparadas

Chave

  • Esta linha foi adicionada.
  • Esta linha foi removida.
  • A formatação mudou.

...

Deck of Cards
effectDuration0.5
historyfalse
idsample
effectTypefade
Card
defaulttrue
id13
labelA partir da 1.6 até 1.6.5-190514


  • Acesse o diretório [Instalação fluig]\appserver\domain\configuration e edite o arquivo domain.xml;
  • Procure pelo bloco <datasources>;
  • Nesse bloco verifique todas as informações relacionadas à conexão com o banco, como por exemplo, usuário, senha e nome da base.


Exemplo de configuração com banco de dados Oracle:

Bloco de código
languagexml
themeEclipse
titledomain.xml
collapsetrue
<datasources>
    <datasource jta="true" jndi-name="java:/jdbc/FluigDS" pool-name="FluigDS" enabled="true" use-java-context="false">
        <connection-url>jdbc:oracle:thin:@192.168.0.1:1521:FLUIG</connection-url>
        <driver>oracleDriver</driver>
        <new-connection-sql>alter session set nls_comp = 'LINGUISTIC' nls_sort = 'BINARY_CI'</new-connection-sql>
        <transaction-isolation>TRANSACTION_READ_COMMITTED</transaction-isolation>
        <pool>
            <min-pool-size>10</min-pool-size>
            <max-pool-size>20</max-pool-size>
        </pool>
        <security>
            <user-name>usuario</user-name>
            <password>senha</password>
        </security>
        <validation>
            <valid-connection-checker class-name="org.jboss.jca.adapters.jdbc.extensions.oracle.OracleValidConnectionChecker"/>
            <validate-on-match>true</validate-on-match>
            <background-validation>false</background-validation>
        </validation>
        <statement>
            <share-prepared-statements>false</share-prepared-statements>
        </statement>
    </datasource>
    <datasource jta="false" jndi-name="java:/jdbc/FluigDSRO" pool-name="FluigDSRO" enabled="true" use-java-context="false">
        <connection-url>jdbc:oracle:thin:@192.168.0.1:1521:FLUIG</connection-url>
        <driver>oracleDriver</driver>
        <new-connection-sql>alter session set nls_comp = 'LINGUISTIC' nls_sort = 'BINARY_CI'</new-connection-sql>
        <transaction-isolation>TRANSACTION_READ_COMMITTED</transaction-isolation>
        <pool>
            <min-pool-size>5</min-pool-size>
            <max-pool-size>15</max-pool-size>
        </pool>
        <security>
            <user-name>usuario</user-name>
            <password>senha</password>
        </security>
        <validation>
            <valid-connection-checker class-name="org.jboss.jca.adapters.jdbc.extensions.oracle.OracleValidConnectionChecker"/>
            <validate-on-match>true</validate-on-match>
            <background-validation>false</background-validation>
        </validation>
        <timeout>
            <blocking-timeout-millis>30000</blocking-timeout-millis>
        </timeout>
        <statement>
            <share-prepared-statements>false</share-prepared-statements>
        </statement>
    </datasource>
    <drivers>
        <driver name="oracleDriver" module="com.oracle.jdbc<datasource jta="false" jndi-name="java:/jdbc/AppDS" pool-name="AppDS" enabled="true" use-java-context="false">
            <driver-class>oracle.jdbc.driver.OracleDriver</driver-class><connection-url>jdbc:oracle:thin:@192.168.0.1:1521:FLUIG</connection-url>
        <<driver>oracleDriver</driver>
        <new-connection-sql>alter session set nls_comp = 'LINGUISTIC' nls_sort = 'BINARY_CI'</drivers>
</datasources>
Card
id2
label1.5.13 e anteriores
  • Acesse o diretório [Instalação fluig]\jboss\standalone\configuration e edite o arquivo standalone.xml;
  • Procure pelo bloco <datasources>;
  • Nesse bloco verifique todas as informações relacionadas à conexão com o banco, como por exemplo, usuário, senha e nome da base.

Exemplo de configuração com banco de dados Oracle:

Bloco de código
languagexml
themeEclipse
titlestandalone.xml
collapsetrue
<datasources>
    <datasource jta="true" jndi-name="java:/jdbc/FluigDS" pool-name="FluigDS" enabled="true" use-java-context="false">new-connection-sql>
        <transaction-isolation>TRANSACTION_READ_COMMITTED</transaction-isolation>
        <pool>
            <min-pool-size>5</min-pool-size>
            <max-pool-size>15</max-pool-size>
        <connection-url>jdbc:oracle:thin:@192.168.0.1:1521:FLUIG</connection-url></pool>
        <driver>oracleDriver</driver><security>
        <new-connection-sql>alter session set nls_comp = 'LINGUISTIC' nls_sort = 'BINARY_CI'</new-connection-sql>
 <user-name>usuario</user-name>
            <transaction-isolation>TRANSACTION_READ_COMMITTED</transaction-isolation><password>senha</password>
        <pool></security>
            <min-pool-size>10</min-pool-size><validation>
            <max<valid-pool-size>20</max-pool-size>
connection-checker class-name="org.jboss.jca.adapters.jdbc.extensions.oracle.OracleValidConnectionChecker"/>
         </pool>   <validate-on-match>true</validate-on-match>
        <security>
    <background-validation>false</background-validation>
        <user-name>usuario</user-name></validation>
        <timeout>
    <password>senha</password>
        </security><blocking-timeout-millis>30000</blocking-timeout-millis>
        <validation></timeout>
            <valid-connection-checker class-name="org.jboss.jca.adapters.jdbc.extensions.oracle.OracleValidConnectionChecker"/><statement>
            <validate<share-onprepared-match>true<statements>false</validateshare-onprepared-match>statements>
            <background-validation>false</background-validation>
 </statement>
       </validation>datasource>
        <statement><drivers>
        <driver name="oracleDriver" module="com.oracle.jdbc">
            <share-prepared-statements>false</share-prepared-statements><driver-class>oracle.jdbc.driver.OracleDriver</driver-class>
        </statement>driver>
    </drivers>
</datasources>
Card
id1
label1.6.0 a 1.6.5-190430


  • Acesse o diretório [Instalação fluig]\appserver\domain\configuration e edite o arquivo domain.xml;
  • Procure pelo bloco <datasources>;
  • Nesse bloco verifique todas as informações relacionadas à conexão com o banco, como por exemplo, usuário, senha e nome da base.


Exemplo de configuração com banco de dados Oracle:

Bloco de código
languagexml
themeEclipse
titledomain.xml
collapsetrue
<datasources>
    <datasource jta="true" jndi-name="java:/jdbc/FluigDS" pool-name="FluigDS" enabled="true" use-java-context="false">datasource>
    <datasource jta="false" jndi-name="java:/jdbc/FluigDSRO" pool-name="FluigDSRO" enabled="true" use-java-context="false">
        <connection-url>jdbc:oracle:thin:@192.168.0.1:1521:FLUIG</connection-url>
        <driver>oracleDriver</driver>
        <new-connection-sql>alter session set nls_comp = 'LINGUISTIC' nls_sort = 'BINARY_CI'</new-connection-sql>
        <transaction-isolation>TRANSACTION_READ_COMMITTED</transaction-isolation>
        <pool><connection-url>jdbc:oracle:thin:@192.168.0.1:1521:FLUIG</connection-url>
            <min-pool-size>5</min-pool-size><driver>oracleDriver</driver>
        <new-connection-sql>alter session   <max-pool-size>15</max-pool-size>set nls_comp = 'LINGUISTIC' nls_sort = 'BINARY_CI'</new-connection-sql>
        </pool><transaction-isolation>TRANSACTION_READ_COMMITTED</transaction-isolation>
        <security><pool>
            <user<min-pool-name>usuario<size>10</usermin-pool-name>size>
            <password>senha</password><max-pool-size>20</max-pool-size>
        </security>pool>
        <validation><security>
            <valid-<user-name>usuario</user-name>
            <password>senha</password>
        </security>
        <validation>
            <valid-connection-checker class-name="org.jboss.jca.adapters.jdbc.extensions.oracle.OracleValidConnectionChecker"/>
            <validate-on-match>true</validate-on-match>
            <background-validation>false</background-validation>
        </validation>
        <timeout><statement>
            <blocking<share-timeoutprepared-millis>30000<statements>false</blockingshare-timeoutprepared-millis>statements>
        </timeout>statement>
     </datasource>
     <statement>
    <datasource jta="false" jndi-name="java:/jdbc/FluigDSRO" pool-name="FluigDSRO" enabled="true" use-java-context="false">
        <share-prepared-statements>false</share-prepared-statements><connection-url>jdbc:oracle:thin:@192.168.0.1:1521:FLUIG</connection-url>
        <<driver>oracleDriver</statement>driver>
      </datasource>
    <drivers>
    <new-connection-sql>alter session set nls_comp = 'LINGUISTIC' nls_sort = 'BINARY_CI'</new-connection-sql>
      <driver name="oracleDriver" module="com.oracle.jdbc"> <transaction-isolation>TRANSACTION_READ_COMMITTED</transaction-isolation>
        <pool>
    <driver-class>oracle.jdbc.driver.OracleDriver</driver-class>        <min-pool-size>5</min-pool-size>
        </driver>
    </drivers>
</datasources>
Card
id3
label1.6.5 - 190514 ou superiores
  • Acesse o diretório [Instalação fluig]\appserver\domain\configuration e edite o arquivo domain.xml;
  • Procure pelo bloco <datasources>;
  • Nesse bloco verifique todas as informações relacionadas à conexão com o banco, como por exemplo, usuário, senha e nome da base.

Exemplo de configuração com banco de dados Oracle:

Bloco de código
languagexml
themeEclipse
titledomain.xml
collapsetrue
<datasources><max-pool-size>15</max-pool-size>
    <datasource jta="true" jndi-name="java:/jdbc/FluigDS" pool-name="FluigDS" enabled="true" use-java-context="false">    </pool>
        <security>
        <connection-url>jdbc:oracle:thin:@192.168.0.1:1521:FLUIG</connection-url>
    <user-name>usuario</user-name>
           <driver>oracleDriver< <password>senha</driver>password>
        <new-connection-sql>alter session set nls_comp = 'LINGUISTIC' nls_sort = 'BINARY_CI'</new-connection-sql></security>
        <validation>
        <transaction-isolation>TRANSACTION_READ_COMMITTED</transaction-isolation>    <valid-connection-checker class-name="org.jboss.jca.adapters.jdbc.extensions.oracle.OracleValidConnectionChecker"/>
        <pool>
            <min-pool-size>10</min-pool-size><validate-on-match>true</validate-on-match>
            <max<background-pool-size>20<validation>false</maxbackground-pool-size>validation>
        </pool>validation>
        <security><timeout>
            <user<blocking-timeout-name>usuario<millis>30000</user-name>
            <password>senha</password>blocking-timeout-millis>
        </security>timeout>
        <validation><statement>
            <valid-connection-checker class-name="org.jboss.jca.adapters.jdbc.extensions.oracle.OracleValidConnectionChecker"/><share-prepared-statements>false</share-prepared-statements>
        </statement>
    <validate-on-match>true</validate-on-match>
  </datasource>
    <drivers>
        <driver  <background-validation>false</background-validation>name="oracleDriver" module="com.oracle.jdbc">
        </validation>
        <statement><driver-class>oracle.jdbc.driver.OracleDriver</driver-class>
        </driver>
    </drivers>
</datasources>
Card
id2
label1.5.13 e anteriores


  • Acesse o diretório [Instalação fluig]\jboss\standalone\configuration e edite o arquivo standalone.xml;
  • Procure pelo bloco <datasources>;
  • Nesse bloco verifique todas as informações relacionadas à conexão com o banco, como por exemplo, usuário, senha e nome da base.


Exemplo de configuração com banco de dados Oracle:

Bloco de código
languagexml
themeEclipse
titlestandalone.xml
collapsetrue
<datasources>
    <share-prepared-statements>false</share-prepared-statements>
        </statement>
    </datasource>
    <datasource jta="falsetrue" jndi-name="java:/jdbc/FluigDSROFluigDS" pool-name="FluigDSROFluigDS" enabled="true" use-java-context="false">
        <connection-url>jdbc:oracle:thin:@192.168.0.1:1521:FLUIG</connection-url>
        <driver>oracleDriver</driver>
        <new-connection-sql>alter session set nls_comp = 'LINGUISTIC' nls_sort = 'BINARY_CI'</new-connection-sql>
        <transaction-isolation>TRANSACTION_READ_COMMITTED</transaction-isolation>
        <pool>
            <min-pool-size>5<size>10</min-pool-size>
            <max-pool-size>15<size>20</max-pool-size>
        </pool>
        <security>
            <user-name>usuario</user-name>
            <password>senha</password>
        </security>
        <validation>
            <valid-connection-checker class-name="org.jboss.jca.adapters.jdbc.extensions.oracle.OracleValidConnectionChecker"/>
            <validate-on-match>true</validate-on-match>
            <background-validation>false</background-validation>
        </validation>
        <timeout>
            <blocking-timeout-millis>30000</blocking-timeout-millis>
        </timeout>
        <statement>
            <share-prepared-statements>false</share-prepared-statements>
        </statement>
    </datasource>
    <datasource jta="false" jndi-name="java:/jdbc/AppDSFluigDSRO" pool-name="AppDSFluigDSRO" enabled="true" use-java-context="false">
        <connection-url>jdbc:oracle:thin:@192.168.0.1:1521:FLUIG</connection-url>
        <driver>oracleDriver</driver>
        <new-connection-sql>alter session set nls_comp = 'LINGUISTIC' nls_sort = 'BINARY_CI'</new-connection-sql>
        <transaction-isolation>TRANSACTION_READ_COMMITTED</transaction-isolation>
        <pool>
            <min-pool-size>5</min-pool-size>
            <max-pool-size>15</max-pool-size>
        </pool>
        <security>
            <user-name>usuario</user-name>
            <password>senha</password>
        </security>
        <validation>
            <valid-connection-checker class-name="org.jboss.jca.adapters.jdbc.extensions.oracle.OracleValidConnectionChecker"/>
            <validate-on-match>true</validate-on-match>
            <background-validation>false</background-validation>
        </validation>
        <timeout>
            <blocking-timeout-millis>30000</blocking-timeout-millis>
        </timeout>
        <statement>
            <share-prepared-statements>false</share-prepared-statements>
        </statement>
    </datasource>
    <drivers>
        <driver name="oracleDriver" module="com.oracle.jdbc">
            <driver-class>oracle.jdbc.driver.OracleDriver</driver-class>
        </driver>
    </drivers>
</datasources>





...