You are viewing a plain text version of this content. The canonical link for it is here.
Posted to users@tomee.apache.org by mauro2java2011 <ma...@gmail.com> on 2014/02/10 12:32:50 UTC

org.apache.openjpa.lib.jdbc.ReportingSQLException - Tabella/Vista 'CONSULTANT_STATUS' non esiste.

Caused by:
org.apache.openjpa.lib.jdbc.ReportingSQLException - Tabella/Vista
'CONSULTANT_STATUS' non esiste. {SELECT t0.STATUS_ID, t0.DESCRIPTION FROM
CONSULTANT_STATUS t0} [code=-1, state=42X05]
at
org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator.wrap(LoggingConnectionDecorator.java:219)



--
View this message in context: http://openejb.979440.n4.nabble.com/org-apache-openjpa-lib-jdbc-ReportingSQLException-Tabella-Vista-CONSULTANT-STATUS-non-esiste-tp4667584.html
Sent from the OpenEJB User mailing list archive at Nabble.com.

Re: org.apache.openjpa.lib.jdbc.ReportingSQLException - Tabella/Vista 'CONSULTANT_STATUS' non esiste.

Posted by mauro2java2011 <ma...@gmail.com>.
https://github.com/maurojava/ConsultingRifattoTomeePrimefaces.git


2014-02-10 12:37 GMT+01:00 Romain Manni-Bucau [via OpenEJB] <
ml-node+s979440n4667585h10@n4.nabble.com>:

> Hmm
>
> is the question missing? did you create your table (using buildSchema?)?
> Romain Manni-Bucau
> Twitter: @rmannibucau
> Blog: http://rmannibucau.wordpress.com/
> LinkedIn: http://fr.linkedin.com/in/rmannibucau
> Github: https://github.com/rmannibucau
>
>
>
> 2014-02-10 12:32 GMT+01:00 mauro2java2011 <[hidden email]<http://user/SendEmail.jtp?type=node&node=4667585&i=0>>:
>
>
> > Caused by:
> > org.apache.openjpa.lib.jdbc.ReportingSQLException - Tabella/Vista
> > 'CONSULTANT_STATUS' non esiste. {SELECT t0.STATUS_ID, t0.DESCRIPTION
> FROM
> > CONSULTANT_STATUS t0} [code=-1, state=42X05]
> > at
> >
> org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator.wrap(LoggingConnectionDecorator.java:219)
>
> >
> >
> >
> > --
> > View this message in context:
> http://openejb.979440.n4.nabble.com/org-apache-openjpa-lib-jdbc-ReportingSQLException-Tabella-Vista-CONSULTANT-STATUS-non-esiste-tp4667584.html
> > Sent from the OpenEJB User mailing list archive at Nabble.com.
>
>
> ------------------------------
>  If you reply to this email, your message will be added to the discussion
> below:
>
> http://openejb.979440.n4.nabble.com/org-apache-openjpa-lib-jdbc-ReportingSQLException-Tabella-Vista-CONSULTANT-STATUS-non-esiste-tp4667584p4667585.html
>  To unsubscribe from org.apache.openjpa.lib.jdbc.ReportingSQLException -
> Tabella/Vista 'CONSULTANT_STATUS' non esiste., click here<http://openejb.979440.n4.nabble.com/template/NamlServlet.jtp?macro=unsubscribe_by_code&node=4667584&code=bWF1cm8yamF2YTIwMTFAZ21haWwuY29tfDQ2Njc1ODR8LTExMTcxODc2MjU=>
> .
> NAML<http://openejb.979440.n4.nabble.com/template/NamlServlet.jtp?macro=macro_viewer&id=instant_html%21nabble%3Aemail.naml&base=nabble.naml.namespaces.BasicNamespace-nabble.view.web.template.NabbleNamespace-nabble.view.web.template.NodeNamespace&breadcrumbs=notify_subscribers%21nabble%3Aemail.naml-instant_emails%21nabble%3Aemail.naml-send_instant_email%21nabble%3Aemail.naml>
>




