SQL Assistant Java Edition is an information discovery tool that retrieves data from Teradata Database systems and allows the data to be manipulated and stored on the desktop. It is built on top of the Eclipse Rich Client Platform (RCP). This allows the product to take advantage of the RCP framework for building and deploying native GUI applications to a variety of desktop operating systems. SQL Assistant Java Edition can be run on Windows, Linux, and Mac OSX operating systemts. The Eclipse platform is designed as an open tools platform but architected so that its components (or a subset of its components) can be used to build RCP applications. This allows SQL Assistant Java Edition to benefit from the many high quality Eclipse features available while focusing on value-add for Teradata.

SQL Assistant Java Edition includes the following key features:

  • Modular display that allows you to move panels around, creating a custom look and feel.
  • Data Source Explorer to view database objects, such as schemas , tables, macros, stored procedures, user-defined functions, user-defined types, views, and triggers. (NOTE: SQL Assistant Java Edition uses the term schema to refer to a database.)
  • Data Source Explorer menu options to run Stored Procedures, Macros, and User-defined Functions.
  • Connection Profile Wizard to create connection profiles using the Teradata JDBC Driver.
  • SQL Editor to create, modify, and execute individual or multiple SQL Statements, including parsing the SQL statement for syntax errors and formatting the SQL according to selected formatting options.
  • Support for Parameterized Queries including Named Parameters
  • SQL Editor Templates (INSERT, SELECT, DELETE, UPDATE, and more)
  • Result Set Viewer that displays result set data, allowing the user to select rows and cells, copy and format data, sort, hide, and move columns, and search for result set data values.
  • SQL History view that stores historical data for executed SQL statements with time values and status information.
  • Ability to export result set data as plain text, XML, HTML, CSV, as well as Excel format.
  • SQL Query Builder to visually build and edit SQL queries.
  • Data wizard to extract data from the Teradata Database to a file on the desktop.
  • Data wizard to load data from the desktop file system to the Teradata Database.

Modular Display

The SQL Assistant Java Edition display includes the SQL Assistant Toolbar along with five view panels: the Data Source Explorer View, the Project Explorer View, the SQL Editor (SQL Scratchpad), the Teradata SQL History View, and the Teradata View/ Result Set Viewer.

SQL Assistant Java Edition contains a toolbar that provides buttons to allow quick access to functions that are used while creating and modifying SQL files.

A view can also contain its own toolbar and drop down menu. These toolbar buttons and menu items provide actions on the data managed by the view. Included in the view toolbar are buttons to minimize, maximize, and restore the view. Maximizing the view will cause the view to take over the entire SQL Assistant Java Edition window display. Click the Restore button to return the view back to its previous display.

You can customize the look and feel of SQL Assistant Java Edition by moving view panels within the main display window. A view can be moved by selecting the view and dragging it to a new location. As you move the view over the display, the mouse pointer will change depending on where you want to drop or dock the view. You can also drag the view outside the display area. The view will then become a "detached" view. You can also remove a view panel by clicking the "X" on the view tab. A view can be re-displayed by selecting the view from the Window>Show View option in the main menu. Or to return the views to their original display, click Window>Reset Perspective...

Data Source Explorer View

The Data Source Explorer View panel contains the database object tree display. It is here that you can create connection profiles to your Teradata Database systems and interact with the database objects.

Data Source Explorer

Creating Connections

You can create connections to your database using the Connection Profile Wizard. The wizard is invoked from the Data Source Explorer by right clicking on the Database Connections folder.

 

SQLA JE provides an option to create connection profiles for additional database servers other than Teradata.  You must provide the specific database server JDBC drivers for databases other than Teradata.

Select Teradata Database from the Connection Profile Types, enter a Name and click Next.


The Connection Profile Wizard is based on a driver template that references an embedded Teradata JDBC driver. Enter the database server name, user name, password, and default database name into the wizard dialog screen. The Authentication Mechanism allows you to choose an advanced logon mechanism, such as LDAP or Kerberos, or select the default mechanism, PASSWORD_PROTECTED. If you wish to save your password to disk, check the Save Password box. Otherwise, the password is stored in the profile and only active throught the Eclipse session. When Eclipse is closed, the unsaved password is removed before the profile is written to disk. You will be prompted for the password the next time you connect to that profile.

Optionally, You can choose a different Teradata JDBC driver than the embedded Teradata JDBC driver, as well as add and remove properties for the database connection.

You can also cache schema metadata, saving time when loading the database objects in the Data Source Explorer. Click the Cache Properties button to select schemas (or databases) to cache.

Creating a SQL Statement (SQL Scratchpad)

When SQL Assistant Java Edition is launched, a SQL Scratchpad area is provided for you to enter your SQL statements. Once you have a connection to your Teradata database, you can begin to enter SQL statements in the SQL Scratchpad window.  Click the Save button to save the SQL Scratchpad to a file.

Another option to create a SQL file is through the Data Source Explorer. Within the Data Source Explorer, select your database connection and click the SQL Scrapbook action from the Data Source Exporer toolbar. This will create a SQL file in the SQL Editor with the name 'SQL Scrapbook [n]' and the connection profile set to your database connection. You are now ready to enter your SQL statement.  Refer to the section below entitled 'SQL Editor' for information on executing your SQL statement. Click the Save icon to save your SQL file within your SQL Project.

 

Edit, Extract and Load Data, Row Count

The Data Source Explorer also provides an option to edit, extract and load data, and display the row count for a given table. Right click on the table and select the option from the drop down context menu.

The Edit option will present the current rows of data from the table in a table grid display within the SQL Editor. You can click on a cell in the table grid to modify the cell contents or add a new row by clicking on the <new row> entry. Depending on the edit option, a SQL UPDATE, INSERT, or DELETE statement is created and run. The results are displayed in the SQL Results View.

The Load and Teradata FastLoad options will present a dialog to choose the file to load and define the necessary file format needed to identify columns when loading data into the table. File format options include the column delimiter (comma, semicolon, space, tab, or vertical bar “|”) along with the character string delimiter (double quote, single quote, or none).

The simple Load option will create an INSERT statement for each row of data in the file. The Teradata FastLoad option will create a separate JDBC connection using the JDBC FastLoad option (TYPE=FASTLOAD). The rows of data are read into a buffer and loaded in batch increments. It should be noted that not all of the column data types are supported with the Teradata FastLoad option.

The Extract and FastExport data options will present a similar dialog for you to enter information about the file created from the extracted data, such as the output file and output file format (column delimiter and character string delimiter options). The Teradata FastExport option will create a separate JDBC connection using the JDBC FastExport option (TYPE=FASTEXPORT).

The Sample Contents option will perform a “SELECT * FROM” SQL operation on the table and display the results in the SQL Results view.

The Row Count pops up a dialog displaying the number of rows for a given table.

Project Explorer View

The Project Explorer View panel provides a hierarchical view of the Projects and their resource files. It is here that you can select SQL files for editing or create new SQL files. SQL files can also be imported from or linked to your file system. When Teradata SQL Assistant is first installed, an initial project called 'SQL' is created for you. You can create additional projects using the New>Project... menu option.

Within the Project Explorer, you can also choose an option to compare two files. The Compare Option displays the two files side by side with buttons that allow you to jump from one difference to another or move changes from one file to another. This is very handy when comparing SQL files or result set data.

The Project Explorer also provides an option to execute one or more SQL files from list of files.

SQL Editor

The SQL Editor view is displayed when a SQL file is opened. Double clicking on a file in the Project Explorer will cause the file to be opened in the SQL Editor.

The SQL Editor provides a scratch pad for you to enter your SQL statements. As you type, SQL content assist will pop up annotations showing a list of expected keywords. If a database (or schema) name is entered followed by a dot, the content assist will display the list of tables from your schema for you to select from. (Note: You must be connected to a Teradata Database in order for SQL content assist to work.)

Content assist will also provide a list of SQL Templates. At the start of the SQL statement, hit the Cntrl+SPACE keys and a pop up list of templates is displayed. Scroll down until you find the template you want and double click on it to insert the template into your SQL Editor file. Anchor statements are provided that you can navigate by tabbing. You can also edit or add your own SQL Templates via the SQL Editor Preferences page.

Parameterized queries can also be created in the SQL Editor. The query contains parameters indicated by question marks. When the query is executed, the user is prompted for the parameter value(s). Named parameters allows the user to specify a name for the parameter.

The SQL Editor also provides syntax coloring for your SQL statements. You can change the colors of comments, keywords, identifiers, types, or other syntax items via the SQL Editor Preferences page.

When right clicking in the SQL Editor window, a SQL Editor Context menu appears with options to execute the SQL statement(s) in your SQL file.

 The following options are presented:

  • Execute all of the SQL statements
  • Execute the selected SQL statement
  • Execute the SQL statements as individual statements (with a commit occurring between statements)
  • Execute the selected statement as one statement
  • Execute the current statement where the cursor is located
  • Visual Query Builder

SQL Assistant Java Edition provides a graphical interface for creating SQL statements, referred to as the SQL Query Builder. You can edit an existing statement using the SQL Query Builder by selecting the statement within the SQL Editor and choosing the ‘Edit in SQL Query Builder…’ menu option. (Refer to figure above).

You can add additional tables and table joins by right clicking in the SQL diagram area and select Add Table… or Create Join…. When adding a table, a list of tables and views is presented for you to choose from. Additionally, from the SQL text window, you can choose an option to run the SQL statement. A SQL Results tab is provided for you to see the result set data.

A shortcut key, in the toolbar or Tools drop down menu, will perform an EXPLAIN on a given SQL statement.

Result Set Viewer

The Result Set Viewer displays the result set or parameter data from executing SQL statements and running database routines, such as stored procedures, macros, user-defined functions, and triggers. The Result Set Viewer provides an enhanced display of the Result Set data. It displays the result sets as tabs within the Teradata View, allowing the user to select rows or cells from the Result Set data table grid. The Result Set Viewer provides menu options to hide or show all columns, move and sort columns, find a value within the result set data, perform aggregate functions on selected numeric columns, filter column data, format cells, and copy cells. Select a row or cell and right click to display the menu options.

Mutliple result sets can be displayed as tabs or in a side by side sash display.

LOBs can also be displayed in the Result Set Viewer. When a query result is being processed that contains an LOB result column, a dialog appears for ther user to specify where and how to store the LOB values on the file system.

If specified, LOB values are displayed in the Result Set Viewer.

A toolbar is also provided with options to show the SQL associated with the result set, switch the display between text and grid display, switch the display between tabs and side-by-side sash display, and save, export, and print result set data. SQL result data can also be saved to a file within your Project or exported to an external file in the file system.

If the Export or Export All option is chosen, the Export Result dialog is displayed. Select a file name, format, and export options. Then click the finish button to create the exported file. The Save option presents a similar dialog.

The following screen capture shows the result data with totals on integer columns as exported to an Excel file.

SQL History View

The SQL History View provides an enhanced display of the SQL History information. As SQL statements are executed from the SQL Editor or functions are run from the Data Source Explorer, an entry is placed in the SQL History. The SQL History view displays the data in a grid format, allowing the user to select rows and cells. The SQL History provides extensive information about the SQL execution, such as execution elapsed time, DBMS time, and fetch time, database server, row count, parameter display for macros and stored procedures, SQL statement, and SQL statement type. It provides options to copy cells or rows, edit the ‘Note’ or SQL for a SQL History entry, search for result history data, and re-execute SQL statements. Choosing the 'Edit SQL' option will open a SQL Scrapbook file in the SQL Editor with the selected SQL statement. This allows users to further fine tune their SQL statements.

The SQL History view also provides a toolbar menu with options to delete rows or all of the history entries, filter columns, format cells, and sort columns, The SQL History uses an embedded Derby Database to manage the SQL History entries.

Teradata View

The Teradata View contains more detailed information about the database objects. When an object is selected in the Data Source Explorer, it is automatically displayed in the Teradata View. You can click on the tabs to display additional information on the database object.

Help

Help is provided by clicking on the Help>Help Contents in the main toolbar.

Conclusion

While SQL Assistant Java Edition is not necessarily intended to replace the current Teradata SQL Assistant product it does allows us to offer an alternative for customers whose client platform includes systems other than Windows. Supporting multiple platforms (Windows 32/64, Linux 32/64 and Mac OS X) in this way allows customers to be flexible when choosing a client operating system to connect to their Teradata Database system.

To get up and running with Teradata SQL Assistant Java Edition use the Download links above or go to the Tools Download area, pick your OS and take a look at the README.

Discussion
MikeC 17 comments Joined 03/09
02 Oct 2009

First off a Disclaimer: I am responsible for the Tools content on Teradata Developer Exchange so all of the articles in the Tools section are close to my heart. I'm also a Java developer and have been working with Eclipse based tools since before it was even called Eclipse (anyone remember WSAD) so I'm pretty comfortable with the UI.

That said, SQL Assistant Java Edition was created as an off shoot of the Teradata Plug-in for Eclipse activity, which is focused on helping developers to create applications (obviously including SQL) for use on Teradata. This use of Eclipse dictates some of the UI aspects of the product and I would contend that there is sufficient weight behind Eclipse.org that their UI decisions are good enough.

With SQL Assistant Java Edition (marketing chosen name) we were asked to provide a "Single Click Install" version of the SQL oriented part of the Teradata Plug-in for Eclipse in order to support a wider range of Operating Systems and Users than the existing SQL Assistant (windows) product. We are not trying to replace SQL Assistant, rather we wish to introduce a whole new set of users to Teradata.

