Get a specific Database Information.

[dmjpro]

Some times a tables wrapped with " or sometimes with ` character.
Could I get those information from DatabaseMetadata.
I could get the information whether the table wrapped with " from DatabaseMetaData.supportsMixedCaseQuotedIdentifier s.
But whether it's with ` how could I get it?
One more thing if I do DatabaseMetaData.supportsMixedCaseQuotedIdentifier s with PostgreSQL the it returns true so i do wrap it with " but the thing is if i do the same for MySQL then i get true too but if I wrap with " then SQL grammer erros come.
So how could I get those information what Nebeans does well.
What Netbeans does that with Java APIs if NetBeans can then why not we?

One more thing in MySQL .what happens some data in date field as '0000-00-00' when Java APIs finds this type of data in Date field then it flashes an error .... the data '0000-00-00' can't be represented as java.sql.Date.

Please help me out.

Debasis Jana.

[dmjpro]

Some times a tables wrapped with " or sometimes with ` character.
Could I get those information from DatabaseMetadata.
I could get the information whether the table wrapped with " from DatabaseMetaData.supportsMixedCaseQuotedIdentifier s.
But whether it's with ` how could I get it?
One more thing if I do DatabaseMetaData.supportsMixedCaseQuotedIdentifier s with PostgreSQL the it returns true so i do wrap it with " but the thing is if i do the same for MySQL then i get true too but if I wrap with " then SQL grammer erros come.
So how could I get those information what Nebeans does well.
What Netbeans does that with Java APIs if NetBeans can then why not we?

One more thing in MySQL .what happens some data in date field as '0000-00-00' when Java APIs finds this type of data in Date field then it flashes an error .... the data '0000-00-00' can't be represented as java.sql.Date.

Please help me out.

Debasis Jana.

Guys I did that using DatabaseMetaData.getIndentifierQuoteString.

Debasis Jana