Datasource Problem

Gelöschtes Mitglied 5909 · 28. Nov 2008

Zur Zeit hänge ich an einem Problem das ich nicht ganz versteh:

Ich verwende innerhalb von Glassfish OpenJPA da OpenJPA h2 unterstützt und ich diese db gerne verwenden würde (sind auch schon einige Daten drinn, die ich nur ungern neu eingebe).

Er Versucht ständig den org.h2.Driver in eine Datasource zu Casten, was natürlich um die Ohren fliegt.

Meine Konfiguration:

persistence.xml

Code:

<?xml version="1.0" encoding="UTF-8"?>
<persistence version="1.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_1_0.xsd">
  <persistence-unit name="webshop">
    <provider>org.apache.openjpa.persistence.PersistenceProviderImpl</provider>
    <jta-data-source>h2db</jta-data-source>
    <class>de.mas.ejb.persistence.Article</class>
    <class>de.mas.ejb.persistence.Tag</class>
    <class>de.mas.ejb.persistence.Category</class>
    <class>de.mas.ejb.persistence.User</class>
    <class>de.mas.ejb.persistence.Person</class>
    <class>de.mas.ejb.persistence.Order</class>
    <properties>
      <property name="openjpa.jdbc.DBDictionary" value="org.apache.openjpa.jdbc.sql.H2Dictionary"/>
      <property name="openjpa.ConnectionURL" value="jdbc:h2:tcp://localhost/db/data"/>
      <property name="openjpa.ConnectionDriverName" value="org.h2.Driver"/>
      <property name="openjpa.ConnectionUserName" value="sa"/>
      <property name="openjpa.ConnectionPassword" value="sa"/>
      <property name="openjpa.NontransactionalWrite" value="false"/>
      <property name="openjpa.Log" value="DefaultLevel=TRACE,Tool=TRACE"/>
      <property name="openjpa.jdbc.SynchronizeMappings" value="buildSchema(ForeignKeys=true)"/>
    </properties>
  </persistence-unit>
</persistence>

sun-resources.xml

Code:

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE resources PUBLIC "-//Sun Microsystems, Inc.//DTD Application Server 9.0 Resource Definitions //EN" "http://www.sun.com/software/appserver/dtds/sun-resources_1_3.dtd">
<resources>
  <jdbc-resource enabled="true" jndi-name="h2db" object-type="user" pool-name="jdbc_h2_tcp_localhost_db_dataPool"/>
  <jdbc-connection-pool allow-non-component-callers="false" associate-with-thread="false" 
connection-creation-retry-attempts="0" connection-creation-retry-interval-in-seconds="10" connection-leak-reclaim="false" 
connection-leak-timeout-in-seconds="0" connection-validation-method="auto-commit" datasource-classname="org.h2.Driver"
 fail-all-connections="false" idle-timeout-in-seconds="300" is-connection-validation-required="false" is-isolation-level-guaranteed="true"
 lazy-connection-association="false" lazy-connection-enlistment="false" match-connections="false" max-connection-usage-count="0"
 max-pool-size="32" max-wait-time-in-millis="60000" name="jdbc_h2_tcp_localhost_db_dataPool" non-transactional-connections="false" 
pool-resize-quantity="2" res-type="javax.sql.DataSource" statement-timeout-in-seconds="-1" 
steady-pool-size="8" validate-atmost-once-period-in-seconds="0" wrap-jdbc-objects="false">
    <property name="User" value="SA"/>
    <property name="Password" value="sa"/>
    <property name="URL" value="jdbc:h2:tcp://localhost/db/data"/>
    <property name="driverClass" value="org.h2.Driver"/>
  </jdbc-connection-pool>
</resources>

ejb-konfiguration in der web.xml

Code:

    <ejb-local-ref>
        <ejb-ref-name>browse</ejb-ref-name>
        <ejb-ref-type>Session</ejb-ref-type>
        <local-home/>
        <local>de.mas.ejb.session.BrowseLocal</local>
        <ejb-link>de.mas.ejb.session.Browse</ejb-link>
    </ejb-local-ref>
    <ejb-local-ref>
        <ejb-ref-name>cart</ejb-ref-name>
        <ejb-ref-type>Session</ejb-ref-type>
        <local-home/>
        <local>de.mas.ejb.session.ShoppingCartLocal</local>
        <ejb-link>de.mas.ejb.session.ShoppingCart</ejb-link>
    </ejb-local-ref>
    <ejb-local-ref>
        <ejb-ref-name>userManager</ejb-ref-name>
        <ejb-ref-type>Session</ejb-ref-type>


        <local-home/>
        <local>de.mas.ejb.session.UserManagerLocal</local>
        <ejb-link>de.mas.ejb.session.UserManager</ejb-link>
    </ejb-local-ref>

