Thu, 24 Sep 2026
Login

Integration with Oracle 12c || tables not auto created

Confluence User - 11 Apr, 2017

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

forms;userviews;integration;database;oracle

5

Confluence User •
12 Apr, 2017 •
confluenceUser •
•
confluenceUser •

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.

Confluence User •
12 Apr, 2017 •
confluenceUser •
•
confluenceUser •

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.

Confluence User •
18 Apr, 2017 •
confluenceUser •
1 •
confluenceUser •

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

Confluence User •
19 Apr, 2017 •
confluenceUser •
•
confluenceUser •

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

Confluence User •
19 Apr, 2017 •
confluenceUser •
•
confluenceUser •

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

1
CSV | Excel | XML | PDF
RELATED QUESTIONS
Process not starting with Form submission.
Form Submission Performance Issue
How can I set dedicated datasource for each app ?
Export As PDF
Select Box
one to many relationship
Can we create a dropdown field directly in a Joget List so that users can change the status of a record from the list view itself?
How to auto load client data after selecting it in a dropdown?
Retrieve image upload from form into PDF
Issue Saving AJAX Subform Data to Datalist in Joget
1
CSV | Excel | XML | PDF

Your answer

To answer a question you'll need an account.

Print