Frequently Asked Questions

Registration Issues

Login on customer area using your email address. Here you have full access on your data.
Login on customer area using your email address. Here you have full access on your data, can purchase renewal and edit your profile.
Login on customer area using your email address. Here you have full access on your data, can purchase renewal and edit your profile.
Login into your account. Then you may follow this steps. Near each subscription listed in the control panel you have an option to 'Align invoice details'. Just follow this link. In case of issues please contact the direct online support in the interface.

Database Connectivity & Schema Synchronization

Check the application help for the database you connect. The problem can be in database configuration, firewall, etc. Contact support for help.
We apply the modification as it is in the database and store it in DbSchema as well. The database may slightly re-write it, and by next refresh is reported as being different. As example default values using sequences in Postgres may look different after refresh. We cannot influence this and you should refresh the diff in DbSchema.
DbSchema knows only some predefined data types ( configured in Connection / Rdbms Settings ) plus the one which are used in the current database schema. Based on the forms and reports engine we are currently developing, we build a management console for each database. This will allow to manage the user defined data types. The management console will be open source software.
True. If you refresh the schema you will not want to loose your comment in DbSchema. This difference will show only when you do a schmea compare from the menu.
Foreign key support 'on delete' and 'on update' actions, which specifies what should be done when a record from the primary key table is deleted. By default if a children record exists, an error is shown ( this is on delete no action ). 'On delete cascade' will drop the children records when the pk record is removed. 'On delete restrict' is for the most of the databases similar with 'on delete no action'.
DbSchema use JDBC driver methods to reverse engineer the schema from the database. Procedures, triggers and functions are loaded using configurable SQL queries listed in Connection / Rdbms Settings dialog. They are the best queries we could found searching the internet. If you have any clue how the queries can be improved please write us.

Mac OS Issues

Please check this post. There are explained few different ways of linking the Java in the Mac OS. The most important is this :
Execute in terminal
whereis java
will return /usr/bin/java which in turn points to /System/Library/Frameworks/JavaVM.framework/Versions/A/Commands/java, which is Apple's 1.6 version.

So, if you want to use the new java version, replace the /usr/bin/java symlink so that it points to /Library/Internet\ Plug-Ins/JavaAppletPlugin.plugin/Contents/Home/bin/java instead:

sudo rm /usr/bin/java
sudo ln -s /Library/Internet\ Plug-Ins/JavaAppletPlugin.plugin/Contents/Home/bin/java /usr/bin

PostgreSql

Table inherit allows defining one table based on the definition of another table. In practice they are two distinct tables and JDBC will report the structure of each table distinct, without inheritance. You may create one table in DbSchema, and creating the second table specify the inheritance in the table storage panel. On refresh the diagram will get all columns, as it is physically in the database . Since we trust on JDBC implementation which does not consider the inheritance, there is no way for us to support it deeper.
Enter in the column default value something like "nextval('products_product_no_seq')". Database does not allocate a sequence to a certain column, therefore DbSchema won't do it as well. After a refresh you will see the default value slightly different in the database - Postgres does rewrite its definition. You have just to apply the difference in the local project.
In the connector editor choose to enter a custom URL. There you can enter something like "jdbc:postgresql://localhost/test?user=fred&password=secret&ssl=true". See more samples here.

Oracle

No, there is no difference in DbSchema. The EE adds features to replication, online index rebuild, etc. in Oracle, which are mostly admin features. DbSchema is compatible with both versions.

SqlServer

Kerberos can be configured outside DbSchema, something like here. Then edit dbschema.bat to include the library as in documentation and start it using dbschema.bat.

LookAndFeel

Our interface is based on Jide.com libraries. Jide announced Nimbus is not compatible with their infrastructure.

Navigation