Erro no arquivo standardjbosscmp-jdbc.xml...?

7 respostas
P

Caros ,

por que está dando erro ao startup do Jboss

no arquivo C:\jboss-4.2.2.GA\server\default\conf\standardjbosscmp-jdbc.xml

Se alguém puder me ajudar …agradeceria…

abs

--
<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE jbosscmp-jdbc PUBLIC
   "-//JBoss//DTD JBOSSCMP-JDBC 4.0//EN"
   "http://www.jboss.org/j2ee/dtd/jbosscmp-jdbc_4_0.dtd">

<!-- ===================================================================== -->
<!--                                                                       -->
<!--  Standard JBossCMP-JDBC Configuration                                 -->
<!--                                                                       -->
<!-- ===================================================================== -->

<!-- $Id: standardjbosscmp-jdbc.xml 63355 2007-06-05 17:25:20Z rrajesh $ -->

<jbosscmp-jdbc>

   <defaults>
   
   <!-- -->
   <datasource>java:/OracleDS</datasource>
   <datasource-mapping>Oracle</datasource-mapping>
   </datasources>
   
 <!-- -->
      <datasource>java:/DefaultDS</datasource>
      <!-- optional since 4.0 <datasource-mapping>Hypersonic SQL</datasource-mapping> -->

      <create-table>true</create-table>
      <remove-table>false</remove-table>
      <read-only>false</read-only>
      <read-time-out>300000</read-time-out>
      <row-locking>false</row-locking>
      <pk-constraint>true</pk-constraint>
      <fk-constraint>false</fk-constraint>
      <preferred-relation-mapping>foreign-key</preferred-relation-mapping>
      <read-ahead>
         <strategy>on-load</strategy>
         <page-size>1000</page-size>
         <eager-load-group>*</eager-load-group>
      </read-ahead>
      <list-cache-max>1000</list-cache-max>
      <clean-read-ahead-on-load>false</clean-read-ahead-on-load>
