Is it anyway to get the database user and password from "datasource & profile"

 
1
0
-1

Dear Expert,

I did not want to hard code the database user and password at the "Bean shell Form builder" when accessing the joget database. So anyway for us to get the information from the Joget configuration / datasource profile ?

Best Regards

Tony Chu

    CommentAdd your comment...

    1 answer

    1.  
      1
      0
      -1

      Hi,

      From an example in Store Form Field Data to Multiple Tables, you can retrieve the default datasource connection directly using the following

      // retrieve connection from the default datasource
DataSource ds = (DataSource)AppUtil.getApplicationContext().getBean("setupDataSource");
Connection con = ds.getConnection();
        CommentAdd your comment...