http://www.theserverside.com Most recent forum messages en Jive Forums Silver 5.5.30 (www.jivesoftware.com) Sun, 26 May 2013 02:38:30 -0400 http://www.theserverside.com/discussions/thread.tss?thread_id=29937 One place where SQL scores is in generating reports.
I agree. Though JDO 2 has introduced aggregate and grouping support to JDOQL, so SQL isn't quite as necessary as it once was. And many relational JDO implementations (like...]]> Mon, 15 Nov 2004 11:07:09 -0500 Mon, 15 Nov 2004 11:07:09 -0500 Mon, 15 Nov 2004 11:07:09 -0500 Nov 15, 2004 Abe White 0 http://www.theserverside.com/discussions/thread.tss?thread_id=29937 Agree SQL is not an object query language, and OQL's have their advantages in querying objects.
One place where SQL scores is in generating reports. I am not talking complex reports. Trying to create even moderately complex reports using...]]> Mon, 15 Nov 2004 10:03:23 -0500 Mon, 15 Nov 2004 10:03:23 -0500 Mon, 15 Nov 2004 10:03:23 -0500 Nov 15, 2004 Ravishankar V 1 http://www.theserverside.com/discussions/thread.tss?thread_id=29937
SELECT * FROM {T1 LEFT OUTER JOIN T2 ON T1.C1=T2.C3}
       
( probably it is bit outdated problem )

JDBC compiliant driver must support...]]> Mon, 15 Nov 2004 04:22:46 -0500 Mon, 15 Nov 2004 04:22:46 -0500 Mon, 15 Nov 2004 04:22:46 -0500 Nov 15, 2004 Juozas Baliuka 0 http://www.theserverside.com/discussions/thread.tss?thread_id=29937 I think that some syntatical sugar and a handful of new functions is all we need in a SQL dialect for ORM.+1]]> Mon, 15 Nov 2004 03:43:09 -0500 Mon, 15 Nov 2004 03:43:09 -0500 Mon, 15 Nov 2004 03:43:09 -0500 Nov 15, 2004 Juozas Baliuka 1 http://www.theserverside.com/discussions/thread.tss?thread_id=29937 So you're basically saying "if we add object-level concepts to SQL, then it becomes an object query language (like HQL)". That's self-evident. But my point is that SQL doesn't have those features right now.
Well,...]]> Mon, 15 Nov 2004 03:37:47 -0500 Mon, 15 Nov 2004 03:37:47 -0500 Mon, 15 Nov 2004 03:37:47 -0500 Nov 15, 2004 Christian Bauer 2 http://www.theserverside.com/discussions/thread.tss?thread_id=29937 1. JDOQL (and other object query languages) is much more concise than the equivalent SQL for complex models... sometimes 5 times as concise or more.2. JDOQL only requires knowledge of the object model, while using SQL for object queries...]]> Mon, 15 Nov 2004 01:36:24 -0500 Mon, 15 Nov 2004 01:36:24 -0500 Mon, 15 Nov 2004 01:36:24 -0500 Nov 15, 2004 Juozas Baliuka 0 http://www.theserverside.com/discussions/thread.tss?thread_id=29937 HQL has automatic inner joins with a dot notation, on the mapped foreign key constraint ... You use field names (well, variable identifiers of a Java type, like I said) instead of column names in HQL ... What is left is polymorphism, and this...]]> Sun, 14 Nov 2004 22:06:34 -0500 Sun, 14 Nov 2004 22:06:34 -0500 Sun, 14 Nov 2004 22:06:34 -0500 Nov 14, 2004 Abe White 3 http://www.theserverside.com/discussions/thread.tss?thread_id=29937 Sun, 14 Nov 2004 21:52:08 -0500 Sun, 14 Nov 2004 21:52:08 -0500 Sun, 14 Nov 2004 21:52:08 -0500 Nov 14, 2004 Christian Bauer 4 http://www.theserverside.com/discussions/thread.tss?thread_id=29937 I think SQL is a great query language "for objects", and HQL proves the point (its SQL with different identifiers for types).
HQL takes its structure and functions from SQL, but it works at the object level. You can...]]> Sun, 14 Nov 2004 19:45:14 -0500 Sun, 14 Nov 2004 19:45:14 -0500 Sun, 14 Nov 2004 19:45:14 -0500 Nov 14, 2004 Abe White 5 http://www.theserverside.com/discussions/thread.tss?thread_id=29937 Sun, 14 Nov 2004 18:38:34 -0500 Sun, 14 Nov 2004 18:38:34 -0500 Sun, 14 Nov 2004 18:38:34 -0500 Nov 14, 2004 Christian Bauer 6 http://www.theserverside.com/discussions/thread.tss?thread_id=29937 Yes, SQL standard has a few levels and versions, any technology starts from experiments before to mature, the same is about JDO. Do not ignore and reinvent standards please, all "experts" like to invent alternatyve standards, but it...]]> Sun, 14 Nov 2004 16:51:43 -0500 Sun, 14 Nov 2004 16:51:43 -0500 Sun, 14 Nov 2004 16:51:43 -0500 Nov 14, 2004 Abe White 10 http://www.theserverside.com/discussions/thread.tss?thread_id=29937 but it is as silly as to reinvent UNIX.
I'll be sure to let Linus Torvalds know.
hehehe. Just kidding!

-geoff]]> Sun, 14 Nov 2004 15:14:15 -0500 Sun, 14 Nov 2004 15:14:15 -0500 Sun, 14 Nov 2004 15:14:15 -0500 Nov 14, 2004 nextdb 0 http://www.theserverside.com/discussions/thread.tss?thread_id=29937 Sun, 14 Nov 2004 03:47:39 -0500 Sun, 14 Nov 2004 03:47:39 -0500 Sun, 14 Nov 2004 03:47:39 -0500 Nov 14, 2004 Juozas Baliuka 12 http://www.theserverside.com/discussions/thread.tss?thread_id=29937 It's amazing how for every JDO post, there seems to be some "character" intent on monopolizing the thread with talk of how JDO is not needed.
I need JDO, It must be clear from my posts, but I need good JDO not...]]> Sun, 14 Nov 2004 03:42:17 -0500 Sun, 14 Nov 2004 03:42:17 -0500 Sun, 14 Nov 2004 03:42:17 -0500 Nov 14, 2004 Juozas Baliuka 0 http://www.theserverside.com/discussions/thread.tss?thread_id=29937 I just don't get it.
I'm porting a site off of Cold Fusion. The exercise of moving it to Wicket and JDO has been pure pleasure. Every time I look at my code I am just blown away by how few lines of code I had to...]]> Sat, 13 Nov 2004 21:07:00 -0500 Sat, 13 Nov 2004 21:07:00 -0500 Sat, 13 Nov 2004 21:07:00 -0500 Nov 13, 2004 nextdb 1