2008-09-10 14:34:04,484 DEBUG [org.jboss.system.ServiceController] starting service jboss:service=invoker,type=unified
2008-09-10 14:34:04,484 DEBUG [org.jboss.invocation.unified.server.UnifiedInvoker] Starting jboss:service=invoker,type=unified
2008-09-10 14:34:04,484 DEBUG [org.jboss.invocation.unified.server.UnifiedInvoker] Starting unified invoker service.
2008-09-10 14:34:04,500 DEBUG [org.jboss.invocation.unified.server.UnifiedInvoker] Started jboss:service=invoker,type=unified
2008-09-10 14:34:04,500 DEBUG [org.jboss.system.ServiceController] Starting dependent components for: jboss:service=invoker,type=unified dependent components: []
2008-09-10 14:34:04,500 DEBUG [org.jboss.system.ServiceController] starting service jboss.remoting:service=Connector,transport=socket
2008-09-10 14:34:04,500 DEBUG [org.jboss.system.ServiceController] Ignoring start request for service: jboss.remoting:service=Connector,transport=socket
2008-09-10 14:34:04,500 DEBUG [org.jboss.system.ServiceController] starting service jboss.jdbc:service=metadata
2008-09-10 14:34:04,500 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.metadata.MetaDataLibrary] Starting jboss.jdbc:service=metadata
2008-09-10 14:34:04,515 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.metadata.MetaDataLibrary] Loading standardjbosscmp-jdbc.xml : file:/C:/jboss-4.2.2.GA/server/default/conf/standardjbosscmp-jdbc.xml
2008-09-10 14:34:04,546 ERROR [org.jboss.metadata.XmlFileLoader] XmlFileLoader: File file:/C:/jboss-4.2.2.GA/server/default/conf/standardjbosscmp-jdbc.xml process fatal error. Line: 21. Error message: The element type "defaults" must be terminated by the matching end-tag "</defaults>".
2008-09-10 14:34:04,546 DEBUG [org.jboss.util.NestedThrowable] org.jboss.util.NestedThrowable.parentTraceEnabled=true
2008-09-10 14:34:04,546 DEBUG [org.jboss.util.NestedThrowable] org.jboss.util.NestedThrowable.nestedTraceEnabled=false
2008-09-10 14:34:04,546 DEBUG [org.jboss.util.NestedThrowable] org.jboss.util.NestedThrowable.detectDuplicateNesting=true
2008-09-10 14:34:04,546 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.metadata.MetaDataLibrary] Starting failed jboss.jdbc:service=metadata
org.jboss.deployment.DeploymentException: Invalid XML: file=file:/C:/jboss-4.2.2.GA/server/default/conf/standardjbosscmp-jdbc.xml@6:21; - nested throwable: (org.xml.sax.SAXParseException: The element type "defaults" must be terminated by the matching end-tag "</defaults>".)
	at org.jboss.metadata.XmlFileLoader.getDocument(XmlFileLoader.java:342)
	at org.jboss.metadata.XmlFileLoader.getDocument(XmlFileLoader.java:272)
	at org.jboss.metadata.XmlFileLoader.getDocumentFromURL(XmlFileLoader.java:244)
	at org.jboss.metadata.XmlFileLoader.getDocument(XmlFileLoader.java:228)
	at org.jboss.ejb.plugins.cmp.jdbc.metadata.MetaDataLibrary.startService(MetaDataLibrary.java:79)
	at org.jboss.system.ServiceMBeanSupport.jbossInternalStart(ServiceMBeanSupport.java:289)
	at org.jboss.system.ServiceMBeanSupport.jbossInternalLifecycle(ServiceMBeanSupport.java:245)
	at sun.reflect.GeneratedMethodAccessor3.invoke(Unknown Source)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
	at java.lang.reflect.Method.invoke(Method.java:597)
	at org.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatcher.java:155)
	at org.jboss.mx.server.Invocation.dispatch(Invocation.java:94)
	at org.jboss.mx.server.Invocation.invoke(Invocation.java:86)
	at org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:264)
	at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:659)
	at org.jboss.system.ServiceController$ServiceProxy.invoke(ServiceController.java:978)
	at $Proxy0.start(Unknown Source)
	at org.jboss.system.ServiceController.start(ServiceController.java:417)
	at sun.reflect.GeneratedMethodAccessor9.invoke(Unknown Source)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
	at java.lang.reflect.Method.invoke(Method.java:597)
	at org.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatcher.java:155)
	at org.jboss.mx.server.Invocation.dispatch(Invocation.java:94)
	at org.jboss.mx.server.Invocation.invoke(Invocation.java:86)
	at org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:264)
	at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:659)
	at org.jboss.mx.util.MBeanProxyExt.invoke(MBeanProxyExt.java:210)
	at $Proxy4.start(Unknown Source)
	at org.jboss.deployment.SARDeployer.start(SARDeployer.java:302)
	at org.jboss.deployment.MainDeployer.start(MainDeployer.java:1025)
	at org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:819)
	at org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:782)
	at org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:766)
	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
	at java.lang.reflect.Method.invoke(Method.java:597)
	at org.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatcher.java:155)
	at org.jboss.mx.server.Invocation.dispatch(Invocation.java:94)
	at org.jboss.mx.interceptor.AbstractInterceptor.invoke(AbstractInterceptor.java:133)
	at org.jboss.mx.server.Invocation.invoke(Invocation.java:88)
	at org.jboss.mx.interceptor.ModelMBeanOperationInterceptor.invoke(ModelMBeanOperationInterceptor.java:142)
	at org.jboss.mx.server.Invocation.invoke(Invocation.java:88)
	at org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:264)
	at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:659)
	at org.jboss.mx.util.MBeanProxyExt.invoke(MBeanProxyExt.java:210)
	at $Proxy5.deploy(Unknown Source)
	at org.jboss.system.server.ServerImpl.doStart(ServerImpl.java:482)
	at org.jboss.system.server.ServerImpl.start(ServerImpl.java:362)
	at org.jboss.Main.boot(Main.java:200)
	at org.jboss.Main$1.run(Main.java:508)
	at java.lang.Thread.run(Thread.java:619)
Caused by: org.xml.sax.SAXParseException: The element type "defaults" must be terminated by the matching end-tag "</defaults>".
	at org.apache.xerces.parsers.DOMParser.parse(Unknown Source)
	at org.apache.xerces.jaxp.DocumentBuilderImpl.parse(Unknown Source)
	at org.jboss.metadata.XmlFileLoader.getDocument(XmlFileLoader.java:328)
	... 51 more