The developers of the Teradata Plug-in for Eclipse and SQL Assistant Java Edition are prolific contributors to the Tool section of Teradata Developer Exchange (for which I commend them) and I would point the audience to their many articles as a quick way to get up and running with Teradata Plug-in for Eclipse, SQL Assistant Java Edition and Teradata.

MikeC....

Q 6 comments Joined 10/09
21 Oct 2009

I think it deserves a new name, just because.

lucky 16 comments Joined 12/08
22 Oct 2009

I think hyperj's comment is really just pointing out that the default view of SQLA-JE doesn't actually have an area to enter SQL. I think it should be there as part of the default view, since after all, when starting this tool you probably want to enter SQL ;)

buffgecko 1 comment Joined 10/09
29 Oct 2009

I agree with hyperj, SQLA is the TD application I have used the most so far.

zby 7 comments Joined 11/09
03 Nov 2009

Autocomplete of column names doesn't work in SQL editor while using table aliases. It works only in Query builder.

fgrimmer 486 comments Joined 04/09
03 Nov 2009

Yes. The reason being is that the SQL Editor is using strictly a token based parser. It has a very narrow focus. The Query Builder is collecting more information at a wider scope, for example keeping track of the aliases, to help the user build SQL.

VMarcelo 1 comment Joined 11/09
05 Nov 2009

Hello fgrimmer,
I downloaded the SQL Assistant Java Edition and i think that it is incredible !!!!!!!.
I have a question ... How can I add Tasks ?

Antonio 1 comment Joined 11/09
05 Nov 2009

hello fgrimmer, thank for your answer,

Is any difference conect it for JDBC or ODBC? which is more efficient?

fgrimmer 486 comments Joined 04/09
05 Nov 2009

I am not the best person to answer that. There are many factors and opinions that could argue either way. This question is better handled on the DevX Connectivity forum.

xdege 2 comments Joined 11/09
05 Nov 2009

Hi fgrimmer, I have a question....How can I look the explain of the query (shortcut)?

fgrimmer 486 comments Joined 04/09
05 Nov 2009

You can perform a SQL "explain" on a query, such as:
explain select * from dbc.dbcinfo;

and the result is displayed in the SQL Results View for that query.

xdege 2 comments Joined 11/09
05 Nov 2009

It is correct but the question was whether there was any key combination such as F6 in Sql Assistant.

fgrimmer 486 comments Joined 04/09
05 Nov 2009

No, not at this time.

sunshare 1 comment Joined 08/08
19 Nov 2009

湘西 2007 »¤Ô«ÏØ
湘西 2001 ¼ªÊŒÊð
It's problem ,The result in Chinese.

fgrimmer 486 comments Joined 04/09
19 Nov 2009

Can you give more information on how the problem occurred?

antonw 6 comments Joined 10/09
24 Nov 2009

Hi there,
The Eclipse port really goes the right direction ... congratulations!

Questions:
1) How do i specify the mechanism? We use ldap. Is there a substitute for the usergssconfig-file?
2) can the client be installed really standalone without any other packages?

Thanks in advance!
BR
Anton

antonw 6 comments Joined 10/09
24 Nov 2009

Hi, a question about the migration scenario from the old assistant:
How can we convert the locally stored SQL statement history? Where/how is the new history stored?

The old one uses afaik a access mdb database ... the new edition a flat-file history? There should be a way to convert the history, because our users need it badly.

Thanks!

Chuckbert 35 comments Joined 07/09
24 Nov 2009

1) The ability to specify LDAP and Kerberos is coming soon.

2) The SQLA Java Edition contains the necessary pieces to connect to Teradata. It requires the Java VM.

The migration of the original SQLA's history is on the list of features under consideration.

SQLA Java Edition's history is stored as serialized Java objects in the workspace's metadata repository (in the directory .metadata\.plugins\org.eclipse.datatools.sqltools.result under the workspace). Since they are serialized objects, there isn't the opportunity to create a migration tool by editing them.

hvganipineni 2 comments Joined 09/09
08 Dec 2009

How much does it cost to buy the official SQL Assistant

fgrimmer 486 comments Joined 04/09
08 Dec 2009

SQL Assistant JE will be available from the Developer Exchange downloads at no cost.

antonw 6 comments Joined 10/09
21 Dec 2009

Hi,
Normally Eclipse creates the workspace in the user's home directory.
In the SQLA RCP, it is created under the installation directory (which is not possible in our installations due the lack of user rights).

This makes it also unusable in out Terminal Server scenario ... :-(

How can I force the workspace creation in the user-home folder?
Thanks!

Chuckbert 35 comments Joined 07/09
21 Dec 2009

The workspace is created in the working directory on Windows and Linux and the user's Documents directory on Mac.

The just-released version of SQLA-JE's installation process creates desktop and Start menu shortcuts that set the working directory to the user's home directory so that's where the workspace will be created.

If you're using the Windows alpha version, you can create a shortcut with the "Start in" directory set to the location you want the workspace.

bibhuti 2 comments Joined 12/09
24 Dec 2009

After Installation: Teradata SQL Assistant Java Edition for MAC OS X, I am unable to run the Application, its giving following error: "You can't open the application "Teradata SQL Assistant" because its not supported on this architecture". I am having Mac OS X version 10.5.8, Plz let me know the what needs to be done.

fgrimmer 486 comments Joined 04/09
24 Dec 2009

Can you verify that you have the correct Java Runtime, version 1.5 or greater.

zby 7 comments Joined 11/09
27 Jan 2010

FORMAT doesn't work - output is unformatted. FORMAT works in the original version ("Queryman").
e.g. SELECT TheTime(FLOAT,FORMAT'99:99:99') FROM SW_Event_Log

I tried to change connection parameter TMODE (ANSI,TERA,DEFAULT) - nothing helps.

fgrimmer 486 comments Joined 04/09
27 Jan 2010

The FORMAT command is performed by the Teradata Database when in field mode. This option is not supported by the JDBC Driver, at this time. As well, the format information isn't readily available to SQLA JE to get and process for displaying the result data. It is recommended that you use Excel to format your result set data.

zby 7 comments Joined 11/09
28 Jan 2010

Is it possible to create a connection without saving a password ?
Is the saved password hackerproof (where is it saved, which type of encryption is used, ...) ?

gseller 3 comments Joined 05/09
28 Jan 2010

Currently it is not possible to create a connection profile without saving the password. It is stored in a .plugin directory for connectivity. This file is managed by the underlying Eclipse technology and is encrypted with DESede (triple DES).

Is not saving the password and soliciting it an option that is desirable or required?

zby 7 comments Joined 11/09
29 Jan 2010

Soliciting (not saving) password is a required option (security policy).

zby 7 comments Joined 11/09
29 Jan 2010

The FORMAT keyword is not supported by the Teradata JDBC Driver. Original SQLA uses the Terdata ODBC Driver and supports FORMAT keyword. I think that SQLA-JE is a little bit of a "downgrade" in this case.

Will support of the FORMAT keyword be implemented in the future? Thanks.

gseller 3 comments Joined 05/09
29 Jan 2010

We'll make saving the password optional so that if it is not saved it will be solicited.

fgrimmer 486 comments Joined 04/09
29 Jan 2010

There are not plans to provide the functionality of the FORMAT keyword at this time. Again, we are referring this functionality and other formatting options to a tool, such as Excel.

Tuen 21 comments Joined 07/05
10 Feb 2010

I downloaded the SQLJE and installed it, when I click on it to run (in windows) it brings up the splash screen, then just goes away. Nothing starts up, the process just goes away with no errors and no indication that anything was wrong.

Chuckbert 35 comments Joined 07/09
10 Feb 2010

Tuen, which version of Windows are you running on? And which version of Java is installed?

When SQLA-JE runs, it creates a folder called "workspace" in the folder specified in the "Start in" field of the shortcut used to start the application. This is set to be your home directory (usually C:\Documents and Settings\your-user-name). In that folder it creates a folder called ".metadata". Inside that folder a file called ".log" receives log messages from the application.

Has a HOME_FOLDER\workspace\.metadata\.log file been created? If so, is there anything in it that indicates a problem?

We haven't seen the problem you have described. We'll need more information to try to figure this one out.

santomo 1 comment Joined 02/10
24 Feb 2010

Thanks for replying. The result set of a query displays the Decimal Datatypes correctly. But when I try to export the result I have the mentioned limit of 500 rows.

The Problem with the Decimals appears when I am trying to extract a complete table from the Table or View list. SQL Assistant ist extracting the content but when finished it tells me the follwoing (in the SQL resultset next to the list of queries:

Extracting [Table] ...
Data extraction was successful.
13561 row(s) extracted.
One or more values could not be retrieved in the following column(s): Col1, Col3

Col1 and Col3 are Decimal Datatypes. The List of the SQL statements I have a warning sign in front of the SQL.

When I am using a different table the same happen again, just the Decimal will be rejected.

The Error Log says the following:

Widget is disposed

org.eclipse.swt.SWTException: Widget is disposed
at org.eclipse.swt.SWT.error(SWT.java:3884)
at org.eclipse.swt.SWT.error(SWT.java:3799)
at org.eclipse.swt.SWT.error(SWT.java:3770)
at org.eclipse.swt.widgets.Widget.error(Widget.java:450)
at org.eclipse.swt.widgets.Widget.checkWidget(Widget.java:388)
at org.eclipse.swt.widgets.Text.getText(Text.java:963)
at org.eclipse.ui.dialogs.FilteredTree$3.getName(FilteredTree.java:630)
at org.eclipse.swt.accessibility.AccessibleObject.atkObject_get_name(AccessibleObject.java:395)
at org.eclipse.swt.internal.gtk.OS._gtk_widget_destroy(Native Method)
at org.eclipse.swt.internal.gtk.OS.gtk_widget_destroy(OS.java:11922)
at org.eclipse.swt.widgets.Widget.destroyWidget(Widget.java:412)
at org.eclipse.swt.widgets.Widget.release(Widget.java:1054)
at org.eclipse.swt.widgets.Control.release(Control.java:3293)
at org.eclipse.swt.widgets.Widget.dispose(Widget.java:446)
at org.eclipse.ui.internal.PartPane.dispose(PartPane.java:180)
at org.eclipse.ui.internal.ViewPane.dispose(ViewPane.java:193)
at org.eclipse.ui.internal.WorkbenchPartReference.dispose(WorkbenchPartReference.java:681)
at org.eclipse.ui.internal.WorkbenchPage.disposePart(WorkbenchPage.java:1715)
at org.eclipse.ui.internal.WorkbenchPage.partRemoved(WorkbenchPage.java:1707)
at org.eclipse.ui.internal.ViewFactory.releaseView(ViewFactory.java:256)
at org.eclipse.ui.internal.Perspective.hideView(Perspective.java:606)
at org.eclipse.ui.internal.WorkbenchPage.hideView(WorkbenchPage.java:2381)
at org.eclipse.ui.internal.ViewPane.doHide(ViewPane.java:213)
at org.eclipse.ui.internal.PartStack.close(PartStack.java:543)
at org.eclipse.ui.internal.PartStack.close(PartStack.java:526)
at org.eclipse.ui.internal.PartStack$1.close(PartStack.java:122)
at org.eclipse.ui.internal.presentations.util.TabbedStackPresentation$1.handleEvent(TabbedStackPresentation.java:83)
at org.eclipse.ui.internal.presentations.util.AbstractTabFolder.fireEvent(AbstractTabFolder.java:270)
at org.eclipse.ui.internal.presentations.util.AbstractTabFolder.fireEvent(AbstractTabFolder.java:279)
at org.eclipse.ui.internal.presentations.defaultpresentation.DefaultTabFolder.access$1(DefaultTabFolder.java:1)
at org.eclipse.ui.internal.presentations.defaultpresentation.DefaultTabFolder$1.closeButtonPressed(DefaultTabFolder.java:70)
at org.eclipse.ui.internal.presentations.PaneFolder.notifyCloseListeners(PaneFolder.java:626)
at org.eclipse.ui.internal.presentations.PaneFolder$3.close(PaneFolder.java:206)
at org.eclipse.swt.custom.CTabFolder.onMouse(CTabFolder.java:2199)
at org.eclipse.swt.custom.CTabFolder$1.handleEvent(CTabFolder.java:327)
at org.eclipse.swt.widgets.EventTable.sendEvent(EventTable.java:84)
at org.eclipse.swt.widgets.Widget.sendEvent(Widget.java:1176)
at org.eclipse.swt.widgets.Display.runDeferredEvents(Display.java:3493)
at org.eclipse.swt.widgets.Display.readAndDispatch(Display.java:3112)
at org.eclipse.ui.internal.Workbench.runEventLoop(Workbench.java:2405)
at org.eclipse.ui.internal.Workbench.runUI(Workbench.java:2369)
at org.eclipse.ui.internal.Workbench.access$4(Workbench.java:2221)
at org.eclipse.ui.internal.Workbench$5.run(Workbench.java:500)
at org.eclipse.core.databinding.observable.Realm.runWithDefault(Realm.java:332)
at org.eclipse.ui.internal.Workbench.createAndRunWorkbench(Workbench.java:493)
at org.eclipse.ui.PlatformUI.createAndRunWorkbench(PlatformUI.java:149)
at com.teradata.sqla.Application.start(Unknown Source)
at org.eclipse.equinox.internal.app.EclipseAppHandle.run(EclipseAppHandle.java:194)
at org.eclipse.core.runtime.internal.adaptor.EclipseAppLauncher.runApplication(EclipseAppLauncher.java:110)
at org.eclipse.core.runtime.internal.adaptor.EclipseAppLauncher.start(EclipseAppLauncher.java:79)
at org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.java:368)
at org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.java:179)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:616)
at org.eclipse.equinox.launcher.Main.invokeFramework(Main.java:559)
at org.eclipse.equinox.launcher.Main.basicRun(Main.java:514)
at org.eclipse.equinox.launcher.Main.run(Main.java:1311)
at org.eclipse.equinox.launcher.Main.main(Main.java:1287)

