0 Replies Latest reply on May 6, 2007 11:20 AM by Suneet Shah

    Qualifying table with schema name

    Suneet Shah Newbie

      Hello,

      All of my sql statements being generated by hibernate are being qualified by the schema or database name. Is there anyway to prevent this? I have updated the hibernate maps to exclude this, but they are still being qualified so I am not sure where this information is being set.

      <hibernate-mapping default-lazy="false">
       <class name="diamelle.common.service.RequestApprover" table="request_approver">
       <comment></comment>
       <id name="requestApproverId" type="string">
       <column name="REQUEST_APPROVER_ID" length="20" />
       <generator class="assigned" />
       </id>
       <many-to-one name="service" class="diamelle.common.service.Service" fetch="select">
       <column name="SERVICE_ID" length="20">
       <comment></comment>
       </column>
       </many-to-one>
       <property name="approverType" type="string">
       <column name="APPROVER_TYPE" length="20">
       <comment></comment>
       </column>
       </property>
       <property name="approverId" type="string">
       <column name="APPROVER_ID" length="20">
       <comment></comment>
       </column>
       </property>
       <property name="approvalLevel" type="string">
       <column name="APPROVAL_LEVEL" length="20">
       <comment></comment>
       </column>
       </property>
       </class>
      </hibernate-mapping>
      
      



      Thanks
      Suneet