I've got a table (Oracle) with c.a. 50 fields (a mix of chars, varchars and numeric data) and millions of records. A particular data set I am trying to...
Hi, In the pull down menus you have the "Window" menu which allows you to Hide the Query Toolbar, Query Results and the Server Browser. Or you can use the CTRL...
Hi Andy, One of the problems of writing an app in Java is that Java takes up more memory for data than a native app. 1 million records is probably too much to...
Hey all, new to hsqldb, i do have a small experience upon ADS and want to know if someone managed a connection with Hypersonic SQL... Regards, Yvon...
Yvon Thoraval
yvon_thoraval@...
Sep 8, 2004 7:07 am
1373
Hi Yvon, You can make a connection using the Generic JDBC connection type. Login Name: sa URL:jdbc:hsqldb:hsql://localhost Driver: org.hsqldb.jdbcDriver Driver...
I often receive Excel files from people who need a field updated or added from another database in our Datawarehouse. Is there a way to import Excel files,...
Hi Kori, Currently you can't import Excel files (I do have this on the todo list). The only thing to do is to export the Excel file to a comma delimited (CSV)...
Hi Ram, There are 2 things you can do ... 1) You can select each statement into a Query Window and then save the query window as a file. [not very efficient] ...
I was wondering what is the status of resolving the Mac L&F bug discussed in the following thread? http://groups.yahoo.com/group/aquadatastudio/message/1313...
Hi, I am not sure if you are referring to the Look and Feel issue or the Dual G5 issue which throws the exception. I don't believe the Look and Feel issue is a...
I am referring to the bug in ADS draws the the background of the application in a dark gray color. ADS is the only Java application I run that has this ...
Hi, I put out a new build with some minor fixes, including the OSX Look and Feel bug which some users have pointed out. Update instructions below ... ( ...
Hi Bob, Thanks for challenging me on this one :) ... After looking through the ADS code, I found that I was setting the background of the main frame to gray,...
Hi, Just a note. I found these two articles on the up and coming DB2 8.2, which now addresses the redistribution of the DB2 JDBC drivers. It seems IBM always...
Hi Marco, I am not sure what you mean by "extracting the .jar". But I can tell you the current state of the startup performance situation. I have done...
Thanks John, What i meant was 'unzipping or unjarring'. It creates a nice directory structure of all files. I'm not sure if this would: 1. Work 2. Reduce load...
Hi Marco, So, you can do this. You would just need to make the appropriate changes to the script to make sure the classes or in the class path. I will look...
Having gone down this road with other programs, my suggestion is to keep the jar. There is very little performance gain from unzipping the jar, and having an...
I would agree. Launching ADS on my mac G5 takes all of six seconds and Macs are supposed to be slower with Java I was led to believe. So saving a few seconds...
Hi, I will keep the jar intact, this is the standard way for packaging and distributing Java applications. In my performance testing I will also document how...
Hello, is anyone having troubles with auto-complete function? It works only for very short period of time :( Restarting ADS helps, but for half a minute or...
Hi, I have not encountered this problem before. The only thing that comes to mind is the jConnect meta data. Did you install the jConnect meta data script on...
... more ... 256MB of ... I realize that. I guess I'd expect to get some sort of a message/error checking (like 'not enough memory to complete this ...
... You are correct. I have this on my list. I do want to fix this badly ... I am not aware of any other tools that do this. The problem with this is that...
John, About the restricting the number of records; What about having a configuration setting that add's (for DB2) after a select ' fetch first xx rows only...
Hi John, I don't know whether it is comparable as it is more of a front-end type of tool than ADS but Servoy has a default limit of 200 records it retrieves at...