But I think this is not related to the error, since I will get this message as soon as I am opening the Error log.
There is not much else in the Errorlog (I deleted it), at least nothing which obviously is related to the warning.

When I am opening the exported file I can find all exported values except the Dezimal. They appear to be NULL (I used the | (pipe) sign as a field sperator) at least th row look like this:

|abcdedv||343|2009-02-10|...

Col1 and Col3 supposed to hold the decimal values.

Thanks

fgrimmer 486 comments Joined 04/09
24 Feb 2010

Thank you for the trace. This, too, is an Eclipse DTP problem that we are tracking. We hope to have a SQLA JE version with a fix soon.

zby 7 comments Joined 11/09
02 Mar 2010

Do you plan to implement autocomplete of column names in SQL editor while using table aliases ?

Chuckbert 35 comments Joined 07/09
02 Mar 2010

zby,

Table aliases are not used in autocomplete and aren't planned to be used.

The SQL Editor's autocomplete is based on the tokens that appear from the start of the statement to the insertion point. The table alias often (usually?) appears after the insertion point where the parser being used doesn't have the ability to see so the alias is unknown.

zby 7 comments Joined 11/09
02 Mar 2010

It is a pity because autocomplete is very useful. I hope that maybe in the future it will change ...

mtlrsk 4 comments Joined 06/08
06 Jun 2010

hi,
Is it worth using Fastload/FastExport using JDBC/ODBC connections? It will be too slow compared to traditional Load/Unload utilities and or TPT operators.? I tried load/export using TD SQLA ODBC connections, and it goes very much slow just for 1000 rows.

What will be the performance impact if this two features of this tool is compared with our traditional TTU?

fgrimmer 486 comments Joined 04/09
07 Jun 2010

JDBC FastLoad/FastExport has significant overhead for opening connections to Teradata Database so is not recommended for inserting only a few rows. The documentation suggests using FastLoad for inserting at least 100,000 rows.

robca2 1 comment Joined 06/10
09 Jun 2010

For people using OS X, if you do not see a menu option for "Edit in SQL Builder..." then you can CTRL-Click on your SQL code in the scrapbook and find that option in the contextual menu.

toddtrues 1 comment Joined 06/10
10 Jun 2010

installed sql assistant 64 bit.. pretty straightforward. when I double click on the icon to start.. nothing happens. anyone have any suggestions? do I need to have other software installed FIRST? I am running windows 7 pro.

fgrimmer 486 comments Joined 04/09
10 Jun 2010

One thing to check is to make sure you have JRE 1.5 or greater installed on your system and it is available in your path. Is the splash screen displayed at all when you try to run? Also check for an error log in the configuration directory. This should be located on Windows 7 in the Users\\.eclipse\com.teradata.sqla.TeradataSQLA_13.1.0.201005121457_xxxxxxxx\configuration.

tomsal 1 comment Joined 06/10
18 Jun 2010

I have found the possiblily to change result set viewer, but only Default viewer is available. How it is possible to integrate another viewer?

forpartha 2 comments Joined 06/10
18 Jun 2010

Hello, I am facing this curious thing in SQL Assistant Java. A PPI created in a table is showing up as a NUSI in the Teradata view. Has anyone else encountered this or am I missing something obvious here?

Here are the details:

show table order_table;

CREATE MULTISET TABLE TDUSER.order_table ,NO FALLBACK ,
NO BEFORE JOURNAL,
NO AFTER JOURNAL,
CHECKSUM = DEFAULT
(
Order_Number INTEGER NOT NULL,
Customer_Number INTEGER NOT NULL,
order_date DATE FORMAT 'YY/MM/DD',
order_total DECIMAL(10,2))
PRIMARY INDEX ( Order_Number )
PARTITION BY RANGE_N(Order_date BETWEEN DATE '2009-04-01' AND DATE '2010-03-31' EACH INTERVAL '1' MONTH );

In the "Indexes tab" of the Teradata view, the following entry is shown:

Name Index Type Columns Comments
Nonunique Secondary Index Order_Number

Regards,

Parthasarathi Dutta Sharma

Chuckbert 35 comments Joined 07/09
21 Jun 2010

Thanks for pointing out the problem with a Partitioned Primary Index being reported as a Secondary Index. This was caused by the fact that there are two types of primary indexes (nonpartitioned and partitioned) and only the nonpartitioned type was being handled as a primary index.

If an index's type isn't nonpartitioned primary index, the index currently is always reported as a secondary index. We will fix this in our next release to include partitioned primary indexes.

davidhfeldman 3 comments Joined 04/10
28 Jun 2010

I'm using the FastLoad option (right-clicking on a table) and I'm getting an error stating that there is one faulty row. Are the FastLoad error tables that could tell me which row in particular is causing the error created by the FastLoad process when used through SqlA JE? Or is there some other error reporting implementation for FastLoad used via SqlA?

fgrimmer 486 comments Joined 04/09
28 Jun 2010

The FastLoad error tables are temporary and no longer available when the JDBC FastLoad call returns. The FastLoad protocol does not indicate which row is bad, so the JDBC Driver FastLoad cannot be more specific. The JDBC SQL Exception chain errors are provided in the Message tab of the SQL Results View in SQLA JE. The faulty row error is typically an error trying to translate one of the column data types for FastLoad.

vsatsang 1 comment Joined 05/09
14 Jul 2010

I wanted to provide some feedback on what makes the tool less useful to me. I understand that the product manager has to weigh different features, so mine is just one view point. I am a business user, albeit with solid SQL skills that I use to build ad-hoc reports, do mastering and cleaning of data, etc.

1. I don't know how to create a "favourites" of schemas I most often visit. I hate having to scroll through the list of all schemas. [In SQL Assistant this is easy because we add databases one at a time].
2. Similarly, our schemas are littered with bunches of tables and views. So I want to be able to create a filtered set of the ones that are most useful to me. [ This is not possible, AFAIK, in SQL Assistant also ].
3. I understand that the SQL Builder does do table name completion and this matter was brought up earlier in this forum, but with the plethora of tables, table name completion in the SQL scratchpad would be really nice. To allow for better performance, this can be an turn-off-able feature.
4. When running a script, need some way to number the queries (folding queries in the editor would be even better)... because when I have to find an error, counting the number of queries is a pain.
5. I get errors in saving as Excel all the time in SQL Assistant or Exporting to MS Access, haven't tried that outin the Java Edition yet, but I really hope it is a lot more error free.
6. I would really like a visual query builder that includes joins, etc. but is faster than using Microsoft Query. The one in SQL Assistant is a little clunky, so I am more productive and faster just tying out the queries.

Several of the features of of PL/SQL Developer I miss a lot from my Oracle days. That's a good source of feature ideas.

fgrimmer 486 comments Joined 04/09
14 Jul 2010

Thank you for your feedback. In response to your concerns:
#1. There is a way to filter on the schemas list and select only specific schemas to show in the data source explorer: Right click on the Schemas folder and select 'Properties'. Uncheck the 'Disable filter' option and select the 'Selection' option. The list of schemas is displayed with check boxes to select the ones you want to display. Or you can also enter a filter expression. The downside is that your content assist is limited to what you have filtered on. This feature is also available on the Tables folder, which should address your concern #2.
#3. There is an option to turn off the code assist or name completion. Go to Window>Preferences and open the Data management>SQL Editor>Code Assist. Uncheck the 'Enable auto activation' option. You can also change the auto activation delay time and trigger.
#4. We don't currently have a way to number the queries in the SQL Editor but there is an Outline View that can help you find a SQL statement more quickly in a long list of statements. To open the Outline View: Click on Window>Show View and select Outline. This will open the Outline view in the display. Drag the view so it is lined up next to the SQL Editor/Scratchpad, for easy reference to the SQL statements.
#5. Give the export option a try and let us know if you have any problems or feedback.
#6. There is a Query Builder as part of the SQL Editor. Right click in the SQL Editor/Scratchpad and select the option 'Edit in SQL Query Builder'. This will launch the 'SQL Query Builder' dialog. From here you can add tables and joins, etc to build your query. A drawback, at this time, is that it doesn't optimize for Teradata SQL.

Let us know if you have any additional feedback.

purimetla.raj 1 comment Joined 07/10
24 Aug 2010

This is quite different from old sql assistant. One difference which is bothering it is slow in connecting and disconnecting to TD servers.

schloegl 11 comments Joined 11/09
02 Sep 2010

Hi, i like the SQL Assistant Java Edition very much. But i have a problem with executing several SQL-Statements in one go. E.g. when I want to Create a volatile Table and work on it with a second statement I get an error - it seems that a new session is started for each SQL-statement? the same statements work in the 'old' version of SQL-assistant without a problem. Maybe there is an option somewhere, but I didn't find it...

Chuckbert 35 comments Joined 07/09
02 Sep 2010

SQL Assistant Java Edition is using a JDBC connection that has autocommit on. This means that each time SQL statements are executed, they are run in a transaction that is committed when it is done. This probably is causing the issues you've encountered.

The statements are all run in a single session so the volatile table should remain available what the application is running.

I'm not sure what error you're seeing when you work on your volatile table with the second statement. If you have entered the CREATE TABLE SQL and the statement that works on the new table in the SQL Editor then select "Execute All" for the editor's context menu, you will get an error "Only a COMMIT WORK or null statement is legal after a DDL Statement." because the two statements are run in a single transaction and you can't run a DML statement after a DDL statement in a transaction.

If you select the CREATE VOLATILE TABLE statement in the editor then select the "Execute Selected Text" from the editor's context menu, the statement should execute and the volatile table should be ready to be used.

All the manipulation of the volatile table would then have to be done in a single transaction. The only way to achieve that right now is to select all the statements you want to run then select the "Execute Selected Text" menu item. This will run the selected statements in a single transaction.

Because the autocommit is done, if you run a statement that inserts rows into a volatile table then run a statement to select from the volatile table as a separate operation you will get no rows returned. This is because the insert operation was committed and, being a volatile table, the contents are then gone.

What appears to be missing from SQL Assistant Java Edition is a way to turn off the autocommit setting in the connection. This will be added to our list of improvements to add to future versions.

Chuckbert 35 comments Joined 07/09
02 Sep 2010

Well, what do you know? We learn something new about our own product every day! It is built on the Data Tools Platform from Eclipse and their ability to turn off autocommit is something I hadn't encountered before.

There is a setting in the Preferences that lets you set the commit mode to manual.

The setting is in the Preferences dialog box at:
Data Management>SQL Development>SQL Editor>SQL Files/Scrapbooks
(you can type the word "scrap" in the filter box at the top right corner of the Preferences dialog box to find that page more quickly.)

In that preferences page, you then select the Type and Name setting that match what you see in the SQL Editor window. In the "Connection Commit Mode" setting, select "Manual" from the list and save the preference (OK or Apply button).

Once you've made that preference selection you'll have to reopen the SQL file...the setting doesn't seem to be applied to open editor windows. The editor shows "Manual Commit" as part of the Status.

Once you've set the Commit Mode to Manual, the statements are run in a single transaction until you execute a COMMIT or ROLLBACK statement. It looks a commit is performed when you shut down the application.

This is rather clunky and we'll need to add buttons to perform the toggling of the commit mode, and to perform the commit and rollback actions.

tomnolan 12 comments Joined 01/08
02 Sep 2010

When you create the volatile table, if you specify the clause ON COMMIT PRESERVE ROWS, then the volatile table's contents will persist across transaction boundaries.

schloegl 11 comments Joined 11/09
02 Sep 2010

Thank you for your fast responses.
I don't reach the point where the autocommit could be a problem :-)
What I did was to select all statements (Create table, Insert, Select..) and click on the footstep ('Execute SQL-Statements as individual statements').
I did the same in the 'normal' SQL-Assistant - there the description is 'Execute the query one statement at a time'.

No I tried what Chuckbert said:
At first I create the table with "Execute Selected Text". No Problem.
Then I try the insert and get: 'Object 'vt_emp_job_dept' does not exist.

Here are my statements:

create volatile table vt_emp_job_dept, NO LOG
(empno int,
deptname CHAR(15),
job_desc CHAR(15))
UNIQUE PRIMARY INDEX (empno)
ON COMMIT PRESERVE ROWS
;
insert into vt_emp_job_dept
Select employee_number, department_name, description
from e_d00_tmp.employee a
left outer join e_d00_tmp.job b
on a.job_code = b.job_code
inner join e_d00_tmp.department c
on a.department_number = c.department_number
;
select * from vt_emp_job_dept
;

Chuckbert 35 comments Joined 07/09
03 Sep 2010

I don't see what is going wrong...it works for me when I try it.

I entered your (slightly edited) SQL into the editor. When I click on the run as individual statements footprints the table is created, the row is inserted and the row is selected and appears in the SQL Results View. (I changed the INSERT/SELECT part of the SQL to simply select three constants rather than columns from joined tables. That shouldn't cause any differences since your error message says the destination table doesn't exist.)

If I modify the INSERT statement to add additional rows and rerun it and the SELECT, I see the additional rows in the results.

If I disconnect the database, reconnect and run the INSERT/SELECT, I do see the "Object 'vt_emp_job_dept' does not exist." message since a new session has been created.

I've tried doing all this with autocommit and manual commit and I've tried with some other JDBC connection properties and can't get the error message to occur except after disconnecting and reconnecting when the error is expected to happen.

Have you added or changed any JDBC Connection Properties when you defined the Connection Profile to your database system? (By default only the CHARSET=UTF8 and TMODE=ANSI are set.)

