[SOLVED] OrbiterMicro Chat Tutorial not connecting

[Stylesoftware]

Hi all,

OrbiterMicro Chat Tutorial, Part 1
Tried in Chrome latest, and Firefox latest, and IE8, with Win7 x64, jre6, no software firewalls.

Doesn't want to connect to tryunion.com when run on this page:
1) http://www.unionplatform.com/?page_id=2247

2) Nor when i download it and run it from my own server, Firebug shows an http connection problem only. no other errors.

3) I then downloaded and ran the union server (no errors in the log, successful server start) and changed the Chat.html code to connect to localhost. It still wont work, any ideas?

Additional:
I can ping tryunion.com with 131ms response from New Zealand.
The fully working Chess and Isometric game on your front page work fine.

Multiuser Drawing Pad Built with Pure JavaScript/HTML5/Canvas: http://www.unionplatform.com/?page_id=2762
Doesn't work either, same problem.

Pleeeease help, i really want to use your wonderful software.

[colin]

tryunion.com is currently down. we are dealing with a server overload issue, and expect to have the service back up soon. thanks for your patience.

as for running the server locally, i'll double check the steps on my windows machine later today to make sure the installation steps are accurate. meanwhile, please check your server and client logs for errors and diagnostic information.

colin

[Stylesoftware]

Hi Colin,

Thankyou for getting back to me

I'm still getting nothing out of the union server on my local machine.

I removed all versions of java, and installed the latest from sun.
I made sure my WAMP server was turned off.
I made sure all software firewalls were turned off

I opened a command prompt with administrator rights.
Went to the correct folder and started the server via 'startserver'

Code: Select all

C:\wamp\www\union>java  -Dfile.encoding=UTF-8 -cp lib\union.jar;lib\stax-api-1.0
.1.jar;lib\wstx-asl-3.2.6.jar net.user1.union.core.UnionMain start
Union Server 1.1.0 (build 530) Started....OK

derby.log was created:

Code: Select all

----------------------------------------------------------------
2011-11-19 06:21:37.405 GMT:
Booting Derby version The Apache Software Foundation - Apache Derby - 10.5.3.0 - (802917): instance a816c00e-0133-ba7c-be82-000000e085f0
on database directory C:\wamp\www\union\unionDB 

Database Class Loader started - derby.database.classpath=''

log.txt was created:

Code: Select all

