[ https://forge.continuent.org/jira/browse/SEQUOIA-972?page=comments#action_14071 ]
Juan Olmedilla commented on SEQUOIA-972: ---------------------------------------- Sorry but the Sequoia versio I reported initially was incorrect, it is 2.10.9, I wanted to delete this issue and clone a new one in version 2.10.9 but I did it wrong and ended up creating issue SEQUOIA-976, and no I cannot close either of them. Can you close 976 and correct versioning in this one? > Table names with quotes in SQL statements are not accepted > ---------------------------------------------------------- > > Key: SEQUOIA-972 > URL: https://forge.continuent.org/jira/browse/SEQUOIA-972 > 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