Are you sure that when you run the CREATE TABLE statement that the table does get created? That is, the SQL Results view's entry shows the create table statement succeeded.

Other than disconnecting and reconnecting, I don't understand why all the operations wouldn't occur in a single session.

danteo 1 comment Joined 05/10
06 Sep 2010

Hi, I am trying to use fastload to load a data file, but I get the following error:

fastload error occurred message: unexpected token

The table I'm writing to only has VARCHAR datatypes. As far as I can see, there is nothing strange with the record where the error occurred. Any ideas?

fgrimmer 486 comments Joined 04/09
06 Sep 2010

The 'unexpected token' means that in parsing the fastload input file, it has come across an unexpected value. This could be that the number of values for a row in the input file does not match the number of columns in the table, or the column or string delimiter is not set correctly.

schloegl 11 comments Joined 11/09
10 Sep 2010

Hi Chuckbert,
* when I run he create I get 'succeeded' in the status field of the results view.
* I didn't change JDBC settings (UTF8, ANSI are set, additionaly connection url jdbc:teradata://host, Vendor Teradata
* After the successful create I try a select on the created table and get '[Teradata Database] [TeraJDBC 13.00.00.06] [Error 3807] [SQLState 42S02] Object 'vt_emp_job_dept' does not exist.'
* I can run the create multiple times, it always succeeds.

schloegl 11 comments Joined 11/09
13 Sep 2010

I shut down the SQL assistant, executed the steps you asked me to. But now the assistant works as it should! I'm happy and sorry at the same time, but I swear it behaved the way I described above! I should have restarted earlier...
Thank you for your support!

sitemaze 2 comments Joined 03/10
14 Sep 2010

Ok.. T@YS is actually Teradata @ Your Service. Anyway, I managed to get it working using 3rd party clients like DbVisualizer.

sitemaze 2 comments Joined 03/10
14 Sep 2010

If the results view is slow, would editing sqlaje.ini help? I have increased them to 512M.

fgrimmer 486 comments Joined 04/09
14 Sep 2010

This should help if you are trying to display a large result set. You can also modify the number of rows to display in the SQL Results preferences. Otherwise there may be adjustments needed on the database side to improve the performance of your query.

16 Sep 2010

I installed V13.10 and so far am impressed with the functionality and performance! My only complaint so far is that I also find the default of all databases of all types in one flattened view in the Schemas folder and then having to set a filter to be annoying. I would like to see settings for the default and improved filter options too (like a combination of Expression and Selection).

fgrimmer 486 comments Joined 04/09
16 Sep 2010

Thank you for your comments. We will look into your request for additional filtering options.

nryberg 4 comments Joined 08/10
06 Oct 2010

When I load a particular database, I always get an error:

Error 3523 User does not have SELECT access to DBC.Functions

Is there some way that I can tell SQL Assistant to stop polling the database for specific things that I can't see? After multiple clicks through the ignore button, I can finally get it to work, but it'd be great if I could just not go there in the first place.

fgrimmer 486 comments Joined 04/09
20 Oct 2010

We access the DBC views for the Teradata meta data to populate the Data Source Explorer. We will look into adding an option on the dialog such as 'Don't display this message again...' for exceptions gathering the meta data. Would that work for you?

gskaushik 4 comments Joined 09/10
23 Oct 2010

Hi,

I love this tool, this has helped me in saving my time manipulating the data.
Even though the sql assistant gives us the option to Import data, it is more convenient
to have a data editor, SQL assiatant - JAVA edition have provided me the same.

I would really appreciate TD team behind this.

I have posted my views on this tool below.

http://ramesh1986.blogspot.com/2010/10/teradata-sql-assistant-java-edition.html

Regards
GS

nryberg 4 comments Joined 08/10
25 Oct 2010

It'd be great to have the pop-up error easy to ignore, but I noticed that it slows down the query process as it attempts to pull data I don't have permission to access. If you could either configure the error to stop looking at all in the first place, or put an option some where in the preferences that would let me uncheck the need to pull these things, it'd be great.

It's kind of like the autocompletion function. It's neat, but doesn't work very well, and I simply turn it off. If I could do the same with the metadata pull errors, that'd be awesome.

Love this version of SQL Assistant more and more. Keep up the good work!

MReyerink 4 comments Joined 12/05
28 Oct 2010

When using SQLAJE I have to type my queries in the exact case of the data. This is strange as the TD server only has the ASCII character set enabled. I do not need to do this using SQL assistant. The connection profile settings are CHARSET=UTF8 and TMODE=ANSI are set. How can I configure SQLAJE to be case insensitive?

I have not been able to configure the F5 key to run SQL. I have tried to do this via preferences/general/keys to no avail.

The online help is unable to connect to web server. It displays the following message - "The server you are attempting to access has refused the connection with the gateway. This usually results from trying to connect to a service that is inactive on the server"

The server is an ISA proxy..

I would also like to see the following features;
- Ability to copy data from result sets using windows clip board.
- Each query having its own result set tab. Every time I run query it populates the same tab and so I can't compare result sets.

fgrimmer 486 comments Joined 04/09
29 Oct 2010

Martin, I have not seen the problem of the case sensitivity, so I am puzzled as to why you are having this problem. I do not use exact case and the queries are successful. SQLA JE simply passes the query to the JDBC driver for execution. I will dig further to see if I can recreate the problem.

I will also look further into Key Bindings. How are you specifying the command file?

The new features you mention, copy data from the result sets using windows clipboard and result sets having their own tab are items we are working on for out next release, SQLA JE 13.10. This release is scheduled to be ready for download by the end of the year. We are making significant enhancements to the result set and result set history areas.

Chuckbert 35 comments Joined 07/09
29 Oct 2010

Martin,

I have been able to change the key binding for the Execute All command to F5 in the following way:

As you were doing, I brought up the Preferences>General>Keys page where the key bindings can be set. In the Command list, I clicked on the "Execute All" entry (I typed "execute" in the text field above the Command list to find the Execute All command more easily).

I then cleared the "Binding" field. While the now-empty Binding field had the keyboard focus, I simply pressed the F5 key on the keyboard. Notice that "When" list shows "Editing SQL". Then I pressed OK.

Now, when the SQL Scratchpad (editor) has focus, pressing the F5 key executes the statements in the editor. The menu that is shown when right-clicking in the SQL Editor window shows the Execute All command's key binding is F5.

The F5 will execute the SQL only when the editor has the keyboard focus.

MReyerink 4 comments Joined 12/05
01 Nov 2010

Hi Chuckbert,

I am now running my queries with the F5 key..thanks for your feedback.

I have also worked out the cause of my Case Senstivity issue, when I changed connection setting from TMODE=ANSI to TMODE=TERA to problem was solved. TMODE=ANSI is case sensitive, whereas TNMODE=TERA is not case sensistive.

I look forward to the new version..

MReyerink 4 comments Joined 12/05
01 Nov 2010

Hi Chuckbert,

I am now running my queries with the F5 key..thanks for your feedback.

I have also worked out the cause of my Case Senstivity issue, when I changed connection setting from TMODE=ANSI to TMODE=TERA to problem was solved. TMODE=ANSI is case sensitive, whereas TNMODE=TERA is not case sensitive.

I look forward to the new version..

antonw 6 comments Joined 10/09
11 Jan 2011

Hi,
I saw, that SQLAje 13.10 now has LDAP support. Very good!
But now, when try to create a connection to our query-director, the connection fails, because:

com.teradata.jdbc.jdbc_4.util.JDBCException: [Teradata Database] [TeraJDBC 13.10.00.06] [Error 8906] [SQLState HY000] Query Director: Failed to InitSecurity with Server

Our query director uses the accounting string during logon, to determine which TD machine should be targeted. As this setting is missing in the connection dialog, I assume this is why the connection can not be established. (e.g. $T1$-&D for the Test-Environment)

The normal SQLA via ODBC works using this process ...
Is there a property I could use to set the connection string?
I hope so ...
Thanks in advance!
BR
Anton

fgrimmer 486 comments Joined 04/09
11 Jan 2011

The ACCOUNT property should have been in the list of JDBC Properties for the connection profile. It will get fixed and available in our next release. Sorry for the inconvenience.

antonw 6 comments Joined 10/09
12 Jan 2011

Thank you, that's good news ...
Do you have a date for the next release? Our units are very eager to use this tool.
Thanks!

fgrimmer 486 comments Joined 04/09
12 Jan 2011

We are currently planning our next release for Spring.

antonw 6 comments Joined 10/09
13 Jan 2011

It would be really great I you could provide this additional Property as a hotfix ... or perhaps there is an "inofficial" way to set this.
Thanks!

KhalidRehman 2 comments Joined 02/11
15 Feb 2011

I've a strange error.. The below query runs perfectly fine in SQL Assistant but when I tried in SQL JE it gave me error.

SQL :SELECT * FROM
DBC.DBQLogTbl JOIN DBC.DBQLSqlTbl ON DBQLogTbl.ProcID = DBQLSqlTbl.ProcID
where cast(DBQLogTbl.Collecttimestamp as date)= date
;

Error : Executed as Single statement. Failed [3577 : HY000] Row size or Sort Key size overflow.
Elapsed time = 00:00:01.625

STATEMENT 1: Select Statement failed.

Chuckbert 35 comments Joined 07/09
15 Feb 2011

@KhalidRehman The default CHARSET property of the connection is UTF8. When I ran your query with that CHARSET used in the connection profile, I see that error. I then changed the CHARSET property in the connection profile to ASCII and reran the query. It ran with no error (though on my system it returned no rows).

I see that when I define a new ODBC data source to be used by SQL Assistant, the Session Character Set's default value is ASCII. So I believe that is what the difference in running that query on the two applications is.

To change the CHARSET setting in SQLA-JE:
* right click on the connection that you're running the query on and select Properties from the context menu
* Click on the Teradata JDBC Connection Properties item on the left side of the dialog
* Add CHARSET=ASCII to the JDBC Connection Properties (which should replace the CHARSET=UTF8 property)
* OK the dialog

Apparently there is potential that the size of a row from this query that is encoded as UTF8 can exceed the maximum row size.

01 Mar 2011

Hi, I need a SQl graphical intefase for AIX, what could be the best way?

The SQL assistant for Java?
or The eclipse plugin?

regards and thanks!

regards,

Carlos G. Varela
Freelance - BI Project Manager / Solutions Architect
+34 616307704
carlos@varela.com

fgrimmer 486 comments Joined 04/09
02 Mar 2011

We currently don't support AIX. I would suggest posting to the Tools Forum to see if other have a suggestion.

panlasi 11 comments Joined 12/10
14 Mar 2011

Hello, newbie here. I love SQLA so much that when I changed jobs to an organization using MACs, I searched and found SQLJE for Mac. It was working for a while and I am loving the UI. Most recently, my company upgraded did a patch upgrade (still v.12.0.1.18h), my SQLJE encountered "Eclipse" error. I tried to fix but can't so I uninstalled SQLJE, re-donloaded and re-installed. It appears to work as I can get in TD with my driver. I an see the tables, expand them and view the columns on the Database Connections window. The problem now is running queries, it seems to be fine but running a simple query, which took 20 miliseconds in before now takes forever, literally - I had to cancel my session - the query runs and ruins without return any result a result set. When I try to cancel the query it gets stuck at "Ganle Result Set" and continue to hang.

Any ideas?

Many thanks.

Bob

panlasi 11 comments Joined 12/10
14 Mar 2011

sorry I fat fingered the last sentence above should say: When I try...... "Handle Result Set" and continue to run.

Thanks again,

Bob

Chuckbert 35 comments Joined 07/09
14 Mar 2011

Bob,

You say that it gets stuck at "Handle Result Set". I'm assuming that you've seen this shown by clicking on the Details button in the SQL Statement Execution progress dialog. Is there anything below the Handle Result Sets progress bar? There should be another progress bar labeled with something like "SQL statement execution: Iterating results".

If the Iterating results progress bar isn't shown, it would look like an exception was caused by some of the processing code that wasn't handled. Is there an entry created in the Error Log at the time the query is run? You can see the Error Log by selecting the Window|Show View|Other menu item then selecting General|Error Log from the Show View dialog box.

If there is an entry that appears to be created as a result of this query, could you paste any exception trace contained in the entry?

panlasi 11 comments Joined 12/10
14 Mar 2011

Thanks for the reply, yes there were 3 status bars in blue prior to my "attempt" to cancel query (then all 3 had Cancel Requested in parenthesis when I cancelled but did not change until a "forced quit" the application), the middle bar was Handle Result Sets... and the lowest bar was iIterating results. Since the query did not complete, no results were produced.

Here's the error: eclipse.buildId=unknown
java.version=1.6.0_24
java.vendor=Apple Inc.
BootLoader constants: OS=macosx, ARCH=x86_64, WS=cocoa, NL=en_US
Framework arguments: -keyring /Users/robert/.eclipse_keyring -showlocation
Command-line arguments: -os macosx -ws cocoa -arch x86_64 -keyring /Users/robert/.eclipse_keyring -showlocation

Error
Mon Mar 14 07:22:50 PDT 2011
An internal error occurred during: "Teradata SQL Statement Execution".

org.eclipse.swt.SWTException: Device is disposed
at org.eclipse.swt.SWT.error(SWT.java:3884)
at org.eclipse.swt.SWT.error(SWT.java:3799)
at org.eclipse.swt.SWT.error(SWT.java:3770)
at org.eclipse.swt.widgets.Display.error(Display.java:961)
at org.eclipse.swt.widgets.Display.syncExec(Display.java:3942)
at com.teradata.eclipse.datatools.sqltools.sqleditor.result.GroupSQLResultRunnable.run(Unknown Source)
at org.eclipse.core.internal.jobs.Worker.run(Worker.java:55)

