Frequently Asked Questions

Registration Issues

Login on Avangate website using your email address and 'forgot password'. There you have full access on your data.
Login on Avangate website using your email address and 'forgot password'. There you have full access on your data, can purchase renewal and edit your profile.
Login on Avangate website using your email address and 'forgot password'. There you have full access on your data, can purchase renewal and edit your profile.
Login on Avangate website using your email address and 'forgot password'. Follow Avangate documentation. Requirements:
  1. Subscriptions must be associated with different products purchased from the same vendor.
  2. Subscriptions must be associated with different products purchased by the same customer (defined through Avangate Customer Reference (ID) and/or AV_CUSTOMERID External Customer ID). This means that the subscriptions need to have been aggregated under the same customer. Guidance is available here: Attribute a subscription to an existing Customer account using CUSTOMERID in the buy link and here: Place orders using the Avangate Customer Reference (ID) AV_CUSTOMERID.
  3. Subscriptions must be active or in the grace period (status Past Due), but not expired or disabled.
  4. The auto-renewal system needs to be enabled for subscriptions.
  5. Subscription expiration/renewal dates are aligned chronologically. This means that the expiration/renewal date of the subscription for which the co-termination process is generated needs to precede the expiration/renewal date of the subscription to which it's aligned, and that will act as the co-termination date.
  6. Subscriptions need to share the same billing cycle. One month subscriptions can be aligned only with other subscriptions with monthly billing cycles. One year subscriptions can be aligned only with other subscriptions that are set to renew yearly.
  7. Co-termination is available only for subscriptions associated to products for which a credit/debit card was used for the initial purchase. Supported cards: VISA, MasterCard, AMEX and Discovery.
  8. Transactions for the initial orders which generated the subscriptions must have been done using the same currency.
  9. Subscriptions for which billing involves both a base, recurring cost and a dynamic expense component (usage) incurred for metered resources consumed cannot be aligned with other subscriptions.
  10. This feature does not work for imported subscriptions.

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