hier habe ich was ähliches gefunden:
http://www.marciowb.net/blog/2008/08/quickly-using-h2-database-with

aber wenn ich Toplink verwende dann muss ich meine Entities wieder ändern so wie es aussieht und meine Daten sind warscheinlich unbrauchbar.

Die h2 Datenbank starte ich manuell und sie ist auch auf jeden fall aktiv.

Die ganze Exception:

1066531 webshop TRACE [httpSSLWorkerThread-8084-0] openjpa.MetaData - "de.mas.ejb.persistence.Order" has mapping strategy "full".
1066531 webshop TRACE [httpSSLWorkerThread-8084-0] openjpa.MetaData - Resolving field "de.mas.ejb.persistence.Order@4115458.article".
1066531 webshop TRACE [httpSSLWorkerThread-8084-0] openjpa.MetaData - "article" has mapping strategy "org.apache.openjpa.jdbc.meta.strats.RelationFieldStrategy".
1066531 webshop TRACE [httpSSLWorkerThread-8084-0] openjpa.MetaData - Resolving field "de.mas.ejb.persistence.Order@4115458.user".
1066531 webshop TRACE [httpSSLWorkerThread-8084-0] openjpa.MetaData - "user" has mapping strategy "org.apache.openjpa.jdbc.meta.strats.RelationFieldStrategy".
1066531 webshop TRACE [httpSSLWorkerThread-8084-0] openjpa.jdbc.JDBC - DataSource connection setAutoCommit to "true"
RAR5111 : Fehler beim Umwandeln in javax.sql.Datasource :{0}
java.lang.ClassCastException: org.h2.Driver cannot be cast to javax.sql.DataSource
at com.sun.gjc.spi.DSManagedConnectionFactory.getDataSource(DSManagedConnectionFactory.java:139)
at com.sun.gjc.spi.DSManagedConnectionFactory.createManagedConnection(DSManagedConnectionFactory.java:93)
at com.sun.enterprise.resource.LocalTxConnectorAllocator.createResource(LocalTxConnectorAllocator.java:68)
at com.sun.enterprise.resource.AbstractResourcePool.createSingleResource(AbstractResourcePool.java:891)
at com.sun.enterprise.resource.AbstractResourcePool.createResourceAndAddToPool(AbstractResourcePool.java:1752)
at com.sun.enterprise.resource.AbstractResourcePool.createResources(AbstractResourcePool.java:917)
at com.sun.enterprise.resource.AbstractResourcePool.initPool(AbstractResourcePool.java:225)
at com.sun.enterprise.resource.AbstractResourcePool.internalGetResource(AbstractResourcePool.java:516)
at com.sun.enterprise.resource.AbstractResourcePool.getResource(AbstractResourcePool.java:443)
at com.sun.enterprise.resource.PoolManagerImpl.getResourceFromPool(PoolManagerImpl.java:248)
at com.sun.enterprise.resource.PoolManagerImpl.getResource(PoolManagerImpl.java:176)
at com.sun.enterprise.connectors.ConnectionManagerImpl.internalGetConnection(ConnectionManagerImpl.java:327)
at com.sun.enterprise.connectors.ConnectionManagerImpl.allocateConnection(ConnectionManagerImpl.java:189)
at com.sun.enterprise.connectors.ConnectionManagerImpl.allocateConnection(ConnectionManagerImpl.java:165)
at com.sun.enterprise.connectors.ConnectionManagerImpl.allocateConnection(ConnectionManagerImpl.java:158)
at com.sun.gjc.spi.base.DataSource.getConnection(DataSource.java:108)
at org.apache.openjpa.lib.jdbc.DelegatingDataSource.getConnection(DelegatingDataSource.java:112)
at org.apache.openjpa.lib.jdbc.DecoratingDataSource.getConnection(DecoratingDataSource.java:93)
at org.apache.openjpa.jdbc.schema.DataSourceFactory.installDBDictionary(DataSourceFactory.java:237)
at org.apache.openjpa.jdbc.conf.JDBCConfigurationImpl.getConnectionFactory2(JDBCConfigurationImpl.java:752)
at org.apache.openjpa.jdbc.conf.JDBCConfigurationImpl.getDataSource2(JDBCConfigurationImpl.java:795)
at org.apache.openjpa.jdbc.schema.SchemaTool.<init>(SchemaTool.java:127)
at org.apache.openjpa.jdbc.meta.MappingTool.newSchemaTool(MappingTool.java:310)
at org.apache.openjpa.jdbc.meta.MappingTool.record(MappingTool.java:490)
at org.apache.openjpa.jdbc.meta.MappingTool.record(MappingTool.java:453)
at org.apache.openjpa.jdbc.kernel.JDBCBrokerFactory.synchronizeMappings(JDBCBrokerFactory.java:159)
at org.apache.openjpa.jdbc.kernel.JDBCBrokerFactory.newBrokerImpl(JDBCBrokerFactory.java:119)
at org.apache.openjpa.kernel.AbstractBrokerFactory.newBroker(AbstractBrokerFactory.java:189)
at org.apache.openjpa.kernel.DelegatingBrokerFactory.newBroker(DelegatingBrokerFactory.java:142)
at org.apache.openjpa.persistence.EntityManagerFactoryImpl.createEntityManager(EntityManagerFactoryImpl.java:192)
at org.apache.openjpa.persistence.EntityManagerFactoryImpl.createEntityManager(EntityManagerFactoryImpl.java:56)
at com.sun.enterprise.util.EntityManagerWrapper._getDelegate(EntityManagerWrapper.java:326)
at com.sun.enterprise.util.EntityManagerWrapper.createQuery(EntityManagerWrapper.java:660)
at de.mas.ejb.session.Browse.getAllCategories(Browse.java:63)
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 com.sun.enterprise.security.application.EJBSecurityManager.runMethod(EJBSecurityManager.java:1067)
at com.sun.enterprise.security.SecurityUtil.invoke(SecurityUtil.java:176)
at com.sun.ejb.containers.BaseContainer.invokeTargetBeanMethod(BaseContainer.java:2895)
at com.sun.ejb.containers.BaseContainer.intercept(BaseContainer.java:3986)
at com.sun.ejb.containers.EJBLocalObjectInvocationHandler.invoke(EJBLocalObjectInvocationHandler.java:197)
at com.sun.ejb.containers.EJBLocalObjectInvocationHandlerDelegate.invoke(EJBLocalObjectInvocationHandlerDelegate.java:127)
at $Proxy76.getAllCategories(Unknown Source)
at BrowseServlet.processRequest(BrowseServlet.java:51)
at BrowseServlet.doGet(BrowseServlet.java:110)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:718)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:831)
at org.apache.catalina.core.ApplicationFilterChain.servletService(ApplicationFilterChain.java:411)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:317)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:198)
at org.netbeans.modules.web.monitor.server.MonitorFilter.doFilter(MonitorFilter.java:390)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:230)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:198)
at org.apache.catalina.core.ApplicationDispatcher.doInvoke(ApplicationDispatcher.java:853)
at org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:703)
at org.apache.catalina.core.ApplicationDispatcher.processRequest(ApplicationDispatcher.java:542)
at org.apache.catalina.core.ApplicationDispatcher.doForward(ApplicationDispatcher.java:474)
at org.apache.catalina.core.ApplicationDispatcher.forward(ApplicationDispatcher.java:366)
at org.apache.jasper.runtime.PageContextImpl.forward(PageContextImpl.java:767)
at org.apache.jsp.index_jsp._jspService(index_jsp.java from :61)
at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:93)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:831)
at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:373)
at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:470)
at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:364)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:831)
at org.apache.catalina.core.ApplicationFilterChain.servletService(ApplicationFilterChain.java:411)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:317)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:198)
at org.netbeans.modules.web.monitor.server.MonitorFilter.doFilter(MonitorFilter.java:390)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:230)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:198)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:288)
at org.apache.catalina.core.StandardContextValve.invokeInternal(StandardContextValve.java:271)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:202)
at org.apache.catalina.core.StandardPipeline.doInvoke(StandardPipeline.java:632)
at org.apache.catalina.core.StandardPipeline.doInvoke(StandardPipeline.java:577)
at com.sun.enterprise.web.WebPipeline.invoke(WebPipeline.java:94)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:206)
at org.apache.catalina.core.StandardPipeline.doInvoke(StandardPipeline.java:632)
at org.apache.catalina.core.StandardPipeline.doInvoke(StandardPipeline.java:577)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:571)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:1080)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:150)
at org.apache.catalina.core.StandardPipeline.doInvoke(StandardPipeline.java:632)
at org.apache.catalina.core.StandardPipeline.doInvoke(StandardPipeline.java:577)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:571)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:1080)
at org.apache.coyote.tomcat5.CoyoteAdapter.service(CoyoteAdapter.java:272)
at com.sun.enterprise.web.connector.grizzly.DefaultProcessorTask.invokeAdapter(DefaultProcessorTask.java:637)
at com.sun.enterprise.web.connector.grizzly.DefaultProcessorTask.doProcess(DefaultProcessorTask.java:568)
at com.sun.enterprise.web.connector.grizzly.DefaultProcessorTask.process(DefaultProcessorTask.java:813)
at com.sun.enterprise.web.connector.grizzly.DefaultReadTask.executeProcessorTask(DefaultReadTask.java:341)
at com.sun.enterprise.web.connector.grizzly.DefaultReadTask.doTask(DefaultReadTask.java:263)
at com.sun.enterprise.web.connector.grizzly.DefaultReadTask.doTask(DefaultReadTask.java:214)
at com.sun.enterprise.web.connector.grizzly.TaskBase.run(TaskBase.java:265)
at com.sun.enterprise.web.connector.grizzly.ssl.SSLWorkerThread.run(SSLWorkerThread.java:106)
RAR5038:Unerwarteter Ausnahmefehler beim Erstellen der Ressource für Pool jdbc_h2_tcp_localhost_db_dataPool. Ausnahmefehler : org.h2.Driver cannot be cast to javax.sql.DataSource
RAR5117 : Verbindung von Verbindungspool [ jdbc_h2_tcp_localhost_db_dataPool ] konnte nicht abgerufen/hergestellt werden. Grund: org.h2.Driver cannot be cast to javax.sql.DataSource
RAR5114 : Fehler beim Zuweisen der Verbindung : [Fehler beim Zuweisen einer Verbindung. Ursache: org.h2.Driver cannot be cast to javax.sql.DataSource]
<openjpa-1.2.0-r422266:683325 fatal user error> org.apache.openjpa.persistence.ArgumentException: A connection could not be obtained for driver class "null" and URL "null". You may have specified an invalid URL.
at org.apache.openjpa.jdbc.schema.DataSourceFactory.newConnectException(DataSourceFactory.java:256)
at org.apache.openjpa.jdbc.schema.DataSourceFactory.installDBDictionary(DataSourceFactory.java:242)
at org.apache.openjpa.jdbc.conf.JDBCConfigurationImpl.getConnectionFactory2(JDBCConfigurationImpl.java:752)
at org.apache.openjpa.jdbc.conf.JDBCConfigurationImpl.getDataSource2(JDBCConfigurationImpl.java:795)
at org.apache.openjpa.jdbc.schema.SchemaTool.<init>(SchemaTool.java:127)
at org.apache.openjpa.jdbc.meta.MappingTool.newSchemaTool(MappingTool.java:310)
at org.apache.openjpa.jdbc.meta.MappingTool.record(MappingTool.java:490)
at org.apache.openjpa.jdbc.meta.MappingTool.record(MappingTool.java:453)
at org.apache.openjpa.jdbc.kernel.JDBCBrokerFactory.synchronizeMappings(JDBCBrokerFactory.java:159)
at org.apache.openjpa.jdbc.kernel.JDBCBrokerFactory.newBrokerImpl(JDBCBrokerFactory.java:119)
at org.apache.openjpa.kernel.AbstractBrokerFactory.newBroker(AbstractBrokerFactory.java:189)
at org.apache.openjpa.kernel.DelegatingBrokerFactory.newBroker(DelegatingBrokerFactory.java:142)
at org.apache.openjpa.persistence.EntityManagerFactoryImpl.createEntityManager(EntityManagerFactoryImpl.java:192)
at org.apache.openjpa.persistence.EntityManagerFactoryImpl.createEntityManager(EntityManagerFactoryImpl.java:56)
at com.sun.enterprise.util.EntityManagerWrapper._getDelegate(EntityManagerWrapper.java:326)
at com.sun.enterprise.util.EntityManagerWrapper.createQuery(EntityManagerWrapper.java:660)
at de.mas.ejb.session.Browse.getAllCategories(Browse.java:63)
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 com.sun.enterprise.security.application.EJBSecurityManager.runMethod(EJBSecurityManager.java:1067)
at com.sun.enterprise.security.SecurityUtil.invoke(SecurityUtil.java:176)
at com.sun.ejb.containers.BaseContainer.invokeTargetBeanMethod(BaseContainer.java:2895)
at com.sun.ejb.containers.BaseContainer.intercept(BaseContainer.java:3986)
at com.sun.ejb.containers.EJBLocalObjectInvocationHandler.invoke(EJBLocalObjectInvocationHandler.java:197)
at com.sun.ejb.containers.EJBLocalObjectInvocationHandlerDelegate.invoke(EJBLocalObjectInvocationHandlerDelegate.java:127)
at $Proxy76.getAllCategories(Unknown Source)
at BrowseServlet.processRequest(BrowseServlet.java:51)
at BrowseServlet.doGet(BrowseServlet.java:110)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:718)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:831)
at org.apache.catalina.core.ApplicationFilterChain.servletService(ApplicationFilterChain.java:411)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:317)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:198)
at org.netbeans.modules.web.monitor.server.MonitorFilter.doFilter(MonitorFilter.java:390)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:230)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:198)
at org.apache.catalina.core.ApplicationDispatcher.doInvoke(ApplicationDispatcher.java:853)
at org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:703)
at org.apache.catalina.core.ApplicationDispatcher.processRequest(ApplicationDispatcher.java:542)
at org.apache.catalina.core.ApplicationDispatcher.doForward(ApplicationDispatcher.java:474)
at org.apache.catalina.core.ApplicationDispatcher.forward(ApplicationDispatcher.java:366)
at org.apache.jasper.runtime.PageContextImpl.forward(PageContextImpl.java:767)
at org.apache.jsp.index_jsp._jspService(index_jsp.java from :61)
at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:93)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:831)
at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:373)
at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:470)
at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:364)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:831)
at org.apache.catalina.core.ApplicationFilterChain.servletService(ApplicationFilterChain.java:411)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:317)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:198)
at org.netbeans.modules.web.monitor.server.MonitorFilter.doFilter(MonitorFilter.java:390)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:230)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:198)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:288)
at org.apache.catalina.core.StandardContextValve.invokeInternal(StandardContextValve.java:271)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:202)
at org.apache.catalina.core.StandardPipeline.doInvoke(StandardPipeline.java:632)
at org.apache.catalina.core.StandardPipeline.doInvoke(StandardPipeline.java:577)
at com.sun.enterprise.web.WebPipeline.invoke(WebPipeline.java:94)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:206)
at org.apache.catalina.core.StandardPipeline.doInvoke(StandardPipeline.java:632)
at org.apache.catalina.core.StandardPipeline.doInvoke(StandardPipeline.java:577)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:571)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:1080)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:150)
at org.apache.catalina.core.StandardPipeline.doInvoke(StandardPipeline.java:632)
at org.apache.catalina.core.StandardPipeline.doInvoke(StandardPipeline.java:577)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:571)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:1080)
at org.apache.coyote.tomcat5.CoyoteAdapter.service(CoyoteAdapter.java:272)
at com.sun.enterprise.web.connector.grizzly.DefaultProcessorTask.invokeAdapter(DefaultProcessorTask.java:637)
at com.sun.enterprise.web.connector.grizzly.DefaultProcessorTask.doProcess(DefaultProcessorTask.java:568)
at com.sun.enterprise.web.connector.grizzly.DefaultProcessorTask.process(DefaultProcessorTask.java:813)
at com.sun.enterprise.web.connector.grizzly.DefaultReadTask.executeProcessorTask(DefaultReadTask.java:341)
at com.sun.enterprise.web.connector.grizzly.DefaultReadTask.doTask(DefaultReadTask.java:263)
at com.sun.enterprise.web.connector.grizzly.DefaultReadTask.doTask(DefaultReadTask.java:214)
at com.sun.enterprise.web.connector.grizzly.TaskBase.run(TaskBase.java:265)
at com.sun.enterprise.web.connector.grizzly.ssl.SSLWorkerThread.run(SSLWorkerThread.java:106)
Caused by: java.sql.SQLException: Fehler beim Zuweisen einer Verbindung. Ursache: org.h2.Driver cannot be cast to javax.sql.DataSource
at com.sun.gjc.spi.base.DataSource.getConnection(DataSource.java:115)
at org.apache.openjpa.lib.jdbc.DelegatingDataSource.getConnection(DelegatingDataSource.java:112)
at org.apache.openjpa.lib.jdbc.DecoratingDataSource.getConnection(DecoratingDataSource.java:93)
at org.apache.openjpa.jdbc.schema.DataSourceFactory.installDBDictionary(DataSourceFactory.java:237)
... 80 more