Thanks again,

Bob

Chuckbert 35 comments Joined 07/09
14 Mar 2011

Bob,

The exception stack shows that main application window had been closed when the processing of the results has completed. This confuses me since you're not seeing that processing completes.

Do you see this hanging behavior for all queries you run or is there something about the results of this particular query? That is, do you ever see results of other queries displayed?

Do you know what types of data are being returned in the results?

Since you see the iterating through the results message in the progress dialog box that means that the query has finished running and the results have been returned to the program for processing. Since that doesn't complete it appears that the results processing is either looping or it is failing but in a way that the progress monitor isn't aware of. Does the Activity Monitor indicate that the program continues to use the CPU after running the query or does it appear to be idle?

panlasi 11 comments Joined 12/10
14 Mar 2011

The same behavior for any query, this particular query is agains a 1000 row table so it should have returned data quickly - select count(1) from table.table_name. Hoping to return 2 character country codes from this table. I see the Iterating results.. but the blue status bar doesn't move past 75%, The activity monitor shows .3% CPU usage but not sure whether it idle, Am I missing a component?

Thx,

Bob

panlasi 11 comments Joined 12/10
16 Mar 2011

Per my problems above, interestingly I found out that while the query is running and in "Handle Result Set...." mode, that if I right clicked on the connection and disconnect, once the connection disconnects, I get my results in the results tab? Does anyone know how I can fix this. I am getting tired of SQL Workbench.

Many thanks,

Bob

fgrimmer 486 comments Joined 04/09
17 Mar 2011

Bob,
I am trying to recreate your problem. It looks like it is iterating through the result data for display. Can you provide more information about the table you are querying? What are the column types?

thanks

fgrimmer 486 comments Joined 04/09
17 Mar 2011

Bob,
Do you have access to the DBC database? Can you try running a query such as select * from dbc.dbcinfo;

panlasi 11 comments Joined 12/10
18 Mar 2011

Thanks for responding. This happens whether the table contains 10 rows or 150 MM rows. IYes I did try that and did again before I sent this current post to make sure. The result is the same. Here's an interesting phenomena, If a query I run requires output (meaning I expect something to be returned in the SQL Results window, the hanging happens. However, I tried running a query against a table the does not exist in the DB, the query did not hang and obviously no results but I get back to ready state - meaning I can edit my my SQL code, perform task in the Database connection window, etc. This is also true when I changed my password, which did not require results in the results window. Could I be missing a plug-in that senses the query is complete therefore SQLA is ready to receive data in the results window - I don't I just invented that based on how I think this tool works.

Thanks again,

Bob

panlasi 11 comments Joined 12/10
18 Mar 2011

Apologies, got carried away answering, I forgot to give you the results of the query, which I received in the Result Set window after disconnecting my connection to DB.

select * from dbc.dbcinfo

Language Support Mode Standard
Version 12.00.03.18h
Release 12.00.03.24

Thanks,

Bob

fgrimmer 486 comments Joined 04/09
18 Mar 2011

SQLA JE is an Eclipse RCP which means that all the plug-ins are bundled in the product. No additional downloads are needed. I have a couple more questions: You mentioned earlier that you could "get in TD with my driver". Are you using the external Teradata JDBC driver? What version of Teradata JDBC are you running with? If so, can you try a connection using the Embedded Teradata JDBC driver and see if you can get results. You also mentioned that you have a patch to Teradata 12. Did the problem happen before the patch was applied?

panlasi 11 comments Joined 12/10
18 Mar 2011

It happens with either driver, the one supplied (Embedded) and the one I've used before (which worked). The version embedded is Ver 13.10 as is the external driver. I do not know what patch version it was but my workmate uses the same driver, same type machine, same version SQLA and I am able to login from his machine and run this simple test SQL. It did not have this symptom before the patch and just happened after but I think that's coincidental because I don't have issues in using another Mac. I did get an error when this started happening to me, which I why I reinstalled, I can remember but it was an Eclipse type error. Unfortunately I can not remember what the error message was.

I appreciate you looking into this.

Bob

panlasi 11 comments Joined 12/10
21 Mar 2011

Sorry, how do I do this? - Start SQLA JE redirecting standard output to a file, $ ./sqlaje > jdbc.log

Thanks,

Bob

fgrimmer 486 comments Joined 04/09
21 Mar 2011

Using the Terminal application. first locate the teradatasqla directory, depending on where you installed SQLA JE. Typically this is in your /Applications directory. So change directory to /Applications/teradatasqla/Teradata SQL Assistant.app/Contents/MacOS. You should see the file sqlaje. Then try launching SQLA JE using: ./sqlaje > jdbc.log to redirect the output to a file.

panlasi 11 comments Joined 12/10
21 Mar 2011

I can't run it that way, getting permission denied error when I try to launch. Any alternative?

panlasi 11 comments Joined 12/10
21 Mar 2011

An update: All of a sudden, with reinstalling any OS and/or software, my queries started working. I still have a trouble ticket with my systems folks but for now, if you have ideas where to start looking on their end, I would appreciate it. BTW, the systems folks here do not support TD SQLA, funny because this is TD installation, they would much rather us use SQL Workbench or Aqua Data Studio, go figure. Thanks to all that tried to help but the gnomes seemed to have gone away :)

Bob

MK183200 3 comments Joined 03/11
30 Mar 2011

Just installed and checked out the latest SQL Assistant Java Edition, and immediately a few suggestions for improvement came to my mind:
.) In the Teradata results view, it would be nice if rows could be sorted by multiple columns, as in the classical Queryman.
.) It would be terrific if the query history could be imported from Queryman.
.) Stability needs improvement. I keep geting java NullPointerExceptions on every other operation such as clicking on a displayed Database object or just before results would be displayed.

Regards µX

fgrimmer 486 comments Joined 04/09
30 Mar 2011

.) SQLA JE will allow you to sort multiple columns but one at a time. We can look into similar sort.
.) Our next release will allow you to import history from the original SQL Assistant (previously Queryman).
.) You should not be getting NullPointExceptions. Please send more information on the NPE that is occurring.

MK183200 3 comments Joined 03/11
31 Mar 2011

Another nice feature to have would be a "Show definition" feature for Views etc. as in Queryman! I know, I know, one tends to get lazy...

As for NPEs, I don't know if this is the right platform to place stack dumps, but here is some information about the system I am running on. I was just clicking on a database object and got this:
eclipse.buildId=unknown
java.version=1.6.0_20
java.vendor=Sun Microsystems Inc.
BootLoader constants: OS=win32, ARCH=x86, WS=win32, NL=en_US
Command-line arguments: -os win32 -ws win32 -arch x86
Error Thu Mar 31 09:51:31 CEST 2011 Problems occurred when invoking code from plug-in: "org.eclipse.jface". java.lang.NullPointerException at com.teradata.datatools.sqldev.models.privileges.PrivUtils.getConnectionUser(Unknown Source) [...]

I guess it may have to do with the TD ODBC version I am using (13.0.0.22)?

Regards µX

fgrimmer 486 comments Joined 04/09
31 Mar 2011

Michael,
Thank you for your comments. We will look at adding a "Show definition" option.

It looks like the NPE is a database permission problem. We have fixed this problem in our upcoming release, due out in May.

alexfed 3 comments Joined 04/11
07 Apr 2011

I am getting this error when executing a query. The only way to reslove is to restart the tool. After a few minutes of use this error pops again.

'Launch Teradata ResultsetViewer' has encontered a problem:

The stack trace:

eclipse.buildId=unknown
java.version=1.6.0_21
java.vendor=Sun Microsystems Inc.
BootLoader constants: OS=win32, ARCH=x86, WS=win32, NL=en_AU
Command-line arguments: -os win32 -ws win32 -arch x86

!ENTRY org.eclipse.ui 4 0 2011-04-08 11:55:20.397
!MESSAGE Unhandled event loop exception
!STACK 0
java.lang.NullPointerException
at com.teradata.datatools.dtp.teradataview.view.ViewConta iner.activateCurrentItem(Unknown Source)
at com.teradata.datatools.dtp.teradataview.view.ViewConta iner.handleSelection(Unknown Source)
at com.teradata.datatools.dtp.teradataview.view.ViewConta iner$2.widgetSelected(Unknown Source)
at org.eclipse.swt.widgets.TypedListener.handleEvent(Type dListener.java:228)
at org.eclipse.swt.widgets.EventTable.sendEvent(EventTabl e.java:84)
at org.eclipse.swt.widgets.Widget.sendEvent(Widget.java: 1003)
at org.eclipse.swt.widgets.Widget.sendEvent(Widget.java: 1027)
at org.eclipse.swt.widgets.Widget.sendEvent(Widget.java: 1012)
at org.eclipse.swt.widgets.Widget.notifyListeners(Widget. java:770)
at org.eclipse.swt.custom.CTabFolder.setSelection(CTabFol der.java:3256)
at org.eclipse.swt.custom.CTabFolder.destroyItem(CTabFold er.java:647)
at org.eclipse.swt.custom.CTabItem.dispose(CTabItem.java: 165)
at org.eclipse.swt.custom.CTabFolder.onMouse(CTabFolder.j ava:2205)
at org.eclipse.swt.custom.CTabFolder$1.handleEvent(CTabFo lder.java:327)
at org.eclipse.swt.widgets.EventTable.sendEvent(EventTabl e.java:84)
at org.eclipse.swt.widgets.Widget.sendEvent(Widget.java: 1003)
at org.eclipse.swt.widgets.Display.runDeferredEvents(Disp lay.java:3910)
at org.eclipse.swt.widgets.Display.readAndDispatch(Displa y.java:3503)
at org.eclipse.ui.internal.Workbench.runEventLoop(Workben ch.java:2405)
at org.eclipse.ui.internal.Workbench.runUI(Workbench.java :2369)
at org.eclipse.ui.internal.Workbench.access$4(Workbench.j ava:2221)
at org.eclipse.ui.internal.Workbench$5.run(Workbench.java :500)
at org.eclipse.core.databinding.observable.Realm.runWithD efault(Realm.java:332)
at org.eclipse.ui.internal.Workbench.createAndRunWorkbenc h(Workbench.java:493)
at org.eclipse.ui.PlatformUI.createAndRunWorkbench(Platfo rmUI.java:149)
at com.teradata.sqla.Application.start(Unknown Source)
at org.eclipse.equinox.internal.app.EclipseAppHandle.run( EclipseAppHandle.java:194)
at org.eclipse.core.runtime.internal.adaptor.EclipseAppLa uncher.runApplication(EclipseAppLauncher.java:110)
at org.eclipse.core.runtime.internal.adaptor.EclipseAppLa uncher.start(EclipseAppLauncher.java:79)
at org.eclipse.core.runtime.adaptor.EclipseStarter.run(Ec lipseStarter.java:368)
at org.eclipse.core.runtime.adaptor.EclipseStarter.run(Ec lipseStarter.java:179)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknow n Source)
at java.lang.reflect.Method.invoke(Unknown Source)
at org.eclipse.equinox.launcher.Main.invokeFramework(Main .java:559)
at org.eclipse.equinox.launcher.Main.basicRun(Main.java: 514)
at org.eclipse.equinox.launcher.Main.run(Main.java:1311)

Jparks2532 2 comments Joined 02/11
08 Apr 2011

I wanted to describe an issue that I've had recently with SQLA Java edition (13.10.0.201012021734), and receive some ideas about how to retrieve the week of code that I've lost as a result of this bug.

For the past week, I thought I'd try out SQLA Java edition because the legacy version of SQLA has had trouble submitting queries the TD system at my project site. I created a project and saved my SQL in separate 'files' within this project. At the time, I assumed that this was a safe move, but I was entirely wrong.

This morning, I had trouble establishing the connection with the TD machine (probably because I was attempting remote access through VPN), and SQLA JE stopped responding. As a result, I killed the process and tried to restart the program (through the start menu icon). To my surprise I got the following Error Dialog:
---------------------
Workspace in Use
---------------------
The application can not be started because its workspace is in use. Only one application can use a workspace at a time.
----------------------
The next and last thing I did was try to open the program directly through target .exe file. Magically, the program opened, and all of my connection information and the files saved under the SQL project were GONE! Even more surprisingly, any time that I attempt to open the program through the start menu links, I get the same Error Dialog. FYI, I've checked to verify that the target of the start menu link is the same .exe file. I've also checked the workspace folder for my old project files, and they are nowhere to be found.

Can someone please explain why the program opens directly through the target, and not through the start menu links. More importantly, Can anyone explain why my entire workspace was wiped out!?!? Finally, does anyone know if it's possible to recover these files? FYI, I don't have DBQL collected for the queries that were run.

Thanks very much for any help that you can provide.

Jonathan Parks | Teradata | Solutions Architect | 404) 210-4992

Jparks2532 2 comments Joined 02/11
08 Apr 2011

Good news! I restarted my computer, and was able to start SQLA JE from the start menu. Miraculously, all of SQL, the SQL history, and connection info was present. I then did a harddrive search based on my project name, and found that the workspace that was referenced (when using the start menu icon) is located in:

"C:/Documents and Settings/[username]/workspace".

Alternatively, when I was starting SQLA JE directly from the executable:

"C:\Program Files\Teradata\Client\13.10\Teradata SQL Assistant Java Edition\sqlaje.exe",

the associated workspace was in:

"C:\Program Files\Teradata\Client\13.10\Teradata SQL Assistant Java Edition\workspace".

Can anyone explain why a different workspace is used in these two cases? Thanks.

