Hibernate version:
2.1
I'm not sure why is this giving an error. any suggestion, most probably you guys can look at the stack trace. Getting full object gets this error but not a single property,
Thanks
Amin
Code between sessionFactory.openSession() and session.close():
ChannelBuilder builder = new ChannelBuilder(session);
Transaction tx = null;
// --- list
try {
tx = session.beginTransaction();
// Query q = session.createQuery("select ch.id from Channel as ch");
// List result = q.list();
List result = session.find("from Channel");
// List chs = session.find("from Channel as ch where cat.title = ?",
// "Another category title", Hibernate.STRING);
tx.commit();
Iterator it = result.iterator();
while (it.hasNext()) {
Channel c = (Channel) it.next();
System.out.println("retrieved channel --> " + c.getId());
System.out.println(" c: " + c);
Iterator it_items = c.getItems().iterator();
while (it_items.hasNext()) {
Item item = (Item) it_items.next();
System.out.println(" * " + item);
}
}
} catch (HibernateException he2) {
if (tx != null) {
tx.rollback();
}
throw he2;
} finally {
session.close();
}
Full stack trace of any exception that occurs:
net.sf.hibernate.type.SerializationException: could not deserialize
at net.sf.hibernate.util.SerializationHelper.deserialize(SerializationHelper.java:211)
at net.sf.hibernate.util.SerializationHelper.deserialize(SerializationHelper.java:234)
at net.sf.hibernate.type.SerializableType.fromBytes(SerializableType.java:73)
at net.sf.hibernate.type.SerializableType.get(SerializableType.java:38)
at net.sf.hibernate.type.NullableType.nullSafeGet(NullableType.java:62)
at net.sf.hibernate.type.NullableType.nullSafeGet(NullableType.java:53)
at net.sf.hibernate.type.AbstractType.hydrate(AbstractType.java:66)
at net.sf.hibernate.loader.Loader.hydrate(Loader.java:686)
at net.sf.hibernate.loader.Loader.loadFromResultSet(Loader.java:627)
at net.sf.hibernate.loader.Loader.instanceNotYetLoaded(Loader.java:586)
at net.sf.hibernate.loader.Loader.getRow(Loader.java:501)
at net.sf.hibernate.loader.Loader.getRowFromResultSet(Loader.java:213)
at net.sf.hibernate.loader.Loader.doQuery(Loader.java:281)
at net.sf.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:133)
at net.sf.hibernate.loader.Loader.loadCollection(Loader.java:990)
at net.sf.hibernate.loader.Loader.loadCollection(Loader.java:965)
at net.sf.hibernate.loader.OneToManyLoader.initialize(OneToManyLoader.java:93)
at net.sf.hibernate.collection.AbstractCollectionPersister.initialize(AbstractCollectionPersister.java:288)
at net.sf.hibernate.impl.SessionImpl.initializeCollection(SessionImpl.java:3303)
at net.sf.hibernate.collection.PersistentCollection.forceInitialization(PersistentCollection.java:336)
at net.sf.hibernate.impl.SessionImpl.initializeNonLazyCollections(SessionImpl.java:3156)
at net.sf.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:138)
at net.sf.hibernate.loader.Loader.doList(Loader.java:1033)
at net.sf.hibernate.loader.Loader.list(Loader.java:1024)
at net.sf.hibernate.hql.QueryTranslator.list(QueryTranslator.java:854)
at net.sf.hibernate.impl.SessionImpl.find(SessionImpl.java:1553)
at net.sf.hibernate.impl.SessionImpl.find(SessionImpl.java:1530)
at net.sf.hibernate.impl.SessionImpl.find(SessionImpl.java:1522)
at com.xymphany.aggregator.crawler.ChannelUpdate.initChannelUpdates(ChannelUpdate.java:54)
at com.xymphany.aggregator.crawler.ChannelUpdate.main(ChannelUpdate.java:27)
Caused by: java.io.EOFException
at java.io.ObjectInputStream$PeekInputStream.readFully(Unknown Source)
at java.io.ObjectInputStream$BlockDataInputStream.readUTFBody(Unknown Source)
at java.io.ObjectInputStream$BlockDataInputStream.readUTF(Unknown Source)
at java.io.ObjectInputStream.readString(Unknown Source)
at java.io.ObjectInputStream.readObject0(Unknown Source)
at java.io.ObjectInputStream.defaultReadFields(Unknown Source)
at java.io.ObjectInputStream.defaultReadObject(Unknown Source)
at java.net.URL.readObject(Unknown Source)
at sun.reflect.GeneratedMethodAccessor4.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.lang.reflect.Method.invoke(Unknown Source)
at java.io.ObjectStreamClass.invokeReadObject(Unknown Source)
at java.io.ObjectInputStream.readSerialData(Unknown Source)
at java.io.ObjectInputStream.readOrdinaryObject(Unknown Source)
at java.io.ObjectInputStream.readObject0(Unknown Source)
at java.io.ObjectInputStream.readObject(Unknown Source)
at net.sf.hibernate.util.SerializationHelper.deserialize(SerializationHelper.java:204)
... 29 more
Exception in thread "main"
Name and version of the database you are using:
Mysql 4.1
The generated SQL (show_sql=true):
Hibernate: select channel0_.CHANNEL_ID as CHANNEL_ID, channel0_.TITLE as TITLE, channel0_.DESCRIPTION as DESCRIPT3_, channel0_.LOCSTRING as LOCSTRING, channel0_.SITE as SITE, channel0_.CREATOR as CREATOR, channel0_.PUBLISHER as PUBLISHER, channel0_.LANGUAGE as LANGUAGE, channel0_.FORMAT as FORMAT, channel0_.IMAGE_ID as IMAGE_ID, channel0_.TEXTINPUT_ID as TEXTINP11_, channel0_.COPYRIGHT as COPYRIGHT, channel0_.RATING as RATING, channel0_.CLOUD_ID as CLOUD_ID, channel0_.GENERATOR as GENERATOR, channel0_.DOCS as DOCS, channel0_.TTL as TTL, channel0_.LAST_UPDATED as LAST_UP18_, channel0_.LAST_BUILD_DATE as LAST_BU19_, channel0_.PUB_DATE as PUB_DATE, channel0_.UPDATE_PERIOD as UPDATE_21_, channel0_.UPDATE_FREQUENCY as UPDATE_22_, channel0_.UPDATE_BASE as UPDATE_23_ from CHANNELS channel0_
Hibernate: select image0_.IMAGE_ID as IMAGE_ID0_, image0_.TITLE as TITLE0_, image0_.DESCRIPTION as DESCRIPT3_0_, image0_.LOCATION as LOCATION0_, image0_.LINK as LINK0_, image0_.WIDTH as WIDTH0_, image0_.HEIGHT as HEIGHT0_ from IMAGES image0_ where image0_.IMAGE_ID=?
Hibernate: select image0_.IMAGE_ID as IMAGE_ID0_, image0_.TITLE as TITLE0_, image0_.DESCRIPTION as DESCRIPT3_0_, image0_.LOCATION as LOCATION0_, image0_.LINK as LINK0_, image0_.WIDTH as WIDTH0_, image0_.HEIGHT as HEIGHT0_ from IMAGES image0_ where image0_.IMAGE_ID=?
Hibernate: select image0_.IMAGE_ID as IMAGE_ID0_, image0_.TITLE as TITLE0_, image0_.DESCRIPTION as DESCRIPT3_0_, image0_.LOCATION as LOCATION0_, image0_.LINK as LINK0_, image0_.WIDTH as WIDTH0_, image0_.HEIGHT as HEIGHT0_ from IMAGES image0_ where image0_.IMAGE_ID=?
Hibernate: select image0_.IMAGE_ID as IMAGE_ID0_, image0_.TITLE as TITLE0_, image0_.DESCRIPTION as DESCRIPT3_0_, image0_.LOCATION as LOCATION0_, image0_.LINK as LINK0_, image0_.WIDTH as WIDTH0_, image0_.HEIGHT as HEIGHT0_ from IMAGES image0_ where image0_.IMAGE_ID=?
Hibernate: select image0_.IMAGE_ID as IMAGE_ID0_, image0_.TITLE as TITLE0_, image0_.DESCRIPTION as DESCRIPT3_0_, image0_.LOCATION as LOCATION0_, image0_.LINK as LINK0_, image0_.WIDTH as WIDTH0_, image0_.HEIGHT as HEIGHT0_ from IMAGES image0_ where image0_.IMAGE_ID=?
Hibernate: select image0_.IMAGE_ID as IMAGE_ID0_, image0_.TITLE as TITLE0_, image0_.DESCRIPTION as DESCRIPT3_0_, image0_.LOCATION as LOCATION0_, image0_.LINK as LINK0_, image0_.WIDTH as WIDTH0_, image0_.HEIGHT as HEIGHT0_ from IMAGES image0_ where image0_.IMAGE_ID=?
Hibernate: select image0_.IMAGE_ID as IMAGE_ID0_, image0_.TITLE as TITLE0_, image0_.DESCRIPTION as DESCRIPT3_0_, image0_.LOCATION as LOCATION0_, image0_.LINK as LINK0_, image0_.WIDTH as WIDTH0_, image0_.HEIGHT as HEIGHT0_ from IMAGES image0_ where image0_.IMAGE_ID=?
Hibernate: select image0_.IMAGE_ID as IMAGE_ID0_, image0_.TITLE as TITLE0_, image0_.DESCRIPTION as DESCRIPT3_0_, image0_.LOCATION as LOCATION0_, image0_.LINK as LINK0_, image0_.WIDTH as WIDTH0_, image0_.HEIGHT as HEIGHT0_ from IMAGES image0_ where image0_.IMAGE_ID=?
Hibernate: select image0_.IMAGE_ID as IMAGE_ID0_, image0_.TITLE as TITLE0_, image0_.DESCRIPTION as DESCRIPT3_0_, image0_.LOCATION as LOCATION0_, image0_.LINK as LINK0_, image0_.WIDTH as WIDTH0_, image0_.HEIGHT as HEIGHT0_ from IMAGES image0_ where image0_.IMAGE_ID=?
Hibernate: select image0_.IMAGE_ID as IMAGE_ID0_, image0_.TITLE as TITLE0_, image0_.DESCRIPTION as DESCRIPT3_0_, image0_.LOCATION as LOCATION0_, image0_.LINK as LINK0_, image0_.WIDTH as WIDTH0_, image0_.HEIGHT as HEIGHT0_ from IMAGES image0_ where image0_.IMAGE_ID=?
Hibernate: select image0_.IMAGE_ID as IMAGE_ID0_, image0_.TITLE as TITLE0_, image0_.DESCRIPTION as DESCRIPT3_0_, image0_.LOCATION as LOCATION0_, image0_.LINK as LINK0_, image0_.WIDTH as WIDTH0_, image0_.HEIGHT as HEIGHT0_ from IMAGES image0_ where image0_.IMAGE_ID=?
Hibernate: select image0_.IMAGE_ID as IMAGE_ID0_, image0_.TITLE as TITLE0_, image0_.DESCRIPTION as DESCRIPT3_0_, image0_.LOCATION as LOCATION0_, image0_.LINK as LINK0_, image0_.WIDTH as WIDTH0_, image0_.HEIGHT as HEIGHT0_ from IMAGES image0_ where image0_.IMAGE_ID=?
Hibernate: select image0_.IMAGE_ID as IMAGE_ID0_, image0_.TITLE as TITLE0_, image0_.DESCRIPTION as DESCRIPT3_0_, image0_.LOCATION as LOCATION0_, image0_.LINK as LINK0_, image0_.WIDTH as WIDTH0_, image0_.HEIGHT as HEIGHT0_ from IMAGES image0_ where image0_.IMAGE_ID=?
Hibernate: select image0_.IMAGE_ID as IMAGE_ID0_, image0_.TITLE as TITLE0_, image0_.DESCRIPTION as DESCRIPT3_0_, image0_.LOCATION as LOCATION0_, image0_.LINK as LINK0_, image0_.WIDTH as WIDTH0_, image0_.HEIGHT as HEIGHT0_ from IMAGES image0_ where image0_.IMAGE_ID=?
Hibernate: select image0_.IMAGE_ID as IMAGE_ID0_, image0_.TITLE as TITLE0_, image0_.DESCRIPTION as DESCRIPT3_0_, image0_.LOCATION as LOCATION0_, image0_.LINK as LINK0_, image0_.WIDTH as WIDTH0_, image0_.HEIGHT as HEIGHT0_ from IMAGES image0_ where image0_.IMAGE_ID=?
Hibernate: select image0_.IMAGE_ID as IMAGE_ID0_, image0_.TITLE as TITLE0_, image0_.DESCRIPTION as DESCRIPT3_0_, image0_.LOCATION as LOCATION0_, image0_.LINK as LINK0_, image0_.WIDTH as WIDTH0_, image0_.HEIGHT as HEIGHT0_ from IMAGES image0_ where image0_.IMAGE_ID=?
Hibernate: select image0_.IMAGE_ID as IMAGE_ID0_, image0_.TITLE as TITLE0_, image0_.DESCRIPTION as DESCRIPT3_0_, image0_.LOCATION as LOCATION0_, image0_.LINK as LINK0_, image0_.WIDTH as WIDTH0_, image0_.HEIGHT as HEIGHT0_ from IMAGES image0_ where image0_.IMAGE_ID=?
Hibernate: select image0_.IMAGE_ID as IMAGE_ID0_, image0_.TITLE as TITLE0_, image0_.DESCRIPTION as DESCRIPT3_0_, image0_.LOCATION as LOCATION0_, image0_.LINK as LINK0_, image0_.WIDTH as WIDTH0_, image0_.HEIGHT as HEIGHT0_ from IMAGES image0_ where image0_.IMAGE_ID=?
Hibernate: select image0_.IMAGE_ID as IMAGE_ID0_, image0_.TITLE as TITLE0_, image0_.DESCRIPTION as DESCRIPT3_0_, image0_.LOCATION as LOCATION0_, image0_.LINK as LINK0_, image0_.WIDTH as WIDTH0_, image0_.HEIGHT as HEIGHT0_ from IMAGES image0_ where image0_.IMAGE_ID=?
Hibernate: select image0_.IMAGE_ID as IMAGE_ID0_, image0_.TITLE as TITLE0_, image0_.DESCRIPTION as DESCRIPT3_0_, image0_.LOCATION as LOCATION0_, image0_.LINK as LINK0_, image0_.WIDTH as WIDTH0_, image0_.HEIGHT as HEIGHT0_ from IMAGES image0_ where image0_.IMAGE_ID=?
Hibernate: select image0_.IMAGE_ID as IMAGE_ID0_, image0_.TITLE as TITLE0_, image0_.DESCRIPTION as DESCRIPT3_0_, image0_.LOCATION as LOCATION0_, image0_.LINK as LINK0_, image0_.WIDTH as WIDTH0_, image0_.HEIGHT as HEIGHT0_ from IMAGES image0_ where image0_.IMAGE_ID=?
Hibernate: select image0_.IMAGE_ID as IMAGE_ID0_, image0_.TITLE as TITLE0_, image0_.DESCRIPTION as DESCRIPT3_0_, image0_.LOCATION as LOCATION0_, image0_.LINK as LINK0_, image0_.WIDTH as WIDTH0_, image0_.HEIGHT as HEIGHT0_ from IMAGES image0_ where image0_.IMAGE_ID=?
Hibernate: select image0_.IMAGE_ID as IMAGE_ID0_, image0_.TITLE as TITLE0_, image0_.DESCRIPTION as DESCRIPT3_0_, image0_.LOCATION as LOCATION0_, image0_.LINK as LINK0_, image0_.WIDTH as WIDTH0_, image0_.HEIGHT as HEIGHT0_ from IMAGES image0_ where image0_.IMAGE_ID=?
Hibernate: select image0_.IMAGE_ID as IMAGE_ID0_, image0_.TITLE as TITLE0_, image0_.DESCRIPTION as DESCRIPT3_0_, image0_.LOCATION as LOCATION0_, image0_.LINK as LINK0_, image0_.WIDTH as WIDTH0_, image0_.HEIGHT as HEIGHT0_ from IMAGES image0_ where image0_.IMAGE_ID=?
Hibernate: select image0_.IMAGE_ID as IMAGE_ID0_, image0_.TITLE as TITLE0_, image0_.DESCRIPTION as DESCRIPT3_0_, image0_.LOCATION as LOCATION0_, image0_.LINK as LINK0_, image0_.WIDTH as WIDTH0_, image0_.HEIGHT as HEIGHT0_ from IMAGES image0_ where image0_.IMAGE_ID=?
Hibernate: select image0_.IMAGE_ID as IMAGE_ID0_, image0_.TITLE as TITLE0_, image0_.DESCRIPTION as DESCRIPT3_0_, image0_.LOCATION as LOCATION0_, image0_.LINK as LINK0_, image0_.WIDTH as WIDTH0_, image0_.HEIGHT as HEIGHT0_ from IMAGES image0_ where image0_.IMAGE_ID=?
Hibernate: select image0_.IMAGE_ID as IMAGE_ID0_, image0_.TITLE as TITLE0_, image0_.DESCRIPTION as DESCRIPT3_0_, image0_.LOCATION as LOCATION0_, image0_.LINK as LINK0_, image0_.WIDTH as WIDTH0_, image0_.HEIGHT as HEIGHT0_ from IMAGES image0_ where image0_.IMAGE_ID=?
Hibernate: select image0_.IMAGE_ID as IMAGE_ID0_, image0_.TITLE as TITLE0_, image0_.DESCRIPTION as DESCRIPT3_0_, image0_.LOCATION as LOCATION0_, image0_.LINK as LINK0_, image0_.WIDTH as WIDTH0_, image0_.HEIGHT as HEIGHT0_ from IMAGES image0_ where image0_.IMAGE_ID=?
Hibernate: select image0_.IMAGE_ID as IMAGE_ID0_, image0_.TITLE as TITLE0_, image0_.DESCRIPTION as DESCRIPT3_0_, image0_.LOCATION as LOCATION0_, image0_.LINK as LINK0_, image0_.WIDTH as WIDTH0_, image0_.HEIGHT as HEIGHT0_ from IMAGES image0_ where image0_.IMAGE_ID=?
Hibernate: select image0_.IMAGE_ID as IMAGE_ID0_, image0_.TITLE as TITLE0_, image0_.DESCRIPTION as DESCRIPT3_0_, image0_.LOCATION as LOCATION0_, image0_.LINK as LINK0_, image0_.WIDTH as WIDTH0_, image0_.HEIGHT as HEIGHT0_ from IMAGES image0_ where image0_.IMAGE_ID=?
Hibernate: select image0_.IMAGE_ID as IMAGE_ID0_, image0_.TITLE as TITLE0_, image0_.DESCRIPTION as DESCRIPT3_0_, image0_.LOCATION as LOCATION0_, image0_.LINK as LINK0_, image0_.WIDTH as WIDTH0_, image0_.HEIGHT as HEIGHT0_ from IMAGES image0_ where image0_.IMAGE_ID=?
Hibernate: select image0_.IMAGE_ID as IMAGE_ID0_, image0_.TITLE as TITLE0_, image0_.DESCRIPTION as DESCRIPT3_0_, image0_.LOCATION as LOCATION0_, image0_.LINK as LINK0_, image0_.WIDTH as WIDTH0_, image0_.HEIGHT as HEIGHT0_ from IMAGES image0_ where image0_.IMAGE_ID=?
Hibernate: select image0_.IMAGE_ID as IMAGE_ID0_, image0_.TITLE as TITLE0_, image0_.DESCRIPTION as DESCRIPT3_0_, image0_.LOCATION as LOCATION0_, image0_.LINK as LINK0_, image0_.WIDTH as WIDTH0_, image0_.HEIGHT as HEIGHT0_ from IMAGES image0_ where image0_.IMAGE_ID=?
Hibernate: select image0_.IMAGE_ID as IMAGE_ID0_, image0_.TITLE as TITLE0_, image0_.DESCRIPTION as DESCRIPT3_0_, image0_.LOCATION as LOCATION0_, image0_.LINK as LINK0_, image0_.WIDTH as WIDTH0_, image0_.HEIGHT as HEIGHT0_ from IMAGES image0_ where image0_.IMAGE_ID=?
Hibernate: select image0_.IMAGE_ID as IMAGE_ID0_, image0_.TITLE as TITLE0_, image0_.DESCRIPTION as DESCRIPT3_0_, image0_.LOCATION as LOCATION0_, image0_.LINK as LINK0_, image0_.WIDTH as WIDTH0_, image0_.HEIGHT as HEIGHT0_ from IMAGES image0_ where image0_.IMAGE_ID=?
Hibernate: select image0_.IMAGE_ID as IMAGE_ID0_, image0_.TITLE as TITLE0_, image0_.DESCRIPTION as DESCRIPT3_0_, image0_.LOCATION as LOCATION0_, image0_.LINK as LINK0_, image0_.WIDTH as WIDTH0_, image0_.HEIGHT as HEIGHT0_ from IMAGES image0_ where image0_.IMAGE_ID=?
Hibernate: select image0_.IMAGE_ID as IMAGE_ID0_, image0_.TITLE as TITLE0_, image0_.DESCRIPTION as DESCRIPT3_0_, image0_.LOCATION as LOCATION0_, image0_.LINK as LINK0_, image0_.WIDTH as WIDTH0_, image0_.HEIGHT as HEIGHT0_ from IMAGES image0_ where image0_.IMAGE_ID=?
Hibernate: select items0_.CHANNEL_ID as CHANNEL_ID__, items0_.ITEM_ID as ITEM_ID__, items0_.ITEM_ID as ITEM_ID3_, items0_.CHANNEL_ID as CHANNEL_ID3_, items0_.TITLE as TITLE3_, items0_.DESCRIPTION as DESCRIPT4_3_, items0_.UNREAD as UNREAD3_, items0_.LINK as LINK3_, items0_.CREATOR as CREATOR3_, items0_.SUBJECT as SUBJECT3_, items0_.DATE as DATE3_, items0_.FOUND as FOUND3_, items0_.GUID as GUID3_, items0_.COMMENTS as COMMENTS3_, items0_.SOURCE as SOURCE3_, items0_.ENCLOSURE as ENCLOSURE3_, itemguid1_.ITEM_GUID_ID as ITEM_GUI1_0_, itemguid1_.ITEM_ID as ITEM_ID0_, itemguid1_.LOCATION as LOCATION0_, itemguid1_.PERMA_LINK as PERMA_LINK0_, itemsource2_.ITEM_SOURCE_ID as ITEM_SOU1_1_, itemsource2_.ITEM_ID as ITEM_ID1_, itemsource2_.NAME as NAME1_, itemsource2_.LOCATION as LOCATION1_, itemsource2_.TIMESTAMP as TIMESTAMP1_, itemenclos3_.ITEM_ENCLOSURE_ID as ITEM_ENC1_2_, itemenclos3_.ITEM_ID as ITEM_ID2_, itemenclos3_.LOCATION as LOCATION2_, itemenclos3_.TYPE as TYPE2_, itemenclos3_.LENGTH as LENGTH2_ from ITEMS items0_ left outer join ITEM_GUID itemguid1_ on items0_.GUID=itemguid1_.ITEM_GUID_ID left outer join ITEM_SOURCE itemsource2_ on items0_.SOURCE=itemsource2_.ITEM_SOURCE_ID left outer join ITEM_ENCLOSURE itemenclos3_ on items0_.ENCLOSURE=itemenclos3_.ITEM_ENCLOSURE_ID where items0_.CHANNEL_ID=?
Hibernate: select items0_.CHANNEL_ID as CHANNEL_ID__, items0_.ITEM_ID as ITEM_ID__, items0_.ITEM_ID as ITEM_ID3_, items0_.CHANNEL_ID as CHANNEL_ID3_, items0_.TITLE as TITLE3_, items0_.DESCRIPTION as DESCRIPT4_3_, items0_.UNREAD as UNREAD3_, items0_.LINK as LINK3_, items0_.CREATOR as CREATOR3_, items0_.SUBJECT as SUBJECT3_, items0_.DATE as DATE3_, items0_.FOUND as FOUND3_, items0_.GUID as GUID3_, items0_.COMMENTS as COMMENTS3_, items0_.SOURCE as SOURCE3_, items0_.ENCLOSURE as ENCLOSURE3_, itemguid1_.ITEM_GUID_ID as ITEM_GUI1_0_, itemguid1_.ITEM_ID as ITEM_ID0_, itemguid1_.LOCATION as LOCATION0_, itemguid1_.PERMA_LINK as PERMA_LINK0_, itemsource2_.ITEM_SOURCE_ID as ITEM_SOU1_1_, itemsource2_.ITEM_ID as ITEM_ID1_, itemsource2_.NAME as NAME1_, itemsource2_.LOCATION as LOCATION1_, itemsource2_.TIMESTAMP as TIMESTAMP1_, itemenclos3_.ITEM_ENCLOSURE_ID as ITEM_ENC1_2_, itemenclos3_.ITEM_ID as ITEM_ID2_, itemenclos3_.LOCATION as LOCATION2_, itemenclos3_.TYPE as TYPE2_, itemenclos3_.LENGTH as LENGTH2_ from ITEMS items0_ left outer join ITEM_GUID itemguid1_ on items0_.GUID=itemguid1_.ITEM_GUID_ID left outer join ITEM_SOURCE itemsource2_ on items0_.SOURCE=itemsource2_.ITEM_SOURCE_ID left outer join ITEM_ENCLOSURE itemenclos3_ on items0_.ENCLOSURE=itemenclos3_.ITEM_ENCLOSURE_ID where items0_.CHANNEL_ID=?
Hibernate: select items0_.CHANNEL_ID as CHANNEL_ID__, items0_.ITEM_ID as ITEM_ID__, items0_.ITEM_ID as ITEM_ID3_, items0_.CHANNEL_ID as CHANNEL_ID3_, items0_.TITLE as TITLE3_, items0_.DESCRIPTION as DESCRIPT4_3_, items0_.UNREAD as UNREAD3_, items0_.LINK as LINK3_, items0_.CREATOR as CREATOR3_, items0_.SUBJECT as SUBJECT3_, items0_.DATE as DATE3_, items0_.FOUND as FOUND3_, items0_.GUID as GUID3_, items0_.COMMENTS as COMMENTS3_, items0_.SOURCE as SOURCE3_, items0_.ENCLOSURE as ENCLOSURE3_, itemguid1_.ITEM_GUID_ID as ITEM_GUI1_0_, itemguid1_.ITEM_ID as ITEM_ID0_, itemguid1_.LOCATION as LOCATION0_, itemguid1_.PERMA_LINK as PERMA_LINK0_, itemsource2_.ITEM_SOURCE_ID as ITEM_SOU1_1_, itemsource2_.ITEM_ID as ITEM_ID1_, itemsource2_.NAME as NAME1_, itemsource2_.LOCATION as LOCATION1_, itemsource2_.TIMESTAMP as TIMESTAMP1_, itemenclos3_.ITEM_ENCLOSURE_ID as ITEM_ENC1_2_, itemenclos3_.ITEM_ID as ITEM_ID2_, itemenclos3_.LOCATION as LOCATION2_, itemenclos3_.TYPE as TYPE2_, itemenclos3_.LENGTH as LENGTH2_ from ITEMS items0_ left outer join ITEM_GUID itemguid1_ on items0_.GUID=itemguid1_.ITEM_GUID_ID left outer join ITEM_SOURCE itemsource2_ on items0_.SOURCE=itemsource2_.ITEM_SOURCE_ID left outer join ITEM_ENCLOSURE itemenclos3_ on items0_.ENCLOSURE=itemenclos3_.ITEM_ENCLOSURE_ID where items0_.CHANNEL_ID=?
Debug level Hibernate log excerpt:
|