Como configurar pool de conexão no jBoss 3.2.7

Boa tarde pessoal,

Estou disponibilizando uma aplicação web através do jBoss versão 3.2.7.
E durante a inicialização do jBoss está ocorrendo o seguinte erro:
Após o mapeamento dos VOs pelo Hibernate.

2006-12-29 16:27:10,648 INFO  [org.hibernate.util.NamingHelper] JNDI InitialContext properties:{}
2006-12-29 16:27:10,648 FATAL [org.hibernate.connection.DatasourceConnectionProvider] Could not find datasource: java:comp/env/jdbc/sgo
javax.naming.NamingException: Could not dereference object [Root exception is javax.naming.NameNotFoundException: jdbc not bound]
   at org.jnp.interfaces.NamingContext.resolveLink(NamingContext.java:1047)
   at org.jnp.interfaces.NamingContext.lookup(NamingContext.java:681)
   at org.jnp.interfaces.NamingContext.lookup(NamingContext.java:697)
   at org.jnp.interfaces.NamingContext.lookup(NamingContext.java:568)
   at javax.naming.InitialContext.lookup(InitialContext.java:351)
   at org.hibernate.connection.DatasourceConnectionProvider.configure(DatasourceConnectionProvider.java:52)
   at org.hibernate.connection.ConnectionProviderFactory.newConnectionProvider(ConnectionProviderFactory.java:124)
   at org.hibernate.connection.ConnectionProviderFactory.newConnectionProvider(ConnectionProviderFactory.java:56)
   at org.hibernate.cfg.SettingsFactory.createConnectionProvider(SettingsFactory.java:397)
   at org.hibernate.cfg.SettingsFactory.buildSettings(SettingsFactory.java:62)
   at org.hibernate.cfg.Configuration.buildSettings(Configuration.java:1933)
   at org.hibernate.cfg.Configuration.buildSessionFactory(Configuration.java:1216)
   at com.powerlogic.jcompany.persistencia.hibernate.PlcBaseHibernateManager.registraFabrica(PlcBaseHibernateManager.java:106)

Alguém poderia nos orientar qual é o problema?
Abaixo segue a estrutura da configuração de conexão:

web.xml:

<resource-ref>
 <description>EndereÃ§o JNDI para pegar o Pool de ConexÃµes com o SGBD.
  Este pool deve ser configurado no Application Server e registrado com
  o endereÃ§o acima:jdbc/sgo</description>
 <res-ref-name>jdbc/sgo</res-ref-name>
 <res-type>javax.sql.DataSource</res-type>
 <res-auth>Container</res-auth>
 <res-sharing-scope>Shareable</res-sharing-scope>
</resource-ref>

jboss-web.xml:

<jboss-web>

  <!-- Resource references -->
  <resource-ref>
     <res-ref-name>jdbc/sgo</res-ref-name>
     <res-type>javax.sql.DataSource</res-type>
     <jndi-name>java:jdbc/sgo</jndi-name>
  </resource-ref>

</jboss-web>

pool de conexão (pool-oracle-sgo-ds.xml):

<?xml version="1.0" encoding="UTF-8"?>
<datasources>
 <local-tx-datasource>
   <jndi-name>jdbc/sgo</jndi-name>
   <connection-url>jdbc:oracle:thin:@srvnt05:1521:d900</connection-url>
   <driver-class>oracle.jdbc.driver.OracleDriver</driver-class>
   <user-name>ADMDADOS</user-name>
   <password>ADMDADOS</password>
   <metadata>
      <type-mapping>PostgreSQL 7.2</type-mapping>
   </metadata>
 </local-tx-datasource>
</datasources>

hibernate.cfg.xml:

<property name="connection.datasource">java:comp/env/jdbc/sgo</property>

jboss Versão 3.2.7:
Driver do jdbc Oracle:
E:\jboss-3.2.7\server\default\lib\classes12.jar
Aplicação:
E:\jboss-3.2.7\server\default\deploy\sgo.war e
E:\jboss-3.2.7\server\default\deploy\pool-oracle-sgo-ds.xml

Att,

Péricles.

Topicos relacionados