Hi Danilo, It could be that the older JTDS drivers don't really work that well anymore with newer Sybase versions.
I would try using a generic database connection with one of their newer drivers. You will have to figure out what the driver class is but normally this should be well documented. Another way would be to use a tool like DBeaver and see what drivers and setting they are using on a connection that works for you. Hope this helps, Hans On 8 Aug 2024 at 15:17 +0200, Danilo Gallo <[email protected]>, wrote: > 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!
