Fw: WOXMLDecoder NullPointerException

2010-03-13 Thread Shravan Kumar. M
Any suggestions please? Fw: WOXMLDecoder NullPointerException WOXMLDecoder NullPointerException Sat Mar 13 17:15:22 2010 From: "Shravan Kumar. M" To: "WO Dev Group" Hi Group, Following code to decode an xml file or xml string is resuting in NPE, could you any one please advise what's going w

Re: Long Fetch times

2010-03-13 Thread Shravan Kumar. M
Hi Jeff, Just few questions to nail the problem: 1) When you execute the queries logged in your earlier directly in the database, does it have same performance/ same time to execute as you experience in the WO. 2) Try rebuilding table indices. 3) Just see if any data is corrupted in your databas

Re: Long Fetch times

2010-03-13 Thread Gaastra Dennis - WO Lists
Hi Jeff, As Chuck also said; please do a flat-file backup, create an empty database, and run the script to restore from the flat-file. This will give you a fresh database. Two more thinks to consider: 4) Disk fragmentation; maybe re-format the partition holding the DB. 5) Memory... 6) Research y

Re: Long Fetch times

2010-03-13 Thread Jeff Schmitz
The one thing that is different about the data added is they have similar names (e.g. pool names, entry names), so your comment about not using LIKE might be a part of it since I assume finding the right name is harder when there's a lot of similar ones. On Mar 13, 2010, at 10:53 PM, Chuck

Re: Long Fetch times

2010-03-13 Thread Chuck Hill
Let's keep this on the list. On Mar 13, 2010, at 8:46 PM, Jeff Schmitz wrote: On Mar 13, 2010, at 10:41 PM, Chuck Hill wrote: On Mar 13, 2010, at 4:44 PM, Jeff Schmitz wrote: While running some stress tests I seem to be able to get my database (Frontbase) in a state where fetch times take an

Re: Long Fetch times

2010-03-13 Thread Chuck Hill
Notice that of those queries, only _two_ take a significant amount of time. That is symptomatic of not having indexes that FB can use to optimize them. SELECT whatever FROM "t_combo_team" t0 INNER JOIN "t_entry" T1 ON t0."entryID" = T1."id" INNER JOIN

Re: Long Fetch times

2010-03-13 Thread Chuck Hill
On Mar 13, 2010, at 7:54 PM, Jeff Schmitz wrote: Thanks Dennis, comments below... On Mar 13, 2010, at 8:59 PM, Gaastra Dennis - WO Lists wrote: Some things coming to my mind: 1) Are you using a lot of indices and/or compound indices? Sometimes when you have large tables, loading those

Re: Long Fetch times

2010-03-13 Thread Chuck Hill
On Mar 13, 2010, at 6:40 PM, Jeff Schmitz wrote: btw, I have tried backing up (live backup) and restoring to no avail. If there is a problem in the database, that just copies the problem and restores it. Chuck Jeff On Mar 13, 2010, at 6:44 PM, Jeff Schmitz wrote: While running some

Re: Long Fetch times

2010-03-13 Thread Chuck Hill
On Mar 13, 2010, at 4:44 PM, Jeff Schmitz wrote: While running some stress tests I seem to be able to get my database (Frontbase) in a state where fetch times take an inordinate amount of time (e.g. fetches that return no rows take a minute), Has your stress testing added any data to the d

Re: Long Fetch times

2010-03-13 Thread Jeff Schmitz
A little more info. Here's the actual code that is doing the long running fetch, followed by the sql generated by the code. Note there there isn't all that much data in the databaes, and the fetch itself finds no matches... EOQualifier poolQual = Pool.POOL_TYPE.eq((int) po

Re: Long Fetch times

2010-03-13 Thread Jeff Schmitz
Thanks Dennis, comments below... On Mar 13, 2010, at 8:59 PM, Gaastra Dennis - WO Lists wrote: Some things coming to my mind: 1) Are you using a lot of indices and/or compound indices? Sometimes when you have large tables, loading those indices the first time, takes a while. So there is

Re: Long Fetch times

