On Wed, 27 Jun 2012 17:19:34 +0200, Mark Rotteveel <m...@lawinegevaar.nl> wrote: > It would be interesting to see what other JDBC drivers report for the the > DatabaseMetaData.getSQLKeywords() method. Jaybird explicitly does not > include TIMESTAMP as that should already be a SQL-92 (and/or SQL:2003) > reserved word, and the JDBC spec requires : "Retrieves a comma-separated > list of all of this database's SQL keywords that are NOT also SQL:2003 > keywords.". Maybe JIRA simply looks at the result of this method and does > no further reserved words checking for deciding on quoting or not. If other > vendors do include SQL-2003 reserved words, Jaybird could do so as well. > > You could also look at manually changing the > /WEB-INF/classes/entitydefs/entitymodel.xml file to see if you can solve > the problem that way (see 'Configuring the Entity Engine for JIRA' in the > JIRA documentation.
Other interesting thing, the OfBiz Entity Engine used by JIRA does seem to check for reserved words, and it does check for TIMESTAMP: https://fisheye6.atlassian.com/browse/ofbiz/trunk/framework/entity/src/org/ofbiz/entity/model/ModelEntityChecker.java?r=1335927 ------------------------------------------------------------------------------ Live Security Virtual Conference Exclusive live event will cover all the ways today's security and threat landscape has changed and how IT managers can respond. Discussions will include endpoint security, mobile security and the latest in malware threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/ Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
