alamuvinai Posted July 20, 2015 Share Posted July 20, 2015 Hi All, I am trying to upgrade from version 5.6 to 6.1; made lot of customization code in 5.6; need to integrate those changes to 6.1;steps taken so far:1) download 6.1 source code, built successfully; deployed war file in tomcat. if using post-gres sample db, able to login from UI.2) but i've to use the oracle jasper db. right now using the oracle jasper 5.6 db that I've already. but getting error on tomcat start up.3) How do I fix this error. I am trying to connect from jasper 6.1 source code to jasper5.6 database.4) Is there any db script for oracle that needs to be run on oracle 5.6? Can someone please let me know ASAP?ORA-00904: "REPOPROFIL0_"."OWNER": invalid identifier org.springframework.beans.factory.BeanCreationException:Error creating bean with name 'proOnStartPropagator' defined in ServletContext resource [/WEB-INF/applicationContext-onStart-web-pro.xml]: Invocatio n of init method failed;nested exception is org.springframework.dao.InvalidDataAccessResourceUsageException: could not execute query; SQL [select repoprofil0_.id as id12_, repoprofil0_.attrName as attrNam e12_, repoprofil0_.attrValue as attrValue12_, repoprofil0_.description as descript4_12_, repoprofil0_.owner as owner12_, repoprofil0_.principalobjectclass as principa6_12_, repoprofil0_.principalobjectid a s principa7_12_ from JIProfileAttribute repoprofil0_ where repoprofil0_.principalobjectclass=? and repoprofil0_.principalobjectid=?]; nested exception is org.hibernate.exception.SQLGrammarException: could not execute query at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1514) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:521) Link to comment Share on other sites More sharing options...
alamuvinai Posted August 4, 2015 Author Share Posted August 4, 2015 had to run the dbscripts for oracle on top of jasper 5 db; then it fixed the above issue. thanks! Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now