2008-09-10 14:34:04,562 WARN  [org.jboss.system.ServiceController] Problem starting service jboss.jdbc:service=metadata
org.jboss.deployment.DeploymentException: Invalid XML: file=file:/C:/jboss-4.2.2.GA/server/default/conf/standardjbosscmp-jdbc.xml@6:21; - nested throwable: (org.xml.sax.SAXParseException: The element type "defaults" must be terminated by the matching end-tag "</defaults>".)
	at org.jboss.metadata.XmlFileLoader.getDocument(XmlFileLoader.java:342)
	at org.jboss.metadata.XmlFileLoader.getDocument(XmlFileLoader.java:272)
	at org.jboss.metadata.XmlFileLoader.getDocumentFromURL(XmlFileLoader.java:244)
	at org.jboss.metadata.XmlFileLoader.getDocument(XmlFileLoader.java:228)
	at org.jboss.ejb.plugins.cmp.jdbc.metadata.MetaDataLibrary.startService(MetaDataLibrary.java:79)
	at org.jboss.system.ServiceMBeanSupport.jbossInternalStart(ServiceMBeanSupport.java:289)
	at org.jboss.system.ServiceMBeanSupport.jbossInternalLifecycle(ServiceMBeanSupport.java:245)
	at sun.reflect.GeneratedMethodAccessor3.invoke(Unknown Source)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
	at java.lang.reflect.Method.invoke(Method.java:597)
	at org.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatcher.java:155)
	at org.jboss.mx.server.Invocation.dispatch(Invocation.java:94)
	at org.jboss.mx.server.Invocation.invoke(Invocation.java:86)

7 Respostas

Jair_Rillo_Junior

Amigo,

Deu para notar que você está estudando EJB 3 (eu mesmo já respondi várias perguntas suas), que ótimo para você. Porém antes de vir até o fórum perguntar, tenta dar uma pesquisada antes. De todas as perguntas que você perguntou, todas com um mínimo de pesquisa você iria encontrar a resposta rapidamente. Isso ajuda a deixar o fórum mais limpo :slight_smile:

Sobre a dúvida, o próprio erro já diz

Você tem uma tag <defaults> aberta porém não fechou ela.

P

Caros,

desculpas minha ignorância mas estou tentando configurar
o arquivo
standardjbosscmp-jdbc.xml

mas me da erro conforme abaixo como faço para configurar o banco oracle
nesse xml

quem puder me ajudar agradeceria…

abs

2008-09-10 14:53:18,828 DEBUG [org.jboss.util.NestedThrowable] org.jboss.util.NestedThrowable.nestedTraceEnabled=false
 2008-09-10 14:53:18,828 DEBUG [org.jboss.util.NestedThrowable] org.jboss.util.NestedThrowable.detectDuplicateNesting=true
 2008-09-10 14:53:18,843 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.metadata.MetaDataLibrary] Starting failed jboss.jdbc:service=metadata
 org.jboss.deployment.DeploymentException: Invalid XML: file=file:/C:/jboss-4.2.2.GA/server/default/conf/standardjbosscmp-jdbc.xml@6:20; - nested throwable: (org.xml.sax.SAXParseException: The element type "jbosscmp-jdbc" must be terminated by the matching end-tag "&lt;/jbosscmp-jdbc&gt;".)
 	at org.jboss.metadata.XmlFileLoader.getDocument(XmlFileLoader.java:342)
 	at org.jboss.metadata.XmlFileLoader.getDocument(XmlFileLoader.java:272)
 	at org.jboss.metadata.XmlFileLoader.getDocumentFromURL(XmlFileLoader.java:244)
 	at org.jboss.metadata.XmlFileLoader.getDocument(XmlFileLoader.java:228)
 	at org.jboss.ejb.plugins.cmp.jdbc.metadata.MetaDataLibrary.startService(MetaDataLibrary.java:79)
 	at org.jboss.system.ServiceMBeanSupport.jbossInternalStart(ServiceMBeanSupport.java:289)
 	at org.jboss.system.ServiceMBeanSupport.jbossInternalLifecycle(ServiceMBeanSupport.java:245)
 	at sun.reflect.GeneratedMethodAccessor3.invoke(Unknown Source)
 	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
 	at java.lang.reflect.Method.invoke(Method.java:597)
 	at org.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatcher.java:155)
 	at org.jboss.mx.server.Invocation.dispatch(Invocation.java:94)
 	at org.jboss.mx.server.Invocation.invoke(Invocation.java:86)
 	at org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:264)
 	at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:659)
 	at org.jboss.system.ServiceController$ServiceProxy.invoke(ServiceController.java:978)
 	at $Proxy0.start(Unknown Source)
 	at org.jboss.system.ServiceController.start(ServiceController.java:417)
 	at sun.reflect.GeneratedMethodAccessor9.invoke(Unknown Source)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.ja