Jonathan Parks | Teradata | Solutions Architect | 404) 210-4992

fgrimmer 486 comments Joined 04/09
08 Apr 2011

Yes, on Windows platforms, the start menu icon will start up in the user's Home directory and this is where it will create the workspace. If you start SQLA JE by clicking on the .exe file, it will start in that location and create the workspace there.

fgrimmer 486 comments Joined 04/09
08 Apr 2011

@alexfed - Try closing the Teradata View by clicking the [X] on the tab. When you execute a new query, it will restart a new Teradata View. Does the query always cause this problem?

alexfed 3 comments Joined 04/11
10 Apr 2011

Yep closing the teradata view does seem to avert the issue. It happens with all queries. I tried simple selects and nested joins.

I think I manged to re-create the sequence of events that causes the ResultViewer to crash.

1. Right click on a table in Data View Explorer. An NPE is thrown in a pop-up window: Problems occurred when invoking code from plug-in: "org.eclipse.jface".

2. Modify an existing query in the Scrap Book

3. Execute the query - this is when the "'Launch Teradata ResultsetViewer' has encontered a problem" error is thrown

So by the looks of it, it is the "org.eclipse.jface" NPE that is the culprit. Here is the stack trace:

Problems occurred when invoking code from plug-in: "org.eclipse.jface".

java.lang.NullPointerException
at com.teradata.datatools.dtp.teradataview.view.ViewContainer.selectExistingTab(Unknown Source)
at com.teradata.datatools.dtp.teradataview.view.ViewContainer.showViewContributor(Unknown Source)
at com.teradata.datatools.dtp.teradataview.view.TeradataView.show(Unknown Source)
at com.teradata.datatools.dtp.teradataview.view.TeradataView.showSelection(Unknown Source)
at com.teradata.datatools.dtp.teradataview.view.TeradataView.handleSelectionChange(Unknown Source)
at com.teradata.datatools.dtp.teradataview.view.TeradataView.access$2(Unknown Source)
at com.teradata.datatools.dtp.teradataview.view.TeradataView$2$1.selectionChanged(Unknown Source)
at org.eclipse.jface.viewers.StructuredViewer$3.run(StructuredViewer.java:864)
at org.eclipse.core.runtime.SafeRunner.run(SafeRunner.java:42)
at org.eclipse.core.runtime.Platform.run(Platform.java:888)
at org.eclipse.ui.internal.JFaceUtil$1.run(JFaceUtil.java:48)
at org.eclipse.jface.util.SafeRunnable.run(SafeRunnable.java:175)
at org.eclipse.jface.viewers.StructuredViewer.firePostSelectionChanged(StructuredViewer.java:862)
at org.eclipse.jface.viewers.StructuredViewer.handlePostSelect(StructuredViewer.java:1175)
at org.eclipse.ui.navigator.CommonViewer.handlePostSelect(CommonViewer.java:475)
at org.eclipse.jface.viewers.StructuredViewer$5.widgetSelected(StructuredViewer.java:1200)
at org.eclipse.jface.util.OpenStrategy.firePostSelectionEvent(OpenStrategy.java:251)
at org.eclipse.jface.util.OpenStrategy.access$5(OpenStrategy.java:245)
at org.eclipse.jface.util.OpenStrategy$3.run(OpenStrategy.java:419)
at org.eclipse.swt.widgets.RunnableLock.run(RunnableLock.java:35)
at org.eclipse.swt.widgets.Synchronizer.runAsyncMessages(Synchronizer.java:134)
at org.eclipse.swt.widgets.Display.runAsyncMessages(Display.java:3885)
at org.eclipse.swt.widgets.Display.readAndDispatch(Display.java:3506)
at org.eclipse.ui.internal.Workbench.runEventLoop(Workbench.java:2405)
at org.eclipse.ui.internal.Workbench.runUI(Workbench.java:2369)
at org.eclipse.ui.internal.Workbench.access$4(Workbench.java:2221)
at org.eclipse.ui.internal.Workbench$5.run(Workbench.java:500)
at org.eclipse.core.databinding.observable.Realm.runWithDefault(Realm.java:332)
at org.eclipse.ui.internal.Workbench.createAndRunWorkbench(Workbench.java:493)
at org.eclipse.ui.PlatformUI.createAndRunWorkbench(PlatformUI.java:149)
at com.teradata.sqla.Application.start(Unknown Source)
at org.eclipse.equinox.internal.app.EclipseAppHandle.run(EclipseAppHandle.java:194)
at org.eclipse.core.runtime.internal.adaptor.EclipseAppLauncher.runApplication(EclipseAppLauncher.java:110)
at org.eclipse.core.runtime.internal.adaptor.EclipseAppLauncher.start(EclipseAppLauncher.java:79)
at org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.java:368)
at org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.java:179)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.lang.reflect.Method.invoke(Unknown Source)
at org.eclipse.equinox.launcher.Main.invokeFramework(Main.java:559)
at org.eclipse.equinox.launcher.Main.basicRun(Main.java:514)
at org.eclipse.equinox.launcher.Main.run(Main.java:1311)

alexfed 3 comments Joined 04/11
10 Apr 2011

P.s In step 4 when I close the Teradata View and then re-execute the query Eclipse just hangs indefinitely so the only way to fix this is to kill the process and restart Eclipse

fgrimmer 486 comments Joined 04/09
12 Apr 2011

We need for you to send us your log file so we can get a better idea of what is going on. Visit our Customer Support site (http://tays.teradata.com/web/guest;jsessionid=108277C3187639BB8A883050708ACE94) and open an incident through Teradata @ Your Service or call 1-877-my-tdata. Thanks

whitestorm2k 2 comments Joined 09/04
11 May 2011

Is it possible to connect to other databases, especially Hive, using SQL Assistant Java Edition?
Thanks in advance.

fgrimmer 486 comments Joined 04/09
12 May 2011

Yes, we have added support for Oracle, SQL Server, and DB2, which will be available at the end of May. No plans for Hive at this time.

vgrinber 2 comments Joined 05/11
16 May 2011

Two questions:

1. Select all does not seem to work on the resultset. I'm clicking within the data and then hitting Ctrl-A.

2. Can I copy (Ctrl-C) data from the resultset with the headers? Right now, only the data is being copied.

rgallen 1 comment Joined 03/11
18 May 2011

Hello!

Quick question - Is it possible to run(execute) the syntax for TDGeoImport through SQLA JE?

Thanks!

fgrimmer 486 comments Joined 04/09
18 May 2011

@vgrinber,
1. Select All is not an option for the result set. You would have to use the Shift key to select multiple cells. This is something we can add in the future.
2. The copy is just for result data. Use the Save or Export to include the column headers.

fgrimmer 486 comments Joined 04/09
18 May 2011

@vgrinber,
Added note, our new version of SQLA JE, 13.11, will have the Select All option for both the result set and the SQL history. SQLA JE 13.11 is scheduled to be released at the end of May.

vgrinber 2 comments Joined 05/11
19 May 2011

Thanks fgrimmer! I'm glad that option will be added.

fgrimmer 486 comments Joined 04/09
19 May 2011

@rgallen
No, the TDGeoImport commands are run outside of SQLA JE.

RW255006 3 comments Joined 12/10
15 Jun 2011

fgrimmer: I'm usinig 13.01 now I want to upgrade to 13.11

1. This what is happening with "Teradata SQL History" and "Teradata" tabs it really makes me cry from point of view calling usabilty. Tell me why "Teradata" plugin calls "Teradata SQL History" each time, even if it's closed? Why "Teradata"s PIN is not implemented right ?
2. Why "Teradata" tab disables "SQL Result" tab ?
3. Why I can only "Export" configured shortcuts ?
4. Why You don't keep standard and force users to learn weard combinations of keyboard shortcuts ?
5. Why You don't handle JDBC connection right, whole Eclipse platform really slows down after leaving open connection with no action for a while ( eg. hibernation )

What is missing:
1. I have 2000 ( from 6k ) of filtered tables in Data Source Explorer and I want to find table D01501_PARTY, why You don't implement input field on top which will filter objects real time?
2. Teradata SQL History takes 1/4 of screen where 80% of informations provieded is unusefull. Does timestamp is more important then result status which should be represented by Icon (not Text)? That's why "SQL Result" is 10 times better
3. Connection profile should be smaller and on right-top side because it's not used often.

I think it's good to learn from others : "MySQL WorkBench" or "Oracle SQL Developer" because my whole team is not using this edition...

R.

fgrimmer 486 comments Joined 04/09
15 Jun 2011

Rafal,
For many reasons we have evolved the SQLA JE product. As mentioned, this product is based on Eclipse and its DTP framework. Where possible, we have used this extensible platform to add value for use with Teradata. But when we can't extend Eclipse and DTP, we have developed our own extensions.

The Teradata SQL History is now used when executing SQL statements. It replaces the DTP SQL Result view. We needed to provide additional information in this regards. The information is provided in group sections. If you are not interested in a section, you can close that section by clicking the double arrows >>. SQLA JE will remember that you have closed a section next time you bring it up. The user can also resize or move the views to customize their display.

The Teradata View does provides the ability to Pin its tabs. If you Pin a tab it will not close the tab until you manual close it (click the 'X') or if you close the Teradata View.

The shortcut keys are the Eclipse shortcut keys with additional shortcut keys that we have added.

Importing Key bindings is something we can look into as well as a Find option to help find objects in the Data Source Explorer.

Sen_td 3 comments Joined 08/11
09 Aug 2011

i did not find an option to abort the submitted request. Can't we abort a request from Sql Asst JE?

--Sen

fgrimmer 486 comments Joined 04/09
09 Aug 2011

Yes, When you execute your SQL statement, a dialog pops up 'SQL Statement Execution' and you can click the Cancel button to cancel the execution. If you have designated to Run in Background. You can open the Progress Bar view, from Show View, and cancel from there.

Sen_td 3 comments Joined 08/11
10 Aug 2011

Yes got it, Thanks! and also i set in preferences that keywords should appear in uppercase but it is not happening. Anything else i need to set to make it work?

fgrimmer 486 comments Joined 04/09
10 Aug 2011

I believe the preference you are referring to is for the SQL Formatter. This is invoked by pressing the Format toolbar button, or going to the Tools>Format SQL option, or pressing Control SHIFT F in the SQL Editor. Make sure you have selected a Teradata connection profile for your SQL Editor window.

Sen_td 3 comments Joined 08/11
10 Aug 2011

Yes got it, it looks like i need to manually format everytime so that my keywords are converted to Uppercase but in Sql Asst ODBC version Keywords converted to Uppercase automatically if the option was set.

gskaushik 4 comments Joined 09/10
18 Aug 2011

Is it possible to generate random data within the Teradata tables ??

Regards
GS

Chuckbert 35 comments Joined 07/09
18 Aug 2011

@gskaushik The Database forum is probably a better place for your question. There is the RANDOM(lower_bound, upper_bound) function that returns a random integer in the specified range of values. The result of that function could be used in your insert statements to determine the random data you want to create.

gskaushik 4 comments Joined 09/10
18 Aug 2011

Chuckbert,I understand that we can use the random function to generate random numbers.

let me rephrase my question, I want to generate data within the tables for all the columns.Is there any facility within SQL assistant to populate data within tables.

Regards
GS

playwiz 2 comments Joined 07/11
22 Aug 2011

Is there a reason my SQLA JE runs incredibly slow? Connecting upon loading the workspace is fine. But then as I'm writing SQL statements and it gets to a point where it wants to suggest keywords, it just hangs.

Anyone else having this problem? Seriously contemplating going back to using 12.00 >_<

Chuckbert 35 comments Joined 07/09
22 Aug 2011

@playwiz The default setting for Code Assist (the suggesting keywords and database object names) is to have these words displayed automatically after a slight pause in typing. You can turn the auto activation of the feature off in the following location in the Preferences dialog:

Data Management>SQL Development>SQL Editor>Code Assist

If you uncheck the "Enable auto activation" checkbox, the list will not be automatically shown as you type. When you do want the code assist feature's choices, you can press Ctrl-Space and the list will be displayed.

In the next version we're planning to change the default for this setting to be unchecked and to provide a toolbar button to toggle the setting.

playwiz 2 comments Joined 07/11
22 Aug 2011

@Chuckbert -- Thanks for the tip. I'll give that a shot before throwing in the towel on this version.

Has this version been tested against gigantic schemas? Even just expanding the database tree takes an incredibly long amount of time (7 to 10 minutes) on average; God forbid, we want to go further down into the various schemas...

Chuckbert 35 comments Joined 07/09
22 Aug 2011

Again, there is a default setting that can cause slow performance on large system where every object is loaded for each level of the Data Source Explorer (DSE) when you expand that level. You can set filters on the nodes of the DSE that contain collections of objects.

If you expand the DSE to the "Schemas" folder, you can right-click on the Schemas folder and select the "Properties" item from the context menu. You can then uncheck the "Disable filter" checkbox near the bottom and specify either an Expression or Selection filter. The Selection filter lets you select the schemas you want shown in the DSE from the list of schemas that are on the system.

The Expression filter lets you specify a string of characters that appears in the names of the schemas in the positions selected from the drop-down list.

There are other collections of objects deeper in the DSE that let you define similar filters.

pdruley 1 comment Joined 01/10
24 Aug 2011

Is it currently possible or could it one day be possible to use the "Format SQL" tool to only make keywords uppercase? When I try to make keywords uppercase using "Format SQL" it realigns my query even when I change all of the options to "Unchanged". I would just accept the alignment changes but for complex queries it doesn't meet my needs.

Using Version: 13.11.0.201106132116

fgrimmer 486 comments Joined 04/09
24 Aug 2011

I am not sure but will look into this further. thank you for the suggestion.

Subhrajit 1 comment Joined 09/11
20 Sep 2011

Hi,
I have few basic requests which is forcing me not to use this very useful tool.
Please suggest if there is any work around or simply this is not available in the tool. Thanks for your help in advance.
1) Complete DDLs/SQLs etc are not showing when we do a show procedure or show table (probably because of some thing is written in the code which restrict the max character to certain value)
2) I can't compile Teradata procedures which has BT/ET statements inside it.
3) I can't change the default font size of sql results although I can do that for the query panel. Since the default font size is very small , I can't even see the results properly
4)Once strange issue I faced, all my connections get deleted when I did a force quit. I have never faced this in any other tool starting from Aqua data studio, Sql Workbench razor SQL etc etc..