Ich habe oben Extra noch ein bischen von JPA Trace mit angehängt, weil es so aussieht als würde er schon auf die Datenbank zugreifen und die Entities auflösen und dann knallst...

Ich hoffe mir kann jemand helfen, besten Dank im vorraus.

Gelöschtes Mitglied 5909 · 28. Nov 2008

Oh Mann bin ich blind...

datasource-classname="org.h2.jdbcx.JdbcDataSource"
res-type="org.h2.jdbcx.JdbcDataSource"

in der sun-resources.xml und es geht.

Jetzt hab ich schon ein weiteres Problem:

Der Container verwaltet jetzt automatisch für mich die Transationen und schon gibts n Problem:

javax.ejb.EJBException: Transaction aborted; nested exception is: javax.transaction.RollbackException: Transaktion für Zurücksetzung markiert.
at com.sun.ejb.containers.BaseContainer.completeNewTx(BaseContainer.java:3798)
at com.sun.ejb.containers.BaseContainer.postInvokeTx(BaseContainer.java:3571)
at com.sun.ejb.containers.StatefulSessionContainer.postInvokeTx(StatefulSessionContainer.java:2714)
at com.sun.ejb.containers.BaseContainer.postInvoke(BaseContainer.java:1354)
at com.sun.ejb.containers.BaseContainer.postInvoke(BaseContainer.java:1316)
at com.sun.ejb.containers.EJBLocalObjectInvocationHandler.invoke(EJBLocalObjectInvocationHandler.java:205)
at com.sun.ejb.containers.EJBLocalObjectInvocationHandlerDelegate.invoke(EJBLocalObjectInvocationHandlerDelegate.java:127)
at $Proxy125.purchase(Unknown Source)
at CartServlet.processRequest(CartServlet.java:56)
at CartServlet.doGet(CartServlet.java:98)

