We have a Job server installed on our windows on the 😧 but it seems to be using C:\Users\<user>\AppData\Local\Temp\ for some kind of temp storage(specifically large result sets from database queries in our case). This is not desirable as we configure our servers specifically so the C: is only really for the OS.
How can we change that location so it uses a temp folder on 😧 instead?
Found the issue, this is not a talend issue, it's a problem with the jtds driver. By default it tries to cache the entire result set from queries and for large result sets it uses the temp drive storage.
Setting useCursors=true in the connection string prevents this.
Found the issue, this is not a talend issue, it's a problem with the jtds driver. By default it tries to cache the entire result set from queries and for large result sets it uses the temp drive storage.
Setting useCursors=true in the connection string prevents this.
