Menu
▾
▴
hibernate-issues
|
From: <leg...@at...> - 2003-05-25 16:45:03
|
The following comment has been added to this issue:
Author: Max Rydahl Andersen
Created: Sun, 25 May 2003 11:44 AM
Body:
working - and testing if jira notifications works.
---------------------------------------------------------------------
View the issue:
http://opensource.atlassian.com/projects/hibernate/secure/ViewIssue.jspa?key=HB-18
Here is an overview of the issue:
---------------------------------------------------------------------
Key: HB-18
Summary: Integrate support for SQL queries
Type: New Feature
Status: In Progress
Priority: Major
Project: Hibernate2
Assignee: Max Rydahl Andersen
Reporter: Max Rydahl Andersen
Created: Sat, 3 May 2003 10:08 AM
Updated: Mon, 19 May 2003 1:19 AM
Description:
Integrate support for SQL queries
To execute SQL in Hibernate one aquires a connection as normal
or via the session object.
This can really only be used to
fetch scalar values.
A real nice feature would be to be able to
provide SQL directly as an alternative to HQL. The SQL should
ofcourse return the named columns and data types that Hibernate
expects to be able to instantiate objects from the resultset.
(original: http://sourceforge.net/tracker/index.php?func=detail&aid=622605&group_id=40712&atid=428711=
---------------------------------------------------------------------
JIRA INFORMATION:
This message is automatically generated by JIRA.
If you think it was sent incorrectly contact one of the administrators:
http://opensource.atlassian.com/projects/hibernate/Administrators.jspa
If you want more information on JIRA, or have a bug to report see:
http://www.atlassian.com/software/jira
|
|
From: <leg...@at...> - 2003-08-06 11:18:15
|
The following comment has been added to this issue:
Author: Max Rydahl Andersen
Created: Wed, 6 Aug 2003 6:17 AM
Body:
I've just attached patch that adds very simple sql support to Hibernate.
It is just a "see what it can do" example that I hope you will look into and see if we can do better ;)
In doing it i found out that it is actually quite hard to write the sql that is needed to fetch these objects - but i got the basics working.
It works as follows:
SQLQuery query = session.createSQLQuery("select s.id as {simple.id}, s.name as {simple.name} from {simple} s", "simple", Category.class);
The code for SQLLoader et.al. is highly inspired on how Criteria works - it is actually copy-paste and then delete code as it somewhat simple than Criteria's ;)
YES - i know. This is not how it is laid out in the roadplan - here it is only for named queries, but i did not want to use time on writing Binder code before i could actually execute the queries ;)
One big problem i've found with the current solution:
- How do we get the alias name for the discriminator value to be used when dealing with subclasses ? This name is only available internally - could not find a way to refer to it from a query or similar)
---------------------------------------------------------------------
View the issue:
http://opensource.atlassian.com/projects/hibernate/secure/ViewIssue.jspa?key=HB-18
Here is an overview of the issue:
---------------------------------------------------------------------
Key: HB-18
Summary: Integrate support for SQL queries
Type: New Feature
Status: In Progress
Priority: Major
Project: Hibernate2
Assignee: Max Rydahl Andersen
Reporter: Max Rydahl Andersen
Created: Sat, 3 May 2003 10:08 AM
Updated: Wed, 6 Aug 2003 6:10 AM
Description:
Integrate support for SQL queries
To execute SQL in Hibernate one aquires a connection as normal
or via the session object.
This can really only be used to
fetch scalar values.
A real nice feature would be to be able to
provide SQL directly as an alternative to HQL. The SQL should
ofcourse return the named columns and data types that Hibernate
expects to be able to instantiate objects from the resultset.
(original: http://sourceforge.net/tracker/index.php?func=detail&aid=622605&group_id=40712&atid=428711=
---------------------------------------------------------------------
JIRA INFORMATION:
This message is automatically generated by JIRA.
If you think it was sent incorrectly contact one of the administrators:
http://opensource.atlassian.com/projects/hibernate/secure/Administrators.jspa
If you want more information on JIRA, or have a bug to report see:
http://www.atlassian.com/software/jira
|
|
From: <leg...@at...> - 2003-08-07 17:55:14
|
The following comment has been added to this issue:
Author: Gavin King
Created: Thu, 7 Aug 2003 12:54 PM
Body:
looking really good. I'd love to see:
* multiple object results
* SQLQuery interface replaced by Query
* {person.*} to insert persister.propertySelectFragment("person")
* support for named and positional parameters
* {person.class} for discriminator column
* {person.component.property} to support components
---------------------------------------------------------------------
View the issue:
http://opensource.atlassian.com/projects/hibernate/secure/ViewIssue.jspa?key=HB-18
Here is an overview of the issue:
---------------------------------------------------------------------
Key: HB-18
Summary: Integrate support for SQL queries
Type: New Feature
Status: In Progress
Priority: Major
Project: Hibernate2
Assignee: Max Rydahl Andersen
Reporter: Max Rydahl Andersen
Created: Sat, 3 May 2003 10:08 AM
Updated: Wed, 6 Aug 2003 6:10 AM
Description:
Integrate support for SQL queries
To execute SQL in Hibernate one aquires a connection as normal
or via the session object.
This can really only be used to
fetch scalar values.
A real nice feature would be to be able to
provide SQL directly as an alternative to HQL. The SQL should
ofcourse return the named columns and data types that Hibernate
expects to be able to instantiate objects from the resultset.
(original: http://sourceforge.net/tracker/index.php?func=detail&aid=622605&group_id=40712&atid=428711=
---------------------------------------------------------------------
JIRA INFORMATION:
This message is automatically generated by JIRA.
If you think it was sent incorrectly contact one of the administrators:
http://opensource.atlassian.com/projects/hibernate/secure/Administrators.jspa
If you want more information on JIRA, or have a bug to report see:
http://www.atlassian.com/software/jira
|
|
From: <leg...@at...> - 2003-08-07 18:50:14
|
The following comment has been added to this issue:
Author: Max Rydahl Andersen
Created: Thu, 7 Aug 2003 1:49 PM
Body:
"impedeance mismatch" in the SQL ;)
I got a question for ya' ;)
If I want to load all A.class's with my SQLQuery i also have to get ALL the columns for my potential subclasses properties (Hibernate expects that)
Currently this actually works:
session.createSQLQuery("select id as {a.id}, clazz as {a.class}, count_ as {a.count}, name as {a.name} from A", "a", A.class);
But note that {a.count} is actually referring to B.class property count, is this not misleading ?
Is it ok to refer to subclasses properties as what is happening in this case ?
Should we instead support class based property references ? so, the above would be:
session.createSQLQuery("select id as {A.id}, clazz as {A.class}, count_ as {B.count}, name as {A.name} from A", "myA", A.class);
Notice that A and B is now references to the mapped classes A and B.
Here i don't even need the "myA" alias name....
...or should we instead just keep the "old" syntax and then look at the alias name as an alias for the returnClass + their subclasses ? (this is what happens now ;)
---------------------------------------------------------------------
View the issue:
http://opensource.atlassian.com/projects/hibernate/secure/ViewIssue.jspa?key=HB-18
Here is an overview of the issue:
---------------------------------------------------------------------
Key: HB-18
Summary: Integrate support for SQL queries
Type: New Feature
Status: In Progress
Priority: Major
Project: Hibernate2
Assignee: Max Rydahl Andersen
Reporter: Max Rydahl Andersen
Created: Sat, 3 May 2003 10:08 AM
Updated: Wed, 6 Aug 2003 6:10 AM
Description:
Integrate support for SQL queries
To execute SQL in Hibernate one aquires a connection as normal
or via the session object.
This can really only be used to
fetch scalar values.
A real nice feature would be to be able to
provide SQL directly as an alternative to HQL. The SQL should
ofcourse return the named columns and data types that Hibernate
expects to be able to instantiate objects from the resultset.
(original: http://sourceforge.net/tracker/index.php?func=detail&aid=622605&group_id=40712&atid=428711=
---------------------------------------------------------------------
JIRA INFORMATION:
This message is automatically generated by JIRA.
If you think it was sent incorrectly contact one of the administrators:
http://opensource.atlassian.com/projects/hibernate/secure/Administrators.jspa
If you want more information on JIRA, or have a bug to report see:
http://www.atlassian.com/software/jira
|
|
From: <leg...@at...> - 2003-08-07 20:37:14
|
The following comment has been added to this issue:
Author: Max Rydahl Andersen
Created: Thu, 7 Aug 2003 3:36 PM
Body:
DONE * SQLQuery interface replaced by Query
DONE * {person.class} for discriminator column
(not attached yet...just to inform ya ;)
---------------------------------------------------------------------
View the issue:
http://opensource.atlassian.com/projects/hibernate/secure/ViewIssue.jspa?key=HB-18
Here is an overview of the issue:
---------------------------------------------------------------------
Key: HB-18
Summary: Integrate support for SQL queries
Type: New Feature
Status: In Progress
Priority: Major
Project: Hibernate2
Assignee: Max Rydahl Andersen
Reporter: Max Rydahl Andersen
Created: Sat, 3 May 2003 10:08 AM
Updated: Wed, 6 Aug 2003 6:10 AM
Description:
Integrate support for SQL queries
To execute SQL in Hibernate one aquires a connection as normal
or via the session object.
This can really only be used to
fetch scalar values.
A real nice feature would be to be able to
provide SQL directly as an alternative to HQL. The SQL should
ofcourse return the named columns and data types that Hibernate
expects to be able to instantiate objects from the resultset.
(original: http://sourceforge.net/tracker/index.php?func=detail&aid=622605&group_id=40712&atid=428711=
---------------------------------------------------------------------
JIRA INFORMATION:
This message is automatically generated by JIRA.
If you think it was sent incorrectly contact one of the administrators:
http://opensource.atlassian.com/projects/hibernate/secure/Administrators.jspa
If you want more information on JIRA, or have a bug to report see:
http://www.atlassian.com/software/jira
|
|
From: <leg...@at...> - 2003-08-08 00:49:14
|
The following comment has been added to this issue:
Author: Max Rydahl Andersen
Created: Thu, 7 Aug 2003 7:48 PM
Body:
DONE * multiple object results
that was a tricky one ;)
---------------------------------------------------------------------
View the issue:
http://opensource.atlassian.com/projects/hibernate/secure/ViewIssue.jspa?key=HB-18
Here is an overview of the issue:
---------------------------------------------------------------------
Key: HB-18
Summary: Integrate support for SQL queries
Type: New Feature
Status: In Progress
Priority: Major
Project: Hibernate2
Assignee: Max Rydahl Andersen
Reporter: Max Rydahl Andersen
Created: Sat, 3 May 2003 10:08 AM
Updated: Wed, 6 Aug 2003 6:10 AM
Description:
Integrate support for SQL queries
To execute SQL in Hibernate one aquires a connection as normal
or via the session object.
This can really only be used to
fetch scalar values.
A real nice feature would be to be able to
provide SQL directly as an alternative to HQL. The SQL should
ofcourse return the named columns and data types that Hibernate
expects to be able to instantiate objects from the resultset.
(original: http://sourceforge.net/tracker/index.php?func=detail&aid=622605&group_id=40712&atid=428711=
---------------------------------------------------------------------
JIRA INFORMATION:
This message is automatically generated by JIRA.
If you think it was sent incorrectly contact one of the administrators:
http://opensource.atlassian.com/projects/hibernate/secure/Administrators.jspa
If you want more information on JIRA, or have a bug to report see:
http://www.atlassian.com/software/jira
|
|
From: <leg...@at...> - 2003-08-08 10:52:14
|
The following comment has been added to this issue:
Author: Max Rydahl Andersen
Created: Fri, 8 Aug 2003 5:50 AM
Body:
I've completed the implementaiton of SQLLoader - except for the composite properties part. But this is easily added, i just probably can't get it done before the weekend is over ,(
but this code can handle pretty much else ;)
---------------------------------------------------------------------
View the issue:
http://opensource.atlassian.com/projects/hibernate/secure/ViewIssue.jspa?key=HB-18
Here is an overview of the issue:
---------------------------------------------------------------------
Key: HB-18
Summary: Integrate support for SQL queries
Type: New Feature
Status: In Progress
Priority: Major
Project: Hibernate2
Assignee: Max Rydahl Andersen
Reporter: Max Rydahl Andersen
Created: Sat, 3 May 2003 10:08 AM
Updated: Fri, 8 Aug 2003 5:49 AM
Description:
Integrate support for SQL queries
To execute SQL in Hibernate one aquires a connection as normal
or via the session object.
This can really only be used to
fetch scalar values.
A real nice feature would be to be able to
provide SQL directly as an alternative to HQL. The SQL should
ofcourse return the named columns and data types that Hibernate
expects to be able to instantiate objects from the resultset.
(original: http://sourceforge.net/tracker/index.php?func=detail&aid=622605&group_id=40712&atid=428711=
---------------------------------------------------------------------
JIRA INFORMATION:
This message is automatically generated by JIRA.
If you think it was sent incorrectly contact one of the administrators:
http://opensource.atlassian.com/projects/hibernate/secure/Administrators.jspa
If you want more information on JIRA, or have a bug to report see:
http://www.atlassian.com/software/jira
|
|
From: <leg...@at...> - 2003-08-08 13:15:21
|
The following comment has been added to this issue:
Author: Gavin King
Created: Fri, 8 Aug 2003 8:14 AM
Body:
Max, why don't you just comit this? The diff doesn't look like it worked too well anyway.
---------------------------------------------------------------------
View the issue:
http://opensource.atlassian.com/projects/hibernate/secure/ViewIssue.jspa?key=HB-18
Here is an overview of the issue:
---------------------------------------------------------------------
Key: HB-18
Summary: Integrate support for SQL queries
Type: New Feature
Status: In Progress
Priority: Major
Project: Hibernate2
Assignee: Max Rydahl Andersen
Reporter: Max Rydahl Andersen
Created: Sat, 3 May 2003 10:08 AM
Updated: Fri, 8 Aug 2003 5:49 AM
Description:
Integrate support for SQL queries
To execute SQL in Hibernate one aquires a connection as normal
or via the session object.
This can really only be used to
fetch scalar values.
A real nice feature would be to be able to
provide SQL directly as an alternative to HQL. The SQL should
ofcourse return the named columns and data types that Hibernate
expects to be able to instantiate objects from the resultset.
(original: http://sourceforge.net/tracker/index.php?func=detail&aid=622605&group_id=40712&atid=428711=
---------------------------------------------------------------------
JIRA INFORMATION:
This message is automatically generated by JIRA.
If you think it was sent incorrectly contact one of the administrators:
http://opensource.atlassian.com/projects/hibernate/secure/Administrators.jspa
If you want more information on JIRA, or have a bug to report see:
http://www.atlassian.com/software/jira
|
×
Want the latest updates on software, tech news, and AI?
Get latest updates about software, tech news, and AI from SourceForge directly in your inbox once a month.
Thanks for helping keep SourceForge clean.
X