Re: WOWODC 2015
Hi all, i'm realy glad about WOWODC in Germany. I'm looking to come to the conference. Hopefully my company will pay the tickets for me. But to get them to that point i need to know which presentations will come up. In my company we don't use WO, but there is a lot of cool stuff which can be integrated. The last weeks i've done some testing with jnario. If someone is interested in it i could do a session about jnario (jnario.org). The main focus of this framework is to have executable specifications and no seperation between testspezification and testexcecution. Looking forward to WOWODC 2015 Tobias 2014-12-28 12:31 GMT+01:00 Matthias Fricke matthias.fri...@xyrality.com: Hi all, we have some presentations already but still looking for more. I will have the first draft on the website by tomorrow. Best, Matthias Am 28.12.2014 um 12:29 schrieb Matthias Fricke matthias.fri...@xyrality.com: Hi, we have some presentations already but still looking for more. I will have the first draft on the website by tomorrow. Best, Matthias ___ 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: https://lists.apple.com/mailman/options/webobjects-dev/janz.tobias%40gmail.com This email sent to janz.tob...@gmail.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: https://lists.apple.com/mailman/options/webobjects-dev/archive%40mail-archive.com This email sent to arch...@mail-archive.com
AjaxAutoComplete in Tables
Hi all, i have a table with a loop for the line (tr). Each line displays one entity. I need to edit field of the entity directly in the table. One of this field is an AjaxAutoComplete. I so use this component in some other parts of my application and it works fine. But now in the table i have some problems. First the choices are not a lot so i used isLocal=true. In the table with these option the div with the choices don't show up when the component gets the focus, outside the table everything is fine. When i change isLocal=false, the choices are displayed but not filtered. Any idea? Tobias wo:loop list = $kunde.kommunikationenOrderedByDefTime item = $kommunikationItem tr tdwo:TJAjaxDatePicker class = form-half disabled = $disabled format = $session.defaultDateFormat value = $kommunikationItem.datum //td tdwo:textfield class = form-half disabled = $disabled value = $kommunikationItem.ersteller //td tdwo:textfield class = form-small disabled = $disabled value = $kommunikationItem.kontaktart //td tdwo:text style =min-height: 55px; min-width: 520px; disabled = $disabled value = $kommunikationItem.gespraechsnotiz //td tdwo:checkbox checked = $kommunikationItem.wvl disabled = $disabled //td tdwo:TJAjaxDatePicker class = form-half disabled = $disabled format = $session.defaultDateFormat value = $kommunikationItem.wvlDatum //td tdspan *wo:AjaxAutoComplete id = $saveAblehnungsgrundID disabled = $disabled activateOnFocus = $true ignoreCase = $true value = $kommunikationItem.ablehnungsgrundlist = $ablehnungsgruende isLocal = $false /*/span/td /tr /wo:loop ___ 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: https://lists.apple.com/mailman/options/webobjects-dev/archive%40mail-archive.com This email sent to arch...@mail-archive.com
Re: PrimaryKey generation takes a lot of time
Hi all, First i've tryed to set the size of primaryKeys fetched per statement in _FrontBasePlugin to 500. I've gained abound 5%. Next i've tryed to use ERXJDBCAdopter with batchsize 1000, but got no benefit. Then I tryed connectionpooling, but ended with a lot of exceptions, because the initialisation of Connections got broken. I switched to ObjectStoreCoordinator and the performance got worse. Multithreading did also slow down the application (With 2 Threads i got a better performance by about 3-5%, but with more threads the performance slows down by 5% with 10 Threads and 15% with 20 Threads). My solution: 1. Return the hole multithreading, ObjectStoreCoordinator. 2. Configure Testinstance on Productionsystem only to import the data. Database near Applikation got me to speed up. the 5 hours import is done in 5min. Its not the best for me, but with the latency and slow connection issues it's the best i can get. Thanks for all your hints. regards Tobias 2014-05-06 10:40 GMT+02:00 Patrick Middleton patr...@onestep.co.uk: We encountered this recently against MySQL 5.6.12. (Not using Project Wonder) The default primary key generation was invoking a stored procedure once per row. Once per second, some sort of garbage collection would occur inside the RDBMS and the stored procedure would take about 0.2s to complete instead of about 0.005s. The fix is to create and cache all your new primary keys at once in advance using something like er.extensions.jdbc.ERXJDBCAdaptor.Channel.primaryKeysForNewRowsWithEntity(int cnt, com.webobjects.eoaccess.EOEntity entity) then use something like databaseContextNewPrimaryKey(EODatabaseContext dbCtxt, Object object, EOEntity entity) http://wocommunity.org/documents/javadoc/WebObjects/ 5.4.2/com/webobjects/eoaccess/EODatabaseContext.Delegate. html?is-external=true to fetch a candidate new key from your cache rather than make a database round-trip to make one. On 6 May 2014, at 08:20, Tobias Janz wrote: I forgott to replay to the list. the database is close to the server. I did not find the way to copy the Database from Mac OS Frontbase to CentOS Frontbase or the other way. I tryed to recover me lokal Database with a Backup created with CentOS-Frontbase, but it fails. So I think the best way for me will be the WRITE ALL export. I will take a look at this. Thanks Tobias 2014-05-06 7:58 GMT+02:00 Chuck Hill ch...@global-village.net: Hi Tobias, I missed the Frontbase in the cloud on centOS” before. Is the app server not “close” to the database server? With latency like this, you are going to face production issues, too. That would be my first concern. Some ideas to consider: Import it locally, do a WRITE ALL export and import on the server Change to the binary UUID primary keys that are generated in the application ERXLongPrimaryKeyFactory Chuck On 2014-05-05, 10:28 PM, Tobias Janz wrote: Hi Chuck, thanks for your advice, but this approch i have allready tryed. I create a new editing context for each 100. Also i've tryed multiple threads with relevant success. When i do the import on my lokal database its much much faster. I think it's because of the latency. Is there a way to savely create primary key with multiple DB-connections in multiple Threads? And how do i get multiple database connections? regards Tobias 2014-05-06 1:32 GMT+02:00 Chuck Hill ch...@global-village.net: Are you creating the objects and saving them all at once? If so, that is your problem. Save them in batches of 500 or 1000 and it will go much quicker. You might want to try making a new editing context for each batch. Chuck On 2014-05-05, 4:29 PM, Tobias Janz wrote: Hi all, i need to import a csv-file with about 58.000 Lines und 60 Columns. I have 8 Entitys where the values will be stored. The conversion of a line to entitys takes almost no time. But the full prozess, from conversion until saveChanges is done, takes several hours (5-6h). After profiling it points me to the generating of primary keys. This part uses half of the time. I need to do the import several times. Do you see a way to improve the speed? I'm using WebObject 5.4.3 (with Wonder). My Development is on Mac. Database is a Frontbase in the cloud on centOS. Thanks for any advice. Tobias ___ 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: https://lists.apple.com/mailman/options/webobjects- dev/patrick%40onestep.co.uk This email sent to patr...@onestep.co.uk This email, including any attachments, is confidential and intended solely for the person or organisation to whom it is addressed. If you are not the intended recipient you must not disseminate, distribute or copy any partof this email nor take any action in reliance on it. If you have received
Re: PrimaryKey generation takes a lot of time
I forgott to replay to the list. the database is close to the server. I did not find the way to copy the Database from Mac OS Frontbase to CentOS Frontbase or the other way. I tryed to recover me lokal Database with a Backup created with CentOS-Frontbase, but it fails. So I think the best way for me will be the WRITE ALL export. I will take a look at this. Thanks Tobias 2014-05-06 7:58 GMT+02:00 Chuck Hill ch...@global-village.net: Hi Tobias, I missed the Frontbase in the cloud on centOS” before. Is the app server not “close” to the database server? With latency like this, you are going to face production issues, too. That would be my first concern. Some ideas to consider: - Import it locally, do a WRITE ALL export and import on the server - Change to the binary UUID primary keys that are generated in the application - ERXLongPrimaryKeyFactory Chuck On 2014-05-05, 10:28 PM, Tobias Janz wrote: Hi Chuck, thanks for your advice, but this approch i have allready tryed. I create a new editing context for each 100. Also i've tryed multiple threads with relevant success. When i do the import on my lokal database its much much faster. I think it's because of the latency. Is there a way to savely create primary key with multiple DB-connections in multiple Threads? And how do i get multiple database connections? regards Tobias 2014-05-06 1:32 GMT+02:00 Chuck Hill ch...@global-village.net: Are you creating the objects and saving them all at once? If so, that is your problem. Save them in batches of 500 or 1000 and it will go much quicker. You might want to try making a new editing context for each batch. Chuck On 2014-05-05, 4:29 PM, Tobias Janz wrote: Hi all, i need to import a csv-file with about 58.000 Lines und 60 Columns. I have 8 Entitys where the values will be stored. The conversion of a line to entitys takes almost no time. But the full prozess, from conversion until saveChanges is done, takes several hours (5-6h). After profiling it points me to the generating of primary keys. This part uses half of the time. I need to do the import several times. Do you see a way to improve the speed? I'm using WebObject 5.4.3 (with Wonder). My Development is on Mac. Database is a Frontbase in the cloud on centOS. Thanks for any advice. Tobias ___ 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: https://lists.apple.com/mailman/options/webobjects-dev/archive%40mail-archive.com This email sent to arch...@mail-archive.com
PrimaryKey generation takes a lot of time
Hi all, i need to import a csv-file with about 58.000 Lines und 60 Columns. I have 8 Entitys where the values will be stored. The conversion of a line to entitys takes almost no time. But the full prozess, from conversion until saveChanges is done, takes several hours (5-6h). After profiling it points me to the generating of primary keys. This part uses half of the time. I need to do the import several times. Do you see a way to improve the speed? I'm using WebObject 5.4.3 (with Wonder). My Development is on Mac. Database is a Frontbase in the cloud on centOS. Thanks for any advice. Tobias ___ 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: https://lists.apple.com/mailman/options/webobjects-dev/archive%40mail-archive.com This email sent to arch...@mail-archive.com
Re: JQueryUI, Ajax Components?
Hi Matthias, i don't know about the JQueryUI Components, but I'm using the Ajax Components (like the Datepicker) quite a lot. They are not destroyed. Regards, Tobias 2014-02-06 0:39 GMT+01:00 Matthias Jakob ja...@ementals.de: Hi there, are there any experiences with this? Do ajax components still function or not (i think no but not tested - hope never dies ;-)? i.e. ( i know there is a ajax date picker): input type=date name=date class=pickMe value= / $(function() { $('.pickMe').datepicker(); }); Destroyed or not? Thank you, Matthias ___ 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: https://lists.apple.com/mailman/options/webobjects-dev/janz.tobias%40gmail.com This email sent to janz.tob...@gmail.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: https://lists.apple.com/mailman/options/webobjects-dev/archive%40mail-archive.com This email sent to arch...@mail-archive.com
Re: Wonder 6.1.1 is out
Thanks to every one. Keep it up. Tobias 2014-02-12 11:21 GMT+01:00 Michael Schmiedgen schmied...@takwa.de: On 10.02.2014 16:24, Johann Werner wrote: it has been a long time but finally Wonder 6.1.1 is officially out. Point your browser to the release page on github https://github.com/ wocommunity/wonder/releases to get everything you need: a changelog and all artifacts you would get from the wocommunity jenkins server. Thank you very much, all! Michael -- ___ Michael Schmiedgen, BSc Senior Software Engineer Takwa GmbH Friedrich-List-Str. 36 99096 Erfurt GERMANY Tel +49 361 6534096 Fax +49 361 6534097 Mail schmied...@takwa.de Web http://www.takwa.de/ ___ Amtsgericht Jena HRB 112964 Geschäftsführung: Ingo Buchholz ___ 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: https://lists.apple.com/mailman/options/webobjects- dev/janz.tobias%40gmail.com This email sent to janz.tob...@gmail.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: https://lists.apple.com/mailman/options/webobjects-dev/archive%40mail-archive.com This email sent to arch...@mail-archive.com
Re: WOWODC 14 presentations and tickets
Hi there, i'm realy sorry not coming to WOWODC. It would be a great thing for me coming there. I started developing applications with WO in 2007. I switched to another company and there we don't use WO, but I still use it for private projects. I love the easyness of WO, especially with Project Wonder. But i have do buy the ticket on my own cost and have to fly from Germany and that is to much. I wish you a good conference. Tobias ___ 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: https://lists.apple.com/mailman/options/webobjects-dev/archive%40mail-archive.com This email sent to arch...@mail-archive.com
Re: Triggering AjaxObserveField through javascript
Hi Taylor, i was wrong, sorry. the problem with the myAjaxIDUpdate() is that it will do a get not a post. 2 other solutions: 1. Add an AjaxObserveField to the List, which is updating all. At the AOF set fullSubmit=true. Add an onChange to the List, where you call your JavaScript to set the values. Something like this: ListForAll: wo:popUpButton id=list3 list = $myList item = $listItem selection = $listForAllSelection onChange = document.getElementById('list1').setValue('2'); document.getElementById('list2').setValue('2'); noSelectionString = ---/ wo:AjaxObserveField observeFieldID = list3 updateContainerID = myAjaxID fullSubmit = $true / 2. And this is what I would do: Add an AjaxObserveField like above, but with an action then you can set the value in your JavaCode. Example: ListForAll: wo:popUpButton id=list3 list = $myList item = $listItem selection = $listForAllSelection noSelectionString = ---/ wo:AjaxObserveField action = $setValuesFromListForAll observeFieldID = list3 updateContainerID = myAjaxID fullSubmit = $true / public WOActionResults setValuesFromListForAll() { setList1Selection(SelectForAll); setList2Selection(SelectForAll); return null; } Hope this helps. Tobias 2013/5/7 Taylor Hadden tay...@red-aurora.com Hi Tobias, Do I literally call myAjaxIDUpdate()? Does the AjaxUpdateContainer need to be within a WOForm, or can it exist outside of it? Thanks, -Taylor taylorchadden.com @drizztmainsword On May 6, 2013, at 3:17 AM, Tobias Janz janz.tob...@gmail.com wrote: Hi, AjaxUpdateContainer with fullsubmit=true and id=yourUpdateContainerId JavaScript to call yourUpdateContainerIdUpdate() Tobias 2013/5/2 Taylor Hadden tay...@red-aurora.com Hi there, I've got a series of WOPopUpButtons each with their own AjaxObserveField. They all have the same options and related to different objects. When manually manipulating pop-ups, everything works perfectly. I've also got another WOPopPupButton that is used to set the other pop-ups all at once. I set the values through javascript, and the selection fields on the page update, however their values are not submitted through AjaxObserveField. I have tried manually firing the onchange event in javascript, but it doesn't work. I had previously used the observeFieldFrequency attribute of AjaxObserveField to bypass this problem, but that causes issues with text fields (which are set up in the same manner). So, how can I get the javascript behind AjaxObserveField to update and submit these values? Thanks, -Taylor taylorchadden.com @drizztmainsword ___ 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: https://lists.apple.com/mailman/options/webobjects-dev/janz.tobias%40gmail.com This email sent to janz.tob...@gmail.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: https://lists.apple.com/mailman/options/webobjects-dev/archive%40mail-archive.com This email sent to arch...@mail-archive.com
Re: Triggering AjaxObserveField through javascript
Hi, AjaxUpdateContainer with fullsubmit=true and id=yourUpdateContainerId JavaScript to call yourUpdateContainerIdUpdate() Tobias 2013/5/2 Taylor Hadden tay...@red-aurora.com Hi there, I've got a series of WOPopUpButtons each with their own AjaxObserveField. They all have the same options and related to different objects. When manually manipulating pop-ups, everything works perfectly. I've also got another WOPopPupButton that is used to set the other pop-ups all at once. I set the values through javascript, and the selection fields on the page update, however their values are not submitted through AjaxObserveField. I have tried manually firing the onchange event in javascript, but it doesn't work. I had previously used the observeFieldFrequency attribute of AjaxObserveField to bypass this problem, but that causes issues with text fields (which are set up in the same manner). So, how can I get the javascript behind AjaxObserveField to update and submit these values? Thanks, -Taylor taylorchadden.com @drizztmainsword ___ 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: https://lists.apple.com/mailman/options/webobjects-dev/janz.tobias%40gmail.com This email sent to janz.tob...@gmail.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: https://lists.apple.com/mailman/options/webobjects-dev/archive%40mail-archive.com This email sent to arch...@mail-archive.com
Re: Creating a WO Maven project
I would be interessted to help out on that task. Tobias 2013/4/20 Pascal Robert prob...@macti.ca Le 2013-04-19 à 14:18, Hugi Thordarson h...@karlmenn.is a écrit : Community Working Group: want to talk about new stuff that should go in Wonder? Ideas of replace WO core stuff with open source libs (like having Cayenne as a alternative to EOF)? you want to contribute to Wonder but don't know how to do it? All of these should be done in the Community Working Group. I'd like to propose cleanly re-implementing JavaFoundation and JavaWebObjects as open source. Q has already done some pretty great work on implementing foundation (in NSFoundation4J) and we could start by: 1) Writing a ton of unit tests for Apple's JavaFoundation. 2) Writing a new JavaFoundation (perhaps based on Q's NSFoundation4J) that conforms exactly to Apple's API and passes said unit tests. 3) allow the daring to experiment with replacing WO's/Apple's JavaFoundation and fix bugs as they come up. 4) Eventually introduce the new JavaFoundation as a component of Wonder, deprecating Apple's version. Repeat this process for the JavaWebObjects framework. Once these two frameworks are open, we can start working towards an actual future—where the community has complete control over WO. And yes, this assumes the community will move away from EOF as a persistence framework, but this is easily made possible by Cayenne. I wrote a little app to look at the APIs that would need testing and re-implementation, it isn't really that much… http://smu.is/oo/ So I take it that you will be our leader on that task :-) ___ 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: https://lists.apple.com/mailman/options/webobjects-dev/janz.tobias%40gmail.com This email sent to janz.tob...@gmail.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: https://lists.apple.com/mailman/options/webobjects-dev/archive%40mail-archive.com This email sent to arch...@mail-archive.com
Re: first attempt at many to many
hi, its just like David said. What extra information is that boolean? If a Releationship between User and Project exists -- isToReceiveEmail = true If not -- isToReceiveEmail = false Will you set isToReceiveEmail to false or remove the relationship. If the Releationsship is only for the Email-Information, i would recommand to not created redundant information and skip the boolean. Tobias 2013/4/15 Jesse Tayler jtay...@oeinc.com again, what David said. I see you actually do want a many-to-many and you do not want just the wizard style, because what you want is an attributed correlation table - because you want an attribute called isToReceiveEmail or whatever to be right there. I have never really seen any value in the flatten relationships and basically never use the wizard's to-many either, because I at least want to store the date created or adjusted on just about any object saved to the database, including many-to-many - so I don't see many uses for those without any attributes at all anyway. On Apr 15, 2013, at 11:34 AM, Theodore Petrosky tedp...@yahoo.com wrote: so if I am creating the relationship, it is m-to-m and I take off the flatten check box. then I create an attribute in the new ProjectUser table, boolean 'isToReceiveEmail'. Ted --- On Mon, 4/15/13, David LeBer dleber_wo...@codeferous.com wrote: From: David LeBer dleber_wo...@codeferous.com Subject: Re: first attempt at many to many To: Theodore Petrosky tedp...@yahoo.com Cc: WebObjects Development webobjects-dev@lists.apple.com Date: Monday, April 15, 2013, 11:14 AM Theodore, Do you already have a m-to-m between User and Project? Or is assumed that all users have access to all projects? If all you need to do is decide who gets emails for a given project then a simple m-to-m will do. i.e: User --emailRecipients--projects-- Project Any user in the project's emailRecipients array will receive emails. If you already have a m-to-m between User and Project, then you will want to add a flag on the join table (isEmailRecipient) and expose that table as an entity. But! You also will have to unflatten the m-to-m relationship and treat it like the individual relationships and entities that is is. EOF will cannot handle a flattened m-to-m relationship if you need access to the join entity. i.e: User --user--projectDetails-ProjectUser--userDetails---project--Project How you choose to implement the UI will depend on how you end up modelling this. D -- David LeBer Codeferous Software On 2013-04-15, at 10:15 AM, Theodore Petrosky tedp...@yahoo.com wrote: Are there any examples of working with a many to many relationship in a D2W app? I need to figure this out. I have and entity Project and an entity User. My client has asked that I add a function to allow them to choose which User(s) will get an email if the Project gets changed. Of course now it is on a project by project basis!!! So I thought I would create a many to many relationship, then each project would be populated with the users that could get an email. The each user list had a 'isSelecteToReceiveEmail' check box. but I dont understand where this value is stored? Is it in the ProjectUser 'union' table? I was under the impression that I don't touch this table. of course I could just make a textarea and have them type in a comma separated list of email addresses. ___ 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: https://lists.apple.com/mailman/options/webobjects-dev/dleber_wodev%40codeferous.com This email sent to dleber_wo...@codeferous.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: https://lists.apple.com/mailman/options/webobjects-dev/jtayler%40oeinc.com This email sent to jtay...@oeinc.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: https://lists.apple.com/mailman/options/webobjects-dev/janz.tobias%40gmail.com This email sent to janz.tob...@gmail.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: https://lists.apple.com/mailman/options/webobjects-dev/archive%40mail-archive.com This email sent to arch...@mail-archive.com
Re: [Excel] - Maximum column with EGSimpleTableCreator
Hi, looks like nobody has used the ExcelGenerator-Framework with more than 255 Columns or a bit abstract with the xlsx-Format. Maybe you could write an extension? Also the version of the poi-jar is out of date, 3.9 is the latest stable version (3.6 is 3 years old). Looks like the SS Usermodel is a good idea. Tobias 2013/4/3 Dev WO webobje...@anazys.com I'm sure I won't be able to fit more than 255 columns in this one either;) Xavier On 3 avr. 2013, at 19:21, Alan Ward aw...@apple.com wrote: What's Excel? I thought it was a car :) http://en.wikipedia.org/wiki/Lotus_Excel Alan On Apr 3, 2013, at 11:09 AM, Dev WO webobje...@anazys.com wrote: I don't want to believe I'm the only one on this list to have to deal with Excel;) Any pointer/recommendation regarding the Excel generation column limit? Thanks, Xavier On 28 mars 2013, at 20:54, Dev WO webobje...@anazys.com wrote: Hello list, I found a thread from 2010 about this, mentioning the the pre-2007 Excel limitation regarding the number of columns. I looked at the code from EGSimpleTableParser and EGSimpleTableCreator and related Properties' file but didn't find anything in them related to this limitation. It looks like the only way to get more than 255 columns in Excel is using the xlsx format through org.apache.poi.ss.usermodel instead of the org.apache.poi.hssf.usermodel. I'm wondering how people creating Excel export on this list are handling that, are you all using Aspose or did I overlooked something in Wonder? Thanks, Xavier ___ 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: https://lists.apple.com/mailman/options/webobjects-dev/webobjects%40anazys.com This email sent to webobje...@anazys.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: https://lists.apple.com/mailman/options/webobjects-dev/award%40apple.com This email sent to aw...@apple.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: https://lists.apple.com/mailman/options/webobjects-dev/janz.tobias%40gmail.com This email sent to janz.tob...@gmail.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: https://lists.apple.com/mailman/options/webobjects-dev/archive%40mail-archive.com This email sent to arch...@mail-archive.com
Re: Statement running too long
Hi, the property is er.extensions.ERXAdaptorChannelDelegate.trace.milliSeconds.error, default 5000 -- 5s May take a look at the javadoc of ERXAdaptorChannelDelegate. regards Tobias 2013/3/26 Ron X ron.x.by...@gmail.com hi4all! i have a problem: when i execute query in MySQL - everything is good - it performs in ~6s; but when i do it thru EOF i have: java.lang.RuntimeException: Statement running too long at er.extensions.eof. ERXEOAccessUtilities.logExpression(ERXEOAccessUtilities.java:1301) at er.extensions.eof.ERXAdaptorChannelDelegate.adaptorChannelDidEvaluateExpression(ERXAdaptorChannelDelegate.java:81) ... does anybody know where is the property where i van set the default value of timing for queries? thanx! ___ 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: https://lists.apple.com/mailman/options/webobjects-dev/janz.tobias%40gmail.com This email sent to janz.tob...@gmail.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: https://lists.apple.com/mailman/options/webobjects-dev/archive%40mail-archive.com This email sent to arch...@mail-archive.com