Daer Mr.Schöder and Elke,
 Thank you very much and now everything is fine. The mistake was exactly the 
same what Mr.Schöder suspected. 
 Thanking you again,
 Regards,
Praveenjothi

 On 7/27/05, Schroeder, Alexander <[EMAIL PROTECTED]> wrote: 
> 
> Hello Praveen, 
>  it seems that you mixed up your code, or missed a statement. You create 
> the table with the shorter name:
>  [EMAIL PROTECTED] (create table 
> person_rolle_zuordnung_versionen (*pn_rolle_zuordng_vn_id *FIXED(19,0) not 
> null, aenderer FIXED(19,0) not null, aenderungszeitpunkt TIMESTAMP not null, 
> version_nummer INT not null, aenderungsaktion CHAR(1) not null, 
> personalnummer FIXED(19,0) null, primary key (pn_rolle_zuordng_vn_id)))
> => 0
> but access it the on the insert operation with a statement that seems to 
> be the 'old' (i.e. long) name of that column.
>  [EMAIL PROTECTED] (insert into 
> person_rolle_zuordnung_versionen (aenderer, aenderungszeitpunkt, 
> version_nummer, aenderungsaktion, personalnummer, *
> person_rolle_zuordnung_versionen_id*) values (?, ?, ?, ?, ?, ?))
> <-!
> Timestamp: 2005-07-27 09:36:49.906
> com.sap.dbtech.jdbc.exceptions.DatabaseException: [-2014] (at 128): 
> Identifier too long
> The identifier person_rolle_zuordnung_versionen_id is apparantly too long,
> so please look into your application what went wrong here. (BTW, the 
> position 128 is correctly pointing to the beginning of the offending, and 
> too long column in this SQL statement).
>  Regards
> Alexander Schröder
> SAP DB, SAP Labs Berlin
>  
>  ------------------------------
> *From:* praveen jothi [mailto:[EMAIL PROTECTED] 
> *Sent:* Wednesday, July 27, 2005 9:51 AM
> *To:* Schroeder, Alexander
> *Subject:* Re: porting an application from MySql to MaxDB
> 
>   Dear Mr.Schröder and colleagues,
>  I am attaching the jdbc trace. I see the statement at the end which I 
> think is causing the problem, but I dont understand when it is 32 characters 
> long, which is the maximum, why it still says "identifier too long". The 
> point here is, I also renamed that identifier for a much smaller version, 
> but still I get the same error. 
>  Please give me your suggestions.
>  Thank you very much.
>  Regards,
> Praveenjothi
> 
>  On 7/27/05, Schroeder, Alexander <[EMAIL PROTECTED]> wrote: 
> > 
> > Hello Praveen,
> > 
> > could you run the application with JDBC trace enabled, and
> > send the trace? See http://sapdb.2scale.net/moin.cgi/JdbcTrace
> > on how to create one. So, the offending SQL statement can
> > probably be seen in the trace.
> > 
> > Regards
> > Alexander Schröder
> > SAP DB, SAP Labs Berlin
> > 
> > > -----Original Message----- 
> > > From: praveen jothi [mailto:[EMAIL PROTECTED]
> > > Sent: Wednesday, July 27, 2005 7:16 AM
> > > To: maxdb@lists.mysql.com
> > > Subject: porting an application from MySql to MaxDB
> > >
> > > 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 (ReplyPa
> > > cket.java:72)
> > >
> > > at
> > > com.sap.dbtech.jdbc.ConnectionSapDB.throwSQLError(ConnectionSa
> > > pDB.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(Connectio
> > > nSapDB.java:802)
> > >
> > > at
> > > net.sf.hibernate.impl.BatcherImpl.getPreparedStatement (Batcher
> > > Impl.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(Batche
> > > rImpl.java:109)
> > >
> > > at
> > > net.sf.hibernate.persister.EntityPersister.insert(EntityPersis
> > > ter.java:460)
> > >
> > > at
> > > net.sf.hibernate.persister.EntityPersister.insert(EntityPersis
> > > ter.java:442)
> > >
> > > at
> > > net.sf.hibernate.impl.ScheduledInsertion.execute(ScheduledInse
> > > rtion.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 (SessionI
> > > mpl.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.erzeugeNeue
> > > PersonRolleZuordnung
> > > (PersonRolleZuordnung.java :144)
> > > at
> > > com.ste.rolo.test.SimpleTest.testRealPersonRolle(SimpleTest.ja
> > > va: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(EntityPersis
> > > ter.java:478)
> > >
> > > at
> > > net.sf.hibernate.persister.EntityPersister.insert(EntityPersis
> > > ter.java:442)
> > >
> > > at
> > > net.sf.hibernate.impl.ScheduledInsertion.execute(ScheduledInse
> > > rtion.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(SessionI
> > > mpl.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.erzeugeNeue
> > > PersonRolleZuordnung
> > > (PersonRolleZuordnung.java:144)
> > > at
> > > com.ste.rolo.test.SimpleTest.testRealPersonRolle(SimpleTest.ja 
> > > va: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(ReplyPa
> > > cket.java:72)
> > >
> > > at
> > > com.sap.dbtech.jdbc.ConnectionSapDB.throwSQLError(ConnectionSa
> > > pDB.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(Connectio
> > > nSapDB.java:802)
> > >
> > > at
> > > net.sf.hibernate.impl.BatcherImpl.getPreparedStatement(Batcher
> > > Impl.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(Batche
> > > rImpl.java:109)
> > >
> > > at 
> > > net.sf.hibernate.persister.EntityPersister.insert(EntityPersis
> > > ter.java:460)
> > >
> > > ... 12 more
> > > net.sf.hibernate.JDBCException: could not insert: [
> > > com.ste.rolo.persistence.PPersonRolleZuordnungVersionen#15 ]
> > > at
> > > net.sf.hibernate.persister.EntityPersister.insert(EntityPersis
> > > ter.java:478)
> > >
> > > at
> > > net.sf.hibernate.persister.EntityPersister.insert(EntityPersis
> > > ter.java:442)
> > >
> > > at
> > > net.sf.hibernate.impl.ScheduledInsertion.execute(ScheduledInse
> > > rtion.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(SessionI
> > > mpl.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.erzeugeNeue
> > > PersonRolleZuordnung
> > > (PersonRolleZuordnung.java:144)
> > > at
> > > com.ste.rolo.test.SimpleTest.testRealPersonRolle(SimpleTest.ja 
> > > va: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(ReplyPa
> > > cket.java:72)
> > >
> > > at
> > > com.sap.dbtech.jdbc.ConnectionSapDB.throwSQLError(ConnectionSa
> > > pDB.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(Connectio
> > > nSapDB.java:802)
> > >
> > > at
> > > net.sf.hibernate.impl.BatcherImpl.getPreparedStatement(Batcher
> > > Impl.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(Batche
> > > rImpl.java:109)
> > >
> > > at 
> > > net.sf.hibernate.persister.EntityPersister.insert(EntityPersis
> > > ter.java:460)
> > >
> > > ... 12 more
> > >
> > > ______________________________________________________________
> > > __________
> > >
> > > Thank you very much in advance.
> > >
> > > Regards,
> > > Praveenjothi
> > >
> > 
> 
>

Reply via email to