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

    Qualifying table with schema name

    suneetshah2000

      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