2010-03-13 Thread Gaastra Dennis - WO Lists
Some things coming to my mind: 1) Are you using a lot of indices and/or compound indices? Sometimes when you have large tables, loading those indices the first time, takes a while. So there is a fine balance between too many and not enough indices; we have noticed with FB. As such, after every

Re: Long Fetch times

2010-03-13 Thread Jeff Schmitz
btw, I have tried backing up (live backup) and restoring to no avail. Jeff On Mar 13, 2010, at 6:44 PM, Jeff Schmitz wrote: While running some stress tests I seem to be able to get my database (Frontbase) in a state where fetch times take an inordinate amount of time (e.g. fetches that ret

Re: [OT]FrontBase from 4. to 5.1. 2

2010-03-13 Thread Chuck Hill
For major version upgrades you often have to do a WRITE ALL export and re-create and import the export. That is the case here. You will need to reinstall 4.x. Chuck On Mar 13, 2010, at 6:04 PM, Baiss Eric Magnusson wrote: I had been running FB 4.latest on the latest MacMini running 10

[OT]FrontBase from 4. to 5.1. 2

2010-03-13 Thread Baiss Eric Magnusson
I had been running FB 4.latest on the latest MacMini running 10.6.2 and I downloaded and installed FrontBase Server - 5.1. 2. I got a new FB license, I deleted the Transaction Logs, and re-booted; but he databases won't start giving the error: Database Financial on host baissYi.local failed to

Long Fetch times

2010-03-13 Thread Jeff Schmitz
While running some stress tests I seem to be able to get my database (Frontbase) in a state where fetch times take an inordinate amount of time (e.g. fetches that return no rows take a minute), and once in that state, even a reboot of the machine won't fix the problem. Is there anyway to r

Re: javadoc

2010-03-13 Thread Johann Werner
I think I read somewhere that between 5.4.2 and 5.4.3 there are no API changes. That is why there is no specific 5.4.3 API on apple.com. Am 13.03.2010 um 14:44 schrieb msch...@mdimension.com: > I thought I pulled 5.4.2... Maybe not. There isn't a link to 5.4.3 on apple's > site. > > Sent from

Re: JRebel

2010-03-13 Thread Hugi Thordarson
> I'm fond of JRebel too, although if it threw a tantrum at the supermarket I'd > probably leave it there ;) Hee hee :) > I've had memory issues at launch time with some projects that have multiple > custom framework dependencies and I can't seem to provide the right JVM args > to please it.

Re: javadoc

2010-03-13 Thread mschrag
I thought I pulled 5.4.2... Maybe not. There isn't a link to 5.4.3 on apple's site. Sent from my iPhone On Mar 13, 2010, at 3:18 AM, "Johann Werner" wrote: Be careful that these javadoc pages are for WO 5.4.0 and not WO 5.4.2/5.4.3 though I think that the API differences should be minimal.

WOXMLDecoder NullPointerException

2010-03-13 Thread Shravan Kumar. M
Hi Group, Following code to decode an xml file or xml string is resuting in NPE, could you any one please advise what's going wrong here: WOXMLDecoder xmlDecoder = WOXMLDecoder.decoder(); //InputStream is = application().resourceManager().inputStreamForResourceNamed("sup

Re: JRebel

2010-03-13 Thread Michael Sharp
I'm fond of JRebel too, although if it threw a tantrum at the supermarket I'd probably leave it there ;) I've had memory issues at launch time with some projects that have multiple custom framework dependencies and I can't seem to provide the right JVM args to please it. But as Q keeps telling

JRebel

2010-03-13 Thread Hugi Thordarson
If you're not using it, start using it. Now! It's one of the greatest productivity enhancers I've encountered in years. Honestly. I'm torn about which was a happier event - the birth of my child, or me discovering JRebel. - hugi ___ Do not post admin r

Re: javadoc

2010-03-13 Thread Johann Werner
Be careful that these javadoc pages are for WO 5.4.0 and not WO 5.4.2/5.4.3 though I think that the API differences should be minimal. jw Am 12.03.2010 um 23:54 schrieb Mark Wardle: > Fantastic. I still struggle to find the right pages!!! > > Now should I start linking to these from various b