Not sure this is the right forum for this, but here goes.
First of all, I've been a software developer for over 42 years, but have been working in TCL, MatLab, & Vhayu for less than 2 months.
Our database server runs TCL with Matlab on our desktops. we use the JavaMethod "execute Query" to run database queries and return the results back to the desktops.
The problem is that the entire result is always returned by the executeQuery method. When the query results are huge, this becomes a memory problem on the database server.
I'm looking for the proper Java interface that will allow me to send the query to the database server, have the server retrieve the data in pieces, transmit the pieces one at a time to the desktop, then have the desktop run a loop to recieve each piece until it detects the end of the datastream.
OK, the question. Is there any TCL / JAVA interface that will allow the connection to become persistant until it is closed by the database server?
What are the methods that I should research for this?
First of all, I've been a software developer for over 42 years, but have been working in TCL, MatLab, & Vhayu for less than 2 months.
Our database server runs TCL with Matlab on our desktops. we use the JavaMethod "execute Query" to run database queries and return the results back to the desktops.
The problem is that the entire result is always returned by the executeQuery method. When the query results are huge, this becomes a memory problem on the database server.
I'm looking for the proper Java interface that will allow me to send the query to the database server, have the server retrieve the data in pieces, transmit the pieces one at a time to the desktop, then have the desktop run a loop to recieve each piece until it detects the end of the datastream.
OK, the question. Is there any TCL / JAVA interface that will allow the connection to become persistant until it is closed by the database server?
What are the methods that I should research for this?