Hi all,

    I wanted to ask, whether Joget supports other databases like Redis (key-value database)?

 I wanted to use it in a project. Whether we can use it in BeanShell plugin for accessing Redis database by using its driver?

Thanks.

  • No labels

8 Comments

  1. Hugo

    As long as there's driver for it, I don't see why not. You can import in classes that you may need in the BeanShell Plugin as you code.

    See http://code.google.com/p/jredis/wiki/JRedisQuickStart

    1. chait

      Hi Hugo,

         Thanks for replying. You mean to say we can use JRedis as a driver for JDBC connection?

      Is that possible?

             I have read the link you gave me. We have to use maven to install JRedis and it produces

      a jar file.

      Thanks.

      1. Vignesh Balasubramanian

        Hi Chait,

        Hope you shud be aware that every database comes with its own driver JAR file for connecting from Java code (for example, mysql-connector-java-bin.jar for mysql, etc), so probably Redis should be having its driver and If I'm not wrong, JRedis is just a reference implementation (client) for using methods available in the Redis classes.

        Try adding the driver JAR and code your requirement within the BeanShell Plugin, as you would connect to mysql/sqlserver from a simple java code.

        Regards,

        Vignesh

        1. Mark Knowles

          Hi Vignesh

          You can see my question to Chait. It is fundamental to our project that we can read and write from a Unidata database with Joget, so any sample code you can provide would be very useful.

          Many Thanks

          Mark

      2. Mark Knowles

        Hi Chait

        Did you have any success using Joget with Redis? I ask, because I would like to use Joget with the Unidata database. Do you or anybody else have some sample code we can modify? Unidata has its own driver JAR file, so what Vignesh suggests sounds sensible.

        Many Thanks

        Mark

    2. Mark Knowles

      Hi Hugo

      As I indicated in the messages I sent to others I am trying to integrate Joget with Unidata database as without that Joget is unfortunately of no use to our project. Do I need to use hash variables in Beanshell and then pass the values to the Unidata JAR file driver?

      Your assistance would be very much appreciated as I really like the functionality Joget offers, but without Unidata integration we can't use it. If we have success I would be happy to share our code to make it easier for others to integrate with other databases.

      I have replied to more than one person as I am not sure if others can see my message or not if I send it to just one person. I am not yet very familiar with the Joget forum.

      Many Thanks

      Mark

      1. Hugo

        Hi Mark,

        Thanks for your interest in Joget. I believe that you will need to load the necessary driver/library first before connecting to Unidata database.

        Here's a quick sample using mysql.

        import java.sql.*;
import java.util.*;
import org.joget.apps.form.model.*;
import org.joget.apps.form.service.*;

Connection con = null;

try {
 Class.forName("YOUR DB CLASS").newInstance();
 con = DriverManager.getConnection("YOUR DB PATH", "DB USERNAME", "DB PASSWORD");

 if(!con.isClosed()){
  PreparedStatement stmt = con.prepareStatement("QUERY");
  ResultSet rs = stmt.executeQuery();

  while (rs.next()) {
//retrieve row
 }

        You do not need to use hash variable in order to communicate with the database unless you have specific need on this.
        Cheers~

        1. Mark Knowles

          Hi Hugo
          Thanks for the help!
          You have made it clear how we can interface with Unidata.
          We hope to be able to read data from the forms and write to our unidata database.
          Similarly we hope to read data from our unidata database like a list of contacts and include those in a form.
          Is this doable and if so can you give me a few tips on how to interact with the joget forms or point me to suitable entries in the forum?
          We aim to setup a simple project to start with with 1 form and 1 textbox just to see if what we plan to do will work.
          As I said any code we produce we would be happy to share with others on the forum.
          Many Thanks
          Mark