Instaling on Oracle.

Some of the database constraints can not be created on Oracle due to the obect name length constraint of 30 characters.

Is Joget certified to run on Oracle?

Regards,

Ben.

  • No labels

7 Comments

  1. Ben

    Hi,

    I altered the creation script with shorter constraint names and got the database installed. The next problem was with Hibernate complaining about the Oracle 11 major version. I updated the Hibernate dialect setting to use Oracle10gDialect as suggested on another forum since Hibernate does not support 11g yet and updated the included Hibernate jar file to a newer version (3.3.1) - unfortunately now I get a "org.springframework.beans.factory.BeanCreationException" error with a "java.lang.NoClassDefFoundError" exception when using the new Hibernate jar.

    Any suggestions will be appreciated.

    Thanks,

    Ben.

    1. Tiensoon

      Hi Ben,

      I have tried running Joget Workflow on Oracle 10g Express (10.2.0.1.0), and I could start it up and login to Workflow Management Console, without changing anything for Hibernate.

      I have configured the wflow/datasource-sample.properties as such:

      workflowUser=joget
sharkDriver=oracle.jdbc.driver.OracleDriver
workflowPassword=joget
formUrl=jdbc\:oracle\:thin\:@localhost\:1521\:XE
sharkPassword=joget
directoryPassword=joget
workflowDriver=oracle.jdbc.driver.OracleDriver
reportUrl=jdbc\:oracle\:thin\:@localhost\:1521\:XE
workflowUrl=jdbc\:oracle\:thin\:@localhost\:1521\:XE
profileName=
directoryUrl=jdbc\:oracle\:thin\:@localhost\:1521\:XE
directoryDriver=oracle.jdbc.driver.OracleDriver
reportPassword=joget
directoryUser=joget
sharkUser=joget
formUser=joget
reportUser=joget
sharkUrl=jdbc\:oracle\:thin\:@localhost\:1521\:XE
formDriver=oracle.jdbc.driver.OracleDriver
formPassword=joget
reportDriver=oracle.jdbc.driver.OracleDriver

      I'm not too sure if it works for Oracle 11g. Never tested it myself

  2. Tiensoon

    For further details on running Joget Workflow with Oracle 10g, please refer to this page in the Knowledge Base - Running Joget Workflow with Oracle 10g

  3. salman khan

    Hello Tiensoon brother,please do see the following problem and i would be very thankful if you could reply sooner.
    i have configured joget workflow with oracle 10 g and it works fine.Now the problem for me is regarding beanshell plugin.

    I want to populate a drop down with some values from a table in my oracle database,I put the following code in the beanshell configuration,Please see if there is any problem with the code,or should i include some more libraries or what else should i do after putting the code it gives an error saying      *unknown source*. please let me know where can the problem be,i really need to work it out,or show me an alternative.thank you.

    Note:   i am running oracle and joget workflow on my local machine.l

    Beanshell configuration code.

    import java.sql.*;

    Connection con = null;

    try {

        Class.forName("oracle.jdbc.driver.OracleDriver").newInstance();

        con = DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:oradb", "root", "root");

        if(!con.isClosed()){

            System.out.println("Successfully connected to MySQL server using TCP/IP...");

            PreparedStatement stmt = con.createStatement();

            stmt.executeUpdate("UPDATE formdata_simpleflow set c_status='#assignment.activityId#' WHERE processId='#assignment.processId#'");

        }

    {color:#3366ff}} catch(Exception e) {{color}

        System.err.println("Exception: " + e.getMessage());

    {color:#3366ff}} finally {{color}

        try {

            if(con != null)

                con.close();

        } catch(SQLException e) {}

    1. Tiensoon

      The "unknown source" error possibly suggests that, the JDBC URL (jdbc:oracle:thin:@localhost:1521:oradb) specified is incorrect. 

      Could you try verify this JDBC connection with a universal SQL client, such as SQuirreL SQL?

      1. salman khan

        the oracle is actually connected with joget workflow,it saves our form information and tables that we generate in joget workflow.the problem just comes with the beanshell plugin.
        the path that i have provided is basically the one i took from workflow datasource so i think the path is

        correct because the rest of the workflow works fine with the database. if you see any problem in the syntax of the path regarding beanshell then correct me.

        (jdbc:oracle:thin:@localhost:1521:oradb)   

        Please also let me know if i can use another better plugin that is more easy to work with and also tell me

        where can i get it.
        please see the following error log.thank you.

        Nov 02, 2011 3:11:29 PM org.joget.apps.form.lib.BeanShellFormBinder executeScrip
        t
        WARNING: Error executing script
        Parse error at line 14, column 33.  Encountered: ,
                at bsh.Parser.generateParseException(Unknown Source)
                at bsh.Parser.jj_consume_token(Unknown Source)
                at bsh.Parser.Statement(Unknown Source)
                at bsh.Parser.BlockStatement(Unknown Source)
                at bsh.Parser.Line(Unknown Source)
                at bsh.Interpreter.Line(Unknown Source)
                at bsh.Interpreter.eval(Unknown Source)
                at bsh.Interpreter.eval(Unknown Source)
                at bsh.Interpreter.eval(Unknown Source)
                at org.joget.apps.form.lib.BeanShellFormBinder.executeScript(BeanShellFo
        rmBinder.java:73)
                at org.joget.apps.form.lib.BeanShellFormBinder.load(BeanShellFormBinder.
        java:44)
                at org.joget.apps.form.service.FormUtil.executeOptionBinders(FormUtil.ja
        va:278)
                at org.joget.apps.form.service.FormUtil.executeOptionBinders(FormUtil.ja
        va:286)
                at org.joget.apps.form.service.FormUtil.executeOptionBinders(FormUtil.ja
        va:286)
                at org.joget.apps.form.service.FormUtil.executeOptionBinders(FormUtil.ja
        va:286)
                at org.joget.apps.form.service.FormService.executeFormOptionsBinders(For
        mService.java:337)
                at org.joget.apps.form.service.FormService.previewElement(FormService.ja
        va:49)
                at org.joget.apps.app.controller.FormBuilderWebController.previewForm(Fo
        rmBuilderWebController.java:108)
                at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
                at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.
        java:57)
                at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAcces
        sorImpl.java:43)
                at java.lang.reflect.Method.invoke(Method.java:601)
                at org.springframework.web.bind.annotation.support.HandlerMethodInvoker.
        doInvokeMethod(HandlerMethodInvoker.java:421)
                at org.springframework.web.bind.annotation.support.HandlerMethodInvoker.
        invokeHandlerMethod(HandlerMethodInvoker.java:136)
                at org.springframework.web.servlet.mvc.annotation.AnnotationMethodHandle
        rAdapter.invokeHandlerMethod(AnnotationMethodHandlerAdapter.java:326)
                at org.springframework.web.servlet.mvc.annotation.AnnotationMethodHandle
        rAdapter.handle(AnnotationMethodHandlerAdapter.java:313)
                at org.joget.commons.spring.web.ParameterizedAnnotationMethodHandlerAdap
        ter.handle(ParameterizedAnnotationMethodHandlerAdapter.java:30)
                at org.springframework.web.servlet.DispatcherServlet.doDispatch(Dispatch
        erServlet.java:875)
                at org.springframework.web.servlet.DispatcherServlet.doService(Dispatche
        rServlet.java:807)
                at org.springframework.web.servlet.FrameworkServlet.processRequest(Frame
        workServlet.java:571)
                at org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServ
        let.java:511)
                at javax.servlet.http.HttpServlet.service(HttpServlet.java:637)
                at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
                at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Appl
        icationFilterChain.java:290)
                at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationF
        ilterChain.java:206)
                at org.displaytag.filter.ResponseOverrideFilter.doFilter(ResponseOverrid
        eFilter.java:125)
                at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Appl
        icationFilterChain.java:235)
                at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationF
        ilterChain.java:206)
                at org.springframework.security.util.FilterChainProxy$VirtualFilterChain
        .doFilter(FilterChainProxy.java:394)
                at org.springframework.security.intercept.web.FilterSecurityInterceptor.
        invoke(FilterSecurityInterceptor.java:109)
                at org.springframework.security.intercept.web.FilterSecurityInterceptor.
        doFilter(FilterSecurityInterceptor.java:83)
                at org.springframework.security.util.FilterChainProxy$VirtualFilterChain
        .doFilter(FilterChainProxy.java:406)
                at org.springframework.security.ui.SessionFixationProtectionFilter.doFil
        terHttp(SessionFixationProtectionFilter.java:67)
                at org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringS
        ecurityFilter.java:53)
                at org.springframework.security.util.FilterChainProxy$VirtualFilterChain
        .doFilter(FilterChainProxy.java:406)
                at org.springframework.security.ui.ExceptionTranslationFilter.doFilterHt
        tp(ExceptionTranslationFilter.java:101)
                at org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringS
        ecurityFilter.java:53)
                at org.springframework.security.util.FilterChainProxy$VirtualFilterChain
        .doFilter(FilterChainProxy.java:406)
                at org.springframework.security.providers.anonymous.AnonymousProcessingF
        ilter.doFilterHttp(AnonymousProcessingFilter.java:105)
                at org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringS
        ecurityFilter.java:53)
                at org.springframework.security.util.FilterChainProxy$VirtualFilterChain
        .doFilter(FilterChainProxy.java:406)
                at org.springframework.security.ui.AbstractProcessingFilter.doFilterHttp
        (AbstractProcessingFilter.java:278)
                at org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringS
        ecurityFilter.java:53)
                at org.springframework.security.util.FilterChainProxy$VirtualFilterChain
        .doFilter(FilterChainProxy.java:406)
                at org.springframework.security.ui.AbstractProcessingFilter.doFilterHttp
        (AbstractProcessingFilter.java:278)
                at org.joget.apps.workflow.security.WorkflowHttpAuthProcessingFilter.doF
        ilterHttp(WorkflowHttpAuthProcessingFilter.java:39)
                at org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringS
        ecurityFilter.java:53)
                at org.springframework.security.util.FilterChainProxy$VirtualFilterChain
        .doFilter(FilterChainProxy.java:406)
                at org.springframework.security.ui.logout.LogoutFilter.doFilterHttp(Logo
        utFilter.java:89)
                at org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringS
        ecurityFilter.java:53)
                at org.springframework.security.util.FilterChainProxy$VirtualFilterChain
        .doFilter(FilterChainProxy.java:406)
                at org.springframework.security.context.HttpSessionContextIntegrationFil
        ter.doFilterHttp(HttpSessionContextIntegrationFilter.java:235)
                at org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringS
        ecurityFilter.java:53)
                at org.springframework.security.util.FilterChainProxy$VirtualFilterChain
        .doFilter(FilterChainProxy.java:406)
                at org.springframework.security.util.FilterChainProxy.doFilter(FilterCha
        inProxy.java:185)
                at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(D
        elegatingFilterProxy.java:236)
                at org.springframework.web.filter.DelegatingFilterProxy.doFilter(Delegat
        ingFilterProxy.java:167)
                at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Appl
        icationFilterChain.java:235)
                at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationF
        ilterChain.java:206)
                at org.springframework.web.filter.CharacterEncodingFilter.doFilterIntern
        al(CharacterEncodingFilter.java:96)
                at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerR
        equestFilter.java:76)
                at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Appl
        icationFilterChain.java:235)
                at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationF
        ilterChain.java:206)
                at com.shm.servlets.shmResponseFilterServlet.doFilter(shmResponseFilterS
        ervlet.java:40)
                at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Appl
        icationFilterChain.java:235)
                at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationF
        ilterChain.java:206)
                at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperV
        alve.java:233)
                at org.apache.catalina.core.StandardContextValve.invoke(StandardContextV
        alve.java:191)
                at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.j
        ava:128)
                at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.j
        ava:102)
                at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineVal
        ve.java:109)
                at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.jav
        a:286)
                at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java
        :845)
                at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.proce
        ss(Http11Protocol.java:583)
                at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:44
        7)
                at java.lang.Thread.run(Thread.java:722)

        1. Tiensoon

          The log suggests that there is an error resulted from line 14 of the codes. Could you check with the 14th line of your codes and troubleshoot?