[quote=jakefrog][quote=diegohsi]Certo,
então eu posso remover o driver e a url de conexao com o banco do meu persistence e colocar no ds ?[/quote]Você tentou? Deu algum erro? [=[/quote]
Voltei,
fiz algumas tentativas, mais não esta construindo minha aplicação corretamente no jboss.
de uma olhada por favor pra ver se pode me dar uma luz…
persistence.xml
tentei com java:/ sem e ainda persiste.
[code]
<persistence-unit name="catalogoclientes" transaction-type="JTA">
<provider>org.hibernate.ejb.HibernatePersistence</provider>
<jta-data-source>java:/sqlite-ds</jta-data-source>
<class>br.com.catalogoclientes.model.Pessoa</class>
<class>br.com.catalogoclientes.model.PessoaFisica</class>
<class>br.com.catalogoclientes.model.PessoaJuridica</class>
<properties>
<property name="hibernate.connection.driver_class" value="org.sqlite.JDBC"/>
<property name="hibernate.connection.url" value="jdbc:sqlite:cliente"/>
<!-- <property name="javax.persistence.jdbc.driver" value="org.sqlite.JDBC" /> -->
<!-- <property name="javax.persistence.jdbc.url" value="jdbc:sqlite:cliente" /> -->
<property name="hibernate.dialect" value="br.com.catalogoclientes.util.SQLiteDialect" />
<property name="hibernate.show_sql" value="true" />
<property name="hibernate.format_sql" value="true" />
<!-- Opção habilitada apenas para teste - Retirar em produção -->
<property name="hibernate.hbm2ddl.auto" value="update"/>
</properties>
</persistence-unit>
[/code]
sqlite-ds.xml
<?xml version="1.0" encoding="UTF-8"?>
<datasources>
<local-tx-datasource>
<jndi-name>jdbc/catalogoclientes-ds</jndi-name>
<connection-url>jdbc:sqlite:cliente</connection-url>
<driver-class>org.sqlite.JDBC</driver-class>
<user-name></user-name>
<password></password>
<exception-sorter-class-name>org.jboss.resource.adapter.jdbc.vendor.MySQLExceptionSorter</exception-sorter-class-name>
<metadata>
<type-mapping></type-mapping>
</metadata>
</local-tx-datasource>
</datasources>
log do jboss
[code]persistence.units:ear=catalogoClientesEAR.ear,jar=catalogoClientesEJB.jar,unitName=catalogoclientes
State: NOTYETINSTALLED
I Depend On:
jboss.jca:name=sqlite-ds,service=DataSourceBinding
2012-07-27 16:28:28,917 DEBUG [org.jboss.system.ServiceController] removing jboss.j2ee:ear=catalogoClientesEAR.ear,jar=catalogoClientesEJB.jar,name=PessoaHBDAO,service=EJB3 from server
2012-07-27 16:28:28,917 DEBUG [org.jboss.system.ServiceController] Context not removed, it is recording dependencies: ObjectName: jboss.j2ee:ear=catalogoClientesEAR.ear,jar=catalogoClientesEJB.jar,name=PessoaHBDAO,service=EJB3
State: NOTYETINSTALLED
Depends On Me:
jboss.j2ee:ear=catalogoClientesEAR.ear,jar=catalogoClientesEJB.jar,name=br/com/catalogoclientes/remote/PessoaBO,service=EJB3
2012-07-27 16:28:28,917 DEBUG [org.jboss.system.ServiceController] removing service: jboss.j2ee:ear=catalogoClientesEAR.ear,jar=catalogoClientesEJB.jar,name=PessoaHBDAO,service=EJB3
2012-07-27 16:28:28,917 DEBUG [org.jboss.system.ServiceController] no need to remove jboss.j2ee:ear=catalogoClientesEAR.ear,jar=catalogoClientesEJB.jar,name=PessoaHBDAO,service=EJB3 from server
2012-07-27 16:28:28,917 WARN [org.jboss.ejb3.JmxKernelAbstraction] jboss.j2ee:ear=catalogoClientesEAR.ear,jar=catalogoClientesEJB.jar,name=PessoaHBDAO,service=EJB3 is not registered
2012-07-27 16:28:28,917 DEBUG [org.jboss.system.ServiceController] stopping service: jboss.j2ee:ear=catalogoClientesEAR.ear,jar=catalogoClientesEJB.jar,name=br/com/catalogoclientes/remote/PessoaBO,service=EJB3
2012-07-27 16:28:28,917 DEBUG [org.jboss.system.ServiceController] destroying service: jboss.j2ee:ear=catalogoClientesEAR.ear,jar=catalogoClientesEJB.jar,name=br/com/catalogoclientes/remote/PessoaBO,service=EJB3
2012-07-27 16:28:28,917 DEBUG [org.jboss.system.ServiceController] removing service: jboss.j2ee:ear=catalogoClientesEAR.ear,jar=catalogoClientesEJB.jar,name=br/com/catalogoclientes/remote/PessoaBO,service=EJB3
2012-07-27 16:28:28,917 DEBUG [org.jboss.system.ServiceController] Removing context for nonexistent service it is no longer recording dependencies: ObjectName: jboss.j2ee:ear=catalogoClientesEAR.ear,jar=catalogoClientesEJB.jar,name=PessoaHBDAO,service=EJB3
State: NOTYETINSTALLED
deployer: null
status: null
state: CONSTRUCTED
watch: file:/C:/jboss-4.2.3/server/default/tmp/deploy/tmp5824689318659151130catalogoClientesEAR.ear-contents/catalogoClientesEJB.jar
altDD: null
lastDeployed: 0
lastModified: 0
mbeans:
, isDirectory: false
2012-07-27 16:28:28,974 DEBUG [org.jboss.deployment.MainDeployer] Begin deployment start file:/C:/jboss-4.2.3/server/default/tmp/deploy/tmp5824689318659151130catalogoClientesEAR.ear-contents/catalogoClientesEJB.jar
2012-07-27 16:28:28,974 DEBUG [org.jboss.ejb3.EJB3Deployer] start application, deploymentInfo: org.jboss.deployment.DeploymentInfo@fda0982 { url=file:/C:/jboss-4.2.3/server/default/tmp/deploy/tmp5824689318659151130catalogoClientesEAR.ear-contents/catalogoClientesEJB.jar }
deployer: MBeanProxyExt[jboss.ejb3:service=EJB3Deployer]
status: Starting
state: START_DEPLOYER
watch: file:/C:/jboss-4.2.3/server/default/tmp/deploy/tmp5824689318659151130catalogoClientesEAR.ear-contents/catalogoClientesEJB.jar
altDD: null
lastDeployed: 1343417308932
lastModified: 1343417308927
mbeans:
, short name: catalogoClientesEJB.jar, parent short name: catalogoClientesEAR.ear
— MBeans waiting for other MBeans —
ObjectName: persistence.units:ear=catalogoClientesEAR.ear,jar=catalogoClientesEJB.jar,unitName=catalogoclientes
State: NOTYETINSTALLED
I Depend On:
jboss.jca:name=sqlite-ds,service=DataSourceBinding
ObjectName: persistence.units:ear=catalogoClientesEAR.ear,jar=catalogoClientesEJB.jar,unitName=catalogoclientes
State: NOTYETINSTALLED
I Depend On:
jboss.jca:name=sqlite-ds,service=DataSourceBinding
Depends On Me:
jboss.j2ee:ear=catalogoClientesEAR.ear,jar=catalogoClientesEJB.jar,name=PessoaHBDAO,service=EJB3
ObjectName: jboss.j2ee:ear=catalogoClientesEAR.ear,jar=catalogoClientesEJB.jar,name=PessoaHBDAO,service=EJB3
State: NOTYETINSTALLED
I Depend On:
persistence.units:ear=catalogoClientesEAR.ear,jar=catalogoClientesEJB.jar,unitName=catalogoclientes
Depends On Me:
jboss.j2ee:ear=catalogoClientesEAR.ear,jar=catalogoClientesEJB.jar,name=br/com/catalogoclientes/remote/PessoaBO,service=EJB3
ObjectName: jboss.j2ee:ear=catalogoClientesEAR.ear,jar=catalogoClientesEJB.jar,name=br/com/catalogoclientes/remote/PessoaBO,service=EJB3
State: NOTYETINSTALLED
I Depend On:
jboss.j2ee:ear=catalogoClientesEAR.ear,jar=catalogoClientesEJB.jar,name=PessoaHBDAO,service=EJB3
— MBEANS THAT ARE THE ROOT CAUSE OF THE PROBLEM —
ObjectName: jboss.jca:name=sqlite-ds,service=DataSourceBinding
State: NOTYETINSTALLED
Depends On Me:
persistence.units:ear=catalogoClientesEAR.ear,jar=catalogoClientesEJB.jar,unitName=catalogoclientes
persistence.units:ear=catalogoClientesEAR.ear,jar=catalogoClientesEJB.jar,unitName=catalogoclientes[/code]
É muito ruim quando não sabemos direito o porque das coisas, ainda to boiando nessa arquitetura do jboss, ejb, jpa. Comprei o livro ejb3 in action e chegará dia 30, mais ate espero que vcs me ajudem…