Connection of glue with rds database isn't working

I am trying to connect AWS glue crawler with a postgres db on RDS. Both the crawler and DB are in the same region. steps followed:

1. created a connection with jdbc url username and password(credentials are correct and working in other applications)
2. in the VPC I created an endpoint within a particular subnet.
3. created a NAT gateway
4. edited the route tables to target the NAT gateway
5. in the security group of the rds db added self-referencing inbound rule for all TCP ports.
6. added the security group in the glue connection Now when I test the connection i get Failed to test connection flip_rds-23 due to FAILED status. on checking the logs i get 2024-04-24T16:00:17.670+05:30 ERROR StatusLogger Unrecognized format specifier [d] 2024-04-24T16:00:17.671+05:30 ERROR StatusLogger Unrecognized conversion specifier [d] starting at position 16 in conversion pattern. what am i missing here?