3 Replies Latest reply on Dec 1, 2004 12:53 AM by Joan Horta Tosas

    Problem configuring JBoss with PostgreSQL

    jcgerm Newbie

      When I start up JBoss I get this:

      =========================================================================
      
       JBoss Bootstrap Environment
      
       JBOSS_HOME: /usr/local/jboss-3.2.4
      
       JAVA: /usr/local/j2sdk1.4.2_04/bin/java
      
       JAVA_OPTS: -server -Dprogram.name=run.sh
      
       CLASSPATH: /usr/local/jboss-3.2.4/bin/run.jar:/usr/local/j2sdk1.4.2_04/lib/tools.jar
      
      =========================================================================
      
      11:04:57,974 INFO [Server] Starting JBoss (MX MicroKernel)...
      11:04:57,976 INFO [Server] Release ID: JBoss [WonderLand] 3.2.4 (build: CVSTag=JBoss_3_2_4 date=200406040847)
      11:04:57,976 INFO [Server] Home Dir: /usr/local/jboss-3.2.4
      11:04:57,976 INFO [Server] Home URL: file:/usr/local/jboss-3.2.4/
      11:04:57,977 INFO [Server] Library URL: file:/usr/local/jboss-3.2.4/lib/
      11:04:57,978 INFO [Server] Patch URL: null
      11:04:57,978 INFO [Server] Server Name: default
      11:04:57,978 INFO [Server] Server Home Dir: /usr/local/jboss-3.2.4/server/default
      11:04:57,978 INFO [Server] Server Home URL: file:/usr/local/jboss-3.2.4/server/default/
      11:04:57,978 INFO [Server] Server Data Dir: /usr/local/jboss-3.2.4/server/default/data
      11:04:57,978 INFO [Server] Server Temp Dir: /usr/local/jboss-3.2.4/server/default/tmp
      11:04:57,979 INFO [Server] Server Config URL: file:/usr/local/jboss-3.2.4/server/default/conf/
      11:04:57,979 INFO [Server] Server Library URL: file:/usr/local/jboss-3.2.4/server/default/lib/
      11:04:57,979 INFO [Server] Root Deployment Filename: jboss-service.xml
      11:04:57,982 INFO [Server] Starting General Purpose Architecture (GPA)...
      11:04:58,298 INFO [ServerInfo] Java version: 1.4.2_04,Sun Microsystems Inc.
      11:04:58,298 INFO [ServerInfo] Java VM: Java HotSpot(TM) Server VM 1.4.2_04-b05,Sun Microsystems Inc.
      11:04:58,298 INFO [ServerInfo] OS-System: Linux 2.4.9-e.3smp,i386
      11:04:58,588 INFO [Server] Core system initialized
      11:05:01,282 INFO [Log4jService$URLWatchTimerTask] Configuring from URL: resource:log4j.xml
      11:05:01,744 INFO [WebService] Using RMI server codebase: http://vhaiswimmras1:8083/
      11:05:01,839 INFO [NamingService] Started jnpPort=1099, rmiPort=1098, backlog=50, bindAddress=/0.0.0.0, Client SocketFactory=null, Server SocketFactory=org.jboss.net.sockets.DefaultSocketFactory@ad093076
      11:05:05,112 INFO [RARMetaData] Loading JBoss Resource Adapter for JDBC 2 XA drivers
      11:05:05,113 INFO [RARMetaData] Required license terms present. See deployment descriptor.
      11:05:08,347 INFO [MailService] Mail Service bound to java:/Mail
      11:05:08,812 INFO [Embedded] Catalina naming disabled
      11:05:09,526 INFO [Http11Protocol] Initializing Coyote HTTP/1.1 on http-0.0.0.0-8080
      11:05:09,567 INFO [Catalina] Initialization processed in 681 ms
      11:05:09,568 INFO [StandardService] Starting service jboss.web
      11:05:09,579 INFO [StandardEngine] Starting Servlet Engine: Apache Tomcat/5.0.26
      11:05:09,587 INFO [StandardHost] XML validation disabled
      11:05:09,612 INFO [Catalina] Server startup in 44 ms
      11:05:09,685 WARN [DeploymentInfo] Only the root deployment can set the loader repository, ingoring config=null
      11:05:09,699 INFO [TomcatDeployer] deploy, ctxPath=/invoker, warUrl=file:/usr/local/jboss-3.2.4/server/default/deploy/http-invoker.sar/invoker.war/
      11:05:10,700 WARN [DeploymentInfo] Only the root deployment can set the loader repository, ingoring config=null
      11:05:10,705 INFO [TomcatDeployer] deploy, ctxPath=, warUrl=file:/usr/local/jboss-3.2.4/server/default/deploy/jbossweb-tomcat50.sar/ROOT.war/
      11:05:10,870 WARN [DeploymentInfo] Only the root deployment can set the loader repository, ingoring config=null
      11:05:10,879 INFO [TomcatDeployer] deploy, ctxPath=/jbossmq-httpil, warUrl=file:/usr/local/jboss-3.2.4/server/default/deploy/jms/jbossmq-httpil.sar/jbossmq-httpil.war/
      11:05:11,091 INFO [JmsXA] Bound connection factory for resource adapter for ConnectionManager 'jboss.jca:service=TxCM,name=JmsXA to JNDI name 'java:/JmsXA'
      11:05:11,097 INFO [PostgresDS] Bound connection factory for resource adapter for ConnectionManager 'jboss.jca:service=LocalTxCM,name=PostgresDS to JNDI name 'java:/PostgresDS'
      11:05:11,167 INFO [TomcatDeployer] deploy, ctxPath=/jmx-console, warUrl=file:/usr/local/jboss-3.2.4/server/default/deploy/jmx-console.war/
      11:05:11,629 INFO [TomcatDeployer] deploy, ctxPath=/web-console, warUrl=file:/usr/local/jboss-3.2.4/server/default/tmp/deploy/tmp48563web-console.war/
      11:05:12,228 ERROR [URLDeploymentScanner] Incomplete Deployment listing:
      MBeans waiting for other MBeans:
      ObjectName: jboss.mq:service=InvocationLayer,type=HTTP
       state: CONFIGURED
       I Depend On: jboss.mq:service=Invoker
       jboss.web:service=WebServer
      
       Depends On Me:
      ObjectName: jboss.mq:service=StateManager
       state: CONFIGURED
       I Depend On: jboss.jca:service=LocalTxCM,name=DefaultDS
      
       Depends On Me: jboss.mq:service=DestinationManager
      
      ObjectName: jboss.mq:service=DestinationManager
       state: CONFIGURED
       I Depend On: jboss.mq:service=MessageCache
       jboss.mq:service=PersistenceManager
       jboss.mq:service=StateManager
      
       Depends On Me: jboss.mq.destination:service=Topic,name=testTopic
       jboss.mq.destination:service=Topic,name=securedTopic
       jboss.mq.destination:service=Topic,name=testDurableTopic
       jboss.mq.destination:service=Queue,name=testQueue
       jboss.mq.destination:service=Queue,name=A
       jboss.mq.destination:service=Queue,name=B
       jboss.mq.destination:service=Queue,name=C
       jboss.mq.destination:service=Queue,name=D
       jboss.mq.destination:service=Queue,name=ex
       jboss.mq:service=SecurityManager
       jboss.mq.destination:service=Queue,name=DLQ
      
      ObjectName: jboss.mq:service=PersistenceManager
       state: CONFIGURED
       I Depend On: jboss.jca:service=LocalTxCM,name=DefaultDS
      
       Depends On Me: jboss.mq:service=DestinationManager
      
      ObjectName: jboss.mq.destination:service=Topic,name=testTopic
       state: CONFIGURED
       I Depend On: jboss.mq:service=DestinationManager
       jboss.mq:service=SecurityManager
      
       Depends On Me:
      ObjectName: jboss.mq.destination:service=Topic,name=securedTopic
       state: CONFIGURED
       I Depend On: jboss.mq:service=DestinationManager
       jboss.mq:service=SecurityManager
      
       Depends On Me:
      ObjectName: jboss.mq.destination:service=Topic,name=testDurableTopic
       state: CONFIGURED
       I Depend On: jboss.mq:service=DestinationManager
       jboss.mq:service=SecurityManager
      
       Depends On Me:
      ObjectName: jboss.mq.destination:service=Queue,name=testQueue
       state: CONFIGURED
       I Depend On: jboss.mq:service=DestinationManager
       jboss.mq:service=SecurityManager
      
       Depends On Me:
      ObjectName: jboss.mq.destination:service=Queue,name=A
       state: CONFIGURED
       I Depend On: jboss.mq:service=DestinationManager
      
       Depends On Me:
      ObjectName: jboss.mq.destination:service=Queue,name=B
       state: CONFIGURED
       I Depend On: jboss.mq:service=DestinationManager
      
       Depends On Me:
      ObjectName: jboss.mq.destination:service=Queue,name=C
       state: CONFIGURED
       I Depend On: jboss.mq:service=DestinationManager
      
       Depends On Me:
      ObjectName: jboss.mq.destination:service=Queue,name=D
       state: CONFIGURED
       I Depend On: jboss.mq:service=DestinationManager
      
       Depends On Me:
      ObjectName: jboss.mq.destination:service=Queue,name=ex
       state: CONFIGURED
       I Depend On: jboss.mq:service=DestinationManager
      
       Depends On Me:
      ObjectName: jboss.mq:service=Invoker
       state: CONFIGURED
       I Depend On: jboss.mq:service=TracingInterceptor
      
       Depends On Me: jboss.mq:service=InvocationLayer,type=HTTP
       jboss.mq:service=InvocationLayer,type=JVM
       jboss.mq:service=InvocationLayer,type=UIL2
      
      ObjectName: jboss.mq:service=TracingInterceptor
       state: CONFIGURED
       I Depend On: jboss.mq:service=SecurityManager
      
       Depends On Me: jboss.mq:service=Invoker
      
      ObjectName: jboss.mq:service=SecurityManager
       state: CONFIGURED
       I Depend On: jboss.mq:service=DestinationManager
      
       Depends On Me: jboss.mq.destination:service=Topic,name=testTopic
       jboss.mq.destination:service=Topic,name=securedTopic
       jboss.mq.destination:service=Topic,name=testDurableTopic
       jboss.mq.destination:service=Queue,name=testQueue
       jboss.mq:service=TracingInterceptor
       jboss.mq.destination:service=Queue,name=DLQ
      
      ObjectName: jboss.mq.destination:service=Queue,name=DLQ
       state: CONFIGURED
       I Depend On: jboss.mq:service=DestinationManager
       jboss.mq:service=SecurityManager
      
       Depends On Me:
      ObjectName: jboss.mq:service=InvocationLayer,type=JVM
       state: CONFIGURED
       I Depend On: jboss.mq:service=Invoker
      
       Depends On Me:
      ObjectName: jboss.mq:service=InvocationLayer,type=UIL2
       state: CONFIGURED
       I Depend On: jboss.mq:service=Invoker
      
       Depends On Me:
      
      MBEANS THAT ARE THE ROOT CAUSE OF THE PROBLEM:
      ObjectName: jboss.jca:service=LocalTxCM,name=DefaultDS
       state: NOTYETINSTALLED
       I Depend On:
       Depends On Me: jboss.mq:service=StateManager
       jboss.mq:service=PersistenceManager
      


      My postgres-ds.xml file:
      <?xml version="1.0" encoding="UTF-8"?>
      
      <!-- ===================================================================== -->
      <!-- -->
      <!-- JBoss Server Configuration -->
      <!-- -->
      <!-- ===================================================================== -->
      
      <!-- $Id: postgres-ds.xml,v 1.1.2.1 2003/09/05 16:38:24 patriot1burke Exp $ -->
      <!-- ==================================================================== -->
      <!-- Datasource config for Postgres -->
      <!-- ==================================================================== -->
      
      
      <datasources>
       <local-tx-datasource>
       <jndi-name>PostgresDS</jndi-name>
       <connection-url>jdbc:postgresql://localhost:5432/jbossas1</connection-url>
       <driver-class>org.postgresql.Driver</driver-class>
       <user-name>postgres</user-name>
       <password>postgres</password>
       <!-- sql to call when connection is created
       <new-connection-sql>some arbitrary sql</new-connection-sql>
       -->
      
       <!-- sql to call on an existing pooled connection when it is obtained from pool
       <check-valid-connection-sql>some arbitrary sql</check-valid-connection-sql>
       -->
      
       </local-tx-datasource>
      
      </datasources>
      


      A piece of my standardjbosscmp-jdbc.xml file:
      <jbosscmp-jdbc>
      
       <defaults>
       <datasource>java:/PostgresDS</datasource>
       <datasource-mapping>PostgreSQL<datasource-mapping>
      


      No tables are being created in the database either. Can anyone help me out? I don't really understand why it's not working.