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.