Hibernate Community • View topic - NHibernate default

View unanswered posts | View active topics

Board index » Hibernate & Java Persistence » NHibernate Users

All times are UTC - 5 hours [ DST ]

NHibernate default_schema property

Page 1 of 1

[ 3 posts ]

Previous topic | Next topic

Author

Message

grondeau

Post subject: NHibernate default_schema property

Posted: Wed Aug 15, 2007 3:47 pm

Newbie

Joined: Wed Aug 15, 2007 3:39 pm
Posts: 1

NHibernate version: 1.2.0

When omitting the schema attribute in mapping files and using default_shema property in the NHibernate configuration, generated SQL statements are not qualified using the schema name.

Code:

<?xml version="1.0" encoding="utf-8" ?>
  <hibernate-configuration xmlns="urn:nhibernate-configuration-2.2">
    <session-factory>
      <property name="dialect">NHibernate.Dialect.OracleDialect</property>
      <property name="default_schema">DOCREPO_DEV1</property>
      <property name="show_sql">true</property>
      <property name="connection.provider">NHibernate.Connection.DriverConnectionProvider</property>
      <property name="connection.driver_class">NHibernate.Driver.OracleDataClientDriver</property>
      <property name="connection.connection_string"><![CDATA[user ID=epsilon;Password=epsilon;Data Source=QA10G.INTEGRIM.COM]]></property>
      <mapping assembly="ClinCaptDocRepo" />
    </session-factory>
  </hibernate-configuration>

Any suggestions?

Top

TomBossink

Post subject: NHibernate default_schema property

Posted: Wed Feb 20, 2008 4:23 am

Newbie

Joined: Wed Feb 20, 2008 4:16 am
Posts: 2

I'm having the exact same problem over here. When I view the queries that are being send to SQL server (through SQL profiler) I see no difference in the query.

Somebody got a solution?

Top

TomBossink

Post subject: Found the solution!

Posted: Wed Feb 20, 2008 7:00 am

Newbie

Joined: Wed Feb 20, 2008 4:16 am
Posts: 2

I have found the solution and I want to share it with you:

take a look in your table mapping files (*.hbm.xml), properly the second line of the mapping file contains the hibernate-mapping tag, check if there is a 'schema=??' attribute. Remove it from the mapping file and your query will be adjusted with the default_schema option that you have configurered.

Top

Page 1 of 1

[ 3 posts ]

Board index » Hibernate & Java Persistence » NHibernate Users

All times are UTC - 5 hours [ DST ]

You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum