Re: Why JDBC cannot be used to select column types for all SQL server

Without using heavy tools like Hibernate, i wanted to export some data
to "any SQL server". So if i have text data of fixed size, using only
JDBC, i should use java.sql.DatabaseMetaData.getTypeInfo(), and keep the
 first typename corresponding to java.sql.Types.VARCHAR. Then i will do:

create table (
...
  columnName typename(maxSize),
...
)

But the same code didn't work for mysql and postgresql.

I would need this method in jdbc:

/**
 * @param maxSize if > 0, strings will be of maximum length maxSize
 */
getLimitedTextColumnDataType(int maxSize);

This method would return "varchar(200)" without having to read the SQL
server documentation... What is called a generic way i assume.