o que quero configurar …

&lt;?xml version="1.0" encoding="UTF-8"?&gt;
 &lt;!DOCTYPE jbosscmp-jdbc PUBLIC
    "-//JBoss//DTD JBOSSCMP-JDBC 4.0//EN"
    "http://www.jboss.org/j2ee/dtd/jbosscmp-jdbc_4_0.dtd"&gt;
 
 &lt;!-- ===================================================================== --&gt;
 &lt;!--                                                                       --&gt;
 &lt;!--  Standard JBossCMP-JDBC Configuration                                 --&gt;
 &lt;!--                                                                       --&gt;
 &lt;!-- ===================================================================== --&gt;
 
 &lt;!-- $Id: standardjbosscmp-jdbc.xml 63355 2007-06-05 17:25:20Z rrajesh $ --&gt;
 
 &lt;jbosscmp-jdbc&gt;
 
 
 &lt;!--Inicio Novo --&gt;
    &lt;datasource&gt;java:/OracleDS&lt;/datasource&gt;
    &lt;datasource-mapping&gt;Oracle&lt;/datasource-mapping&gt;
    &lt;/datasources&gt;
 &lt;!--Fim Novo --&gt;
 
    &lt;defaults&gt;
 
       &lt;datasource&gt;java:/DefaultDS&lt;/datasource&gt;
       &lt;!-- optional since 4.0 &lt;datasource-mapping&gt;Hypersonic SQL&lt;/datasource-mapping&gt; --&gt;
 
       &lt;create-table&gt;true&lt;/create-table&gt;
       &lt;remove-table&gt;false&lt;/remove-table&gt;
       &lt;read-only&gt;false&lt;/read-only&gt;
       &lt;read-time-out&gt;300000&lt;/read-time-out&gt;
       &lt;row-locking&gt;false&lt;/row-locking&gt;
       &lt;pk-constraint&gt;true&lt;/pk-constraint&gt;
       &lt;fk-constraint&gt;false&lt;/fk-constraint&gt;
       &lt;preferred-relation-mapping&gt;foreign-key&lt;/preferred-relation-mapping&gt;
       &lt;read-ahead&gt;
          &lt;strategy&gt;on-load&lt;/strategy&gt;
          &lt;page-size&gt;1000&lt;/page-size&gt;
          &lt;eager-load-group&gt;*&lt;/eager-load-group&gt;
       &lt;/read-ahead&gt;
       &lt;list-cache-max&gt;1000&lt;/list-cache-max&gt;
       &lt;clean-read-ahead-on-load&gt;false&lt;/clean-read-ahead-on-load&gt;
 
       &lt;unknown-pk&gt;
          &lt;key-generator-factory&gt;UUIDKeyGeneratorFactory&lt;/key-generator-factory&gt;
          &lt;unknown-pk-class&gt;java.lang.String&lt;/unknown-pk-class&gt;
          &lt;jdbc-type&gt;VARCHAR&lt;/jdbc-type&gt;
          &lt;sql-type&gt;VARCHAR(32)&lt;/sql-type&gt;
       &lt;/unknown-pk&gt;
 
       &lt;entity-command name="default"/&gt;
       &lt;ql-compiler&gt;org.jboss.ejb.plugins.cmp.jdbc.JDBCEJBQLCompiler&lt;/ql-compiler&gt;
       &lt;throw-runtime-exceptions&gt;false&lt;/throw-runtime-exceptions&gt;
    &lt;/defaults&gt;
Jair_Rillo_Junior

Novamente,

Preste um pouco mais de atenção nos erros (e as mensagens que ele gera).

Essa mensagem parece familiar, não é?

P

ok mas por da esse erro então já que existe seu fim …

o arquivo todo então …para sua analise e conclusão :::::

&lt;!-- Inicio Novo --&gt;
&lt;jbosscmp-jdbc&gt;
   &lt;defaults&gt;
      &lt;datasource&gt;java:/OracleDS&lt;/datasource&gt;
      &lt;datasource-mapping&gt;Oracle&lt;/datasource-mapping&gt;
   &lt;/defaults&gt;