--
View this message in context: http://openejb.979440.n4.nabble.com/org-apache-openjpa-lib-jdbc-ReportingSQLException-Tabella-Vista-CONSULTANT-STATUS-non-esiste-tp4667584p4667588.html
Sent from the OpenEJB User mailing list archive at Nabble.com.

Re: org.apache.openjpa.lib.jdbc.ReportingSQLException - Tabella/Vista 'CONSULTANT_STATUS' non esiste.

Posted by mauro2java2011 <ma...@gmail.com>.
yes ,

org.apache.myfaces.view.facelets.el.ContextAwareELException:
javax.el.ELException: Error reading 'items' on type
jsf.ConsultantStatusController$$OwbNormalScopeProxy0
	at
org.apache.myfaces.view.facelets.el.ContextAwareTagValueExpression.getValue(ContextAwareTagValueExpression.java:104)
	at javax.faces.component._DeltaStateHelper.eval(_DeltaStateHelper.java:249)
	at javax.faces.component.UIData.getValue(UIData.java:2036)
	at
org.primefaces.component.datatable.DataTable.getValue(DataTable.java:910)
	at org.primefaces.component.api.UIData.getDataModel(UIData.java:615)
	at org.primefaces.component.api.UIData.setRowModel(UIData.java:422)
	at org.primefaces.component.api.UIData.setRowIndex(UIData.java:414)
	at javax.faces.component.UIData.encodeEnd(UIData.java:1698)
	at org.primefaces.renderkit.CoreRenderer.renderChild(CoreRenderer.java:74)
	at
org.primefaces.renderkit.CoreRenderer.renderChildren(CoreRenderer.java:57)
	at
org.primefaces.component.panel.PanelRenderer.encodeContent(PanelRenderer.java:204)
	at
org.primefaces.component.panel.PanelRenderer.encodeMarkup(PanelRenderer.java:121)
	at
org.primefaces.component.panel.PanelRenderer.encodeEnd(PanelRenderer.java:58)
	at
javax.faces.component.UIComponentBase.encodeEnd(UIComponentBase.java:665)
	at org.primefaces.renderkit.CoreRenderer.renderChild(CoreRenderer.java:74)
	at
org.primefaces.renderkit.CoreRenderer.renderChildren(CoreRenderer.java:57)
	at org.primefaces.renderkit.CoreRenderer.renderChild(CoreRenderer.java:72)
	at
org.primefaces.renderkit.CoreRenderer.renderChildren(CoreRenderer.java:57)
	at
org.primefaces.component.layout.LayoutUnitRenderer.encodeEnd(LayoutUnitRenderer.java:51)
	at
javax.faces.component.UIComponentBase.encodeEnd(UIComponentBase.java:665)
	at
javax.faces.component.UIComponentBase.encodeAll(UIComponentBase.java:545)
	at
javax.faces.component.UIComponentBase.encodeAll(UIComponentBase.java:541)
	at
javax.faces.component.UIComponentBase.encodeAll(UIComponentBase.java:541)
	at
javax.faces.component.UIComponentBase.encodeAll(UIComponentBase.java:541)
	at
org.apache.myfaces.view.facelets.FaceletViewDeclarationLanguage.renderView(FaceletViewDeclarationLanguage.java:1981)
	at
org.apache.myfaces.application.ViewHandlerImpl.renderView(ViewHandlerImpl.java:305)
	at
javax.faces.application.ViewHandlerWrapper.renderView(ViewHandlerWrapper.java:59)
	at
org.apache.myfaces.lifecycle.RenderResponseExecutor.execute(RenderResponseExecutor.java:116)
	at
org.apache.myfaces.lifecycle.LifecycleImpl.render(LifecycleImpl.java:241)
	at javax.faces.webapp.FacesServlet.service(FacesServlet.java:199)
	at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:305)
	at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
	at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:51)
	at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243)
	at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
	at
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:222)
	at
org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:123)
	at org.apache.tomee.catalina.OpenEJBValve.invoke(OpenEJBValve.java:45)
	at
org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:502)
	at
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:171)
	at
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:100)
	at
org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:953)
	at
