Need help on Jasper Server with Oracle 10g

[rghanta]

Hi,

Did anyone install Jasper Server with Oracle 10g as the back-end? I tried it and I had logged in successfully into Jasper Server. But I am getting the following exception whenever I try to open the repository. I set the hibernate.show_sql property to ture to look at the query which is causing this exception. The SQL query which is being executed just above this step and causing this exception is  

Hibernate: select this.id as id103_, this.version as version103_, this.uri as uri103_, this.hidden as hidden103_, this.name as name103_, this.label as label103_, this.description as descript7_103_, this.parent_folder as parent8_103_, this.creation_date as creation9_103_ from JIResourceFolder this where this.parent_folder = ? and ((hidden=false ))

I checked the SQL schema for the table JIResourceFolder and found that the values should be either 0 or 1 for the field 'hidden' as the data type for 'hidden' is Number. Can some body help me how to fix this issue and the location where I need to change this.???

Code:

13:17:58,438 ERROR HibernateDaoImpl,[ACTIVE] ExecuteThread: '0' for queue: 'weblogic.kernel.Default (self-tuning)':61 - Hibernate DataAccessExceptionorg.springframework.orm.hibernate3.HibernateJdbcException: JDBC exception on Hibernate data access; nested exception is org.hibernate.exception.SQLGrammarException: could not execute queryCaused by: org.hibernate.exception.SQLGrammarException: could not execute query	at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:67)	at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)	at org.hibernate.loader.Loader.doList(Loader.java:2214)	at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2095)	at org.hibernate.loader.Loader.list(Loader.java:2090)	at org.hibernate.hql.classic.QueryTranslatorImpl.list(QueryTranslatorImpl.java:888)	at org.hibernate.engine.query.HQLQueryPlan.performList(HQLQueryPlan.java:172)	at org.hibernate.impl.SessionImpl.listFilter(SessionImpl.java:1477)	at org.hibernate.impl.CollectionFilterImpl.list(CollectionFilterImpl.java:51)	at com.jaspersoft.jasperserver.api.metadata.common.service.impl.hibernate.HibernateRepositoryServiceImpl$9$1.doInHibernate(HibernateRepositoryServiceImpl.java:805)	at org.springframework.orm.hibernate3.HibernateTemplate.execute(HibernateTemplate.java:367)	at org.springframework.orm.hibernate3.HibernateTemplate.executeFind(HibernateTemplate.java:337)	at com.jaspersoft.jasperserver.api.metadata.common.service.impl.hibernate.HibernateRepositoryServiceImpl$9.execute(HibernateRepositoryServiceImpl.java:803)	at com.jaspersoft.jasperserver.api.metadata.common.service.impl.HibernateDaoImpl.executeCallback(HibernateDaoImpl.java:58)	at com.jaspersoft.jasperserver.api.metadata.common.service.impl.hibernate.HibernateRepositoryServiceImpl.getSubFolders(HibernateRepositoryServiceImpl.java:795)	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)	at java.lang.reflect.Method.invoke(Method.java:597)	at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:281)	at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:187)	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:154)	at org.acegisecurity.intercept.method.aopalliance.MethodSecurityInterceptor.invoke(MethodSecurityInterceptor.java:66)	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:176)	at org.acegisecurity.intercept.method.aopalliance.MethodSecurityInterceptor.invoke(MethodSecurityInterceptor.java:66)	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:176)	at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:107)	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:176)	at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:107)	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:176)	at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:210)	at $Proxy97.getSubFolders(Unknown Source)	at com.jaspersoft.jasperserver.war.model.impl.RepositoryExplorerTreeDataProviderImpl.processFolder(RepositoryExplorerTreeDataProviderImpl.java:121)	at com.jaspersoft.jasperserver.war.model.impl.RepositoryExplorerTreeDataProviderImpl.getNode(RepositoryExplorerTreeDataProviderImpl.java:90)	at com.jaspersoft.jasperserver.war.model.impl.RepositoryExplorerTreeDataProviderImpl.getChildren(RepositoryExplorerTreeDataProviderImpl.java:66)	at com.jaspersoft.jasperserver.war.model.TreeHelper.processMiniNode(TreeHelper.java:138)	at com.jaspersoft.jasperserver.war.model.TreeHelper.getSubtree(TreeHelper.java:100)	at com.jaspersoft.jasperserver.war.action.tree.TreeAction.getNode(TreeAction.java:116)	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)	at java.lang.reflect.Method.invoke(Method.java:597)	at org.springframework.webflow.util.DispatchMethodInvoker.invoke(DispatchMethodInvoker.java:103)	at org.springframework.webflow.action.MultiAction.doExecute(MultiAction.java:136)	at org.springframework.webflow.action.AbstractAction.execute(AbstractAction.java:203)	at org.springframework.webflow.engine.AnnotatedAction.execute(AnnotatedAction.java:142)	at org.springframework.webflow.engine.ActionExecutor.execute(ActionExecutor.java:61)	at org.springframework.webflow.engine.ActionState.doEnter(ActionState.java:180)	at org.springframework.webflow.engine.State.enter(State.java:200)	at org.springframework.webflow.engine.Transition.execute(Transition.java:229)	at org.springframework.webflow.engine.DecisionState.doEnter(DecisionState.java:58)	at org.springframework.webflow.engine.State.enter(State.java:200)	at org.springframework.webflow.engine.Flow.start(Flow.java:557)	at org.springframework.webflow.engine.impl.RequestControlContextImpl.start(RequestControlContextImpl.java:195)	at org.springframework.webflow.engine.impl.FlowExecutionImpl.start(FlowExecutionImpl.java:189)	at org.springframework.webflow.executor.FlowExecutorImpl.launch(FlowExecutorImpl.java:206)	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)	at java.lang.reflect.Method.invoke(Method.java:597)	at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:281)	at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:187)	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:154)	at org.acegisecurity.intercept.method.aopalliance.MethodSecurityInterceptor.invoke(MethodSecurityInterceptor.java:66)	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:176)	at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:210)	at $Proxy113.launch(Unknown Source)	at org.springframework.webflow.executor.support.FlowRequestHandler.handleFlowRequest(FlowRequestHandler.java:131)	at org.springframework.webflow.executor.mvc.FlowController.handleRequestInternal(FlowController.java:170)	at org.springframework.web.servlet.mvc.AbstractController.handleRequest(AbstractController.java:153)	at org.springframework.web.servlet.mvc.SimpleControllerHandlerAdapter.handle(SimpleControllerHandlerAdapter.java:45)	at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:820)	at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:755)	at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:396)	at org.springframework.web.servlet.FrameworkServlet.doGet(FrameworkServlet.java:350)	at javax.servlet.http.HttpServlet.service(HttpServlet.java:707)	at javax.servlet.http.HttpServlet.service(HttpServlet.java:820)	at weblogic.servlet.internal.StubSecurityHelper$ServletServiceAction.run(StubSecurityHelper.java:227)	at weblogic.servlet.internal.StubSecurityHelper.invokeServlet(StubSecurityHelper.java:125)	at weblogic.servlet.internal.ServletStubImpl.execute(ServletStubImpl.java:292)	at weblogic.servlet.internal.TailFilter.doFilter(TailFilter.java:26)	at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:42)	at com.jaspersoft.jasperserver.war.common.UploadMultipartFilter.doFilter(UploadMultipartFilter.java:86)	at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:42)	at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:264)	at org.acegisecurity.ui.switchuser.SwitchUserProcessingFilter.doFilter(SwitchUserProcessingFilter.java:335)	at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274)	at org.acegisecurity.intercept.web.FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:107)	at org.acegisecurity.intercept.web.FilterSecurityInterceptor.doFilter(FilterSecurityInterceptor.java:72)	at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274)	at org.acegisecurity.ui.ExceptionTranslationFilter.doFilter(ExceptionTranslationFilter.java:110)	at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274)	at com.jaspersoft.ji.license.JILicenseFilter.doFilter(JILicenseFilter.java:107)	at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274)	at org.acegisecurity.providers.anonymous.AnonymousProcessingFilter.doFilter(AnonymousProcessingFilter.java:125)	at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274)	at com.jaspersoft.jasperserver.api.metadata.user.service.impl.MetadataAuthenticationProcessingFilter.doFilter(MetadataAuthenticationProcessingFilter.java:141)	at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274)	at com.jaspersoft.jasperserver.war.util.RequestParameterAuthenticationFilter.doFilter(RequestParameterAuthenticationFilter.java:97)	at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274)	at org.acegisecurity.ui.basicauth.BasicProcessingFilter.doFilter(BasicProcessingFilter.java:181)	at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274)	at com.jaspersoft.jasperserver.war.UserPreferencesFilter.doFilter(UserPreferencesFilter.java:165)	at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274)	at org.acegisecurity.ui.AbstractProcessingFilter.doFilter(AbstractProcessingFilter.java:217)	at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274)	at com.jaspersoft.jasperserver.war.UserPreferencesFilter.doFilter(UserPreferencesFilter.java:165)	at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274)	at org.acegisecurity.context.HttpSessionContextIntegrationFilter.doFilter(HttpSessionContextIntegrationFilter.java:191)	at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274)	at org.acegisecurity.util.FilterChainProxy.doFilter(FilterChainProxy.java:148)	at org.acegisecurity.util.FilterToBeanProxy.doFilter(FilterToBeanProxy.java:90)	at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:42)	at com.jaspersoft.jasperserver.war.util.CharacterEncodingFilter.doFilter(CharacterEncodingFilter.java:70)	at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:138)	at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:42)	at weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.run(WebAppServletContext.java:3496)	at weblogic.security.acl.internal.AuthenticatedSubject.doAs(AuthenticatedSubject.java:321)	at weblogic.security.service.SecurityManager.runAs(Unknown Source)	at weblogic.servlet.internal.WebAppServletContext.securedExecute(WebAppServletContext.java:2180)	at weblogic.servlet.internal.WebAppServletContext.execute(WebAppServletContext.java:2086)	at weblogic.servlet.internal.ServletRequestImpl.run(ServletRequestImpl.java:1406)	at weblogic.work.ExecuteThread.execute(ExecuteThread.java:201)	at weblogic.work.ExecuteThread.run(ExecuteThread.java:173)Caused by: java.sql.SQLSyntaxErrorException: ORA-00904: "FALSE": invalid identifier	at oracle.jdbc.driver.SQLStateMapping.newSQLException(SQLStateMapping.java:91)	at oracle.jdbc.driver.DatabaseError.newSQLException(DatabaseError.java:112)	at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:173)	at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:455)	at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:413)	at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:1030)	at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:194)	at oracle.jdbc.driver.T4CPreparedStatement.executeForDescribe(T4CPreparedStatement.java:785)	at oracle.jdbc.driver.T4CPreparedStatement.executeMaybeDescribe(T4CPreparedStatement.java:860)	at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1186)	at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3381)	at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3425)	at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeQuery(OraclePreparedStatementWrapper.java:1490)	at weblogic.jdbc.wrapper.PreparedStatement.executeQuery(PreparedStatement.java:128)	at org.hibernate.jdbc.AbstractBatcher.getResultSet(AbstractBatcher.java:186)	at org.hibernate.loader.Loader.getResultSet(Loader.java:1778)	at org.hibernate.loader.Loader.doQuery(Loader.java:662)	at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:224)	at org.hibernate.loader.Loader.doList(Loader.java:2211)	... 121 more

[swood]

Did you set the Hibernate dialect to Oracle?

 

Sherman

Jaspersoft

[rghanta]

Yes..I have modified the hibernate.properties file and set the Dialect to "com.jaspersoft.ji.hibernate.dialect.OracleUnicodeDialect".

[rghanta]

Can somebody help me in this regard? Its really urgent for me...We have got the commercial license of Jasper Suite and haven't got the support details yet to seek support....

Regards,

Ram....

[ramnik]

Did you load sample data from the right js-catalog. There is specific "js-catalog-oracle" for oracle. It is mentioned in jaspeserver - pro -Install guide. Page 32.

[anandharaj]

What version of JS you using? Im using OpenSource JS3.0 and the data type for "hidden" field in JIResourceFolder is "boolean" (Postgres).

 

Maybe you can try change the data type and see the outcome...

[swood]

There must be something wrong with your setup, rghanta.

Did you do the install from source to get the Oracle database set up? Have a look at the source build guide. That would confirm your settings are correct.

 

 

Sherman

Jaspersoft