&lt;/jbosscmp-jdbc&gt; 
&lt;!-- Fim  Novo --&gt;

&lt;jbosscmp-jdbc&gt;


   &lt;defaults&gt;

      &lt;datasource&gt;java:/DefaultDS&lt;/datasource&gt;
      &lt;!-- optional since 4.0 &lt;datasource-mapping&gt;Hypersonic SQL&lt;/datasource-mapping&gt; --&gt;

      &lt;create-table&gt;true&lt;/create-table&gt;
      &lt;remove-table&gt;false&lt;/remove-table&gt;
      &lt;read-only&gt;false&lt;/read-only&gt;
      &lt;read-time-out&gt;300000&lt;/read-time-out&gt;
      &lt;row-locking&gt;false&lt;/row-locking&gt;
      &lt;pk-constraint&gt;true&lt;/pk-constraint&gt;
      &lt;fk-constraint&gt;false&lt;/fk-constraint&gt;
      &lt;preferred-relation-mapping&gt;foreign-key&lt;/preferred-relation-mapping&gt;
      &lt;read-ahead&gt;
         &lt;strategy&gt;on-load&lt;/strategy&gt;
         &lt;page-size&gt;1000&lt;/page-size&gt;
         &lt;eager-load-group&gt;*&lt;/eager-load-group&gt;
      &lt;/read-ahead&gt;
      &lt;list-cache-max&gt;1000&lt;/list-cache-max&gt;
      &lt;clean-read-ahead-on-load&gt;false&lt;/clean-read-ahead-on-load&gt;

      &lt;unknown-pk&gt;
         &lt;key-generator-factory&gt;UUIDKeyGeneratorFactory&lt;/key-generator-factory&gt;
         &lt;unknown-pk-class&gt;java.lang.String&lt;/unknown-pk-class&gt;
         &lt;jdbc-type&gt;VARCHAR&lt;/jdbc-type&gt;
         &lt;sql-type&gt;VARCHAR(32)&lt;/sql-type&gt;
      &lt;/unknown-pk&gt;

      &lt;entity-command name="default"/&gt;
      &lt;ql-compiler&gt;org.jboss.ejb.plugins.cmp.jdbc.JDBCEJBQLCompiler&lt;/ql-compiler&gt;
      &lt;throw-runtime-exceptions&gt;false&lt;/throw-runtime-exceptions&gt;
   &lt;/defaults&gt;

   &lt;type-mappings&gt;
      &lt;type-mapping&gt;
         &lt;name&gt;FirstSQL/J&lt;/name&gt;
         &lt;row-locking-template/&gt;
         &lt;pk-constraint-template&gt;PRIMARY KEY (?2)&lt;/pk-constraint-template&gt;
         &lt;fk-constraint-template&gt;FOREIGN KEY (?3) REFERENCES ?4 (?5)&lt;/fk-constraint-template&gt;
         &lt;alias-header-prefix&gt;t&lt;/alias-header-prefix&gt;
         &lt;alias-header-suffix&gt;_&lt;/alias-header-suffix&gt;
         &lt;alias-max-length&gt;32&lt;/alias-max-length&gt;
         &lt;subquery-supported&gt;true&lt;/subquery-supported&gt;
         &lt;true-mapping&gt;1&lt;/true-mapping&gt;
         &lt;false-mapping&gt;0&lt;/false-mapping&gt;

&lt;/jbosscmp-jdbc&gt;
Jair_Rillo_Junior

Cade o fechamando do <type-mapping> ? e o <type-mappings> ??

É falta de atenção

P

Olá amigo,

não é falta de atneção e sim não consigo enviar o arquivo todo pois dá erro …

Já verifiquei todas as aberturas de tab e seu fechamento postei esse pequeno codigo porque não deu erro …

O seguinte preciso de um exemplo do xml onde consigo definir o banco Oracle e o DefaultDS juntos …

Se puder me ajudar agradeço …

abs

Jair_Rillo_Junior

Se você quer saber como configurar um DataSource no JBoss, acho que o segiunte link pode te ajudar: http://jairrillo.wordpress.com/2008/05/14/how-to-setup-a-datasource-in-jboss-42-and-glassfish/

Criado 10 de setembro de 2008
Ultima resposta 10 de set. de 2008
Respostas 7
Participantes 2