Frequently Asked Questions

General

  1. What all databases are supported?
  2. Which version of java is required ?
  3. I am not able to run the cmd files even though Java 1.5 is installed properly?
  4. I am still facing issues and not able to use dbdesignexcel, where can I get help?
  5. I am interested in this project and want to join your team, what is the process?

DB Configuration

  1. How do I add a new module to group the tables in the excel?
  2. How do I add a new table type to group the tables in the excel?
  3. I don't want to use dbdesignexcel API, how can I rollback the scripts exceuted during installation?

Build

  1. Can I build dbdesign excel in Maven?
  2. I don't see any javadocs, what all API methods are avaliable?

General

What all databases are supported?

Currently only oracle is supported, will include support of other databases soon!

[top]

Which version of java is required ?

Java 1.5 and above.

[top]

I am not able to run the cmd files even though Java 1.5 is installed properly?

Please put jave excecutable in the class path.

[top]

I am still facing issues and not able to use dbdesignexcel, where can I get help?

You can post your problems here.

[top]

I am interested in this project and want to join your team, what is the process?

You send an e-mail to rakesh_nitj@rediffmail.com, you are most welcome!

[top]

DB Configuration

How do I add a new module to group the tables in the excel?

You can add a new entry in DBMM_DB_MODULE_MASTER table and add corrosponding module_id in DBTCM_DB_TABLE_CONFGRN_MASTER table.

[top]

How do I add a new table type to group the tables in the excel?

You can add a new entry in DBTTM_DB_TABLE_TYPE_MASTER table and add corrosponding table_type_id in DBTCM_DB_TABLE_CONFGRN_MASTER table.

[top]

I don't want to use dbdesignexcel API, how can I rollback the scripts exceuted during installation?

You can run Rollback_Scripts.sql to remove all tables, function and procedures.

[top]

Build

Can I build dbdesign excel in Maven?

Pom.xml and source code is provided with the distribution package.

[top]

I don't see any javadocs, what all API methods are avaliable?

Since its a very small API and we didn't have much time, javadocs are not published as of now. We will try and publish javadocs in the near future. Meanwhile you can go through Main.java file where all public methods have been called.

[top]