| I have to make the post shorter. Again:
 Hi all,
 
 Problem #1:
 I have some code which works fine on 2.0 .
 
 List newList = null;
 try {
 q =sess.getPersistentSession().createQuery(
 "from nemgmtinfo in class com.db.device.NEMgmtInfo");
 newList = q.list();
 } catch (HibernateException e) {
 throw new DAOException(e);
 }catch (Throwable e) {
 e.printStackTrace();
 }
 
 I am replacing the 2.0 version with 2.1 beta 5 and, for the same code I (surprisingly) get :
 
 10:59:13,765 INFO TransactionManagerLookupFactory:33 - No TransactionManagerLookup configured (use of process level read-write cache is not recommended)
 10:59:14,046 INFO SettingsFactory:89 - Use scrollable result sets: true
 10:59:14,046 INFO SettingsFactory:99 - Query language substitutions: {no='N', true=1, yes='Y', false=0}
 10:59:14,046 INFO SettingsFactory:110 - cache provider: net.sf.hibernate.cache.JCSCacheProvider
 10:59:14,046 INFO Configuration:990 - instantiating and configuring caches
 10:59:14,093 INFO SessionFactoryImpl:115 - building session factory
 10:59:17,312 INFO SessionFactoryObjectFactory:82 - no JNDI name configured
 10:59:17,375 INFO HibernateSession:48 - Session opened
 10:59:17,593 INFO HibernateSession:69 - Session closed
 10:59:17,609 INFO HibernateSession:48 - Session opened
 10:59:17,625 INFO HibernateSession:85 - beginTransaction
 10:59:17,687 INFO HibernateSession:98 - commit
 10:59:17,687 INFO HibernateSession:69 - Session closed
 Starting Application Manager.
 Starting Device Mgmt..
 [AWT-EventQueue-0] [2003-11-03 10:59:28,734] INFO - Session opened
 An unrecoverable stack overflow has occurred.
 
 An unexpected exception has been detected in native code outside the VM.
 Unexpected Signal : EXCEPTION_STACK_OVERFLOW occurred at PC=0x6D8739FE
 Function=sqlcctcpinit+0x28EE
 Library=D:\PROGRA~1\SQLLIB\bin\db2tcp.DLL
 
 Current Java thread:
 at COM.ibm.db2.jdbc.app.DB2PreparedStatement.SQLExecute(Native Method)
 at COM.ibm.db2.jdbc.app.DB2PreparedStatement.execute2(DB2PreparedStatement.java:2065)
 at COM.ibm.db2.jdbc.app.DB2PreparedStatement.executeQuery(DB2PreparedStatement.java:1596)
 at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:205)
 at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:205)
 at net.sf.hibernate.impl.BatcherImpl.getResultSet(BatcherImpl.java:81)
 at net.sf.hibernate.loader.Loader.getResultSet(Loader.java:631)
 at net.sf.hibernate.loader.Loader.doResultSet(Loader.java:166)
 at net.sf.hibernate.loader.Loader.doFind(Loader.java:111)
 at net.sf.hibernate.loader.Loader.loadCollection(Loader.java:722)
 at net.sf.hibernate.loader.Loader.loadCollection(Loader.java:705)
 at net.sf.hibernate.loader.CollectionLoader.initialize(CollectionLoader.java:69)
 at net.sf.hibernate.collection.AbstractCollectionPersister.initialize(AbstractCollectionPersister.java:306)
 at net.sf.hibernate.impl.SessionImpl.initialize(SessionImpl.java:3229)
 at net.sf.hibernate.collection.PersistentCollection.forceLoad(PersistentCollection.java:236)
 at net.sf.hibernate.impl.SessionImpl.initializeNonLazyCollections(SessionImpl.java:3144)
 at net.sf.hibernate.loader.Loader.doFind(Loader.java:116)
 at net.sf.hibernate.loader.Loader.loadCollection(Loader.java:722)
 at net.sf.hibernate.loader.Loader.loadCollection(Loader.java:705)
 at net.sf.hibernate.loader.CollectionLoader.initialize(CollectionLoader.java:69)
 at net.sf.hibernate.collection.AbstractCollectionPersister.initialize(AbstractCollectionPersister.java:306)
 at net.sf.hibernate.impl.SessionImpl.initialize(SessionImpl.java:3229)
 at net.sf.hibernate.collection.PersistentCollection.forceLoad(PersistentCollection.java:236)
 at net.sf.hibernate.impl.SessionImpl.initializeNonLazyCollections(SessionImpl.java:3144)
 at net.sf.hibernate.loader.Loader.doFind(Loader.java:116)
 at net.sf.hibernate.loader.Loader.loadCollection(Loader.java:722)
 at net.sf.hibernate.loader.Loader.loadCollection(Loader.java:705)
 at net.sf.hibernate.loader.CollectionLoader.initialize(CollectionLoader.java:69)
 at net.sf.hibernate.collection.AbstractCollectionPersister.initialize(AbstractCollectionPersister.java:306)
 at net.sf.hibernate.impl.SessionImpl.initialize(SessionImpl.java:3229)
 at net.sf.hibernate.collection.PersistentCollection.forceLoad(PersistentCollection.java:236)
 at net.sf.hibernate.impl.SessionImpl.initializeNonLazyCollections(SessionImpl.java:3144)
 at net.sf.hibernate.loader.Loader.doFind(Loader.java:116)
 at net.sf.hibernate.loader.Loader.loadCollection(Loader.java:722)
 at net.sf.hibernate.loader.Loader.loadCollection(Loader.java:705)
 at net.sf.hibernate.loader.CollectionLoader.initialize(CollectionLoader.java:69)
 at net.sf.hibernate.collection.AbstractCollectionPersister.initialize(AbstractCollectionPersister.java:306)
 at net.sf.hibernate.impl.SessionImpl.initialize(SessionImpl.java:3229)
 at net.sf.hibernate.collection.PersistentCollection.forceLoad(PersistentCollection.java:236)
 at net.sf.hibernate.impl.SessionImpl.initializeNonLazyCollections(SessionImpl.java:3144)
 at net.sf.hibernate.loader.Loader.doFind(Loader.java:116)
 at net.sf.hibernate.loader.Loader.loadCollection(Loader.java:722)
 at net.sf.hibernate.loader.Loader.loadCollection(Loader.java:705)
 at net.sf.hibernate.loader.CollectionLoader.initialize(CollectionLoader.java:69)
 at net.sf.hibernate.collection.AbstractCollectionPersister.initialize(AbstractCollectionPersister.java:306)
 at net.sf.hibernate.impl.SessionImpl.initialize(SessionImpl.java:3229)
 at net.sf.hibernate.collection.PersistentCollection.forceLoad(PersistentCollection.java:236)
 at net.sf.hibernate.impl.SessionImpl.initializeNonLazyCollections(SessionImpl.java:3144)
 at net.sf.hibernate.loader.Loader.doFind(Loader.java:116)
 at net.sf.hibernate.loader.Loader.loadCollection(Loader.java:722)
 at net.sf.hibernate.loader.Loader.loadCollection(Loader.java:705)
 at net.sf.hibernate.loader.CollectionLoader.initialize(CollectionLoader.java:69)
 at net.sf.hibernate.collection.AbstractCollectionPersister.initialize(AbstractCollectionPersister.java:306)
 at net.sf.hibernate.impl.SessionImpl.initialize(SessionImpl.java:3229)
 at net.sf.hibernate.collection.PersistentCollection.forceLoad(PersistentCollection.java:236)
 at net.sf.hibernate.impl.SessionImpl.initializeNonLazyCollections(SessionImpl.java:3144)
 at net.sf.hibernate.loader.Loader.doFind(Loader.java:116)
 at net.sf.hibernate.loader.Loader.loadCollection(Loader.java:722)
 at net.sf.hibernate.loader.Loader.loadCollection(Loader.java:705)
 at net.sf.hibernate.loader.CollectionLoader.initialize(CollectionLoader.java:69)
 at net.sf.hibernate.collection.AbstractCollectionPersister.initialize(AbstractCollectionPersister.java:306)
 at net.sf.hibernate.impl.SessionImpl.initialize(SessionImpl.java:3229)
 at net.sf.hibernate.collection.PersistentCollection.forceLoad(PersistentCollection.java:236)
 at net.sf.hibernate.impl.SessionImpl.initializeNonLazyCollections(SessionImpl.java:3144)
 at net.sf.hibernate.loader.Loader.doFind(Loader.java:116)
 at net.sf.hibernate.loader.Loader.loadCollection(Loader.java:722)
 at net.sf.hibernate.loader.Loader.loadCollection(Loader.java:705)
 at net.sf.hibernate.loader.CollectionLoader.initialize(CollectionLoader.java:69)
 at net.sf.hibernate.collection.AbstractCollectionPersister.initialize(AbstractCollectionPersister.java:306)
 at net.sf.hibernate.impl.SessionImpl.initialize(SessionImpl.java:3229)
 at net.sf.hibernate.collection.PersistentCollection.forceLoad(PersistentCollection.java:236)
 at net.sf.hibernate.impl.SessionImpl.initializeNonLazyCollections(SessionImpl.java:3144)
 at net.sf.hibernate.loader.Loader.doFind(Loader.java:116)
 at net.sf.hibernate.loader.Loader.loadCollection(Loader.java:722)
 at net.sf.hibernate.loader.Loader.loadCollection(Loader.java:705)
 at net.sf.hibernate.loader.CollectionLoader.initializeat net.sf.hibernate.impl.SessionImpl.initialize(SessionImpl.java:3229)
 at net.sf.hibernate.collection.PersistentCollection.forceLoad(PersistentCollection.java:236)
 at net.sf.hibernate.impl.SessionImpl.initializeNonLazyCollections(SessionImpl.java:3144)
 ...............................................................................
 
 at net.sf.hibernate.loader.Loader.doFind(Loader.java:116)
 at net.sf.hibernate.loader.Loader.loadCollection(Loader.java:722)
 at net.sf.hibernate.loader.Loader.loadCollection(Loader.java:705)
 at net.sf.hibernate.loader.CollectionLoader.initialize(CollectionLoader.java:69)
 at net.sf.hibernate.collection.AbstractCollectionPersister.initialize(AbstractCollectionPersister.java:306)
 at net.sf.hibernate.impl.SessionImpl.initialize(SessionImpl.java:3229)
 at net.sf.hibernate.collection.PersistentCollection.forceLoad(PersistentCollection.java:236)
 at net.sf.hibernate.impl.SessionImpl.initializeNonLazyCollections(SessionImpl.java:3144)
 at net.sf.hibernate.loader.Loader.doFind(Loader.java:116)
 at net.sf.hibernate.loader.Loader.loadCollection(Loader.java:722)
 at net.sf.hibernate.loader.Loader.loadCollection(Loader.java:705)
 at net.sf.hibernate.loader.CollectionLoader.initialize(CollectionLoader.java:69)
 at net.sf.hibernate.collection.AbstractCollectionPersister.initialize(AbstractCollectionPersister.java:306)
 at net.sf.hibernate.impl.SessionImpl.initialize(SessionImpl.java:3229)
 at net.sf.hibernate.collection.PersistentCollection.forceLoad(PersistentCollection.java:236)
 at net.sf.hibernate.impl.SessionImpl.initializeNonLazyCollections(SessionImpl.java:3144)
 at net.sf.hibernate.loader.Loader.doFind(Loader.java:116)
 at net.sf.hibernate.loader.Loader.loadCollection(Loader.java:722)
 at net.sf.hibernate.loader.Loader.loadCollection(Loader.java:705)
 at net.sf.hibernate.loader.CollectionLoader.initialize(CollectionLoader.java:69)
 at net.sf.hibernate.collection.AbstractCollectionPersister.initialize(AbstractCollectionPersister.java:306)
 at net.sf.hibernate.impl.SessionImpl.initialize(SessionImpl.java:3229)
 at net.sf.hibernate.collection.PersistentCollection.forceLoad(PersistentCollection.java:236)
 at net.sf.hibernate.impl.SessionImpl.initializeNonLazyCollections(SessionImpl.java:3144)
 at net.sf.hibernate.loader.Loader.doFind(Loader.java:116)
 at net.sf.hibernate.loader.Loader.loadCollection(Loader.java:722)
 at net.sf.hibernate.loader.Loader.loadCollection(Loader.java:705)
 at net.sf.hibernate.loader.CollectionLoader.initialize(CollectionLoader.java:69)
 at net.sf.hibernate.collection.AbstractCollectionPersister.initialize(AbstractCollectionPersister.java:306)
 at net.sf.hibernate.impl.SessionImpl.initialize(SessionImpl.java:3229)
 at net.sf.hibernate.collection.PersistentCollection.forceLoad(PersistentCollection.java:236)
 at net.sf.hibernate.impl.SessionImpl.initializeNonLazyCollections(SessionImpl.java:3144)
 at net.sf.hibernate.loader.Loader.doFind(Loader.java:116)
 at net.sf.hibernate.loader.Loader.loadCollection(Loader.java:722)
 at net.sf.hibernate.loader.Loader.loadCollection(Loader.java:705)
 at net.sf.hibernate.loader.CollectionLoader.initialize(CollectionLoader.java:69)
 at net.sf.hibernate.collection.AbstractCollectionPersister.initialize(AbstractCollectionPersister.java:306)
 at net.sf.hibernate.impl.SessionImpl.initialize(SessionImpl.java:3229)
 at net.sf.hibernate.collection.PersistentCollection.forceLoad(PersistentCollection.java:236)
 at net.sf.hibernate.impl.SessionImpl.initializeNonLazyCollections(SessionImpl.java:3144)
 
 Dynamic libraries:
 0x00400000 - 0x00407000 	D:\j2sdk1.4.1_03\bin\javaw.exe
 0x77F80000 - 0x77FFA000 	C:\WINNT\system32\ntdll.dll
 0x77DB0000 - 0x77E0B000 	C:\WINNT\system32\ADVAPI32.dll
 0x77E80000 - 0x77F31000 	C:\WINNT\system32\KERNEL32.dll
 0x77D30000 - 0x77D9E000 	C:\WINNT\system32\RPCRT4.dll
 0x77E10000 - 0x77E6F000 	C:\WINNT\system32\USER32.dll
 0x77F40000 - 0x77F79000 	C:\WINNT\system32\GDI32.dll
 0x78000000 - 0x78046000 	C:\WINNT\system32\MSVCRT.dll
 0x6D340000 - 0x6D46B000 	D:\j2sdk1.4.1_03\jre\bin\client\jvm.dll
 0x77570000 - 0x775A0000 	C:\WINNT\System32\WINMM.dll
 0x6D1E0000 - 0x6D1E7000 	D:\j2sdk1.4.1_03\jre\bin\hpi.dll
 0x6D310000 - 0x6D31E000 	D:\j2sdk1.4.1_03\jre\bin\verify.dll
 0x6D220000 - 0x6D239000 	D:\j2sdk1.4.1_03\jre\bin\java.dll
 0x6D330000 - 0x6D33D000 	D:\j2sdk1.4.1_03\jre\bin\zip.dll
 0x6D000000 - 0x6D105000 	D:\j2sdk1.4.1_03\jre\bin\awt.dll
 0x77800000 - 0x7781E000 	C:\WINNT\System32\WINSPOOL.DRV
 0x76620000 - 0x76630000 	C:\WINNT\system32\MPR.dll
 0x75E60000 - 0x75E7A000 	C:\WINNT\System32\IMM32.dll
 0x77A50000 - 0x77B3C000 	C:\WINNT\system32\ole32.dll
 0x6D2E0000 - 0x6D2EE000 	D:\j2sdk1.4.1_03\jre\bin\net.dll
 0x75050000 - 0x75058000 	C:\WINNT\System32\WSOCK32.dll
 0x75030000 - 0x75043000 	C:\WINNT\System32\WS2_32.DLL
 0x75020000 - 0x75028000 	C:\WINNT\System32\WS2HELP.DLL
 0x782C0000 - 0x782CC000 	C:\WINNT\System32\rnr20.dll
 0x77980000 - 0x779A4000 	C:\WINNT\System32\DNSAPI.DLL
 0x77340000 - 0x77353000 	C:\WINNT\System32\iphlpapi.dll
 0x77520000 - 0x77525000 	C:\WINNT\System32\ICMP.DLL
 0x77320000 - 0x77337000 	C:\WINNT\System32\MPRAPI.DLL
 0x75150000 - 0x75160000 	C:\WINNT\System32\SAMLIB.DLL
 0x75170000 - 0x751BF000 	C:\WINNT\System32\NETAPI32.DLL
 0x77BE0000 - 0x77BEF000 	C:\WINNT\System32\Secur32.dll
 0x751C0000 - 0x751C6000 	C:\WINNT\System32\NETRAP.dll
 0x77950000 - 0x77978000 	C:\WINNT\system32\WLDAP32.dll
 0x779B0000 - 0x77A4B000 	C:\WINNT\system32\OLEAUT32.DLL
 0x773B0000 - 0x773DE000 	C:\WINNT\System32\ACTIVEDS.DLL
 0x77380000 - 0x773A2000 	C:\WINNT\System32\ADSLDPC.DLL
 0x77830000 - 0x7783E000 	C:\WINNT\System32\RTUTILS.DLL
 0x77880000 - 0x7790D000 	C:\WINNT\System32\SETUPAPI.DLL
 0x77C10000 - 0x77C6D000 	C:\WINNT\System32\USERENV.DLL
 0x774E0000 - 0x77512000 	C:\WINNT\System32\RASAPI32.DLL
 0x774C0000 - 0x774D1000 	C:\WINNT\System32\RASMAN.DLL
 0x77530000 - 0x77552000 	C:\WINNT\System32\TAPI32.DLL
 0x71710000 - 0x71794000 	C:\WINNT\system32\COMCTL32.DLL
 0x70BD0000 - 0x70C35000 	C:\WINNT\system32\SHLWAPI.DLL
 0x77360000 - 0x77379000 	C:\WINNT\System32\DHCPCSVC.DLL
 0x777E0000 - 0x777E8000 	C:\WINNT\System32\winrnr.dll
 0x0B6B0000 - 0x0B6E6000 	C:\Program Files\NewDotNet\newdotnet5_20.dll
 0x70200000 - 0x70295000 	C:\WINNT\system32\WININET.dll
 0x77440000 - 0x774B6000 	C:\WINNT\system32\CRYPT32.dll
 0x77430000 - 0x77440000 	C:\WINNT\system32\MSASN1.dll
 0x76930000 - 0x7695B000 	C:\WINNT\System32\WINTRUST.dll
 0x77920000 - 0x77943000 	C:\WINNT\system32\IMAGEHLP.dll
 0x777F0000 - 0x777F5000 	C:\WINNT\System32\rasadhlp.dll
 0x74FD0000 - 0x74FED000 	C:\WINNT\system32\msafd.dll
 0x75010000 - 0x75017000 	C:\WINNT\System32\wshtcpip.dll
 0x6D190000 - 0x6D1E0000 	D:\j2sdk1.4.1_03\jre\bin\fontmanager.dll
 0x51000000 - 0x51044000 	C:\WINNT\System32\ddraw.dll
 0x728A0000 - 0x728A6000 	C:\WINNT\System32\DCIMAN32.dll
 0x5C000000 - 0x5C0C7000 	C:\WINNT\System32\D3DIM700.DLL
 0x6D290000 - 0x6D2AE000 	D:\j2sdk1.4.1_03\jre\bin\jpeg.dll
 0x61220000 - 0x6122B000 	C:\Program Files\Microsoft Hardware\Mouse\MSH_ZWF.dll
 0x6D6A0000 - 0x6D6B2000 	D:\Program Files\SQLLIB\bin\db2jdbc.dll
 0x6C000000 - 0x6C281000 	D:\Program Files\SQLLIB\BIN\DB2CLI.dll
 0x6C5A0000 - 0x6C770000 	D:\Program Files\SQLLIB\BIN\DB2SYS.dll
 0x6D660000 - 0x6D66B000 	D:\Program Files\SQLLIB\BIN\DB2WINT.dll
 0x11CB0000 - 0x11CC1000 	D:\Program Files\SQLLIB\BIN\DB2SYSP.dll
 0x6C290000 - 0x6C3E6000 	D:\Program Files\SQLLIB\BIN\DB2APP.dll
 0x77820000 - 0x77827000 	C:\WINNT\system32\VERSION.dll
 0x759B0000 - 0x759B6000 	C:\WINNT\system32\LZ32.DLL
 0x6C4D0000 - 0x6C571000 	D:\Program Files\SQLLIB\BIN\DB2UTIL.dll
 0x6C3F0000 - 0x6C40D000 	D:\Program Files\SQLLIB\BIN\DB2ABIND.dll
 0x78280000 - 0x782B3000 	C:\WINNT\system32\kerberos.dll
 0x76670000 - 0x7667E000 	C:\WINNT\System32\cryptdll.dll
 0x6D870000 - 0x6D87D000 	D:\PROGRA~1\SQLLIB\bin\db2tcp.DLL
 0x6D140000 - 0x6D162000 	D:\j2sdk1.4.1_03\jre\bin\dcpr.dll
 0x72A00000 - 0x72A2D000 	C:\WINNT\system32\DBGHELP.dll
 0x690A0000 - 0x690AB000 	C:\WINNT\System32\PSAPI.DLL
 
 Local Time = Mon Nov 03 11:18:50 2003
 Elapsed Time = 43
 #
 # The exception above was detected in native code outside the VM
 #
 # Java VM: Java HotSpot(TM) Client VM (1.4.1_03-b02 mixed mode)
 #
 # An error report file has been saved as hs_err_pid1936.log.
 # Please refer to the file for further information.
 #
 
 Looks like we have a looooop when dealing with collections....
 
 Problem #2:
 
 SchemaUpdate gives:
 create index IDXCADC435DBA89991B on subnet (net_subnet_id)
 11:22:33,390 ERROR SchemaUpdate:123 - Unsuccessful: create index IDXCADC435DBA89991B on subnet (net_subnet_id)
 COM.ibm.db2.jdbc.DB2Exception: [IBM][CLI Driver][DB2/SUN] SQL0107N  The name "IDXCADC435DBA89991B" is too long.  The maximum length is "18".  SQLSTATE=42622
 
 at COM.ibm.db2.jdbc.app.SQLExceptionGenerator.throw_SQLException(SQLExceptionGenerator.java:270)
 at COM.ibm.db2.jdbc.app.SQLExceptionGenerator.throw_SQLException(SQLExceptionGenerator.java:207)
 at COM.ibm.db2.jdbc.app.SQLExceptionGenerator.check_return_code(SQLExceptionGenerator.java:458)
 at COM.ibm.db2.jdbc.app.DB2Statement.execute2(DB2Statement.java:838)
 at COM.ibm.db2.jdbc.app.DB2Statement.executeUpdate(DB2Statement.java:728)
 at net.sf.hibernate.tool.hbm2ddl.SchemaUpdate.execute(SchemaUpdate.java:120)
 at com.db.device.MainDevice.initHibernate(MainDevice.java:52)
 at com.db.device.MainDevice.go(MainDevice.java:56)
 at com.db.device.MainDevice.main(MainDevice.java:43)
 
 do I have to re-write the old mappings ???
 
 \TIA,
 --steve p.
 
 
 |