Integration with Oracle 12c || tables not auto created

 
1
0
-1

I have configured Joget to work with Oracle 12c, and everything works fine, except when trying to submit data on any form I got "Table Or view doesn't exists" error and tables not created.

Only forms that has only one field works fine (tables created and data inserted normally), but the rest throws bellow error.

ERROR 11 Apr 2017 10:36:45 org.joget.apps.form.service.FormService - Error executing store binder
org.hibernate.exception.SQLGrammarException: could not extract ResultSet
at org.hibernate.exception.internal.SQLExceptionTypeDelegate.convert(SQLExceptionTypeDelegate.java:80)
at org.hibernate.exception.internal.StandardSQLExceptionConverter.convert(StandardSQLExceptionConverter.java:49)
at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:126)
at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:112)
at org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.extract(ResultSetReturnImpl.java:91)
at org.hibernate.loader.plan.exec.internal.AbstractLoadPlanBasedLoader.getResultSet(AbstractLoadPlanBasedLoader.java:449)
at org.hibernate.loader.plan.exec.internal.AbstractLoadPlanBasedLoader.executeQueryStatement(AbstractLoadPlanBasedLoader.java:202)
at org.hibernate.loader.plan.exec.internal.AbstractLoadPlanBasedLoader.executeLoad(AbstractLoadPlanBasedLoader.java:137)
at org.hibernate.loader.plan.exec.internal.AbstractLoadPlanBasedLoader.executeLoad(AbstractLoadPlanBasedLoader.java:102)
at org.hibernate.loader.entity.plan.AbstractLoadPlanBasedEntityLoader.load(AbstractLoadPlanBasedEntityLoader.java:186)
at org.hibernate.persister.entity.AbstractEntityPersister.load(AbstractEntityPersister.java:4126)
at org.hibernate.event.internal.DefaultLoadEventListener.loadFromDatasource(DefaultLoadEventListener.java:503)
at org.hibernate.event.internal.DefaultLoadEventListener.doLoad(DefaultLoadEventListener.java:468)
at org.hibernate.event.internal.DefaultLoadEventListener.load(DefaultLoadEventListener.java:213)
at org.hibernate.event.internal.DefaultLoadEventListener.proxyOrLoad(DefaultLoadEventListener.java:259)
at org.hibernate.event.internal.DefaultLoadEventListener.onLoad(DefaultLoadEventListener.java:151)
at org.hibernate.internal.SessionImpl.fireLoad(SessionImpl.java:1106)
at org.hibernate.internal.SessionImpl.access$2000(SessionImpl.java:176)
at org.hibernate.internal.SessionImpl$IdentifierLoadAccessImpl.getReference(SessionImpl.java:2564)
at org.hibernate.internal.SessionImpl.load(SessionImpl.java:986)
at org.joget.apps.form.dao.FormDataDaoImpl.internalLoad(FormDataDaoImpl.java:188)
at org.joget.apps.form.dao.FormDataDaoImpl.loadWithoutTransaction(FormDataDaoImpl.java:171)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:498)
at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:317)
at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:190)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:157)
at org.joget.apps.app.service.AuditTrailInterceptor.invoke(AuditTrailInterceptor.java:17)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)
at org.springframework.transaction.interceptor.TransactionInterceptor$1.proceedWithInvocation(TransactionInterceptor.java:99)
at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:281)
at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:96)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)
at org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:92)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)
at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:207)
at com.sun.proxy.$Proxy28.loadWithoutTransaction(Unknown Source)
at org.joget.apps.app.service.AppServiceImpl.internalLoadFormData(AppServiceImpl.java:1348)
at org.joget.apps.app.service.AppServiceImpl.loadFormDataWithoutTransaction(AppServiceImpl.java:1331)
at org.joget.apps.app.service.AppServiceImpl.storeFormData(AppServiceImpl.java:1438)
at org.joget.apps.app.service.AppServiceImpl.storeFormData(AppServiceImpl.java:1389)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:498)
at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:317)
at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:201)
at com.sun.proxy.$Proxy50.storeFormData(Unknown Source)
at org.joget.apps.form.lib.DefaultFormBinder.store(DefaultFormBinder.java:85)
at org.joget.apps.form.lib.WorkflowFormBinder.store(WorkflowFormBinder.java:97)
at org.joget.apps.form.service.FormServiceImpl.recursiveExecuteFormStoreBinders(FormServiceImpl.java:528)
at org.joget.apps.form.service.FormServiceImpl.executeFormStoreBinders(FormServiceImpl.java:498)
at org.joget.apps.form.service.FormServiceImpl.submitForm(FormServiceImpl.java:287)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:498)
at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:317)
at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:190)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:157)
at org.springframework.transaction.interceptor.TransactionInterceptor$1.proceedWithInvocation(TransactionInterceptor.java:99)
at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:281)
at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:96)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)
at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:207)
at com.sun.proxy.$Proxy26.submitForm(Unknown Source)
at org.joget.apps.app.service.AppServiceImpl.submitForm(AppServiceImpl.java:1257)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:498)
at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:317)
at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:201)
at com.sun.proxy.$Proxy50.submitForm(Unknown Source)
at org.joget.apps.form.lib.SubmitButton.actionPerformed(SubmitButton.java:36)
at org.joget.apps.form.service.FormUtil.executeActions(FormUtil.java:579)
at org.joget.apps.form.service.FormUtil.executeActions(FormUtil.java:587)
at org.joget.apps.form.service.FormUtil.executeActions(FormUtil.java:587)
at org.joget.apps.form.service.FormUtil.executeActions(FormUtil.java:587)
at org.joget.apps.form.service.FormServiceImpl.executeFormActions(FormServiceImpl.java:445)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:498)
at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:317)
at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:201)
at com.sun.proxy.$Proxy26.executeFormActions(Unknown Source)
at org.joget.apps.userview.lib.FormMenu.submitDataForm(FormMenu.java:479)
at org.joget.apps.userview.lib.FormMenu.submitForm(FormMenu.java:227)
at org.joget.apps.userview.lib.FormMenu.getJspPage(FormMenu.java:120)
at org.joget.apps.userview.model.UserviewMenu.getReadyJspPage(UserviewMenu.java:132)
...................................
at java.lang.Thread.run(Thread.java:745)
Caused by: java.sql.SQLSyntaxErrorException: ORA-00942: table or view does not exist

    CommentAdd your comment...

    2 answers

    1.  
      1
      0
      -1

      I found issue and it is mainly Hibernate-Oracle issue.

      I have added blog post here explain issue and how to fix it. http://ourexperienceatntg.blogspot.com.eg/2017/04/joget-hibernate-issue-with-oracle.html

      1. Anders

        Which edition are you using? I'm using the enterprise edition and don't face this issue.

      2. Mostafa Shokiel

        I tried it with community and enterprise v5 and v6 as well; all gave same error.

      CommentAdd your comment...
    2.  
      1
      0
      -1

      Hi, the database tables should be automatically created as required so it is very likely that the db connection user configured does not have sufficient privileges. Make sure that your connection user has sufficient privileges to create and alter tables.

      1. Mostafa Shokiel

        Thanks Anders for your reply, as I mentioned in the question forms with only one field is working fine (table auto created ..etc), in addition db user has dba privilege, so it is not privileges issue. Waiting to hear your thoughts.

      CommentAdd your comment...