• Open Menu Close Menu
  • Apple
  • Shopping Bag
  • Apple
  • Mac
  • iPad
  • iPhone
  • Watch
  • TV
  • Music
  • Support
  • Search apple.com
  • Shopping Bag

Lists

Open Menu Close Menu
  • Terms and Conditions
  • Lists hosted on this site
  • Email the Postmaster
  • Tips for posting to public mailing lists
Re: DB Columns showing up twice in SQL statement.
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: DB Columns showing up twice in SQL statement.


  • Subject: Re: DB Columns showing up twice in SQL statement.
  • From: Zac Konopa <email@hidden>
  • Date: Wed, 23 Aug 2006 12:18:22 -0700

David and Art,

You guys nailed it right on the head. I had two columns with the same name in the model even though the object attributes had different names. I'd just been so deep into the code I couldn't see the simple errors. Thanks a lot guys.

Zac
On Aug 23, 2006, at 11:49 AM, David Sargent wrote:

I have seen this before when you copy and paste or duplicate an column in EOModeler. EOModeler will change the java property but leave the DB column name the same and you will end up with 2 columns in your model the same.

David

On Aug 23, 2006, at 12:29 PM, Zac Konopa wrote:

Hey all,

I've got another weird one. Oddly enough for me on this one for once I know exactly what's wrong. I'm trying to insert a row into my MySQL db and I get the error you see below:

Application: LeftHandMan
Error: com.webobjects.eoaccess.EOGeneralAdaptorException: EvaluateExpression failed: : Next exception:SQL State:42000 -- error code: 1110 -- msg: Syntax error or access violation message from server: "Column 'videoURLmediumHd' specified twice"
Reason: EvaluateExpression failed: <com.webobjects.jdbcadaptor.MySQLPlugIn$MySQLExpression: "INSERT INTO seminar(descr, couponGraphicFilePath, graphicTwo, videoURLmediumHd, videoURLteaser, startDate, landingTemplate, optMsgA, graphicOne, videoURLmedium, videoURLbig, viewingTemplate, videoURLsmall, thankYou, graphicThree, perUseCost, couponImageURL, graphicOneLinkDescr, moviePoster, graphicTwoLink, filePath, couponGraphic, graphicTwoLinkDescr, graphicTwoFilePath, videoURLmediumHd, videoURLbigHd, endDate, campaignID, creationDate, subhead, graphicThreeLink, graphicThreeLinkDescr, graphicOneLink, optMsgB, videoURLipod, seminarName, graphicThreeFilePath, landingFilePath, template, seminarID, viewingFilePath, moviePosterFilePath, graphicOneFilePath) VALUES (NULL, NULL, NULL, NULL, NULL, ?, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ?, ?, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ?, NULL, NULL, NULL, ?, NULL, NULL, NULL)" withBindings: 1:2006-06-01 00:00:00(startDate), 2:2006-06-01 00:00:00(endDate), 3:9(campaignID), 4:"Test Seminar 1"(seminarName), 5:16(seminarID) >: Next exception:SQL State:42000 -- error code: 1110 -- msg: Syntax error or access violation message from server: "Column 'videoURLmediumHd' specified twice"
Stack trace:
File Line# Method Package
EODatabaseContext.java 4685 _exceptionWithDatabaseContextInformationAdded com.webobjects.eoaccess
EODatabaseContext.java 6393 performChanges com.webobjects.eoaccess
EOObjectStoreCoordinator.java 415 saveChangesInEditingContext com.webobjects.eocontrol
EOEditingContext.java 3226 saveChanges com.webobjects.eocontrol
SeminarManagement.java 311 saveChanges SeminarManagement
NativeMethodAccessorImpl.java NA invoke0 sun.reflect
NativeMethodAccessorImpl.java 39 invoke sun.reflect
DelegatingMethodAccessorImpl.java 25 invoke sun.reflect
Method.java 585 invoke java.lang.reflect
KeyValueCodingProtectedAccessor.java 54 methodValue KeyValueCodingProtectedAccessor
NSKeyValueCoding.java 1160 valueInObject com.webobjects.foundation
NSKeyValueCoding.java 1268 valueForKey com.webobjects.foundation
WOComponent.java 1539 valueForKey com.webobjects.appserver
NSKeyValueCoding.java 498 valueForKey com.webobjects.foundation
NSKeyValueCodingAdditions.java 212 valueForKeyPath com.webobjects.foundation
WOComponent.java 1600 valueForKeyPath com.webobjects.appserver
WOKeyValueAssociation.java 46 valueInComponent com.webobjects.appserver._private
WOHyperlink.java 76 invokeAction com.webobjects.appserver._private
WODynamicGroup.java 101 invokeChildrenAction com.webobjects.appserver._private
WODynamicGroup.java 110 invokeAction com.webobjects.appserver._private
WOConditional.java 55 invokeAction com.webobjects.appserver._private
WODynamicGroup.java 101 invokeChildrenAction com.webobjects.appserver._private
WODynamicGroup.java 110 invokeAction com.webobjects.appserver._private
WOComponent.java 945 invokeAction com.webobjects.appserver
WOSession.java 1168 invokeAction com.webobjects.appserver
WOApplication.java 1375 invokeAction com.webobjects.appserver
WOComponentRequestHandler.java 196 _dispatchWithPreparedPage com.webobjects.appserver._private
WOComponentRequestHandler.java 287 _dispatchWithPreparedSession com.webobjects.appserver._private
WOComponentRequestHandler.java 322 _dispatchWithPreparedApplication com.webobjects.appserver._private
WOComponentRequestHandler.java 358 _handleRequest com.webobjects.appserver._private
WOComponentRequestHandler.java 432 handleRequest com.webobjects.appserver._private
WOApplication.java 1306 dispatchRequest com.webobjects.appserver
WOWorkerThread.java 173 runOnce com.webobjects.appserver._private
WOWorkerThread.java 254 run com.webobjects.appserver._private
Thread.java 613 run java.lang



The nice thing is that it's obvious what's happening. The insert statement has a column specified twice. 'videoURLmediumHd' The problem is that I'm not writing this sql statement. It's being generated by the EO layer when I try to save a new object. I have no idea where to go from here. I've checked the model specification and there is only one field with that name in the model and the db, so I have no idea where EO is getting the erroneous occurrence of the column name. As always any help is greatly appreciated.


Thanks

Zac
_______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list (email@hidden)
Help/Unsubscribe/Update your Subscription:
40holicow.com


This email sent to email@hidden


_______________________________________________ Do not post admin requests to the list. They will be ignored. Webobjects-dev mailing list (email@hidden) Help/Unsubscribe/Update your Subscription: This email sent to email@hidden
References: 
 >DB Columns showing up twice in SQL statement. (From: Zac Konopa <email@hidden>)
 >Re: DB Columns showing up twice in SQL statement. (From: David Sargent <email@hidden>)

  • Prev by Date: Re: DB Columns showing up twice in SQL statement.
  • Next by Date: Re: WO PR
  • Previous by thread: Re: DB Columns showing up twice in SQL statement.
  • Next by thread: Re: DB Columns showing up twice in SQL statement.
  • Index(es):
    • Date
    • Thread