JDBC sql query

 
1
0
-1

HI, i am only using Community edition so i use JDBC binder to get the information of the current user. but i doesn't seem to wrok, what is wrong with my code? thank you!

 

    CommentAdd your comment...

    3 answers

    1.  
      1
      0
      -1

      Hi Jedi

      You can view the error log in your pc/server Joget directory: 

      C:\Joget-v5-Enterprise\apache-tomcat-8.0.20\logs
        CommentAdd your comment...
      1.  
        1
        0
        -1

        hi Anders, where can i see the error log? i tried running this to the MSSQL database and is works, but i am using mySQL database

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

          Hi,

          Did you check the error messages in the console or log? That should indicate what the error is. Looking at the screenshot, are the column names correct? Don't think there are cusername or c_username columns in the dir_user table.

           

          1. jedi

            hi Anders, where can i see the error log? i tried running this to the MSSQL database and is works, but i am using mySQL database

          CommentAdd your comment...