You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@hop.apache.org by "Mattang-Dan (via GitHub)" <gi...@apache.org> on 2023/10/19 20:14:22 UTC
[I] [Bug]: clear cache button on table inputs does not always or seldom works (hop)
Mattang-Dan opened a new issue, #3312:
URL: https://github.com/apache/hop/issues/3312
### Apache Hop version?
2.7
### Java version?
microsoft-jdk-11.0.19-windows-x64.msi
### Operating system
Windows
### What happened?
The clear cache button on table inputs seldom works for me. I am connected to a remote SQL Server database and running Hop on a VM to Windows Server. I usually have to close Hop, and even VS Code (which launches Hop) for it to work.
launch script from VS Code.
```
#!/usr/bin/env pwsh
#Requires -Version 7
#Set Windows System Environment variables
$env:HOP_CONFIG = 'C:\dev\hop\HopBaseConfig\hop-config.json'
$env:HOP_CONFIG_FOLDER = 'C:\dev\hop\HopBaseConfig'
#Launch Hop 2.7
start-process -FilePath "C:\programs\hop\hop_2.7\hop-gui.bat" -WorkingDirectory "C:\programs\hop\hop_2.7"
```
### Issue Priority
Priority: 3
### Issue Component
Component: Hop Gui
--
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]: clear cache button on table inputs does not always or seldom works (hop)
Posted by "Mattang-Dan (via GitHub)" <gi...@apache.org>.
Mattang-Dan commented on issue #3312:
URL: https://github.com/apache/hop/issues/3312#issuecomment-1775000005
The only place I can think of adding it is here. Look right? this will affect every SQL server statement.
--
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]: clear cache button on table inputs does not always or seldom works (hop)
Posted by "bamaer (via GitHub)" <gi...@apache.org>.
bamaer commented on issue #3312:
URL: https://github.com/apache/hop/issues/3312#issuecomment-1773781214
can you try setting this `SET use_cached_result = false` in the SQL statements in your advanced connection options to make sure this isn't related to JDBC driver caching (and not the Apache Hop cache)?
https://learn.microsoft.com/en-us/azure/databricks/sql/admin/query-caching
--
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]: clear cache button on table inputs does not always or seldom works (hop)
Posted by "hansva (via GitHub)" <gi...@apache.org>.
hansva commented on issue #3312:
URL: https://github.com/apache/hop/issues/3312#issuecomment-5778575612
.take-issue
--
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]: clear cache button on table inputs does not always or seldom works (hop)
Posted by "hansva (via GitHub)" <gi...@apache.org>.
hansva closed issue #3312: [Bug]: clear cache button on table inputs does not always or seldom works
URL: https://github.com/apache/hop/issues/3312
--
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]: clear cache button on table inputs does not always or seldom works (hop)
Posted by "bamaer (via GitHub)" <gi...@apache.org>.
bamaer commented on issue #3312:
URL: https://github.com/apache/hop/issues/3312#issuecomment-1775697042
nope, just in the Advanced tab, where it says "The SQL statements to run after connecting".
will be executed once every time a connection is created. that is not the same as every SQL server statement.
--
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]: clear cache button on table inputs does not always or seldom works (hop)
Posted by "Mattang-Dan (via GitHub)" <gi...@apache.org>.
Mattang-Dan commented on issue #3312:
URL: https://github.com/apache/hop/issues/3312#issuecomment-1775765094
I clicked the Test button in appropriate... but received an error:
--
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