Dear all, I am a beginner. My work involves porting an Application from Mysql to Maxdb. I use Hibernate and everything was working fine with MySql. When I tried to setup the same application with MaxDB, initially it showed errors that the table name's used are long. I learnt that the characters should be maximum 32. So,I changed all the table names and columns in the hibernate mapping files and ensured that they are within 32 characters. After changing this, all my tables and columns were created.
Now, when I run a class which basically inserts the default values in the columns in each table, I again get "identifier too long" exception. I could not understand why even after the tables and columns are properly created I am getting this error. Should I also change the name of the mapped classes if they are more than 32 characters long, kindly give me suggestions. I have copied the error from the console and are as follows __________________________________________________________________ ul 26, 2005 1:33:12 PM net.sf.hibernate.util.JDBCExceptionReporterlogExceptions WARNING: SQL Error: -2014, SQLState: 42000 Jul 26, 2005 1:33:12 PM net.sf.hibernate.util.JDBCExceptionReporterlogExceptions SEVERE: [-2014] (at 128): Identifier too long Jul 26, 2005 1:33:12 PM net.sf.hibernate.util.JDBCExceptionReporterlogExceptions WARNING: SQL Error: -2014, SQLState: 42000 Jul 26, 2005 1:33:12 PM net.sf.hibernate.util.JDBCExceptionReporterlogExceptions SEVERE: [-2014] (at 128): Identifier too long Jul 26, 2005 1:33:12 PM net.sf.hibernate.JDBCException <init> SEVERE: could not insert: [ com.ste.rolo.persistence.PPersonRolleZuordnungVersionen#15] com.sap.dbtech.jdbc.exceptions.DatabaseException: [-2014] (at 128): Identifier too long at com.sap.dbtech.jdbc.packet.ReplyPacket.createException(ReplyPacket.java:72) at com.sap.dbtech.jdbc.ConnectionSapDB.throwSQLError(ConnectionSapDB.java:910) at com.sap.dbtech.jdbc.ConnectionSapDB.execute(ConnectionSapDB.java:569) at com.sap.dbtech.jdbc.CallableStatementSapDB.sendCommand( CallableStatementSapDB.java:1736) at com.sap.dbtech.jdbc.StatementSapDB.sendSQL(StatementSapDB.java:778) at com.sap.dbtech.jdbc.CallableStatementSapDB.doParse( CallableStatementSapDB.java:235) at com.sap.dbtech.jdbc.CallableStatementSapDB.constructor( CallableStatementSapDB.java:186) at com.sap.dbtech.jdbc.CallableStatementSapDB.<init>( CallableStatementSapDB.java:88) at com.sap.dbtech.jdbc.ConnectionSapDB.prepareStatement(ConnectionSapDB.java:802) at net.sf.hibernate.impl.BatcherImpl.getPreparedStatement(BatcherImpl.java:249) at net.sf.hibernate.impl.BatcherImpl.prepareStatement(BatcherImpl.java:61) at net.sf.hibernate.impl.BatcherImpl.prepareStatement(BatcherImpl.java:56) at net.sf.hibernate.impl.BatcherImpl.prepareBatchStatement(BatcherImpl.java:109) at net.sf.hibernate.persister.EntityPersister.insert(EntityPersister.java:460) at net.sf.hibernate.persister.EntityPersister.insert(EntityPersister.java:442) at net.sf.hibernate.impl.ScheduledInsertion.execute(ScheduledInsertion.java:29) at net.sf.hibernate.impl.SessionImpl.executeAll(SessionImpl.java:2382) at net.sf.hibernate.impl.SessionImpl.execute(SessionImpl.java:2335) at net.sf.hibernate.impl.SessionImpl.autoFlushIfRequired(SessionImpl.java:1775) at net.sf.hibernate.impl.SessionImpl.getQueries(SessionImpl.java:1536) at net.sf.hibernate.impl.SessionImpl.find(SessionImpl.java:1501) at net.sf.hibernate.impl.SessionImpl.find(SessionImpl.java:1491) at net.sf.hibernate.impl.SessionImpl.find(SessionImpl.java:1483) at com.ste.rolo.realworldobjects.PersonRolleZuordnung.erzeugeNeuePersonRolleZuordnung (PersonRolleZuordnung.java:144) at com.ste.rolo.test.SimpleTest.testRealPersonRolle(SimpleTest.java:1024) at com.ste.rolo.test.SimpleTest.main(SimpleTest.java:147) Jul 26, 2005 1:33:12 PM net.sf.hibernate.impl.SessionImpl execute SEVERE: Could not synchronize database state with session net.sf.hibernate.JDBCException: could not insert: [ com.ste.rolo.persistence.PPersonRolleZuordnungVersionen#15] at net.sf.hibernate.persister.EntityPersister.insert(EntityPersister.java:478) at net.sf.hibernate.persister.EntityPersister.insert(EntityPersister.java:442) at net.sf.hibernate.impl.ScheduledInsertion.execute(ScheduledInsertion.java:29) at net.sf.hibernate.impl.SessionImpl.executeAll(SessionImpl.java:2382) at net.sf.hibernate.impl.SessionImpl.execute(SessionImpl.java:2335) at net.sf.hibernate.impl.SessionImpl.autoFlushIfRequired(SessionImpl.java:1775) at net.sf.hibernate.impl.SessionImpl.getQueries(SessionImpl.java:1536) at net.sf.hibernate.impl.SessionImpl.find(SessionImpl.java:1501) at net.sf.hibernate.impl.SessionImpl.find(SessionImpl.java:1491) at net.sf.hibernate.impl.SessionImpl.find(SessionImpl.java:1483) at com.ste.rolo.realworldobjects.PersonRolleZuordnung.erzeugeNeuePersonRolleZuordnung (PersonRolleZuordnung.java:144) at com.ste.rolo.test.SimpleTest.testRealPersonRolle(SimpleTest.java:1024) at com.ste.rolo.test.SimpleTest.main(SimpleTest.java:147) Caused by: com.sap.dbtech.jdbc.exceptions.DatabaseException: [-2014] (at 128): Identifier too long at com.sap.dbtech.jdbc.packet.ReplyPacket.createException(ReplyPacket.java:72) at com.sap.dbtech.jdbc.ConnectionSapDB.throwSQLError(ConnectionSapDB.java:910) at com.sap.dbtech.jdbc.ConnectionSapDB.execute(ConnectionSapDB.java:569) at com.sap.dbtech.jdbc.CallableStatementSapDB.sendCommand( CallableStatementSapDB.java:1736) at com.sap.dbtech.jdbc.StatementSapDB.sendSQL(StatementSapDB.java:778) at com.sap.dbtech.jdbc.CallableStatementSapDB.doParse( CallableStatementSapDB.java:235) at com.sap.dbtech.jdbc.CallableStatementSapDB.constructor( CallableStatementSapDB.java:186) at com.sap.dbtech.jdbc.CallableStatementSapDB.<init>( CallableStatementSapDB.java:88) at com.sap.dbtech.jdbc.ConnectionSapDB.prepareStatement(ConnectionSapDB.java:802) at net.sf.hibernate.impl.BatcherImpl.getPreparedStatement(BatcherImpl.java:249) at net.sf.hibernate.impl.BatcherImpl.prepareStatement(BatcherImpl.java:61) at net.sf.hibernate.impl.BatcherImpl.prepareStatement(BatcherImpl.java:56) at net.sf.hibernate.impl.BatcherImpl.prepareBatchStatement(BatcherImpl.java:109) at net.sf.hibernate.persister.EntityPersister.insert(EntityPersister.java:460) ... 12 more net.sf.hibernate.JDBCException: could not insert: [ com.ste.rolo.persistence.PPersonRolleZuordnungVersionen#15] at net.sf.hibernate.persister.EntityPersister.insert(EntityPersister.java:478) at net.sf.hibernate.persister.EntityPersister.insert(EntityPersister.java:442) at net.sf.hibernate.impl.ScheduledInsertion.execute(ScheduledInsertion.java:29) at net.sf.hibernate.impl.SessionImpl.executeAll(SessionImpl.java:2382) at net.sf.hibernate.impl.SessionImpl.execute(SessionImpl.java:2335) at net.sf.hibernate.impl.SessionImpl.autoFlushIfRequired(SessionImpl.java:1775) at net.sf.hibernate.impl.SessionImpl.getQueries(SessionImpl.java:1536) at net.sf.hibernate.impl.SessionImpl.find(SessionImpl.java:1501) at net.sf.hibernate.impl.SessionImpl.find(SessionImpl.java:1491) at net.sf.hibernate.impl.SessionImpl.find(SessionImpl.java:1483) at com.ste.rolo.realworldobjects.PersonRolleZuordnung.erzeugeNeuePersonRolleZuordnung (PersonRolleZuordnung.java:144) at com.ste.rolo.test.SimpleTest.testRealPersonRolle(SimpleTest.java:1024) at com.ste.rolo.test.SimpleTest.main(SimpleTest.java:147) Caused by: com.sap.dbtech.jdbc.exceptions.DatabaseException: [-2014] (at 128): Identifier too long at com.sap.dbtech.jdbc.packet.ReplyPacket.createException(ReplyPacket.java:72) at com.sap.dbtech.jdbc.ConnectionSapDB.throwSQLError(ConnectionSapDB.java:910) at com.sap.dbtech.jdbc.ConnectionSapDB.execute(ConnectionSapDB.java:569) at com.sap.dbtech.jdbc.CallableStatementSapDB.sendCommand( CallableStatementSapDB.java:1736) at com.sap.dbtech.jdbc.StatementSapDB.sendSQL(StatementSapDB.java:778) at com.sap.dbtech.jdbc.CallableStatementSapDB.doParse( CallableStatementSapDB.java:235) at com.sap.dbtech.jdbc.CallableStatementSapDB.constructor( CallableStatementSapDB.java:186) at com.sap.dbtech.jdbc.CallableStatementSapDB.<init>( CallableStatementSapDB.java:88) at com.sap.dbtech.jdbc.ConnectionSapDB.prepareStatement(ConnectionSapDB.java:802) at net.sf.hibernate.impl.BatcherImpl.getPreparedStatement(BatcherImpl.java:249) at net.sf.hibernate.impl.BatcherImpl.prepareStatement(BatcherImpl.java:61) at net.sf.hibernate.impl.BatcherImpl.prepareStatement(BatcherImpl.java:56) at net.sf.hibernate.impl.BatcherImpl.prepareBatchStatement(BatcherImpl.java:109) at net.sf.hibernate.persister.EntityPersister.insert(EntityPersister.java:460) ... 12 more ________________________________________________________________________ Thank you very much in advance. Regards, Praveenjothi
