jdbc persistence startup problems

[parisd]

I have problems starting up the jdbc persistemce manager...

My configuration is:



jbossmqstate.xml



java:/SQLPool_DS

...


The DB pool should be OK, as I have used it elsewhere in the application with no problems... The error I get is at the end of this message. If I initialise and start the persistence manager, it appears to start fine.

On a separate note, what should the data type of MESSAGEBLOB be in SQL Server? I've tried binary(8000) but if I try to send to a queue I get a
java.sql.SQLException: String or binary data would be truncated


Thanks in advance for any help,
Paris

Here is the error:

[PersistenceManager] Starting
[PersistenceManager] Stopped
java.lang.NullPointerException
at org.jboss.mq.pm.jdbc.PersistenceManager.restore(PersistenceManager.java:257)
at org.jboss.mq.pm.jdbc.PersistenceManager.startService(PersistenceManager.java:112)
at org.jboss.util.ServiceMBeanSupport.start(ServiceMBeanSupport.java:107)
at java.lang.reflect.Method.invoke(Native Method)
at com.sun.management.jmx.MBeanServerImpl.invoke(MBeanServerImpl.java:1628)
at com.sun.management.jmx.MBeanServerImpl.invoke(MBeanServerImpl.java:1523)
at org.jboss.configuration.ConfigurationService$ServiceProxy.invoke(ConfigurationService.java:836)
at $Proxy0.start(Unknown Source)
at org.jboss.util.ServiceControl.start(ServiceControl.java:81)
at java.lang.reflect.Method.invoke(Native Method)
at com.sun.management.jmx.MBeanServerImpl.invoke(MBeanServerImpl.java:1628)
at com.sun.management.jmx.MBeanServerImpl.invoke(MBeanServerImpl.java:1523)
at org.jboss.Main.(Main.java:221)
at org.jboss.Main$1.run(Main.java:127)
at java.security.AccessController.doPrivileged(Native Method)
at org.jboss.Main.main(Main.java:123)
[Configuration] java.lang.NullPointerException
[Configuration] at org.jboss.mq.pm.jdbc.PersistenceManager.restore(PersistenceManager.java:257)
[Configuration] at org.jboss.mq.pm.jdbc.PersistenceManager.startService(PersistenceManager.java:112)
[Configuration] at org.jboss.util.ServiceMBeanSupport.start(ServiceMBeanSupport.java:107)
[Configuration] at java.lang.reflect.Method.invoke(Native Method)
[Configuration] at com.sun.management.jmx.MBeanServerImpl.invoke(MBeanServerImpl.java:1628)
[Configuration] at com.sun.management.jmx.MBeanServerImpl.invoke(MBeanServerImpl.java:1523)
[Configuration] at org.jboss.configuration.ConfigurationService$ServiceProxy.invoke(ConfigurationService.java:836)
[Configuration] at $Proxy0.start(Unknown Source)
[Configuration] at org.jboss.util.ServiceControl.start(ServiceControl.java:81)
[Configuration] at java.lang.reflect.Method.invoke(Native Method)
[Configuration] at com.sun.management.jmx.MBeanServerImpl.invoke(MBeanServerImpl.java:1628)
[Configuration] at com.sun.management.jmx.MBeanServerImpl.invoke(MBeanServerImpl.java:1523)
[Configuration] at org.jboss.Main.(Main.java:221)
[Configuration] at org.jboss.Main$1.run(Main.java:127)
[Configuration] at java.security.AccessController.doPrivileged(Native Method)
[Configuration] at org.jboss.Main.main(Main.java:123)

[rlynn]

Did you ever get this resolved. I have the same issue.

[parisd]

I think the problem is that the datasource has not been yet registered when the PersistanceManager is being initialised. It seems to start up OK if you wait until the server is up and then init and start it from the web interface (port 8082). You also have to restart any queues you have defined.

That solves _that_ problem... But you better try it yourself.

cheers,
paris

[hchirino]

Was this with the 3.0 alpha release?

I thought that JDBC was working in that release.

[parisd]

I've only tried it up to version 2.4.4. Maybe it's OK now (but is there any kind of documentation for version 3?)