[GitHub] [hop] DAJGIT opened a new issue, #2465: [Bug]: MySql DATETIME fields detected as Type None and all NULLS -ERROR: org.apache.hop.core.exception.HopValueException

[via GitHub]

DAJGIT opened a new issue, #2465:
URL: https://github.com/apache/hop/issues/2465

   ### Apache Hop version?
   
   2.2.0 / 2.4.0
   
   ### Java version?
   
   jre11.0.15 (Azul)
   
   ### Operating system
   
   Windows
   
   ### What happened?
   
   MySql DATETIME fields detected as Type None and all NULLS -ERROR: 
org.apache.hop.core.exception.HopValueException
   
   We have a Table with DATETIME fields in MySql Server running on Red Hat 
Linux: mysql  Ver 14.14 Distrib 5.7.24
   We have a Workflow running a Table Input Action 
   If you run HOP from Linux the DATETIME fields are detected as TIMESTAMP and 
are retrieved OK
   If you run HOP from Windows the DATETIME fields are detected as Type: None 
and retrieved as NULLS 
   In both cases we are using JAVA: jre11.0.15 (Azul) and LIB: 
mysql-connector-java-5.1.38-bin.jar
   
   
![image](https://user-images.githubusercontent.com/25872532/220988066-c2a10fbf-a15c-4563-b4f5-9242fc6bbf9b.png)
   
   If you run HOP from Linux the DATETIME fields are detected as TIMESTAMP and 
are retrieved OK
   
![image](https://user-images.githubusercontent.com/25872532/220988242-f149d71a-7542-4d0a-b432-2615c118874a.png)
   
   If you run HOP from Windows the DATETIME fields are detected as Type: None 
and retrieved as NULLS 
   
![image](https://user-images.githubusercontent.com/25872532/220988290-fb715d22-5da2-4c0f-942f-a45738a0d601.png)
   
   **ERROR: org.apache.hop.core.exception.HopValueException**
   
![image](https://user-images.githubusercontent.com/25872532/220989175-72b5c4db-0d45-439c-9596-a7b787d134f5.png)
   
   
   
   ### Issue Priority
   
   Priority: 3
   
   ### Issue Component
   
   Component: Actions


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: issues-unsubscr...@hop.apache.org.apache.org

For queries about this service, please contact Infrastructure at:
us...@infra.apache.org