>Can you show your persistence.xml and any plans used to deploy a >datasource, along with which adapter you are using?
>thanks >david jencks Yes of course. Here's the persistence.xml ------------------------------------------------ <?xml version="1.0" encoding="UTF-8"?> <persistence xmlns="http://java.sun.com/xml/ns/persistence"; xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"; version="1.0" xsi:schemaLocation="http://java.sun.com/xml/ns/persistence http://java.sun.com/xml/ns/persistence/persistence_1_0.xsd";> <persistence-unit name="FMDBPU" transaction-type="JTA"> <description>FMDB</description> <provider>org.apache.openjpa.persistence.PersistenceProviderImpl</provider> <jta-data-source>FMDBPool</jta-data-source> <class>com.de.otto.fmdb.ejb.BenutzerBean</class> <class>com.de.otto.fmdb.ejb.FormulareBean</class> <class>com.de.otto.fmdb.ejb.SystemBean</class> <class>com.de.otto.fmdb.ejb.AuflagenBean</class> </persistence-unit> </persistence> ------------------------------------------------ For deploying/setting up the data pool I used the datapool wizzard in the Geronimo Web-Console: Name of the Database Pool: FMDBPool Database Type: Oracle Thin JDBC Driver Class: oracle.jdbc.OracleDriver Driver JAR: ojdbc/ojdbc/14/jar (this is where I put the ojdbc-14.jar in the repository) DB User Name: XXX DB Password: XXX Host: XXX SID: XXX Port: 1525 XXX means I filled out those fields as well, but I won't tell you and I think that wouldn't be usefull as well. My config.xml in var/config/config.xml looks like that (IP and Username etc are dummys - won't give out secret data to you): -------------------------------------------------------------- <?xml version="1.0" encoding="UTF-8" standalone="yes"?> <attributes xmlns:ns2="http://geronimo.apache.org/xml/ns/plugins-1.3"; xmlns="http://geronimo.apache.org/xml/ns/attributes-1.2";> <comment> ================================================================== Warning - This XML file is regenerated by Geronimo whenever changes are made to Geronimo's configuration. If you want to include comments, create a single comment element element. They are allowable at any level of the configuration. !!!! Do not edit this file while Geronimo is running !!!! ==================================================================</comment> <module name="org.apache.geronimo.framework/j2ee-security/2.1.1/car"> <gbean name="JMXService"> <attribute name="protocol">rmi</attribute> <attribute name="host">${ServerHostname}</attribute> <attribute name="port">${JMXPort + PortOffset}</attribute> <attribute name="urlPath">/jndi/rmi://${ServerHostname}:${NamingPort + PortOffset}/JMXConnector</attribute> </gbean> </module> <module name="org.apache.geronimo.framework/rmi-naming/2.1.1/car"> <gbean name="RMIRegistry"> <attribute name="port">${NamingPort + PortOffset}</attribute> </gbean> <gbean name="NamingProperties"> <attribute name="namingProviderUrl">rmi://${ServerHostname}:${NamingPort + PortOffset}</attribute> </gbean> <gbean name="DefaultThreadPool"> <attribute name="keepAliveTime">30000</attribute> <attribute name="minPoolSize">${MinThreadPoolSize}</attribute> <attribute name="maxPoolSize">${MaxThreadPoolSize}</attribute> </gbean> </module> <module name="org.apache.geronimo.framework/j2ee-system/2.1.1/car"/> <module name="org.apache.geronimo.framework/jee-specs/2.1.1/car"/> <module name="org.apache.geronimo.framework/shutdown/2.1.1/car" load="false"/> <module name="org.apache.geronimo.framework/client-system/2.1.1/car" load="false"/> <module name="org.apache.geronimo.framework/online-deployer/2.1.1/car" load="false"/> <module name="org.apache.geronimo.framework/transformer-agent/2.1.1/car"/> <module name="org.apache.geronimo.framework/server-security-config/2.1.1/car"/> <module name="org.apache.geronimo.framework/plugin/2.1.1/car"> <gbean name="DownloadedPluginRepos"> <attribute name="repositoryList">http://geronimo.apache.org/plugins/plugin-repository-list-2.1.txt</attribute> <attribute name="userRepositories">~/.m2/repository</attribute> </gbean> </module> <module name="org.apache.geronimo.framework/xmlbeans/2.1.1/car"/> <module name="org.apache.geronimo.configs/myfaces-deployer/2.1.1/car"/> <module name="org.apache.geronimo.configs/myfaces/2.1.1/car"/> <module name="org.apache.geronimo.configs/j2ee-server/2.1.1/car"/> <module name="org.apache.geronimo.configs/j2ee-deployer/2.1.1/car"> <gbean name="WebBuilder"> <attribute name="defaultNamespace">http://geronimo.apache.org/xml/ns/j2ee/web/jetty-2.0</attribute> </gbean> <gbean name="EnvironmentEntryBuilder"> <attribute name="eeNamespaces">http://java.sun.com/xml/ns/j2ee,http://java.sun.com/xml/ns/javaee</attribute> </gbean> </module> <module name="org.apache.geronimo.framework/geronimo-gbean-deployer/2.1.1/car"> <gbean name="Deployer"> <attribute name="remoteDeployAddress">http://${RemoteDeployHostname}:${HTTPPort + PortOffset}</attribute> </gbean> </module> <module name="org.apache.geronimo.configs/activemq-ra/2.1.1/car"> <gbean name="ActiveMQ RA"> <attribute name="ServerUrl">tcp://${ServerHostname}:${ActiveMQPort + PortOffset}</attribute> </gbean> </module> <module name="org.apache.geronimo.configs/activemq-broker/2.1.1/car"> <gbean name="ActiveMQ.tcp.default"> <attribute name="host">${ServerHostname}</attribute> <attribute name="port">${ActiveMQPort + PortOffset}</attribute> </gbean> <gbean name="ActiveMQ.stomp.default"> <attribute name="host">${ServerHostname}</attribute> <attribute name="port">${ActiveMQStompPort + PortOffset}</attribute> </gbean> </module> <module name="org.apache.geronimo.configs/system-database/2.1.1/car"> <gbean name="DerbyNetwork"> <attribute name="host">${ServerHostname}</attribute> <attribute name="port">${DerbyPort + PortOffset}</attribute> </gbean> </module> <module name="org.apache.geronimo.configs/derby/2.1.1/car"/> <module name="org.apache.geronimo.configs/transaction/2.1.1/car"> <gbean name="ResourceBindings"> <attribute name="format">${ResourceBindingsFormat}</attribute> <attribute name="nameInNamespace">${ResourceBindingsNameInNamespace}</attribute> <attribute name="namePattern">${ResourceBindingsNamePattern}</attribute> <attribute name="abstractNameQuery">${ResourceBindingsQuery}</attribute> </gbean> </module> <module name="org.apache.geronimo.configs/uddi-tomcat/2.1.1/car"/> <module name="org.apache.geronimo.configs/axis/2.1.1/car"/> <module name="org.apache.geronimo.configs/webservices-common/2.1.1/car"/> <module name="org.apache.geronimo.configs/openejb/2.1.1/car"> <gbean name="EJBNetworkService"> <attribute name="port">${OpenEJBPort + PortOffset}</attribute> <attribute name="host">${ServerHostname}</attribute> </gbean> </module> <module name="org.apache.geronimo.configs/openjpa/2.1.1/car"/> <module name="org.apache.geronimo.configs/jasper/2.1.1/car"/> <module name="org.apache.geronimo.configs/tomcat6/2.1.1/car"> <gbean name="TomcatWebConnector"> <attribute name="host">${ServerHostname}</attribute> <attribute name="port">${HTTPPort + PortOffset}</attribute> <attribute name="redirectPort">${HTTPSPort + PortOffset}</attribute> <attribute name="maxHttpHeaderSize">8192</attribute> <attribute name="maxThreads">150</attribute> <attribute name="minSpareThreads">25</attribute> <attribute name="maxSpareThreads">75</attribute> <attribute name="enableLookups">false</attribute> <attribute name="acceptCount">100</attribute> <attribute name="connectionTimeout">${WebConnectorConTimeout}</attribute> <attribute name="disableUploadTimeout">true</attribute> </gbean> <gbean name="TomcatAJPConnector"> <attribute name="host">${ServerHostname}</attribute> <attribute name="port">${AJPPort + PortOffset}</attribute> <attribute name="redirectPort">${HTTPSPort + PortOffset}</attribute> <attribute name="minSpareThreads">25</attribute> <attribute name="maxSpareThreads">75</attribute> <attribute name="enableLookups">false</attribute> </gbean> <gbean name="TomcatWebSSLConnector"> <attribute name="host">${ServerHostname}</attribute> <attribute name="port">${HTTPSPort + PortOffset}</attribute> <attribute name="maxHttpHeaderSize">8192</attribute> <attribute name="maxThreads">150</attribute> <attribute name="minSpareThreads">25</attribute> <attribute name="maxSpareThreads">75</attribute> <attribute name="enableLookups">false</attribute> <attribute name="acceptCount">100</attribute> <attribute name="disableUploadTimeout">false</attribute> <attribute name="clientAuth">false</attribute> <attribute name="algorithm">Default</attribute> <attribute name="sslProtocol">TLS</attribute> <attribute name="keystoreFile">var/security/keystores/geronimo-default</attribute> <attribute name="keystorePass">secret</attribute> <attribute name="keystoreType">JKS</attribute> </gbean> <gbean name="TomcatHost"> <attribute name="initParams">name=${ServerHostname} appBase= workDir=work</attribute> </gbean> </module> <module name="org.apache.geronimo.configs/connector-deployer/2.1.1/car"> <gbean name="ResourceRefBuilder"> <attribute name="eeNamespaces">http://java.sun.com/xml/ns/j2ee,http://java.sun.com/xml/ns/javaee</attribute> <attribute propertyEditor="org.apache.geronimo.deployment.service.EnvironmentBuilder" name="corbaEnvironment"> <environment:environment xmlns:ns4="http://geronimo.apache.org/xml/ns/attributes-1.2"; xmlns:environment="http://geronimo.apache.org/xml/ns/deployment-1.2";> <environment:dependencies> <environment:dependency> <environment:groupId>org.apache.geronimo.configs</environment:groupId> <environment:artifactId>j2ee-corba-yoko</environment:artifactId> <environment:type>car</environment:type> </environment:dependency> </environment:dependencies> </environment:environment></attribute> </gbean> <gbean name="AdminObjectRefBuilder"> <attribute name="eeNamespaces">http://java.sun.com/xml/ns/j2ee,http://java.sun.com/xml/ns/javaee</attribute> </gbean> <gbean name="ClientResourceRefBuilder"> <attribute name="eeNamespaces">http://java.sun.com/xml/ns/j2ee,http://java.sun.com/xml/ns/javaee</attribute> <attribute propertyEditor="org.apache.geronimo.deployment.service.EnvironmentBuilder" name="corbaEnvironment"> <environment:environment xmlns:ns4="http://geronimo.apache.org/xml/ns/attributes-1.2"; xmlns:environment="http://geronimo.apache.org/xml/ns/deployment-1.2";> <environment:dependencies> <environment:dependency> <environment:groupId>org.apache.geronimo.configs</environment:groupId> <environment:artifactId>client-corba-yoko</environment:artifactId> <environment:type>car</environment:type> </environment:dependency> </environment:dependencies> </environment:environment></attribute> </gbean> </module> <module name="org.apache.geronimo.configs/axis2/2.1.1/car"/> <module name="org.apache.geronimo.configs/jasper-deployer/2.1.1/car"/> <module name="org.apache.geronimo.configs/remote-deploy-tomcat/2.1.1/car"/> <module name="org.apache.geronimo.configs/client-security/2.1.1/car" load="false"/> <module name="org.apache.geronimo.configs/client/2.1.1/car" load="false"/> <module name="org.apache.geronimo.configs/axis2-ejb-deployer/2.1.1/car" condition="props['org.apache.geronimo.jaxws.provider'] == 'axis2' or (props['org.apache.geronimo.jaxws.provider'] == null and webcontainerName == 'tomcat6')"> <gbean name="Axis2ModuleBuilderExtension"> <attribute name="listener">?name=${webcontainer}</attribute> </gbean> </module> <module name="org.apache.geronimo.configs/jaxws-ejb-deployer/2.1.1/car"/> <module name="org.apache.geronimo.configs/jaxws-deployer/2.1.1/car"/> <module name="org.apache.geronimo.configs/openejb-deployer/2.1.1/car"> <gbean name="EjbRefBuilder"> <attribute name="eeNamespaces">http://java.sun.com/xml/ns/j2ee,http://java.sun.com/xml/ns/javaee</attribute> </gbean> <gbean name="ClientEjbRefBuilder"> <attribute name="eeNamespaces">http://java.sun.com/xml/ns/j2ee,http://java.sun.com/xml/ns/javaee</attribute> <attribute name="host">${ServerHostname}</attribute> <attribute name="port">${OpenEJBPort + PortOffset}</attribute> </gbean> </module> <module name="org.apache.geronimo.configs/axis2-deployer/2.1.1/car" condition="props['org.apache.geronimo.jaxws.provider'] == 'axis2' or (props['org.apache.geronimo.jaxws.provider'] == null and webcontainerName == 'tomcat6')"/> <module name="org.apache.geronimo.configs/axis2-ejb/2.1.1/car"/> <module name="org.apache.geronimo.configs/ca-helper-tomcat/2.1.1/car"/> <module name="org.apache.geronimo.plugins/agent/2.1.1/car"/> <module name="org.apache.geronimo.plugins/agent-ds/2.1.1/car"/> <module name="org.apache.geronimo.configs/mejb/2.1.1/car"/> <module name="org.apache.geronimo.configs/tomcat6-clustering-builder-wadi/2.1.1/car"> <gbean name="TomcatClusteringBuilder"> <attribute name="defaultSweepInterval">${DefaultWadiSweepInterval}</attribute> <attribute name="defaultNumPartitions">${DefaultWadiNumPartitions}</attribute> </gbean> </module> <module name="org.apache.geronimo.configs/tomcat6-deployer/2.1.1/car"/> <module name="org.apache.geronimo.configs/tomcat6-clustering-wadi/2.1.1/car" load="false"/> <module name="org.apache.geronimo.configs/wadi-clustering/2.1.1/car" load="false"> <gbean name="DefaultBackingStrategyFactory"> <attribute name="nbReplica">${ReplicaCount}</attribute> </gbean> <gbean name="DefaultDispatcherHolder"> <attribute name="endPointURI">${EndPointURI}</attribute> <attribute name="clusterName">${ClusterName}</attribute> </gbean> </module> <module name="org.apache.geronimo.configs/clustering/2.1.1/car"> <gbean name="Node"> <attribute name="nodeName">${clusterNodeName}</attribute> </gbean> </module> <module name="org.apache.geronimo.plugins/debugviews-console-tomcat/2.1.1/car"/> <module name="org.apache.geronimo.plugins/console-tomcat/2.1.1/car"/> <module name="org.apache.geronimo.plugins/pluto-support/2.1.1/car"/> <module name="org.apache.geronimo.configs/spring/2.1.1/car"/> <module name="org.apache.geronimo.configs/dojo-legacy-tomcat/2.1.1/car"/> <module name="org.apache.geronimo.configs/persistence-jpa10-deployer/2.1.1/car"> <gbean name="PersistenceUnitBuilder"> <attribute name="defaultPersistenceProviderClassName">org.apache.openjpa.persistence.PersistenceProviderImpl</attribute> <attribute name="defaultPersistenceUnitProperties">openjpa.Log=commons openjpa.jdbc.SynchronizeMappings=buildSchema(ForeignKeys=true) openjpa.jdbc.UpdateManager=operation-order openjpa.Sequence=table(Table=OPENJPASEQ, Increment=100)</attribute> <attribute propertyEditor="org.apache.geronimo.deployment.service.EnvironmentBuilder" name="defaultEnvironment"> <environment:environment xmlns:ns4="http://geronimo.apache.org/xml/ns/attributes-1.2"; xmlns:environment="http://geronimo.apache.org/xml/ns/deployment-1.2";> <environment:dependencies> <environment:dependency> <environment:groupId>org.apache.geronimo.configs</environment:groupId> <environment:artifactId>openjpa</environment:artifactId> <environment:type>car</environment:type> </environment:dependency> </environment:dependencies> </environment:environment></attribute> </gbean> </module> <module name="org.apache.geronimo.plugins/plugin-console-tomcat/2.1.1/car"/> <module name="org.apache.geronimo.plugins/plancreator-console-tomcat/2.1.1/car"/> <module name="org.apache.geronimo.framework/upgrade-cli/2.1.1/car" load="false"/> <module name="org.apache.geronimo.configs/axis-deployer/2.1.1/car"> <gbean name="AxisModuleBuilderExtension"> <attribute name="listener">?name=${webcontainer}</attribute> <attribute propertyEditor="org.apache.geronimo.deployment.service.EnvironmentBuilder" name="defaultEnvironment"> <environment:environment xmlns:ns4="http://geronimo.apache.org/xml/ns/attributes-1.2"; xmlns:environment="http://geronimo.apache.org/xml/ns/deployment-1.2";> <environment:dependencies> <environment:dependency> <environment:groupId>org.apache.geronimo.configs</environment:groupId> <environment:artifactId>${webcontainerName}</environment:artifactId> <environment:type>car</environment:type> </environment:dependency> </environment:dependencies> </environment:environment></attribute> </gbean> </module> <module name="org.apache.geronimo.configs/j2ee-corba-yoko/2.1.1/car"> <gbean name="NameServer"> <attribute name="port">${COSNamingPort + PortOffset}</attribute> <attribute name="host">${COSNamingHost}</attribute> </gbean> <gbean name="Server"> <attribute name="port">${ORBSSLPort + PortOffset}</attribute> <attribute name="host">${ORBSSLHost}</attribute> </gbean> <gbean name="UnprotectedServer"> <attribute name="port">${ORBPort + PortOffset}</attribute> <attribute name="host">${ORBHost}</attribute> </gbean> </module> <module name="org.apache.geronimo.configs/hot-deployer/2.1.1/car"> <gbean name="HotDeployer"> <attribute name="path">deploy/</attribute> <attribute name="pollIntervalMillis">2000</attribute> </gbean> </module> <module name="org.apache.geronimo.configs/farming/2.1.1/car" load="false"> <gbean name="NodeInfo"> <attribute name="name">${clusterNodeName}</attribute> </gbean> <gbean name="ClusterInfo"> <attribute name="name">${clusterName}</attribute> </gbean> </module> <module name="org.apache.geronimo.plugins/sysdb-console-tomcat/2.1.1/car"/> <module name="org.apache.geronimo.configs/openejb-corba-deployer/2.1.1/car"/> <module name="org.apache.geronimo.framework/offline-deployer/2.1.1/car" load="false"/> <module name="org.apache.geronimo.plugins/activemq-console-tomcat/2.1.1/car"/> <module name="org.apache.geronimo.configs/client-corba-yoko/2.1.1/car" load="false"/> <module name="org.apache.geronimo.configs/javamail/2.1.1/car"> <gbean name="SMTPTransport"> <attribute name="host">${SMTPHost}</attribute> <attribute name="port">${SMTPPort + PortOffset}</attribute> </gbean> </module> <module name="org.apache.geronimo.configs/welcome-tomcat/2.1.1/car"/> <module name="org.apache.geronimo.configs/cxf-deployer/2.1.1/car" condition="props['org.apache.geronimo.jaxws.provider'] == 'cxf' or (props['org.apache.geronimo.jaxws.provider'] == null and webcontainerName == 'jetty6')"/> <module name="org.apache.geronimo.configs/cxf/2.1.1/car"/> <module name="org.apache.geronimo.configs/sharedlib/2.1.1/car"/> <module name="org.apache.geronimo.plugins/mconsole-tomcat/2.1.1/car"/> <module name="org.apache.geronimo.plugins/mconsole-ds/2.1.1/car"/> <module name="org.apache.geronimo.configs/client-deployer/2.1.1/car"/> <module name="org.apache.geronimo.configs/client-transaction/2.1.1/car" load="false"/> <module name="org.apache.geronimo.configs/cxf-ejb-deployer/2.1.1/car" condition="props['org.apache.geronimo.jaxws.provider'] == 'cxf' or (props['org.apache.geronimo.jaxws.provider'] == null and webcontainerName == 'jetty6')"> <gbean name="CXFModuleBuilderExtension"> <attribute name="listener">?name=${webcontainer}</attribute> </gbean> </module> <module name="org.apache.geronimo.configs/cxf-ejb/2.1.1/car"/> <module name="org.apache.geronimo.configs/dojo-tomcat/2.1.1/car"/> <module name="default/WebAppEjbAccessAnnotations/1.0/war" load="false"/> <module name="org.apache.geronimo.configs/jsr88-ear-configurer/2.1.1/car" load="false"/> <module name="org.apache.geronimo.configs/jsr88-jar-configurer/2.1.1/car" load="false"/> <module name="org.apache.geronimo.configs/jsr88-war-configurer/2.1.1/car" load="false"/> <module name="org.apache.geronimo.framework/jsr88-deploymentfactory/2.1.1/car" load="false"/> <module name="console.dbpool/FMDBPool/1.0/rar"> <gbean name="console.dbpool/FMDBPool/1.0/rar?J2EEApplication=null,JCAConnectionFactory=FMDBPool,JCAResource=console.dbpool/FMDBPool/1.0/rar,ResourceAdapter=console.dbpool/FMDBPool/1.0/rar,ResourceAdapterModule=console.dbpool/FMDBPool/1.0/rar,j2eeType=JCAManagedConnectionFactory,name=FMDBPool"> <attribute name="ConnectionURL">jdbc:oracle:thin:@000.000.000.000:1525:ANONYM</attribute> <attribute name="UserName">Username</attribute> <attribute name="Password">{Simple}</attribute> </gbean> </module> <module name="default/fmdb/1.0/jar"/> </attributes> -------------------------------------------------------------- -- View this message in context: http://www.nabble.com/Transactions-are-commited-only-when-Server-shuts-down.-tp19251568s134p19303992.html Sent from the Apache Geronimo - Users mailing list archive at Nabble.com.