CartServlet:

Code:

                if (cart.getUser() != null) {
                    sucess = cart.purchase();                    
                }

Cart-EJB:

Code:

@Stateful
@TransactionManagement(TransactionManagementType.CONTAINER)
public class ShoppingCart implements ShoppingCartLocal, Serializable {

    @PersistenceContext(unitName="webshop")
    private EntityManager   entityManager;

// ...
    public boolean purchase() {
        try {
            User found = entityManager.find(User.class, this.user.getId());
            if (found == null) return false;
            for (Order order : orders) {
                order.setUser(found);
                entityManager.persist(order);
            }
        } catch(Exception e) {
            e.printStackTrace();
            return false;
        }
        return true;
    }
}

// EDIT

Problem gelöst merge statt persist, komisch nur dass es vorher ging

	Titel	Forum	Antworten	Datum
E	JBoss 7.1 Datasource Problem	Allgemeines EE	2	9. Jun 2012
S	JDBC Mysql Connection Problem - datasource null	Allgemeines EE	3	27. Mrz 2007
B	Tomcat, JNDI und datasource - Konfiguartion	Allgemeines EE	2	17. Apr 2011
G	JBoss Datasource	Allgemeines EE	3	28. Jul 2010
S	Oracle DataSource im JBOSS ---> ClassCastException	Allgemeines EE	2	9. Apr 2008
J	Tomcat: "Unable to get connection, DataSource invalid&q	Allgemeines EE	8	1. Jan 2008
B	DataSource	Allgemeines EE	4	23. Okt 2007
T	jndi & tomcat & datasource	Allgemeines EE	3	29. Jul 2005
D	Problem mit Update von ApacheHttpClient von 5.2 auf 5.3	Allgemeines EE	10	9. Apr 2024
D	Problem mit redundanten Servern	Allgemeines EE	7	10. Okt 2022
	JSF: Problem bei der einfachsten Applikation	Allgemeines EE	2	21. Okt 2020
