On Wed, 27 Jun 2012 10:47:14 -0400, "Leyne, Sean" <s...@broadviewsoftware.com> wrote: >> > -----Original Message----- >> > From: Leyne, Sean [mailto:s...@broadviewsoftware.com] >> > Sent: Viernes, 22 de Junio de 2012 17:18 >> > >> > > They have a column named TIMESTAMP which is a reserved word >> > in Firebird, >> > > and supposedly in many other RDBMS too (and in the SQL >> > standard as well). >> > > What the hell they are doing? >> > >> > I have logged a case on the Jira tracker regarding this issue. >> > >> > https://jira.atlassian.com/browse/JRA-28657 >> >> I hope you'll have some success, Sean. >> When I logged issues, they invariably defended their shortcomings. > > Got a reply which follows this pattern, they missed the larger point I was > trying to make. You can see their reply and my retort for yourself.
I do have to say that I found your ticket to be very sparse in actual details of the problem. > It would appear that the project may need to migrate to another solution, > unless we can 'encourage' a friendlier attitude from Atlassian/JIRA. 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. Mark ------------------------------------------------------------------------------ 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
