Re: Performance issue of derby using JDBC

Hi Harshad, Some comments inline... Harshad wrote: Rick Hillegas wrote: Depending on your data, the two queries could return different results, so Bryan's faster query is not a transformation which Derby would perform automatically. Oh yes! Although my data ensures that the

RE: Performance issue of derby using JDBC

Hi, Sorry for top posting. What you're looking for is an index. :-) Ok, I know you know about indexes on individual columns but you can create an index on multiple columns too! It's the same statement that you use to create your other indexes but you can identify multiple columns where the

Re: Performance issue of derby using JDBC

de...@segel.com wrote: Hi, [ snip ] You can create as many indexes on a table as you want, provided that the names of the indexes are unique. One major caveat... Too many indexes may confuse the optimizer and when your query is processed, the engine may choose a different index. In

How to get a Derby schema.sql so we can build the next DB?

Hi all, We're long term Java-Desktop-App-via-Hibernate-On-Postgres users trying to transition to Derby. When we deploy a new site we want to be able to (1) create the fresh database then (2) run schema.sql to construct the database schema, prior to (3) running the app and adding the data. With

Re: How to get a Derby schema.sql so we can build the next DB?

On Wed, Dec 17, 2008 at 7:24 PM, Damian Carey jami...@gmail.com wrote: Hi all, We're long term Java-Desktop-App-via-Hibernate-On-Postgres users trying to transition to Derby. When we deploy a new site we want to be able to (1) create the fresh database then (2) run schema.sql to construct

Need help in derby and tomcat

See Thread at: http://www.techienuggets.com/Detail?tx=65764 Posted on behalf of a User Hi all, I am working on developing a web application where: first, a script will retrieve data from the Japplet then validate it with information on Database (Apache derby database) then, it will sent an Ok

Re: How to get a Derby schema.sql so we can build the next DB?

On Thu, Dec 18, 2008 at 12:59 PM, Stephan van Loendersloot (LIST) step...@republika.nl wrote: Damian Carey wrote: On Wed, Dec 17, 2008 at 7:24 PM, Damian Carey jami...@gmail.com wrote: Hi all, We're long term Java-Desktop-App-via-Hibernate-On-Postgres users trying to transition to Derby.

Re: Need help in derby and tomcat

s...@twinix.com wrote: Also, any one can provide me with a tutorial how I can integrate Apache derby database and tomcat through eclipse Try these: http://db.apache.org/derby/integrate/DerbyTomcat5512JPetStor.html http://db.apache.org/derby/papers/fortune_tut.html thanks, bryan