0 Replies Latest reply on Jun 19, 2008 5:12 AM by Armen Arzumanyan

    JPQL query tool not running

    Armen Arzumanyan Newbie

      https://jpaquerytool.dev.java.net/
      Hello people, I want to use console for JPQL I found
      https://jpaquerytool.dev.java.net/how-to.html
      and install it, but then I added my-app.jar and persistence unit name, after run I have one warning -
      "could not load persistance unit
      check your database classpath"....
      and
      Message Stack:
      No Persistence provider for EntityManager named TestPU: Provider named org.hibernate.ejb.HibernatePersistence threw unexpected exception at create EntityManagerFactory:
      javax.persistence.PersistenceException
      javax.persistence.PersistenceException: org.xml.sax.SAXParseException: XML document structures must start and end within the same entity.
      at org.hibernate.ejb.Ejb3Configuration.configure(Ejb3Configuration.java:252)
      at org.hibernate.ejb.HibernatePersistence.createEntityManagerFactory(HibernatePersistence.java:120)
      at javax.persistence.Persistence.createEntityManagerFactory(Persistence.java:110)
      at javax.persistence.Persistence.createEntityManagerFactory(Persistence.java:83)
      at org.morgade.jpaquerytool.core.EntityFinder.(EntityFinder.java:33)
      at org.morgade.jpaquerytool.gui.tasks.CreateEntityFinderTask.doInBackground(CreateEntityFinderTask.java:47)
      at org.jdesktop.swingworker.SwingWorker$1.call(Unknown Source)
      at java.util.concurrent.FutureTask$Sync.innerRun(Unknown Source)
      at java.util.concurrent.FutureTask.run(Unknown Source)
      at org.jdesktop.swingworker.SwingWorker.run(Unknown Source)
      at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(Unknown Source)
      at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
      at java.lang.Thread.run(Unknown Source)
      Caused by: org.xml.sax.SAXParseException: XML document structures must start and end within the same entity.
      at com.sun.org.apache.xerces.internal.parsers.DOMParser.parse(Unknown Source)
      at com.sun.org.apache.xerces.internal.jaxp.DocumentBuilderImpl.parse(Unknown Source)
      at org.hibernate.ejb.packaging.PersistenceXmlLoader.loadURL(PersistenceXmlLoader.java:70)
      at org.hibernate.ejb.packaging.PersistenceXmlLoader.deploy(PersistenceXmlLoader.java:79)
      at org.hibernate.ejb.Ejb3Configuration.configure(Ejb3Configuration.java:212)
      ... 12 more


      Provider named oracle.toplink.essentials.PersistenceProvider threw unexpected exception at create EntityManagerFactory:
      oracle.toplink.essentials.exceptions.PersistenceUnitLoadingException
      Local Exception Stack:
      Exception [TOPLINK-30005] (Oracle TopLink Essentials - 2.0 (Build b58g-fcs (09/07/2007))): oracle.toplink.essentials.exceptions.PersistenceUnitLoadingException
      Exception Description: An exception was thrown while searching for persistence archives with ClassLoader: sun.misc.Launcher$AppClassLoader@11b86e7
      Internal Exception: Exception [TOPLINK-30004] (Oracle TopLink Essentials - 2.0 (Build b58g-fcs (09/07/2007))): oracle.toplink.essentials.exceptions.PersistenceUnitLoadingException
      Exception Description: An exception was thrown while processing persistence.xml from URL: file:/E:/projects/wn/wn-ejb/dist/wn-ejb.jar
      Internal Exception:
      (1. cvc-complex-type.2.4.a: Invalid content was found starting with element 'persistence'. One of '{"http://java.sun.com/xml/ns/persistence" ersistence-unit}' is expected.)
      (2. XML document structures must start and end within the same entity.)
      at oracle.toplink.essentials.exceptions.PersistenceUnitLoadingException.exceptionSearchingForPersistenceResources(PersistenceUnitLoadingException.java:143)
      at oracle.toplink.essentials.ejb.cmp3.EntityManagerFactoryProvider.createEntityManagerFactory(EntityManagerFactoryProvider.java:169)
      at javax.persistence.Persistence.createEntityManagerFactory(Persistence.java:110)
      at javax.persistence.Persistence.createEntityManagerFactory(Persistence.java:83)
      at org.morgade.jpaquerytool.core.EntityFinder.(EntityFinder.java:33)
      at org.morgade.jpaquerytool.gui.tasks.CreateEntityFinderTask.doInBackground(CreateEntityFinderTask.java:47)
      at org.jdesktop.swingworker.SwingWorker$1.call(Unknown Source)
      at java.util.concurrent.FutureTask$Sync.innerRun(Unknown Source)
      at java.util.concurrent.FutureTask.run(Unknown Source)
      at org.jdesktop.swingworker.SwingWorker.run(Unknown Source)
      at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(Unknown Source)
      at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
      at java.lang.Thread.run(Unknown Source)
      Caused by: Exception [TOPLINK-30004] (Oracle TopLink Essentials - 2.0 (Build b58g-fcs (09/07/2007))): oracle.toplink.essentials.exceptions.PersistenceUnitLoadingException
      Exception Description: An exception was thrown while processing persistence.xml from URL: file:/E:/projects/wn/wn-ejb/dist/wn-ejb.jar
      Internal Exception:
      (1. cvc-complex-type.2.4.a: Invalid content was found starting with element 'persistence'. One of '{"http://java.sun.com/xml/ns/persistence" ersistence-unit}' is expected.)
      (2. XML document structures must start and end within the same entity.)
      at oracle.toplink.essentials.exceptions.PersistenceUnitLoadingException.exceptionProcessingPersistenceXML(PersistenceUnitLoadingException.java:134)
      at oracle.toplink.essentials.ejb.cmp3.persistence.PersistenceUnitProcessor.processPersistenceXML(PersistenceUnitProcessor.java:161)
      at oracle.toplink.essentials.ejb.cmp3.persistence.PersistenceUnitProcessor.processPersistenceArchive(PersistenceUnitProcessor.java:99)
      at oracle.toplink.essentials.ejb.cmp3.persistence.PersistenceUnitProcessor.getPersistenceUnits(PersistenceUnitProcessor.java:89)
      at oracle.toplink.essentials.internal.ejb.cmp3.JavaSECMPInitializer.initPersistenceUnits(JavaSECMPInitializer.java:236)
      at oracle.toplink.essentials.internal.ejb.cmp3.JavaSECMPInitializer.initialize(JavaSECMPInitializer.java:255)
      at oracle.toplink.essentials.ejb.cmp3.EntityManagerFactoryProvider.createEntityManagerFactory(EntityManagerFactoryProvider.java:155)
      ... 11 more
      Caused by:
      (1. cvc-complex-type.2.4.a: Invalid content was found starting with element 'persistence'. One of '{"http://java.sun.com/xml/ns/persistence" ersistence-unit}' is expected.)
      (2. XML document structures must start and end within the same entity.)
      at oracle.toplink.essentials.internal.ejb.cmp3.xml.parser.XMLExceptionHandler.error(XMLExceptionHandler.java:52)
      at com.sun.org.apache.xerces.internal.util.ErrorHandlerWrapper.error(Unknown Source)
      at com.sun.org.apache.xerces.internal.impl.XMLErrorReporter.reportError(Unknown Source)
      at com.sun.org.apache.xerces.internal.impl.XMLErrorReporter.reportError(Unknown Source)
      at com.sun.org.apache.xerces.internal.impl.xs.XMLSchemaValidator$XSIErrorReporter.reportError(Unknown Source)
      at com.sun.org.apache.xerces.internal.impl.xs.XMLSchemaValidator.reportSchemaError(Unknown Source)
      at com.sun.org.apache.xerces.internal.impl.xs.XMLSchemaValidator.handleStartElement(Unknown Source)
      at com.sun.org.apache.xerces.internal.impl.xs.XMLSchemaValidator.startElement(Unknown Source)
      at com.sun.org.apache.xerces.internal.impl.XMLNSDocumentScannerImpl.scanStartElement(Unknown Source)
      at com.sun.org.apache.xerces.internal.impl.XMLDocumentFragmentScannerImpl$FragmentContentDriver.next(Unknown Source)
      at com.sun.org.apache.xerces.internal.impl.XMLDocumentScannerImpl.next(Unknown Source)
      at com.sun.org.apache.xerces.internal.impl.XMLNSDocumentScannerImpl.next(Unknown Source)
      at com.sun.org.apache.xerces.internal.impl.XMLDocumentFragmentScannerImpl.scanDocument(Unknown Source)
      at com.sun.org.apache.xerces.internal.parsers.XML11Configuration.parse(Unknown Source)
      at com.sun.org.apache.xerces.internal.parsers.XML11Configuration.parse(Unknown Source)
      at com.sun.org.apache.xerces.internal.parsers.XMLParser.parse(Unknown Source)
      at com.sun.org.apache.xerces.internal.parsers.AbstractSAXParser.parse(Unknown Source)
      at com.sun.org.apache.xerces.internal.jaxp.SAXParserImpl$JAXPSAXParser.parse(Unknown Source)
      at oracle.toplink.essentials.ejb.cmp3.persistence.PersistenceUnitProcessor.processPersistenceXML(PersistenceUnitProcessor.java:151)
      ... 16 more

      -----------
      All this for all my persistance units!

      If you know cause of this problem please help me, or
      provide other JPQL or JPA query tool.
      More Thanks