2011-11-19 19:21:36,668 WARN  - ***********************************************
2011-11-19 19:21:36,668 WARN  - *** Starting Union Server 1.1.0 (build 530) ***
2011-11-19 19:21:36,668 WARN  - ***********************************************
2011-11-19 19:21:36,668 WARN  - UPC Version: 1.9.3
2011-11-19 19:21:36,669 WARN  - Java VM [1.6.0_29 from Sun Microsystems Inc.]
2011-11-19 19:21:36,669 WARN  - Licence [Union]
2011-11-19 19:21:36,764 WARN  - UNION_HOME set to [C:\wamp\www\union\.]
2011-11-19 19:21:36,783 DEBUG - Creating new CacheManager with default config
2011-11-19 19:21:36,784 DEBUG - Configuring ehcache from classpath.
2011-11-19 19:21:36,787 DEBUG - Configuring ehcache from ehcache.xml found in the classpath: file:/C:/wamp/www/union/lib/ehcache.xml
2011-11-19 19:21:36,787 DEBUG - Configuring ehcache from URL: file:/C:/wamp/www/union/lib/ehcache.xml
2011-11-19 19:21:36,788 DEBUG - Configuring ehcache from InputStream
2011-11-19 19:21:36,800 DEBUG - Ignoring ehcache attribute xmlns:xsi
2011-11-19 19:21:36,801 DEBUG - Ignoring ehcache attribute xsi:noNamespaceSchemaLocation
2011-11-19 19:21:36,802 DEBUG - Disk Store Path: C:\Users\Chris\AppData\Local\Temp\
2011-11-19 19:21:36,811 DEBUG - No CacheManagerEventListenerFactory class specified. Skipping...
2011-11-19 19:21:36,811 DEBUG - No CachePeerListenerFactoryConfiguration specified. Not configuring a CacheManagerPeerListener.
2011-11-19 19:21:36,811 DEBUG - No CachePeerProviderFactoryConfiguration specified. Not configuring a CacheManagerPeerProvider.
2011-11-19 19:21:36,865 DEBUG - No BootstrapCacheLoaderFactory class specified. Skipping...
2011-11-19 19:21:36,865 DEBUG - No CacheLoaderFactory class specified. Skipping...
2011-11-19 19:21:36,865 DEBUG - No CacheExceptionHandlerFactory class specified. Skipping...
2011-11-19 19:21:36,869 DEBUG - Initialized net.sf.ehcache.store.LfuMemoryStore for accountCache
2011-11-19 19:21:36,869 DEBUG - Initialised cache: accountCache
2011-11-19 19:21:36,901 INFO  - Hibernate 3.3.1.GA
2011-11-19 19:21:36,904 INFO  - hibernate.properties not found
2011-11-19 19:21:36,907 INFO  - Bytecode provider name : javassist
2011-11-19 19:21:36,910 INFO  - using JDK 1.4 java.sql.Timestamp handling
2011-11-19 19:21:36,953 INFO  - configuring from file: uhibernate.cfg.xml
2011-11-19 19:21:36,958 DEBUG - trying to resolve system-id [http://hibernate.sourceforge.net/hibernate-configuration-3.0.dtd]
2011-11-19 19:21:36,959 DEBUG - recognized hibernate namespace; attempting to resolve on classpath under org/hibernate/
2011-11-19 19:21:36,959 DEBUG - located [http://hibernate.sourceforge.net/hibernate-configuration-3.0.dtd] in classpath
2011-11-19 19:21:36,965 DEBUG - dialect=org.hibernate.dialect.DerbyDialect
2011-11-19 19:21:36,965 DEBUG - hibernate.connection.driver_class=org.apache.derby.jdbc.EmbeddedDriver
2011-11-19 19:21:36,965 DEBUG - hibernate.connection.url=jdbc:derby:unionDB
2011-11-19 19:21:36,965 DEBUG - hibernate.connection.username=
2011-11-19 19:21:36,965 DEBUG - hibernate.connection.password=
2011-11-19 19:21:36,965 DEBUG - show_sql=false
2011-11-19 19:21:36,965 DEBUG - use_outer_join=true
2011-11-19 19:21:36,965 DEBUG - hibernate.hbm2ddl.auto=update
2011-11-19 19:21:36,966 DEBUG - null<-org.dom4j.tree.DefaultAttribute@1d04653 [Attribute: name resource value "Account.hbm.xml"]
2011-11-19 19:21:36,966 INFO  - Reading mappings from resource : Account.hbm.xml
2011-11-19 19:21:36,967 DEBUG - trying to resolve system-id [http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd]
2011-11-19 19:21:36,967 DEBUG - recognized hibernate namespace; attempting to resolve on classpath under org/hibernate/
2011-11-19 19:21:36,967 DEBUG - located [http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd] in classpath
2011-11-19 19:21:37,022 INFO  - Mapping class: net.user1.union.persistence.union.PersistentAccount -> ACCOUNT
2011-11-19 19:21:37,032 DEBUG - Mapped property: id -> ID
2011-11-19 19:21:37,038 DEBUG - Mapped property: createdAt -> CREATED_AT
2011-11-19 19:21:37,038 DEBUG - Mapped property: updatedAt -> UPDATED_AT
2011-11-19 19:21:37,039 DEBUG - Mapped property: userID -> USERID
2011-11-19 19:21:37,039 DEBUG - Mapped property: password -> PASSWORD
2011-11-19 19:21:37,039 DEBUG - Mapped property: moderator -> MODERATOR
2011-11-19 19:21:37,039 DEBUG - null<-org.dom4j.tree.DefaultAttribute@1b9240e [Attribute: name resource value "Room.hbm.xml"]
2011-11-19 19:21:37,039 INFO  - Reading mappings from resource : Room.hbm.xml
2011-11-19 19:21:37,040 DEBUG - trying to resolve system-id [http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd]
2011-11-19 19:21:37,040 DEBUG - recognized hibernate namespace; attempting to resolve on classpath under org/hibernate/
2011-11-19 19:21:37,040 DEBUG - located [http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd] in classpath
2011-11-19 19:21:37,051 INFO  - Mapping class: net.user1.union.persistence.union.PersistentRoom -> ROOM
2011-11-19 19:21:37,052 DEBUG - Mapped property: id -> ID
2011-11-19 19:21:37,052 DEBUG - Mapped property: roomQualifier -> ROOM_QUALIFIER
2011-11-19 19:21:37,052 DEBUG - Mapped property: roomID -> ROOM_ID
2011-11-19 19:21:37,052 DEBUG - Mapped property: password -> PASSWORD
2011-11-19 19:21:37,052 DEBUG - Mapped property: createdAt -> CREATED_AT
2011-11-19 19:21:37,052 DEBUG - Mapped property: updatedAt -> UPDATED_AT
2011-11-19 19:21:37,052 DEBUG - null<-org.dom4j.tree.DefaultAttribute@181edf4 [Attribute: name resource value "RoomAttribute.hbm.xml"]
2011-11-19 19:21:37,052 INFO  - Reading mappings from resource : RoomAttribute.hbm.xml
2011-11-19 19:21:37,053 DEBUG - trying to resolve system-id [http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd]
2011-11-19 19:21:37,053 DEBUG - recognized hibernate namespace; attempting to resolve on classpath under org/hibernate/
2011-11-19 19:21:37,053 DEBUG - located [http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd] in classpath
2011-11-19 19:21:37,062 INFO  - Mapping class: net.user1.union.persistence.union.RoomAttribute -> ROOM_ATTRIBUTE
2011-11-19 19:21:37,063 DEBUG - Mapped property: id -> ID
2011-11-19 19:21:37,063 DEBUG - Mapped property: createdAt -> CREATED_AT
2011-11-19 19:21:37,063 DEBUG - Mapped property: updatedAt -> UPDATED_AT
2011-11-19 19:21:37,064 DEBUG - Mapped property: holder -> ROOM
2011-11-19 19:21:37,064 DEBUG - Mapped property: name -> NAME
2011-11-19 19:21:37,064 DEBUG - Mapped property: scope -> SCOPE
2011-11-19 19:21:37,064 DEBUG - Mapped property: value -> VALUE
2011-11-19 19:21:37,064 DEBUG - Mapped property: flags -> FLAGS
2011-11-19 19:21:37,064 DEBUG - null<-org.dom4j.tree.DefaultAttribute@166a22b [Attribute: name resource value "AccountAttribute.hbm.xml"]
2011-11-19 19:21:37,064 INFO  - Reading mappings from resource : AccountAttribute.hbm.xml
2011-11-19 19:21:37,065 DEBUG - trying to resolve system-id [http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd]
2011-11-19 19:21:37,065 DEBUG - recognized hibernate namespace; attempting to resolve on classpath under org/hibernate/
2011-11-19 19:21:37,065 DEBUG - located [http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd] in classpath
2011-11-19 19:21:37,071 INFO  - Mapping class: net.user1.union.persistence.union.AccountAttribute -> ACCOUNT_ATTRIBUTE
2011-11-19 19:21:37,072 DEBUG - Mapped property: id -> id
2011-11-19 19:21:37,072 DEBUG - Mapped property: createdAt -> CREATED_AT
2011-11-19 19:21:37,072 DEBUG - Mapped property: updatedAt -> UPDATED_AT
2011-11-19 19:21:37,072 DEBUG - Mapped property: holder -> CLIENT
2011-11-19 19:21:37,072 DEBUG - Mapped property: name -> NAME
2011-11-19 19:21:37,072 DEBUG - Mapped property: scope -> SCOPE
2011-11-19 19:21:37,072 DEBUG - Mapped property: value -> VALUE
2011-11-19 19:21:37,072 DEBUG - Mapped property: flags -> FLAGS
2011-11-19 19:21:37,072 DEBUG - null<-org.dom4j.tree.DefaultAttribute@763f5d [Attribute: name resource value "ServerAttribute.hbm.xml"]
2011-11-19 19:21:37,072 INFO  - Reading mappings from resource : ServerAttribute.hbm.xml
2011-11-19 19:21:37,073 DEBUG - trying to resolve system-id [http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd]
2011-11-19 19:21:37,073 DEBUG - recognized hibernate namespace; attempting to resolve on classpath under org/hibernate/
2011-11-19 19:21:37,073 DEBUG - located [http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd] in classpath
2011-11-19 19:21:37,079 INFO  - Mapping class: net.user1.union.persistence.union.ServerAttribute -> SERVER_ATTRIBUTE
2011-11-19 19:21:37,079 DEBUG - Mapped property: id -> ID
2011-11-19 19:21:37,079 DEBUG - Mapped property: createdAt -> CREATED_AT
2011-11-19 19:21:37,079 DEBUG - Mapped property: updatedAt -> UPDATED_AT
2011-11-19 19:21:37,079 DEBUG - Mapped property: name -> NAME
2011-11-19 19:21:37,079 DEBUG - Mapped property: scope -> SCOPE
2011-11-19 19:21:37,080 DEBUG - Mapped property: value -> VALUE
2011-11-19 19:21:37,080 DEBUG - Mapped property: flags -> FLAGS
2011-11-19 19:21:37,080 INFO  - Configured SessionFactory: null
2011-11-19 19:21:37,080 DEBUG - properties: {hibernate.connection.password=, java.runtime.name=Java(TM) SE Runtime Environment, sun.boot.library.path=C:\Program Files (x86)\java\jre6\bin, java.vm.version=20.4-b02, hibernate.connection.username=, java.vm.vendor=Sun Microsystems Inc., java.vendor.url=http://java.sun.com/, path.separator=;, java.vm.name=Java HotSpot(TM) Client VM, file.encoding.pkg=sun.io, use_outer_join=true, user.country=NZ, sun.java.launcher=SUN_STANDARD, sun.os.patch.level=, java.vm.specification.name=Java Virtual Machine Specification, user.dir=C:\wamp\www\union, java.runtime.version=1.6.0_29-b11, java.awt.graphicsenv=sun.awt.Win32GraphicsEnvironment, java.endorsed.dirs=C:\Program Files (x86)\java\jre6\lib\endorsed, os.arch=x86, java.io.tmpdir=C:\Users\Chris\AppData\Local\Temp\, line.separator=
, java.vm.specification.vendor=Sun Microsystems Inc., user.variant=, os.name=Windows 7, sun.jnu.encoding=Cp1252, java.library.path=C:\Program Files (x86)\java\jre6\bin;C:\Windows\Sun\Java\bin;C:\Windows\system32;C:\Windows;C:\Program Files (x86)\AMD APP\bin\x86_64;C:\Program Files (x86)\AMD APP\bin\x86;C:\Program Files\Common Files\Microsoft Shared\Windows Live;C:\Program Files (x86)\Common Files\Microsoft Shared\Windows Live;C:\Windows\system32;C:\Windows;C:\Windows\System32\Wbem;C:\Windows\System32\WindowsPowerShell\v1.0\;C:\Program Files (x86)\Windows Live\Shared;C:\Program Files (x86)\QuickTime\QTSystem\;C:\Program Files (x86)\Calibre2\;C:\Program Files (x86)\ATI Technologies\ATI.ACE\Core-Static;C:\Program Files (x86)\java\jre6\bin\;;., java.specification.name=Java Platform API Specification, java.class.version=50.0, sun.management.compiler=HotSpot Client Compiler, os.version=6.1, user.home=C:\Users\Chris, user.timezone=Pacific/Auckland, java.awt.printerjob=sun.awt.windows.WPrinterJob, file.encoding=UTF-8, java.specification.version=1.6, hibernate.connection.driver_class=org.apache.derby.jdbc.EmbeddedDriver, show_sql=false, user.name=Chris, java.class.path=lib\union.jar;lib\stax-api-1.0.1.jar;lib\wstx-asl-3.2.6.jar, hibernate.bytecode.use_reflection_optimizer=false, hibernate.show_sql=false, java.vm.specification.version=1.0, sun.java.command=net.user1.union.core.UnionMain start, java.home=C:\Program Files (x86)\java\jre6, sun.arch.data.model=32, hibernate.connection.url=jdbc:derby:unionDB, hibernate.dialect=org.hibernate.dialect.DerbyDialect, user.language=en, java.specification.vendor=Sun Microsystems Inc., awt.toolkit=sun.awt.windows.WToolkit, java.vm.info=mixed mode, sharing, java.version=1.6.0_29, java.ext.dirs=C:\Program Files (x86)\java\jre6\lib\ext;C:\Windows\Sun\Java\lib\ext, sun.boot.class.path=C:\Program Files (x86)\java\jre6\lib\resources.jar;C:\Program Files (x86)\java\jre6\lib\rt.jar;C:\Program Files (x86)\java\jre6\lib\sunrsasign.jar;C:\Program Files (x86)\java\jre6\lib\jsse.jar;C:\Program Files (x86)\java\jre6\lib\jce.jar;C:\Program Files (x86)\java\jre6\lib\charsets.jar;C:\Program Files (x86)\java\jre6\lib\modules\jdk.boot.jar;C:\Program Files (x86)\java\jre6\classes, java.vendor=Sun Microsystems Inc., file.separator=\, hibernate.hbm2ddl.auto=update, java.vendor.url.bug=http://java.sun.com/cgi-bin/bugreport.cgi, sun.io.unicode.encoding=UnicodeLittle, sun.cpu.endian=little, hibernate.use_outer_join=true, sun.desktop=windows, dialect=org.hibernate.dialect.DerbyDialect, sun.cpu.isalist=}
2011-11-19 19:21:37,847 DEBUG - Preparing to build session factory with filters : {}
2011-11-19 19:21:37,847 DEBUG - processing extends queue
2011-11-19 19:21:37,847 DEBUG - processing collection mappings
2011-11-19 19:21:37,847 DEBUG - processing native query and ResultSetMapping mappings
2011-11-19 19:21:37,847 DEBUG - processing association property references
2011-11-19 19:21:37,847 DEBUG - processing foreign key constraints
2011-11-19 19:21:37,891 INFO  - Using Hibernate built-in connection pool (not for production use!)
2011-11-19 19:21:37,891 INFO  - Hibernate connection pool size: 20
2011-11-19 19:21:37,891 INFO  - autocommit mode: false
2011-11-19 19:21:37,891 INFO  - using driver: org.apache.derby.jdbc.EmbeddedDriver at URL: jdbc:derby:unionDB
2011-11-19 19:21:37,891 INFO  - connection properties: {user=, password=}
2011-11-19 19:21:37,891 DEBUG - opening new JDBC connection
2011-11-19 19:21:37,892 DEBUG - created connection to: jdbc:derby:unionDB, Isolation Level: 2
2011-11-19 19:21:37,896 INFO  - RDBMS: Apache Derby, version: 10.5.3.0 - (802917)
2011-11-19 19:21:37,896 INFO  - JDBC driver: Apache Derby Embedded JDBC Driver, version: 10.5.3.0 - (802917)
2011-11-19 19:21:37,909 INFO  - Using dialect: org.hibernate.dialect.DerbyDialect
2011-11-19 19:21:37,916 INFO  - Using default transaction strategy (direct JDBC transactions)
2011-11-19 19:21:37,917 INFO  - No TransactionManagerLookup configured (in JTA environment, use of read-write or transactional second-level cache is not recommended)
2011-11-19 19:21:37,917 INFO  - Automatic flush during beforeCompletion(): disabled
2011-11-19 19:21:37,917 INFO  - Automatic session close at end of transaction: disabled
2011-11-19 19:21:37,918 INFO  - Scrollable result sets: enabled
2011-11-19 19:21:37,918 DEBUG - Wrap result sets: disabled
2011-11-19 19:21:37,918 INFO  - JDBC3 getGeneratedKeys(): disabled
2011-11-19 19:21:37,918 INFO  - Connection release mode: auto
2011-11-19 19:21:37,918 INFO  - Default batch fetch size: 1
2011-11-19 19:21:37,919 INFO  - Generate SQL with comments: disabled
2011-11-19 19:21:37,919 INFO  - Order SQL updates by primary key: disabled
2011-11-19 19:21:37,919 INFO  - Order SQL inserts for batching: disabled
2011-11-19 19:21:37,919 INFO  - Query translator: org.hibernate.hql.ast.ASTQueryTranslatorFactory
2011-11-19 19:21:37,920 INFO  - Using ASTQueryTranslatorFactory
2011-11-19 19:21:37,920 INFO  - Query language substitutions: {}
2011-11-19 19:21:37,920 INFO  - JPA-QL strict compliance: disabled
2011-11-19 19:21:37,920 INFO  - Second-level cache: enabled
2011-11-19 19:21:37,920 INFO  - Query cache: disabled
2011-11-19 19:21:37,920 INFO  - Cache region factory : org.hibernate.cache.impl.NoCachingRegionFactory
2011-11-19 19:21:37,921 INFO  - Optimize cache for minimal puts: disabled
2011-11-19 19:21:37,921 INFO  - Structured second-level cache entries: disabled
2011-11-19 19:21:37,924 INFO  - Statistics: disabled
2011-11-19 19:21:37,925 INFO  - Deleted entity synthetic identifier rollback: disabled
2011-11-19 19:21:37,925 INFO  - Default entity-mode: pojo
2011-11-19 19:21:37,925 INFO  - Named query checking : enabled
2011-11-19 19:21:37,959 INFO  - building session factory
2011-11-19 19:21:37,960 DEBUG - Session factory constructed with filter configurations : {}
2011-11-19 19:21:37,961 DEBUG - instantiating session factory with properties: {java.runtime.name=Java(TM) SE Runtime Environment, hibernate.connection.password=, sun.boot.library.path=C:\Program Files (x86)\java\jre6\bin, java.vm.version=20.4-b02, hibernate.connection.username=, java.vm.vendor=Sun Microsystems Inc., java.vendor.url=http://java.sun.com/, path.separator=;, java.vm.name=Java HotSpot(TM) Client VM, file.encoding.pkg=sun.io, user.country=NZ, sun.java.launcher=SUN_STANDARD, sun.os.patch.level=, use_outer_join=true, java.vm.specification.name=Java Virtual Machine Specification, user.dir=C:\wamp\www\union, java.runtime.version=1.6.0_29-b11, java.awt.graphicsenv=sun.awt.Win32GraphicsEnvironment, java.endorsed.dirs=C:\Program Files (x86)\java\jre6\lib\endorsed, os.arch=x86, java.io.tmpdir=C:\Users\Chris\AppData\Local\Temp\, line.separator=
, java.vm.specification.vendor=Sun Microsystems Inc., user.variant=, os.name=Windows 7, sun.jnu.encoding=Cp1252, java.library.path=C:\Program Files (x86)\java\jre6\bin;C:\Windows\Sun\Java\bin;C:\Windows\system32;C:\Windows;C:\Program Files (x86)\AMD APP\bin\x86_64;C:\Program Files (x86)\AMD APP\bin\x86;C:\Program Files\Common Files\Microsoft Shared\Windows Live;C:\Program Files (x86)\Common Files\Microsoft Shared\Windows Live;C:\Windows\system32;C:\Windows;C:\Windows\System32\Wbem;C:\Windows\System32\WindowsPowerShell\v1.0\;C:\Program Files (x86)\Windows Live\Shared;C:\Program Files (x86)\QuickTime\QTSystem\;C:\Program Files (x86)\Calibre2\;C:\Program Files (x86)\ATI Technologies\ATI.ACE\Core-Static;C:\Program Files (x86)\java\jre6\bin\;;., java.specification.name=Java Platform API Specification, java.class.version=50.0, sun.management.compiler=HotSpot Client Compiler, os.version=6.1, user.home=C:\Users\Chris, user.timezone=Pacific/Auckland, java.awt.printerjob=sun.awt.windows.WPrinterJob, java.specification.version=1.6, file.encoding=UTF-8, hibernate.connection.driver_class=org.apache.derby.jdbc.EmbeddedDriver, show_sql=false, java.class.path=lib\union.jar;lib\stax-api-1.0.1.jar;lib\wstx-asl-3.2.6.jar, user.name=Chris, hibernate.bytecode.use_reflection_optimizer=false, hibernate.show_sql=false, java.vm.specification.version=1.0, sun.arch.data.model=32, java.home=C:\Program Files (x86)\java\jre6, sun.java.command=net.user1.union.core.UnionMain start, hibernate.dialect=org.hibernate.dialect.DerbyDialect, hibernate.connection.url=jdbc:derby:unionDB, java.specification.vendor=Sun Microsystems Inc., user.language=en, awt.toolkit=sun.awt.windows.WToolkit, java.vm.info=mixed mode, sharing, java.version=1.6.0_29, java.ext.dirs=C:\Program Files (x86)\java\jre6\lib\ext;C:\Windows\Sun\Java\lib\ext, sun.boot.class.path=C:\Program Files (x86)\java\jre6\lib\resources.jar;C:\Program Files (x86)\java\jre6\lib\rt.jar;C:\Program Files (x86)\java\jre6\lib\sunrsasign.jar;C:\Program Files (x86)\java\jre6\lib\jsse.jar;C:\Program Files (x86)\java\jre6\lib\jce.jar;C:\Program Files (x86)\java\jre6\lib\charsets.jar;C:\Program Files (x86)\java\jre6\lib\modules\jdk.boot.jar;C:\Program Files (x86)\java\jre6\classes, java.vendor=Sun Microsystems Inc., file.separator=\, java.vendor.url.bug=http://java.sun.com/cgi-bin/bugreport.cgi, hibernate.hbm2ddl.auto=update, sun.cpu.endian=little, sun.io.unicode.encoding=UnicodeLittle, hibernate.use_outer_join=true, sun.desktop=windows, sun.cpu.isalist=, dialect=org.hibernate.dialect.DerbyDialect}
2011-11-19 19:21:38,112 DEBUG - Static SQL for entity: net.user1.union.persistence.union.ServerAttribute
2011-11-19 19:21:38,113 DEBUG -  Version select: select ID from SERVER_ATTRIBUTE where ID =?
2011-11-19 19:21:38,113 DEBUG -  Snapshot select: select serverattr_.ID, serverattr_.CREATED_AT as CREATED2_4_, serverattr_.UPDATED_AT as UPDATED3_4_, serverattr_.NAME as NAME4_, serverattr_.SCOPE as SCOPE4_, serverattr_.VALUE as VALUE4_, serverattr_.FLAGS as FLAGS4_ from SERVER_ATTRIBUTE serverattr_ where serverattr_.ID=?
2011-11-19 19:21:38,113 DEBUG -  Insert 0: insert into SERVER_ATTRIBUTE (CREATED_AT, UPDATED_AT, NAME, SCOPE, VALUE, FLAGS, ID) values (?, ?, ?, ?, ?, ?, ?)
2011-11-19 19:21:38,113 DEBUG -  Update 0: update SERVER_ATTRIBUTE set CREATED_AT=?, UPDATED_AT=?, NAME=?, SCOPE=?, VALUE=?, FLAGS=? where ID=?
2011-11-19 19:21:38,113 DEBUG -  Delete 0: delete from SERVER_ATTRIBUTE where ID=?
2011-11-19 19:21:38,118 DEBUG - Static SQL for entity: net.user1.union.persistence.union.AccountAttribute
2011-11-19 19:21:38,118 DEBUG -  Version select: select id from ACCOUNT_ATTRIBUTE where id =?
2011-11-19 19:21:38,118 DEBUG -  Snapshot select: select accountatt_.id, accountatt_.CREATED_AT as CREATED2_3_, accountatt_.UPDATED_AT as UPDATED3_3_, accountatt_.CLIENT as CLIENT3_, accountatt_.NAME as NAME3_, accountatt_.SCOPE as SCOPE3_, accountatt_.VALUE as VALUE3_, accountatt_.FLAGS as FLAGS3_ from ACCOUNT_ATTRIBUTE accountatt_ where accountatt_.id=?
2011-11-19 19:21:38,118 DEBUG -  Insert 0: insert into ACCOUNT_ATTRIBUTE (CREATED_AT, UPDATED_AT, CLIENT, NAME, SCOPE, VALUE, FLAGS, id) values (?, ?, ?, ?, ?, ?, ?, ?)
2011-11-19 19:21:38,118 DEBUG -  Update 0: update ACCOUNT_ATTRIBUTE set CREATED_AT=?, UPDATED_AT=?, CLIENT=?, NAME=?, SCOPE=?, VALUE=?, FLAGS=? where id=?
2011-11-19 19:21:38,118 DEBUG -  Delete 0: delete from ACCOUNT_ATTRIBUTE where id=?
2011-11-19 19:21:38,126 DEBUG - Static SQL for entity: net.user1.union.persistence.union.PersistentAccount
2011-11-19 19:21:38,127 DEBUG -  Version select: select ID from ACCOUNT where ID =?
2011-11-19 19:21:38,127 DEBUG -  Snapshot select: select persistent_.ID, persistent_.CREATED_AT as CREATED2_0_, persistent_.UPDATED_AT as UPDATED3_0_, persistent_.USERID as USERID0_, persistent_.PASSWORD as PASSWORD0_, persistent_.MODERATOR as MODERATOR0_ from ACCOUNT persistent_ where persistent_.ID=?
2011-11-19 19:21:38,127 DEBUG -  Insert 0: insert into ACCOUNT (CREATED_AT, UPDATED_AT, USERID, PASSWORD, MODERATOR, ID) values (?, ?, ?, ?, ?, ?)
2011-11-19 19:21:38,127 DEBUG -  Update 0: update ACCOUNT set CREATED_AT=?, UPDATED_AT=?, USERID=?, PASSWORD=?, MODERATOR=? where ID=?
2011-11-19 19:21:38,127 DEBUG -  Delete 0: delete from ACCOUNT where ID=?
2011-11-19 19:21:38,131 DEBUG - Static SQL for entity: net.user1.union.persistence.union.RoomAttribute
2011-11-19 19:21:38,132 DEBUG -  Version select: select ID from ROOM_ATTRIBUTE where ID =?
2011-11-19 19:21:38,132 DEBUG -  Snapshot select: select roomattrib_.ID, roomattrib_.CREATED_AT as CREATED2_2_, roomattrib_.UPDATED_AT as UPDATED3_2_, roomattrib_.ROOM as ROOM2_, roomattrib_.NAME as NAME2_, roomattrib_.SCOPE as SCOPE2_, roomattrib_.VALUE as VALUE2_, roomattrib_.FLAGS as FLAGS2_ from ROOM_ATTRIBUTE roomattrib_ where roomattrib_.ID=?
2011-11-19 19:21:38,132 DEBUG -  Insert 0: insert into ROOM_ATTRIBUTE (CREATED_AT, UPDATED_AT, ROOM, NAME, SCOPE, VALUE, FLAGS, ID) values (?, ?, ?, ?, ?, ?, ?, ?)
2011-11-19 19:21:38,132 DEBUG -  Update 0: update ROOM_ATTRIBUTE set CREATED_AT=?, UPDATED_AT=?, ROOM=?, NAME=?, SCOPE=?, VALUE=?, FLAGS=? where ID=?
2011-11-19 19:21:38,132 DEBUG -  Delete 0: delete from ROOM_ATTRIBUTE where ID=?
2011-11-19 19:21:38,135 DEBUG - Static SQL for entity: net.user1.union.persistence.union.PersistentRoom
2011-11-19 19:21:38,135 DEBUG -  Version select: select ID from ROOM where ID =?
2011-11-19 19:21:38,135 DEBUG -  Snapshot select: select persistent_.ID, persistent_.ROOM_QUALIFIER as ROOM2_1_, persistent_.ROOM_ID as ROOM3_1_, persistent_.PASSWORD as PASSWORD1_, persistent_.CREATED_AT as CREATED5_1_, persistent_.UPDATED_AT as UPDATED6_1_ from ROOM persistent_ where persistent_.ID=?
2011-11-19 19:21:38,135 DEBUG -  Insert 0: insert into ROOM (ROOM_QUALIFIER, ROOM_ID, PASSWORD, CREATED_AT, UPDATED_AT, ID) values (?, ?, ?, ?, ?, ?)
2011-11-19 19:21:38,135 DEBUG -  Update 0: update ROOM set ROOM_QUALIFIER=?, ROOM_ID=?, PASSWORD=?, CREATED_AT=?, UPDATED_AT=? where ID=?
2011-11-19 19:21:38,135 DEBUG -  Delete 0: delete from ROOM where ID=?
2011-11-19 19:21:38,151 DEBUG - Static select for entity net.user1.union.persistence.union.AccountAttribute: select accountatt0_.id as id3_0_, accountatt0_.CREATED_AT as CREATED2_3_0_, accountatt0_.UPDATED_AT as UPDATED3_3_0_, accountatt0_.CLIENT as CLIENT3_0_, accountatt0_.NAME as NAME3_0_, accountatt0_.SCOPE as SCOPE3_0_, accountatt0_.VALUE as VALUE3_0_, accountatt0_.FLAGS as FLAGS3_0_ from ACCOUNT_ATTRIBUTE accountatt0_ where accountatt0_.id=?
2011-11-19 19:21:38,151 DEBUG - Static select for entity net.user1.union.persistence.union.AccountAttribute: select accountatt0_.id as id3_0_, accountatt0_.CREATED_AT as CREATED2_3_0_, accountatt0_.UPDATED_AT as UPDATED3_3_0_, accountatt0_.CLIENT as CLIENT3_0_, accountatt0_.NAME as NAME3_0_, accountatt0_.SCOPE as SCOPE3_0_, accountatt0_.VALUE as VALUE3_0_, accountatt0_.FLAGS as FLAGS3_0_ from ACCOUNT_ATTRIBUTE accountatt0_ where accountatt0_.id=?
2011-11-19 19:21:38,151 DEBUG - Static select for entity net.user1.union.persistence.union.AccountAttribute: select accountatt0_.id as id3_0_, accountatt0_.CREATED_AT as CREATED2_3_0_, accountatt0_.UPDATED_AT as UPDATED3_3_0_, accountatt0_.CLIENT as CLIENT3_0_, accountatt0_.NAME as NAME3_0_, accountatt0_.SCOPE as SCOPE3_0_, accountatt0_.VALUE as VALUE3_0_, accountatt0_.FLAGS as FLAGS3_0_ from ACCOUNT_ATTRIBUTE accountatt0_ where accountatt0_.id=? for read only with rs
2011-11-19 19:21:38,151 DEBUG - Static select for entity net.user1.union.persistence.union.AccountAttribute: select accountatt0_.id as id3_0_, accountatt0_.CREATED_AT as CREATED2_3_0_, accountatt0_.UPDATED_AT as UPDATED3_3_0_, accountatt0_.CLIENT as CLIENT3_0_, accountatt0_.NAME as NAME3_0_, accountatt0_.SCOPE as SCOPE3_0_, accountatt0_.VALUE as VALUE3_0_, accountatt0_.FLAGS as FLAGS3_0_ from ACCOUNT_ATTRIBUTE accountatt0_ where accountatt0_.id=? for read only with rs
2011-11-19 19:21:38,151 DEBUG - Static select for entity net.user1.union.persistence.union.AccountAttribute: select accountatt0_.id as id3_0_, accountatt0_.CREATED_AT as CREATED2_3_0_, accountatt0_.UPDATED_AT as UPDATED3_3_0_, accountatt0_.CLIENT as CLIENT3_0_, accountatt0_.NAME as NAME3_0_, accountatt0_.SCOPE as SCOPE3_0_, accountatt0_.VALUE as VALUE3_0_, accountatt0_.FLAGS as FLAGS3_0_ from ACCOUNT_ATTRIBUTE accountatt0_ where accountatt0_.id=? for read only with rs
2011-11-19 19:21:38,157 DEBUG - Static select for action ACTION_MERGE on entity net.user1.union.persistence.union.AccountAttribute: select accountatt0_.id as id3_0_, accountatt0_.CREATED_AT as CREATED2_3_0_, accountatt0_.UPDATED_AT as UPDATED3_3_0_, accountatt0_.CLIENT as CLIENT3_0_, accountatt0_.NAME as NAME3_0_, accountatt0_.SCOPE as SCOPE3_0_, accountatt0_.VALUE as VALUE3_0_, accountatt0_.FLAGS as FLAGS3_0_ from ACCOUNT_ATTRIBUTE accountatt0_ where accountatt0_.id=?
2011-11-19 19:21:38,158 DEBUG - Static select for action ACTION_REFRESH on entity net.user1.union.persistence.union.AccountAttribute: select accountatt0_.id as id3_0_, accountatt0_.CREATED_AT as CREATED2_3_0_, accountatt0_.UPDATED_AT as UPDATED3_3_0_, accountatt0_.CLIENT as CLIENT3_0_, accountatt0_.NAME as NAME3_0_, accountatt0_.SCOPE as SCOPE3_0_, accountatt0_.VALUE as VALUE3_0_, accountatt0_.FLAGS as FLAGS3_0_ from ACCOUNT_ATTRIBUTE accountatt0_ where accountatt0_.id=?
2011-11-19 19:21:38,158 DEBUG - Static select for entity net.user1.union.persistence.union.ServerAttribute: select serverattr0_.ID as ID4_0_, serverattr0_.CREATED_AT as CREATED2_4_0_, serverattr0_.UPDATED_AT as UPDATED3_4_0_, serverattr0_.NAME as NAME4_0_, serverattr0_.SCOPE as SCOPE4_0_, serverattr0_.VALUE as VALUE4_0_, serverattr0_.FLAGS as FLAGS4_0_ from SERVER_ATTRIBUTE serverattr0_ where serverattr0_.ID=?
2011-11-19 19:21:38,158 DEBUG - Static select for entity net.user1.union.persistence.union.ServerAttribute: select serverattr0_.ID as ID4_0_, serverattr0_.CREATED_AT as CREATED2_4_0_, serverattr0_.UPDATED_AT as UPDATED3_4_0_, serverattr0_.NAME as NAME4_0_, serverattr0_.SCOPE as SCOPE4_0_, serverattr0_.VALUE as VALUE4_0_, serverattr0_.FLAGS as FLAGS4_0_ from SERVER_ATTRIBUTE serverattr0_ where serverattr0_.ID=?
2011-11-19 19:21:38,158 DEBUG - Static select for entity net.user1.union.persistence.union.ServerAttribute: select serverattr0_.ID as ID4_0_, serverattr0_.CREATED_AT as CREATED2_4_0_, serverattr0_.UPDATED_AT as UPDATED3_4_0_, serverattr0_.NAME as NAME4_0_, serverattr0_.SCOPE as SCOPE4_0_, serverattr0_.VALUE as VALUE4_0_, serverattr0_.FLAGS as FLAGS4_0_ from SERVER_ATTRIBUTE serverattr0_ where serverattr0_.ID=? for read only with rs
2011-11-19 19:21:38,158 DEBUG - Static select for entity net.user1.union.persistence.union.ServerAttribute: select serverattr0_.ID as ID4_0_, serverattr0_.CREATED_AT as CREATED2_4_0_, serverattr0_.UPDATED_AT as UPDATED3_4_0_, serverattr0_.NAME as NAME4_0_, serverattr0_.SCOPE as SCOPE4_0_, serverattr0_.VALUE as VALUE4_0_, serverattr0_.FLAGS as FLAGS4_0_ from SERVER_ATTRIBUTE serverattr0_ where serverattr0_.ID=? for read only with rs
2011-11-19 19:21:38,158 DEBUG - Static select for entity net.user1.union.persistence.union.ServerAttribute: select serverattr0_.ID as ID4_0_, serverattr0_.CREATED_AT as CREATED2_4_0_, serverattr0_.UPDATED_AT as UPDATED3_4_0_, serverattr0_.NAME as NAME4_0_, serverattr0_.SCOPE as SCOPE4_0_, serverattr0_.VALUE as VALUE4_0_, serverattr0_.FLAGS as FLAGS4_0_ from SERVER_ATTRIBUTE serverattr0_ where serverattr0_.ID=? for read only with rs
2011-11-19 19:21:38,158 DEBUG - Static select for action ACTION_MERGE on entity net.user1.union.persistence.union.ServerAttribute: select serverattr0_.ID as ID4_0_, serverattr0_.CREATED_AT as CREATED2_4_0_, serverattr0_.UPDATED_AT as UPDATED3_4_0_, serverattr0_.NAME as NAME4_0_, serverattr0_.SCOPE as SCOPE4_0_, serverattr0_.VALUE as VALUE4_0_, serverattr0_.FLAGS as FLAGS4_0_ from SERVER_ATTRIBUTE serverattr0_ where serverattr0_.ID=?
2011-11-19 19:21:38,158 DEBUG - Static select for action ACTION_REFRESH on entity net.user1.union.persistence.union.ServerAttribute: select serverattr0_.ID as ID4_0_, serverattr0_.CREATED_AT as CREATED2_4_0_, serverattr0_.UPDATED_AT as UPDATED3_4_0_, serverattr0_.NAME as NAME4_0_, serverattr0_.SCOPE as SCOPE4_0_, serverattr0_.VALUE as VALUE4_0_, serverattr0_.FLAGS as FLAGS4_0_ from SERVER_ATTRIBUTE serverattr0_ where serverattr0_.ID=?
2011-11-19 19:21:38,159 DEBUG - Static select for entity net.user1.union.persistence.union.PersistentAccount: select persistent0_.ID as ID0_0_, persistent0_.CREATED_AT as CREATED2_0_0_, persistent0_.UPDATED_AT as UPDATED3_0_0_, persistent0_.USERID as USERID0_0_, persistent0_.PASSWORD as PASSWORD0_0_, persistent0_.MODERATOR as MODERATOR0_0_ from ACCOUNT persistent0_ where persistent0_.ID=?
2011-11-19 19:21:38,159 DEBUG - Static select for entity net.user1.union.persistence.union.PersistentAccount: select persistent0_.ID as ID0_0_, persistent0_.CREATED_AT as CREATED2_0_0_, persistent0_.UPDATED_AT as UPDATED3_0_0_, persistent0_.USERID as USERID0_0_, persistent0_.PASSWORD as PASSWORD0_0_, persistent0_.MODERATOR as MODERATOR0_0_ from ACCOUNT persistent0_ where persistent0_.ID=?
2011-11-19 19:21:38,159 DEBUG - Static select for entity net.user1.union.persistence.union.PersistentAccount: select persistent0_.ID as ID0_0_, persistent0_.CREATED_AT as CREATED2_0_0_, persistent0_.UPDATED_AT as UPDATED3_0_0_, persistent0_.USERID as USERID0_0_, persistent0_.PASSWORD as PASSWORD0_0_, persistent0_.MODERATOR as MODERATOR0_0_ from ACCOUNT persistent0_ where persistent0_.ID=? for read only with rs
2011-11-19 19:21:38,159 DEBUG - Static select for entity net.user1.union.persistence.union.PersistentAccount: select persistent0_.ID as ID0_0_, persistent0_.CREATED_AT as CREATED2_0_0_, persistent0_.UPDATED_AT as UPDATED3_0_0_, persistent0_.USERID as USERID0_0_, persistent0_.PASSWORD as PASSWORD0_0_, persistent0_.MODERATOR as MODERATOR0_0_ from ACCOUNT persistent0_ where persistent0_.ID=? for read only with rs
2011-11-19 19:21:38,159 DEBUG - Static select for entity net.user1.union.persistence.union.PersistentAccount: select persistent0_.ID as ID0_0_, persistent0_.CREATED_AT as CREATED2_0_0_, persistent0_.UPDATED_AT as UPDATED3_0_0_, persistent0_.USERID as USERID0_0_, persistent0_.PASSWORD as PASSWORD0_0_, persistent0_.MODERATOR as MODERATOR0_0_ from ACCOUNT persistent0_ where persistent0_.ID=? for read only with rs
2011-11-19 19:21:38,159 DEBUG - Static select for action ACTION_MERGE on entity net.user1.union.persistence.union.PersistentAccount: select persistent0_.ID as ID0_0_, persistent0_.CREATED_AT as CREATED2_0_0_, persistent0_.UPDATED_AT as UPDATED3_0_0_, persistent0_.USERID as USERID0_0_, persistent0_.PASSWORD as PASSWORD0_0_, persistent0_.MODERATOR as MODERATOR0_0_ from ACCOUNT persistent0_ where persistent0_.ID=?
2011-11-19 19:21:38,159 DEBUG - Static select for action ACTION_REFRESH on entity net.user1.union.persistence.union.PersistentAccount: select persistent0_.ID as ID0_0_, persistent0_.CREATED_AT as CREATED2_0_0_, persistent0_.UPDATED_AT as UPDATED3_0_0_, persistent0_.USERID as USERID0_0_, persistent0_.PASSWORD as PASSWORD0_0_, persistent0_.MODERATOR as MODERATOR0_0_ from ACCOUNT persistent0_ where persistent0_.ID=?
2011-11-19 19:21:38,159 DEBUG - Static select for entity net.user1.union.persistence.union.RoomAttribute: select roomattrib0_.ID as ID2_0_, roomattrib0_.CREATED_AT as CREATED2_2_0_, roomattrib0_.UPDATED_AT as UPDATED3_2_0_, roomattrib0_.ROOM as ROOM2_0_, roomattrib0_.NAME as NAME2_0_, roomattrib0_.SCOPE as SCOPE2_0_, roomattrib0_.VALUE as VALUE2_0_, roomattrib0_.FLAGS as FLAGS2_0_ from ROOM_ATTRIBUTE roomattrib0_ where roomattrib0_.ID=?
2011-11-19 19:21:38,160 DEBUG - Static select for entity net.user1.union.persistence.union.RoomAttribute: select roomattrib0_.ID as ID2_0_, roomattrib0_.CREATED_AT as CREATED2_2_0_, roomattrib0_.UPDATED_AT as UPDATED3_2_0_, roomattrib0_.ROOM as ROOM2_0_, roomattrib0_.NAME as NAME2_0_, roomattrib0_.SCOPE as SCOPE2_0_, roomattrib0_.VALUE as VALUE2_0_, roomattrib0_.FLAGS as FLAGS2_0_ from ROOM_ATTRIBUTE roomattrib0_ where roomattrib0_.ID=?
2011-11-19 19:21:38,160 DEBUG - Static select for entity net.user1.union.persistence.union.RoomAttribute: select roomattrib0_.ID as ID2_0_, roomattrib0_.CREATED_AT as CREATED2_2_0_, roomattrib0_.UPDATED_AT as UPDATED3_2_0_, roomattrib0_.ROOM as ROOM2_0_, roomattrib0_.NAME as NAME2_0_, roomattrib0_.SCOPE as SCOPE2_0_, roomattrib0_.VALUE as VALUE2_0_, roomattrib0_.FLAGS as FLAGS2_0_ from ROOM_ATTRIBUTE roomattrib0_ where roomattrib0_.ID=? for read only with rs
2011-11-19 19:21:38,160 DEBUG - Static select for entity net.user1.union.persistence.union.RoomAttribute: select roomattrib0_.ID as ID2_0_, roomattrib0_.CREATED_AT as CREATED2_2_0_, roomattrib0_.UPDATED_AT as UPDATED3_2_0_, roomattrib0_.ROOM as ROOM2_0_, roomattrib0_.NAME as NAME2_0_, roomattrib0_.SCOPE as SCOPE2_0_, roomattrib0_.VALUE as VALUE2_0_, roomattrib0_.FLAGS as FLAGS2_0_ from ROOM_ATTRIBUTE roomattrib0_ where roomattrib0_.ID=? for read only with rs
2011-11-19 19:21:38,160 DEBUG - Static select for entity net.user1.union.persistence.union.RoomAttribute: select roomattrib0_.ID as ID2_0_, roomattrib0_.CREATED_AT as CREATED2_2_0_, roomattrib0_.UPDATED_AT as UPDATED3_2_0_, roomattrib0_.ROOM as ROOM2_0_, roomattrib0_.NAME as NAME2_0_, roomattrib0_.SCOPE as SCOPE2_0_, roomattrib0_.VALUE as VALUE2_0_, roomattrib0_.FLAGS as FLAGS2_0_ from ROOM_ATTRIBUTE roomattrib0_ where roomattrib0_.ID=? for read only with rs
2011-11-19 19:21:38,160 DEBUG - Static select for action ACTION_MERGE on entity net.user1.union.persistence.union.RoomAttribute: select roomattrib0_.ID as ID2_0_, roomattrib0_.CREATED_AT as CREATED2_2_0_, roomattrib0_.UPDATED_AT as UPDATED3_2_0_, roomattrib0_.ROOM as ROOM2_0_, roomattrib0_.NAME as NAME2_0_, roomattrib0_.SCOPE as SCOPE2_0_, roomattrib0_.VALUE as VALUE2_0_, roomattrib0_.FLAGS as FLAGS2_0_ from ROOM_ATTRIBUTE roomattrib0_ where roomattrib0_.ID=?
2011-11-19 19:21:38,160 DEBUG - Static select for action ACTION_REFRESH on entity net.user1.union.persistence.union.RoomAttribute: select roomattrib0_.ID as ID2_0_, roomattrib0_.CREATED_AT as CREATED2_2_0_, roomattrib0_.UPDATED_AT as UPDATED3_2_0_, roomattrib0_.ROOM as ROOM2_0_, roomattrib0_.NAME as NAME2_0_, roomattrib0_.SCOPE as SCOPE2_0_, roomattrib0_.VALUE as VALUE2_0_, roomattrib0_.FLAGS as FLAGS2_0_ from ROOM_ATTRIBUTE roomattrib0_ where roomattrib0_.ID=?
2011-11-19 19:21:38,160 DEBUG - Static select for entity net.user1.union.persistence.union.PersistentRoom: select persistent0_.ID as ID1_0_, persistent0_.ROOM_QUALIFIER as ROOM2_1_0_, persistent0_.ROOM_ID as ROOM3_1_0_, persistent0_.PASSWORD as PASSWORD1_0_, persistent0_.CREATED_AT as CREATED5_1_0_, persistent0_.UPDATED_AT as UPDATED6_1_0_ from ROOM persistent0_ where persistent0_.ID=?
2011-11-19 19:21:38,160 DEBUG - Static select for entity net.user1.union.persistence.union.PersistentRoom: select persistent0_.ID as ID1_0_, persistent0_.ROOM_QUALIFIER as ROOM2_1_0_, persistent0_.ROOM_ID as ROOM3_1_0_, persistent0_.PASSWORD as PASSWORD1_0_, persistent0_.CREATED_AT as CREATED5_1_0_, persistent0_.UPDATED_AT as UPDATED6_1_0_ from ROOM persistent0_ where persistent0_.ID=?
2011-11-19 19:21:38,160 DEBUG - Static select for entity net.user1.union.persistence.union.PersistentRoom: select persistent0_.ID as ID1_0_, persistent0_.ROOM_QUALIFIER as ROOM2_1_0_, persistent0_.ROOM_ID as ROOM3_1_0_, persistent0_.PASSWORD as PASSWORD1_0_, persistent0_.CREATED_AT as CREATED5_1_0_, persistent0_.UPDATED_AT as UPDATED6_1_0_ from ROOM persistent0_ where persistent0_.ID=? for read only with rs
2011-11-19 19:21:38,161 DEBUG - Static select for entity net.user1.union.persistence.union.PersistentRoom: select persistent0_.ID as ID1_0_, persistent0_.ROOM_QUALIFIER as ROOM2_1_0_, persistent0_.ROOM_ID as ROOM3_1_0_, persistent0_.PASSWORD as PASSWORD1_0_, persistent0_.CREATED_AT as CREATED5_1_0_, persistent0_.UPDATED_AT as UPDATED6_1_0_ from ROOM persistent0_ where persistent0_.ID=? for read only with rs
2011-11-19 19:21:38,161 DEBUG - Static select for entity net.user1.union.persistence.union.PersistentRoom: select persistent0_.ID as ID1_0_, persistent0_.ROOM_QUALIFIER as ROOM2_1_0_, persistent0_.ROOM_ID as ROOM3_1_0_, persistent0_.PASSWORD as PASSWORD1_0_, persistent0_.CREATED_AT as CREATED5_1_0_, persistent0_.UPDATED_AT as UPDATED6_1_0_ from ROOM persistent0_ where persistent0_.ID=? for read only with rs
2011-11-19 19:21:38,161 DEBUG - Static select for action ACTION_MERGE on entity net.user1.union.persistence.union.PersistentRoom: select persistent0_.ID as ID1_0_, persistent0_.ROOM_QUALIFIER as ROOM2_1_0_, persistent0_.ROOM_ID as ROOM3_1_0_, persistent0_.PASSWORD as PASSWORD1_0_, persistent0_.CREATED_AT as CREATED5_1_0_, persistent0_.UPDATED_AT as UPDATED6_1_0_ from ROOM persistent0_ where persistent0_.ID=?
2011-11-19 19:21:38,161 DEBUG - Static select for action ACTION_REFRESH on entity net.user1.union.persistence.union.PersistentRoom: select persistent0_.ID as ID1_0_, persistent0_.ROOM_QUALIFIER as ROOM2_1_0_, persistent0_.ROOM_ID as ROOM3_1_0_, persistent0_.PASSWORD as PASSWORD1_0_, persistent0_.CREATED_AT as CREATED5_1_0_, persistent0_.UPDATED_AT as UPDATED6_1_0_ from ROOM persistent0_ where persistent0_.ID=?
2011-11-19 19:21:38,162 DEBUG - initializing class SessionFactoryObjectFactory
2011-11-19 19:21:38,163 DEBUG - registered: 8a81818433ba7cc10133ba7cc1f10000 (unnamed)
2011-11-19 19:21:38,163 INFO  - Not binding factory to JNDI, no JNDI name configured
2011-11-19 19:21:38,163 DEBUG - instantiated session factory
2011-11-19 19:21:38,169 INFO  - Running hbm2ddl schema update
2011-11-19 19:21:38,169 INFO  - fetching database metadata
2011-11-19 19:21:38,172 INFO  - updating schema
2011-11-19 19:21:38,173 DEBUG - processing extends queue
2011-11-19 19:21:38,173 DEBUG - processing collection mappings
2011-11-19 19:21:38,173 DEBUG - processing native query and ResultSetMapping mappings
2011-11-19 19:21:38,173 DEBUG - processing association property references
2011-11-19 19:21:38,173 DEBUG - processing foreign key constraints
2011-11-19 19:21:38,649 INFO  - table found: .APP.ACCOUNT
2011-11-19 19:21:38,649 INFO  - columns: [id, updated_at, moderator, userid, created_at, password]
2011-11-19 19:21:38,649 INFO  - foreign keys: []
2011-11-19 19:21:38,649 INFO  - indexes: [sql111117024500810]
2011-11-19 19:21:38,666 INFO  - table found: .APP.ACCOUNT_ATTRIBUTE
2011-11-19 19:21:38,666 INFO  - columns: [id, flags, scope, updated_at, client, name, value, created_at]
2011-11-19 19:21:38,666 INFO  - foreign keys: []
2011-11-19 19:21:38,666 INFO  - indexes: [sql111117024500950]
2011-11-19 19:21:38,674 INFO  - table found: .APP.ROOM
2011-11-19 19:21:38,674 INFO  - columns: [id, room_qualifier, updated_at, created_at, room_id, password]
2011-11-19 19:21:38,674 INFO  - foreign keys: []
2011-11-19 19:21:38,674 INFO  - indexes: [sql111117024501050]
2011-11-19 19:21:38,682 INFO  - table found: .APP.ROOM_ATTRIBUTE
2011-11-19 19:21:38,682 INFO  - columns: [id, flags, scope, updated_at, name, value, created_at, room]
2011-11-19 19:21:38,682 INFO  - foreign keys: []
2011-11-19 19:21:38,682 INFO  - indexes: [sql111117024501190]
2011-11-19 19:21:38,693 INFO  - table found: .APP.SERVER_ATTRIBUTE
2011-11-19 19:21:38,693 INFO  - columns: [id, flags, scope, updated_at, name, value, created_at]
2011-11-19 19:21:38,693 INFO  - foreign keys: []
2011-11-19 19:21:38,693 INFO  - indexes: [sql111117024501310]
2011-11-19 19:21:38,698 INFO  - table found: .APP.HIBERNATE_UNIQUE_KEY
2011-11-19 19:21:38,698 INFO  - columns: [next_hi]
2011-11-19 19:21:38,698 INFO  - foreign keys: []
2011-11-19 19:21:38,698 INFO  - indexes: []
2011-11-19 19:21:38,698 INFO  - schema update complete
2011-11-19 19:21:38,699 DEBUG - Checking 0 named HQL queries
2011-11-19 19:21:38,699 DEBUG - Checking 0 named SQL queries
2011-11-19 19:21:38,700 WARN  - Datasource [union] added to server.
2011-11-19 19:21:38,703 WARN  - Banned list file [banned.txt] not found.  Banned list not initiated.
2011-11-19 19:21:38,790 WARN  - Gateway [PrimaryGateway] bound to port [9100] on all local IP addresses.
2011-11-19 19:21:38,790 INFO  - Gateway [PrimaryGateway] added to the Server.
2011-11-19 19:21:38,792 WARN  - POLICY_FILE attribute missing for Gateway [AdminGateway].  Using default [policy.xml].
2011-11-19 19:21:38,793 WARN  - Gateway [AdminGateway] bound to port [9110] on all local IP addresses.
2011-11-19 19:21:38,794 INFO  - Gateway [AdminGateway] added to the Server.
2011-11-19 19:21:38,794 WARN  - Admin Gateway Started.
2011-11-19 19:21:38,821 DEBUG - opened session at timestamp: 13216836987
2011-11-19 19:21:38,822 DEBUG - begin
2011-11-19 19:21:38,822 DEBUG - opening JDBC connection
2011-11-19 19:21:38,822 DEBUG - current autocommit status: false
2011-11-19 19:21:38,866 DEBUG - parse() - HQL: from net.user1.union.persistence.union.ServerAttribute
2011-11-19 19:21:38,870 DEBUG - Keyword  'union' is being interpreted as an identifier due to: expecting IDENT, found 'union'
2011-11-19 19:21:38,870 DEBUG - Keyword  'union' is being interpreted as an identifier due to: expecting IDENT, found 'union'
2011-11-19 19:21:38,875 DEBUG - --- HQL AST ---
\-[QUERY] 'query'
    \-[SELECT_FROM] 'SELECT_FROM'
       \-[FROM] 'from'
          \-[RANGE] 'RANGE'
             \-[DOT] '.'
                +-[DOT] '.'
                |  +-[DOT] '.'
                |  |  +-[DOT] '.'
                |  |  |  +-[DOT] '.'
                |  |  |  |  +-[IDENT] 'net'
                |  |  |  |  \-[IDENT] 'user1'
                |  |  |  \-[WEIRD_IDENT] 'union'
                |  |  \-[IDENT] 'persistence'
                |  \-[WEIRD_IDENT] 'union'
                \-[IDENT] 'ServerAttribute'

2011-11-19 19:21:38,875 DEBUG - throwQueryException() : no errors
2011-11-19 19:21:38,902 DEBUG - select << begin [level=1, statement=select]
2011-11-19 19:21:38,915 DEBUG - FromClause{level=1} :  net.user1.union.persistence.union.ServerAttribute (no alias) -> serverattr0_
2011-11-19 19:21:38,915 DEBUG - select : finishing up [level=1, statement=select]
2011-11-19 19:21:38,915 DEBUG - processQuery() :  ( SELECT ( FromClause{level=1} SERVER_ATTRIBUTE serverattr0_ ) )
2011-11-19 19:21:38,920 DEBUG - Derived SELECT clause created.
2011-11-19 19:21:38,924 DEBUG - Using FROM fragment [SERVER_ATTRIBUTE serverattr0_]
2011-11-19 19:21:38,924 DEBUG - select >> end [level=1, statement=select]
2011-11-19 19:21:38,925 DEBUG - --- SQL AST ---
\-[SELECT] QueryNode: 'SELECT'  querySpaces (SERVER_ATTRIBUTE)
    +-[SELECT_CLAUSE] SelectClause: '{derived select clause}'
    |  +-[SELECT_EXPR] SelectExpressionImpl: 'serverattr0_.ID as ID4_' {FromElement{explicit,not a collection join,not a fetch join,fetch non-lazy properties,classAlias=null,role=null,tableName=SERVER_ATTRIBUTE,tableAlias=serverattr0_,origin=null,colums={,className=net.user1.union.persistence.union.ServerAttribute}}}
    |  \-[SQL_TOKEN] SqlFragment: 'serverattr0_.CREATED_AT as CREATED2_4_, serverattr0_.UPDATED_AT as UPDATED3_4_, serverattr0_.NAME as NAME4_, serverattr0_.SCOPE as SCOPE4_, serverattr0_.VALUE as VALUE4_, serverattr0_.FLAGS as FLAGS4_'
    \-[FROM] FromClause: 'from' FromClause{level=1, fromElementCounter=1, fromElements=1, fromElementByClassAlias=[], fromElementByTableAlias=[serverattr0_], fromElementsByPath=[], collectionJoinFromElementsByPath=[], impliedElements=[]}
       \-[FROM_FRAGMENT] FromElement: 'SERVER_ATTRIBUTE serverattr0_' FromElement{explicit,not a collection join,not a fetch join,fetch non-lazy properties,classAlias=null,role=null,tableName=SERVER_ATTRIBUTE,tableAlias=serverattr0_,origin=null,colums={,className=net.user1.union.persistence.union.ServerAttribute}}

2011-11-19 19:21:38,925 DEBUG - throwQueryException() : no errors
2011-11-19 19:21:38,933 DEBUG - HQL: from net.user1.union.persistence.union.ServerAttribute
2011-11-19 19:21:38,933 DEBUG - SQL: select serverattr0_.ID as ID4_, serverattr0_.CREATED_AT as CREATED2_4_, serverattr0_.UPDATED_AT as UPDATED3_4_, serverattr0_.NAME as NAME4_, serverattr0_.SCOPE as SCOPE4_, serverattr0_.VALUE as VALUE4_, serverattr0_.FLAGS as FLAGS4_ from SERVER_ATTRIBUTE serverattr0_
2011-11-19 19:21:38,933 DEBUG - throwQueryException() : no errors
2011-11-19 19:21:38,944 DEBUG - about to open PreparedStatement (open PreparedStatements: 0, globally: 0)
2011-11-19 19:21:38,944 DEBUG - select serverattr0_.ID as ID4_, serverattr0_.CREATED_AT as CREATED2_4_, serverattr0_.UPDATED_AT as UPDATED3_4_, serverattr0_.NAME as NAME4_, serverattr0_.SCOPE as SCOPE4_, serverattr0_.VALUE as VALUE4_, serverattr0_.FLAGS as FLAGS4_ from SERVER_ATTRIBUTE serverattr0_
2011-11-19 19:21:38,951 DEBUG - about to open ResultSet (open ResultSets: 0, globally: 0)
2011-11-19 19:21:38,952 DEBUG - about to close ResultSet (open ResultSets: 1, globally: 1)
2011-11-19 19:21:38,952 DEBUG - about to close PreparedStatement (open PreparedStatements: 1, globally: 1)
2011-11-19 19:21:38,953 DEBUG - initializing non-lazy collections
2011-11-19 19:21:38,953 DEBUG - commit
2011-11-19 19:21:38,954 DEBUG - committed JDBC Connection
2011-11-19 19:21:38,954 DEBUG - aggressively releasing JDBC connection
2011-11-19 19:21:38,954 DEBUG - releasing JDBC connection [ (open PreparedStatements: 0, globally: 0) (open ResultSets: 0, globally: 0)]
2011-11-19 19:21:38,957 WARN  - Union Server 1.1.0 (build 530) Started....OK

I changed the chat.html from the "tryunion.com" to my ip address "10.0.0.4"
Opened Chrome to the file "file:///C:/wamp/www/chat.html", after a few seconds: "Orbiter connection closed."

Checked log.txt and derby.txt, neither have changed.

Here is a full log from Chrome:

Code: Select all

11/19/11 19:29:29.657 UTC+13 INFO: User Agent: Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/535.2 (KHTML, like Gecko) Chrome/15.0.874.120 Safari/535.2 Win32
OrbiterMicro_1.1.0.514_Release.js:83511/19/11 19:29:29.658 UTC+13 INFO: Union Client Version: OrbiterMicro 1.1.0 (Build 514)
OrbiterMicro_1.1.0.514_Release.js:83511/19/11 19:29:29.658 UTC+13 INFO: Client UPC Protocol Version: 1.9.3
OrbiterMicro_1.1.0.514_Release.js:83511/19/11 19:29:29.659 UTC+13 INFO: [CONNECTION_MANAGER] Ready timeout set to 10000 ms.
OrbiterMicro_1.1.0.514_Release.js:83511/19/11 19:29:29.659 UTC+13 INFO: [CONNECTION_MONITOR] Auto-reconnect attempt limit set to none.
OrbiterMicro_1.1.0.514_Release.js:83511/19/11 19:29:29.659 UTC+13 INFO: [CONNECTION_MONITOR] Connection timeout set to 60000 ms.
OrbiterMicro_1.1.0.514_Release.js:83511/19/11 19:29:29.659 UTC+13 INFO: [CONNECTION_MONITOR] Heartbeat frequency set to 10000 ms.
OrbiterMicro_1.1.0.514_Release.js:83511/19/11 19:29:29.659 UTC+13 INFO: [ORBITERMICRO] Initialization complete.
OrbiterMicro_1.1.0.514_Release.js:83511/19/11 19:29:29.660 UTC+13 INFO:  [CONNECTION_MANAGER] New connection added. [WEBSOCKET, host: 10.0.0.4, port: 80].
OrbiterMicro_1.1.0.514_Release.js:83511/19/11 19:29:29.661 UTC+13 INFO:  [CONNECTION_MANAGER] New connection added. [HTTPDirectConnection, host: 10.0.0.4, port: 80, send-delay: 300].
OrbiterMicro_1.1.0.514_Release.js:83511/19/11 19:29:29.661 UTC+13 INFO:  [ORBITER] Connecting to Union...
OrbiterMicro_1.1.0.514_Release.js:83511/19/11 19:29:29.661 UTC+13 DEBUG: [CONNECTION_MANAGER] Searching for most recent valid connection.
OrbiterMicro_1.1.0.514_Release.js:83511/19/11 19:29:29.661 UTC+13 DEBUG: [WEBSOCKET, host: 10.0.0.4, port: 80] Connection is valid because it has either never attempted to connect, or has not attempted to connect since its last successful connection.
OrbiterMicro_1.1.0.514_Release.js:83511/19/11 19:29:29.661 UTC+13 INFO:  [CONNECTION_MANAGER] Attempting connection via [WEBSOCKET, host: 10.0.0.4, port: 80]. (Connection 1 of 2. Attempt 1 since last successful connection).
OrbiterMicro_1.1.0.514_Release.js:83511/19/11 19:29:29.661 UTC+13 INFO:  Attempting connection via [WEBSOCKET, host: 10.0.0.4, port: 80].
OrbiterMicro_1.1.0.514_Release.js:83511/19/11 19:29:39.669 UTC+13 WARN:  [CONNECTION] [WEBSOCKET, host: 10.0.0.4, port: 80] Failed to achieve ready state after 10000ms. Aborting connection...
OrbiterMicro_1.1.0.514_Release.js:83511/19/11 19:29:39.669 UTC+13 DEBUG: [CONNECTION] [WEBSOCKET, host: 10.0.0.4, port: 80] Deactivating...
OrbiterMicro_1.1.0.514_Release.js:83511/19/11 19:29:39.669 UTC+13 INFO:  [MESSAGE_MANAGER] Removing registered message listeners.
OrbiterMicro_1.1.0.514_Release.js:83511/19/11 19:29:39.669 UTC+13 WARN:  [CONNECTION_MANAGER] Connection failed for [WEBSOCKET, host: 10.0.0.4, port: 80]. Status: [Client closed connection before READY state was achieved.]
OrbiterMicro_1.1.0.514_Release.js:83511/19/11 19:29:39.669 UTC+13 INFO:  [CONNECTION_MANAGER] Attempting connection via [HTTPDirectConnection, host: 10.0.0.4, port: 80, send-delay: 300]. (Connection 2 of 2. Attempt 1 since last successful connection).
OrbiterMicro_1.1.0.514_Release.js:83511/19/11 19:29:39.669 UTC+13 INFO:  Attempting connection via [HTTPDirectConnection, host: 10.0.0.4, port: 80, send-delay: 300].
OrbiterMicro_1.1.0.514_Release.js:83511/19/11 19:29:39.669 UTC+13 DEBUG: [HTTPDirectConnection, host: 10.0.0.4, port: 80, send-delay: 300] Sending CLIENT_HELLO: <U><M>u65</M><L><A>OrbiterMicro</A><A>Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/535.2 (KHTML, like Gecko) Chrome/15.0.874.120 Safari/535.2;1.1.0 (Build 514)</A><A>1.9.3</A></L></U>
OrbiterMicro_1.1.0.514_Release.js:83511/19/11 19:29:49.674 UTC+13 WARN:  [CONNECTION] [HTTPDirectConnection, host: 10.0.0.4, port: 80, send-delay: 300] Failed to achieve ready state after 10000ms. Aborting connection...
OrbiterMicro_1.1.0.514_Release.js:83511/19/11 19:29:49.674 UTC+13 DEBUG: [CONNECTION] [HTTPDirectConnection, host: 10.0.0.4, port: 80, send-delay: 300] Deactivating...
OrbiterMicro_1.1.0.514_Release.js:83511/19/11 19:29:49.674 UTC+13 DEBUG: [CONNECTION] [HTTPDirectConnection, host: 10.0.0.4, port: 80, send-delay: 300] Closing all pending HTTP requests.
OrbiterMicro_1.1.0.514_Release.js:83511/19/11 19:29:49.674 UTC+13 ERROR: [CONNECTION][HTTPDirectConnection, host: 10.0.0.4, port: 80, send-delay: 300] u65 (CLIENT_HELLO) request failed. Connection is no longer in progress, so no retry scheduled.
OrbiterMicro_1.1.0.514_Release.js:83511/19/11 19:29:49.674 UTC+13 INFO:  [MESSAGE_MANAGER] Removing registered message listeners.
OrbiterMicro_1.1.0.514_Release.js:83511/19/11 19:29:49.674 UTC+13 WARN:  [CONNECTION_MANAGER] Connection failed for [HTTPDirectConnection, host: 10.0.0.4, port: 80, send-delay: 300]. Status: [Client closed connection before READY state was achieved.]
OrbiterMicro_1.1.0.514_Release.js:83511/19/11 19:29:49.674 UTC+13 INFO:  [CONNECTION_MANAGER] Connection failed for all specified hosts and ports.

I then tried to change the chat.html to "localhost" - no changes in either log, and the Chrome log looked the same.

Thank you in advance for your help.

Kind Regards

[colin]

it looks to me like your server is binding to port 9100, but your chat is attempting to connect to port 80. try editing union.xml to include port 80 in the <gateways> tag. if that doesn't work, please post your union.xml file.

colin

[Stylesoftware]

Hi Colin,

Great thank you for your help, it works now.

Ah I see what my problem was, I didn't realise the user guide was in your site menu.
It perhaps should be singular link in the Unionserver download page, or the Download menu page, or a doc in the union server zip file.

Actually having a quick look around I can't see an obvious link to official documentation for 1.1.0 ?

(Its possible I'm still a bit blind :-)

Kind Regards

[colin]

1) tryunion.com is back up

2) Union Server's documentation main page is:
http://www.unionplatform.com/?page_id=5

i believe the menu on the right provides links to the content you are looking for:
System Requirements
Union Admin
Union User Guide
Union API Reference

for information about port 80 and recommended gateway setup, see:
http://www.unionplatform.com/?page_id=420

colin