org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:118)
	at
org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:408)
	at
org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1041)
	at
org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:603)
	at
org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:310)
	at
java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
	at
java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
	at java.lang.Thread.run(Thread.java:724)
Caused by: javax.el.ELException: Error reading 'items' on type
jsf.ConsultantStatusController$$OwbNormalScopeProxy0
	at javax.el.BeanELResolver.getValue(BeanELResolver.java:68)
	at javax.el.CompositeELResolver.getValue(CompositeELResolver.java:58)
	at
org.apache.myfaces.el.unified.resolver.FacesCompositeELResolver.getValue(FacesCompositeELResolver.java:179)
	at org.apache.el.parser.AstValue.getValue(AstValue.java:183)
	at org.apache.el.ValueExpressionImpl.getValue(ValueExpressionImpl.java:185)
	at
org.apache.webbeans.el22.WrappedValueExpression.getValue(WrappedValueExpression.java:70)
	at
org.apache.myfaces.view.facelets.el.ContextAwareTagValueExpression.getValue(ContextAwareTagValueExpression.java:96)
	... 49 more
Caused by: javax.ejb.EJBException: The bean encountered a non-application
exception; nested exception is: 
	<openjpa-2.3.0-nonfinal-1540826-r422266:1542644 fatal general error>
org.apache.openjpa.persistence.PersistenceException: Tabella/Vista
'CONSULTANT_STATUS' non esiste. {SELECT t0.STATUS_ID, t0.DESCRIPTION FROM
CONSULTANT_STATUS t0} [code=-1, state=42X05]
	at
org.apache.openejb.core.ivm.BaseEjbProxyHandler.convertException(BaseEjbProxyHandler.java:403)
	at
org.apache.openejb.core.ivm.BaseEjbProxyHandler.invoke(BaseEjbProxyHandler.java:307)
	at
ejb.ConsultantStatusFacade$$LocalBeanProxy.findAll(ejb/ConsultantStatusFacade.java)
	at
jsf.ConsultantStatusController.getItems(ConsultantStatusController.java:79)
	at
jsf.ConsultantStatusController$$OwbNormalScopeProxy0.getItems(jsf/ConsultantStatusController.java)
	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
	at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
	at java.lang.reflect.Method.invoke(Method.java:606)
	at javax.el.BeanELResolver.getValue(BeanELResolver.java:64)
	... 55 more
Caused by: <openjpa-2.3.0-nonfinal-1540826-r422266:1542644 fatal general
error> org.apache.openjpa.persistence.PersistenceException: Tabella/Vista
'CONSULTANT_STATUS' non esiste. {SELECT t0.STATUS_ID, t0.DESCRIPTION FROM
CONSULTANT_STATUS t0} [code=-1, state=42X05]
	at org.apache.openjpa.jdbc.sql.DBDictionary.narrow(DBDictionary.java:4974)
	at
org.apache.openjpa.jdbc.sql.DBDictionary.newStoreException(DBDictionary.java:4934)
	at
org.apache.openjpa.jdbc.sql.SQLExceptions.getStore(SQLExceptions.java:134)
	at
org.apache.openjpa.jdbc.sql.SQLExceptions.getStore(SQLExceptions.java:116)
	at
org.apache.openjpa.jdbc.sql.SQLExceptions.getStore(SQLExceptions.java:68)
	at
org.apache.openjpa.jdbc.kernel.SelectResultObjectProvider.handleCheckedException(SelectResultObjectProvider.java:155)
	at
org.apache.openjpa.kernel.QueryImpl$PackingResultObjectProvider.handleCheckedException(QueryImpl.java:2111)
	at
org.apache.openjpa.lib.rop.EagerResultList.<init>(EagerResultList.java:40)
	at org.apache.openjpa.kernel.QueryImpl.toResult(QueryImpl.java:1251)
	at org.apache.openjpa.kernel.QueryImpl.execute(QueryImpl.java:1007)
	at org.apache.openjpa.kernel.QueryImpl.execute(QueryImpl.java:863)
	at org.apache.openjpa.kernel.QueryImpl.execute(QueryImpl.java:794)
	at
