[jboss-user] [Datasource Configuration] - Data source configuration on JBOSS AS 7 with postgres 9

Mrinal Thigale [https://community.jboss.org/people/mthigale] created the discussion "Data source configuration on JBOSS AS 7 with postgres 9" To view the discussion, visit: https://community.jboss.org/message/829849#829849 -------------------------------------------------------------- Hi After reading countless posts and questions : I tried out deploying seam app with following file contents : login-ds.xml <?xml version="1.0" encoding="UTF-8"?> <datasources xmlns=" http://www.jboss.org/ironjacamar/schema http://www.jboss.org/ironjacamar/schema">     <datasource         jndi-name="loginDatasource"         enabled="true"         use-java-context="true" pool-name="loginDatasource_pool">         <connection-url>jdbc:postgresql://localhost:5432/challengeapp</connection-url>         <driver>postgresql-9.2-1003.jdbc4.jar</driver>         <security>                           <user-name>postgres</user-name>                           <password>pa55word</password>         </security>     </datasource> </datasources> persistence.xml <?xml version="1.0" encoding="UTF-8"?> <!-- Persistence deployment descriptor for dev profile --> <persistence xmlns=" http://java.sun.com/xml/ns/persistence http://java.sun.com/xml/ns/persistence"              xmlns:xsi=" http://www.w3.org/2001/XMLSchema-instance http://www.w3.org/2001/XMLSchema-instance"              xsi:schemaLocation=" http://java.sun.com/xml/ns/persistence http://java.sun.com/xml/ns/persistence http://java.sun.com/xml/ns/persistence/persistence_2_0.xsd http://java.sun.com/xml/ns/persistence/persistence_2_0.xsd"              version="2.0">    <persistence-unit name="login" transaction-type="JTA">       <provider>org.hibernate.ejb.HibernatePersistence</provider>       <jta-data-source>java:/loginDatasource</jta-data-source>       <properties>          <property name="hibernate.dialect" value="org.hibernate.dialect.PostgreSQLDialect"/>          <property name="hibernate.hbm2ddl.auto" value="validate"/>          <property name="hibernate.show_sql" value="true"/>          <property name="hibernate.format_sql" value="true"/>          <property name="jboss.entity.manager.factory.jndi.name" value="java:/loginEntityManagerFactory"/>       </properties>    </persistence-unit>    </persistence> Created directory : C:\ServerEnvironment\jbossas7\jboss-as-7.1.1.Final\modules\com\postgresql\main Placed jar for driver and module.xml <module xmlns="urn:jboss:module:1.1" name="org.postgresql"><resources> <resource-root path="postgresql-9.2-1003.jdbc4.jar"/> </resources> <dependencies> <module name="javax.api"/> <module name="javax.transaction.api"/> </dependencies> </module> Standalone.xml <?xml version='1.0' encoding='UTF-8'?> <server xmlns="urn:jboss:domain:1.2">     <extensions>         <extension module="org.jboss.as.clustering.infinispan"/>         <extension module="org.jboss.as.configadmin"/>         <extension module="org.jboss.as.connector"/>         <extension module="org.jboss.as.deployment-scanner"/>         <extension module="org.jboss.as.ee"/>         <extension module="org.jboss.as.ejb3"/>         <extension module="org.jboss.as.jaxrs"/>         <extension module="org.jboss.as.jdr"/>         <extension module="org.jboss.as.jmx"/>         <extension module="org.jboss.as.jpa"/>         <extension module="org.jboss.as.logging"/>         <extension module="org.jboss.as.mail"/>         <extension module="org.jboss.as.naming"/>         <extension module="org.jboss.as.osgi"/>         <extension module="org.jboss.as.pojo"/>         <extension module="org.jboss.as.remoting"/>         <extension module="org.jboss.as.sar"/>         <extension module="org.jboss.as.security"/>         <extension module="org.jboss.as.threads"/>         <extension module="org.jboss.as.transactions"/>         <extension module="org.jboss.as.web"/>         <extension module="org.jboss.as.webservices"/>         <extension module="org.jboss.as.weld"/>     </extensions>     <management>         <security-realms>             <security-realm name="ManagementRealm">                 <authentication>                     <properties path="mgmt-users.properties" relative-to="jboss.server.config.dir"/>                 </authentication>             </security-realm>             <security-realm name="ApplicationRealm">                 <authentication>                     <properties path="application-users.properties" relative-to="jboss.server.config.dir"/>                 </authentication>             </security-realm>         </security-realms>         <management-interfaces>             <native-interface security-realm="ManagementRealm">                 <socket-binding native="management-native"/>             </native-interface>             <http-interface security-realm="ManagementRealm">                 <socket-binding http="management-http"/>             </http-interface>         </management-interfaces>     </management>     <profile>         <subsystem xmlns="urn:jboss:domain:logging:1.1">             <console-handler name="CONSOLE">                 <level name="INFO"/>                 <formatter>                     <pattern-formatter pattern="%d{HH:mm:ss,SSS} %-5p [%c] (%t) %s%E%n"/>                 </formatter>             </console-handler>             <periodic-rotating-file-handler name="FILE">                 <formatter>                     <pattern-formatter pattern="%d{HH:mm:ss,SSS} %-5p [%c] (%t) %s%E%n"/>                 </formatter>                 <file relative-to="jboss.server.log.dir" path="server.log"/>                 <suffix value=".yyyy-MM-dd"/>                 <append value="true"/>             </periodic-rotating-file-handler>             <logger category="com.arjuna">                 <level name="WARN"/>             </logger>             <logger category="org.apache.tomcat.util.modeler">                 <level name="WARN"/>             </logger>             <logger category="sun.rmi">                 <level name="WARN"/>             </logger>             <logger category="jacorb">                 <level name="WARN"/>             </logger>             <logger category="jacorb.config">                 <level name="ERROR"/>             </logger>             <root-logger>                 <level name="INFO"/>                 <handlers>                     <handler name="CONSOLE"/>                     <handler name="FILE"/>                 </handlers>             </root-logger>         </subsystem>         <subsystem xmlns="urn:jboss:domain:configadmin:1.0"/>         <subsystem xmlns="urn:jboss:domain:datasources:1.0">             <datasources>                 <datasource jndi-name="java:jboss/datasources/loginDatasource" pool-name="loginDatasource_pool" enabled="true" use-java-context="true" jta="true">                     <connection-url>jdbc:postgresql://localhost:5432/challengeapp</connection-url>                     <driver>postgres</driver>                     <security>                         <user-name>postgres</user-name>                         <password>pa55word</password>                     </security>                 </datasource>                 <drivers>                     <driver name="postgres" module="com.postgresql">                         <xa-datasource-class>org.postgresql.Driver</xa-datasource-class>                     </driver>                 </drivers>             </datasources>         </subsystem>         <subsystem xmlns="urn:jboss:domain:deployment-scanner:1.1">             <deployment-scanner path="deployments" relative-to="jboss.server.base.dir" scan-interval="5000"/>         </subsystem>         <subsystem xmlns="urn:jboss:domain:ee:1.0"/>         <subsystem xmlns="urn:jboss:domain:ejb3:1.2">             <session-bean>                 <stateless>                     <bean-instance-pool-ref pool-name="slsb-strict-max-pool"/>                 </stateless>                 <stateful default-access-timeout="5000" cache-ref="simple"/>                 <singleton default-access-timeout="5000"/>             </session-bean>             <pools>                 <bean-instance-pools>                     <strict-max-pool name="slsb-strict-max-pool" max-pool-size="20" instance-acquisition-timeout="5" instance-acquisition-timeout-unit="MINUTES"/>                     <strict-max-pool name="mdb-strict-max-pool" max-pool-size="20" instance-acquisition-timeout="5" instance-acquisition-timeout-unit="MINUTES"/>                 </bean-instance-pools>             </pools>             <caches>                 <cache name="simple" aliases="NoPassivationCache"/>                 <cache name="passivating" passivation-store-ref="file" aliases="SimpleStatefulCache"/>             </caches>             <passivation-stores>                 <file-passivation-store name="file"/>             </passivation-stores>             <async thread-pool-name="default"/>             <timer-service thread-pool-name="default">                 <data-store path="timer-service-data" relative-to="jboss.server.data.dir"/>             </timer-service>             <remote connector-ref="remoting-connector" thread-pool-name="default"/>             <thread-pools>                 <thread-pool name="default">                     <max-threads count="10"/>                     <keepalive-time time="100" unit="milliseconds"/>                 </thread-pool>             </thread-pools>         </subsystem>         <subsystem xmlns="urn:jboss:domain:infinispan:1.2" default-cache-container="hibernate">             <cache-container name="hibernate" default-cache="local-query">                 <local-cache name="entity">                     <transaction mode="NON_XA"/>                     <eviction strategy="LRU" max-entries="10000"/>                     <expiration max-idle="100000"/>                 </local-cache>                 <local-cache name="local-query">                     <transaction mode="NONE"/>                     <eviction strategy="LRU" max-entries="10000"/>                     <expiration max-idle="100000"/>                 </local-cache>                 <local-cache name="timestamps">                     <transaction mode="NONE"/>                     <eviction strategy="NONE"/>                 </local-cache>             </cache-container>         </subsystem>         <subsystem xmlns="urn:jboss:domain:jaxrs:1.0"/>         <subsystem xmlns="urn:jboss:domain:jca:1.1">             <archive-validation enabled="true" fail-on-error="true" fail-on-warn="false"/>             <bean-validation enabled="true"/>             <default-workmanager>                 <short-running-threads>                     <core-threads count="50"/>                     <queue-length count="50"/>                     <max-threads count="50"/>                     <keepalive-time time="10" unit="seconds"/>                 </short-running-threads>                 <long-running-threads>                     <core-threads count="50"/>                     <queue-length count="50"/>                     <max-threads count="50"/>                     <keepalive-time time="10" unit="seconds"/>                 </long-running-threads>             </default-workmanager>             <cached-connection-manager/>         </subsystem>         <subsystem xmlns="urn:jboss:domain:jdr:1.0"/>         <subsystem xmlns="urn:jboss:domain:jmx:1.1">             <show-model value="true"/>             <remoting-connector/>         </subsystem>         <subsystem xmlns="urn:jboss:domain:jpa:1.0">             <jpa default-datasource=""/>         </subsystem>         <subsystem xmlns="urn:jboss:domain:mail:1.0">             <mail-session jndi-name="java:jboss/mail/Default">                 <smtp-server outbound-socket-binding-ref="mail-smtp"/>             </mail-session>         </subsystem>         <subsystem xmlns="urn:jboss:domain:naming:1.1"/>         <subsystem xmlns="urn:jboss:domain:osgi:1.2" activation="lazy">             <properties>                 <property name="org.osgi.framework.startlevel.beginning">                     1                 </property>             </properties>             <capabilities>                 <capability name="javax.servlet.api:v25"/>                 <capability name="javax.transaction.api"/>                 <capability name="org.apache.felix.log" startlevel="1"/>                 <capability name="org.jboss.osgi.logging" startlevel="1"/>                 <capability name="org.apache.felix.configadmin" startlevel="1"/>                 <capability name="org.jboss.as.osgi.configadmin" startlevel="1"/>             </capabilities>         </subsystem>         <subsystem xmlns="urn:jboss:domain:pojo:1.0"/>         <subsystem xmlns="urn:jboss:domain:remoting:1.1">             <connector name="remoting-connector" socket-binding="remoting" security-realm="ApplicationRealm"/>         </subsystem>         <subsystem xmlns="urn:jboss:domain:resource-adapters:1.0"/>         <subsystem xmlns="urn:jboss:domain:sar:1.0"/>         <subsystem xmlns="urn:jboss:domain:security:1.1">             <security-domains>                 <security-domain name="other" cache-type="default">                     <authentication>                         <login-module code="Remoting" flag="optional">                             <module-option name="password-stacking" value="useFirstPass"/>                         </login-module>                         <login-module code="RealmUsersRoles" flag="required">                             <module-option name="usersProperties" value="${jboss.server.config.dir}/application-users.properties"/>                             <module-option name="rolesProperties" value="${jboss.server.config.dir}/application-roles.properties"/>                             <module-option name="realm" value="ApplicationRealm"/>                             <module-option name="password-stacking" value="useFirstPass"/>                         </login-module>                     </authentication>                 </security-domain>                 <security-domain name="jboss-web-policy" cache-type="default">                     <authorization>                         <policy-module code="Delegating" flag="required"/>                     </authorization>                 </security-domain>                 <security-domain name="jboss-ejb-policy" cache-type="default">                     <authorization>                         <policy-module code="Delegating" flag="required"/>                     </authorization>                 </security-domain>             </security-domains>         </subsystem>         <subsystem xmlns="urn:jboss:domain:threads:1.1"/>         <subsystem xmlns="urn:jboss:domain:transactions:1.1">             <core-environment>                 <process-id>                     <uuid/>                 </process-id>             </core-environment>             <recovery-environment socket-binding="txn-recovery-environment" status-socket-binding="txn-status-manager"/>             <coordinator-environment default-timeout="300"/>         </subsystem>         <subsystem xmlns="urn:jboss:domain:web:1.1" default-virtual-server="default-host" native="false">             <connector name="http" protocol="HTTP/1.1" scheme="http" socket-binding="http"/>             <virtual-server name="default-host" enable-welcome-root="true">                 <alias name="localhost"/>                 <alias name="example.com"/>             </virtual-server>         </subsystem>         <subsystem xmlns="urn:jboss:domain:webservices:1.1">             <modify-wsdl-address>true</modify-wsdl-address>             <wsdl-host>${jboss.bind.address:127.0.0.1}</wsdl-host>             <endpoint-config name="Standard-Endpoint-Config"/>             <endpoint-config name="Recording-Endpoint-Config">                 <pre-handler-chain name="recording-handlers" protocol-bindings="##SOAP11_HTTP ##SOAP11_HTTP_MTOM ##SOAP12_HTTP ##SOAP12_HTTP_MTOM">                     <handler name="RecordingHandler" class="org.jboss.ws.common.invocation.RecordingServerHandler"/>                 </pre-handler-chain>             </endpoint-config>         </subsystem>         <subsystem xmlns="urn:jboss:domain:weld:1.0"/>     </profile>     <interfaces>         <interface name="management">             <inet-address value="${jboss.bind.address.management:127.0.0.1}"/>         </interface>         <interface name="public">             <inet-address value="${jboss.bind.address:127.0.0.1}"/>         </interface>         <interface name="unsecure">             <inet-address value="${jboss.bind.address.unsecure:127.0.0.1}"/>         </interface>     </interfaces>     <socket-binding-group name="standard-sockets" default-interface="public" port-offset="${jboss.socket.binding.port-offset:0}">         <socket-binding name="management-native" interface="management" port="${jboss.management.native.port:9999}"/>         <socket-binding name="management-http" interface="management" port="${jboss.management.http.port:9990}"/>         <socket-binding name="management-https" interface="management" port="${jboss.management.https.port:9443}"/>         <socket-binding name="ajp" port="8009"/>         <socket-binding name="http" port="8080"/>         <socket-binding name="https" port="8443"/>         <socket-binding name="osgi-http" interface="management" port="8090"/>         <socket-binding name="remoting" port="4447"/>         <socket-binding name="txn-recovery-environment" port="4712"/>         <socket-binding name="txn-status-manager" port="4713"/>         <outbound-socket-binding name="mail-smtp">             <remote-destination host="localhost" port="25"/>         </outbound-socket-binding>     </socket-binding-group> </server> and tried to deploy project: Getting the following error 01:04:52,493 INFO  [org.jboss.as.connector.deployers.jdbc] (MSC service thread 1-2) JBAS010403: Deploying JDBC-compliant driver class org.apache.derby.jdbc.AutoloadedDriver (version 10.4) 01:04:52,580 INFO  [org.jboss.as] (MSC service thread 1-8) JBAS015951: Admin console listening on http://127.0.0.1:9990 http://127.0.0.1:9990 01:04:52,583 *ERROR [org.jboss.as] (MSC service thread 1-8) JBAS015875: JBoss AS 7.1.1.Final "Brontes" started (with errors) in 16799ms - Started 230 of 334 services (23 services failed or missing dependencies, 80 services are passive or on-demand)* 01:04:52,782 INFO  [org.jboss.as.server] (DeploymentScanner-threads - 2) JBAS015871: Deploy of deployment "postgresql-8.1-404.jdbc2.jar" was rolled back with no failure message 01:04:52,794 INFO  [org.jboss.as.server] (DeploymentScanner-threads - 2) JBAS015871: Deploy of deployment "login.war" was rolled back with no failure message 01:04:52,803 INFO  [org.jboss.as.server] (DeploymentScanner-threads - 2) JBAS015870: Deploy of deployment "login-ds.xml" was rolled back with failure message {"JBAS014771: Services with missing/unavailable dependencies" => ["jboss.data-source.loginDatasourcejboss.jdbc-driver.postgresql-9_2-1003_jdbc4_jarMissing[jboss.data-source.loginDatasourcejboss.jdbc-driver.postgresql-9_2-1003_jdbc4_jar]"]} 01:04:52,832 INFO  [org.jboss.as.connector.subsystems.datasources] (MSC service thread 1-5) JBAS010409: Unbound data source [loginDatasource] 01:04:52,853 INFO  [org.jboss.as.server.deployment] (MSC service thread 1-3) JBAS015877: Stopped deployment login-ds.xml in 44ms 01:04:52,855 INFO  [org.jboss.as.server.deployment] (MSC service thread 1-4) JBAS015877: Stopped deployment postgresql-8.1-404.jdbc2.jar in 72ms 01:04:54,002 INFO  [org.jboss.as.server.deployment] (MSC service thread 1-7) JBAS015877: Stopped deployment login.war in 1207ms 01:04:54,005 INFO  [org.jboss.as.controller] (DeploymentScanner-threads - 2) JBAS014774: Service status report *JBAS014775:    New missing/unsatisfied dependencies:* *      service jboss.jdbc-driver.postgresql-9_2-1003_jdbc4_jar (missing) dependents: [service jboss.data-source.loginDatasource]* 01:04:54,012 ERROR [org.jboss.as.server.deployment.scanner] (DeploymentScanner-threads - 1) {"JBAS014653: Composite operation failed and was rolled back. Steps that failed:" => {"Operation step-2" => {"JBAS014771: Services with missing/unavailable dependencies" => ["jboss.data-source.loginDatasourcejboss.jdbc-driver.postgresql-9_2-1003_jdbc4_jarMissing[jboss.data-source.loginDatasourcejboss.jdbc-driver.postgresql-9_2-1003_jdbc4_jar]"]}}} 01:04:54,036 ERROR [org.jboss.as.server.deployment.scanner] (DeploymentScanner-threads - 1) JBAS014654: Composite operation was rolled back 01:04:54,050 ERROR [org.jboss.as.server.deployment.scanner] (DeploymentScanner-threads - 1) JBAS014654: Composite operation was rolled back How do I solve this? Thanks in advance -------------------------------------------------------------- Reply to this message by going to Community [https://community.jboss.org/message/829849#829849] Start a new discussion in Datasource Configuration at Community [https://community.jboss.org/choose-container!input.jspa?contentType=1&...]