[jboss-user] [Persistence, JBoss/CMP, Hibernate, Database] - 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

View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=4043525#4043525

Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=4043525