P	JPA Internal Problem Nullpointer	Allgemeines EE	10	6. Aug 2018
S	MessageDrivenBean Problem beim Zugriff auf Stateful EJB	Allgemeines EE	2	18. Mrz 2015
M	Glassfish Deployment-Problem unter Eclipse	Allgemeines EE	0	4. Feb 2015
B	Problem beim Lesen des Codes...	Allgemeines EE	2	8. Nov 2014
R	JPA Problem beim Speichern eines Users	Allgemeines EE	2	16. Jul 2014
S	WebSocket Problem	Allgemeines EE	0	12. Mrz 2014
F	Eclipse/Java EE Debug-Problem	Allgemeines EE	1	11. Feb 2014
G	Problem: Servlet in JSP einbinden mit <jsp:include>	Allgemeines EE	3	10. Dez 2013
	[SEAM] rich:dataTable sortBy Problem	Allgemeines EE	6	13. Nov 2012
T	Problem mit den Beispielen von Apache	Allgemeines EE	5	18. Jul 2012
W	JSF Validator Problem HTTP Status 500	Allgemeines EE	2	15. Jul 2012
M	JSP Problem -unbestimmte Anzahl von Werten Transportieren	Allgemeines EE	9	9. Feb 2012
S	Problem mit EJB Verständnis	Allgemeines EE	4	23. Dez 2011
B	Problem beim einbinden einer CSS in eine JSP	Allgemeines EE	8	16. Nov 2011
F	JSP Problem mit Datenbankanbindung über Glassfishserver	Allgemeines EE	4	7. Okt 2011
S	java Entities Problem	Allgemeines EE	19	20. Sep 2011
S	Embedded JBoss Problem beim Deployment	Allgemeines EE	4	6. Jun 2011
E	Session Problem	Allgemeines EE	9	18. Dez 2010
F	problem mit nullpointer bei DB zugriff	Allgemeines EE	2	8. Nov 2010
A	Erste Schritte... Problem mit Hibernate	Allgemeines EE	15	22. Okt 2010
	jboss problem - work-verzeichnis muss manuell gelöscht werden???	Allgemeines EE	5	14. Okt 2010
	sendRedirect Problem!	Allgemeines EE	3	5. Okt 2010
