[jboss-user] [Messaging, JMS & JBossMQ] - SpyJMSException !!!

[lethrech]

hi, 
i have configured jboss (with an ESB service) with oracle 10g in stead of hqldb, the server start without problems but when i execute my application which use ESB i have the following problem: 


2007 06 26 - 11:47:33 INFO  org.jboss.internal.soa.esb.couriers.JmsCourier.jmsConnectRetry [2007 06 
  | 26 - 11:47:33 ERROR org.jboss.internal.soa.esb.couriers.JmsCourier.jmsConnectRetry [JMS error.  Atte
  | mpting JMS reconnect.]
  | org.jboss.mq.SpyJMSException: Could not store message: 1 msg=0 hard NOT_STORED PERSISTENT queue=QUEU
  | E.A priority=4 lateClone=false hashCode=32771983; - nested throwable: (java.sql.SQLException: Type d
  | e colonne non valide)
  | 	at org.jboss.mq.pm.jdbc2.PersistenceManager.add(PersistenceManager.java:941)
  | 	at org.jboss.mq.server.PersistentQueue.addMessage(PersistentQueue.java:58)
  | 	at org.jboss.mq.server.JMSQueue.addMessage(JMSQueue.java:179)
  | 	at org.jboss.mq.server.JMSDestinationManager.addMessage(JMSDestinationManager.java:406)
  | 	at org.jboss.mq.server.JMSDestinationManager.addMessage(JMSDestinationManager.java:390)
  | 	at org.jboss.mq.server.JMSServerInterceptorSupport.addMessage(JMSServerInterceptorSupport.java:150)
  | 
  | 	at org.jboss.mq.security.ServerSecurityInterceptor.addMessage(ServerSecurityInterceptor.java:168)
  | 	at org.jboss.mq.server.TracingInterceptor.addMessage(TracingInterceptor.java:266)
  | 	at org.jboss.mq.server.JMSServerInvoker.addMessage(JMSServerInvoker.java:151)
  | 	at org.jboss.mq.il.uil2.ServerSocketManagerHandler.handleMsg(ServerSocketManagerHandler.java:108)
  | 	at org.jboss.mq.il.uil2.SocketManager$ReadTask.handleMsg(SocketManager.java:396)
  | 	at org.jboss.mq.il.uil2.msgs.BaseMsg.run(BaseMsg.java:392)
  | 	at EDU.oswego.cs.dl.util.concurrent.PooledExecutor$Worker.run(PooledExecutor.java:748)
  | 	at java.lang.Thread.run(Thread.java:595)
  | Caused by: java.sql.SQLException: Type de colonne non valide	 


folowing are the script of jboss schema: 

CREATE TABLE TIMERS(TIMERID VARCHAR(80) NOT NULL,TARGETID VARCHAR(250) NOT NULL,INITIALDATE TIMESTAM
  | P NOT NULL,TIMERINTERVAL SYS.ANYDATA,INSTANCEPK SYS.ANYDATA,INFO SYS.ANYDATA,CONSTRAINT TIMERS_PK PR
  | IMARY KEY(TIMERID,TARGETID));
  | CREATE TABLE HILOSEQUENCES(SEQUENCENAME VARCHAR(50) NOT NULL,HIGHVALUES INTEGER NOT NULL,CONSTRAINT 
  | HILO_PK PRIMARY KEY(SEQUENCENAME));
  | CREATE TABLE JMS_USERS(USERID VARCHAR(32) NOT NULL PRIMARY KEY,PASSWD VARCHAR(32) NOT NULL,CLIENTID 
  | VARCHAR(128));
  | CREATE TABLE JMS_ROLES(ROLEID VARCHAR(32) NOT NULL,USERID VARCHAR(32) NOT NULL,PRIMARY KEY(USERID,RO
  | LEID));
  | CREATE TABLE JMS_SUBSCRIPTIONS(CLIENTID VARCHAR(128) NOT NULL,SUBNAME VARCHAR(128) NOT NULL,TOPIC VA
  | RCHAR(255) NOT NULL,SELECTOR VARCHAR(255),PRIMARY KEY(CLIENTID,SUBNAME));
  | CREATE TABLE JMS_MESSAGES(MESSAGEID INTEGER NOT NULL,DESTINATION VARCHAR(255) NOT NULL,TXID INTEGER,
  | TXOP CHAR(1),MESSAGEBLOB SYS.ANYDATA,PRIMARY KEY(MESSAGEID,DESTINATION));
  | CREATE INDEX JMS_MESSAGES_TXOP_TXID ON JMS_MESSAGES(TXOP,TXID);
  | CREATE INDEX JMS_MESSAGES_DESTINATION ON JMS_MESSAGES(DESTINATION);
  | CREATE TABLE JMS_TRANSACTIONS(TXID INTEGER NOT NULL PRIMARY KEY); 
	 


i m using jboss4.0.4 
DB: oracle10g 10.2.0.3
OS: XP professional 2002 SP2 

can you help me 
best regards

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

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