Mrinal Thigale
2013-07-25 19:47:34 UTC
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&containerType=14&container=2077]
"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&containerType=14&container=2077]