File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
Win a copy of Clojure in Action this week in the Clojure forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

JBOSS error invalid column index while server startup

 
ravikanth reddy
Ranch Hand
Posts: 46
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hello,

I am using JBOSS-4.2.3GA with clustering. java version 1.5
After upgrading MESSAGING version 1.4.4GA to 1.4.5GA I am facing below problems while server start up.
If I truncate the tables jbm_msg and jbm_msg_ref before server startup, server is starting without any problems.


Could you please let me know what mistake I have done?
If I replace messaging 1.4.5 jars with 1.4.4 it is working fine.
 
uttam kumar
Ranch Hand
Posts: 128
Eclipse IDE Java Oracle
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Looks like JMS tables are not being created during server startup. Have you made any changes to existing JBoss application server?
 
uttam kumar
Ranch Hand
Posts: 128
Eclipse IDE Java Oracle
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Looks like you have removed hsqldb-ds.xml as I can't see 'DefaultDS' JNDI bound to datasource,ie, following line is not present in your server log
 
ravikanth reddy
Ranch Hand
Posts: 46
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Thanks Uttam for your reply.

I am using OracleDB. I have oracle-ds.xml isntead hsqldb-ds.xml.

And I configured DefaultDS as OracleDS in my *-ds.xml



This problem is not coming if I truncate jbm_msg and jbm_msg_ref or jbm_postoffice tables. If I go back to 1.4.4GA version everything is smooth.
 
Jaikiran Pai
Marshal
Pie
Posts: 10444
227
IntelliJ IDE Ubuntu
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Why are you changing those jars, by the way?
 
uttam kumar
Ranch Hand
Posts: 128
Eclipse IDE Java Oracle
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Please post the contents of your oracle-ds.xml
 
ravikanth reddy
Ranch Hand
Posts: 46
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hello,

@Jaikiran: We are upgrading messaging version from 1.4.4GA to 1.4.5GA.

@Uttam: Please find below files.
 
Jaikiran Pai
Marshal
Pie
Posts: 10444
227
IntelliJ IDE Ubuntu
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
The upgrade to 1.4.5 version doesn't appear to be just a jar file replacement. New column has been added to some table(s) which means that the *-persistence-service.xml too need updates. Also read the Readme that comes with this version. It also mentions some required changes to some other jar files. Overall, just dropping in new jars isn't a good idea.
 
ravikanth reddy
Ranch Hand
Posts: 46
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hello,

Thanks a lot for your suggestion Jaikiran. Yes in one of the node I have not updated *-persistance-service.xml.

Now problem is resolved.



Thanks.
 
I agree. Here's the link: http://aspose.com/file-tools
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic