[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?

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?

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)

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?

5329

days inactive

5330

days old

hibernate-issues@lists.jboss.org

Manage subscription

10 comments

2 participants

tags (0)

participants (2)

Niraj Gadgilwar (JIRA)
Strong Liu (JIRA)

2025

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