Problem configuring JBoss with PostgreSQL
jcgerm Jun 18, 2004 12:08 PMWhen 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.