Some problems and its solutions

look at: https://stackabuse.com/how-to-get-current-date-and-time-in-java/  valuable source about java date classes : https://stackoverflow.com/questions/32437550/whats-the-difference-between-instant-and-localdatetime System.out.println(LocalDateTime.now()); 2021-03-19T13:27:06.043 System.out.println(Instant.now()); 2021-03-19T09:27:06.044Z System.out.println(LocalDateTime.now().atZone(ZoneId.systemDefault())); 2021-03-19T13:27:06.057+04:00[Asia/Baku] System.out.println(LocalDateTime.now().atZone(ZoneId.systemDefault()).toInstant()); 2021-03-19T09:27:06.058Z System.out.println(Date.from(LocalDateTime.now().atZone(ZoneId.systemDefault()).toInstant())); Fri Mar 19 13:27:06 AZT 2021 System.out.println(new Date()); Fri Mar 19 13:27:06 AZT 2021 System.out.println(LocalDate.now()); 2021-03-19 System.out.println(LocalTime.now()); 13:27:06.066 System.out.println(ZonedDateTime.now()); 2021-03-19T13:27:06.066+04:00[Asia/Baku] System.out.println(ZoneId.systemDefault()); Asia/Baku System.o...

oracle pl/sql prosedurlarla ishleyerken bazada yaradilan custom array typelarla(base integer ve ya stringden ibaretdir) ishleyerken java terefde problem olur , HikaryDataSoruce da arraylar createArrayOf ile yaranir  , oracle ise ancaq createArray ile yaradilan array typelari qebul edir . bu problemi hell etmek uchun:     public OracleConnection getOracleConnection() {         Connection conn = oracleDb().getConnection();         return conn.unwrap(OracleConnection.class);     } Array prodCodes = getOracleConnection.createArray("BACK.T_STR_COLL", request.getProdCodes()); array i bazaya oturmemishden evvel OracleConnection u almaq lazimdir bunu da yuxarida olan kod ile almaq olur , daha sonra ui dan oturulen arrayi javada OracleConnectionun createArray metodu ile yaradib o formada bazaya oturmek lazimdir burada SimpleJdbcCall vasitesile oracle pl/sql proseduru chagirilir , nece chagirilmagi docda var: https://docs.spring.io/...