Recursive query on common table
Hi, I need to do a recursive query on a single derby database table. In Derby database documents it is mentioned that this derby doesn't support recursive queries. Is there any other work around to handle this scenario? Thanks -- View this message in context: http://www.nabble.com/Recursive-query-on-common-table-tp25819772p25819772.html Sent from the Apache Derby Users mailing list archive at Nabble.com.
unsubscribe
unsubscribe
Re: unsubscribe
Dear Stavros, you seem to be using Gmail, so be so kind and click on show details link in any message received from this mailing list and click again for unsubscribe. Thanks! Peter PS: OMG is it that hard to unsubscribe?! I though it is more difficult to subscribe... Do not respond, just my Friday afternoon thoughts. On Fri, Oct 9, 2009 at 1:53 PM, Stavros Kounis skou...@gmail.com wrote: unsubscribe
New in-memory back end features suggested, rev 1 (was: Re: Derby in-memory back end - where to go next?)
Kristian Waagan wrote: Hello, In Derby 10.5 an in-memory back end, or storage engine, was included. It stores all the data in main memory, with the exception of derby.log. If this is news to you, and you want a quick intro to it, see [1] and [2]. I'm trying to gather some feedback on whether the current implementation is found acceptable, or if there are additional features people would like to see. I expect some wishes to emerge, and I plan to record these on the wiki page [1]. The page can then be used to guide further work in this area. Hello all, Thanks to everyone that chimed in on this thread earlier. I have now updated the wiki page with some more information. It is very crude, I just wanted to get something out before I leave for two weeks of vacation. Feel free to read through the section Future features and give your feedback on this thread. Does the suggested features look reasonable? Has something really important (for you) been left out? When I get back, I think I'll start working on the new delete mechanism and maybe the monitoring. Besides from that, documentation must be added. If time permits, or somebody else wants to put down some effort, maybe one or more of the remaining features can be added. In addition to the wiki page, I suppose a separate Jira will be created for each feature. More detailed specifications will be attached to the individual Jiras. The wiki page is at: http://wiki.apache.org/db-derby/InMemoryBackEndPrimer Thanks, -- Kristian [ snip ]
Re: Free DBMS that supports DataTypes STRUCT, REF, and DISTINCT
I just spent 5 or 6 hours trying to install PostgreSQL on Windows Vista Business and wasnt able to get it to work. The documentation is pretty Unix oriented and not very logical. It starts out telling you to enter $ createdb mydb, without telling you what to enter it in, or whether/how to start the server, etc. I found answers to some of my problems in various forums but they were written by hackers for hackers. I couldnt understand them. Do you know of any procedure for installing PostgreSQL on Vista written for a layman? I am used to getting vague and slightly erroneous procedures to work, but this is beyond my limits. Rick Hillegas-2 wrote: jstrunk wrote: Is there a free DBMS that supports DataTypes STRUCT, REF, and DISTINCT so I can complete the exercises in the JDBC Tutorial? I have MySQL and Derby and neither one supports them. Thanks. Postgres supports Array types and Composite types. The latter are created by a CREATE TYPE statement--I believe that they correspond to ANSI/ISO structured types, which should mean that they are JDBC STRUCT types. Hope this helps, -Rick -- View this message in context: http://www.nabble.com/Free-DBMS-that-supports-DataTypes-STRUCT%2C-REF%2C-and-DISTINCT-tp25803736p25826357.html Sent from the Apache Derby Users mailing list archive at Nabble.com.