Re: optimization/indexing
Either some crazy joins with other tables or something you are not aware of is going on. 7K rows is tiny. definitely ... this demands sql debug to be turned on ... my money is on your console streaming sql faster than you can read. ms ___ Do not post admin requests to the list. They will be ignored. Webobjects-dev mailing list (Webobjects-dev@lists.apple.com) Help/Unsubscribe/Update your Subscription: http://lists.apple.com/mailman/options/webobjects-dev/archive%40mail-archive.com This email sent to arch...@mail-archive.com
Re: optimization/indexing
Either some crazy joins with other tables or something you are not aware of is going on. 7K rows is tiny. Chuck On Dec 16, 2008, at 9:07 PM, Jeff Schmitz wrote: hmm, I'm not doing an insert at all, just a read. Kind of thought there must be something else too though (with my limited experience) but figured indexing would be a good thing to do regardless before digging into debugging the real culprit here. Jeff On Dec 16, 2008, at 11:01 PM, Mike Schrag wrote: More than a minute to insert to a 7000 row table? Do other operations on the same DB take an appropriate amount of time? If not I would start looking at DNS or other connectivity issues. I can't fathom a FB DB sucking at that level. this was my first thought, too ... something else is going on here. I suspect if sql debug was turned on, you'd see tons of faulting going on that you didn't realize and that the insert itself is not actually the slow thing. ms ___ Do not post admin requests to the list. They will be ignored. Webobjects-dev mailing list (Webobjects-dev@lists.apple.com) Help/Unsubscribe/Update your Subscription: http://lists.apple.com/mailman/options/webobjects-dev/jeffandmonica%40mac.com This email sent to jeffandmon...@mac.com ___ Do not post admin requests to the list. They will be ignored. Webobjects-dev mailing list (Webobjects-dev@lists.apple.com) Help/Unsubscribe/Update your Subscription: http://lists.apple.com/mailman/options/webobjects-dev/chill%40global-village.net This email sent to ch...@global-village.net -- Chuck Hill Senior Consultant / VP Development Practical WebObjects - for developers who want to increase their overall knowledge of WebObjects or who are trying to solve specific problems. http://www.global-village.net/products/practical_webobjects ___ Do not post admin requests to the list. They will be ignored. Webobjects-dev mailing list (Webobjects-dev@lists.apple.com) Help/Unsubscribe/Update your Subscription: http://lists.apple.com/mailman/options/webobjects-dev/archive%40mail-archive.com This email sent to arch...@mail-archive.com
Re: optimization/indexing
hmm, I'm not doing an insert at all, just a read. Kind of thought there must be something else too though (with my limited experience) but figured indexing would be a good thing to do regardless before digging into debugging the real culprit here. Jeff On Dec 16, 2008, at 11:01 PM, Mike Schrag wrote: More than a minute to insert to a 7000 row table? Do other operations on the same DB take an appropriate amount of time? If not I would start looking at DNS or other connectivity issues. I can't fathom a FB DB sucking at that level. this was my first thought, too ... something else is going on here. I suspect if sql debug was turned on, you'd see tons of faulting going on that you didn't realize and that the insert itself is not actually the slow thing. ms ___ Do not post admin requests to the list. They will be ignored. Webobjects-dev mailing list (Webobjects-dev@lists.apple.com) Help/Unsubscribe/Update your Subscription: http://lists.apple.com/mailman/options/webobjects-dev/jeffandmonica%40mac.com This email sent to jeffandmon...@mac.com ___ Do not post admin requests to the list. They will be ignored. Webobjects-dev mailing list (Webobjects-dev@lists.apple.com) Help/Unsubscribe/Update your Subscription: http://lists.apple.com/mailman/options/webobjects-dev/archive%40mail-archive.com This email sent to arch...@mail-archive.com
Re: optimization/indexing
More than a minute to insert to a 7000 row table? Do other operations on the same DB take an appropriate amount of time? If not I would start looking at DNS or other connectivity issues. I can't fathom a FB DB sucking at that level. this was my first thought, too ... something else is going on here. I suspect if sql debug was turned on, you'd see tons of faulting going on that you didn't realize and that the insert itself is not actually the slow thing. ms ___ Do not post admin requests to the list. They will be ignored. Webobjects-dev mailing list (Webobjects-dev@lists.apple.com) Help/Unsubscribe/Update your Subscription: http://lists.apple.com/mailman/options/webobjects-dev/archive%40mail-archive.com This email sent to arch...@mail-archive.com
Re: optimization/indexing
More than a minute to insert to a 7000 row table? Do other operations on the same DB take an appropriate amount of time? If not I would start looking at DNS or other connectivity issues. I can't fathom a FB DB sucking at that level. Jeff Schmitz wrote: Am reading the frontbase docs now. No problem on the CPU load, server is offline just being readied for production using my snazzy new EOFized app (which currently takes a minute+ per page request =8*O) Last question, I'm thinking PERSERVE TIME over PERSERVE SPACE. Disk space is CHEAP. right? On Dec 16, 2008, at 10:21 PM, Guido Neitzer wrote: On 16.12.2008, at 21:10, Jeff Schmitz wrote: SQL?!? So unclean ;-) Is adding the index using frontbase manager something that can be done after a table is populated? Or will I need to export and re-import my data? Sorry, I'm far from a database expert. You can add indexes at any time. Just be aware that big tables (meaning starting with hundreds of thousands of rows) can take a while to index and that inserting in big tables with many indexes can be a bit slow (at least on FrontBase 4.x). cug ___ Do not post admin requests to the list. They will be ignored. Webobjects-dev mailing list (Webobjects-dev@lists.apple.com) Help/Unsubscribe/Update your Subscription: http://lists.apple.com/mailman/options/webobjects-dev/lists%40lochgarman.com This email sent to li...@lochgarman.com ___ Do not post admin requests to the list. They will be ignored. Webobjects-dev mailing list (Webobjects-dev@lists.apple.com) Help/Unsubscribe/Update your Subscription: http://lists.apple.com/mailman/options/webobjects-dev/archive%40mail-archive.com This email sent to arch...@mail-archive.com
Re: optimization/indexing
Am reading the frontbase docs now. No problem on the CPU load, server is offline just being readied for production using my snazzy new EOFized app (which currently takes a minute+ per page request =8*O) Last question, I'm thinking PERSERVE TIME over PERSERVE SPACE. Disk space is CHEAP. right? On Dec 16, 2008, at 10:21 PM, Guido Neitzer wrote: On 16.12.2008, at 21:10, Jeff Schmitz wrote: SQL?!? So unclean ;-) Is adding the index using frontbase manager something that can be done after a table is populated? Or will I need to export and re- import my data? Sorry, I'm far from a database expert. You can add indexes at any time. Just be aware that big tables (meaning starting with hundreds of thousands of rows) can take a while to index and that inserting in big tables with many indexes can be a bit slow (at least on FrontBase 4.x). cug ___ Do not post admin requests to the list. They will be ignored. Webobjects-dev mailing list (Webobjects-dev@lists.apple.com) Help/Unsubscribe/Update your Subscription: http://lists.apple.com/mailman/options/webobjects-dev/archive%40mail-archive.com This email sent to arch...@mail-archive.com
Re: optimization/indexing
On 16.12.2008, at 21:10, Jeff Schmitz wrote: SQL?!? So unclean ;-) Is adding the index using frontbase manager something that can be done after a table is populated? Or will I need to export and re- import my data? Sorry, I'm far from a database expert. You can add indexes at any time. Just be aware that big tables (meaning starting with hundreds of thousands of rows) can take a while to index and that inserting in big tables with many indexes can be a bit slow (at least on FrontBase 4.x). cug ___ Do not post admin requests to the list. They will be ignored. Webobjects-dev mailing list (Webobjects-dev@lists.apple.com) Help/Unsubscribe/Update your Subscription: http://lists.apple.com/mailman/options/webobjects-dev/archive%40mail-archive.com This email sent to arch...@mail-archive.com
Re: optimization/indexing
Is adding the index using frontbase manager something that can be done after a table is populated? Or will I need to export and re- import my data? Sorry, I'm far from a database expert. ... Yes, you can add them after the fact. The only time you can't do that is if it is an unique index and your data is not unique. But you have bigger problems then... Jeff - if you have really large quantities of data, don't forget that it can be a fairly intensive activity for a table's attribute to be indexed so if it is a large database, best try to do it during a low- ebb in system activity. cheers. ___ Andrew Lindesay www.lindesay.co.nz ___ Do not post admin requests to the list. They will be ignored. Webobjects-dev mailing list (Webobjects-dev@lists.apple.com) Help/Unsubscribe/Update your Subscription: http://lists.apple.com/mailman/options/webobjects-dev/archive%40mail-archive.com This email sent to arch...@mail-archive.com
Re: optimization/indexing
On Dec 16, 2008, at 8:10 PM, Jeff Schmitz wrote: SQL?!? So unclean ;-) Use lots of soap and hot water afterwards. Is adding the index using frontbase manager something that can be done after a table is populated? Or will I need to export and re- import my data? Sorry, I'm far from a database expert. Yes, you can add them after the fact. The only time you can't do that is if it is an unique index and your data is not unique. But you have bigger problems then... Chuck On Dec 16, 2008, at 9:13 PM, Chuck Hill wrote: On Dec 16, 2008, at 6:23 PM, Guido Neitzer wrote: On 16.12.2008, at 17:56, Jeff Schmitz wrote: Hello, I've populated my eo tables with data and my queries are VERY slow. A table with about 7000 entries takes a couple minutes to retrieve a single EO (i.e. row of data). I guessing I need to tell the database (frontbase) that it needs to index on the attributes (columns) that I commonly query on. I was wondering, what is the usual way to do this? Can this be done from EOModeler? I know this is probably a very basic (i.e. dumb) question. 1. You can do it in FrontBase manager. 2. If you use Wonder and migrations you can use table.addIndex(columnName) where table is an ERXMigrationTable and columnName the name of the column (not the name of the attribute). 3. I think there is a way of defining indexes in Entity Modeler, but I never used that. There is. I tried to use it once. It is not quite cooked yet. I don't recall if it just needed plugin support or if the EOF part itself needed a few more bits. It will be very nice once this is all working. I recently, er, migrated to Migrations. They are quite nice. Before that I used an SQL script. Chuck -- Chuck Hill Senior Consultant / VP Development Practical WebObjects - for developers who want to increase their overall knowledge of WebObjects or who are trying to solve specific problems. http://www.global-village.net/products/practical_webobjects ___ Do not post admin requests to the list. They will be ignored. Webobjects-dev mailing list (Webobjects-dev@lists.apple.com) Help/Unsubscribe/Update your Subscription: http://lists.apple.com/mailman/options/webobjects-dev/jeffandmonica%40mac.com This email sent to jeffandmon...@mac.com -- Chuck Hill Senior Consultant / VP Development Practical WebObjects - for developers who want to increase their overall knowledge of WebObjects or who are trying to solve specific problems. http://www.global-village.net/products/practical_webobjects ___ Do not post admin requests to the list. They will be ignored. Webobjects-dev mailing list (Webobjects-dev@lists.apple.com) Help/Unsubscribe/Update your Subscription: http://lists.apple.com/mailman/options/webobjects-dev/archive%40mail-archive.com This email sent to arch...@mail-archive.com
Re: optimization/indexing
SQL?!? So unclean ;-) Is adding the index using frontbase manager something that can be done after a table is populated? Or will I need to export and re-import my data? Sorry, I'm far from a database expert. On Dec 16, 2008, at 9:13 PM, Chuck Hill wrote: On Dec 16, 2008, at 6:23 PM, Guido Neitzer wrote: On 16.12.2008, at 17:56, Jeff Schmitz wrote: Hello, I've populated my eo tables with data and my queries are VERY slow. A table with about 7000 entries takes a couple minutes to retrieve a single EO (i.e. row of data). I guessing I need to tell the database (frontbase) that it needs to index on the attributes (columns) that I commonly query on. I was wondering, what is the usual way to do this? Can this be done from EOModeler? I know this is probably a very basic (i.e. dumb) question. 1. You can do it in FrontBase manager. 2. If you use Wonder and migrations you can use table.addIndex(columnName) where table is an ERXMigrationTable and columnName the name of the column (not the name of the attribute). 3. I think there is a way of defining indexes in Entity Modeler, but I never used that. There is. I tried to use it once. It is not quite cooked yet. I don't recall if it just needed plugin support or if the EOF part itself needed a few more bits. It will be very nice once this is all working. I recently, er, migrated to Migrations. They are quite nice. Before that I used an SQL script. Chuck -- Chuck Hill Senior Consultant / VP Development Practical WebObjects - for developers who want to increase their overall knowledge of WebObjects or who are trying to solve specific problems. http://www.global-village.net/products/practical_webobjects ___ Do not post admin requests to the list. They will be ignored. Webobjects-dev mailing list (Webobjects-dev@lists.apple.com) Help/Unsubscribe/Update your Subscription: http://lists.apple.com/mailman/options/webobjects-dev/jeffandmonica%40mac.com This email sent to jeffandmon...@mac.com ___ Do not post admin requests to the list. They will be ignored. Webobjects-dev mailing list (Webobjects-dev@lists.apple.com) Help/Unsubscribe/Update your Subscription: http://lists.apple.com/mailman/options/webobjects-dev/archive%40mail-archive.com This email sent to arch...@mail-archive.com
Re: optimization/indexing
On Dec 16, 2008, at 6:23 PM, Guido Neitzer wrote: On 16.12.2008, at 17:56, Jeff Schmitz wrote: Hello, I've populated my eo tables with data and my queries are VERY slow. A table with about 7000 entries takes a couple minutes to retrieve a single EO (i.e. row of data). I guessing I need to tell the database (frontbase) that it needs to index on the attributes (columns) that I commonly query on. I was wondering, what is the usual way to do this? Can this be done from EOModeler? I know this is probably a very basic (i.e. dumb) question. 1. You can do it in FrontBase manager. 2. If you use Wonder and migrations you can use table.addIndex(columnName) where table is an ERXMigrationTable and columnName the name of the column (not the name of the attribute). 3. I think there is a way of defining indexes in Entity Modeler, but I never used that. There is. I tried to use it once. It is not quite cooked yet. I don't recall if it just needed plugin support or if the EOF part itself needed a few more bits. It will be very nice once this is all working. I recently, er, migrated to Migrations. They are quite nice. Before that I used an SQL script. Chuck -- Chuck Hill Senior Consultant / VP Development Practical WebObjects - for developers who want to increase their overall knowledge of WebObjects or who are trying to solve specific problems. http://www.global-village.net/products/practical_webobjects ___ Do not post admin requests to the list. They will be ignored. Webobjects-dev mailing list (Webobjects-dev@lists.apple.com) Help/Unsubscribe/Update your Subscription: http://lists.apple.com/mailman/options/webobjects-dev/archive%40mail-archive.com This email sent to arch...@mail-archive.com
Re: optimization/indexing
On 16.12.2008, at 17:56, Jeff Schmitz wrote: Hello, I've populated my eo tables with data and my queries are VERY slow. A table with about 7000 entries takes a couple minutes to retrieve a single EO (i.e. row of data). I guessing I need to tell the database (frontbase) that it needs to index on the attributes (columns) that I commonly query on. I was wondering, what is the usual way to do this? Can this be done from EOModeler? I know this is probably a very basic (i.e. dumb) question. 1. You can do it in FrontBase manager. 2. If you use Wonder and migrations you can use table.addIndex(columnName) where table is an ERXMigrationTable and columnName the name of the column (not the name of the attribute). 3. I think there is a way of defining indexes in Entity Modeler, but I never used that. cug ___ Do not post admin requests to the list. They will be ignored. Webobjects-dev mailing list (Webobjects-dev@lists.apple.com) Help/Unsubscribe/Update your Subscription: http://lists.apple.com/mailman/options/webobjects-dev/archive%40mail-archive.com This email sent to arch...@mail-archive.com
optimization/indexing
Hello, I've populated my eo tables with data and my queries are VERY slow. A table with about 7000 entries takes a couple minutes to retrieve a single EO (i.e. row of data). I guessing I need to tell the database (frontbase) that it needs to index on the attributes (columns) that I commonly query on. I was wondering, what is the usual way to do this? Can this be done from EOModeler? I know this is probably a very basic (i.e. dumb) question. Thanks, Jeff ___ Do not post admin requests to the list. They will be ignored. Webobjects-dev mailing list (Webobjects-dev@lists.apple.com) Help/Unsubscribe/Update your Subscription: http://lists.apple.com/mailman/options/webobjects-dev/archive%40mail-archive.com This email sent to arch...@mail-archive.com
Re: New WOLips - bug when building wonder frameworks
On Dec 15, 2008, at 5:13 PM, Simon McLean wrote: I know wobuild.properties is being replaced by wolips.properties, but there seems to be a minor bug with this. We currently set this property in wobuild.properties: wonder.framework.install.root=/Developer/WebObjects53/Library/ Frameworks to tell wonder where to install it's frameworks. if i move this property to wolips.properties, then bin my wobuild.properties file it no longer works. the property is referenced on lines 192 and 459 if generic.xml. I'm guessing line 165 of generic.xml: Now needs to be: Or maybe for backward compatibility just read in both ? Wrong list :-), but a good catch! A pox on backward compatibility with lame, old classpath handling. This fix has been committed to Wonder. Thank you, Chuck -- Chuck Hill Senior Consultant / VP Development Practical WebObjects - for developers who want to increase their overall knowledge of WebObjects or who are trying to solve specific problems. http://www.global-village.net/products/practical_webobjects ___ Do not post admin requests to the list. They will be ignored. Webobjects-dev mailing list (Webobjects-dev@lists.apple.com) Help/Unsubscribe/Update your Subscription: http://lists.apple.com/mailman/options/webobjects-dev/archive%40mail-archive.com This email sent to arch...@mail-archive.com
Re: Problem File Upload WO 5.4 WONDER 5.0.0.8764
On Dec 15, 2008, at 5:31 PM, Sergio Sánchez Maffet wrote: Hi all, I have some problems regarding file uploads with WO 5.4.3. When I submit the form, my action method is called, but the form values get lost some where in the request processing. The page is very simple, only a text field and a file upload inside a form and a submit button. Every thing is binded correctly and it has worked with WO 5.3. I'm using WONDER 5.0.0.8764 for WO 5.4. The application is running in direct connect mode, and session id's are stored in a cookies... dont know if this has some importance. The problem mentioned by William Hatch (Subject: WOFileUpload and 5.4, from 10/30/08) seems to be similar, but there is was solution posted. As Chuck mentioned, form values can get lost when the encoding changes during the request, this seems to happen in my case, but I do not understand why? Here is a log of the request in dispatchRequest() and in the same thread later in takeValueFromRequest(): Dec 16 02:01:46 MyApplication[3004] DEBUG NSLog - dispatchRequest: (headers={accept=[text/xml,application/xml,application/xhtml+xml,text/ html;q=0.9,text/plain;q=0.8,image/png,*/*;q=0.5], accept- encoding=[gzip, deflate], accept-language=[en-us], connection=[keep- alive], content-length=[851656], content-type=[multipart/form-data; boundary=WebKitFormBoundaryoAlLNzXKfp0pQVgV], cookie=[wosid=JqNtBIQBjJoJDvcBQt4bAw; woinst=-1], host=[192.168.4.35:3004], referer=[http://192.168.4.35:3004/cgi-bin/WebObjects/MyApplication.woa/wo/6.5 ], user-agent=[Mozilla/5.0 (Macintosh; U; Intel Mac OS X 10_5_5; en- us) AppleWebKit/525.27.1 (KHTML, like Gecko) Version/3.2.1 Safari/ 525.27.1]} content-length=851656 cookies=null userInfo={} storePageInBacktrackCache=true >) method=POST uri=/cgi-bin/ WebObjects/MyApplication.woa/wo/7.5 defaultFormValueEncoding=UTF-8 formValueEncodingDetectionEnabled=NO formValueEncoding=UTF-8 formValues={5.1 = ("Test 1"); 5.3.mimetype = ("image/jpeg"); 5.3.filename = ("DSC00033.JPG"); 5.3 = (com.webobjects.appserver._private.WOInputStreamData (stream com.webobjects.appserver.WOMultipartIterator$WOFormData $_woformdatainputstr...@ee68d1 of length 0), has NOT been accessed>); } > Dec 16 02:01:46 MyApplication[3004] DEBUG NSLog - takeValuesFromRequest: (headers={accept=[text/xml,application/xml,application/xhtml+xml,text/ html;q=0.9,text/plain;q=0.8,image/png,*/*;q=0.5], accept- encoding=[gzip, deflate], accept-language=[en-us], connection=[keep- alive], content-length=[851656], content-type=[multipart/form-data; boundary=WebKitFormBoundaryoAlLNzXKfp0pQVgV], cookie=[wosid=JqNtBIQBjJoJDvcBQt4bAw; woinst=-1], host=[192.168.4.35:3004], original_context_id=[7], referer=[http://192.168.4.35:3004/cgi-bin/WebObjects/MyApplication.woa/wo/6.5 ], user-agent=[Mozilla/5.0 (Macintosh; U; Intel Mac OS X 10_5_5; en- us) AppleWebKit/525.27.1 (KHTML, like Gecko) Version/3.2.1 Safari/ 525.27.1]} content-length=0 cookies=null userInfo={} storePageInBacktrackCache=true >) method=POST uri=/cgi-bin/ WebObjects/MyApplication.woa/wo/7.5 defaultFormValueEncoding=ISO8859_1 formValueEncodingDetectionEnabled=NO formValueEncoding=ISO8859_1 formValues={} > I have tried to set the form value encoding to UTF-8 in the dispatchRequest() method with no luck, I also tried WOFileUpload and ERXWOFileUpload. Any clues or ideas to fix it? Sergio, This is what I would do to track this down: 1. Create a subclass of ERXRequest and implement these methods: setDefaultFormValueEncoding(String value) setFormValueEncoding(String value) to be like: public void setDefaultFormValueEncoding(String value) { NSLog.out.appendln(new RuntimeException("set to " + value)); super.setDefaultFormValueEncoding(value); } 2. In your Application class, implement _createRequest as protected WORequest _createRequest(String aMethod, String aURL, String anHTTPVersion, NSDictionary someHeaders, NSData aContent, NSDictionary someInfo) { if (anHTTPVersion == null || anHTTPVersion.startsWith("INCLUDED")) { anHTTPVersion = "HTTP/1.0"; } if ("GET".equalsIgnoreCase(aMethod) && someHeaders != null && someHeaders.objectForKey("content-type") != null) { someHeaders = someHeaders.mutableClone(); ((NSMutableDictionary)someHeaders).removeObjectForKey("content- type"); } if (rewriteDirectConnectURL()) { aURL = "/cgi-bin/WebObjects/" + name() + ".woa" + aURL; } NOTE THE NEXT LINE! WORequest worequest = new (aMethod, aURL, anHTTPVersion, someHeaders, aContent, someInfo); return worequest; } That will give you a stack trace to the code that is setting the form encoding to ISO8859_1. With that knowledge, we should be closer to a solution. Chuck -- Chuck Hill
Re: Weird sql generation problem running migration from WO5.4 (Oracle)
What should this SQL be? Caused by: java.lang.RuntimeException: Failed to execute 'alter table CRS null SCRNV NUMBER'. Chuck On Dec 15, 2008, at 7:25 PM, Richard Stephens wrote: Hi I'm running 10.5 with WO5.4.3 installed in the default location, and 5.3.3 installed in /Developer/WebObjects53. I am doing all of my development work against 5.4 but I have 5.3 available should I run into problems. This project uses oracle as the database. Most of the projects I work with are still being deployed on 5.3.3. I have latest WONDER installed for both 5.4 and 5.3, and I experience this problem with both the apple and WONDER oracle plugins. Today I needed to do a very simple migration: public class Migration15 extends ERXMigrationDatabase.Migration { @Override public NSArray modelDependencies() { return null; } @Override public void downgrade(EOEditingContext editingContext, ERXMigrationDatabase database) throws Throwable { // DO NOTHING } @Override public void upgrade(EOEditingContext editingContext, ERXMigrationDatabase database) throws Throwable { ERXMigrationTable tbl = database.existingTableNamed("CRS"); tbl.newIntegerColumn("SCRNV", true); tbl.addForeignKey("SCRNV", "CRS", "CDATID"); } } On 5.3.3, this works exactly as expected. On 5.4.3, the migration fails and I get these messages on the console: Dec 16 13:05:19 sf_admin[61447] (ERXNSLogLog4jBridge.java:46) DEBUG NSLog - Finished initialization after launch: ERXExtensions Dec 16 13:05:19 sf_admin[61447] (ERXNSLogLog4jBridge.java:46) DEBUG NSLog - Finished initialization after launch: Ajax Dec 16 13:05:19 sf_admin[61447] (ERXNSLogLog4jBridge.java:46) DEBUG NSLog - Finished initialization after launch: ERPrototypes Welcome to sf_admin! Dec 16 13:05:19 sf_admin[61447] (ERXModelGroup.java:131) WARN er.extensions.eof.ERXModelGroup - Clearing previous class descriptions Dec 16 13:05:20 sf_admin[61447] (ERXModelGroup.java:903) WARN er.extensions.eof.ERXModelGroup - The EOModel 'erprototypes' has an empty connection dictionary. Dec 16 13:05:23 sf_admin[61447] (ERXMigrator.java:454) INFO er.extensions.migration.ERXMigrator - Upgrading sf to version 15 with migration 'au.edu.sf.migration.migratio...@5c960e' Dec 16 13:05:23 sf_admin[61447] (ERXJDBCUtilities.java:646) INFO er.extensions.jdbc.ERXJDBCUtilities - Executing alter table CRS null SCRNV NUMBER Dec 16 13:05:23 sf_admin[61447] (ERXApplication.java:1102) ERROR er.extensions.appserver.ERXApplication - sf_admin failed to start. er.extensions.migration.ERXMigrationFailedException: Migration failed. at er.extensions.migration.ERXMigrator $ERXMigrationAction.doPerform(ERXMigrator.java:473) at er.extensions.eof.ERXEOAccessUtilities $ChannelAction.perform(ERXEOAccessUtilities.java:1457) at er.extensions.migration.ERXMigrator.migrateToLatest(ERXMigrator.java: 201) at er .extensions .appserver.ERXApplication.finishInitialization(ERXApplication.java: 1003) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun .reflect .NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) at sun .reflect .DelegatingMethodAccessorImpl .invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:585) at com .webobjects.foundation.NSSelector._safeInvokeMethod(NSSelector.java: 122) at com.webobjects.foundation.NSNotificationCenter $_Entry.invokeMethod(NSNotificationCenter.java:588) at com .webobjects .foundation .NSNotificationCenter.postNotification(NSNotificationCenter.java:532) at com .webobjects .foundation .NSNotificationCenter.postNotification(NSNotificationCenter.java:546) at com.webobjects.appserver.WOApplication.run(WOApplication.java: 1229) at er.extensions.appserver.ERXApplication.run(ERXApplication.java: 1098) at com.webobjects.appserver.WOApplication.main(WOApplication.java: 548) at er.extensions.appserver.ERXApplication.main(ERXApplication.java: 631) at au.edu.sf.admin.Application.main(Application.java:62) Caused by: java.lang.RuntimeException: Failed to execute 'alter table CRS null SCRNV NUMBER'. at er .extensions .jdbc.ERXJDBCUtilities.executeUpdateScript(ERXJDBCUtilities.java:653) at er .extensions .jdbc.ERXJDBCUtilities.executeUpdateScript(ERXJDBCUtilities.java:613) at er .extensions .migration.ERXMigrationColumn.create(ERXMigrationColumn.java:388) at er .extensions .migration.ERXMigrationTable._newColumn(ERXMigrationTable.java:224) at er .extensions .migration.ERXMigrationTable.newColumn(ERXMigrationTable.java:269) at er .extensions .migration.ERXMigrationTable.newIntegerColumn(ERXMigrationTable.java: 393) at au.edu.sf.migration.Migration15.upgrade(Migration15.java:24) at er.extensions.migration.ER
Re: _wowrapper not terminated (solved)
On Dec 16, 2008, at 8:37 AM, Johan Henselmans wrote: On 15 dec 2008, at 19:58, Chuck Hill wrote: On Dec 15, 2008, at 8:26 AM, Johan Henselmans wrote: After I found out that my components would not want to read because of some mysterious, untraceable problems with character encodings, I thought I had tackled most of the problems. Alas, now WebObjects 5.4.3 came back to with a vengeance. Somehow, loading a specific page lead to the error on the bottom of the page. In 5.3.3 this does not happen, and the project merrily proceeds without errors. I assume it has something to do with the parser not understanding how I am combining different tags, but I do not know. All I can think of that might cause the problem is a conditional that creates another body tag depending on a condition: onload="init('lnk0','sectionbetalen')"> onload="init('lnk0','sectionverkoop')"> If somebody knows another reason why this happens... No idea, you could try moving the conditional to Java and the body tag to a WOGenericContainer: Did that, cleaned up a syntax error in the the wo, but did not solve the problem. However, you got me thinking (as usual). I finally noticed the Footer comment in the error message, and in this Footer.wo had a HTML file which contained (for future purposes) Footer.html: Footer.wod: That was unacceptable. This had to be: Footer.html: Footer.wod EndBodyContainer : WOGenericContainer { elementName = "/body"; } Should I file this as a bug, or what? I'd file it as a bug. At least ask for a better error message. "Found closing tag in '' (Footer.html) with no opening tag" would have let you fix this much more quickly. Chuck Body: WOGenericContainer { elementName = "body"; // Just guessing here, check with content assist onload = onLoadScript; } If that fixes it, submit a bug report. Chuck } [2008-12-15 17:6:30 CET] WOMLDefaultErrorHandler.fatalError(org.xml.sax.SAXParseException: The element type "_wowrapper_" must be terminated by the matching end-tag "".) [2008-12-15 17:6:30 CET] : Exception occurred while handling request: com.webobjects.appserver.parser.woml.WOMLTemplateParserException: Footer: 4:3: The element type "_wowrapper_" must be terminated by the matching end-tag "". [2008-12-15 17:6:30 CET] com.webobjects.appserver.parser.woml.WOMLTemplateParserException: Footer: 4:3: The element type "_wowrapper_" must be terminated by the matching end-tag "". at com .webobjects .appserver .parser.woml.WOMLTemplateParser.process(WOMLTemplateParser.java:347) at com .webobjects .appserver .parser.woml.WOMLTemplateParser.parse(WOMLTemplateParser.java:653) at com .webobjects .appserver .parser.WOHTMLTemplateParser.parse(WOHTMLTemplateParser.java:40) at com .webobjects .appserver .parser .WOComponentTemplateParser .templateWithHTMLAndDeclaration(WOComponentTemplateParser.java:438) at com .webobjects .appserver ._private .WOComponentDefinition.template(WOComponentDefinition.java:364) at com.webobjects.appserver.WOComponent.template(WOComponent.java: 499) at com .webobjects .appserver.WOComponent.appendToResponse(WOComponent.java:1112) at com .webobjects .appserver ._private .WOComponentReference.appendToResponse(WOComponentReference.java: 135) at com .webobjects .appserver ._private .WODynamicGroup.appendChildrenToResponse(WODynamicGroup.java:126) at com .webobjects .appserver ._private.WODynamicGroup.appendToResponse(WODynamicGroup.java:136) at com .webobjects .appserver.WOComponent.appendToResponse(WOComponent.java:1122) at com.webobjects.appserver.WOSession.appendToResponse(WOSession.java: 1385) at com .webobjects .appserver.WOApplication.appendToResponse(WOApplication.java:1794) at com .webobjects .appserver ._private .WOComponentRequestHandler ._dispatchWithPreparedPage(WOComponentRequestHandler.java:242) at com .webobjects .appserver ._private .WOComponentRequestHandler ._dispatchWithPreparedSession(WOComponentRequestHandler.java:298) at com .webobjects .appserver ._private .WOComponentRequestHandler ._dispatchWithPreparedApplication(WOComponentRequestHandler.java: 332) at com .webobjects .appserver ._private .WOComponentRequestHandler ._handleRequest(WOComponentRequestHandler.java:369) at com .webobjects .appserver ._private .WOComponentRequestHandler .handleRequest(WOComponentRequestHandler.java:442) at com .webobjects .appserver.WOApplication.dispatchRequest(WOApplication.java:1687) at com .webobjects .appserver._private.WOWorkerThread.runOnce(WOWorkerThread.java:144) at com .webobjects .appserver._private.WOWorkerThread.run(WOWorkerThread.java:226) at java.lang.Thread.run(Thread.java:613) Caused by: org.xml.sax.SAXParseException: The element type "_wowrapper_" must be terminated by the matching end-tag "_wowrapper_>". at org.apache.xerces.parsers.Abstract
Re: Can not get objectForGlobalID
In general you want to use faultForGlobalID for this sort of thing. objectForGlobalID will return null if the enterprise object in question hasn't yet been registered in that particular editing context. faultForGlobalID will properly register the eo in the editing context. On Dec 16, 2008, at 9:50 AM, Gennady Kushnir wrote: Hello list. I can not understand if it is a bug or I am doing something wrong. I am caching EOGlobalID's for a reference table in a static NSMutableDictionary However I noticed that this cache is not working: EOEditingContext.objectForGlobalID returns null but when getting that EO by other means, its GID is just the same as requested one (not simply "equals" but "==") In fact, sometimes it returns fine. But I can not get the difference... Any ideas? -- The Ent visualization project: http://wirehose.com/research/entvisualization ___ Do not post admin requests to the list. They will be ignored. Webobjects-dev mailing list (Webobjects-dev@lists.apple.com) Help/Unsubscribe/Update your Subscription: http://lists.apple.com/mailman/options/webobjects-dev/archive%40mail-archive.com This email sent to arch...@mail-archive.com
Can not get objectForGlobalID
Hello list. I can not understand if it is a bug or I am doing something wrong. I am caching EOGlobalID's for a reference table in a static NSMutableDictionary However I noticed that this cache is not working: EOEditingContext.objectForGlobalID returns null but when getting that EO by other means, its GID is just the same as requested one (not simply "equals" but "==") In fact, sometimes it returns fine. But I can not get the difference... Any ideas? ___ Do not post admin requests to the list. They will be ignored. Webobjects-dev mailing list (Webobjects-dev@lists.apple.com) Help/Unsubscribe/Update your Subscription: http://lists.apple.com/mailman/options/webobjects-dev/archive%40mail-archive.com This email sent to arch...@mail-archive.com
Re: _wowrapper not terminated (solved)
On 15 dec 2008, at 19:58, Chuck Hill wrote: On Dec 15, 2008, at 8:26 AM, Johan Henselmans wrote: After I found out that my components would not want to read because of some mysterious, untraceable problems with character encodings, I thought I had tackled most of the problems. Alas, now WebObjects 5.4.3 came back to with a vengeance. Somehow, loading a specific page lead to the error on the bottom of the page. In 5.3.3 this does not happen, and the project merrily proceeds without errors. I assume it has something to do with the parser not understanding how I am combining different tags, but I do not know. All I can think of that might cause the problem is a conditional that creates another body tag depending on a condition: onload="init('lnk0','sectionbetalen')"> onload="init('lnk0','sectionverkoop')"> If somebody knows another reason why this happens... No idea, you could try moving the conditional to Java and the body tag to a WOGenericContainer: Did that, cleaned up a syntax error in the the wo, but did not solve the problem. However, you got me thinking (as usual). I finally noticed the Footer comment in the error message, and in this Footer.wo had a HTML file which contained (for future purposes) Footer.html: Footer.wod: That was unacceptable. This had to be: Footer.html: Footer.wod EndBodyContainer : WOGenericContainer { elementName = "/body"; } Should I file this as a bug, or what? Body: WOGenericContainer { elementName = "body"; // Just guessing here, check with content assist onload = onLoadScript; } If that fixes it, submit a bug report. Chuck } [2008-12-15 17:6:30 CET] WOMLDefaultErrorHandler.fatalError(org.xml.sax.SAXParseException: The element type "_wowrapper_" must be terminated by the matching end-tag "".) [2008-12-15 17:6:30 CET] : Exception occurred while handling request: com.webobjects.appserver.parser.woml.WOMLTemplateParserException: Footer: 4:3: The element type "_wowrapper_" must be terminated by the matching end-tag "". [2008-12-15 17:6:30 CET] com.webobjects.appserver.parser.woml.WOMLTemplateParserException: Footer: 4:3: The element type "_wowrapper_" must be terminated by the matching end-tag "". at com .webobjects .appserver .parser.woml.WOMLTemplateParser.process(WOMLTemplateParser.java:347) at com .webobjects .appserver .parser.woml.WOMLTemplateParser.parse(WOMLTemplateParser.java:653) at com .webobjects .appserver .parser.WOHTMLTemplateParser.parse(WOHTMLTemplateParser.java:40) at com .webobjects .appserver .parser .WOComponentTemplateParser .templateWithHTMLAndDeclaration(WOComponentTemplateParser.java:438) at com .webobjects .appserver ._private.WOComponentDefinition.template(WOComponentDefinition.java: 364) at com.webobjects.appserver.WOComponent.template(WOComponent.java: 499) at com .webobjects.appserver.WOComponent.appendToResponse(WOComponent.java: 1112) at com .webobjects .appserver ._private .WOComponentReference.appendToResponse(WOComponentReference.java:135) at com .webobjects .appserver ._private .WODynamicGroup.appendChildrenToResponse(WODynamicGroup.java:126) at com .webobjects .appserver ._private.WODynamicGroup.appendToResponse(WODynamicGroup.java:136) at com .webobjects.appserver.WOComponent.appendToResponse(WOComponent.java: 1122) at com.webobjects.appserver.WOSession.appendToResponse(WOSession.java: 1385) at com .webobjects .appserver.WOApplication.appendToResponse(WOApplication.java:1794) at com .webobjects .appserver ._private .WOComponentRequestHandler ._dispatchWithPreparedPage(WOComponentRequestHandler.java:242) at com .webobjects .appserver ._private .WOComponentRequestHandler ._dispatchWithPreparedSession(WOComponentRequestHandler.java:298) at com .webobjects .appserver ._private .WOComponentRequestHandler ._dispatchWithPreparedApplication(WOComponentRequestHandler.java:332) at com .webobjects .appserver ._private .WOComponentRequestHandler ._handleRequest(WOComponentRequestHandler.java:369) at com .webobjects .appserver ._private .WOComponentRequestHandler .handleRequest(WOComponentRequestHandler.java:442) at com .webobjects .appserver.WOApplication.dispatchRequest(WOApplication.java:1687) at com .webobjects .appserver._private.WOWorkerThread.runOnce(WOWorkerThread.java:144) at com .webobjects .appserver._private.WOWorkerThread.run(WOWorkerThread.java:226) at java.lang.Thread.run(Thread.java:613) Caused by: org.xml.sax.SAXParseException: The element type "_wowrapper_" must be terminated by the matching end-tag "_wowrapper_>". at org.apache.xerces.parsers.AbstractSAXParser.parse(Unknown Source) at org.apache.xerces.jaxp.SAXParserImpl $JAXPSAXParser.parse(Unknown Source) at com .webobjects .appserver .parser.woml.WOMLTemplateParser.process(WOMLTemplateParser.java:339) ... 21 more
wocode.com is down
Hi, from some day wocode.com is down. Someone has the email in order to alert ? Regards Paolo Sommaruga ___ Do not post admin requests to the list. They will be ignored. Webobjects-dev mailing list (Webobjects-dev@lists.apple.com) Help/Unsubscribe/Update your Subscription: http://lists.apple.com/mailman/options/webobjects-dev/archive%40mail-archive.com This email sent to arch...@mail-archive.com