Histórico da Página

<resources> 
    <resource-root path="spring-asm.jar"/> 
    <resource-root path="spring-aop.jar"/> 
    <resource-root path="spring-context.jar"/> 
    <resource-root path="spring-core.jar"/> 
    <resource-root path="spring-beans.jar"/> 
    <resource-root path="spring-tx.jar"/> 
    <resource-root path="spring-jms.jar"/> 
    <resource-root path="spring-expression.jar"/> 
    <resource-root path="spring-web.jar"/> 
</resources>

CXF 2.6.4

• • Remover o conteúdo do diretório $JBOSS_HOME\modules\system\layers\base\org\apache\cxf\impl\main.
  • Baixar os jars da lista a seguir e colocar no diretório criado no item anterior
    

    • cxf-rt-bindings-coloc-2.6.4.jar

    • cxf-rt-bindings-object-2.6.4.jar

    • cxf-rt-bindings-soap-2.6.4.jar

    • cxf-rt-bindings-xml-2.6.4.jar

    • cxf-rt-core-2.6.4.jar

    • cxf-rt-databinding-aegis-2.6.4.jar

    • cxf-rt-databinding-jaxb-2.6.4.jar

    • cxf-rt-frontend-jaxws-2.6.4.jar

    • cxf-rt-frontend-simple-2.6.4.jar

    • cxf-rt-management-2.6.4.jar

    • cxf-rt-transports-http-2.6.4.jar

    • cxf-rt-transports-jms-2.6.4.jar

    • cxf-rt-transports-local-2.6.4.jar

    • cxf-rt-ws-addr-2.6.4.jar

    • cxf-rt-ws-mex-2.6.4.jar

    • cxf-rt-ws-policy-2.6.4.jar

    • cxf-rt-ws-rm-2.6.4.jar

    • cxf-rt-ws-security-2.6.4.jar

    • cxf-services-sts-core-2.6.4.jar

    • cxf-tools-common-2.6.4.jar

    • cxf-tools-java2ws-2.6.4.jar

    • cxf-tools-validator-2.6.4.jar

    • cxf-tools-wsdlto-core-2.6.4.jar

    • cxf-tools-wsdlto-databinding-jaxb-2.6.4.jar

    • cxf-tools-wsdlto-frontend-jaxws-2.6.4.jar

    • cxf-xjc-boolean-2.6.1.jar

    • cxf-xjc-dv-2.6.1.jar

    • cxf-xjc-ts-2.6.1.jar

       

  • Criar o arquivo module.xml no diretório main e inserir o conteúdo abaixo:

    Bloco de código
    language xml title $JBOSS_HOME\\modules\\system\\layers\\base\\org\\apache\\cxf\\impl\\main\\module.xml
    <?xml version="1.0" encoding="UTF-8"?> <!-- ~ JBoss, Home of Professional Open Source. ~ Copyright 2012, Red Hat, Inc., and individual contributors ~ as indicated by the @author tags. See the copyright.txt file in the ~ distribution for a full listing of individual contributors. ~ ~ This is free software; you can redistribute it and/or modify it ~ under the terms of the GNU Lesser General Public License as ~ published by the Free Software Foundation; either version 2.1 of ~ the License, or (at your option) any later version. ~ ~ This software is distributed in the hope that it will be useful, ~ but WITHOUT ANY WARRANTY; without even the implied warranty of ~ MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU ~ Lesser General Public License for more details. ~ ~ You should have received a copy of the GNU Lesser General Public ~ License along with this software; if not, write to the Free ~ Software Foundation, Inc., 51 Franklin St, Fifth Floor, Boston, MA ~ 02110-1301 USA, or see the FSF site: http://www.fsf.org. --> <module xmlns="urn:jboss:module:1.1" name="org.apache.cxf.impl"> <properties> <property name="jboss.api" value="private"/> </properties> <resources> <resource-root path="cxf-rt-bindings-coloc-2.6.4.jar"/> <resource-root path="cxf-rt-bindings-object-2.6.4.jar"/> <resource-root path="cxf-rt-bindings-soap-2.6.4.jar"/> <resource-root path="cxf-rt-bindings-xml-2.6.4.jar"/> <resource-root path="cxf-rt-core-2.6.4.jar"/> <resource-root path="cxf-rt-databinding-aegis-2.6.4.jar"/> <resource-root path="cxf-rt-databinding-jaxb-2.6.4.jar"/> <resource-root path="cxf-rt-frontend-jaxws-2.6.4.jar"/> <resource-root path="cxf-rt-frontend-simple-2.6.4.jar"/> <resource-root path="cxf-rt-management-2.6.4.jar"/> <resource-root path="cxf-rt-transports-http-2.6.4.jar"/> <resource-root path="cxf-rt-transports-jms-2.6.4.jar"/> <resource-root path="cxf-rt-transports-local-2.6.4.jar"/> <resource-root path="cxf-rt-ws-addr-2.6.4.jar"/> <resource-root path="cxf-rt-ws-mex-2.6.4.jar"/> <resource-root path="cxf-rt-ws-policy-2.6.4.jar"/> <resource-root path="cxf-rt-ws-rm-2.6.4.jar"/> <resource-root path="cxf-rt-ws-security-2.6.4.jar"/> <resource-root path="cxf-services-sts-core-2.6.4.jar"/> <resource-root path="cxf-tools-common-2.6.4.jar"/> <resource-root path="cxf-tools-java2ws-2.6.4.jar"/> <resource-root path="cxf-tools-validator-2.6.4.jar"/> <resource-root path="cxf-tools-wsdlto-core-2.6.4.jar"/> <resource-root path="cxf-tools-wsdlto-databinding-jaxb-2.6.4.jar"/> <resource-root path="cxf-tools-wsdlto-frontend-jaxws-2.6.4.jar"/> <resource-root path="cxf-xjc-boolean-2.6.1.jar"/> <resource-root path="cxf-xjc-dv-2.6.1.jar"/> <resource-root path="cxf-xjc-ts-2.6.1.jar"/> </resources> <dependencies> <module name="asm.asm" /> <module name="javax.api" /> <module name="javax.annotation.api" /> <module name="javax.jms.api" /> <module name="javax.jws.api" /> <module name="javax.mail.api" /> <module name="javax.resource.api" /> <module name="javax.servlet.api" /> <module name="javax.wsdl4j.api" /> <module name="javax.xml.bind.api" services="import"/> <module name="com.sun.xml.bind" services="import"/> <module name="javax.xml.soap.api" /> <module name="javax.xml.stream.api" /> <module name="javax.xml.ws.api" /> <module name="org.apache.commons.lang" /> <module name="org.apache.neethi" /> <module name="org.apache.velocity" /> <module name="org.apache.xml-resolver" /> <module name="org.apache.ws.xmlschema" /> <module name="org.apache.ws.security" /> <module name="org.apache.santuario.xmlsec" /> <module name="org.joda.time" /> <module name="org.opensaml" /> <module name="org.springframework.spring" optional="true"/> <module name="org.apache.cxf" export="true"/> </dependencies> </module>