org.apache.openjpa.kernel.DelegatingQuery.execute(DelegatingQuery.java:542)
	at org.apache.openjpa.persistence.QueryImpl.execute(QueryImpl.java:275)
	at
org.apache.openjpa.persistence.QueryImpl.getResultList(QueryImpl.java:291)
	at ejb.AbstractFacade.findAll(AbstractFacade.java:44)
	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
	at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
	at java.lang.reflect.Method.invoke(Method.java:606)
	at
org.apache.openejb.core.interceptor.ReflectionInvocationContext$Invocation.invoke(ReflectionInvocationContext.java:182)
	at
org.apache.openejb.core.interceptor.ReflectionInvocationContext.proceed(ReflectionInvocationContext.java:164)
	at
org.apache.openejb.monitoring.StatsInterceptor.record(StatsInterceptor.java:180)
	at
org.apache.openejb.monitoring.StatsInterceptor.invoke(StatsInterceptor.java:99)
	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
	at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
	at java.lang.reflect.Method.invoke(Method.java:606)
	at
org.apache.openejb.core.interceptor.ReflectionInvocationContext$Invocation.invoke(ReflectionInvocationContext.java:182)
	at
org.apache.openejb.core.interceptor.ReflectionInvocationContext.proceed(ReflectionInvocationContext.java:164)
	at
org.apache.openejb.core.interceptor.InterceptorStack.invoke(InterceptorStack.java:80)
	at
org.apache.openejb.core.stateless.StatelessContainer._invoke(StatelessContainer.java:212)
	at
org.apache.openejb.core.stateless.StatelessContainer.invoke(StatelessContainer.java:181)
	at
org.apache.openejb.core.ivm.EjbObjectProxyHandler.synchronizedBusinessMethod(EjbObjectProxyHandler.java:268)
	at
org.apache.openejb.core.ivm.EjbObjectProxyHandler.businessMethod(EjbObjectProxyHandler.java:263)
	at
org.apache.openejb.core.ivm.EjbObjectProxyHandler._invoke(EjbObjectProxyHandler.java:86)
	at
org.apache.openejb.core.ivm.BaseEjbProxyHandler.invoke(BaseEjbProxyHandler.java:303)
	... 63 more
Caused by: org.apache.openjpa.lib.jdbc.ReportingSQLException: Tabella/Vista
'CONSULTANT_STATUS' non esiste. {SELECT t0.STATUS_ID, t0.DESCRIPTION FROM
CONSULTANT_STATUS t0} [code=-1, state=42X05]
	at
org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator.wrap(LoggingConnectionDecorator.java:219)
	at
org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator.wrap(LoggingConnectionDecorator.java:199)
	at
org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator.access$000(LoggingConnectionDecorator.java:59)
	at
org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator$LoggingConnection.prepareStatement(LoggingConnectionDecorator.java:251)
	at
org.apache.openjpa.lib.jdbc.DelegatingConnection.prepareStatement(DelegatingConnection.java:133)
	at
org.apache.openjpa.lib.jdbc.ConfiguringConnectionDecorator$ConfiguringConnection.prepareStatement(ConfiguringConnectionDecorator.java:140)
	at
org.apache.openjpa.lib.jdbc.DelegatingConnection.prepareStatement(DelegatingConnection.java:133)
	at
org.apache.openjpa.jdbc.kernel.JDBCStoreManager$RefCountConnection.prepareStatement(JDBCStoreManager.java:1643)
	at
org.apache.openjpa.lib.jdbc.DelegatingConnection.prepareStatement(DelegatingConnection.java:122)
	at
org.apache.openjpa.jdbc.sql.SQLBuffer.prepareStatement(SQLBuffer.java:508)
	at
org.apache.openjpa.jdbc.sql.SQLBuffer.prepareStatement(SQLBuffer.java:488)
	at
org.apache.openjpa.jdbc.sql.SelectImpl.prepareStatement(SelectImpl.java:481)
	at org.apache.openjpa.jdbc.sql.SelectImpl.execute(SelectImpl.java:422)
	at org.apache.openjpa.jdbc.sql.SelectImpl.execute(SelectImpl.java:393)
	at
