Then, modify the handler code to be as follows:
@Override public String handleRequest(String greetee, Context context) { LambdaLogger logger = context.getLogger(); logger.log("Lets greet "+ greetee); String userName = "letspollDB_master"; String password = "......."; String url = "jdbc:postgresql://letspolldb.c9mlwulrnppz.us-west-1.rds.amazonaws.com:5432/letsPoll"; try { Connection conn = DriverManager.getConnection(url, userName, password); DSLContext dslContext = DSL.using(conn, SQLDialect.POSTGRES); Record result = dslContext.fetchOne("SELECT * FROM now()"); Timestamp ts = (java.sql.Timestamp) result.get("now"); return "Hello, " + greetee + " on "+ts.toString() +" as per the time on database server"; } catch (Exception e) { e.printStackTrace(); ...
