** Using Hibernate 2.1.1
Piece of my businness code to retrieve the contacts of a customer...
try {
Session session = PersistencySupport.getSession();
session.lock(customer, LockMode.NONE);
Hibernate.initialize(customer.getContacts());
for (Iterator iter = customer.getContacts().iterator(); iter.hasNext();) {
Contact contact = (Contact) iter.next();
Hibernate.initialize(contact.getCountry());
}
} catch(HibernateException e) {
String emsg = "Unable to retrieve contacts for " + customer;
log.error(emsg, e);
throw e;
}
When debugging i see that
the iteration works for a few loops, but then the line :
Hibernate.initialize(contact.getCountry());
throws net.sf.hibernate.HibernateException:
Could not initialize proxy - the owning Session was closed
THE WEIRD THING : Changing the session.lock(customer, LockMode.NONE) to session.refresh(customer); and the problem is gone !!!???
The session is opened/closed vi a AOP and works fine for other much more complex pieces of business code. The session is stored as thread local in the PersistencySupport object.
Database is MSSQL2000
** mapping files :
<?xml version="1.0"?>
<!DOCTYPE hibernate-mapping PUBLIC
"-//Hibernate/Hibernate Mapping DTD 2.0//EN"
"http://hibernate.sourceforge.net/hibernate-mapping-2.0.dtd">
<hibernate-mapping>
<class
name="be.domainnames.nextgen.model.Customer"
table="domainnames3.dbo.customers"
proxy="be.domainnames.nextgen.model.Customer"
dynamic-update="false"
dynamic-insert="false"
>
<id
name="id"
column="customerId"
type="java.lang.Long"
unsaved-value="null"
>
<generator class="native">
</generator>
</id>
<version
name="version"
type="java.lang.Long"
column="version"
/>
<property
name="password"
type="java.lang.String"
update="true"
insert="true"
column="password"
/>
<property
name="username"
type="java.lang.String"
update="true"
insert="true"
column="username"
not-null="true"
unique="true"
/>
<set
name="roles"
table="domainnames3.dbo.UserRole"
lazy="true"
inverse="false"
cascade="none"
sort="unsorted"
>
<key
column="customerId"
/>
<many-to-many
class="be.domainnames.nextgen.model.Role"
column="roleId"
outer-join="auto"
/>
</set>
<set
name="contacts"
lazy="true"
inverse="true"
cascade="none"
sort="unsorted"
>
<key
column="customerId"
/>
<one-to-many
class="be.domainnames.nextgen.model.Contact"
/>
</set>
<set
name="orders"
lazy="true"
inverse="true"
cascade="none"
sort="unsorted"
>
<key
column="customerId"
/>
<one-to-many
class="be.domainnames.nextgen.model.Order"
/>
</set>
<set
name="hostAddresses"
lazy="true"
inverse="true"
cascade="none"
sort="unsorted"
>
<key
column="customerId"
/>
<one-to-many
class="be.domainnames.nextgen.model.HostAddress"
/>
</set>
<set
name="nameservers"
lazy="true"
inverse="true"
cascade="none"
sort="unsorted"
>
<key
column="customerId"
/>
<one-to-many
class="be.domainnames.nextgen.model.Nameserver"
/>
</set>
<set
name="mailExchangers"
lazy="true"
inverse="true"
cascade="none"
sort="unsorted"
>
<key
column="customerId"
/>
<one-to-many
class="be.domainnames.nextgen.model.MailExchanger"
/>
</set>
<property
name="hiddenKey"
type="java.lang.String"
update="true"
insert="true"
column="hiddenKey"
/>
<!--
To add non XDoclet property mappings, create a file named
hibernate-properties-Customer.xml
containing the additional properties and place it in your merge dir.
-->
</class>
</hibernate-mapping>
<?xml version="1.0"?>
<!DOCTYPE hibernate-mapping PUBLIC
"-//Hibernate/Hibernate Mapping DTD 2.0//EN"
"http://hibernate.sourceforge.net/hibernate-mapping-2.0.dtd">
<hibernate-mapping>
<class
name="be.domainnames.nextgen.model.Contact"
table="domainnames3.dbo.contacts"
proxy="be.domainnames.nextgen.model.Contact"
dynamic-update="false"
dynamic-insert="false"
>
<id
name="id"
column="contactId"
type="java.lang.Long"
unsaved-value="null"
>
<generator class="native">
</generator>
</id>
<property
name="city"
type="java.lang.String"
update="true"
insert="true"
column="city"
/>
<many-to-one
name="country"
class="be.domainnames.nextgen.model.Country"
cascade="none"
outer-join="auto"
update="true"
insert="true"
column="countryId"
not-null="true"
/>
<property
name="creationDt"
type="java.util.Date"
update="true"
insert="true"
column="creationDt"
/>
<many-to-one
name="customer"
class="be.domainnames.nextgen.model.Customer"
cascade="none"
outer-join="auto"
update="true"
insert="true"
column="customerId"
not-null="true"
/>
<property
name="customerContact"
type="java.lang.Boolean"
update="true"
insert="true"
column="isCustomer"
/>
<property
name="defaultBilling"
type="java.lang.Boolean"
update="true"
insert="true"
column="isDefaultBilling"
/>
<property
name="defaultLicensee"
type="java.lang.Boolean"
update="true"
insert="true"
column="isDefaultLicensee"
/>
<property
name="defaultTech"
type="java.lang.Boolean"
update="true"
insert="true"
column="isDefaultTech"
/>
<property
name="email"
type="java.lang.String"
update="true"
insert="true"
column="email"
/>
<property
name="fax"
type="java.lang.String"
update="true"
insert="true"
column="fax"
/>
<property
name="firstName"
type="java.lang.String"
update="true"
insert="true"
column="firstName"
/>
<property
name="language"
type="java.lang.String"
update="true"
insert="true"
column="language"
/>
<property
name="lastName"
type="java.lang.String"
update="true"
insert="true"
column="lastName"
/>
<property
name="licenseeHandle"
type="java.lang.String"
update="true"
insert="true"
column="licenseeHandle"
/>
<property
name="organisation"
type="java.lang.String"
update="true"
insert="true"
column="organisation"
/>
<property
name="street1"
type="java.lang.String"
update="true"
insert="true"
column="street1"
/>
<property
name="street2"
type="java.lang.String"
update="true"
insert="true"
column="street2"
/>
<property
name="techHandle"
type="java.lang.String"
update="true"
insert="true"
column="techHandle"
/>
<property
name="tel"
type="java.lang.String"
update="true"
insert="true"
column="tel"
/>
<property
name="vat"
type="java.lang.String"
update="true"
insert="true"
column="vat"
/>
<property
name="zipCode"
type="java.lang.String"
update="true"
insert="true"
column="zipCode"
/>
<property
name="deleted"
type="java.lang.Boolean"
update="true"
insert="true"
column="deleted"
/>
<property
name="allowPaylater"
type="java.lang.Boolean"
update="true"
insert="true"
column="allowPaylater"
/>
<property
name="reseller"
type="java.lang.Boolean"
update="true"
insert="true"
column="reseller"
/>
<set
name="domainsAsLicensee"
lazy="true"
inverse="true"
cascade="none"
sort="unsorted"
>
<key
column="licenseeId"
/>
<one-to-many
class="be.domainnames.nextgen.model.Domain"
/>
</set>
<!--
To add non XDoclet property mappings, create a file named
hibernate-properties-Contact.xml
containing the additional properties and place it in your merge dir.
-->
</class>
</hibernate-mapping>
<?xml version="1.0"?>
<!DOCTYPE hibernate-mapping PUBLIC
"-//Hibernate/Hibernate Mapping DTD 2.0//EN"
"http://hibernate.sourceforge.net/hibernate-mapping-2.0.dtd">
<hibernate-mapping>
<class
name="be.domainnames.nextgen.model.Country"
table="countries"
proxy="be.domainnames.nextgen.model.Country"
dynamic-update="false"
dynamic-insert="false"
>
<id
name="id"
column="countryId"
type="java.lang.Long"
unsaved-value="null"
>
<generator class="native">
</generator>
</id>
<property
name="country"
type="java.lang.String"
update="true"
insert="true"
column="country"
/>
<property
name="invoiceText"
type="java.lang.String"
update="true"
insert="true"
column="invoiceVATText"
/>
<property
name="vat"
type="java.math.BigDecimal"
update="true"
insert="true"
column="invoiceVAT"
/>
<property
name="countryCode"
type="java.lang.String"
update="true"
insert="true"
column="countryCode"
/>
<!--
To add non XDoclet property mappings, create a file named
hibernate-properties-Country.xml
containing the additional properties and place it in your merge dir.
-->
</class>
</hibernate-mapping>
Login
FAQ
Search
