Should I avoid naming a SQL table by a ODBC Reserved Keyword when I'm using JDBC?

63 Views Asked by At

As indicated here

The following words are reserved for use in ODBC function calls. These words do not constrain the minimum SQL grammar; however, to ensure compatibility with drivers that support the core SQL grammar, applications should avoid using these keywords.

This list includes the word I'd like to use as a table name, Session, and seems to state pretty clearly that I should avoid its use.

But I don't have any current intention to use ODBC - I'll be using JDBC - and I don't really understand how bad this would be if, down the road, I changed my mind. Can anyone explain in more detail whether naming my table this way truly is a bad idea?

I'm looking more for personal experience than further technical references that don't convey the experience of dealing with the problems that might arise. This looks pretty unpleasant, but how often does it come up that one might switch from JDBC to ODBC realistically?

0

There are 0 best solutions below