[Hibernate-JIRA] Created: (HHH-5333) Dynamically setting schema name for native queries in hbm file

[Hibernate-JIRA] Commented:...

[Hibernate-JIRA] Created:...

Niraj Gadgilwar (JIRA)

Wednesday, 23 June 2010 Wed, 23 Jun '10

1:19 p.m.

Dynamically setting schema name for native queries in hbm file -------------------------------------------------------------- Key: HHH-5333 URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-5333 Project: Hibernate Core Issue Type: Task Components: query-sql Affects Versions: 3.3.2, 3.3.0.SP1, 3.2.2 Reporter: Niraj Gadgilwar Hi , inside my hibernate.cfg.xml I am mentioning hibernate.default_schema as schema name (say "testSchema") and it is working with named queries and HQL as expected.But when I am using a native sql query <sql-query name="myQuery"> <return-scalar column="NAME" type="java.lang.String"/> <return-scalar column="SURNAME" type="java.lang.String"/> SELECT NAME,SURNAME FROM ${hibernate.default_schema}.TBEMPLOYEE </sql-query> In that case the schema name(i.e. testSchema)is not getting appended to the table names. I tried this for Hibernate version 3.3.0 and 3.3.2. But it is not working. Can anybody provide me the correct implementation ? Do anyone know correct syntax? -- 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.... - For more information on JIRA, see: http://www.atlassian.com/software/jira

Show replies by date

Niraj Gadgilwar (JIRA)

Wednesday, 23 June Wed, 23 Jun

4:22 p.m.

New subject: [Hibernate-JIRA] Updated: (HHH-5333) Dynamically setting schema name for native queries in hbm file

