Retrieves whether identifier is a simple SQL identifier.
Parameters:
identifier | | a SQL identifier |
Returns: true if a simple SQL identifier, false otherwise
Exceptions:
NullPointerException | | if identifier is null |
SQLException | | if a database access error occurs |
Since: 9
@implSpec The default implementation uses the following criteria to
determine a valid simple SQL identifier:
- The string is not enclosed in double quotes
- The first character is an alphabetic character from a through z, or
from A through Z
- The string only contains alphanumeric characters or the character
"_"
- The string is between 1 and 128 characters in length inclusive
Examples of the conversion:
| identifier |
Simple Identifier |
| Hello |
true |
| G'Day |
false |
| "Bruce Wayne" |
false |
| GoodDay$ |
false |
| Hello"World |
false |
| "Hello"World" |
false |
@implNote JDBC driver implementations may need to provide their own
implementation of this method in order to meet the requirements of the
underlying datasource.