Thank you very much for your answer Bart, the library I am using is the one suggested on the official Firebird website. (jaybird-6.0.1.jar) and the environment variable HOP_JAVA_HOME tip for SDK 23 as shown below in the output of the command "Get-ChildItem Env:" --- HOP_AUDIT_FOLDER C:\Utilitarios\apache-hop-client-2.12.0\hop\audit HOP_CONFIG_FOLDER C:\Utilitarios\apache-hop-client-2.12.0\hop\config HOP_JAVA_HOME C:\Program Files\Java\jdk-23 HOP_PLUGUINS_BASE_FOLDERS C:\Utilitarios\apache-hop-client-2.12.0\hop\plugins HOP_SHARED_JDBC_FOLDERS C:\Utilitarios\apache-hop-client-2.12.0\hop\lib\jdbc JAVA_HOME C:\Program Files\Java\jdk-23 --
I'll have to improvise with "select values" thanks Em qui., 15 de mai. de 2025 às 10:14, Bart Maertens <[email protected]> escreveu: > This sounds like a "feature" of your JDBC driver. I don't have any > experience with Firebird, you'll have to check their JDBC driver > documentation, but there is or used to be a similar issue with DB2. > > Regards, > Bart > > > On Thu, May 15, 2025 at 3:11 PM Irio Andre Moesch <[email protected]> > wrote: > >> Hello everyone, >> >> I'm new here, I searched here about my problem and couldn't solve it and >> would like the help of the "masters". My problem is: I'm using Apache HOP >> version 2.12 and when connecting to the Firebird database version 3.0.12 >> the output of the "table input" transformation where the queries that use >> the "coalesce()" or "cast()" functions the column names do not return the >> name that was defined in the "alias" but rather the name of the function >> that was used "CAST, CAST_1, CAST_2...". How can I solve this problem? >> >> Thank you very much >> Irio >> >
