Get a specific Database Information.

[dmjpro]

Some times a tables wrapped with " or sometimes with ` character.
Could I get those information from DatabaseMetadat a.
I could get the information whether the table wrapped with " from DatabaseMetaDat a.supportsMixed CaseQuotedIdent ifiers.
But whether it's with ` how could I get it?
One more thing if I do DatabaseMetaDat a.supportsMixed CaseQuotedIdent ifiers 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 DatabaseMetadat a.
I could get the information whether the table wrapped with " from DatabaseMetaDat a.supportsMixed CaseQuotedIdent ifiers.
But whether it's with ` how could I get it?
One more thing if I do DatabaseMetaDat a.supportsMixed CaseQuotedIdent ifiers 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 DatabaseMetaDat a.getIndentifie rQuoteString.

Debasis Jana