I posted it in another topic but the only response that I recieve doesn't 
regard the installation of JBoss as default datasource.

Bye! =)

This is the log of JBoss, I shortened some StackTrace to reduce the size of the 
message but if you want or if you need I can post it entirely.

22:06:53,667 INFO [ConnectionFactoryBindingService] Bound ConnectionManager 
'jboss.jca:service=ConnectionFactoryBinding,name=JmsXA' to JNDI name 
'java:JmsXA'
22:06:54,684 INFO [ConnectionFactoryBindingService] Bound ConnectionManager 
'jboss.jca:service=DataSourceBinding,name=DefaultDS' to JNDI name 
'java:DefaultDS'
22:06:55,184 ERROR [GeneralPurposeDatabasePersistencePlugin] Cannot create 
timer table
java.lang.IllegalStateException: Cannot obtain type mapping from: 
jboss.jdbc:datasource=DefaultDS,service=metadata
at 
org.jboss.ejb.txtimer.GeneralPurposeDatabasePersistencePlugin.createTableIfNotExists(GeneralPurposeDatabasePersistencePlugin.java:97)
at 
org.jboss.ejb.txtimer.DatabasePersistencePolicy.startService(DatabasePersistencePolicy.java:96)
....
at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:644)
at org.jboss.mx.util.MBeanProxyExt.invoke(MBeanProxyExt.java:176)
at $Proxy5.deploy(Unknown Source)
at org.jboss.system.server.ServerImpl.doStart(ServerImpl.java:453)
at org.jboss.system.server.ServerImpl.start(ServerImpl.java:330)
at org.jboss.Main.boot(Main.java:187)
at org.jboss.Main$1.run(Main.java:438)
at java.lang.Thread.run(Thread.java:595)
22:06:55,196 WARN [ServiceController] Problem starting service 
jboss.ejb:service=EJBTimerService,persistencePolicy=database
org.postgresql.util.PSQLException: ERROR: relation "timers" does not exist
at 
org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:1512)
at 
org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1297)
at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:188)
...
at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:644)
at org.jboss.mx.util.MBeanProxyExt.invoke(MBeanProxyExt.java:176)
at $Proxy5.deploy(Unknown Source)
at org.jboss.system.server.ServerImpl.doStart(ServerImpl.java:453)
at org.jboss.system.server.ServerImpl.start(ServerImpl.java:330)
at org.jboss.Main.boot(Main.java:187)
at org.jboss.Main$1.run(Main.java:438)
at java.lang.Thread.run(Thread.java:595)
22:06:55,289 WARN [ServiceController] Problem starting service 
jboss.mq:service=PersistenceManager
org.jboss.mq.SpyJMSException: Could not resolve uncommited transactions. 
Message recovery may not be accurate; - nested throwable: 
(org.postgresql.util.PSQLException: ERROR: syntax error at or near "TXID")
at 
org.jboss.mq.pm.jdbc2.PersistenceManager.resolveAllUncommitedTXs(PersistenceManager.java:416)
at 
org.jboss.mq.pm.jdbc2.PersistenceManager.startService(PersistenceManager.java:1499)
at 
org.jboss.system.ServiceMBeanSupport.jbossInternalStart(ServiceMBeanSupport.java:274)
...
at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:644)
at org.jboss.mx.util.MBeanProxyExt.invoke(MBeanProxyExt.java:176)
at $Proxy5.deploy(Unknown Source)
at org.jboss.system.server.ServerImpl.doStart(ServerImpl.java:453)
at org.jboss.system.server.ServerImpl.start(ServerImpl.java:330)
at org.jboss.Main.boot(Main.java:187)
at org.jboss.Main$1.run(Main.java:438)
at java.lang.Thread.run(Thread.java:595)
Caused by: org.postgresql.util.PSQLException: ERROR: syntax error at or near 
"TXID"
at 
org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:1512)
at 
org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1297)
at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:188)
at 
org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:430)
at 
org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:346)
at 
org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:250)
at 
org.jboss.resource.adapter.jdbc.WrappedPreparedStatement.executeQuery(WrappedPreparedStatement.java:211)
at 
org.jboss.mq.pm.jdbc2.PersistenceManager.resolveAllUncommitedTXs(PersistenceManager.java:384)
... 111 more
22:06:55,348 INFO [TomcatDeployer] deploy, ctxPath=/jmx-console, 
warUrl=.../deploy/jmx-console.war/
22:06:55,698 ERROR [URLDeploymentScanner] Incomplete Deployment listing:

--- MBeans waiting for other MBeans ---
ObjectName: jboss.ejb:service=EJBTimerService,persistencePolicy=database
State: FAILED
Reason: org.postgresql.util.PSQLException: ERROR: relation "timers" does not 
exist
I Depend On:
jboss.jca:service=DataSourceBinding,name=DefaultDS

ObjectName: jboss.mq:service=PersistenceManager
State: FAILED
Reason: org.jboss.mq.SpyJMSException: Could not resolve uncommited 
transactions. Message recovery may not be accurate; - nested throwable: 
(org.postgresql.util.PSQLException: ERROR: syntax error at or near "TXID")
I Depend On:
jboss.jca:service=DataSourceBinding,name=DefaultDS
Depends On Me:
jboss.mq:service=DestinationManager

--- MBEANS THAT ARE THE ROOT CAUSE OF THE PROBLEM ---
ObjectName: jboss.mq:service=PersistenceManager
State: FAILED
Reason: org.jboss.mq.SpyJMSException: Could not resolve uncommited 
transactions. Message recovery may not be accurate; - nested throwable: 
(org.postgresql.util.PSQLException: ERROR: syntax error at or near "TXID")
I Depend On:
jboss.jca:service=DataSourceBinding,name=DefaultDS
Depends On Me:
jboss.mq:service=DestinationManager

ObjectName: jboss.ejb:service=EJBTimerService,persistencePolicy=database
State: FAILED
Reason: org.postgresql.util.PSQLException: ERROR: relation "timers" does not 
exist
I Depend On:
jboss.jca:service=DataSourceBinding,name=DefaultDS


22:06:57,501 INFO [Http11Protocol] Starting Coyote HTTP/1.1 on http-0.0.0.0-8080
22:06:57,631 INFO [ChannelSocket] JK: ajp13 listening on /0.0.0.0:8009
22:06:57,637 INFO [JkMain] Jk running ID=0 time=0/18 config=null
22:06:57,643 INFO [Server] JBoss (MX MicroKernel) [4.0.3SP1 (build: 
CVSTag=JBoss_4_0_3_SP1 date=200510231054)] Started in 40s:142ms 

View the original post : 
http://www.jboss.com/index.html?module=bb&op=viewtopic&p=3920877#3920877

Reply to the post : 
http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=3920877


-------------------------------------------------------
This SF.net email is sponsored by: Splunk Inc. Do you grep through log files
for problems?  Stop!  Download the new AJAX search engine that makes
searching your log files as easy as surfing the  web.  DOWNLOAD SPLUNK!
http://sel.as-us.falkag.net/sel?cmd=lnk&kid=103432&bid=230486&dat=121642
_______________________________________________
JBoss-user mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/jboss-user

Reply via email to