[ https://forge.continuent.org/jira/browse/SEQUOIA-976?page=comments#action_14072 ]
Juan Olmedilla commented on SEQUOIA-976: ---------------------------------------- This issue should be closed. SEQUOIA-972 is the original one, but the real Sequoia version for which I was reporting the issue is 2.10.9. Thanks. > Table names with quotes in SQL statements are not accepted > ---------------------------------------------------------- > > Key: SEQUOIA-976 > URL: https://forge.continuent.org/jira/browse/SEQUOIA-976 > Project: Sequoia > Type: Bug > Components: JDBC Driver > Versions: Sequoia 2.9 > Environment: Sequoia 2.9.10 > PostgreSQL 8.1.9 > Java 1.5 > Jbos 4.0.5 > Suse Enterprise Server 10 > Reporter: Juan Olmedilla > > > I have a table named "User" in my schema, my application accesses it without > any problems when using direct access to PostgreSQL through its own jdbc > driver. I have taken care to use quotes around the table name in the EJB3 > annotation. In the EJB3 annotation I use single quotes which are translated > to double quotes to the jdbc driver. The word "user" is reserved in > PostgreSQL and that's why I use quotes for "User" in all SQL statements > (well, the EJB3 translation does for me). > All works correct until I use Sequoia, which throws the following exception: > Caused by: java.sql.BatchUpdateException: Batch failed for request 0: insert > into "User" (name, dni, lastName, telephoneNumber, active, principal_id, id) > values (?, ?, ?, ?, ?, ?, ?) > (org.continuent.sequoia.common.exceptions.driver.DriverSQLException: Message > of cause: Unknown table '"user"' in this INSERT statement: 'insert into > "User" (name, dni, lastName, telephoneNumber, active, principal_id, id) > values (?, ?, ?, ?, ?, ?, ?)') > at > org.continuent.sequoia.driver.PreparedStatement.executeBatch(PreparedStatement.java:1023) > at > org.jboss.resource.adapter.jdbc.WrappedStatement.executeBatch(WrappedStatement.java:519) > at > org.hibernate.jdbc.BatchingBatcher.doExecuteBatch(BatchingBatcher.java:48) > at > org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:242) > ... 76 more -- This message is automatically generated by JIRA. - If you think it was sent incorrectly contact one of the administrators: https://forge.continuent.org/jira/secure/Administrators.jspa - For more information on JIRA, see: http://www.atlassian.com/software/jira _______________________________________________ Sequoia mailing list [email protected] https://forge.continuent.org/mailman/listinfo/sequoia
