P4
A DESCRIPTION OF THE REQUEST :
The DatabaseMetaData class returns information about the database in ResultSet objects which is clumsy to use and time consuming to code, not to say it is also error prone on the part of the programmer. Can't sun come up with an API that presents database metadata information to the application in an object oriented way? How hard is it to do? After all, it is only a specification of few interfaces.
The new API should define classes likes Constraint, ForeignKeyConstraints, DataRelation, DataColumn, DataTables etc. to provide metdata information to the developer in a more object oriented way. Also database metadata should return as much information as possible, rerturning unknown in cases where it can't be determined. For example, ResultSetMetaData class in SDK 6, returns whether a column is autoincrement column or not. However, it does not return the autoincrement seed and or step increment. These type of information should be returned to the application programmer whenever they are available. In other words the specification should be complete as much as possible.
JUSTIFICATION :
-The current Database metadata API in JDBC promotes not good programming practices. Providing classes for metadadata information will go a long way resolving these issues.
- Will provide a better object orieneted approch to Database metadata access. Will help builder and GUI tools in Rapid application develeopment.
- Will provide as much complete information as possible about database metadata. Current specification does not provide complete information.
-Will improve consistency between DatabaseMetaData and ResultSetMetaData. Currently ResultSetMetaData returns some information about database columns which are not available from DatabaseMetaData and vice versa.
The DatabaseMetaData class returns information about the database in ResultSet objects which is clumsy to use and time consuming to code, not to say it is also error prone on the part of the programmer. Can't sun come up with an API that presents database metadata information to the application in an object oriented way? How hard is it to do? After all, it is only a specification of few interfaces.
The new API should define classes likes Constraint, ForeignKeyConstraints, DataRelation, DataColumn, DataTables etc. to provide metdata information to the developer in a more object oriented way. Also database metadata should return as much information as possible, rerturning unknown in cases where it can't be determined. For example, ResultSetMetaData class in SDK 6, returns whether a column is autoincrement column or not. However, it does not return the autoincrement seed and or step increment. These type of information should be returned to the application programmer whenever they are available. In other words the specification should be complete as much as possible.
JUSTIFICATION :
-The current Database metadata API in JDBC promotes not good programming practices. Providing classes for metadadata information will go a long way resolving these issues.
- Will provide a better object orieneted approch to Database metadata access. Will help builder and GUI tools in Rapid application develeopment.
- Will provide as much complete information as possible about database metadata. Current specification does not provide complete information.
-Will improve consistency between DatabaseMetaData and ResultSetMetaData. Currently ResultSetMetaData returns some information about database columns which are not available from DatabaseMetaData and vice versa.