From: <leg...@at...> - 2003-11-05 07:36:14
|
The following comment has been added to this issue: Author: Gavin King Created: Wed, 5 Nov 2003 1:35 AM Body: What is the value of this?? JDBC is a perfectly good API for executing SQL statements! --------------------------------------------------------------------- View the issue: http://opensource.atlassian.com/projects/hibernate/secure/ViewIssue.jspa?key=HB-454 Here is an overview of the issue: --------------------------------------------------------------------- Key: HB-454 Summary: Session.createSQLQuery(sql) Type: New Feature Status: Unassigned Priority: Trivial Project: Hibernate2 Versions: 2.1 beta 5 Assignee: Reporter: Alexey Kaigorodov Created: Tue, 4 Nov 2003 9:15 PM Updated: Tue, 4 Nov 2003 9:15 PM Description: Session.createSQLQuery(sql) without returning some entity. I.e. add the possibility to execute any SELECT through Hibernate API without use JDBC API. Will useful be for uniform access to data. -- With best regards, Alex Kaigorodov --------------------------------------------------------------------- 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-11-05 08:17:16
|
The following comment has been added to this issue: Author: Max Rydahl Andersen Created: Wed, 5 Nov 2003 2:16 AM Body: Remember that we just praised how getNamedQuery() now beautifull hides wether it is a sql or hql query that is about to be executed ? I like that, but today if you have a scalar (or mixed) query then you won't be able to do that beautifull encapsulation ;) So, it get's my vote - while my head is spinining on how the heck I should infer what the resulting rows types are.... HQL now it by parsing upfront - in sql I don't have that possibility... Maybe I should just require that the user uses "select x as {person.name}, y as {person.age}, z as {cat.color} from ..." Then a parse from "select" to "from" after tokens in brackets would "reveal" what the scalar types are.... What do you think ? --------------------------------------------------------------------- View the issue: http://opensource.atlassian.com/projects/hibernate/secure/ViewIssue.jspa?key=HB-454 Here is an overview of the issue: --------------------------------------------------------------------- Key: HB-454 Summary: Session.createSQLQuery(sql) Type: New Feature Status: Unassigned Priority: Trivial Project: Hibernate2 Versions: 2.1 beta 5 Assignee: Reporter: Alexey Kaigorodov Created: Tue, 4 Nov 2003 9:15 PM Updated: Tue, 4 Nov 2003 9:15 PM Description: Session.createSQLQuery(sql) without returning some entity. I.e. add the possibility to execute any SELECT through Hibernate API without use JDBC API. Will useful be for uniform access to data. -- With best regards, Alex Kaigorodov --------------------------------------------------------------------- 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-11-06 00:35:14
|
The following comment has been added to this issue: Author: Gavin King Created: Wed, 5 Nov 2003 6:33 PM Body: Something that hadn't occured to me before was that we could get column types from the ResultSetMetadata. I think this would be quite portable. Perhaps we should even use this instead of the dialect-specific-SQL-functions approach. I can't believe I never considered this before.... --------------------------------------------------------------------- View the issue: http://opensource.atlassian.com/projects/hibernate/secure/ViewIssue.jspa?key=HB-454 Here is an overview of the issue: --------------------------------------------------------------------- Key: HB-454 Summary: Session.createSQLQuery(sql) Type: New Feature Status: Unassigned Priority: Trivial Project: Hibernate2 Versions: 2.1 beta 5 Assignee: Reporter: Alexey Kaigorodov Created: Tue, 4 Nov 2003 9:15 PM Updated: Tue, 4 Nov 2003 9:15 PM Description: Session.createSQLQuery(sql) without returning some entity. I.e. add the possibility to execute any SELECT through Hibernate API without use JDBC API. Will useful be for uniform access to data. -- With best regards, Alex Kaigorodov --------------------------------------------------------------------- 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-11-06 20:15:14
|
The following comment has been added to this issue: Author: Max Rydahl Andersen Created: Thu, 6 Nov 2003 2:14 PM Body: well - I did think I could do it that way when I originally started building SQLLoader....the problem is that the Query "semantics" is that you can call getReturnTypes[] BEFORE you execute the query.... That makes it hard to use resultsetmetadata....and if I remember correctly some parts of hibernate de/hydration from resultset's expect to have some type knowledge before starting executing the query... ..but yes - using the resultsetmetadata would be nice ;) (and one could just perform an implicit list if you call getReturnTypes[] on a scalar query....and maybe cache the result for later retreival via list(), iterate() etc....) what'da'ya'say ? --------------------------------------------------------------------- View the issue: http://opensource.atlassian.com/projects/hibernate/secure/ViewIssue.jspa?key=HB-454 Here is an overview of the issue: --------------------------------------------------------------------- Key: HB-454 Summary: Session.createSQLQuery(sql) Type: New Feature Status: Unassigned Priority: Trivial Project: Hibernate2 Versions: 2.1 beta 5 Assignee: Reporter: Alexey Kaigorodov Created: Tue, 4 Nov 2003 9:15 PM Updated: Tue, 4 Nov 2003 9:15 PM Description: Session.createSQLQuery(sql) without returning some entity. I.e. add the possibility to execute any SELECT through Hibernate API without use JDBC API. Will useful be for uniform access to data. -- With best regards, Alex Kaigorodov --------------------------------------------------------------------- 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 |