Hibernate Books

All times are UTC - 5 hours [ DST ]

Post new topic Reply to topic  [ 1 post ] 
Author Message
 Post subject: Have to fully qualify stored procedure name in hbm.xml file
PostPosted: Mon May 21, 2012 6:43 pm 

Joined: Mon May 21, 2012 6:31 pm
Posts: 1
I am connecting to my SQL Server 2008 database server using a default catalog and default schema in my cfg.xml. As such, the table names don't have to be fully qualified with the schema name.

I do call one stored procedure to load a queue table that I then use Hibernate mapping to manage. The weird thing is I have to fully qualify the stored proc in my hbm.xml named query in order for it to be found (i.e. DatabaseName.SchemaName.StoredProcName). It's working but it feels wrong and I wanted some advice. Here is my cfg.xml:

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE hibernate-configuration PUBLIC "-//Hibernate/Hibernate Configuration DTD 3.0//EN"
    <session-factory name="sessionFactory">
        <property name="hibernate.connection.driver_class">com.microsoft.sqlserver.jdbc.SQLServerDriver</property>
        <property name="hibernate.connection.password">password</property>
        <property name="hibernate.connection.url">jdbc:sqlserver://localhost:1433</property>
        <property name="hibernate.connection.username">jdbc</property>
        <property name="hibernate.default_catalog">DatabaseName</property>
        <property name="hibernate.default_schema">SchemaName</property>
        <property name="hibernate.dialect">org.hibernate.dialect.SQLServerDialect</property>
        <property name="hibernate.c3p0.min_size">5</property>
        <property name="hibernate.c3p0.max_size">20</property>
        <property name="hibernate.c3p0.timeout">300</property>
        <property name="hibernate.c3p0.max_statements">50</property>
        <property name="hibernate.c3p0.idle_test_period">3000</property>
        <mapping resource="com/example/dao/EntityOne.hbm.xml"/>
        <mapping resource="com/example/dao/EntityTwo.hbm.xml"/>

And here is how I am calling the stored proc:
<sql-query name="spLoadQueue" callable="true">
    <return-scalar column="NumberRows" type="java.lang.Integer" />
    { call DatabaseName.SchemaName.StoredProcName() }

Again, if I just put { call StoredProcName() } I get a SQLException "could not find the stored procedure"

UPDATE: This is not just a stored procedure issue. Anytime I execute a SQLServer-specific statement in code using createSQLQuery I have to fully qualify the object name no matter if my cfg.xml file has a default database and schema indicated or not. HQL statements are fine without qualifying the object name.

Display posts from previous:  Sort by  
Post new topic Reply to topic  [ 1 post ] 

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

Search for:
© Copyright 2014, Red Hat Inc. All rights reserved. JBoss and Hibernate are registered trademarks and servicemarks of Red Hat, Inc.