Hi, I get SQL error in exporting db schema when, it came out with the following error message: >>>executing: ALTER TABLE TimeSheetEntryEJB ADD CONSTRAINT TimeSheetEntryEJBPK PRIMARY KEY ( entryId) >>>>Exception occurred: COM.ibm.db2.jdbc.DB2Exception: [IBM][CLI Driver][DB2/NT] SQL0107N The name "TIMESHEETENTRYEJBPK" is too long. The maximum length is "18". SQLSTATE=42622 SQL exception Occurred: COM.ibm.db2.jdbc.DB2Exception: [IBM][CLI Driver][DB2/NT] SQL0107N The name "TIMESHEETENTRYEJBPK" is too long. The maximum length is "18". SQLSTATE=42622 How would I solved this problem. By the way this is the sample from Kyla Brown's book in Chapter 19. I'm unsure what do to do to solve the problem, as I believed I might have left some steps or needs some modification. Any help would be greatly appreciated. Thanks. Cheers
Kyle Brown
author
Ranch Hand
Joined: Aug 10, 2001
Posts: 3878
posted
0
Actually, I'm reasonably sure that I did cover this somewhere in the book... All you have to do is in the VAJ Schema editor set a new physical name for those entries that it complains are too long. For instance, instead of using TIMESHEETENTRYEJBPK as the physical name for this primary key constraint, use TSEntryPK. The only thing you have to do then is export the schema to the database and then regenerate the deployment classes inside of VAJ. Kyle ------------------ Kyle Brown, Author of Enterprise Java (tm) Programming with IBM Websphere See my homepage at http://members.aol.com/kgb1001001 for other WebSphere information.
0