org.apache.openjpa.jdbc.sql.LogicalUnion$UnionSelect.execute(LogicalUnion.java:427)
	at org.apache.openjpa.jdbc.sql.LogicalUnion.execute(LogicalUnion.java:230)
	at org.apache.openjpa.jdbc.sql.LogicalUnion.execute(LogicalUnion.java:220)
	at
org.apache.openjpa.jdbc.kernel.SelectResultObjectProvider.open(SelectResultObjectProvider.java:94)
	at
org.apache.openjpa.kernel.QueryImpl$PackingResultObjectProvider.open(QueryImpl.java:2070)
	at
org.apache.openjpa.lib.rop.EagerResultList.<init>(EagerResultList.java:34)
	... 92 more




--
View this message in context: http://openejb.979440.n4.nabble.com/org-apache-openjpa-lib-jdbc-ReportingSQLException-Tabella-Vista-CONSULTANT-STATUS-non-esiste-tp4667584p4667586.html
Sent from the OpenEJB User mailing list archive at Nabble.com.

Re: org.apache.openjpa.lib.jdbc.ReportingSQLException - Tabella/Vista 'CONSULTANT_STATUS' non esiste.

Posted by mauro2java2011 <ma...@gmail.com>.
Into the web-inf/resoyrces i have :
<resources>
?xml version="1.0" encoding="UTF-8"?>
<resources>
  <Resource id="jdbc/myconsultingManaged" type="javax.sql.DataSource">
        jdbcDriver org.apache.derby.jdbc.ClientDriver
        password app
        userName app
        jdbcUrl jdbc:derby://localhost:1527/consultDB
        JtaManaged true
    </Resource>

    <Resource id="jdbc/myconsultingUnmanaged" type="javax.sql.DataSource">
        jdbcDriver org.apache.derby.jdbc.ClientDriver
        password app
        userName app
        jdbcUrl jdbc:derby://localhost:1527/consultDB
        JtaManaged false

    </Resource>

</resources>

Then into persistence.xml

<?xml version="1.0" encoding="UTF-8"?>
<persistence version="2.0" xmlns="http://java.sun.com/xml/ns/persistence"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="
http://java.sun.com/xml/ns/persistence
http://java.sun.com/xml/ns/persistence/persistence_2_0.xsd">
  <persistence-unit name="ConsultingRifattoTomeePrimefacesPU"
transaction-type="JTA">
    <jta-data-source>jdbc/myconsultingManaged</jta-data-source>
    <non-jta-data-source>jdbc/myconsultingUnmanaged</non-jta-data-source>

    <exclude-unlisted-classes>false</exclude-unlisted-classes>
    <properties>

    </properties>
  </persistence-unit>
</persistence>


Il giorno 10/feb/2014 13.39, "agumbrecht [via OpenEJB]" <
ml-node+s979440n4667592h27@n4.nabble.com> ha scritto:

> How is your DataSource defined? The error is simply that the table does
> not exist, so maybe one of your DataSources is pointing at the wrong place?
>
> Andy.
>
> ------------------------------
>  If you reply to this email, your message will be added to the discussion
> below:
>
> http://openejb.979440.n4.nabble.com/org-apache-openjpa-lib-jdbc-ReportingSQLException-Tabella-Vista-CONSULTANT-STATUS-non-esiste-tp4667584p4667592.html
>  To unsubscribe from org.apache.openjpa.lib.jdbc.ReportingSQLException -
> Tabella/Vista 'CONSULTANT_STATUS' non esiste., click here<http://openejb.979440.n4.nabble.com/template/NamlServlet.jtp?macro=unsubscribe_by_code&node=4667584&code=bWF1cm8yamF2YTIwMTFAZ21haWwuY29tfDQ2Njc1ODR8LTExMTcxODc2MjU=>
> .
> NAML<http://openejb.979440.n4.nabble.com/template/NamlServlet.jtp?macro=macro_viewer&id=instant_html%21nabble%3Aemail.naml&base=nabble.naml.namespaces.BasicNamespace-nabble.view.web.template.NabbleNamespace-nabble.view.web.template.NodeNamespace&breadcrumbs=notify_subscribers%21nabble%3Aemail.naml-instant_emails%21nabble%3Aemail.naml-send_instant_email%21nabble%3Aemail.naml>
>




