SQLEditor 1.4.7 won't launch on Mac OS X 10.6 Snow Leopard.
To use SQLEditor on Snow leopard you need to use version 1.6 or later.
See the SQLEditor and Snow Leopard page for more details and to download the 1.6 beta.
SQLEditor 1.4.x requires that you use only JDBC drivers that support Java 1.4
This is regardless of which version of the JDK is currently installed.
(This issue is mainly because SQLEditor 1.4 is still officially supporting Mac OS X 10.3.9)
SQLEditor 1.6 does not have this limitation and on Mac OS X 10.5 will support Java 1.5 JDBC drivers. On Mac OS X 10.6 it supports Java 1.6 JDBC drivers too.
If you have a table and reorder the fields in SQLEditor, this reordering will not be exported to the database.
This is due to be fixed in a future release for databases that support field ordering.
Please use the release version 1.4 or later. (Beta versions after 1.4b25 also work)
(If you need to use 1.3.9 for some reason please get in touch, there's a special build)
SQLEditor will only run natively, please use version 1.1.4b1 or later
[Top]
Use uppercase, Oracle JDBC drivers seem to expect schema names to be in uppercase
Please upgrade to the latest available JDBC driver, which should fix the problem.
SQLEditor will only recognize drivers that are included on its internal list. If the driver isn't on this list then it will not be recognized automatically and you will need to add it by hand.
See the SQLEditor database drivers page for details of supported drivers
If you install drivers while it is running it may not recognise them immediately. Try restarting SQLEditor to see if this makes any difference.
[Top]
Drag using the drag handle on the left of the field. If no handle is visible try clicking on the field first
Files without extension or with the extensions sql,text or txt can be imported
[Top]
MySQL versions 5.2 and later want to use keyword "ENGINE" instead of "TYPE" for specifying table engine types (INNODB, MyISAM, etc)
Earlier versions of SQLEditor used "TYPE", new releases now correctly use "ENGINE"
[Top]
If you do the following you may get an error:
This may fail with an error "relation "Table2" already exists".
This is because tables in SQLEditor don't have a default schema assigned automatically. However when these tables are exported to Postgres, the database system automatically puts them in the 'public' schema.
SQLEditor doesn't currently understand the 'public' schema and it assumes that the tables don't exist (because they don't have the names SQLEditor expects). So SQLEditor tries to create the tables again, but these tables already exist.
The attempt to create another copy of the existing tables causes Postgres to complain with the error message.
This is an bug that will be corrected in a future release of SQLEditor.
Make sure you assign a specific schema to each table. If you don't have a schema use 'public' (without the quotes)
[Top]
This is a bug in the release, it is fixed in 1.4.2b1 and later.
[Download] 3.9 MB DMG file
SQLEditor may create export images in formats other than the selected format. (e.g. an image requested as a jpeg may be a png). This has been corrected in 1.4.1
The release version 1.4 has some problems with parsing certain bits of SQL. A new version of the parser was included in version 1.4.1
This is a change in behaviour. MySQL doesn't accept this combination in newer versions at all and it was causing export problems.
Also the meaning of having both a default value and auto-increment set is unclear.
This applies only to MySQL, all other dialects allow this combination.
Please send us email at support@malcolmhardie.com if you're having trouble with this.
[Top]
There are some issues with the Rails plugins, including not working on PowerPC and not importing correctly.
This is due to a bug with the released beta versions, where the wrong version of the Rails plugin was mistakenly included with the distributed version.
A revised build with the correct Rails plugin will be available shortly.
[Top]
When the canvas is scaled and objects are dragged they are sometimes unexpectedly resized.
This has been fixed for 1.4b10
Creating a field of name ID in a table stops me adding more fields to that table.
If you find that you cannot add fields to a table try looking for a field called ID. Due to a case-sensitivity bug in SQLEditor creating a field of this name will prevent other fields from being added (since the default name is id in lowercase).
What happens is that part of the system was correctly case-sensitive and understood that ID is not the same as id, while the other part wasn't (and prevented the field being added)
This will be fixed in the next release (and is fixed in the current beta).
If you are using 10.3 or 10.4.0-10.4.2 try setting Preferences->"Use new Printing System" to off. There was a bug in the system software in earlier versions of Mac OS X which requires use of the old printing system in SQLEditor.
(This option has been removed in 1.4.x betas and is now set automatically)
[Top]
There are some bugs that have been identified in versions 1.3.4 and 1.3.5 relating to database importing and database exporting.
Problems include the database import or database export windows not opening, or the database import/export action failing. These problems are related to a change made in 1.3.4 to the database import/export window. Unfortunately this change had unexpected consequences which has led to some unexpected problems.
It was hoped that this had been resolved in 1.3.5, however it still seems to be affecting certain configurations.
In 1.3.5 database importing should work correctly, but the are problems with database exporting. One work around is to try the database export again. It appears that repeating the export will typically complete successfully.
A patch is currently being worked on to fix this. (Fixed in 1.3.6)
[Top]
This is due to a bug in the connector loading system that prevents SQLEditor from distinguishing between the original object and the copy. It will be fixed in the next point release.
[Top]
This is a bug in the new schema option for tables and other objects. The value is saved, but isn't reloaded, which causes the value to be empty when the file is loaded in again. If you have a lot of this type of change please save a copy of the file it should work properly in the next beta.
[Top]
Use version 1.2b2 or later (1.2b3 recommended)
[Top]
There is a bug in 1.2b2 that causes this to fail. Upgrade to 1.2b3
[Top]
There is a bug in 1.1b3 and 1.1b4 when trying to export to a database using JDBC, this action always fails. A fix will be provided in a future release.
[Top]
Upgrade to version 1.1.1 which corrects this problem
[Top]
This is a known problem and a fix is being worked on. As a workaround, do not select the indexed checkbox for a field.
[Top]
Try setting the header in File->Document Options to something. There is an error in the code that does printing without headers. This bug has now been fixed. Please download the latest version for the fix
[Top]
Set drop table option (File->Document Options) to false. This is due to an incorrect ordering of drop table instructions and will be fixed as soon as possible
[Top]
To contact us with a support issue please email: