Hi Mike, I'm now using the latest build. Unfortunately, the issue is still there. Below are the properties set in the Application's Properties file.
dbConnectURLGLOBAL = jdbc:postgresql://127.0.0.1/xxxxxxxx dbConnectUserGLOBAL = xxxxxxxx dbConnectPasswordGLOBAL = xxxxxxxxx dbConnectDriverGLOBAL = org.postgresql.Driver dbConnectPluginGLOBAL = Postgresql dbEOPrototypesEntityGLOBAL = EOJDBCPostgresqlPrototypes I also tried to attach the source code and placed break points in the addCreateClauseForAttribute(...) but those don't get hit. Any further hint? Thanks, Farrukh On 2010-09-19, at 12:30 AM, Farrukh Ijaz wrote: > I'm afraid I am using an older version. I will update it tomorrow. Hopefully > this will resolve the issue. > > Thanks, > > Farrukh > > Sent from my iPhone > > On 2010-09-18, at 11:40 PM, Mike Schrag <[email protected]> wrote: > >> are you using an up-to-date postgresql plugin from Wonder? >> >> in PostgresqlExpression: >> public void addCreateClauseForAttribute(EOAttribute attribute) { >> NSDictionary userInfo = attribute.userInfo(); >> Object defaultValue = null; >> if (userInfo != null) { >> defaultValue = >> userInfo.valueForKey("er.extensions.eoattribute.default"); >> } >> String allowsNullClauseForConstraint = >> allowsNullClauseForConstraint(shouldAllowNull(attribute)); >> String sql; >> if (defaultValue == null) { >> sql = >> _NSStringUtilities.concat(this.quoteIdentifier(attribute.columnName()), " ", >> columnTypeStringForAttribute(attribute), " ", allowsNullClauseForConstraint); >> } >> else { >> sql = >> _NSStringUtilities.concat(this.quoteIdentifier(attribute.columnName()), " ", >> columnTypeStringForAttribute(attribute), " DEFAULT ", >> formatValueForAttribute(defaultValue, attribute), " ", >> allowsNullClauseForConstraint); >> } >> appendItemToListString(sql, _listString()); >> } >> >> the "er.extensions.eoattribute.default" is injected into the attribute >> userInfo by migrations ... you can add some debug to this method and see >> what is going on, but i'm pretty sure this works. >> >> ms >> >> On Sep 18, 2010, at 4:37 PM, Farrukh Ijaz wrote: >> >>> Hi Mike, >>> >>> Thanks for your prompt reply. We are using Postgresql and I am talking >>> about the SQL insert statement which gives me error when I execute using >>> Aqua Studio or PSQL tool. >>> >>> Do you think I am missing something? Well this is not a show stopper and I >>> can create an extra version to execute DDL script to set default values. >>> >>> Farrukh >>> >>> Sent from my iPhone >>> >>> On 2010-09-18, at 11:28 PM, Mike Schrag <[email protected]> wrote: >>> >>>> default values is not supported by eof directly ... it's up to your >>>> database plugin to support wonder's extension for this to work. currently >>>> i believe only frontbase and postgresql migrations support this. >>>> >>>> ms >>>> >>>> On Sep 18, 2010, at 4:17 PM, Farrukh Ijaz wrote: >>>> >>>>> Hi, >>>>> >>>>> I've noticed that MIgrations code does not respect the default values >>>>> specified. E.g. Following code creates a database table called CALENDAR. >>>>> >>>>> ERXMigrationTable calendarTable = database.newTableNamed("CALENDAR"); >>>>> calendarTable.newStringColumn("CAL_DESC", 512, true); >>>>> calendarTable.newStringColumn("CAL_NAME", 64, false); >>>>> calendarTable.newIntegerColumn("IS_PUBLIC", false, 0); >>>>> calendarTable.newIntegerColumn("OID", false); >>>>> calendarTable.create(); >>>>> calendarTable.setPrimaryKey("OID"); >>>>> >>>>> Technically this should set the column to set the default value to 0 for >>>>> IS_PUBLIC column whenever a record is inserted in this table. But this is >>>>> not the case, inspecting the table structure tells there is no default >>>>> value set for this column and inserting a new record in this table >>>>> without explicitly specifying the is_public value to 0, it gives Not Null >>>>> sql exception. >>>>> >>>>> Any comments? >>>>> >>>>> Farrukh >>>>> _______________________________________________ >>>>> Do not post admin requests to the list. They will be ignored. >>>>> Webobjects-dev mailing list ([email protected]) >>>>> Help/Unsubscribe/Update your Subscription: >>>>> http://lists.apple.com/mailman/options/webobjects-dev/mschrag%40pobox.com >>>>> >>>>> This email sent to [email protected] >>>> >>>> _______________________________________________ >>>> Do not post admin requests to the list. They will be ignored. >>>> Webobjects-dev mailing list ([email protected]) >>>> Help/Unsubscribe/Update your Subscription: >>>> http://lists.apple.com/mailman/options/webobjects-dev/farrukh.ijaz%40fuegodigitalmedia.com >>>> >>>> This email sent to [email protected] >> >> _______________________________________________ >> Do not post admin requests to the list. They will be ignored. >> Webobjects-dev mailing list ([email protected]) >> Help/Unsubscribe/Update your Subscription: >> http://lists.apple.com/mailman/options/webobjects-dev/farrukh.ijaz%40fuegodigitalmedia.com >> >> This email sent to [email protected] > _______________________________________________ > Do not post admin requests to the list. They will be ignored. > Webobjects-dev mailing list ([email protected]) > Help/Unsubscribe/Update your Subscription: > http://lists.apple.com/mailman/options/webobjects-dev/farrukh.ijaz%40fuegodigitalmedia.com > > This email sent to [email protected]
_______________________________________________ Do not post admin requests to the list. They will be ignored. Webobjects-dev mailing list ([email protected]) Help/Unsubscribe/Update your Subscription: http://lists.apple.com/mailman/options/webobjects-dev/archive%40mail-archive.com This email sent to [email protected]