Please please look into this as this tool really a very very useful one and it will be great help if you could provide some work arounds if its not possible to have all these issues fixed . Thanks

fgrimmer 486 comments Joined 04/09
20 Sep 2011

Maker sure you are running our latest version of SQLA JE, which is 13.11.
1) Double click in the result set cell and the complete DDL is displayed in a pop up window. Currently it is not formatted but we have fixed that problem in our next release.
2) What is the error you are getting?
3) You are able to change the font size of the result set data by selecting the cells, then right click and select Format Selected Cells... menu option. A dialog will appear for you to select a larger font size.
4) I have not seen this behavior. Can you provide more information about what was happening when you did the force quit?

serisr123 2 comments Joined 10/11
23 Nov 2011

I don't see the "Export All" option in the Result Set pane. Do I need to change something in options?
Thank you

Chuckbert 35 comments Joined 07/09
23 Nov 2011

@serisr123 The Result Set view has two buttons in the view's toolbar (and in the view's menu) to Save and to Export the results. These are the two buttons to the left of the Print button. Both of these buttons save the full set of the results to a file. The difference between the two is that Save writes its files to the workspace and Export writes to a location in the file system that you select.

Is there some other action that you expect that these don't provide?

fgrimmer 486 comments Joined 04/09
26 Nov 2011

Also, the 'Export All' option is only enabled in the Teradata Result Set toolbar when you have executed multiple SQL statements (Execute All or Execute Selected Statements or Execute Selected Text as One Statement) and displaying multiple result sets.

schloegl 11 comments Joined 11/09
14 Mar 2012

Hello, I loved to work with SLA JE, but since a couple of days when I start it I always get the error: "An internal error occurred during: "Error creating SQL Model Connection connection to Brain1. (Error: org.eclipse.core.internal.dtree.NoDataDeltaNode cannot be cast to org.eclipse.core.internal.dtree.DataTreeNode)
org.eclipse.core.internal.dtree.NoDataDeltaNode cannot be cast to org.eclipse.core.internal.dtree.DataTreeNode". I even updated to Teradata Studio Express today, but the problem still remains the same. Please help!

Chuckbert 35 comments Joined 07/09
14 Mar 2012

I see that there is a bug report for Eclipse (the software Studio Express is built on) that reports the same class cast exception but the description of the problem doesn't sound related to yours.

We'll need more information about the problem. Can you provide some information from the Error Log where the details of the problem should be recorded? To display the error log you select the menu item: Window>Show View...>Other... In the resulting dialog select "Error Log" from the "General" folder. An entry in the list in the Error Log should be the details of the problem. Double-clicking on the entry will display its details.

Could you copy the Message, Exception Stack Trace and Session Data from the details and paste them into another comment?

schloegl 11 comments Joined 11/09
15 Mar 2012

There are more events when I start Studio Express

Message:
An internal error occurred during: "Creating connections to Brain1.".

Exception Stack Trace:
java.lang.ClassCastException: org.eclipse.core.internal.dtree.NoDataDeltaNode cannot be cast to org.eclipse.core.internal.dtree.DataTreeNode
at org.eclipse.core.internal.watson.ElementTreeIterator.iterate(ElementTreeIterator.java:120)
at org.eclipse.core.internal.resources.MarkerManager.visitorFindMarkers(MarkerManager.java:614)
at org.eclipse.core.internal.resources.MarkerManager.doFindMarkers(MarkerManager.java:277)
at org.eclipse.core.internal.resources.MarkerManager.findMarkers(MarkerManager.java:262)
at org.eclipse.core.internal.resources.Resource.findMarkers(Resource.java:1017)
at org.eclipse.datatools.connectivity.internal.ConnectionProfile.removeOldFailureMarkers(ConnectionProfile.java:806)
at org.eclipse.datatools.connectivity.internal.ConnectionProfile.access$2(ConnectionProfile.java:803)
at org.eclipse.datatools.connectivity.internal.ConnectionProfile$ConnectJob.run(ConnectionProfile.java:892)
at org.eclipse.core.internal.jobs.Worker.run(Worker.java:54)

Session Data:
eclipse.buildId=unknown
java.version=1.6.0_23
java.vendor=Sun Microsystems Inc.
BootLoader constants: OS=win32, ARCH=x86, WS=win32, NL=de_DE
Command-line arguments: -os win32 -ws win32 -arch x86

Message:
Error creating SQL Model Connection connection to Brain2. (Error: org.eclipse.core.internal.dtree.NoDataDeltaNode cannot be cast to org.eclipse.core.internal.dtree.DataTreeNode)

Exception Stack Trace:
java.lang.ClassCastException: org.eclipse.core.internal.dtree.NoDataDeltaNode cannot be cast to org.eclipse.core.internal.dtree.DataTreeNode
at org.eclipse.core.internal.watson.ElementTreeIterator.iterate(ElementTreeIterator.java:120)
at org.eclipse.core.internal.resources.MarkerManager.visitorFindMarkers(MarkerManager.java:614)
at org.eclipse.core.internal.resources.MarkerManager.doFindMarkers(MarkerManager.java:277)
at org.eclipse.core.internal.resources.MarkerManager.findMarkers(MarkerManager.java:262)
at org.eclipse.core.internal.resources.Resource.findMarkers(Resource.java:1017)
at org.eclipse.datatools.connectivity.internal.InternalProfileManager.removeOldFailureMarkers(InternalProfileManager.java:886)
at org.eclipse.datatools.connectivity.internal.InternalProfileManager.access$0(InternalProfileManager.java:883)
at org.eclipse.datatools.connectivity.internal.InternalProfileManager$2.profileChanged(InternalProfileManager.java:109)
at org.eclipse.datatools.connectivity.internal.InternalProfileManager.fireProfileChanged(InternalProfileManager.java:1218)
at org.eclipse.datatools.connectivity.internal.InternalProfileManager.modifyProfile(InternalProfileManager.java:1002)
at org.eclipse.datatools.connectivity.internal.InternalProfileManager.modifyProfile(InternalProfileManager.java:910)
at org.eclipse.datatools.connectivity.internal.ConnectionProfile.notifyManager(ConnectionProfile.java:722)
at org.eclipse.datatools.connectivity.internal.ConnectionProfile.setProperties(ConnectionProfile.java:250)
at org.eclipse.datatools.connectivity.sqm.internal.core.connection.ConnectionInfoImpl.initializeJDBCConnection(ConnectionInfoImpl.java:668)
at org.eclipse.datatools.connectivity.sqm.internal.core.connection.ConnectionInfoImpl.(ConnectionInfoImpl.java:644)
at org.eclipse.datatools.connectivity.sqm.internal.core.connection.ConnectionFactory.createConnection(ConnectionFactory.java:38)
at org.eclipse.datatools.connectivity.sqm.core.SQMConnectionFactory.createConnection(SQMConnectionFactory.java:45)
at org.eclipse.datatools.connectivity.sqm.internal.core.connection.ConnectionFactory.createConnection(ConnectionFactory.java:59)
at org.eclipse.datatools.connectivity.internal.ConnectionFactoryAdapterProvider.createConnection(ConnectionFactoryAdapterProvider.java:114)
at org.eclipse.datatools.connectivity.internal.ManagedConnection.createConnection(ManagedConnection.java:163)
at org.eclipse.datatools.connectivity.internal.CreateConnectionJob.run(CreateConnectionJob.java:56)
at org.eclipse.core.internal.jobs.Worker.run(Worker.java:54)

Session Data:
eclipse.buildId=unknown
java.version=1.6.0_23
java.vendor=Sun Microsystems Inc.
BootLoader constants: OS=win32, ARCH=x86, WS=win32, NL=de_DE
Command-line arguments: -os win32 -ws win32 -arch x86

Message
An internal error occurred during: "Creating connections to Brain2.".

Exception Stack Trace
java.lang.ClassCastException: org.eclipse.core.internal.dtree.NoDataDeltaNode cannot be cast to org.eclipse.core.internal.dtree.DataTreeNode
at org.eclipse.core.internal.watson.ElementTreeIterator.iterate(ElementTreeIterator.java:120)
at org.eclipse.core.internal.resources.MarkerManager.visitorFindMarkers(MarkerManager.java:614)
at org.eclipse.core.internal.resources.MarkerManager.doFindMarkers(MarkerManager.java:277)
at org.eclipse.core.internal.resources.MarkerManager.findMarkers(MarkerManager.java:262)
at org.eclipse.core.internal.resources.Resource.findMarkers(Resource.java:1017)
at org.eclipse.datatools.connectivity.internal.ConnectionProfile.removeOldFailureMarkers(ConnectionProfile.java:806)
at org.eclipse.datatools.connectivity.internal.ConnectionProfile.access$2(ConnectionProfile.java:803)
at org.eclipse.datatools.connectivity.internal.ConnectionProfile$ConnectJob.run(ConnectionProfile.java:892)
at org.eclipse.core.internal.jobs.Worker.run(Worker.java:54)

Session Data
eclipse.buildId=unknown
java.version=1.6.0_23
java.vendor=Sun Microsystems Inc.
BootLoader constants: OS=win32, ARCH=x86, WS=win32, NL=de_DE
Command-line arguments: -os win32 -ws win32 -arch x86

Message
Error creating SQL Model Connection connection to Brain1. (Error: org.eclipse.core.internal.dtree.NoDataDeltaNode cannot be cast to org.eclipse.core.internal.dtree.DataTreeNode)

Exception Stack Trace
java.lang.ClassCastException: org.eclipse.core.internal.dtree.NoDataDeltaNode cannot be cast to org.eclipse.core.internal.dtree.DataTreeNode
at org.eclipse.core.internal.watson.ElementTreeIterator.iterate(ElementTreeIterator.java:120)
at org.eclipse.core.internal.resources.MarkerManager.visitorFindMarkers(MarkerManager.java:614)
at org.eclipse.core.internal.resources.MarkerManager.doFindMarkers(MarkerManager.java:277)
at org.eclipse.core.internal.resources.MarkerManager.findMarkers(MarkerManager.java:262)
at org.eclipse.core.internal.resources.Resource.findMarkers(Resource.java:1017)
at org.eclipse.datatools.connectivity.internal.InternalProfileManager.removeOldFailureMarkers(InternalProfileManager.java:886)
at org.eclipse.datatools.connectivity.internal.InternalProfileManager.access$0(InternalProfileManager.java:883)
at org.eclipse.datatools.connectivity.internal.InternalProfileManager$2.profileChanged(InternalProfileManager.java:109)
at org.eclipse.datatools.connectivity.internal.InternalProfileManager.fireProfileChanged(InternalProfileManager.java:1218)
at org.eclipse.datatools.connectivity.internal.InternalProfileManager.modifyProfile(InternalProfileManager.java:1002)
at org.eclipse.datatools.connectivity.internal.InternalProfileManager.modifyProfile(InternalProfileManager.java:910)
at org.eclipse.datatools.connectivity.internal.ConnectionProfile.notifyManager(ConnectionProfile.java:722)
at org.eclipse.datatools.connectivity.internal.ConnectionProfile.setProperties(ConnectionProfile.java:250)
at org.eclipse.datatools.connectivity.sqm.internal.core.connection.ConnectionInfoImpl.initializeJDBCConnection(ConnectionInfoImpl.java:668)
at org.eclipse.datatools.connectivity.sqm.internal.core.connection.ConnectionInfoImpl.(ConnectionInfoImpl.java:644)
at org.eclipse.datatools.connectivity.sqm.internal.core.connection.ConnectionFactory.createConnection(ConnectionFactory.java:38)
at org.eclipse.datatools.connectivity.sqm.core.SQMConnectionFactory.createConnection(SQMConnectionFactory.java:45)
at org.eclipse.datatools.connectivity.sqm.internal.core.connection.ConnectionFactory.createConnection(ConnectionFactory.java:59)
at org.eclipse.datatools.connectivity.internal.ConnectionFactoryAdapterProvider.createConnection(ConnectionFactoryAdapterProvider.java:114)
at org.eclipse.datatools.connectivity.internal.ManagedConnection.createConnection(ManagedConnection.java:163)
at org.eclipse.datatools.connectivity.internal.CreateConnectionJob.run(CreateConnectionJob.java:56)
at org.eclipse.core.internal.jobs.Worker.run(Worker.java:54)

Session Data
eclipse.buildId=unknown
java.version=1.6.0_23
java.vendor=Sun Microsystems Inc.
BootLoader constants: OS=win32, ARCH=x86, WS=win32, NL=de_DE
Command-line arguments: -os win32 -ws win32 -arch x86

Chuckbert 35 comments Joined 07/09
15 Mar 2012

@schloegl This is a very odd situation. The connection profile manager was trying to remove any old failure "markers" that it recorded. While the marker manager was looking for any instances of the markers that the profile manager was wanting removed, it encountered a marker that was not of the right type for the collection it was looking through.

I have no idea on how to create such an invalid entry in the collection of markers. Since I can't create one, I don't know how to get an invalid entry removed.