[ http://opensource.atlassian.com/projects/hibernate/browse/HHH-5333?page=c... ] Niraj Gadgilwar updated HHH-5333: --------------------------------- Issue Type: Bug (was: Task)

...

Dynamically setting schema name for native queries in hbm file -------------------------------------------------------------- Key: HHH-5333 URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-5333 Project: Hibernate Core Issue Type: Bug Components: query-sql Affects Versions: 3.2.2, 3.3.0.SP1, 3.3.2 Reporter: Niraj Gadgilwar Hi , inside my hibernate.cfg.xml I am mentioning hibernate.default_schema as schema name (say "testSchema") and it is working with named queries and HQL as expected.But when I am using a native sql query <sql-query name="myQuery"> <return-scalar column="NAME" type="java.lang.String"/> <return-scalar column="SURNAME" type="java.lang.String"/> SELECT NAME,SURNAME FROM ${hibernate.default_schema}.TBEMPLOYEE </sql-query> In that case the schema name(i.e. testSchema)is not getting appended to the table names. I tried this for Hibernate version 3.3.0 and 3.3.2. But it is not working. Can anybody provide me the correct implementation ? Do anyone know correct syntax?

-- 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.... - For more information on JIRA, see: http://www.atlassian.com/software/jira

Strong Liu (JIRA)

Thursday, 24 June Thu, 24 Jun

7:38 a.m.

New subject: [Hibernate-JIRA] Resolved: (HHH-5333) Dynamically setting schema name for native queries in hbm file

[ http://opensource.atlassian.com/projects/hibernate/browse/HHH-5333?page=c... ] Strong Liu resolved HHH-5333. ----------------------------- Assignee: Strong Liu Resolution: Duplicate duplicated by HHH-2576

...

Dynamically setting schema name for native queries in hbm file -------------------------------------------------------------- Key: HHH-5333 URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-5333 Project: Hibernate Core Issue Type: Bug Components: query-sql Affects Versions: 3.2.2, 3.3.0.SP1, 3.3.2 Reporter: Niraj Gadgilwar Assignee: Strong Liu Hi , inside my hibernate.cfg.xml I am mentioning hibernate.default_schema as schema name (say "testSchema") and it is working with named queries and HQL as expected.But when I am using a native sql query <sql-query name="myQuery"> <return-scalar column="NAME" type="java.lang.String"/> <return-scalar column="SURNAME" type="java.lang.String"/> SELECT NAME,SURNAME FROM ${hibernate.default_schema}.TBEMPLOYEE </sql-query> In that case the schema name(i.e. testSchema)is not getting appended to the table names. I tried this for Hibernate version 3.3.0 and 3.3.2. But it is not working. Can anybody provide me the correct implementation ? Do anyone know correct syntax?

Niraj Gadgilwar (JIRA)

8:37 a.m.

New subject: [Hibernate-JIRA] Commented: (HHH-5333) Dynamically setting schema name for native queries in hbm file

[ http://opensource.atlassian.com/projects/hibernate/browse/HHH-5333?page=c... ] Niraj Gadgilwar commented on HHH-5333: -------------------------------------- Hi, I tried this on Hibernate V 3.3.2. But it is not working. Could you tell me the synatx like {h-schema} which I can use in my named query? I tried following query. SELECT NAME,SURNAME FROM {h-schema.}TBEMPLOYEE But it is not working.

...

Dynamically setting schema name for native queries in hbm file -------------------------------------------------------------- Key: HHH-5333 URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-5333 Project: Hibernate Core Issue Type: Bug Components: query-sql Affects Versions: 3.2.2, 3.3.0.SP1, 3.3.2 Reporter: Niraj Gadgilwar Assignee: Strong Liu Hi , inside my hibernate.cfg.xml I am mentioning hibernate.default_schema as schema name (say "testSchema") and it is working with named queries and HQL as expected.But when I am using a native sql query <sql-query name="myQuery"> <return-scalar column="NAME" type="java.lang.String"/> <return-scalar column="SURNAME" type="java.lang.String"/> SELECT NAME,SURNAME FROM ${hibernate.default_schema}.TBEMPLOYEE </sql-query> In that case the schema name(i.e. testSchema)is not getting appended to the table names. I tried this for Hibernate version 3.3.0 and 3.3.2. But it is not working. Can anybody provide me the correct implementation ? Do anyone know correct syntax?

Strong Liu (JIRA)

8:41 a.m.

New subject: [Hibernate-JIRA] Commented: (HHH-5333) Dynamically setting schema name for native queries in hbm file

[ http://opensource.atlassian.com/projects/hibernate/browse/HHH-5333?page=c... ] Strong Liu commented on HHH-5333: --------------------------------- the fix version in HHH-2576 means that issue was resolved in Branch_3_3 and 3.5.0-beta3, and according Branch_3_3 is not maintains anymore, so, i'd suggest you try the latest 3.5.3 release. it does fixed in 3.3.2.GA

...

Dynamically setting schema name for native queries in hbm file -------------------------------------------------------------- Key: HHH-5333 URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-5333 Project: Hibernate Core Issue Type: Bug Components: query-sql Affects Versions: 3.2.2, 3.3.0.SP1, 3.3.2 Reporter: Niraj Gadgilwar Assignee: Strong Liu Hi , inside my hibernate.cfg.xml I am mentioning hibernate.default_schema as schema name (say "testSchema") and it is working with named queries and HQL as expected.But when I am using a native sql query <sql-query name="myQuery"> <return-scalar column="NAME" type="java.lang.String"/> <return-scalar column="SURNAME" type="java.lang.String"/> SELECT NAME,SURNAME FROM ${hibernate.default_schema}.TBEMPLOYEE </sql-query> In that case the schema name(i.e. testSchema)is not getting appended to the table names. I tried this for Hibernate version 3.3.0 and 3.3.2. But it is not working. Can anybody provide me the correct implementation ? Do anyone know correct syntax?

Niraj Gadgilwar (JIRA)

8:41 a.m.

New subject: [Hibernate-JIRA] Commented: (HHH-5333) Dynamically setting schema name for native queries in hbm file

[ http://opensource.atlassian.com/projects/hibernate/browse/HHH-5333?page=c... ] Niraj Gadgilwar commented on HHH-5333: -------------------------------------- I gone through SQLQueryParser.java class of v 3.3.0, 3.3.1 and 3.3.2. But I didn't find the changes related to schema which was mentioned in patch HHH-2576-R5.patch. Am I using downloading wrong jars of Hibernate. I am using following link to download the jars. https://olex.openlogic.com/packages/hibernate/3.3.2.GA#

...

Dynamically setting schema name for native queries in hbm file -------------------------------------------------------------- Key: HHH-5333 URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-5333 Project: Hibernate Core Issue Type: Bug Components: query-sql Affects Versions: 3.2.2, 3.3.0.SP1, 3.3.2 Reporter: Niraj Gadgilwar Assignee: Strong Liu Hi , inside my hibernate.cfg.xml I am mentioning hibernate.default_schema as schema name (say "testSchema") and it is working with named queries and HQL as expected.But when I am using a native sql query <sql-query name="myQuery"> <return-scalar column="NAME" type="java.lang.String"/> <return-scalar column="SURNAME" type="java.lang.String"/> SELECT NAME,SURNAME FROM ${hibernate.default_schema}.TBEMPLOYEE </sql-query> In that case the schema name(i.e. testSchema)is not getting appended to the table names. I tried this for Hibernate version 3.3.0 and 3.3.2. But it is not working. Can anybody provide me the correct implementation ? Do anyone know correct syntax?

Niraj Gadgilwar (JIRA)

9:03 a.m.

New subject: [Hibernate-JIRA] Commented: (HHH-5333) Dynamically setting schema name for native queries in hbm file

[ http://opensource.atlassian.com/projects/hibernate/browse/HHH-5333?page=c... ] Niraj Gadgilwar commented on HHH-5333: -------------------------------------- Thanks Strong... Could you provide me the link to download 3.5.3 jar? I am trying to get it download it from http://sourceforge.net/projects/hibernate/files/ But I think there is some problem.

...

Dynamically setting schema name for native queries in hbm file -------------------------------------------------------------- Key: HHH-5333 URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-5333 Project: Hibernate Core Issue Type: Bug Components: query-sql Affects Versions: 3.2.2, 3.3.0.SP1, 3.3.2 Reporter: Niraj Gadgilwar Assignee: Strong Liu Hi , inside my hibernate.cfg.xml I am mentioning hibernate.default_schema as schema name (say "testSchema") and it is working with named queries and HQL as expected.But when I am using a native sql query <sql-query name="myQuery"> <return-scalar column="NAME" type="java.lang.String"/> <return-scalar column="SURNAME" type="java.lang.String"/> SELECT NAME,SURNAME FROM ${hibernate.default_schema}.TBEMPLOYEE </sql-query> In that case the schema name(i.e. testSchema)is not getting appended to the table names. I tried this for Hibernate version 3.3.0 and 3.3.2. But it is not working. Can anybody provide me the correct implementation ? Do anyone know correct syntax?

Niraj Gadgilwar (JIRA)

9:05 a.m.

New subject: [Hibernate-JIRA] Issue Comment Edited: (HHH-5333) Dynamically setting schema name for native queries in hbm file

[ http://opensource.atlassian.com/projects/hibernate/browse/HHH-5333?page=c... ] Niraj Gadgilwar edited comment on HHH-5333 at 6/24/10 2:03 AM: --------------------------------------------------------------- I gone through SQLQueryParser.java class of v 3.3.0, 3.3.1 and 3.3.2. But I didn't find the changes related to schema which was mentioned in patch HHH-2576-R5.patch. Am I downloading wrong jars of Hibernate? I am using following link to download the jars. https://olex.openlogic.com/packages/hibernate/3.3.2.GA# was (Author: ngadgilwar): I gone through SQLQueryParser.java class of v 3.3.0, 3.3.1 and 3.3.2. But I didn't find the changes related to schema which was mentioned in patch HHH-2576-R5.patch. Am I using downloading wrong jars of Hibernate. I am using following link to download the jars. https://olex.openlogic.com/packages/hibernate/3.3.2.GA#

...

Dynamically setting schema name for native queries in hbm file -------------------------------------------------------------- Key: HHH-5333 URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-5333 Project: Hibernate Core Issue Type: Bug Components: query-sql Affects Versions: 3.2.2, 3.3.0.SP1, 3.3.2 Reporter: Niraj Gadgilwar Assignee: Strong Liu Hi , inside my hibernate.cfg.xml I am mentioning hibernate.default_schema as schema name (say "testSchema") and it is working with named queries and HQL as expected.But when I am using a native sql query <sql-query name="myQuery"> <return-scalar column="NAME" type="java.lang.String"/> <return-scalar column="SURNAME" type="java.lang.String"/> SELECT NAME,SURNAME FROM ${hibernate.default_schema}.TBEMPLOYEE </sql-query> In that case the schema name(i.e. testSchema)is not getting appended to the table names. I tried this for Hibernate version 3.3.0 and 3.3.2. But it is not working. Can anybody provide me the correct implementation ? Do anyone know correct syntax?

Strong Liu (JIRA)

9:14 a.m.

New subject: [Hibernate-JIRA] Commented: (HHH-5333) Dynamically setting schema name for native queries in hbm file

[ http://opensource.atlassian.com/projects/hibernate/browse/HHH-5333?page=c... ] Strong Liu commented on HHH-5333: --------------------------------- http://sourceforge.net/projects/hibernate/files/hibernate3/3.5.3-Final/hi... not sure what's the problem you got...

...

Dynamically setting schema name for native queries in hbm file -------------------------------------------------------------- Key: HHH-5333 URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-5333 Project: Hibernate Core Issue Type: Bug Components: query-sql Affects Versions: 3.2.2, 3.3.0.SP1, 3.3.2 Reporter: Niraj Gadgilwar Assignee: Strong Liu Hi , inside my hibernate.cfg.xml I am mentioning hibernate.default_schema as schema name (say "testSchema") and it is working with named queries and HQL as expected.But when I am using a native sql query <sql-query name="myQuery"> <return-scalar column="NAME" type="java.lang.String"/> <return-scalar column="SURNAME" type="java.lang.String"/> SELECT NAME,SURNAME FROM ${hibernate.default_schema}.TBEMPLOYEE </sql-query> In that case the schema name(i.e. testSchema)is not getting appended to the table names. I tried this for Hibernate version 3.3.0 and 3.3.2. But it is not working. Can anybody provide me the correct implementation ? Do anyone know correct syntax?

Niraj Gadgilwar (JIRA)

10:23 a.m.

New subject: [Hibernate-JIRA] Commented: (HHH-5333) Dynamically setting schema name for native queries in hbm file

...

Dynamically setting schema name for native queries in hbm file -------------------------------------------------------------- Key: HHH-5333 URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-5333 Project: Hibernate Core Issue Type: Bug Components: query-sql Affects Versions: 3.2.2, 3.3.0.SP1, 3.3.2 Reporter: Niraj Gadgilwar Assignee: Strong Liu Hi , inside my hibernate.cfg.xml I am mentioning hibernate.default_schema as schema name (say "testSchema") and it is working with named queries and HQL as expected.But when I am using a native sql query <sql-query name="myQuery"> <return-scalar column="NAME" type="java.lang.String"/> <return-scalar column="SURNAME" type="java.lang.String"/> SELECT NAME,SURNAME FROM ${hibernate.default_schema}.TBEMPLOYEE </sql-query> In that case the schema name(i.e. testSchema)is not getting appended to the table names. I tried this for Hibernate version 3.3.0 and 3.3.2. But it is not working. Can anybody provide me the correct implementation ? Do anyone know correct syntax?

Niraj Gadgilwar (JIRA)

11:12 a.m.

New subject: [Hibernate-JIRA] Closed: (HHH-5333) Dynamically setting schema name for native queries in hbm file

[ http://opensource.atlassian.com/projects/hibernate/browse/HHH-5333?page=c... ] Niraj Gadgilwar closed HHH-5333. --------------------------------

...

Dynamically setting schema name for native queries in hbm file -------------------------------------------------------------- Key: HHH-5333 URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-5333 Project: Hibernate Core Issue Type: Bug Components: query-sql Affects Versions: 3.2.2, 3.3.0.SP1, 3.3.2 Reporter: Niraj Gadgilwar Assignee: Strong Liu Hi , inside my hibernate.cfg.xml I am mentioning hibernate.default_schema as schema name (say "testSchema") and it is working with named queries and HQL as expected.But when I am using a native sql query <sql-query name="myQuery"> <return-scalar column="NAME" type="java.lang.String"/> <return-scalar column="SURNAME" type="java.lang.String"/> SELECT NAME,SURNAME FROM ${hibernate.default_schema}.TBEMPLOYEE </sql-query> In that case the schema name(i.e. testSchema)is not getting appended to the table names. I tried this for Hibernate version 3.3.0 and 3.3.2. But it is not working. Can anybody provide me the correct implementation ? Do anyone know correct syntax?

5121

days inactive

5122

days old

hibernate-issues@lists.jboss.org

Manage subscription

10 comments

2 participants

tags (0)

participants (2)

Niraj Gadgilwar (JIRA)
Strong Liu (JIRA)

2024

2023

2022

2021

2020

2019

2018

2017

2016

2015

2014

2013

2012

2011

2010

2009

2008

2007

2006

[Hibernate-JIRA] Created: (HHH-5333) Dynamically setting schema name for native queries in hbm file