Re: turn derby loggin off?

you need in the Developer's Guide, under Creating Derby databases for read-only use: http://db.apache.org/derby/docs/10.1/devguide/cdevdeploy15325.html -- Oyvind Bakksjo Sun Microsystems, Database Technology Group Trondheim, Norway http://weblogs.java.net/blog/bakksjo

Re: Why are classpath databases always read-only ?

as it can be configured, e.g. as a context-param. -- Oyvind Bakksjo Sun Microsystems, Database Technology Group Trondheim, Norway http://weblogs.java.net/blog/bakksjo/

Re: Recursive Select for Discussion Forum

ordering for free from SQL, you'll have to do some of the sorting in your java code. It should be possible to do with a 1-pass algorithm, I think. -- Oyvind Bakksjo Sun Microsystems, Database Technology Group Trondheim, Norway http://weblogs.java.net/blog/bakksjo/

Re: I need advice for Table schema Design.

Legolas Woodland wrote: Hi Thank you for reading my post. I need your advice for a design/query problem. Scenario : Imagine that i should design a system which should be able log and process view / hit over banners. So , in some portion of time there is a high rate of click / view over one

Re: What does next Exception mean?

#getNextException() :) BTW: Is there a way to search through this mailing-list via an web interface (I already found the web-interface that allows browsing, but I cant find a search field) I think most people use Google... :o) Yes, I know, it's not adequate. -- Oyvind Bakksjo Sun Microsystems, Database

Re: Derby and portability

or not, as long as there's a written commitment to it somewhere, it's fine. :) -- Oyvind Bakksjo Sun Microsystems, Database Technology Group Trondheim, Norway http://weblogs.java.net/blog/bakksjo/

Derby and portability

it in the charter, so do I have a guarantee that this is an invariant? -- Oyvind Bakksjo Sun Microsystems, Database Technology Group Trondheim, Norway http://weblogs.java.net/blog/bakksjo/

Re: Spaces in the database name with the client driver

a workaround? I know others have hit this problem too, so I created DERBY-708 for this issue. -- Oyvind Bakksjo Sun Microsystems, Database Technology Group Trondheim, Norway http://weblogs.java.net/blog/bakksjo/

Re: Question about using URLClassLoader and Derby

with org.apache.derby. I have done this successfully in other projects. I have a feeling it all must be more complex than it looks to me right now. Just a little. :) -- Oyvind Bakksjo Sun Microsystems, Database Technology Group Trondheim, Norway http://weblogs.java.net/blog/bakksjo

Re: Question about using URLClassLoader and Derby

classes must be loaded with the same class loader as the Derby classes themselves, otherwise you'll get strange exceptions. But as said, when your client code simply uses the JDBC interfaces/classes, there should be no problems. -- Oyvind Bakksjo Sun Microsystems, Database Technology Group

Re: I need some advice to choose database for an upcomming job

two threads that prepare and execute a select query on the same connection, then traverse the result sets. Still one program gets a closed resultset in client/server mode, the other doesn't. I must be overlooking something. Any ideas? -- Oyvind Bakksjo Sun Microsystems, Database Technology

Re: I need some advice to choose database for an upcomming job

quote above is vague, it does not state anything about holdability), thus never causing a commit. Quite funny, then, that whether the second execute triggers a commit depends on the holdability of other result sets. -- Oyvind Bakksjo Sun Microsystems, Database Technology Group Trondheim, Norway

Re: I need some advice to choose database for an upcomming job

scenario is not good for me. can you explain more pleas ? (to Oyvind Bakksjo) You should be able to fully embed Derby into your web application without any need to configure your servlet container *and* get decent performance by doing the following: * Place derby.jar in your web application's

Re: I need some advice to choose database for an upcomming job

to create new embedded connections with each request. -- Oyvind Bakksjo Sun Microsystems, Database Technology Group Trondheim, Norway http://weblogs.java.net/blog/bakksjo/

Re: I need some advice to choose database for an upcomming job

(); I have seen some differing behaviour with respect to this in client/server and embedded mode before (that's why I made the test), but I couldn't reproduce any issue now. -- Oyvind Bakksjo Sun Microsystems, Database Technology Group Trondheim, Norway http://weblogs.java.net/blog/bakksjo/

Re: I need some advice to choose database for an upcomming job

. Note that web application reloading can also be configured in the loader, in which case loaded classes will be tracked for changes. My interpretation is that it is actually possible to just replace the .war file. -- Oyvind Bakksjo Sun Microsystems, Database Technology Group Trondheim

Re: I need some advice to choose database for an upcomming job

. -- Oyvind Bakksjo Sun Microsystems, Database Technology Group Trondheim, Norway http://weblogs.java.net/blog/bakksjo/

Re: paging Øyvind and Naka

DERBY-663 and assigned it to me, so I've committed a fix to it. I have run the jdbcapi testsuite with no failures and I'm now waiting for derbyall to finish. -- Oyvind Bakksjo Sun Microsystems, Database Technology Group Trondheim, Norway http://weblogs.java.net/blog/bakksjo/

Re: Backup on-line

. -- Oyvind Bakksjo Sun Microsystems, Database Technology Group Trondheim, Norway http://weblogs.java.net/blog/bakksjo/

Re: Starting Derby at boot time on linux

be that you already have a process occupying that port. Try running the command below: netstat --tcp -l -p --numeric-ports | grep 1527 -- Oyvind Bakksjo Sun Microsystems, Database Technology Group Trondheim, Norway http://weblogs.java.net/blog/bakksjo/

Re: derby performance and 'order by'

still on the opposite side - we should probably investigate more optimization techniques and execution plans, as this thread has shown. -- Oyvind Bakksjo Sun Microsystems, Database Technology Group Trondheim, Norway http://weblogs.java.net/blog/bakksjo/

Re: derby performance and 'order by'

/slides/fri/s1228-reddy.ppt Paper: http://www.vldb2005.org/program/paper/fri/p1228-reddy.pdf Have a look, it's worth the time. We should definitely consider more execution plans in Derby, so that we, too, could draw such interesting pictures. ;o) -- Oyvind Bakksjo Sun Microsystems, Database

Re: derby performance and 'order by'

in the execution of the original query, without relying on the user splitting up the query, creating temporary tables etc.? -- Oyvind Bakksjo Sun Microsystems, Database Technology Group Haakon VII gt. 7b, N-7485 Trondheim, Norway Tel: x43419 / +47 73842119, Fax: +47 73842101

Re: How to compute the duration of two timestamps

Kostas Karadamoglou wrote: Hi, How can I compute the duration of two timestamps? Is there any built-in function that helps? Are any alternative options? This question was asked on this list not so long ago. You can find the answer in the mailing list archives:

Re: remote connections to embedded derby

Knut Anders Hatlen wrote: James Cowan [EMAIL PROTECTED] writes: Hi is it possible to make remote connections to an embedded derby database? No, you'll have to run the the network server. However, the network server is just a layer of networking code on top of an embedded derby database,

Re: derby jdbc load driver

Satheesh Bandaram wrote: I think Derby recommends using *.newInstance()* to load JDBC drivers... In fact, it is required if you plan to shutdown and reboot databases on the same thread/VM for Derby. Take a look at the javadoc for EmbeddedDriver. Ok. But if Derby recommends it, then it should