You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@hop.apache.org by "DAJGIT (via GitHub)" <gi...@apache.org> on 2023/02/23 18:07:21 UTC

[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

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-unsubscribe@hop.apache.org.apache.org

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

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

Posted by "DAJGIT (via GitHub)" <gi...@apache.org>.
DAJGIT commented on issue #2465:
URL: https://github.com/apache/hop/issues/2465#issuecomment-1442274944

   After turning on "Support the Timestamp data type" you must restart HOP and the problem is solved


-- 
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-unsubscribe@hop.apache.org

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

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

Posted by "DAJGIT (via GitHub)" <gi...@apache.org>.
DAJGIT commented on issue #2465:
URL: https://github.com/apache/hop/issues/2465#issuecomment-1442228009

   As Hans sugessted me - (Thanks for the tip)
   I have turned on "Support the Timestamp data type" but still comes as None/Null


-- 
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-unsubscribe@hop.apache.org

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

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

Posted by "DAJGIT (via GitHub)" <gi...@apache.org>.
DAJGIT commented on issue #2465:
URL: https://github.com/apache/hop/issues/2465#issuecomment-1442292839

   ![image](https://user-images.githubusercontent.com/25872532/221005914-6ad59854-a42b-4287-8cd8-3277a87a1a6a.png)
   


-- 
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-unsubscribe@hop.apache.org

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

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

Posted by "DAJGIT (via GitHub)" <gi...@apache.org>.
DAJGIT closed issue #2465: [Bug]: MySql DATETIME fields detected as Type None and all NULLS -ERROR: org.apache.hop.core.exception.HopValueException
URL: https://github.com/apache/hop/issues/2465


-- 
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-unsubscribe@hop.apache.org

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