M	Problem mit Lookup auf EJB3 mit Glassfish	Allgemeines EE	11	12. Mai 2010
0	Problem mit librarys javax.servlet.http.HttpServletRequest cannot be resolved	Allgemeines EE	1	27. Nov 2009
X	JBoss InitialContext problem	Allgemeines EE	5	28. Okt 2009
	Problem mit dem einbinden von Bibliotheken, die sich gegenseitig verwenden	Allgemeines EE	5	20. Jul 2009
H	GWT Problem beim Ausführen	Allgemeines EE	8	10. Jun 2009
Q	Problem mit JMS und Weblogic 10	Allgemeines EE	5	11. Mai 2009
E	Performance-Problem beim ersten Request	Allgemeines EE	4	24. Apr 2009
G	Multi User Problem	Allgemeines EE	8	3. Dez 2008
J	OOP Java Array Problem	Allgemeines EE	2	22. Nov 2008
T	Problem mit Java Transaction API	Allgemeines EE	2	11. Sep 2008
D	Problem mit EJB: Bean soll Objekt eigener Klasse zurückgeben	Allgemeines EE	2	5. Sep 2008
N	JavaMail Problem	Allgemeines EE	4	10. Jul 2008
N	JBoss Problem mit Bibliothek in unterschiedlichen Versionen	Allgemeines EE	2	6. Mai 2008
A	Tomcat -- JSP: komisches Problem	Allgemeines EE	11	5. Mai 2008
W	Speicher-Problem bei WebApp unter Tomcat, Struts, Hibernate	Allgemeines EE	3	1. Apr 2008
B	Problem mit ActionListener	Allgemeines EE	13	11. Mrz 2008
G	Simples JSF-Projekt in Eclipse - Problem	Allgemeines EE	9	28. Feb 2008
O	eclipse - tomcat: Problem bei einfachem Webservice	Allgemeines EE	16	20. Jan 2008
J	Problem mit EJB Aufruf und DualCore Rechner	Allgemeines EE	4	15. Jan 2008
J	ejb3.0 datenbank problem	Allgemeines EE	2	14. Jan 2008
J	Problem mit Zurück-Button	Allgemeines EE	2	5. Jan 2008
T	Tomcat: JNDI + JDBC Problem	Allgemeines EE	3	26. Nov 2007
J	problem mit jsp/js	Allgemeines EE	2	23. Nov 2007
B	Help - EJB2 - Problem mit Hybernate und "LIMIT"	Allgemeines EE	6	14. Nov 2007
B	JSTL Problem	Allgemeines EE	8	5. Nov 2007
	Tomcat Deployment Problem (HTTP Status 503)	Allgemeines EE	8	30. Okt 2007
