Re: is there any way to monitor commands that are comming to Derby server?

2006-01-01 Thread Bryan Pendleton
Legolas Woodland wrote: is there any way to see which commands are coming from clients to Derby server ? I mean , i as developer want to see which commands are executed against my database , what should i do ? One good way is to set derby.language.logStatementText. It will cause each stateme

is there any way to monitor commands that are comming to Derby server?

2006-01-01 Thread Legolas Woodland
Hi Thank you for reading my post. is there any way to see which commands are coming from clients to Derby server ? I mean , i as developer want to see which commands are executed against my database , what should i do ?

RE : Set Path

2006-01-01 Thread hunterfighter
Dear,Here I got a question taht why each time i start my command prompt in Windows XP I need to run the setEmbeddedCP.bat file?Got some other way to set it?Thanks in advanced.Best Regards -- DISCLAIMER:This email and any attachment

RE : Question : How to display database

2006-01-01 Thread HunterFighter
Dear, In here I wish to know how could I be able to show out all the database that available. For example in MySQL : show databases; Best Regards

Derby not as fast as hsqldb ?

2006-01-01 Thread ivan ooi
Hi all, I did an insert 5096 rows test on Derby and HSQLDB. i found out HSQLDB a bit faster... Anythings else that i miss in this test ? Here is the test :- Derby - org.apache.derby.jdbc.EmbeddedDriver url=jdbc:derby:DerbyTest;create=true Auto Commit off. using global temporary table

Re: Tested HSQLDB faster than Derby ? Did I miss anythings ?

2006-01-01 Thread Ivan Ooi
Hi, Thanks for the repply. Is that true that temporary storage are more faster for insert statement ?because i found out temporary storage are much more faster. of cause I mean INSERTand... is there anyway that  i can  increase  Derby temporary storage performance ? other thant those i listed

Re: Tested HSQLDB faster than Derby ? Did I miss anythings ?

2006-01-01 Thread Øystein Grøvlen
> "IO" == Ivan Ooi <[EMAIL PROTECTED]> writes: IO> Hi all, IO>  I did an insert 5096 rows test on Derby and HSQLDB. i found out IO> HSQLDB a bit faster... Anythings else that i miss in this test ? HSQLDB will probably perform well and be a good choice if what you need is just a te