hi, reversed a new db and can't seem to do a get. i get:
01:23:01,343 DEBUG BatcherImpl:196 - about to open: 0 open PreparedStatements, 0 open ResultSets
01:23:01,343 DEBUG SQL:237 - select asnmessage0_.db_id as db_id0_, asnmessage0_.asn_id as asn_id0_, asnmessage0_.asn_num as asn_num0_, asnmessage0_.booking_num as booking_4_0_, asnmessage0_.ref_num as ref_num0_, asnmessage0_.date as date0_, asnmessage0_.when_modified as when_mod7_0_, asnmessage0_.who_modified as who_modi8_0_ from asn_message asnmessage0_ where asnmessage0_.db_id=?
Hibernate: select asnmessage0_.db_id as db_id0_, asnmessage0_.asn_id as asn_id0_, asnmessage0_.asn_num as asn_num0_, asnmessage0_.booking_num as booking_4_0_, asnmessage0_.ref_num as ref_num0_, asnmessage0_.date as date0_, asnmessage0_.when_modified as when_mod7_0_, asnmessage0_.who_modified as who_modi8_0_ from asn_message asnmessage0_ where asnmessage0_.db_id=?
01:23:01,359 DEBUG BatcherImpl:241 - preparing statement
caught: java.lang.ClassCastException
java.lang.ClassCastException
at net.sf.hibernate.type.IntegerType.set(IntegerType.java:31)
at net.sf.hibernate.type.NullableType.nullSafeSet(NullableType.java:48)
(full log is below)
the code (see below) has worked doing a get for a field from another reversed db.
any pointers will be appreciated.
thanks.
// import java.util.*;
import net.sf.hibernate.*;
import net.sf.hibernate.cfg.*;
import fg1.hibernate.*;
//import net.sf.hibernate.expression.*;
public class Main {
public Main(final SessionFactory sessionFactory) {
this.sessionFactory = sessionFactory;
}
public void run() throws Exception {
net.sf.hibernate.Session s = null;
try {
s = sessionFactory.openSession();
Transaction t = s.beginTransaction();
System.err.println("trying to get"); System.err.flush();
Object o = s.get(AsnMessage.class, "LAX");
System.err.println("get returns: " + o);
if (true || o == null) {
Object o2 = s.load(AsnMessage.class, "LAX");
System.err.println("load returns: " + o2);
}
t.commit();
} catch (Exception e) {
System.err.println("caught: " + e);
e.printStackTrace();
} finally {
if (s != null)
s.close();
}
sessionFactory.close();
}
public static void main(String[] args) throws Exception {
Configuration cfg = new Configuration();
System.err.println("1");
for (int i = 0; i < dbClass.length; i++)
if (!dbClass[i].getName().endsWith("PK"))
cfg.addClass(dbClass[i]);
else System.err.println("omitting: "+dbClass[i]);
System.err.println("2");
//.setProperty(Environment.HBM2DDL_AUTO, "create");
//cfg.setProperty("hibernate.show_sql", "true");
final SessionFactory f = cfg.buildSessionFactory();
final Main main = new Main(cfg.buildSessionFactory());
System.err.println("3");
main.run();
}
private final SessionFactory sessionFactory;
private static final Class[] dbClass =
{
AsnMessage.class,
DatabaseHeader.class,
DatabaseType.class,
Entity.class,
EntityNum.class,
EntityRole.class,
Permission.class,
PoItem.class,
PoItemNum.class,PoItemNumPK.class,
PoItemOrdered.class,
PoItemShipped.class,
PoNew.class,
Report.class,
ReportRdv.class,
fg1.hibernate.Session.class,
UniqueId.class,
User.class };
}
01:22:53,968 INFO Environment:462 - Hibernate 2.1.2
01:22:54,000 INFO Environment:496 - loaded properties from resource hibernate.properties: {hibernate.connection.driver_class=org.gjt.mm.mysql.Driver, hibernate.cglib.use_reflection_optimizer=true, hibernate.cache.provider_class=net.sf.hibernate.cache.HashtableCacheProvider, hibernate.cache.use_query_cache=true, hibernate.max_fetch_depth=1, hibernate.dialect=net.sf.hibernate.dialect.MySQLDialect, hibernate.jdbc.use_streams_for_binary=true, hibernate.jdbc.batch_size=0, hibernate.query.substitutions=true 1, false 0, yes 'Y', no 'N', hibernate.proxool.pool_alias=pool1, hibernate.connection.username=root, hibernate.connection.url=jdbc:mysql://204.1.213.186:3306/geo_rtayek, hibernate.show_sql=true, hibernate.connection.password=, hibernate.connection.pool_size=1}
01:22:54,000 INFO Environment:518 - using java.io streams to persist binary types
01:22:54,000 INFO Environment:519 - using CGLIB reflection optimizer
01:22:54,015 INFO Configuration:329 - Mapping resource: fg1/hibernate/AsnMessage.hbm.xml
1
01:22:54,328 DEBUG DTDEntityResolver:20 - trying to locate
http://hibernate.sourceforge.net/hibern ... ng-2.0.dtd in classpath under net/sf/hibernate/
01:22:54,343 DEBUG DTDEntityResolver:29 - found
http://hibernate.sourceforge.net/hibern ... ng-2.0.dtd in classpath
01:22:54,765 INFO Binder:229 - Mapping class: fg1.hibernate.AsnMessage -> asn_message
01:22:55,093 DEBUG Binder:462 - Mapped property: dbId -> db_id, type: integer
01:22:55,140 DEBUG Binder:462 - Mapped property: asnId -> asn_id, type: string
01:22:55,156 DEBUG Binder:462 - Mapped property: asnNum -> asn_num, type: string
01:22:55,156 DEBUG Binder:462 - Mapped property: bookingNum -> booking_num, type: string
01:22:55,156 DEBUG Binder:462 - Mapped property: refNum -> ref_num, type: string
01:22:55,156 DEBUG Binder:462 - Mapped property: date -> date, type: date
01:22:55,156 DEBUG Binder:462 - Mapped property: whenModified -> when_modified, type: timestamp
01:22:55,156 DEBUG Binder:462 - Mapped property: whoModified -> who_modified, type: string
01:22:55,156 INFO Configuration:329 - Mapping resource: fg1/hibernate/DatabaseHeader.hbm.xml
01:22:55,171 DEBUG DTDEntityResolver:20 - trying to locate
http://hibernate.sourceforge.net/hibern ... ng-2.0.dtd in classpath under net/sf/hibernate/
01:22:55,171 DEBUG DTDEntityResolver:29 - found
http://hibernate.sourceforge.net/hibern ... ng-2.0.dtd in classpath
01:22:55,218 INFO Binder:229 - Mapping class: fg1.hibernate.DatabaseHeader -> database_header
01:22:55,218 DEBUG Binder:462 - Mapped property: dbId -> db_id, type: integer
01:22:55,218 DEBUG Binder:462 - Mapped property: variable -> variable, type: string
01:22:55,218 DEBUG Binder:462 - Mapped property: language -> language, type: string
01:22:55,218 DEBUG Binder:462 - Mapped property: keyname -> keyname, type: string
01:22:55,234 DEBUG Binder:462 - Mapped property: string -> string, type: string
01:22:55,234 DEBUG Binder:462 - Mapped property: whoModified -> who_modified, type: string
01:22:55,234 INFO Configuration:329 - Mapping resource: fg1/hibernate/DatabaseType.hbm.xml
01:22:55,343 DEBUG DTDEntityResolver:20 - trying to locate
http://hibernate.sourceforge.net/hibern ... ng-2.0.dtd in classpath under net/sf/hibernate/
01:22:55,359 DEBUG DTDEntityResolver:29 - found
http://hibernate.sourceforge.net/hibern ... ng-2.0.dtd in classpath
01:22:55,421 INFO Binder:229 - Mapping class: fg1.hibernate.DatabaseType -> database_type
01:22:55,421 DEBUG Binder:462 - Mapped property: dbId -> db_id, type: integer
01:22:55,421 DEBUG Binder:462 - Mapped property: variable -> variable, type: string
01:22:55,421 DEBUG Binder:462 - Mapped property: keyname -> keyname, type: string
01:22:55,421 DEBUG Binder:462 - Mapped property: string -> string, type: string
01:22:55,421 DEBUG Binder:462 - Mapped property: whoModified -> who_modified, type: string
01:22:55,421 INFO Configuration:329 - Mapping resource: fg1/hibernate/Entity.hbm.xml
01:22:55,500 DEBUG DTDEntityResolver:20 - trying to locate
http://hibernate.sourceforge.net/hibern ... ng-2.0.dtd in classpath under net/sf/hibernate/
01:22:55,500 DEBUG DTDEntityResolver:29 - found
http://hibernate.sourceforge.net/hibern ... ng-2.0.dtd in classpath
01:22:55,531 INFO Binder:229 - Mapping class: fg1.hibernate.Entity -> entity
01:22:55,531 DEBUG Binder:462 - Mapped property: dbId -> db_id, type: integer
01:22:55,531 DEBUG Binder:462 - Mapped property: entityId -> entity_id, type: string
01:22:55,531 DEBUG Binder:462 - Mapped property: entityType -> entity_type, type: string
01:22:55,531 DEBUG Binder:462 - Mapped property: limitOrderedById -> limit_ordered_by_id, type: string
01:22:55,531 DEBUG Binder:462 - Mapped property: limitBilltoNum -> limit_billto_num, type: string
01:22:55,531 DEBUG Binder:462 - Mapped property: limitCsgNum -> limit_csg_num, type: string
01:22:55,546 DEBUG Binder:462 - Mapped property: limitShpNum -> limit_shp_num, type: string
01:22:55,546 DEBUG Binder:462 - Mapped property: limitAgentNum -> limit_agent_num, type: string
01:22:55,546 DEBUG Binder:462 - Mapped property: entityName -> entity_name, type: string
01:22:55,546 DEBUG Binder:462 - Mapped property: contact -> contact, type: string
01:22:55,546 DEBUG Binder:462 - Mapped property: add1 -> add1, type: string
01:22:55,546 DEBUG Binder:462 - Mapped property: add2 -> add2, type: string
01:22:55,546 DEBUG Binder:462 - Mapped property: phone -> phone, type: string
01:22:55,546 DEBUG Binder:462 - Mapped property: fax -> fax, type: string
01:22:55,546 DEBUG Binder:462 - Mapped property: email -> email, type: string
01:22:55,546 DEBUG Binder:462 - Mapped property: city -> city, type: string
01:22:55,546 DEBUG Binder:462 - Mapped property: state -> state, type: string
01:22:55,546 DEBUG Binder:462 - Mapped property: zip -> zip, type: string
01:22:55,562 DEBUG Binder:462 - Mapped property: country -> country, type: string
01:22:55,562 DEBUG Binder:462 - Mapped property: itemRefEntId -> item_ref_ent_id, type: string
01:22:55,562 DEBUG Binder:462 - Mapped property: whoModified -> who_modified, type: string
01:22:55,562 DEBUG Binder:462 - Mapped property: whenModified -> when_modified, type: timestamp
01:22:55,562 DEBUG Binder:462 - Mapped property: whoCreated -> who_created, type: string
01:22:55,562 DEBUG Binder:462 - Mapped property: whenCreated -> when_created, type: timestamp
01:22:55,562 INFO Configuration:329 - Mapping resource: fg1/hibernate/EntityNum.hbm.xml
01:22:55,703 DEBUG DTDEntityResolver:20 - trying to locate
http://hibernate.sourceforge.net/hibern ... ng-2.0.dtd in classpath under net/sf/hibernate/
01:22:55,718 DEBUG DTDEntityResolver:29 - found
http://hibernate.sourceforge.net/hibern ... ng-2.0.dtd in classpath
01:22:55,765 INFO Binder:229 - Mapping class: fg1.hibernate.EntityNum -> entity_num
01:22:55,765 DEBUG Binder:462 - Mapped property: dbId -> db_id, type: integer
01:22:55,781 DEBUG Binder:462 - Mapped property: myEntId -> my_ent_id, type: string
01:22:55,781 DEBUG Binder:462 - Mapped property: PEntId -> p_ent_id, type: string
01:22:55,781 DEBUG Binder:462 - Mapped property: PEntRole -> p_ent_role, type: string
01:22:55,796 DEBUG Binder:462 - Mapped property: PEntNum -> p_ent_num, type: string
01:22:55,812 DEBUG Binder:462 - Mapped property: whoCreated -> who_created, type: string
01:22:55,812 DEBUG Binder:462 - Mapped property: whenCreated -> when_created, type: timestamp
01:22:55,828 DEBUG Binder:462 - Mapped property: whoModified -> who_modified, type: string
01:22:55,828 DEBUG Binder:462 - Mapped property: whenModified -> when_modified, type: timestamp
01:22:55,828 INFO Configuration:329 - Mapping resource: fg1/hibernate/EntityRole.hbm.xml
01:22:55,859 DEBUG DTDEntityResolver:20 - trying to locate
http://hibernate.sourceforge.net/hibern ... ng-2.0.dtd in classpath under net/sf/hibernate/
01:22:55,875 DEBUG DTDEntityResolver:29 - found
http://hibernate.sourceforge.net/hibern ... ng-2.0.dtd in classpath
01:22:55,953 INFO Binder:229 - Mapping class: fg1.hibernate.EntityRole -> entity_role
01:22:55,953 DEBUG Binder:462 - Mapped property: roleId -> role_id, type: string
01:22:55,953 DEBUG Binder:462 - Mapped property: roleName -> role_name, type: string
01:22:55,953 DEBUG Binder:462 - Mapped property: description -> description, type: string
01:22:55,953 DEBUG Binder:462 - Mapped property: whoCreated -> who_created, type: string
01:22:55,953 DEBUG Binder:462 - Mapped property: whenCreated -> when_created, type: timestamp
01:22:55,953 DEBUG Binder:462 - Mapped property: whoModified -> who_modified, type: string
01:22:55,953 DEBUG Binder:462 - Mapped property: whenModified -> when_modified, type: timestamp
01:22:55,968 INFO Configuration:329 - Mapping resource: fg1/hibernate/Permission.hbm.xml
01:22:56,093 DEBUG DTDEntityResolver:20 - trying to locate
http://hibernate.sourceforge.net/hibern ... ng-2.0.dtd in classpath under net/sf/hibernate/
01:22:56,093 DEBUG DTDEntityResolver:29 - found
http://hibernate.sourceforge.net/hibern ... ng-2.0.dtd in classpath
01:22:56,140 INFO Binder:229 - Mapping class: fg1.hibernate.Permission -> permission
01:22:56,140 DEBUG Binder:462 - Mapped property: permissionId -> permission_id, type: string
01:22:56,140 DEBUG Binder:462 - Mapped property: description -> description, type: string
01:22:56,140 INFO Configuration:329 - Mapping resource: fg1/hibernate/PoItem.hbm.xml
01:22:56,156 DEBUG DTDEntityResolver:20 - trying to locate
http://hibernate.sourceforge.net/hibern ... ng-2.0.dtd in classpath under net/sf/hibernate/
01:22:56,171 DEBUG DTDEntityResolver:29 - found
http://hibernate.sourceforge.net/hibern ... ng-2.0.dtd in classpath
01:22:56,187 INFO Binder:229 - Mapping class: fg1.hibernate.PoItem -> po_item
01:22:56,187 DEBUG Binder:462 - Mapped property: dbId -> db_id, type: integer
01:22:56,187 DEBUG Binder:462 - Mapped property: itemId -> item_id, type: string
01:22:56,187 DEBUG Binder:462 - Mapped property: itemName -> item_name, type: string
01:22:56,187 DEBUG Binder:462 - Mapped property: weightGrossUnit -> weight_gross_unit, type: string
01:22:56,187 DEBUG Binder:462 - Mapped property: weightGross -> weight_gross, type: big_decimal
01:22:56,187 DEBUG Binder:462 - Mapped property: weightNetUnit -> weight_net_unit, type: string
01:22:56,203 DEBUG Binder:462 - Mapped property: weightNet -> weight_net, type: big_decimal
01:22:56,203 DEBUG Binder:462 - Mapped property: volumeUnit -> volume_unit, type: string
01:22:56,203 DEBUG Binder:462 - Mapped property: volume -> volume, type: big_decimal
01:22:56,203 DEBUG Binder:462 - Mapped property: sku -> sku, type: string
01:22:56,203 DEBUG Binder:462 - Mapped property: upc -> upc, type: string
01:22:56,203 DEBUG Binder:462 - Mapped property: quantityUnit -> quantity_unit, type: string
01:22:56,203 DEBUG Binder:462 - Mapped property: quantity -> quantity, type: big_decimal
01:22:56,203 DEBUG Binder:462 - Mapped property: brand -> brand, type: string
01:22:56,203 DEBUG Binder:462 - Mapped property: description -> description, type: string
01:22:56,203 DEBUG Binder:462 - Mapped property: whoCreated -> who_created, type: string
01:22:56,203 DEBUG Binder:462 - Mapped property: whenCreated -> when_created, type: timestamp
01:22:56,203 DEBUG Binder:462 - Mapped property: whoModified -> who_modified, type: string
01:22:56,203 DEBUG Binder:462 - Mapped property: whenModified -> when_modified, type: timestamp
01:22:56,203 INFO Configuration:329 - Mapping resource: fg1/hibernate/PoItemNum.hbm.xml
01:22:56,218 DEBUG DTDEntityResolver:20 - trying to locate
http://hibernate.sourceforge.net/hibern ... ng-2.0.dtd in classpath under net/sf/hibernate/
01:22:56,234 DEBUG DTDEntityResolver:29 - found
http://hibernate.sourceforge.net/hibern ... ng-2.0.dtd in classpath
01:22:56,250 INFO Binder:229 - Mapping class: fg1.hibernate.PoItemNum -> po_item_num
01:22:56,265 DEBUG Binder:462 - Mapped property: itemId -> item_id, type: string
01:22:56,265 DEBUG Binder:462 - Mapped property: itemNum -> item_num, type: string
01:22:56,265 DEBUG Binder:462 - Mapped property: itemRefEntId -> item_ref_ent_id, type: string
01:22:57,015 DEBUG Binder:462 - Mapped property: comp_id -> item_id, item_num, item_ref_ent_id, type: fg1.hibernate.PoItemNumPK
omitting: class fg1.hibernate.PoItemNumPK
01:22:57,015 DEBUG Binder:462 - Mapped property: whoCreated -> who_created, type: string
01:22:57,031 DEBUG Binder:462 - Mapped property: whenCreated -> when_created, type: timestamp
01:22:57,031 DEBUG Binder:462 - Mapped property: whoModified -> who_modified, type: string
01:22:57,031 DEBUG Binder:462 - Mapped property: whenModified -> when_modified, type: timestamp
01:22:57,031 INFO Configuration:329 - Mapping resource: fg1/hibernate/PoItemOrdered.hbm.xml
01:22:57,046 DEBUG DTDEntityResolver:20 - trying to locate
http://hibernate.sourceforge.net/hibern ... ng-2.0.dtd in classpath under net/sf/hibernate/
01:22:57,046 DEBUG DTDEntityResolver:29 - found
http://hibernate.sourceforge.net/hibern ... ng-2.0.dtd in classpath
01:22:57,062 INFO Binder:229 - Mapping class: fg1.hibernate.PoItemOrdered -> po_item_ordered
01:22:57,062 DEBUG Binder:462 - Mapped property: dbId -> db_id, type: integer
01:22:57,062 DEBUG Binder:462 - Mapped property: poId -> po_id, type: string
01:22:57,062 DEBUG Binder:462 - Mapped property: poNum -> po_num, type: string
01:22:57,062 DEBUG Binder:462 - Mapped property: orderedById -> ordered_by_id, type: string
01:22:57,062 DEBUG Binder:462 - Mapped property: deliverToId -> deliver_to_id, type: string
01:22:57,062 DEBUG Binder:462 - Mapped property: deliverToRef -> deliver_to_ref, type: string
01:22:57,078 DEBUG Binder:462 - Mapped property: lineNum -> line_num, type: integer
01:22:57,078 DEBUG Binder:462 - Mapped property: poSuffix -> po_suffix, type: string
01:22:57,078 DEBUG Binder:462 - Mapped property: itemId -> item_id, type: string
01:22:57,078 DEBUG Binder:462 - Mapped property: quantityOrdered -> quantity_ordered, type: big_decimal
01:22:57,078 DEBUG Binder:462 - Mapped property: quantityShipped -> quantity_shipped, type: big_decimal
01:22:57,078 DEBUG Binder:462 - Mapped property: shpDt -> shp_dt, type: date
01:22:57,078 DEBUG Binder:462 - Mapped property: hbNum -> hb_num, type: string
01:22:57,078 DEBUG Binder:462 - Mapped property: shipmentId -> shipment_id, type: string
01:22:57,078 DEBUG Binder:462 - Mapped property: deliverBy -> deliver_by, type: date
01:22:57,078 DEBUG Binder:462 - Mapped property: latestShpDt -> latest_shp_dt, type: date
01:22:57,078 DEBUG Binder:462 - Mapped property: earliestShpDt -> earliest_shp_dt, type: date
01:22:57,078 DEBUG Binder:462 - Mapped property: whoCreated -> who_created, type: string
01:22:57,078 DEBUG Binder:462 - Mapped property: whenModified -> when_modified, type: timestamp
01:22:57,078 DEBUG Binder:462 - Mapped property: whoModified -> who_modified, type: string
01:22:57,078 DEBUG Binder:462 - Mapped property: whenCreated -> when_created, type: timestamp
01:22:57,078 DEBUG Binder:462 - Mapped property: unitPrice -> unit_price, type: string
01:22:57,078 DEBUG Binder:462 - Mapped property: unitPriceCurrency -> unit_price_currency, type: string
01:22:57,078 DEBUG Binder:462 - Mapped property: deliverToDepartment -> deliver_to_department, type: string
01:22:57,093 DEBUG Binder:462 - Mapped property: containerNum -> container_num, type: string
01:22:57,093 DEBUG Binder:462 - Mapped property: asnId -> asn_id, type: string
01:22:57,109 INFO Configuration:329 - Mapping resource: fg1/hibernate/PoItemShipped.hbm.xml
01:22:57,140 DEBUG DTDEntityResolver:20 - trying to locate
http://hibernate.sourceforge.net/hibern ... ng-2.0.dtd in classpath under net/sf/hibernate/
01:22:57,140 DEBUG DTDEntityResolver:29 - found
http://hibernate.sourceforge.net/hibern ... ng-2.0.dtd in classpath
01:22:57,156 INFO Binder:229 - Mapping class: fg1.hibernate.PoItemShipped -> po_item_shipped
01:22:57,156 DEBUG Binder:462 - Mapped property: poId -> po_id, type: string
01:22:57,156 DEBUG Binder:462 - Mapped property: poNum -> po_num, type: string
01:22:57,156 DEBUG Binder:462 - Mapped property: orderedById -> ordered_by_id, type: string
01:22:57,156 DEBUG Binder:462 - Mapped property: lineNum -> line_num, type: string
01:22:57,156 DEBUG Binder:462 - Mapped property: itemId -> item_id, type: string
01:22:57,156 DEBUG Binder:462 - Mapped property: poSuffix -> po_suffix, type: string
01:22:57,156 DEBUG Binder:462 - Mapped property: deliverBy -> deliver_by, type: date
01:22:57,156 DEBUG Binder:462 - Mapped property: quantityShipped -> quantity_shipped, type: big_decimal
01:22:57,156 DEBUG Binder:462 - Mapped property: shpDt -> shp_dt, type: date
01:22:57,156 DEBUG Binder:462 - Mapped property: hbNum -> hb_num, type: string
01:22:57,156 DEBUG Binder:462 - Mapped property: whoCreated -> who_created, type: string
01:22:57,156 DEBUG Binder:462 - Mapped property: whenCreated -> when_created, type: timestamp
01:22:57,171 DEBUG Binder:462 - Mapped property: whoModified -> who_modified, type: string
01:22:57,171 DEBUG Binder:462 - Mapped property: whenModified -> when_modified, type: timestamp
01:22:57,203 INFO Configuration:329 - Mapping resource: fg1/hibernate/PoNew.hbm.xml
01:22:57,343 DEBUG DTDEntityResolver:20 - trying to locate
http://hibernate.sourceforge.net/hibern ... ng-2.0.dtd in classpath under net/sf/hibernate/
01:22:57,359 DEBUG DTDEntityResolver:29 - found
http://hibernate.sourceforge.net/hibern ... ng-2.0.dtd in classpath
01:22:57,406 INFO Binder:229 - Mapping class: fg1.hibernate.PoNew -> po_new
01:22:57,406 DEBUG Binder:462 - Mapped property: dbId -> db_id, type: integer
01:22:57,406 DEBUG Binder:462 - Mapped property: poId -> po_id, type: string
01:22:57,406 DEBUG Binder:462 - Mapped property: poNum -> po_num, type: string
01:22:57,406 DEBUG Binder:462 - Mapped property: orderedById -> ordered_by_id, type: string
01:22:57,406 DEBUG Binder:462 - Mapped property: vendorId -> vendor_id, type: string
01:22:57,406 DEBUG Binder:462 - Mapped property: subVendorId -> sub_vendor_id, type: string
01:22:57,406 DEBUG Binder:462 - Mapped property: projectId -> project_id, type: string
01:22:57,406 DEBUG Binder:462 - Mapped property: vendorRef -> vendor_ref, type: string
01:22:57,406 DEBUG Binder:462 - Mapped property: closedDate -> closed_date, type: date
01:22:57,406 DEBUG Binder:462 - Mapped property: poSuffix -> po_suffix, type: string
01:22:57,406 DEBUG Binder:462 - Mapped property: whoCreated -> who_created, type: string
01:22:57,406 DEBUG Binder:462 - Mapped property: whenCreated -> when_created, type: timestamp
01:22:57,406 DEBUG Binder:462 - Mapped property: whoModified -> who_modified, type: string
01:22:57,406 DEBUG Binder:462 - Mapped property: whenModified -> when_modified, type: timestamp
01:22:57,421 DEBUG Binder:462 - Mapped property: poDate -> po_date, type: date
01:22:57,421 DEBUG Binder:462 - Mapped property: orderedByRef -> ordered_by_ref, type: string
01:22:57,421 DEBUG Binder:462 - Mapped property: remarks -> remarks, type: string
01:22:57,421 INFO Configuration:329 - Mapping resource: fg1/hibernate/Report.hbm.xml
01:22:57,578 DEBUG DTDEntityResolver:20 - trying to locate
http://hibernate.sourceforge.net/hibern ... ng-2.0.dtd in classpath under net/sf/hibernate/
01:22:57,593 DEBUG DTDEntityResolver:29 - found
http://hibernate.sourceforge.net/hibern ... ng-2.0.dtd in classpath
01:22:57,671 INFO Binder:229 - Mapping class: fg1.hibernate.Report -> report
01:22:57,671 DEBUG Binder:462 - Mapped property: dbId -> db_id, type: integer
01:22:57,671 DEBUG Binder:462 - Mapped property: userId -> user_id, type: string
01:22:57,671 DEBUG Binder:462 - Mapped property: reportId -> report_id, type: string
01:22:57,671 DEBUG Binder:462 - Mapped property: title -> title, type: string
01:22:57,671 DEBUG Binder:462 - Mapped property: tablenames -> tablenames, type: string
01:22:57,671 DEBUG Binder:462 - Mapped property: queryDef -> query_def, type: string
01:22:57,671 DEBUG Binder:462 - Mapped property: summaryDef -> summary_def, type: string
01:22:57,671 DEBUG Binder:462 - Mapped property: detailDef -> detail_def, type: string
01:22:57,671 DEBUG Binder:462 - Mapped property: entryDef -> entry_def, type: string
01:22:57,671 DEBUG Binder:462 - Mapped property: sortByDef -> sort_by_def, type: string
01:22:57,671 DEBUG Binder:462 - Mapped property: preEntryDef -> pre_entry_def, type: string
01:22:57,671 DEBUG Binder:462 - Mapped property: preSaveDef -> pre_save_def, type: string
01:22:57,671 DEBUG Binder:462 - Mapped property: dbKey -> db_key, type: string
01:22:57,671 DEBUG Binder:462 - Mapped property: flags -> flags, type: string
01:22:57,671 DEBUG Binder:462 - Mapped property: headerFrequency -> header_frequency, type: integer
01:22:57,671 DEBUG Binder:462 - Mapped property: recordsPerPage -> records_per_page, type: integer
01:22:57,671 DEBUG Binder:462 - Mapped property: sortFieldsNum -> sort_fields_num, type: integer
01:22:57,687 DEBUG Binder:462 - Mapped property: whoModified -> who_modified, type: string
01:22:57,687 DEBUG Binder:462 - Mapped property: whenModified -> when_modified, type: timestamp
01:22:57,687 DEBUG Binder:462 - Mapped property: joinDef -> join_def, type: string
01:22:57,687 DEBUG Binder:462 - Mapped property: preQueryDef -> pre_query_def, type: string
01:22:57,687 DEBUG Binder:462 - Mapped property: sqlDef -> sql_def, type: string
01:22:57,687 DEBUG Binder:462 - Mapped property: downloadDef -> download_def, type: string
01:22:57,687 DEBUG Binder:462 - Mapped property: nextTemplate -> next_template, type: string
01:22:57,687 DEBUG Binder:462 - Mapped property: tabledef -> tabledef, type: string
01:22:57,687 DEBUG Binder:462 - Mapped property: groupByDef -> group_by_def, type: string
01:22:57,687 DEBUG Binder:462 - Mapped property: permission -> permission, type: string
01:22:57,687 DEBUG Binder:462 - Mapped property: module -> module, type: string
01:22:57,687 DEBUG Binder:462 - Mapped property: remark -> remark, type: string
01:22:57,687 DEBUG Binder:462 - Mapped property: postSaveDef -> post_save_def, type: string
01:22:57,687 DEBUG Binder:462 - Mapped property: remarks -> remarks, type: string
01:22:57,687 DEBUG Binder:462 - Mapped property: summaryTemplate -> summary_template, type: string
01:22:57,687 DEBUG Binder:462 - Mapped property: detailTemplate -> detail_template, type: string
01:22:57,687 DEBUG Binder:462 - Mapped property: searchTemplate -> search_template, type: string
01:22:57,687 DEBUG Binder:462 - Mapped property: entryTemplate -> entry_template, type: string
01:22:57,687 DEBUG Binder:462 - Mapped property: downloadTemplate -> download_template, type: string
01:22:57,687 DEBUG Binder:462 - Mapped property: formValidationScripts -> form_validation_scripts, type: string
01:22:57,687 DEBUG Binder:462 - Mapped property: queryDefAdv -> query_def_adv, type: string
01:22:57,703 INFO Configuration:329 - Mapping resource: fg1/hibernate/ReportRdv.hbm.xml
01:22:57,812 DEBUG DTDEntityResolver:20 - trying to locate
http://hibernate.sourceforge.net/hibern ... ng-2.0.dtd in classpath under net/sf/hibernate/
01:22:57,828 DEBUG DTDEntityResolver:29 - found
http://hibernate.sourceforge.net/hibern ... ng-2.0.dtd in classpath
01:22:57,890 INFO Binder:229 - Mapping class: fg1.hibernate.ReportRdv -> report_rdv
01:22:57,890 DEBUG Binder:462 - Mapped property: dbId -> db_id, type: integer
01:22:57,890 DEBUG Binder:462 - Mapped property: reportId -> report_id, type: string
01:22:57,890 DEBUG Binder:462 - Mapped property: tableName -> table_name, type: string
01:22:57,890 DEBUG Binder:462 - Mapped property: roleId -> role_id, type: string
01:22:57,890 DEBUG Binder:462 - Mapped property: rule -> rule, type: string
01:22:57,890 DEBUG Binder:462 - Mapped property: whoModified -> who_modified, type: string
01:22:57,890 DEBUG Binder:462 - Mapped property: whenModified -> when_modified, type: timestamp
01:22:57,890 INFO Configuration:329 - Mapping resource: fg1/hibernate/Session.hbm.xml
01:22:58,000 DEBUG DTDEntityResolver:20 - trying to locate
http://hibernate.sourceforge.net/hibern ... ng-2.0.dtd in classpath under net/sf/hibernate/
01:22:58,000 DEBUG DTDEntityResolver:29 - found
http://hibernate.sourceforge.net/hibern ... ng-2.0.dtd in classpath
01:22:58,015 INFO Binder:229 - Mapping class: fg1.hibernate.Session -> session
01:22:58,015 DEBUG Binder:462 - Mapped property: sessionId -> session_id, type: string
01:22:58,015 DEBUG Binder:462 - Mapped property: userid -> userid, type: string
01:22:58,015 DEBUG Binder:462 - Mapped property: remoteIp -> remote_ip, type: string
01:22:58,031 DEBUG Binder:462 - Mapped property: whenModified -> when_modified, type: timestamp
01:22:58,031 DEBUG Binder:462 - Mapped property: login -> login, type: timestamp
01:22:58,031 DEBUG Binder:462 - Mapped property: logout -> logout, type: timestamp
01:22:58,031 DEBUG Binder:462 - Mapped property: requests -> requests, type: integer
01:22:58,031 DEBUG Binder:462 - Mapped property: whenCreated -> when_created, type: timestamp
01:22:58,031 DEBUG Binder:462 - Mapped property: invalidated -> invalidated, type: timestamp
01:22:58,031 INFO Configuration:329 - Mapping resource: fg1/hibernate/UniqueId.hbm.xml
01:22:58,062 DEBUG DTDEntityResolver:20 - trying to locate
http://hibernate.sourceforge.net/hibern ... ng-2.0.dtd in classpath under net/sf/hibernate/
01:22:58,078 DEBUG DTDEntityResolver:29 - found
http://hibernate.sourceforge.net/hibern ... ng-2.0.dtd in classpath
01:22:58,140 INFO Binder:229 - Mapping class: fg1.hibernate.UniqueId -> _unique_ids
01:22:58,140 DEBUG Binder:462 - Mapped property: tableName -> table_name, type: string
01:22:58,140 DEBUG Binder:462 - Mapped property: sequenceNum -> sequence_num, type: long
01:22:58,140 DEBUG Binder:462 - Mapped property: prefix -> prefix, type: string
01:22:58,140 INFO Configuration:329 - Mapping resource: fg1/hibernate/User.hbm.xml
01:22:58,281 DEBUG DTDEntityResolver:20 - trying to locate
http://hibernate.sourceforge.net/hibern ... ng-2.0.dtd in classpath under net/sf/hibernate/
01:22:58,281 DEBUG DTDEntityResolver:29 - found
http://hibernate.sourceforge.net/hibern ... ng-2.0.dtd in classpath
01:22:58,343 INFO Binder:229 - Mapping class: fg1.hibernate.User -> user
01:22:58,343 DEBUG Binder:462 - Mapped property: dbId -> db_id, type: integer
01:22:58,343 DEBUG Binder:462 - Mapped property: userid -> userid, type: string
01:22:58,343 DEBUG Binder:462 - Mapped property: passwd -> passwd, type: string
01:22:58,343 DEBUG Binder:462 - Mapped property: roleId -> role_id, type: string
01:22:58,343 DEBUG Binder:462 - Mapped property: company -> company, type: string
01:22:58,343 DEBUG Binder:462 - Mapped property: name -> name, type: string
01:22:58,343 DEBUG Binder:462 - Mapped property: languageId -> language_id, type: string
01:22:58,343 DEBUG Binder:462 - Mapped property: active -> active, type: string
01:22:58,343 DEBUG Binder:462 - Mapped property: permissions -> permissions, type: string
01:22:58,343 DEBUG Binder:462 - Mapped property: groups -> groups, type: string
01:22:58,343 DEBUG Binder:462 - Mapped property: idNum -> id_num, type: string
01:22:58,359 DEBUG Binder:462 - Mapped property: agentNum -> agent_num, type: string
01:22:58,359 DEBUG Binder:462 - Mapped property: billtoNum -> billto_num, type: string
01:22:58,359 DEBUG Binder:462 - Mapped property: shpNum -> shp_num, type: string
01:22:58,359 DEBUG Binder:462 - Mapped property: csgNum -> csg_num, type: string
01:22:58,359 DEBUG Binder:462 - Mapped property: carrierNum -> carrier_num, type: string
01:22:58,359 DEBUG Binder:462 - Mapped property: notifypartyNum -> notifyparty_num, type: string
01:22:58,359 DEBUG Binder:462 - Mapped property: emailInfo -> email_info, type: string
01:22:58,359 DEBUG Binder:462 - Mapped property: eventlist -> eventlist, type: string
01:22:58,359 DEBUG Binder:462 - Mapped property: emailError -> email_error, type: string
01:22:58,359 DEBUG Binder:462 - Mapped property: queryStr -> query_str, type: string
01:22:58,359 DEBUG Binder:462 - Mapped property: agentRefPattern -> agent_ref_pattern, type: string
01:22:58,359 DEBUG Binder:462 - Mapped property: billtoRefPattern -> billto_ref_pattern, type: string
01:22:58,359 DEBUG Binder:462 - Mapped property: shpRefPattern -> shp_ref_pattern, type: string
01:22:58,359 DEBUG Binder:462 - Mapped property: csgRefPattern -> csg_ref_pattern, type: string
01:22:58,359 DEBUG Binder:462 - Mapped property: responsibleFor -> responsible_for, type: string
01:22:58,359 DEBUG Binder:462 - Mapped property: passwordTxt -> password_txt, type: string
01:22:58,359 DEBUG Binder:462 - Mapped property: whoModified -> who_modified, type: string
01:22:58,359 DEBUG Binder:462 - Mapped property: whenModified -> when_modified, type: timestamp
01:22:58,359 DEBUG Binder:462 - Mapped property: phone -> phone, type: string
01:22:58,359 DEBUG Binder:462 - Mapped property: fax -> fax, type: string
01:22:58,375 DEBUG Binder:462 - Mapped property: address -> address, type: string
01:22:58,375 DEBUG Binder:462 - Mapped property: address2 -> address2, type: string
01:22:58,375 DEBUG Binder:462 - Mapped property: city -> city, type: string
01:22:58,375 DEBUG Binder:462 - Mapped property: postalCode -> postal_code, type: string
01:22:58,375 DEBUG Binder:462 - Mapped property: orderedById -> ordered_by_id, type: string
01:22:58,375 DEBUG Binder:462 - Mapped property: vendorId -> vendor_id, type: string
2
01:22:58,375 DEBUG Binder:462 - Mapped property: irsNum -> irs_num, type: string
01:22:58,375 DEBUG Binder:462 - Mapped property: deliverToNum -> deliver_to_num, type: string
01:22:58,375 INFO Configuration:595 - processing one-to-many association mappings
01:22:58,375 INFO Configuration:604 - processing one-to-one association property references
01:22:58,375 INFO Configuration:629 - processing foreign key constraints
01:22:58,640 INFO Dialect:82 - Using dialect: net.sf.hibernate.dialect.MySQLDialect
01:22:58,640 INFO SettingsFactory:58 - Maximim outer join fetch depth: 1
01:22:58,640 INFO SettingsFactory:62 - Use outer join fetching: true
01:22:58,671 INFO DriverManagerConnectionProvider:41 - Using Hibernate built-in connection pool (not for production use!)
01:22:58,671 INFO DriverManagerConnectionProvider:42 - Hibernate connection pool size: 1
01:22:58,687 INFO DriverManagerConnectionProvider:71 - using driver: org.gjt.mm.mysql.Driver at URL: jdbc:mysql://204.1.213.186:3306/geo_rtayek
01:22:58,687 INFO DriverManagerConnectionProvider:72 - connection properties: {user=root, password=}
01:22:58,703 INFO TransactionManagerLookupFactory:33 - No TransactionManagerLookup configured (in JTA environment, use of process level read-write cache is not recommended)
01:22:58,703 DEBUG DriverManagerConnectionProvider:78 - total checked-out connections: 0
01:22:58,703 DEBUG DriverManagerConnectionProvider:94 - opening new JDBC connection
01:22:59,312 DEBUG DriverManagerConnectionProvider:100 - created connection to: jdbc:mysql://204.1.213.186:3306/geo_rtayek, Isolation Level: 4
01:22:59,312 DEBUG DriverManagerConnectionProvider:114 - returning connection to pool, pool size: 1
01:22:59,312 INFO SettingsFactory:102 - Use scrollable result sets: true
01:22:59,312 INFO SettingsFactory:105 - Use JDBC3 getGeneratedKeys(): true
01:22:59,312 INFO SettingsFactory:108 - Optimize cache for minimal puts: false
01:22:59,312 INFO SettingsFactory:114 - echoing all SQL to stdout
01:22:59,312 INFO SettingsFactory:117 - Query language substitutions: {no='N', true=1, yes='Y', false=0}
01:22:59,312 INFO SettingsFactory:128 - cache provider: net.sf.hibernate.cache.HashtableCacheProvider
01:22:59,328 INFO Configuration:1080 - instantiating and configuring caches
01:22:59,406 INFO SessionFactoryImpl:119 - building session factory
01:22:59,421 DEBUG SessionFactoryImpl:125 - instantiating session factory with properties: {java.runtime.name=Java(TM) 2 Runtime Environment, Standard Edition, hibernate.connection.password=, hibernate.cache.provider_class=net.sf.hibernate.cache.HashtableCacheProvider, sun.boot.library.path=C:\Program Files\Java\j2re1.4.2_03\bin, java.vm.version=1.4.2_03-b02, hibernate.proxool.pool_alias=pool1, hibernate.connection.username=root, java.vm.vendor=Sun Microsystems Inc., java.vendor.url=http://java.sun.com/, path.separator=;, hibernate.cache.use_query_cache=true, java.vm.name=Java HotSpot(TM) Client VM, file.encoding.pkg=sun.io, user.country=US, sun.os.patch.level=Service Pack 1, java.vm.specification.name=Java Virtual Machine Specification, user.dir=U:\projects\mg2, java.runtime.version=1.4.2_03-b02, java.awt.graphicsenv=sun.awt.Win32GraphicsEnvironment, java.endorsed.dirs=C:\Program Files\Java\j2re1.4.2_03\lib\endorsed, os.arch=x86, java.io.tmpdir=C:\DOCUME~1\rtayek\LOCALS~1\Temp\, line.separator=
, java.vm.specification.vendor=Sun Microsystems Inc., user.variant=, os.name=Windows XP, sun.java2d.fontpath=, java.library.path=C:\Program Files\Java\j2re1.4.2_03\bin;.;C:\WINDOWS\System32;C:\WINDOWS;u:\bin, java.specification.name=Java Platform API Specification, java.class.version=48.0, hibernate.connection.pool_size=1, java.util.prefs.PreferencesFactory=java.util.prefs.WindowsPreferencesFactory, os.version=5.1, user.home=C:\Documents and Settings\rtayek, user.timezone=America/Los_Angeles, java.awt.printerjob=sun.awt.windows.WPrinterJob, file.encoding=Cp1252, java.specification.version=1.4, hibernate.connection.driver_class=org.gjt.mm.mysql.Driver, java.class.path=U:\projects\mg2\bin;U:\projects\mg2\lib\hibernate2.jar;U:\projects\mg2\lib\dom4j-1.4.jar;U:\projects\mg2\lib\commons-logging-1.0.3.jar;U:\projects\mg2\lib\commons-collections-2.1.jar;U:\projects\mg2\lib\mysql.jar;U:\projects\mg2\lib\commons-lang-1.0.1.jar;U:\projects\mg2\lib\cglib-2.0-rc2.jar;U:\projects\mg2\lib\jta.jar;U:\projects\mg2\lib\log4j-1.2.8.jar, user.name=rtayek, hibernate.query.substitutions=true 1, false 0, yes 'Y', no 'N', hibernate.show_sql=true, java.vm.specification.version=1.0, java.home=C:\Program Files\Java\j2re1.4.2_03, sun.arch.data.model=32, hibernate.dialect=net.sf.hibernate.dialect.MySQLDialect, hibernate.connection.url=jdbc:mysql://204.1.213.186:3306/geo_rtayek, user.language=en, java.specification.vendor=Sun Microsystems Inc., awt.toolkit=sun.awt.windows.WToolkit, hibernate.cglib.use_reflection_optimizer=true, java.vm.info=mixed mode, hibernate.jdbc.use_streams_for_binary=true, java.version=1.4.2_03, java.ext.dirs=C:\Program Files\Java\j2re1.4.2_03\lib\ext, sun.boot.class.path=C:\Program Files\Java\j2re1.4.2_03\lib\rt.jar;C:\Program Files\Java\j2re1.4.2_03\lib\i18n.jar;C:\Program Files\Java\j2re1.4.2_03\lib\sunrsasign.jar;C:\Program Files\Java\j2re1.4.2_03\lib\jsse.jar;C:\Program Files\Java\j2re1.4.2_03\lib\jce.jar;C:\Program Files\Java\j2re1.4.2_03\lib\charsets.jar;C:\Program Files\Java\j2re1.4.2_03\classes, java.vendor=Sun Microsystems Inc., hibernate.jdbc.batch_size=0, file.separator=\, java.vendor.url.bug=http://java.sun.com/cgi-bin/bugreport.cgi, sun.io.unicode.encoding=UnicodeLittle, sun.cpu.endian=little, hibernate.max_fetch_depth=1, sun.cpu.isalist=pentium i486 i386}
01:23:00,484 DEBUG SessionFactoryObjectFactory:39 - initializing class SessionFactoryObjectFactory
01:23:00,500 DEBUG SessionFactoryObjectFactory:76 - registered: 4c815534fb48ae6200fb48ae66f40000 (unnamed)
01:23:00,500 INFO SessionFactoryObjectFactory:82 - no JNDI name configured
01:23:00,500 DEBUG SessionFactoryImpl:196 - instantiated session factory
01:23:00,500 INFO UpdateTimestampsCache:35 - starting update timestamps cache at region: net.sf.hibernate.cache.UpdateTimestampsCache
01:23:00,515 INFO QueryCache:39 - starting query cache at region: net.sf.hibernate.cache.QueryCache
01:23:00,515 INFO Configuration:595 - processing one-to-many association mappings
01:23:00,515 INFO Configuration:604 - processing one-to-one association property references
01:23:00,515 INFO Configuration:629 - processing foreign key constraints
01:23:00,515 INFO Dialect:82 - Using dialect: net.sf.hibernate.dialect.MySQLDialect
01:23:00,531 INFO SettingsFactory:58 - Maximim outer join fetch depth: 1
01:23:00,531 INFO SettingsFactory:62 - Use outer join fetching: true
01:23:00,531 INFO DriverManagerConnectionProvider:41 - Using Hibernate built-in connection pool (not for production use!)
01:23:00,531 INFO DriverManagerConnectionProvider:42 - Hibernate connection pool size: 1
01:23:00,531 INFO DriverManagerConnectionProvider:71 - using driver: org.gjt.mm.mysql.Driver at URL: jdbc:mysql://204.1.213.186:3306/geo_rtayek
01:23:00,531 INFO DriverManagerConnectionProvider:72 - connection properties: {user=root, password=}
01:23:00,531 INFO TransactionManagerLookupFactory:33 - No TransactionManagerLookup configured (in JTA environment, use of process level read-write cache is not recommended)
01:23:00,531 DEBUG DriverManagerConnectionProvider:78 - total checked-out connections: 0
01:23:00,531 DEBUG DriverManagerConnectionProvider:94 - opening new JDBC connection
01:23:00,703 DEBUG DriverManagerConnectionProvider:100 - created connection to: jdbc:mysql://204.1.213.186:3306/geo_rtayek, Isolation Level: 4
01:23:00,703 DEBUG DriverManagerConnectionProvider:114 - returning connection to pool, pool size: 1
01:23:00,703 INFO SettingsFactory:102 - Use scrollable result sets: true
01:23:00,703 INFO SettingsFactory:105 - Use JDBC3 getGeneratedKeys(): true
01:23:00,703 INFO SettingsFactory:108 - Optimize cache for minimal puts: false
01:23:00,703 INFO SettingsFactory:114 - echoing all SQL to stdout
01:23:00,703 INFO SettingsFactory:117 - Query language substitutions: {no='N', true=1, yes='Y', false=0}
01:23:00,703 INFO SettingsFactory:128 - cache provider: net.sf.hibernate.cache.HashtableCacheProvider
01:23:00,703 INFO Configuration:1080 - instantiating and configuring caches
01:23:00,703 INFO SessionFactoryImpl:119 - building session factory
01:23:00,703 DEBUG SessionFactoryImpl:125 - instantiating session factory with properties: {java.runtime.name=Java(TM) 2 Runtime Environment, Standard Edition, hibernate.connection.password=, hibernate.cache.provider_class=net.sf.hibernate.cache.HashtableCacheProvider, sun.boot.library.path=C:\Program Files\Java\j2re1.4.2_03\bin, java.vm.version=1.4.2_03-b02, hibernate.proxool.pool_alias=pool1, hibernate.connection.username=root, java.vm.vendor=Sun Microsystems Inc., java.vendor.url=http://java.sun.com/, path.separator=;, hibernate.cache.use_query_cache=true, java.vm.name=Java HotSpot(TM) Client VM, file.encoding.pkg=sun.io, user.country=US, sun.os.patch.level=Service Pack 1, java.vm.specification.name=Java Virtual Machine Specification, user.dir=U:\projects\mg2, java.runtime.version=1.4.2_03-b02, java.awt.graphicsenv=sun.awt.Win32GraphicsEnvironment, java.endorsed.dirs=C:\Program Files\Java\j2re1.4.2_03\lib\endorsed, os.arch=x86, java.io.tmpdir=C:\DOCUME~1\rtayek\LOCALS~1\Temp\, line.separator=
, java.vm.specification.vendor=Sun Microsystems Inc., user.variant=, os.name=Windows XP, sun.java2d.fontpath=, java.library.path=C:\Program Files\Java\j2re1.4.2_03\bin;.;C:\WINDOWS\System32;C:\WINDOWS;u:\bin, java.specification.name=Java Platform API Specification, java.class.version=48.0, hibernate.connection.pool_size=1, java.util.prefs.PreferencesFactory=java.util.prefs.WindowsPreferencesFactory, os.version=5.1, user.home=C:\Documents and Settings\rtayek, user.timezone=America/Los_Angeles, java.awt.printerjob=sun.awt.windows.WPrinterJob, file.encoding=Cp1252, java.specification.version=1.4, hibernate.connection.driver_class=org.gjt.mm.mysql.Driver, java.class.path=U:\projects\mg2\bin;U:\projects\mg2\lib\hibernate2.jar;U:\projects\mg2\lib\dom4j-1.4.jar;U:\projects\mg2\lib\commons-logging-1.0.3.jar;U:\projects\mg2\lib\commons-collections-2.1.jar;U:\projects\mg2\lib\mysql.jar;U:\projects\mg2\lib\commons-lang-1.0.1.jar;U:\projects\mg2\lib\cglib-2.0-rc2.jar;U:\projects\mg2\lib\jta.jar;U:\projects\mg2\lib\log4j-1.2.8.jar, user.name=rtayek, hibernate.query.substitutions=true 1, false 0, yes 'Y', no 'N', hibernate.show_sql=true, java.vm.specification.version=1.0, java.home=C:\Program Files\Java\j2re1.4.2_03, sun.arch.data.model=32, hibernate.dialect=net.sf.hibernate.dialect.MySQLDialect, hibernate.connection.url=jdbc:mysql://204.1.213.186:3306/geo_rtayek, user.language=en, java.specification.vendor=Sun Microsystems Inc., awt.toolkit=sun.awt.windows.WToolkit, hibernate.cglib.use_reflection_optimizer=true, java.vm.info=mixed mode, hibernate.jdbc.use_streams_for_binary=true, java.version=1.4.2_03, java.ext.dirs=C:\Program Files\Java\j2re1.4.2_03\lib\ext, sun.boot.class.path=C:\Program Files\Java\j2re1.4.2_03\lib\rt.jar;C:\Program Files\Java\j2re1.4.2_03\lib\i18n.jar;C:\Program Files\Java\j2re1.4.2_03\lib\sunrsasign.jar;C:\Program Files\Java\j2re1.4.2_03\lib\jsse.jar;C:\Program Files\Java\j2re1.4.2_03\lib\jce.jar;C:\Program Files\Java\j2re1.4.2_03\lib\charsets.jar;C:\Program Files\Java\j2re1.4.2_03\classes, java.vendor=Sun Microsystems Inc., hibernate.jdbc.batch_size=0, file.separator=\, java.vendor.url.bug=http://java.sun.com/cgi-bin/bugreport.cgi, sun.io.unicode.encoding=UnicodeLittle, sun.cpu.endian=little, hibernate.max_fetch_depth=1, sun.cpu.isalist=pentium i486 i386}
01:23:00,906 DEBUG SessionFactoryObjectFactory:76 - registered: 4c815534fb48ae6200fb48ae68aa0001 (unnamed)
01:23:00,906 INFO SessionFactoryObjectFactory:82 - no JNDI name configured
01:23:00,906 DEBUG SessionFactoryImpl:196 - instantiated session factory
01:23:00,906 INFO UpdateTimestampsCache:35 - starting update timestamps cache at region: net.sf.hibernate.cache.UpdateTimestampsCache
01:23:00,906 INFO QueryCache:39 - starting query cache at region: net.sf.hibernate.cache.QueryCache
3
01:23:01,328 DEBUG SessionImpl:531 - opened session
01:23:01,328 DEBUG JDBCTransaction:37 - begin
01:23:01,328 DEBUG DriverManagerConnectionProvider:78 - total checked-out connections: 0
trying to get
01:23:01,328 DEBUG DriverManagerConnectionProvider:84 - using pooled JDBC connection, pool size: 0
01:23:01,328 DEBUG JDBCTransaction:41 - current autocommit status:false
01:23:01,343 DEBUG SessionImpl:1950 - loading [fg1.hibernate.AsnMessage#LAX]
01:23:01,343 DEBUG SessionImpl:2047 - attempting to resolve [fg1.hibernate.AsnMessage#LAX]
01:23:01,343 DEBUG SessionImpl:2080 - object not resolved in any cache [fg1.hibernate.AsnMessage#LAX]
01:23:01,343 DEBUG EntityPersister:416 - Materializing entity: [fg1.hibernate.AsnMessage#LAX]
01:23:01,343 DEBUG BatcherImpl:196 - about to open: 0 open PreparedStatements, 0 open ResultSets
01:23:01,343 DEBUG SQL:237 - select asnmessage0_.db_id as db_id0_, asnmessage0_.asn_id as asn_id0_, asnmessage0_.asn_num as asn_num0_, asnmessage0_.booking_num as booking_4_0_, asnmessage0_.ref_num as ref_num0_, asnmessage0_.date as date0_, asnmessage0_.when_modified as when_mod7_0_, asnmessage0_.who_modified as who_modi8_0_ from asn_message asnmessage0_ where asnmessage0_.db_id=?
Hibernate: select asnmessage0_.db_id as db_id0_, asnmessage0_.asn_id as asn_id0_, asnmessage0_.asn_num as asn_num0_, asnmessage0_.booking_num as booking_4_0_, asnmessage0_.ref_num as ref_num0_, asnmessage0_.date as date0_, asnmessage0_.when_modified as when_mod7_0_, asnmessage0_.who_modified as who_modi8_0_ from asn_message asnmessage0_ where asnmessage0_.db_id=?
01:23:01,359 DEBUG BatcherImpl:241 - preparing statement
caught: java.lang.ClassCastException
java.lang.ClassCastException
at net.sf.hibernate.type.IntegerType.set(IntegerType.java:31)
at net.sf.hibernate.type.NullableType.nullSafeSet(NullableType.java:48)
at net.sf.hibernate.type.NullableType.nullSafeSet(NullableType.java:35)
at net.sf.hibernate.loader.Loader.bindPositionalParameters(Loader.java:674)
at net.sf.hibernate.loader.Loader.prepareQueryStatement(Loader.java:713)
at net.sf.hibernate.loader.Loader.doQuery(Loader.java:185)
at net.sf.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:133)
at net.sf.hibernate.loader.Loader.loadEntity(Loader.java:831)
at net.sf.hibernate.loader.Loader.loadEntity(Loader.java:851)
at net.sf.hibernate.loader.EntityLoader.load(EntityLoader.java:57)
at net.sf.hibernate.loader.EntityLoader.load(EntityLoader.java:49)
at net.sf.hibernate.persister.EntityPersister.load(EntityPersister.java:419)
at net.sf.hibernate.impl.SessionImpl.doLoad(SessionImpl.java:2081)
at net.sf.hibernate.impl.SessionImpl.doLoadByClass(SessionImpl.java:1955)
at net.sf.hibernate.impl.SessionImpl.get(SessionImpl.java:1891)
at Main.run(Main.java:16)
at Main.main(Main.java:46)
01:23:01,406 DEBUG SessionImpl:549 - closing session
01:23:01,406 DEBUG SessionImpl:3294 - disconnecting session
01:23:01,406 DEBUG BatcherImpl:203 - done closing: 0 open PreparedStatements, 0 open ResultSets
01:23:01,406 DEBUG BatcherImpl:261 - closing statement
01:23:01,406 DEBUG DriverManagerConnectionProvider:114 - returning connection to pool, pool size: 1
01:23:01,406 INFO SessionFactoryImpl:531 - closing
01:23:01,406 INFO DriverManagerConnectionProvider:137 - cleaning up connection pool: jdbc:mysql://204.1.213.186:3306/geo_rtayek