S	Problem mit t:selectOneRadio und ValueChangeListener	Allgemeines EE	2	12. Okt 2007
S	Problem mit Struts und tiles	Allgemeines EE	4	11. Okt 2007
B	Problem mit JBoss-4.2.1.GA	Allgemeines EE	8	2. Okt 2007
N	Tiles - JSF Problem	Allgemeines EE	3	1. Okt 2007
M	JSF & EJB "Bean not bound" Problem	Allgemeines EE	4	19. Sep 2007
V	MYSQL JDBC;java.lang.ClassNotFoundException; Problem Eclipse	Allgemeines EE	3	13. Aug 2007
	JMS - Problem mit TemporaryQueue	Allgemeines EE	2	12. Aug 2007
G	Problem mit MimeType/ContentType	Allgemeines EE	4	1. Aug 2007
E	Java Mail problem	Allgemeines EE	5	13. Jul 2007
Y	XFire - Maven Build Problem	Allgemeines EE	2	11. Jul 2007
D	JSP Problem mit equals?	Allgemeines EE	2	10. Jul 2007
A	Eclipse Start-Problem	Allgemeines EE	5	9. Jul 2007
S	JSF - Custom converter Problem	Allgemeines EE	3	6. Jul 2007
Y	JSF Uhrzeitausgabe Problem	Allgemeines EE	4	29. Jun 2007
M	servlet --> jsp - problem beim umstrukturieren	Allgemeines EE	5	24. Mai 2007
Y	JSF - rendered Problem	Allgemeines EE	1	18. Mai 2007
D	Servlet Problem über Server	Allgemeines EE	26	14. Mai 2007
	JSF h:inputText h:outputText update Problem	Allgemeines EE	2	8. Mai 2007