Instalando uma Licença para o TOTVS Intellector

#persistence.properties 
#Fri Feb 03 13:52:26 BRST 2012 
  
### Define se o intellector utilizará banco de dados para persistência dos dados de acessos e políticas 
intellector.usesdatabase=true
  
### Nome da fila utilizada pelo MDB (Não pode ser alterado) 
persistence.queue.name=queue/intellector
  
### Connection Factory 
persistence.queue.connection.factory=/ConnectionFactory
  
### Endereço da fila JMS 
persistence.jndi.address=jnp://192.168.0.113:1099 
  
### Emails de aviso de erro na fila de tarifação, separados por virgula, de preferência sem espaço 
user.emailsWarning= 
#[email protected], [email protected] 
  
### Credenciais de conexão na fila Usuário/Senha 
persistence.jndi.security.principal= 
persistence.jndi.security.credentials= 
  
### Parâmetros do Hibernate do Cache ### 
######################################## 
## Endereço JNDI da conexão 
hibernate.connection.datasource=java:/intellector/totvs
#hibernate.dialect=org.hibernate.dialect.PostgreSQLDialect 
hibernate.dialect=org.hibernate.dialect.SQLServer2008Dialect 
#hibernate.dialect=br.com.totvs.persistence.dialectfix.Oracle9iDialectFix 
#hibernate.dialect=br.com.totvs.persistence.dialectfix.Oracle10gDialectFix 
  