--
View this message in context: http://openejb.979440.n4.nabble.com/org-apache-openjpa-lib-jdbc-ReportingSQLException-Tabella-Vista-CONSULTANT-STATUS-non-esiste-tp4667584p4667597.html
Sent from the OpenEJB User mailing list archive at Nabble.com.

Re: org.apache.openjpa.lib.jdbc.ReportingSQLException - Tabella/Vista 'CONSULTANT_STATUS' non esiste.

Posted by agumbrecht <ag...@tomitribe.com>.
How is your DataSource defined? The error is simply that the table does not
exist, so maybe one of your DataSources is pointing at the wrong place?

Andy.



--
View this message in context: http://openejb.979440.n4.nabble.com/org-apache-openjpa-lib-jdbc-ReportingSQLException-Tabella-Vista-CONSULTANT-STATUS-non-esiste-tp4667584p4667592.html
Sent from the OpenEJB User mailing list archive at Nabble.com.

Re: org.apache.openjpa.lib.jdbc.ReportingSQLException - Tabella/Vista 'CONSULTANT_STATUS' non esiste.

Posted by mauro2java2011 <ma...@gmail.com>.
<?xml version="1.0" encoding="UTF-8"?>
<persistence version="2.0" xmlns="http://java.sun.com/xml/ns/persistence"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="
http://java.sun.com/xml/ns/persistence
http://java.sun.com/xml/ns/persistence/persistence_2_0.xsd">
  <persistence-unit name="ConsultingRifattoTomeePrimefacesPU"
transaction-type="JTA">

<provider>org.apache.openjpa.persistence.PersistenceProviderImpl</provider>
    <jta-data-source>jdbc/myconsultingManaged</jta-data-source>
    <non-jta-data-source>jdbc/myconsultingUnmanaged</non-jta-data-source>
    <exclude-unlisted-classes>false</exclude-unlisted-classes>
    <properties>
      <propertie/>
          <property name="openjpa.jdbc.SynchronizeMappings"
value="org.apache.openjpa.jdbc.sql.DerbyDictionary"/>
      <property name="openjpa.jdbc.DBDictionary"
value="buildSchema(ForeignKeys=true)"/>

    </properties>
  </persistence-unit>
</persistence>



2014-02-10 12:37 GMT+01:00 Romain Manni-Bucau [via OpenEJB] <
ml-node+s979440n4667585h10@n4.nabble.com>:

> Hmm
>
> is the question missing? did you create your table (using buildSchema?)?
> Romain Manni-Bucau
> Twitter: @rmannibucau
> Blog: http://rmannibucau.wordpress.com/
> LinkedIn: http://fr.linkedin.com/in/rmannibucau
> Github: https://github.com/rmannibucau
>
>
>
> 2014-02-10 12:32 GMT+01:00 mauro2java2011 <[hidden email]<http://user/SendEmail.jtp?type=node&node=4667585&i=0>>:
>
>
> > Caused by:
> > org.apache.openjpa.lib.jdbc.ReportingSQLException - Tabella/Vista
> > 'CONSULTANT_STATUS' non esiste. {SELECT t0.STATUS_ID, t0.DESCRIPTION
> FROM
> > CONSULTANT_STATUS t0} [code=-1, state=42X05]
> > at
> >
> org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator.wrap(LoggingConnectionDecorator.java:219)
>
> >
> >
> >
> > --
> > View this message in context:
> http://openejb.979440.n4.nabble.com/org-apache-openjpa-lib-jdbc-ReportingSQLException-Tabella-Vista-CONSULTANT-STATUS-non-esiste-tp4667584.html
> > Sent from the OpenEJB User mailing list archive at Nabble.com.
>
>
> ------------------------------
>  If you reply to this email, your message will be added to the discussion
> below:
>
> http://openejb.979440.n4.nabble.com/org-apache-openjpa-lib-jdbc-ReportingSQLException-Tabella-Vista-CONSULTANT-STATUS-non-esiste-tp4667584p4667585.html
>  To unsubscribe from org.apache.openjpa.lib.jdbc.ReportingSQLException -
> Tabella/Vista 'CONSULTANT_STATUS' non esiste., click here<http://openejb.979440.n4.nabble.com/template/NamlServlet.jtp?macro=unsubscribe_by_code&node=4667584&code=bWF1cm8yamF2YTIwMTFAZ21haWwuY29tfDQ2Njc1ODR8LTExMTcxODc2MjU=>
> .
> NAML<http://openejb.979440.n4.nabble.com/template/NamlServlet.jtp?macro=macro_viewer&id=instant_html%21nabble%3Aemail.naml&base=nabble.naml.namespaces.BasicNamespace-nabble.view.web.template.NabbleNamespace-nabble.view.web.template.NodeNamespace&breadcrumbs=notify_subscribers%21nabble%3Aemail.naml-instant_emails%21nabble%3Aemail.naml-send_instant_email%21nabble%3Aemail.naml>
>




