All Forums Teradata Studio
alistairknight 2 posts Joined 01/15
10 Nov 2015
Alternative to Teradata Studio

Teradata is without a shadow of a doubt, the worst database client software available, it is slow, clunky, crashes frequently, and if a connection to a database drops, it ends up in an endless loop of "connection lost" errors that can only be termiated by force-quitting the entire program, loosing valuable work.
Are there any other client (or third party tools) available to end the pain of using Studio?

fgrimmer 553 posts Joined 04/09
11 Nov 2015

Alistair, What version of Teradata Studio are you using? What database(s) are you connecting to? What types of things are you doing when the connection is lost or it crashes?

alistairknight 2 posts Joined 01/15
12 Nov 2015

Hi
It's the latest version (15.10.01.00), our DBA has implemented rules that close connections after 15 minutes of inactivity, which given testing is easy to reach, so I'll do some DB updates in Studio, then switch to the web app to test the results.
If I'm in studio doing a simple lookup using SQL Editor, I'll get an error message, which I can close, then re-connect and if I've saved my SQL, simply continue.
If however, I'm editing data, I'll first get a (massive) Java error, then a small modal appears with "Unable to access data: [Error Code: 1095, SQL State: HY000] Cannot call a method on a closed connection" - not unreasonable in itself, however, clicking OK to close the error simply reproduces the popup, which ends up in an eternal loop, the only way to close is to force quit the whole program.
When I re-open Studio, I'll also get a load of tab's opening automatically containing the message "No editor descriptor for id org.eclipse.ui.internal.emptyEditorTab".
I appreciate that our DBA's rules are there for a purpose, but an IDE that fails gracefully would be appreciated!
Thanks
Alistair

fgrimmer 553 posts Joined 04/09
12 Nov 2015

Alistair, We are making improvements to our connection management framework. Auto-reconnect is something we are working on next. We hope to have this completed in our next release. 

You must sign in to leave a comment.