• 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: Migrations and OpenBase
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: Migrations and OpenBase


  • Subject: Re: Migrations and OpenBase
  • From: David Avendasora <email@hidden>
  • Date: Fri, 17 Oct 2008 06:03:20 -0400

Gus,

Can you turn on EOAdaptor Debugging so you can see what the actual SQL being sent to the DB is? Do this by creating the following property in your Resources/Properties file:

log4j.logger.er.transaction.adaptor.EOAdaptorDebugEnabled=DEBUG

The log you sent shows two conflicting things:

Oct 16 18:32:57 ControlHorarios[1250] (ERXJDBCUtilities.java:588) INFO  er.extensions.jdbc.ERXJDBCUtilities  - Executing ALTER TABLE EMPLOYEETURN ADD CONSTRAINT EMPLOYEETURN_EMPLOYEE_ID_id_FK FOREIGN KEY (EMPLOYEE_ID) REFERENCES EMPLOYEE (id)

and

2008-10-16 18:32:57 -0500: &ScheduleControl:SQL ERROR - [position 24, near 'ADD' in 'PLOYEETURN ADD CONSTRAINT'] alter table command expected but not found.{
    NSColor = NSCalibratedRGBColorSpace 0 0 1 1;
}

You can see that the SQL the migration is trying to send to the table looks properly formed (I am not an OpenBase developer) but the error says that it isn't, so we need to see the actual SQL sent by the EOAdaptor.

Dave
 _______________________________________________
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

  • Follow-Ups:
    • Re: Migrations and OpenBase
      • From: Darryl Snover <email@hidden>
References: 
 >Migrations and OpenBase (From: WebObjects <email@hidden>)

  • Prev by Date: Re: EO Caching with global id 'fetching'
  • Next by Date: Re: NSTimestamp.timestampByAddingGregorianUnits considered harmful
  • Previous by thread: Re: Migrations and OpenBase
  • Next by thread: Re: Migrations and OpenBase
  • Index(es):
    • Date
    • Thread