K	mysql treiber problem wenn import java.sql.* bei _servlet_	Allgemeines EE	2	24. Apr 2007
T	Session-Problem	Allgemeines EE	2	22. Mrz 2007
R	Tiles - Layout-Problem wegen Leerzeichen	Allgemeines EE	6	6. Mrz 2007
G	Tomcat / Eclipse oder Web.xml Problem	Allgemeines EE	11	27. Feb 2007
S	Netbeans 5.5 Visual Web Pack Problem mit INSERT und PK	Allgemeines EE	4	25. Feb 2007
D	JSF Problem mit Action	Allgemeines EE	2	8. Feb 2007
F	Klassen und zugriffs Problem "Help wanted"!	Allgemeines EE	16	2. Feb 2007
D	<input type="file"> Problem	Allgemeines EE	6	11. Jan 2007
N	Struts - Problem mit <html:link> Action	Allgemeines EE	3	8. Jan 2007
A	Problem / Fehler beim Einbinden einer Klasse in ein JSP	Allgemeines EE	20	5. Jan 2007
G	Session Problem	Allgemeines EE	5	16. Dez 2006
T	Ant Compiler Problem	Allgemeines EE	9	10. Dez 2006
T	Problem dem Zaehler in mein Java - Code	Allgemeines EE	2	9. Dez 2006
A	Hibernate-Problem mit MySQL-Cluster	Allgemeines EE	6	7. Dez 2006
H	Servlet problem	Allgemeines EE	10	6. Dez 2006
G	Problem mit Benutzerverwaltung	Allgemeines EE	3	27. Nov 2006
S	Hibernate Mapping Problem	Allgemeines EE	3	26. Nov 2006
S	Hibernate INSERT Problem	Allgemeines EE	11	16. Nov 2006
S	Dummes JSP-Problem	Allgemeines EE	8	30. Okt 2006
P	EJB-Installations-Problem	Allgemeines EE	4	26. Okt 2006
S	CSS Problem in JSP	Allgemeines EE	16	25. Okt 2006
C	Problem mit html:optionsCollection	Allgemeines EE	4	13. Okt 2006
R	HILFE: Problem mit JSF examples	Allgemeines EE	10	28. Sep 2006

Datasource Problem

Gelöschtes Mitglied 5909

Gast

Gelöschtes Mitglied 5909

Gast

Ähnliche Java Themen

Aktuelle Jobs

Neue Themen