Since the problem is related to "markers" somewhere in the application, do you see anything in the application's window that is marking some sort of situation? Perhaps a red "X" on top of an icon that might indicate an error of some kind.

It seems like the application has somehow created an invalid marker and that is causing the connection manager to always fail while trying to connect to your database system. If we knew what kind of marker might be causing the problem, we might be able to figure out how to get it removed.

A brute-force thing to try is to rename (or remove if you're brave) the internal files that hold the application's markers. These files are contained in the program's workspace.

The workspace is in your home directory. The shortcut for Studio Express uses the folder defined by the environment variables %HOMEDRIVE%%HOMEPATH% as its working directory and it creates the workspace there. If you navigate to the folder:

%HOMEDRIVE%%HOMEPATH%\workspace\

you will see folders with the names of your projects ("SQL" is the project that is automatically created) and a folder named ".metadata". The internal files are beneath the .metadata folder.

If you navigate to:

%HOMEDRIVE%%HOMEPATH%\workspace\.metadata\.plugins\org.eclipse.core.resources

you will find folders named ".root" and ".projects". In the .projects folder there will be folders named the same as projects in your workspace.

Inside the .root and .projects\SQL folders (and any subfolders of .projects with other project names) there might be files named ".markers". If you rename (or delete) the .markers files, the problem might go away. Any markers (such as bookmarks) that you have defined yourself will no longer exist but with any luck the problem will also go away.

If this does solve the problem, I would be interested in knowing what is in the offending .markers file. It is a binary file so I'm not sure how you could attach their contents.

schloegl 11 comments Joined 11/09
19 Mar 2012

@Chuckbert Thank you for your efforts. Unfortunately I don't find a single marker file in the directory you mentioned.

schloegl 11 comments Joined 11/09
19 Mar 2012

@Chuckbert I renamed the existing workspace now and started from scratch and now it works (fortunately I had a copy of my sqls) - it seems that my workspace was damaged somehow.

ericsun2 5 comments Joined 06/10
22 May 2012

Can someone cast a bit light on the following error in Linux?

!SESSION 2012-05-22 00:20:10.981 -----------------------------------------------
eclipse.buildId=unknown
java.version=1.6.0_27
java.vendor=Sun Microsystems Inc.
BootLoader constants: OS=linux, ARCH=x86_64, WS=gtk, NL=en_US
Command-line arguments: -os linux -ws gtk -arch x86_64

!ENTRY org.eclipse.osgi 4 0 2012-05-22 00:20:12.907
!MESSAGE An error occurred while automatically activating bundle org.eclipse.core.resources (102).
!STACK 0
org.osgi.framework.BundleException: Exception in org.eclipse.core.resources.ResourcesPlugin.start() of bundle org.eclipse.core.resources.
at org.eclipse.osgi.framework.internal.core.BundleContextImpl.startActivator(BundleContextImpl.java:806)
at org.eclipse.osgi.framework.internal.core.BundleContextImpl.start(BundleContextImpl.java:755)
at org.eclipse.osgi.framework.internal.core.BundleHost.startWorker(BundleHost.java:370)
at org.eclipse.osgi.framework.internal.core.AbstractBundle.start(AbstractBundle.java:284)
at org.eclipse.osgi.framework.util.SecureAction.start(SecureAction.java:417)
at org.eclipse.osgi.internal.loader.BundleLoader.setLazyTrigger(BundleLoader.java:265)
at org.eclipse.core.runtime.internal.adaptor.EclipseLazyStarter.postFindLocalClass(EclipseLazyStarter.java:106)
at org.eclipse.osgi.baseadaptor.loader.ClasspathManager.findLocalClass(ClasspathManager.java:453)
at org.eclipse.osgi.internal.baseadaptor.DefaultClassLoader.findLocalClass(DefaultClassLoader.java:216)
at org.eclipse.osgi.internal.loader.BundleLoader.findLocalClass(BundleLoader.java:393)
at org.eclipse.osgi.internal.loader.SingleSourcePackage.loadClass(SingleSourcePackage.java:33)
at org.eclipse.osgi.internal.loader.BundleLoader.findClassInternal(BundleLoader.java:466)
at org.eclipse.osgi.internal.loader.BundleLoader.findClass(BundleLoader.java:422)
at org.eclipse.osgi.internal.loader.BundleLoader.findClass(BundleLoader.java:410)
at org.eclipse.osgi.internal.baseadaptor.DefaultClassLoader.loadClass(DefaultClassLoader.java:107)
at java.lang.ClassLoader.loadClass(ClassLoader.java:247)
at com.teradata.datatools.util.Configuration.getConfigurationDirectory(Configuration.java:57)
at com.teradata.datatools.util.logging.Activator.buildLogFileName(Activator.java:336)
at com.teradata.datatools.util.logging.Activator.addLogFile(Activator.java:306)
at com.teradata.datatools.util.logging.Activator.configureLog(Activator.java:283)
at com.teradata.datatools.util.logging.Activator.start(Activator.java:81)
at org.eclipse.osgi.framework.internal.core.BundleContextImpl$1.run(BundleContextImpl.java:783)
at java.security.AccessController.doPrivileged(Native Method)a

Chuckbert 35 comments Joined 07/09
22 May 2012

@edicsun2 The problem appears to because the program is trying to create its workspace in the your current directory and that location isn't writable. For example, if you change directory to the location the program is installed and run the program you are likely to see this error because the installation directory isn't writable.

Possible solutions are:
* put the installation directory in your PATH and run the program from a writable directory.
* use the "-data workspace-location" option on the command line, where "workspace-location" is the path to a writable directory. For example, you could run "/installdirectory/sqlaje -data $HOME/workspace". This will create the workspace in your $HOME directory.

10 Jul 2012

Hello,

Can somebody give me link for downloading "SQL Assistant Java edition"? I don't see it in "Download" area.

Thanks,
Shrinivas

Thanks & Regards,
Shrinivas Sagare

MikeC 17 comments Joined 03/09
10 Jul 2012

We did a little re-branding on the current release and there are now two packages available in the "Download" area, namely Teradata Studio and Teradata Studio Express. Teradata Studio essentially equates to Teradata Administrator, however it is multi-platform (Windows, Linux, MAC) JDBC based. Teradata Studio Express is targeted at providing SQL Assistant type capability again in a multi-platform / JDBC based approach.

MikeC

sumedhpatil 5 comments Joined 06/12
10 Jul 2012

I'm trying to install express 14 edition on windows 7, Java 1.6. but getting following error while creating connection profile. could you please help. I think I'm making mistake in modifying driver settings.

com.teradata.jdbc.jdbc_4.util.JDBCException: [Teradata JDBC Driver] [TeraJDBC 14.00.00.13] [Error 1000] [SQLState 08S01] Login failure for Connection to testServer Wed Jul 11 12:09:02 IST 2012 socket orig=testServer cid=1aa7618 sess=0 java.net.ConnectException: Connection refused: connect at java.net.PlainSocketImpl.socketConnect(Native Method) at java.net.PlainSocketImpl.doConnect(Unknown Source) at java.net.PlainSocketImpl.connectToAddress(Unknown Source) at java.net.PlainSocketImpl.connect(Unknown Source) at java.net.SocksSocketImpl.connect(Unknown Source) at java.net.Socket.connect(Unknown Source) at com.teradata.jdbc.jdbc_4.io.TDNetworkIOIF$ConnectThread.run(TDNetworkIOIF.java:968)

fgrimmer 486 comments Joined 04/09
11 Jul 2012

What driver settings did you change?

fgrimmer 486 comments Joined 04/09
11 Jul 2012

@sumedhpatil, I was able to recreate the error by adding the DBS_PORT JDBC property and setting an invalid port number. Is it possible that is what you have done?

Jeanne-Anne 8 comments Joined 09/05
11 Jul 2012

When my computer was reimaged, Teradata Studio Express stopped working. I can connect to the database fine and launch a query, but the query can't handle the return set.

For example, I put "select current_date ;" in the SQL Scratchpad and click on the feet to run it. I get an error: "'Handle Result Sets' has encountered a problem. An internal error occured during: "Handle Result Sets"."

I click on "Details >>" and see the following:

An internal error occurred during: "Handle Result Sets".
com/teradata/datatools/dtp/sqltools/resultview/TeradataResultSetObjectWrapper

I have to cancel the query to get the error to go away which means I don't have the results of my query.

I've looked through this thread and someone else had the problem but I didn't understand what made it go away?

fgrimmer 486 comments Joined 04/09
11 Jul 2012

Are you running with JRE 1.7? We currently do not support that version. If that is the case, please install JRE 1.6.

Jeanne-Anne 8 comments Joined 09/05
11 Jul 2012

Checking Control Panel, it looks like I have "Java(TM) 6 Update 24". I think that's JRE 1.6?

fgrimmer 486 comments Joined 04/09
11 Jul 2012

Run the "java -version' command to see what version is being used.

Jeanne-Anne 8 comments Joined 09/05
11 Jul 2012

'java' is not recognized as an internal or external command. So it's not in my path. How do I determine which TSE is invoking?

fgrimmer 486 comments Joined 04/09
11 Jul 2012

What environment are you running, Windows, Linux, or Mac? The .log file will record the Java version. It is located in your workspace directory/.metadata directory and called .log.

fgrimmer 486 comments Joined 04/09
11 Jul 2012

@jeanne-Anne, The problem, which I think is similar to your problem, was resolved by installing Java 1.6 as your JVM.

Jeanne-Anne 8 comments Joined 09/05
12 Jul 2012

I'm running Windows. Here we go: java.version=1.6.0_24

Here's an interesting snippet:

!ENTRY com.teradata.datatools.dtp.sqltools.resultview 4 0 2012-07-11 15:06:17.775
!MESSAGE
!STACK 0
java.util.zip.ZipException: Exception in opening zip file: \\starbucks\amer\user\seasc\home\.eclipse\com.teradata.sqla.TeradataSQLA_14.0.0.201112070827_1336619553\configuration\org.eclipse.osgi\bundles\16\1\.cp\jars\net.sourceforge.nattable.core-2.2.1.jar

... a bunch of at paths ....

Caused by: java.util.zip.ZipException: error in opening zip file
at java.util.zip.ZipFile.open(Native Method)
at java.util.zip.ZipFile.(Unknown Source)
at java.util.zip.ZipFile.(Unknown Source)
at org.eclipse.osgi.framework.util.SecureAction.getZipFile(SecureAction.java:251)
... 31 more

It is a Java problem even if I'm on 1.6. I'll download Java 1.6 and reinstall it.

Jeanne-Anne 8 comments Joined 09/05
12 Jul 2012

I installed 1.6u30, but have the same problem. Looking at the .log, it's still invoking 1.6u24. How do I change which java path is used by default?

Jeanne-Anne 8 comments Joined 09/05
12 Jul 2012

I completely uninstalled 1.6u24 and now TSE tells me I have no Java installed. I must have installed a 64-bit version. I'll go looking for a 32-bit version and try again.

Chuckbert 35 comments Joined 07/09
12 Jul 2012

@jeanne-Anne, I have semi-reproduced the problem you are seeing. I modified some of the permissions in the ...\.eclipse\...\configuration directory to make a file that is in there unavailable. I get the "An internal error occurred during: "Handle Result Sets"." message.

I am wondering if in the reimaging of your computer that some permissions on files in your home directory are no longer valid. If that is the case things can go crazy.

The directory in the snippet of the exception you posted it shows that something went wrong while trying to process the file "\\starbucks\amer\user\seasc\home\.eclipse\ com.teradata.sqla.TeradataSQLA_14.0.0.201112070827_1336619553\configuration\org.eclipse.osgi\bundles\16\1\ .cp\jars\net.sourceforge.nattable.core-2.2.1.jar". The configuration directory and its contents are written to when the application needs files that are embedded in other files. If the configuration directory is deleted the files will be recreated when the program is run again.

If the problem you are seeing is a problem with permissions it might be fixed by removing the directory "\\starbucks\amer\user\seasc\home\.eclipse\ com.teradata.sqla.TeradataSQLA_14.0.0.201112070827_1336619553" (or you can simply rename it if you want to be able to restore it). After the directory is removed (or renamed) and you run the program again, the directory should be recreated and filled with fresh copies of the files with your current permissions.

Jeanne-Anne 8 comments Joined 09/05
12 Jul 2012

I think you have hit on the problem. I deleted the com.teradata.sqla... folder, leaving the .eclipse parent and the next launch I got "The configuration area at '\\starbucks\amer\user..... could not be created. Please choose a writable location using the '-configuration' command line option. I deleted the .eclipse folder and got the same error. I can't delete the home folder as that has other necessary stuff in it.

So how do I "use the '-configuration' command"?

Chuckbert 35 comments Joined 07/09
12 Jul 2012

You can put the -configuration flag in the desktop shortcut that you use to launch the program. In the "Target" field of the shortcut you can append " -configuration location" to what is there (make sure there is a space separating the new stuff from what is there).

You might need to make a copy the shortcut to make this change in. I think that the installed desktop shortcut is shared by all users on the system. Edit it by right-clicking on it and select "Properties".

Jeanne-Anne 8 comments Joined 09/05
12 Jul 2012

THAT WAS IT!

To recap - I started out with any query getting a result set error: "'Handle Result Sets' has encountered a problem. An internal error occured during: "Handle Result Sets"."

The problem turned out to be my workspace was created in a folder that became read-only when my computer was reimaged.

The resolution was to modify the target field in my shortcut to add " -configuration ____" where the "____" was the full path to a folder under My Documents which I knew would be writable.

THANK YOU for your help! :)

You must sign in to leave a comment.