## auto schema export 
hibernate.hbm2ddl.auto=update 
  
# cache 
#hibernate.cache.provider_class=org.hibernate.hibernate.NoCacheProvider 
hibernate.cache.use_second_level_cache=true
hibernate.max_fetch_depth=1 
hibernate.cache.use_minimal_puts=true
  
## Delimitador de comandos específico do Banco de dados utilizado 
hibernate.hbm2ddl.delimiter=; 
  
#hibernate.session_factory_name=TSessionFactory 
hibernate.show_sql=true
hibernate.format_sql=true
hibernate.use_sql_comments=true
hibernate.generate_statistics=true
hibernate.jdbc.batch_versioned_data=true
hibernate.use_second_level_cache=false
hibernate.use_query_cache=false
hibernate.connection.release_mode=after_transaction 
hibernate.connection.autocommit=false
hibernate.session_factory_name=sessionFactory 
hibernate.current_session_context_class=thread 
  
# transaction controll 
hibernate.transaction.flush_before_completion=false
hibernate.transaction.auto_close_session=false
 
# para o caso da base Oracle 11g, descomentar a linha abaixo
#hibernate.default_schema=<NOME_DO_SCHEMA>

hibernate.connection.datasource
hibernate.dialect

Configurando Pool de Conexões - JNDI

• O pool de conexão deve ser habilitado usando a console.

• Deve-se definir um banco de dados para o Intellector persistir suas informações. A definição do banco de dados é efetuada no arquivo standalone-full.xml na tag <datasources>. O nome do JNDI não pode ser alterado (jndi-name="java:/intellector/totvs).
  .
  • Exemplo datasource Postgres

    • Formato da conexão: <IP_SERVIDOR_BANCO_DE_DADOS>:<PORTA>/<BASE>

      Bloco de código
      language xml title Exemplo datasource Postgres
      <datasource jta="false" jndi-name="java:/intellector/totvs" pool-name="intellector/totvs" enabled="true" use-ccm="false"> <connection-url>jdbc:postgresql://127.0.0.1:5432/postgres</connection-url> <driver-class>org.postgresql.Driver</driver-class> <driver>postgresql-driver</driver> <pool> <min-pool-size>1</min-pool-size> <max-pool-size>30</max-pool-size> </pool> <security> <user-name>postgres</user-name> <password>01totvs02tools03</password> </security> <validation> <validate-on-match>false</validate-on-match> <background-validation>false</background-validation> </validation> <statement> <share-prepared-statements>false</share-prepared-statements> </statement> </datasource>

  • Exemplo datasource Oracle

    Bloco de código
    language xml title Exemplo datasource Oracle
    <datasource jta="false" jndi-name="java:/intellector/totvs" pool-name="intellector/totvs" enabled="true" use-ccm="false"> <connection-url>jdbc:oracle:thin:@10.5.1.1:1521:Oralin</connection-url> <driver-class>oracle.jdbc.OracleDriver</driver-class> <driver>oracle-driver</driver> <transaction-isolation>TRANSACTION_READ_COMMITTED</transaction-isolation> <pool> <min-pool-size>5</min-pool-size> <max-pool-size>20</max-pool-size> </pool> <security> <user-name>Protheus12_teste</user-name> <password>totvs@1</password> </security> <validation> <validate-on-match>false</validate-on-match> <background-validation>false</background-validation> </validation> <statement> <share-prepared-statements>false</share-prepared-statements> </statement> </datasource>

Apontamento dos drivers de conexão.

Informar todos os drivers/modules que foram utilizados dentro do arquivo standalone-full.xml

                <drivers>
                    <driver name="postgresql-driver" module="org.postgresql">
                        <driver-class>org.postgresql.Driver</driver-class>
                    </driver>
                    <driver name="oracle-driver" module="com.oracle.ojdbc6">
                        <driver-class>oracle.jdbc.OracleDriver</driver-class>
                    </driver>
                    <driver name="jtds-driver" module="net.sourceforge.jtds">
                        <driver-class>net.sourceforge.jtds.jdbc.Driver</driver-class>
                    </driver>
                </drivers>