Hi folks!

I have a connection with JDBC Sybase created and this works fine:
"""-------------------
Connection to ODBC_Dominio was successful.
Hostname: srv-dominio01.gestoracontabilidade.local
Port: 2638
Database name: Contabil
Url:
jdbc:jtds:sybase://srv-dominio01.gestoracontabilidade.local:2638/Contabil
"""-------------------

But in a Table Input step, when I use the "Get SQL select statement..."
button to retrieve schemas and tables it present this error:
"""-------------------
InvocationTargetException: Problem encountered getting information from the
database: org.apache.hop.core.exception.HopDatabaseException:
Unable to retrieve database information because of an error
Error getting views from schema [null]
Invalid state, the Connection object is closed.
Root cause: SQLException: Invalid state, the Connection object is closed.
"""-------------------

When I use a simple "select * from <table>" and "Preview" it present this
error:
"""-------------------
2024/08/08 10:08:14 - Hop - Projects enabled
2024/08/08 10:08:15 - Hop - Enabling project : 'default'
2024/08/08 10:11:32 - Preview pipeline for Table input 2 - Executing this
pipeline using the Local Pipeline Engine with run configuration 'local'
2024/08/08 10:11:32 - Preview pipeline for Table input 2 - Execution
started for pipeline [Preview pipeline for Table input 2]
2024/08/08 10:11:33 - Table input 2.0 - ERROR: Unexpected error
2024/08/08 10:11:33 - Table input 2.0 - ERROR:
org.apache.hop.core.exception.HopDatabaseException:
2024/08/08 10:11:33 - Table input 2.0 - Couldn't get row from result set
2024/08/08 10:11:33 - Table input 2.0 - I/O Error: Stream 2 attempting to
read when no request has been sent
"""-------------------



Anybody have some problem like that?
How can I solve this?

Thank's!

Reply via email to