praveen jothi wrote: > > 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.
This error is produced by the kernel. The kernel does not know your class-names. Therefore mapping them will not help. Please provide a vtrace according to http://sapdb.2scale.net/moin.cgi/VTrace but change default to order in step 1 and 6. Then we will see the statements sent via hibernate to the kernel causing the trouble. Elke SAP Labs Berlin > > 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:9 10 > ) > > 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.jav a: > 802) > > at > net.sf.hibernate.impl.BatcherImpl.getPreparedStatement(BatcherImpl.java: 24 > 9) > > 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 :1 > 09) > > at > net.sf.hibernate.persister.EntityPersister.insert(EntityPersister.java:4 60 > ) > > at > net.sf.hibernate.persister.EntityPersister.insert(EntityPersister.java:4 42 > ) > > at > net.sf.hibernate.impl.ScheduledInsertion.execute(ScheduledInsertion.java :2 > 9) > > 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:1 77 > 5) > > 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.erzeugeNeuePersonRoll eZ > uordnung > (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:4 78 > ) > > at > net.sf.hibernate.persister.EntityPersister.insert(EntityPersister.java:4 42 > ) > > at > net.sf.hibernate.impl.ScheduledInsertion.execute(ScheduledInsertion.java :2 > 9) > > 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:1 77 > 5) > > 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.erzeugeNeuePersonRoll eZ > uordnung > (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:9 10 > ) > > 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.jav a: > 802) > > at > net.sf.hibernate.impl.BatcherImpl.getPreparedStatement(BatcherImpl.java: 24 > 9) > > 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 :1 > 09) > > at > net.sf.hibernate.persister.EntityPersister.insert(EntityPersister.java:4 60 > ) > > ... 12 more > net.sf.hibernate.JDBCException: could not insert: [ > com.ste.rolo.persistence.PPersonRolleZuordnungVersionen#15] > at > net.sf.hibernate.persister.EntityPersister.insert(EntityPersister.java:4 78 > ) > > at > net.sf.hibernate.persister.EntityPersister.insert(EntityPersister.java:4 42 > ) > > at > net.sf.hibernate.impl.ScheduledInsertion.execute(ScheduledInsertion.java :2 > 9) > > 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:1 77 > 5) > > 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.erzeugeNeuePersonRoll eZ > uordnung > (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:9 10 > ) > > 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.jav a: > 802) > > at > net.sf.hibernate.impl.BatcherImpl.getPreparedStatement(BatcherImpl.java: 24 > 9) > > 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 :1 > 09) > > at > net.sf.hibernate.persister.EntityPersister.insert(EntityPersister.java:4 60 > ) > > ... 12 more > > ________________________________________________________________________ > > Thank you very much in advance. > > Regards, > Praveenjothi -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
