You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@hop.apache.org by "pauloricardoferreira (via GitHub)" <gi...@apache.org> on 2024/01/13 16:48:02 UTC

[I] [Bug]: Step Table Input does not bring data in the date column (hop)

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

   ### Apache Hop version?
   
   2.3 and 2.6
   
   ### Java version?
   
   11
   
   ### Operating system
   
   Windows
   
   ### What happened?
   
   Hello.
   
   Sorry for my English, I'm using Google Translate.
   
   I want to report a BUG where Step Table Input is not bringing data from a date column.
   
   I tested the following scenarios:
   
   One connection using what is called a db_link and another direct connection.
   
   By connecting to db_link, the data is read seamlessly.
   
   With direct connection, the step does not bring the column data.
   
   It was tested on versions 2.3 and 2.6
   
   
   Conection with db_link
   ![image](https://github.com/apache/hop/assets/70301866/4ccf902e-6abe-4556-9c0a-b40d92c8b141)
   
   Direct Conection
   ![image](https://github.com/apache/hop/assets/70301866/73da8f3e-3e0d-4a2e-aa52-9da370113fe9)
   
   Tks
   
   
   ### Issue Priority
   
   Priority: 2
   
   ### 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


Re: [I] [Bug]: Step Table Input does not bring data in the date column (hop)

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

   Normally we turn that on by default on more recent versions of Hop (if you make a new connection).
   Good idea to maybe add an other hint in the documentation as this issue does come up from time to time.


-- 
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


Re: [I] [Bug]: Step Table Input does not bring data in the date column (hop)

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

   Not enabled
   
   ![image](https://github.com/apache/hop/assets/70301866/79de2987-5355-4133-9ef5-4c7bca07fce1)
   
   Is it necessary to leave it enabled?


-- 
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


Re: [I] [Bug]: Step Table Input does not bring data in the date column (hop)

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

   I am using Oracle Data Base


-- 
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


Re: [I] [Bug]: Step Table Input does not bring data in the date column (hop)

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

   
   Driver Mysql
   
   before configuration
   ![image](https://github.com/apache/hop/assets/70301866/d43eeaa9-1291-4244-9fac-dbca4c0f4731)
   
   after configuration
   ![image](https://github.com/apache/hop/assets/70301866/c1364e76-fd38-4800-9ab6-eb86abdd9738)
   
   
   Driver Postgres
   before configuration
   ![image](https://github.com/apache/hop/assets/70301866/9f585cd1-1aa4-40ef-9e7c-ca83b5376073)
   
   
   after configuration
   ![image](https://github.com/apache/hop/assets/70301866/dc226801-6487-4c50-8a63-95ca20cc62f2)
   
   
   Sorry for the English... I'm using Google Translate,
   
   I use the Oracle Driver, which is properly configured and therefore validated tests.
   
   Thank you for your attention.
   
   I think it would be interesting to inform the user interface when creating the connection that if Data problems occur, follow the suggested configuration.
   
   You can close the Ticket.


-- 
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


Re: [I] [Bug]: Step Table Input does not bring data in the date column (hop)

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

   If the database supports it (I don't know which database type you are using) enable "supports the boolean data type" and "supports the timestamp data type" 


-- 
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


Re: [I] [Bug]: Step Table Input does not bring data in the date column (hop)

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

   OK.
   
   I will carry out the tests and publish the results in this issue.
   
   Thanks


-- 
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


Re: [I] [Bug]: Step Table Input does not bring data in the date column (hop)

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

   Then I would turn on those options.
   you might also want to add the following to the options tab oracle.jdbc.mapDateToTimestamp=false
   
   https://hop.apache.org/manual/latest/database/databases/oracle.html


-- 
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


Re: [I] [Bug]: Step Table Input does not bring data in the date column (hop)

Posted by "hansva (via GitHub)" <gi...@apache.org>.
hansva closed issue #3544: [Bug]: Step Table Input does not bring data in the date column
URL: https://github.com/apache/hop/issues/3544


-- 
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


Re: [I] [Bug]: Step Table Input does not bring data in the date column (hop)

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

   What is the database type?
   Is the support timestamp option enabled in the advanced tab of the database connection?


-- 
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