--
View this message in context: http://openejb.979440.n4.nabble.com/org-apache-openjpa-lib-jdbc-ReportingSQLException-Tabella-Vista-CONSULTANT-STATUS-non-esiste-tp4667584p4667587.html
Sent from the OpenEJB User mailing list archive at Nabble.com.

Re: org.apache.openjpa.lib.jdbc.ReportingSQLException - Tabella/Vista 'CONSULTANT_STATUS' non esiste.

Posted by Romain Manni-Bucau <rm...@gmail.com>.
Hmm

is the question missing? did you create your table (using buildSchema?)?
Romain Manni-Bucau
Twitter: @rmannibucau
Blog: http://rmannibucau.wordpress.com/
LinkedIn: http://fr.linkedin.com/in/rmannibucau
Github: https://github.com/rmannibucau



2014-02-10 12:32 GMT+01:00 mauro2java2011 <ma...@gmail.com>:
> Caused by:
> org.apache.openjpa.lib.jdbc.ReportingSQLException - Tabella/Vista
> 'CONSULTANT_STATUS' non esiste. {SELECT t0.STATUS_ID, t0.DESCRIPTION FROM
> CONSULTANT_STATUS t0} [code=-1, state=42X05]
> at
> org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator.wrap(LoggingConnectionDecorator.java:219)
>
>
>
> --
> View this message in context: http://openejb.979440.n4.nabble.com/org-apache-openjpa-lib-jdbc-ReportingSQLException-Tabella-Vista-CONSULTANT-STATUS-non-esiste-tp4667584.html
> Sent from the OpenEJB User mailing list archive at Nabble.com.

Re: org.apache.openjpa.lib.jdbc.ReportingSQLException - Tabella/Vista 'CONSULTANT_STATUS' non esiste.

Posted by mauro2java2011 <ma...@gmail.com>.
fianlly it work . 
i have removed the resourcces.xml file with declaration of datasource and
put into tomee.xml 

<Resource id="jdbc-myconsultingManaged" type="javax.sql.DataSource">
        jdbcDriver org.apache.derby.jdbc.ClientDriver
        password app
        userName app
        jdbcUrl jdbc:derby://localhost:1527/consultDB
        JtaManaged true  
    </Resource>
    
    <Resource id="jdbc-myconsultingUnmanaged" type="javax.sql.DataSource">
        jdbcDriver org.apache.derby.jdbc.ClientDriver
        password app
        userName app
        jdbcUrl jdbc:derby://localhost:1527/consultDB
        JtaManaged false 
      </Resource>




--
View this message in context: http://openejb.979440.n4.nabble.com/org-apache-openjpa-lib-jdbc-ReportingSQLException-Tabella-Vista-CONSULTANT-STATUS-non-esiste-tp4667584p4667616.html
Sent from the OpenEJB User mailing list archive at Nabble.com.