users@grizzly.java.net

Re: Problem with Grizzly/Comet on Glassfish 3.1.2

From: Enrique Ubinas <enrique.ubinas_at_gmail.com>
Date: Thu, 21 Jun 2012 14:27:55 -0400

Hey Oleksiy,

So I can confirm that Comet Support has been enabled on all protocols. I
made a small CometTest web app and the results were different. This time
around, I'm getting notification events but the data in the notification
responses is inconsistent. About half of the time, it correctly displays
the incremented value and the other half it displays null. My testing
process went as follows, I opened up three browser windows and I started
clicking the increment link on any of the three windows.

Attached is my War file with the source code inside. Let me know what you
find.

Thanks,

On Wed, Jun 20, 2012 at 3:16 PM, Oleksiy Stashok <oleksiy.stashok_at_oracle.com
> wrote:

> Hi,
>
>
>
> I'm having this problem all the time with every long polling request I
> make.
>
> Ok. Looks like it's really config issue.
>
>
> Is there another way to check if comet support is enabled, other than
> using the admin console?
>
> Usually if comet is disabled - you'd see warning in the log, I don't see
> it, so looks like comet is enabled.
> What we can do to make sure comet is enabled - let's enable it for all
> listeners. Pls. open GF domain.xml file and make sure all protocols like:
>
> <protocol name="http-listener-<N>">
> <http default-virtual-server="server" max-connections="250" *
> comet-support-enabled="true"*>
> <file-cache></file-cache>
> </http>
> </protocol>
>
> have comet-support-enabled attribute set to true.
> If it doesn't help - pls. create a small webapp so we can reproduce the
> issue and suggest the solution.
>
> Thanks.
>
> WBR,
> Alexey.
>
>
> To me it seems like it's one of these possibilities,
>
> 1. Comet Support is not enabled, even though I enabled it via admin
> console.
> 2. Comet Support is enabled and is not sending the NOTIFY event and not
> reporting anything to server.log.
> 3. Comet Support is enabled and the CometHandler is not receiving the
> NOTIFY event.
>
> What is the best method of testing each of these cases? Is there another
> setting in glassfish that I need to enable or disable? I'll send a test
> case in a few hours.
>
> Thank you,
>
> On Wed, Jun 20, 2012 at 11:21 AM, Enrique Ubinas <
> enrique.ubinas_at_gmail.com> wrote:
>
>> This is the server.log file. For whatever reason there is no mention of
>> any comet related function other than the System.out calls that I made. I
>> did enable comet support through the admin console. Is it possible that
>> it's still not enabled?
>>
>> [#|2012-06-20T10:24:40.551-0400|INFO|oracle-glassfish3.1.2|javax.enterprise.system.container.web.com.sun.enterprise.web|_ThreadID=16;_ThreadName=Thread-2;|WEB0671:
>> Loading application [WebPortalEAR#WebPortalServlets.war] at [webportal]|#]
>>
>> [#|2012-06-20T10:24:40.558-0400|INFO|oracle-glassfish3.1.2|javax.enterprise.system.core.com.sun.enterprise.v3.server|_ThreadID=24;_ThreadName=Thread-2;|CORE10010:
>> Loading application WebPortalEAR done in 0 ms|#]
>>
>> [#|2012-06-20T10:25:38.288-0400|INFO|oracle-glassfish3.1.2|javax.enterprise.system.std.com.sun.enterprise.server.logging|_ThreadID=25;_ThreadName=Thread-2;|CompanyLocationsService
>> is initialized.|#]
>>
>> [#|2012-06-20T10:25:38.289-0400|INFO|oracle-glassfish3.1.2|javax.enterprise.system.std.com.sun.enterprise.server.logging|_ThreadID=25;_ThreadName=Thread-2;|CompanyLocationsService
>> received a request of type INITIAL_REQUEST.|#]
>>
>> [#|2012-06-20T10:25:38.342-0400|FINE|oracle-glassfish3.1.2|org.eclipse.persistence.session.file:/opt/glassfish3/glassfish/domains/anon_domain_1/applications/WebPortalEAR/WebPortalEJB_jar/_anon_unit.sql|_ThreadID=25;_ThreadName=Thread-2;ClassName=null;MethodName=null;|SELECT
>> ID, NAME FROM company WHERE (NAME = ?)
>> bind => [1 parameter bound]|#]
>>
>> [#|2012-06-20T10:25:38.370-0400|FINE|oracle-glassfish3.1.2|org.eclipse.persistence.session.file:/opt/glassfish3/glassfish/domains/anon_domain_1/applications/WebPortalEAR/WebPortalEJB_jar/_anon_unit.sql|_ThreadID=25;_ThreadName=Thread-2;ClassName=null;MethodName=null;|SELECT
>> t1.ID, t1.LINE, t1.CITY_ID, t1.COUNTRY_ID, t1.STATE_ID, t1.zip_code_id FROM
>> company_address t0, address t1 WHERE ((t0.company_id = ?) AND (t1.ID =
>> t0.address_id))
>> bind => [1 parameter bound]|#]
>>
>> [#|2012-06-20T10:25:38.372-0400|FINE|oracle-glassfish3.1.2|org.eclipse.persistence.session.file:/opt/glassfish3/glassfish/domains/anon_domain_1/applications/WebPortalEAR/WebPortalEJB_jar/_anon_unit.sql|_ThreadID=25;_ThreadName=Thread-2;ClassName=null;MethodName=null;|SELECT
>> ID, NAME, COUNTRY_ID, STATE_ID FROM city WHERE (ID = ?)
>> bind => [1 parameter bound]|#]
>>
>> [#|2012-06-20T10:25:38.375-0400|FINE|oracle-glassfish3.1.2|org.eclipse.persistence.session.file:/opt/glassfish3/glassfish/domains/anon_domain_1/applications/WebPortalEAR/WebPortalEJB_jar/_anon_unit.sql|_ThreadID=25;_ThreadName=Thread-2;ClassName=null;MethodName=null;|SELECT
>> ID, NAME FROM country WHERE (ID = ?)
>> bind => [1 parameter bound]|#]
>>
>> [#|2012-06-20T10:25:38.377-0400|FINE|oracle-glassfish3.1.2|org.eclipse.persistence.session.file:/opt/glassfish3/glassfish/domains/anon_domain_1/applications/WebPortalEAR/WebPortalEJB_jar/_anon_unit.sql|_ThreadID=25;_ThreadName=Thread-2;ClassName=null;MethodName=null;|SELECT
>> ID, NAME, COUNTRY_ID FROM state WHERE (ID = ?)
>> bind => [1 parameter bound]|#]
>>
>> [#|2012-06-20T10:25:38.378-0400|FINE|oracle-glassfish3.1.2|org.eclipse.persistence.session.file:/opt/glassfish3/glassfish/domains/anon_domain_1/applications/WebPortalEAR/WebPortalEJB_jar/_anon_unit.sql|_ThreadID=25;_ThreadName=Thread-2;ClassName=null;MethodName=null;|SELECT
>> ID, NUMBER, CITY_ID, COUNTRY_ID, STATE_ID FROM zip_code WHERE (ID = ?)
>> bind => [1 parameter bound]|#]
>>
>> [#|2012-06-20T10:25:38.380-0400|FINE|oracle-glassfish3.1.2|org.eclipse.persistence.session.file:/opt/glassfish3/glassfish/domains/anon_domain_1/applications/WebPortalEAR/WebPortalEJB_jar/_anon_unit.sql|_ThreadID=25;_ThreadName=Thread-2;ClassName=null;MethodName=null;|SELECT
>> ID, NUMBER, CITY_ID, COUNTRY_ID, STATE_ID FROM zip_code WHERE (ID = ?)
>> bind => [1 parameter bound]|#]
>>
>> [#|2012-06-20T10:25:38.381-0400|FINE|oracle-glassfish3.1.2|org.eclipse.persistence.session.file:/opt/glassfish3/glassfish/domains/anon_domain_1/applications/WebPortalEAR/WebPortalEJB_jar/_anon_unit.sql|_ThreadID=25;_ThreadName=Thread-2;ClassName=null;MethodName=null;|SELECT
>> ID, NAME, COUNTRY_ID, STATE_ID FROM city WHERE (ID = ?)
>> bind => [1 parameter bound]|#]
>>
>> [#|2012-06-20T10:25:38.382-0400|FINE|oracle-glassfish3.1.2|org.eclipse.persistence.session.file:/opt/glassfish3/glassfish/domains/anon_domain_1/applications/WebPortalEAR/WebPortalEJB_jar/_anon_unit.sql|_ThreadID=25;_ThreadName=Thread-2;ClassName=null;MethodName=null;|SELECT
>> ID, NAME FROM country WHERE (ID = ?)
>> bind => [1 parameter bound]|#]
>>
>> [#|2012-06-20T10:25:38.383-0400|FINE|oracle-glassfish3.1.2|org.eclipse.persistence.session.file:/opt/glassfish3/glassfish/domains/anon_domain_1/applications/WebPortalEAR/WebPortalEJB_jar/_anon_unit.sql|_ThreadID=25;_ThreadName=Thread-2;ClassName=null;MethodName=null;|SELECT
>> ID, NAME, COUNTRY_ID FROM state WHERE (ID = ?)
>> bind => [1 parameter bound]|#]
>>
>> [#|2012-06-20T10:25:38.385-0400|FINE|oracle-glassfish3.1.2|org.eclipse.persistence.session.file:/opt/glassfish3/glassfish/domains/anon_domain_1/applications/WebPortalEAR/WebPortalEJB_jar/_anon_unit.sql|_ThreadID=25;_ThreadName=Thread-2;ClassName=null;MethodName=null;|SELECT
>> ID, NUMBER, CITY_ID, COUNTRY_ID, STATE_ID FROM zip_code WHERE (ID = ?)
>> bind => [1 parameter bound]|#]
>>
>> [#|2012-06-20T10:25:38.391-0400|FINE|oracle-glassfish3.1.2|org.eclipse.persistence.session.file:/opt/glassfish3/glassfish/domains/anon_domain_1/applications/WebPortalEAR/WebPortalEJB_jar/_anon_unit.sql|_ThreadID=25;_ThreadName=Thread-2;ClassName=null;MethodName=null;|SELECT
>> ID, NAME, COUNTRY_ID, STATE_ID FROM city WHERE (ID = ?)
>> bind => [1 parameter bound]|#]
>>
>> [#|2012-06-20T10:25:38.393-0400|FINE|oracle-glassfish3.1.2|org.eclipse.persistence.session.file:/opt/glassfish3/glassfish/domains/anon_domain_1/applications/WebPortalEAR/WebPortalEJB_jar/_anon_unit.sql|_ThreadID=25;_ThreadName=Thread-2;ClassName=null;MethodName=null;|SELECT
>> ID, NAME FROM country WHERE (ID = ?)
>> bind => [1 parameter bound]|#]
>>
>> [#|2012-06-20T10:25:38.396-0400|FINE|oracle-glassfish3.1.2|org.eclipse.persistence.session.file:/opt/glassfish3/glassfish/domains/anon_domain_1/applications/WebPortalEAR/WebPortalEJB_jar/_anon_unit.sql|_ThreadID=25;_ThreadName=Thread-2;ClassName=null;MethodName=null;|SELECT
>> ID, NAME, COUNTRY_ID FROM state WHERE (ID = ?)
>> bind => [1 parameter bound]|#]
>>
>> [#|2012-06-20T10:25:38.397-0400|FINE|oracle-glassfish3.1.2|org.eclipse.persistence.session.file:/opt/glassfish3/glassfish/domains/anon_domain_1/applications/WebPortalEAR/WebPortalEJB_jar/_anon_unit.sql|_ThreadID=25;_ThreadName=Thread-2;ClassName=null;MethodName=null;|SELECT
>> ID, NUMBER, CITY_ID, COUNTRY_ID, STATE_ID FROM zip_code WHERE (ID = ?)
>> bind => [1 parameter bound]|#]
>>
>> [#|2012-06-20T10:25:38.401-0400|FINE|oracle-glassfish3.1.2|org.eclipse.persistence.session.file:/opt/glassfish3/glassfish/domains/anon_domain_1/applications/WebPortalEAR/WebPortalEJB_jar/_anon_unit.sql|_ThreadID=25;_ThreadName=Thread-2;ClassName=null;MethodName=null;|SELECT
>> ID, NAME, COUNTRY_ID, STATE_ID FROM city WHERE (ID = ?)
>> bind => [1 parameter bound]|#]
>>
>> [#|2012-06-20T10:25:38.405-0400|FINE|oracle-glassfish3.1.2|org.eclipse.persistence.session.file:/opt/glassfish3/glassfish/domains/anon_domain_1/applications/WebPortalEAR/WebPortalEJB_jar/_anon_unit.sql|_ThreadID=25;_ThreadName=Thread-2;ClassName=null;MethodName=null;|SELECT
>> ID, NAME FROM country WHERE (ID = ?)
>> bind => [1 parameter bound]|#]
>>
>> [#|2012-06-20T10:25:38.407-0400|FINE|oracle-glassfish3.1.2|org.eclipse.persistence.session.file:/opt/glassfish3/glassfish/domains/anon_domain_1/applications/WebPortalEAR/WebPortalEJB_jar/_anon_unit.sql|_ThreadID=25;_ThreadName=Thread-2;ClassName=null;MethodName=null;|SELECT
>> ID, NAME, COUNTRY_ID FROM state WHERE (ID = ?)
>> bind => [1 parameter bound]|#]
>>
>> [#|2012-06-20T10:25:38.410-0400|FINE|oracle-glassfish3.1.2|org.eclipse.persistence.session.file:/opt/glassfish3/glassfish/domains/anon_domain_1/applications/WebPortalEAR/WebPortalEJB_jar/_anon_unit.sql|_ThreadID=25;_ThreadName=Thread-2;ClassName=null;MethodName=null;|SELECT
>> ID, NUMBER, CITY_ID, COUNTRY_ID, STATE_ID FROM zip_code WHERE (ID = ?)
>> bind => [1 parameter bound]|#]
>>
>> [#|2012-06-20T10:25:38.414-0400|FINE|oracle-glassfish3.1.2|org.eclipse.persistence.session.file:/opt/glassfish3/glassfish/domains/anon_domain_1/applications/WebPortalEAR/WebPortalEJB_jar/_anon_unit.sql|_ThreadID=25;_ThreadName=Thread-2;ClassName=null;MethodName=null;|SELECT
>> ID, NAME, COUNTRY_ID, STATE_ID FROM city WHERE (ID = ?)
>> bind => [1 parameter bound]|#]
>>
>> [#|2012-06-20T10:25:38.417-0400|FINE|oracle-glassfish3.1.2|org.eclipse.persistence.session.file:/opt/glassfish3/glassfish/domains/anon_domain_1/applications/WebPortalEAR/WebPortalEJB_jar/_anon_unit.sql|_ThreadID=25;_ThreadName=Thread-2;ClassName=null;MethodName=null;|SELECT
>> ID, NAME FROM country WHERE (ID = ?)
>> bind => [1 parameter bound]|#]
>>
>> [#|2012-06-20T10:25:38.420-0400|FINE|oracle-glassfish3.1.2|org.eclipse.persistence.session.file:/opt/glassfish3/glassfish/domains/anon_domain_1/applications/WebPortalEAR/WebPortalEJB_jar/_anon_unit.sql|_ThreadID=25;_ThreadName=Thread-2;ClassName=null;MethodName=null;|SELECT
>> ID, NAME, COUNTRY_ID FROM state WHERE (ID = ?)
>> bind => [1 parameter bound]|#]
>>
>> [#|2012-06-20T10:25:38.423-0400|FINE|oracle-glassfish3.1.2|org.eclipse.persistence.session.file:/opt/glassfish3/glassfish/domains/anon_domain_1/applications/WebPortalEAR/WebPortalEJB_jar/_anon_unit.sql|_ThreadID=25;_ThreadName=Thread-2;ClassName=null;MethodName=null;|SELECT
>> ID, NUMBER, CITY_ID, COUNTRY_ID, STATE_ID FROM zip_code WHERE (ID = ?)
>> bind => [1 parameter bound]|#]
>>
>> [#|2012-06-20T10:25:38.426-0400|FINE|oracle-glassfish3.1.2|org.eclipse.persistence.session.file:/opt/glassfish3/glassfish/domains/anon_domain_1/applications/WebPortalEAR/WebPortalEJB_jar/_anon_unit.sql|_ThreadID=25;_ThreadName=Thread-2;ClassName=null;MethodName=null;|SELECT
>> ID, NAME, COUNTRY_ID, STATE_ID FROM city WHERE (ID = ?)
>> bind => [1 parameter bound]|#]
>>
>> [#|2012-06-20T10:25:38.429-0400|FINE|oracle-glassfish3.1.2|org.eclipse.persistence.session.file:/opt/glassfish3/glassfish/domains/anon_domain_1/applications/WebPortalEAR/WebPortalEJB_jar/_anon_unit.sql|_ThreadID=25;_ThreadName=Thread-2;ClassName=null;MethodName=null;|SELECT
>> ID, NAME FROM country WHERE (ID = ?)
>> bind => [1 parameter bound]|#]
>>
>> [#|2012-06-20T10:25:38.432-0400|FINE|oracle-glassfish3.1.2|org.eclipse.persistence.session.file:/opt/glassfish3/glassfish/domains/anon_domain_1/applications/WebPortalEAR/WebPortalEJB_jar/_anon_unit.sql|_ThreadID=25;_ThreadName=Thread-2;ClassName=null;MethodName=null;|SELECT
>> ID, NAME, COUNTRY_ID FROM state WHERE (ID = ?)
>> bind => [1 parameter bound]|#]
>>
>> [#|2012-06-20T10:25:38.436-0400|FINE|oracle-glassfish3.1.2|org.eclipse.persistence.session.file:/opt/glassfish3/glassfish/domains/anon_domain_1/applications/WebPortalEAR/WebPortalEJB_jar/_anon_unit.sql|_ThreadID=25;_ThreadName=Thread-2;ClassName=null;MethodName=null;|SELECT
>> ID, NUMBER, CITY_ID, COUNTRY_ID, STATE_ID FROM zip_code WHERE (ID = ?)
>> bind => [1 parameter bound]|#]
>>
>> [#|2012-06-20T10:25:38.439-0400|FINE|oracle-glassfish3.1.2|org.eclipse.persistence.session.file:/opt/glassfish3/glassfish/domains/anon_domain_1/applications/WebPortalEAR/WebPortalEJB_jar/_anon_unit.sql|_ThreadID=25;_ThreadName=Thread-2;ClassName=null;MethodName=null;|SELECT
>> ID, NAME, COUNTRY_ID, STATE_ID FROM city WHERE (ID = ?)
>> bind => [1 parameter bound]|#]
>>
>> [#|2012-06-20T10:25:38.442-0400|FINE|oracle-glassfish3.1.2|org.eclipse.persistence.session.file:/opt/glassfish3/glassfish/domains/anon_domain_1/applications/WebPortalEAR/WebPortalEJB_jar/_anon_unit.sql|_ThreadID=25;_ThreadName=Thread-2;ClassName=null;MethodName=null;|SELECT
>> ID, NAME FROM country WHERE (ID = ?)
>> bind => [1 parameter bound]|#]
>>
>> [#|2012-06-20T10:25:38.445-0400|FINE|oracle-glassfish3.1.2|org.eclipse.persistence.session.file:/opt/glassfish3/glassfish/domains/anon_domain_1/applications/WebPortalEAR/WebPortalEJB_jar/_anon_unit.sql|_ThreadID=25;_ThreadName=Thread-2;ClassName=null;MethodName=null;|SELECT
>> ID, NAME, COUNTRY_ID FROM state WHERE (ID = ?)
>> bind => [1 parameter bound]|#]
>>
>> [#|2012-06-20T10:25:38.448-0400|FINE|oracle-glassfish3.1.2|org.eclipse.persistence.session.file:/opt/glassfish3/glassfish/domains/anon_domain_1/applications/WebPortalEAR/WebPortalEJB_jar/_anon_unit.sql|_ThreadID=25;_ThreadName=Thread-2;ClassName=null;MethodName=null;|SELECT
>> ID, NUMBER, CITY_ID, COUNTRY_ID, STATE_ID FROM zip_code WHERE (ID = ?)
>> bind => [1 parameter bound]|#]
>>
>> [#|2012-06-20T10:25:38.451-0400|FINE|oracle-glassfish3.1.2|org.eclipse.persistence.session.file:/opt/glassfish3/glassfish/domains/anon_domain_1/applications/WebPortalEAR/WebPortalEJB_jar/_anon_unit.sql|_ThreadID=25;_ThreadName=Thread-2;ClassName=null;MethodName=null;|SELECT
>> ID, NAME, COUNTRY_ID, STATE_ID FROM city WHERE (ID = ?)
>> bind => [1 parameter bound]|#]
>>
>> [#|2012-06-20T10:25:38.454-0400|FINE|oracle-glassfish3.1.2|org.eclipse.persistence.session.file:/opt/glassfish3/glassfish/domains/anon_domain_1/applications/WebPortalEAR/WebPortalEJB_jar/_anon_unit.sql|_ThreadID=25;_ThreadName=Thread-2;ClassName=null;MethodName=null;|SELECT
>> ID, NAME FROM country WHERE (ID = ?)
>> bind => [1 parameter bound]|#]
>>
>> [#|2012-06-20T10:25:38.458-0400|FINE|oracle-glassfish3.1.2|org.eclipse.persistence.session.file:/opt/glassfish3/glassfish/domains/anon_domain_1/applications/WebPortalEAR/WebPortalEJB_jar/_anon_unit.sql|_ThreadID=25;_ThreadName=Thread-2;ClassName=null;MethodName=null;|SELECT
>> ID, NAME, COUNTRY_ID FROM state WHERE (ID = ?)
>> bind => [1 parameter bound]|#]
>>
>> [#|2012-06-20T10:25:38.461-0400|FINE|oracle-glassfish3.1.2|org.eclipse.persistence.session.file:/opt/glassfish3/glassfish/domains/anon_domain_1/applications/WebPortalEAR/WebPortalEJB_jar/_anon_unit.sql|_ThreadID=25;_ThreadName=Thread-2;ClassName=null;MethodName=null;|SELECT
>> ID, NUMBER, CITY_ID, COUNTRY_ID, STATE_ID FROM zip_code WHERE (ID = ?)
>> bind => [1 parameter bound]|#]
>>
>> [#|2012-06-20T10:25:38.464-0400|FINE|oracle-glassfish3.1.2|org.eclipse.persistence.session.file:/opt/glassfish3/glassfish/domains/anon_domain_1/applications/WebPortalEAR/WebPortalEJB_jar/_anon_unit.sql|_ThreadID=25;_ThreadName=Thread-2;ClassName=null;MethodName=null;|SELECT
>> ID, NAME, COUNTRY_ID, STATE_ID FROM city WHERE (ID = ?)
>> bind => [1 parameter bound]|#]
>>
>> [#|2012-06-20T10:25:38.467-0400|FINE|oracle-glassfish3.1.2|org.eclipse.persistence.session.file:/opt/glassfish3/glassfish/domains/anon_domain_1/applications/WebPortalEAR/WebPortalEJB_jar/_anon_unit.sql|_ThreadID=25;_ThreadName=Thread-2;ClassName=null;MethodName=null;|SELECT
>> ID, NAME FROM country WHERE (ID = ?)
>> bind => [1 parameter bound]|#]
>>
>> [#|2012-06-20T10:25:38.470-0400|FINE|oracle-glassfish3.1.2|org.eclipse.persistence.session.file:/opt/glassfish3/glassfish/domains/anon_domain_1/applications/WebPortalEAR/WebPortalEJB_jar/_anon_unit.sql|_ThreadID=25;_ThreadName=Thread-2;ClassName=null;MethodName=null;|SELECT
>> ID, NAME, COUNTRY_ID FROM state WHERE (ID = ?)
>> bind => [1 parameter bound]|#]
>>
>> [#|2012-06-20T10:25:38.473-0400|FINE|oracle-glassfish3.1.2|org.eclipse.persistence.session.file:/opt/glassfish3/glassfish/domains/anon_domain_1/applications/WebPortalEAR/WebPortalEJB_jar/_anon_unit.sql|_ThreadID=25;_ThreadName=Thread-2;ClassName=null;MethodName=null;|SELECT
>> ID, NUMBER, CITY_ID, COUNTRY_ID, STATE_ID FROM zip_code WHERE (ID = ?)
>> bind => [1 parameter bound]|#]
>>
>> [#|2012-06-20T10:25:38.476-0400|FINE|oracle-glassfish3.1.2|org.eclipse.persistence.session.file:/opt/glassfish3/glassfish/domains/anon_domain_1/applications/WebPortalEAR/WebPortalEJB_jar/_anon_unit.sql|_ThreadID=25;_ThreadName=Thread-2;ClassName=null;MethodName=null;|SELECT
>> ID, NAME, COUNTRY_ID, STATE_ID FROM city WHERE (ID = ?)
>> bind => [1 parameter bound]|#]
>>
>> [#|2012-06-20T10:25:38.479-0400|FINE|oracle-glassfish3.1.2|org.eclipse.persistence.session.file:/opt/glassfish3/glassfish/domains/anon_domain_1/applications/WebPortalEAR/WebPortalEJB_jar/_anon_unit.sql|_ThreadID=25;_ThreadName=Thread-2;ClassName=null;MethodName=null;|SELECT
>> ID, NAME FROM country WHERE (ID = ?)
>> bind => [1 parameter bound]|#]
>>
>> [#|2012-06-20T10:25:38.481-0400|FINE|oracle-glassfish3.1.2|org.eclipse.persistence.session.file:/opt/glassfish3/glassfish/domains/anon_domain_1/applications/WebPortalEAR/WebPortalEJB_jar/_anon_unit.sql|_ThreadID=25;_ThreadName=Thread-2;ClassName=null;MethodName=null;|SELECT
>> ID, NAME, COUNTRY_ID FROM state WHERE (ID = ?)
>> bind => [1 parameter bound]|#]
>>
>> [#|2012-06-20T10:25:38.485-0400|FINE|oracle-glassfish3.1.2|org.eclipse.persistence.session.file:/opt/glassfish3/glassfish/domains/anon_domain_1/applications/WebPortalEAR/WebPortalEJB_jar/_anon_unit.sql|_ThreadID=25;_ThreadName=Thread-2;ClassName=null;MethodName=null;|SELECT
>> ID, NUMBER, CITY_ID, COUNTRY_ID, STATE_ID FROM zip_code WHERE (ID = ?)
>> bind => [1 parameter bound]|#]
>>
>> [#|2012-06-20T10:25:38.488-0400|FINE|oracle-glassfish3.1.2|org.eclipse.persistence.session.file:/opt/glassfish3/glassfish/domains/anon_domain_1/applications/WebPortalEAR/WebPortalEJB_jar/_anon_unit.sql|_ThreadID=25;_ThreadName=Thread-2;ClassName=null;MethodName=null;|SELECT
>> ID, NAME, COUNTRY_ID, STATE_ID FROM city WHERE (ID = ?)
>> bind => [1 parameter bound]|#]
>>
>> [#|2012-06-20T10:25:38.491-0400|FINE|oracle-glassfish3.1.2|org.eclipse.persistence.session.file:/opt/glassfish3/glassfish/domains/anon_domain_1/applications/WebPortalEAR/WebPortalEJB_jar/_anon_unit.sql|_ThreadID=25;_ThreadName=Thread-2;ClassName=null;MethodName=null;|SELECT
>> ID, NAME FROM country WHERE (ID = ?)
>> bind => [1 parameter bound]|#]
>>
>> [#|2012-06-20T10:25:38.493-0400|FINE|oracle-glassfish3.1.2|org.eclipse.persistence.session.file:/opt/glassfish3/glassfish/domains/anon_domain_1/applications/WebPortalEAR/WebPortalEJB_jar/_anon_unit.sql|_ThreadID=25;_ThreadName=Thread-2;ClassName=null;MethodName=null;|SELECT
>> ID, NAME, COUNTRY_ID FROM state WHERE (ID = ?)
>> bind => [1 parameter bound]|#]
>>
>> [#|2012-06-20T10:25:38.496-0400|FINE|oracle-glassfish3.1.2|org.eclipse.persistence.session.file:/opt/glassfish3/glassfish/domains/anon_domain_1/applications/WebPortalEAR/WebPortalEJB_jar/_anon_unit.sql|_ThreadID=25;_ThreadName=Thread-2;ClassName=null;MethodName=null;|SELECT
>> ID, NUMBER, CITY_ID, COUNTRY_ID, STATE_ID FROM zip_code WHERE (ID = ?)
>> bind => [1 parameter bound]|#]
>>
>> [#|2012-06-20T10:25:38.500-0400|FINE|oracle-glassfish3.1.2|org.eclipse.persistence.session.file:/opt/glassfish3/glassfish/domains/anon_domain_1/applications/WebPortalEAR/WebPortalEJB_jar/_anon_unit.sql|_ThreadID=25;_ThreadName=Thread-2;ClassName=null;MethodName=null;|SELECT
>> ID, NAME, COUNTRY_ID, STATE_ID FROM city WHERE (ID = ?)
>> bind => [1 parameter bound]|#]
>>
>> [#|2012-06-20T10:25:38.502-0400|FINE|oracle-glassfish3.1.2|org.eclipse.persistence.session.file:/opt/glassfish3/glassfish/domains/anon_domain_1/applications/WebPortalEAR/WebPortalEJB_jar/_anon_unit.sql|_ThreadID=25;_ThreadName=Thread-2;ClassName=null;MethodName=null;|SELECT
>> ID, NAME FROM country WHERE (ID = ?)
>> bind => [1 parameter bound]|#]
>>
>> [#|2012-06-20T10:25:38.505-0400|FINE|oracle-glassfish3.1.2|org.eclipse.persistence.session.file:/opt/glassfish3/glassfish/domains/anon_domain_1/applications/WebPortalEAR/WebPortalEJB_jar/_anon_unit.sql|_ThreadID=25;_ThreadName=Thread-2;ClassName=null;MethodName=null;|SELECT
>> ID, NAME, COUNTRY_ID FROM state WHERE (ID = ?)
>> bind => [1 parameter bound]|#]
>>
>> [#|2012-06-20T10:25:38.508-0400|FINE|oracle-glassfish3.1.2|org.eclipse.persistence.session.file:/opt/glassfish3/glassfish/domains/anon_domain_1/applications/WebPortalEAR/WebPortalEJB_jar/_anon_unit.sql|_ThreadID=25;_ThreadName=Thread-2;ClassName=null;MethodName=null;|SELECT
>> ID, NUMBER, CITY_ID, COUNTRY_ID, STATE_ID FROM zip_code WHERE (ID = ?)
>> bind => [1 parameter bound]|#]
>>
>> [#|2012-06-20T10:25:38.511-0400|FINE|oracle-glassfish3.1.2|org.eclipse.persistence.session.file:/opt/glassfish3/glassfish/domains/anon_domain_1/applications/WebPortalEAR/WebPortalEJB_jar/_anon_unit.sql|_ThreadID=25;_ThreadName=Thread-2;ClassName=null;MethodName=null;|SELECT
>> ID, NAME, COUNTRY_ID, STATE_ID FROM city WHERE (ID = ?)
>> bind => [1 parameter bound]|#]
>>
>> [#|2012-06-20T10:25:38.514-0400|FINE|oracle-glassfish3.1.2|org.eclipse.persistence.session.file:/opt/glassfish3/glassfish/domains/anon_domain_1/applications/WebPortalEAR/WebPortalEJB_jar/_anon_unit.sql|_ThreadID=25;_ThreadName=Thread-2;ClassName=null;MethodName=null;|SELECT
>> ID, NAME FROM country WHERE (ID = ?)
>> bind => [1 parameter bound]|#]
>>
>> [#|2012-06-20T10:25:38.516-0400|FINE|oracle-glassfish3.1.2|org.eclipse.persistence.session.file:/opt/glassfish3/glassfish/domains/anon_domain_1/applications/WebPortalEAR/WebPortalEJB_jar/_anon_unit.sql|_ThreadID=25;_ThreadName=Thread-2;ClassName=null;MethodName=null;|SELECT
>> ID, NAME, COUNTRY_ID FROM state WHERE (ID = ?)
>> bind => [1 parameter bound]|#]
>>
>> [#|2012-06-20T10:25:38.519-0400|FINE|oracle-glassfish3.1.2|org.eclipse.persistence.session.file:/opt/glassfish3/glassfish/domains/anon_domain_1/applications/WebPortalEAR/WebPortalEJB_jar/_anon_unit.sql|_ThreadID=25;_ThreadName=Thread-2;ClassName=null;MethodName=null;|SELECT
>> ID, NUMBER, CITY_ID, COUNTRY_ID, STATE_ID FROM zip_code WHERE (ID = ?)
>> bind => [1 parameter bound]|#]
>>
>> [#|2012-06-20T10:25:38.522-0400|FINE|oracle-glassfish3.1.2|org.eclipse.persistence.session.file:/opt/glassfish3/glassfish/domains/anon_domain_1/applications/WebPortalEAR/WebPortalEJB_jar/_anon_unit.sql|_ThreadID=25;_ThreadName=Thread-2;ClassName=null;MethodName=null;|SELECT
>> ID, NAME, COUNTRY_ID, STATE_ID FROM city WHERE (ID = ?)
>> bind => [1 parameter bound]|#]
>>
>> [#|2012-06-20T10:25:38.525-0400|FINE|oracle-glassfish3.1.2|org.eclipse.persistence.session.file:/opt/glassfish3/glassfish/domains/anon_domain_1/applications/WebPortalEAR/WebPortalEJB_jar/_anon_unit.sql|_ThreadID=25;_ThreadName=Thread-2;ClassName=null;MethodName=null;|SELECT
>> ID, NAME FROM country WHERE (ID = ?)
>> bind => [1 parameter bound]|#]
>>
>> [#|2012-06-20T10:25:38.528-0400|FINE|oracle-glassfish3.1.2|org.eclipse.persistence.session.file:/opt/glassfish3/glassfish/domains/anon_domain_1/applications/WebPortalEAR/WebPortalEJB_jar/_anon_unit.sql|_ThreadID=25;_ThreadName=Thread-2;ClassName=null;MethodName=null;|SELECT
>> ID, NAME, COUNTRY_ID FROM state WHERE (ID = ?)
>> bind => [1 parameter bound]|#]
>>
>> [#|2012-06-20T10:25:38.531-0400|FINE|oracle-glassfish3.1.2|org.eclipse.persistence.session.file:/opt/glassfish3/glassfish/domains/anon_domain_1/applications/WebPortalEAR/WebPortalEJB_jar/_anon_unit.sql|_ThreadID=25;_ThreadName=Thread-2;ClassName=null;MethodName=null;|SELECT
>> ID, NUMBER, CITY_ID, COUNTRY_ID, STATE_ID FROM zip_code WHERE (ID = ?)
>> bind => [1 parameter bound]|#]
>>
>> [#|2012-06-20T10:25:38.534-0400|FINE|oracle-glassfish3.1.2|org.eclipse.persistence.session.file:/opt/glassfish3/glassfish/domains/anon_domain_1/applications/WebPortalEAR/WebPortalEJB_jar/_anon_unit.sql|_ThreadID=25;_ThreadName=Thread-2;ClassName=null;MethodName=null;|SELECT
>> ID, NAME, COUNTRY_ID, STATE_ID FROM city WHERE (ID = ?)
>> bind => [1 parameter bound]|#]
>>
>> [#|2012-06-20T10:25:38.537-0400|FINE|oracle-glassfish3.1.2|org.eclipse.persistence.session.file:/opt/glassfish3/glassfish/domains/anon_domain_1/applications/WebPortalEAR/WebPortalEJB_jar/_anon_unit.sql|_ThreadID=25;_ThreadName=Thread-2;ClassName=null;MethodName=null;|SELECT
>> ID, NAME FROM country WHERE (ID = ?)
>> bind => [1 parameter bound]|#]
>>
>> [#|2012-06-20T10:25:38.540-0400|FINE|oracle-glassfish3.1.2|org.eclipse.persistence.session.file:/opt/glassfish3/glassfish/domains/anon_domain_1/applications/WebPortalEAR/WebPortalEJB_jar/_anon_unit.sql|_ThreadID=25;_ThreadName=Thread-2;ClassName=null;MethodName=null;|SELECT
>> ID, NAME, COUNTRY_ID FROM state WHERE (ID = ?)
>> bind => [1 parameter bound]|#]
>>
>> [#|2012-06-20T10:25:38.543-0400|FINE|oracle-glassfish3.1.2|org.eclipse.persistence.session.file:/opt/glassfish3/glassfish/domains/anon_domain_1/applications/WebPortalEAR/WebPortalEJB_jar/_anon_unit.sql|_ThreadID=25;_ThreadName=Thread-2;ClassName=null;MethodName=null;|SELECT
>> ID, NUMBER, CITY_ID, COUNTRY_ID, STATE_ID FROM zip_code WHERE (ID = ?)
>> bind => [1 parameter bound]|#]
>>
>> [#|2012-06-20T10:25:38.546-0400|FINE|oracle-glassfish3.1.2|org.eclipse.persistence.session.file:/opt/glassfish3/glassfish/domains/anon_domain_1/applications/WebPortalEAR/WebPortalEJB_jar/_anon_unit.sql|_ThreadID=25;_ThreadName=Thread-2;ClassName=null;MethodName=null;|SELECT
>> ID, NAME, COUNTRY_ID, STATE_ID FROM city WHERE (ID = ?)
>> bind => [1 parameter bound]|#]
>>
>> [#|2012-06-20T10:25:38.549-0400|FINE|oracle-glassfish3.1.2|org.eclipse.persistence.session.file:/opt/glassfish3/glassfish/domains/anon_domain_1/applications/WebPortalEAR/WebPortalEJB_jar/_anon_unit.sql|_ThreadID=25;_ThreadName=Thread-2;ClassName=null;MethodName=null;|SELECT
>> ID, NAME FROM country WHERE (ID = ?)
>> bind => [1 parameter bound]|#]
>>
>> [#|2012-06-20T10:25:38.551-0400|FINE|oracle-glassfish3.1.2|org.eclipse.persistence.session.file:/opt/glassfish3/glassfish/domains/anon_domain_1/applications/WebPortalEAR/WebPortalEJB_jar/_anon_unit.sql|_ThreadID=25;_ThreadName=Thread-2;ClassName=null;MethodName=null;|SELECT
>> ID, NAME, COUNTRY_ID FROM state WHERE (ID = ?)
>> bind => [1 parameter bound]|#]
>>
>> [#|2012-06-20T10:25:38.554-0400|FINE|oracle-glassfish3.1.2|org.eclipse.persistence.session.file:/opt/glassfish3/glassfish/domains/anon_domain_1/applications/WebPortalEAR/WebPortalEJB_jar/_anon_unit.sql|_ThreadID=25;_ThreadName=Thread-2;ClassName=null;MethodName=null;|SELECT
>> ID, NUMBER, CITY_ID, COUNTRY_ID, STATE_ID FROM zip_code WHERE (ID = ?)
>> bind => [1 parameter bound]|#]
>>
>> [#|2012-06-20T10:25:38.558-0400|FINE|oracle-glassfish3.1.2|org.eclipse.persistence.session.file:/opt/glassfish3/glassfish/domains/anon_domain_1/applications/WebPortalEAR/WebPortalEJB_jar/_anon_unit.sql|_ThreadID=25;_ThreadName=Thread-2;ClassName=null;MethodName=null;|SELECT
>> ID, NAME, COUNTRY_ID, STATE_ID FROM city WHERE (ID = ?)
>> bind => [1 parameter bound]|#]
>>
>> [#|2012-06-20T10:25:38.560-0400|FINE|oracle-glassfish3.1.2|org.eclipse.persistence.session.file:/opt/glassfish3/glassfish/domains/anon_domain_1/applications/WebPortalEAR/WebPortalEJB_jar/_anon_unit.sql|_ThreadID=25;_ThreadName=Thread-2;ClassName=null;MethodName=null;|SELECT
>> ID, NAME FROM country WHERE (ID = ?)
>> bind => [1 parameter bound]|#]
>>
>> [#|2012-06-20T10:25:38.563-0400|FINE|oracle-glassfish3.1.2|org.eclipse.persistence.session.file:/opt/glassfish3/glassfish/domains/anon_domain_1/applications/WebPortalEAR/WebPortalEJB_jar/_anon_unit.sql|_ThreadID=25;_ThreadName=Thread-2;ClassName=null;MethodName=null;|SELECT
>> ID, NAME, COUNTRY_ID FROM state WHERE (ID = ?)
>> bind => [1 parameter bound]|#]
>>
>> [#|2012-06-20T10:25:38.566-0400|FINE|oracle-glassfish3.1.2|org.eclipse.persistence.session.file:/opt/glassfish3/glassfish/domains/anon_domain_1/applications/WebPortalEAR/WebPortalEJB_jar/_anon_unit.sql|_ThreadID=25;_ThreadName=Thread-2;ClassName=null;MethodName=null;|SELECT
>> ID, NUMBER, CITY_ID, COUNTRY_ID, STATE_ID FROM zip_code WHERE (ID = ?)
>> bind => [1 parameter bound]|#]
>>
>> [#|2012-06-20T10:25:38.569-0400|FINE|oracle-glassfish3.1.2|org.eclipse.persistence.session.file:/opt/glassfish3/glassfish/domains/anon_domain_1/applications/WebPortalEAR/WebPortalEJB_jar/_anon_unit.sql|_ThreadID=25;_ThreadName=Thread-2;ClassName=null;MethodName=null;|SELECT
>> ID, NAME, COUNTRY_ID, STATE_ID FROM city WHERE (ID = ?)
>> bind => [1 parameter bound]|#]
>>
>> [#|2012-06-20T10:25:38.571-0400|FINE|oracle-glassfish3.1.2|org.eclipse.persistence.session.file:/opt/glassfish3/glassfish/domains/anon_domain_1/applications/WebPortalEAR/WebPortalEJB_jar/_anon_unit.sql|_ThreadID=25;_ThreadName=Thread-2;ClassName=null;MethodName=null;|SELECT
>> ID, NAME FROM country WHERE (ID = ?)
>> bind => [1 parameter bound]|#]
>>
>> [#|2012-06-20T10:25:38.574-0400|FINE|oracle-glassfish3.1.2|org.eclipse.persistence.session.file:/opt/glassfish3/glassfish/domains/anon_domain_1/applications/WebPortalEAR/WebPortalEJB_jar/_anon_unit.sql|_ThreadID=25;_ThreadName=Thread-2;ClassName=null;MethodName=null;|SELECT
>> ID, NAME, COUNTRY_ID FROM state WHERE (ID = ?)
>> bind => [1 parameter bound]|#]
>>
>> [#|2012-06-20T10:25:38.577-0400|FINE|oracle-glassfish3.1.2|org.eclipse.persistence.session.file:/opt/glassfish3/glassfish/domains/anon_domain_1/applications/WebPortalEAR/WebPortalEJB_jar/_anon_unit.sql|_ThreadID=25;_ThreadName=Thread-2;ClassName=null;MethodName=null;|SELECT
>> ID, NUMBER, CITY_ID, COUNTRY_ID, STATE_ID FROM zip_code WHERE (ID = ?)
>> bind => [1 parameter bound]|#]
>>
>> [#|2012-06-20T10:25:38.580-0400|FINE|oracle-glassfish3.1.2|org.eclipse.persistence.session.file:/opt/glassfish3/glassfish/domains/anon_domain_1/applications/WebPortalEAR/WebPortalEJB_jar/_anon_unit.sql|_ThreadID=25;_ThreadName=Thread-2;ClassName=null;MethodName=null;|SELECT
>> ID, NAME, COUNTRY_ID, STATE_ID FROM city WHERE (ID = ?)
>> bind => [1 parameter bound]|#]
>>
>> [#|2012-06-20T10:25:38.582-0400|FINE|oracle-glassfish3.1.2|org.eclipse.persistence.session.file:/opt/glassfish3/glassfish/domains/anon_domain_1/applications/WebPortalEAR/WebPortalEJB_jar/_anon_unit.sql|_ThreadID=25;_ThreadName=Thread-2;ClassName=null;MethodName=null;|SELECT
>> ID, NAME FROM country WHERE (ID = ?)
>> bind => [1 parameter bound]|#]
>>
>> [#|2012-06-20T10:25:38.585-0400|FINE|oracle-glassfish3.1.2|org.eclipse.persistence.session.file:/opt/glassfish3/glassfish/domains/anon_domain_1/applications/WebPortalEAR/WebPortalEJB_jar/_anon_unit.sql|_ThreadID=25;_ThreadName=Thread-2;ClassName=null;MethodName=null;|SELECT
>> ID, NAME, COUNTRY_ID FROM state WHERE (ID = ?)
>> bind => [1 parameter bound]|#]
>>
>> [#|2012-06-20T10:25:38.588-0400|FINE|oracle-glassfish3.1.2|org.eclipse.persistence.session.file:/opt/glassfish3/glassfish/domains/anon_domain_1/applications/WebPortalEAR/WebPortalEJB_jar/_anon_unit.sql|_ThreadID=25;_ThreadName=Thread-2;ClassName=null;MethodName=null;|SELECT
>> ID, NUMBER, CITY_ID, COUNTRY_ID, STATE_ID FROM zip_code WHERE (ID = ?)
>> bind => [1 parameter bound]|#]
>>
>> [#|2012-06-20T10:25:38.591-0400|FINE|oracle-glassfish3.1.2|org.eclipse.persistence.session.file:/opt/glassfish3/glassfish/domains/anon_domain_1/applications/WebPortalEAR/WebPortalEJB_jar/_anon_unit.sql|_ThreadID=25;_ThreadName=Thread-2;ClassName=null;MethodName=null;|SELECT
>> ID, NAME, COUNTRY_ID, STATE_ID FROM city WHERE (ID = ?)
>> bind => [1 parameter bound]|#]
>>
>> [#|2012-06-20T10:25:38.593-0400|FINE|oracle-glassfish3.1.2|org.eclipse.persistence.session.file:/opt/glassfish3/glassfish/domains/anon_domain_1/applications/WebPortalEAR/WebPortalEJB_jar/_anon_unit.sql|_ThreadID=25;_ThreadName=Thread-2;ClassName=null;MethodName=null;|SELECT
>> ID, NAME FROM country WHERE (ID = ?)
>> bind => [1 parameter bound]|#]
>>
>> [#|2012-06-20T10:25:38.596-0400|FINE|oracle-glassfish3.1.2|org.eclipse.persistence.session.file:/opt/glassfish3/glassfish/domains/anon_domain_1/applications/WebPortalEAR/WebPortalEJB_jar/_anon_unit.sql|_ThreadID=25;_ThreadName=Thread-2;ClassName=null;MethodName=null;|SELECT
>> ID, NAME, COUNTRY_ID FROM state WHERE (ID = ?)
>> bind => [1 parameter bound]|#]
>>
>> [#|2012-06-20T10:25:38.599-0400|FINE|oracle-glassfish3.1.2|org.eclipse.persistence.session.file:/opt/glassfish3/glassfish/domains/anon_domain_1/applications/WebPortalEAR/WebPortalEJB_jar/_anon_unit.sql|_ThreadID=25;_ThreadName=Thread-2;ClassName=null;MethodName=null;|SELECT
>> ID, NUMBER, CITY_ID, COUNTRY_ID, STATE_ID FROM zip_code WHERE (ID = ?)
>> bind => [1 parameter bound]|#]
>>
>> [#|2012-06-20T10:25:38.602-0400|FINE|oracle-glassfish3.1.2|org.eclipse.persistence.session.file:/opt/glassfish3/glassfish/domains/anon_domain_1/applications/WebPortalEAR/WebPortalEJB_jar/_anon_unit.sql|_ThreadID=25;_ThreadName=Thread-2;ClassName=null;MethodName=null;|SELECT
>> ID, NAME, COUNTRY_ID, STATE_ID FROM city WHERE (ID = ?)
>> bind => [1 parameter bound]|#]
>>
>> [#|2012-06-20T10:25:38.605-0400|FINE|oracle-glassfish3.1.2|org.eclipse.persistence.session.file:/opt/glassfish3/glassfish/domains/anon_domain_1/applications/WebPortalEAR/WebPortalEJB_jar/_anon_unit.sql|_ThreadID=25;_ThreadName=Thread-2;ClassName=null;MethodName=null;|SELECT
>> ID, NAME FROM country WHERE (ID = ?)
>> bind => [1 parameter bound]|#]
>>
>> [#|2012-06-20T10:25:38.608-0400|FINE|oracle-glassfish3.1.2|org.eclipse.persistence.session.file:/opt/glassfish3/glassfish/domains/anon_domain_1/applications/WebPortalEAR/WebPortalEJB_jar/_anon_unit.sql|_ThreadID=25;_ThreadName=Thread-2;ClassName=null;MethodName=null;|SELECT
>> ID, NAME, COUNTRY_ID FROM state WHERE (ID = ?)
>> bind => [1 parameter bound]|#]
>>
>> [#|2012-06-20T10:25:38.611-0400|FINE|oracle-glassfish3.1.2|org.eclipse.persistence.session.file:/opt/glassfish3/glassfish/domains/anon_domain_1/applications/WebPortalEAR/WebPortalEJB_jar/_anon_unit.sql|_ThreadID=25;_ThreadName=Thread-2;ClassName=null;MethodName=null;|SELECT
>> ID, NUMBER, CITY_ID, COUNTRY_ID, STATE_ID FROM zip_code WHERE (ID = ?)
>> bind => [1 parameter bound]|#]
>>
>> [#|2012-06-20T10:25:38.614-0400|FINE|oracle-glassfish3.1.2|org.eclipse.persistence.session.file:/opt/glassfish3/glassfish/domains/anon_domain_1/applications/WebPortalEAR/WebPortalEJB_jar/_anon_unit.sql|_ThreadID=25;_ThreadName=Thread-2;ClassName=null;MethodName=null;|SELECT
>> ID, NAME, COUNTRY_ID, STATE_ID FROM city WHERE (ID = ?)
>> bind => [1 parameter bound]|#]
>>
>> [#|2012-06-20T10:25:38.617-0400|FINE|oracle-glassfish3.1.2|org.eclipse.persistence.session.file:/opt/glassfish3/glassfish/domains/anon_domain_1/applications/WebPortalEAR/WebPortalEJB_jar/_anon_unit.sql|_ThreadID=25;_ThreadName=Thread-2;ClassName=null;MethodName=null;|SELECT
>> ID, NAME FROM country WHERE (ID = ?)
>> bind => [1 parameter bound]|#]
>>
>> [#|2012-06-20T10:25:38.620-0400|FINE|oracle-glassfish3.1.2|org.eclipse.persistence.session.file:/opt/glassfish3/glassfish/domains/anon_domain_1/applications/WebPortalEAR/WebPortalEJB_jar/_anon_unit.sql|_ThreadID=25;_ThreadName=Thread-2;ClassName=null;MethodName=null;|SELECT
>> ID, NAME, COUNTRY_ID FROM state WHERE (ID = ?)
>> bind => [1 parameter bound]|#]
>>
>> [#|2012-06-20T10:25:38.623-0400|FINE|oracle-glassfish3.1.2|org.eclipse.persistence.session.file:/opt/glassfish3/glassfish/domains/anon_domain_1/applications/WebPortalEAR/WebPortalEJB_jar/_anon_unit.sql|_ThreadID=25;_ThreadName=Thread-2;ClassName=null;MethodName=null;|SELECT
>> ID, NUMBER, CITY_ID, COUNTRY_ID, STATE_ID FROM zip_code WHERE (ID = ?)
>> bind => [1 parameter bound]|#]
>>
>> [#|2012-06-20T10:25:38.626-0400|FINE|oracle-glassfish3.1.2|org.eclipse.persistence.session.file:/opt/glassfish3/glassfish/domains/anon_domain_1/applications/WebPortalEAR/WebPortalEJB_jar/_anon_unit.sql|_ThreadID=25;_ThreadName=Thread-2;ClassName=null;MethodName=null;|SELECT
>> ID, NAME, COUNTRY_ID, STATE_ID FROM city WHERE (ID = ?)
>> bind => [1 parameter bound]|#]
>>
>> [#|2012-06-20T10:25:38.628-0400|FINE|oracle-glassfish3.1.2|org.eclipse.persistence.session.file:/opt/glassfish3/glassfish/domains/anon_domain_1/applications/WebPortalEAR/WebPortalEJB_jar/_anon_unit.sql|_ThreadID=25;_ThreadName=Thread-2;ClassName=null;MethodName=null;|SELECT
>> ID, NAME FROM country WHERE (ID = ?)
>> bind => [1 parameter bound]|#]
>>
>> [#|2012-06-20T10:25:38.631-0400|FINE|oracle-glassfish3.1.2|org.eclipse.persistence.session.file:/opt/glassfish3/glassfish/domains/anon_domain_1/applications/WebPortalEAR/WebPortalEJB_jar/_anon_unit.sql|_ThreadID=25;_ThreadName=Thread-2;ClassName=null;MethodName=null;|SELECT
>> ID, NAME, COUNTRY_ID FROM state WHERE (ID = ?)
>> bind => [1 parameter bound]|#]
>>
>> [#|2012-06-20T10:25:38.634-0400|FINE|oracle-glassfish3.1.2|org.eclipse.persistence.session.file:/opt/glassfish3/glassfish/domains/anon_domain_1/applications/WebPortalEAR/WebPortalEJB_jar/_anon_unit.sql|_ThreadID=25;_ThreadName=Thread-2;ClassName=null;MethodName=null;|SELECT
>> ID, NUMBER, CITY_ID, COUNTRY_ID, STATE_ID FROM zip_code WHERE (ID = ?)
>> bind => [1 parameter bound]|#]
>>
>> [#|2012-06-20T10:25:38.661-0400|INFO|oracle-glassfish3.1.2|javax.enterprise.system.std.com.sun.enterprise.server.logging|_ThreadID=25;_ThreadName=Thread-2;|CompanyLocationsService
>> sent a response.|#]
>>
>> [#|2012-06-20T10:25:39.379-0400|INFO|oracle-glassfish3.1.2|javax.enterprise.system.std.com.sun.enterprise.server.logging|_ThreadID=26;_ThreadName=Thread-2;|CompanyLocationsService
>> received a request of type LONG_POLLING_REQUEST.|#]
>>
>> [#|2012-06-20T10:26:21.983-0400|FINE|oracle-glassfish3.1.2|org.eclipse.persistence.session.file:/opt/glassfish3/glassfish/domains/anon_domain_1/applications/WebPortalEAR/WebPortalEJB_jar/_anon_unit.sql|_ThreadID=27;_ThreadName=Thread-2;ClassName=null;MethodName=null;|SELECT
>> ID, NAME FROM company WHERE (NAME = ?)
>> bind => [1 parameter bound]|#]
>>
>> [#|2012-06-20T10:26:21.987-0400|FINE|oracle-glassfish3.1.2|org.eclipse.persistence.session.file:/opt/glassfish3/glassfish/domains/anon_domain_1/applications/WebPortalEAR/WebPortalEJB_jar/_anon_unit.sql|_ThreadID=27;_ThreadName=Thread-2;ClassName=null;MethodName=null;|SELECT
>> ID, NAME FROM country WHERE (NAME = ?)
>> bind => [1 parameter bound]|#]
>>
>> [#|2012-06-20T10:26:22.092-0400|INFO|oracle-glassfish3.1.2|javax.enterprise.system.core.transaction.com.sun.jts.CosTransactions|_ThreadID=27;_ThreadName=Thread-2;|JTS5014:
>> Recoverable JTS instance, serverId = [100]|#]
>>
>> [#|2012-06-20T10:26:34.255-0400|FINE|oracle-glassfish3.1.2|org.eclipse.persistence.session.file:/opt/glassfish3/glassfish/domains/anon_domain_1/applications/WebPortalEAR/WebPortalEJB_jar/_anon_unit.sql|_ThreadID=27;_ThreadName=Thread-2;ClassName=null;MethodName=null;|INSERT
>> INTO country (NAME) VALUES (?)
>> bind => [1 parameter bound]|#]
>>
>> [#|2012-06-20T10:26:34.257-0400|FINE|oracle-glassfish3.1.2|org.eclipse.persistence.session.file:/opt/glassfish3/glassfish/domains/anon_domain_1/applications/WebPortalEAR/WebPortalEJB_jar/_anon_unit.sql|_ThreadID=27;_ThreadName=Thread-2;ClassName=null;MethodName=null;|SELECT
>> LAST_INSERT_ID()|#]
>>
>> [#|2012-06-20T10:26:34.261-0400|FINE|oracle-glassfish3.1.2|org.eclipse.persistence.session.file:/opt/glassfish3/glassfish/domains/anon_domain_1/applications/WebPortalEAR/WebPortalEJB_jar/_anon_unit.sql|_ThreadID=27;_ThreadName=Thread-2;ClassName=null;MethodName=null;|SELECT
>> ID, NAME, COUNTRY_ID FROM state WHERE ((COUNTRY_ID = ?) AND (NAME = ?))
>> bind => [2 parameters bound]|#]
>>
>> [#|2012-06-20T10:26:34.264-0400|FINE|oracle-glassfish3.1.2|org.eclipse.persistence.session.file:/opt/glassfish3/glassfish/domains/anon_domain_1/applications/WebPortalEAR/WebPortalEJB_jar/_anon_unit.sql|_ThreadID=27;_ThreadName=Thread-2;ClassName=null;MethodName=null;|INSERT
>> INTO state (NAME, COUNTRY_ID) VALUES (?, ?)
>> bind => [2 parameters bound]|#]
>>
>> [#|2012-06-20T10:26:34.264-0400|FINE|oracle-glassfish3.1.2|org.eclipse.persistence.session.file:/opt/glassfish3/glassfish/domains/anon_domain_1/applications/WebPortalEAR/WebPortalEJB_jar/_anon_unit.sql|_ThreadID=27;_ThreadName=Thread-2;ClassName=null;MethodName=null;|SELECT
>> LAST_INSERT_ID()|#]
>>
>> [#|2012-06-20T10:26:34.266-0400|FINE|oracle-glassfish3.1.2|org.eclipse.persistence.session.file:/opt/glassfish3/glassfish/domains/anon_domain_1/applications/WebPortalEAR/WebPortalEJB_jar/_anon_unit.sql|_ThreadID=27;_ThreadName=Thread-2;ClassName=null;MethodName=null;|SELECT
>> ID, NAME, COUNTRY_ID, STATE_ID FROM city WHERE (((COUNTRY_ID = ?) AND
>> (STATE_ID = ?)) AND (NAME = ?))
>> bind => [3 parameters bound]|#]
>>
>> [#|2012-06-20T10:26:34.274-0400|FINE|oracle-glassfish3.1.2|org.eclipse.persistence.session.file:/opt/glassfish3/glassfish/domains/anon_domain_1/applications/WebPortalEAR/WebPortalEJB_jar/_anon_unit.sql|_ThreadID=27;_ThreadName=Thread-2;ClassName=null;MethodName=null;|INSERT
>> INTO city (NAME, COUNTRY_ID, STATE_ID) VALUES (?, ?, ?)
>> bind => [3 parameters bound]|#]
>>
>> [#|2012-06-20T10:26:34.276-0400|FINE|oracle-glassfish3.1.2|org.eclipse.persistence.session.file:/opt/glassfish3/glassfish/domains/anon_domain_1/applications/WebPortalEAR/WebPortalEJB_jar/_anon_unit.sql|_ThreadID=27;_ThreadName=Thread-2;ClassName=null;MethodName=null;|SELECT
>> LAST_INSERT_ID()|#]
>>
>> [#|2012-06-20T10:26:34.279-0400|FINE|oracle-glassfish3.1.2|org.eclipse.persistence.session.file:/opt/glassfish3/glassfish/domains/anon_domain_1/applications/WebPortalEAR/WebPortalEJB_jar/_anon_unit.sql|_ThreadID=27;_ThreadName=Thread-2;ClassName=null;MethodName=null;|SELECT
>> ID, NUMBER, CITY_ID, COUNTRY_ID, STATE_ID FROM zip_code WHERE (((COUNTRY_ID
>> = ?) AND (STATE_ID = ?)) AND ((CITY_ID = ?) AND (NUMBER = ?)))
>> bind => [4 parameters bound]|#]
>>
>> [#|2012-06-20T10:26:34.285-0400|FINE|oracle-glassfish3.1.2|org.eclipse.persistence.session.file:/opt/glassfish3/glassfish/domains/anon_domain_1/applications/WebPortalEAR/WebPortalEJB_jar/_anon_unit.sql|_ThreadID=27;_ThreadName=Thread-2;ClassName=null;MethodName=null;|INSERT
>> INTO zip_code (NUMBER, CITY_ID, COUNTRY_ID, STATE_ID) VALUES (?, ?, ?, ?)
>> bind => [4 parameters bound]|#]
>>
>> [#|2012-06-20T10:26:34.287-0400|FINE|oracle-glassfish3.1.2|org.eclipse.persistence.session.file:/opt/glassfish3/glassfish/domains/anon_domain_1/applications/WebPortalEAR/WebPortalEJB_jar/_anon_unit.sql|_ThreadID=27;_ThreadName=Thread-2;ClassName=null;MethodName=null;|SELECT
>> LAST_INSERT_ID()|#]
>>
>> [#|2012-06-20T10:26:34.292-0400|FINE|oracle-glassfish3.1.2|org.eclipse.persistence.session.file:/opt/glassfish3/glassfish/domains/anon_domain_1/applications/WebPortalEAR/WebPortalEJB_jar/_anon_unit.sql|_ThreadID=27;_ThreadName=Thread-2;ClassName=null;MethodName=null;|SELECT
>> ID, LINE, CITY_ID, COUNTRY_ID, STATE_ID, zip_code_id FROM address WHERE
>> ((((COUNTRY_ID = ?) AND (STATE_ID = ?)) AND ((CITY_ID = ?) AND (zip_code_id
>> = ?))) AND (LINE = ?))
>> bind => [5 parameters bound]|#]
>>
>> [#|2012-06-20T10:26:34.301-0400|FINE|oracle-glassfish3.1.2|org.eclipse.persistence.session.file:/opt/glassfish3/glassfish/domains/anon_domain_1/applications/WebPortalEAR/WebPortalEJB_jar/_anon_unit.sql|_ThreadID=27;_ThreadName=Thread-2;ClassName=null;MethodName=null;|INSERT
>> INTO address (LINE, CITY_ID, COUNTRY_ID, STATE_ID, zip_code_id) VALUES (?,
>> ?, ?, ?, ?)
>> bind => [5 parameters bound]|#]
>>
>> [#|2012-06-20T10:26:34.303-0400|FINE|oracle-glassfish3.1.2|org.eclipse.persistence.session.file:/opt/glassfish3/glassfish/domains/anon_domain_1/applications/WebPortalEAR/WebPortalEJB_jar/_anon_unit.sql|_ThreadID=27;_ThreadName=Thread-2;ClassName=null;MethodName=null;|SELECT
>> LAST_INSERT_ID()|#]
>>
>> [#|2012-06-20T10:26:34.307-0400|FINE|oracle-glassfish3.1.2|org.eclipse.persistence.session.file:/opt/glassfish3/glassfish/domains/anon_domain_1/applications/WebPortalEAR/WebPortalEJB_jar/_anon_unit.sql|_ThreadID=27;_ThreadName=Thread-2;ClassName=null;MethodName=null;|SELECT
>> t1.ID, t1.NAME FROM company_country t0, country t1 WHERE ((t0.company_id =
>> ?) AND (t1.ID = t0.country_id))
>> bind => [1 parameter bound]|#]
>>
>> [#|2012-06-20T10:26:34.317-0400|FINE|oracle-glassfish3.1.2|org.eclipse.persistence.session.file:/opt/glassfish3/glassfish/domains/anon_domain_1/applications/WebPortalEAR/WebPortalEJB_jar/_anon_unit.sql|_ThreadID=27;_ThreadName=Thread-2;ClassName=null;MethodName=null;|SELECT
>> t1.ID, t1.NAME, t1.COUNTRY_ID FROM company_state t0, state t1 WHERE
>> ((t0.company_id = ?) AND (t1.ID = t0.state_id))
>> bind => [1 parameter bound]|#]
>>
>> [#|2012-06-20T10:26:34.326-0400|FINE|oracle-glassfish3.1.2|org.eclipse.persistence.session.file:/opt/glassfish3/glassfish/domains/anon_domain_1/applications/WebPortalEAR/WebPortalEJB_jar/_anon_unit.sql|_ThreadID=27;_ThreadName=Thread-2;ClassName=null;MethodName=null;|SELECT
>> t1.ID, t1.NAME, t1.COUNTRY_ID, t1.STATE_ID FROM company_city t0, city t1
>> WHERE ((t0.company_id = ?) AND (t1.ID = t0.city_id))
>> bind => [1 parameter bound]|#]
>>
>> [#|2012-06-20T10:26:34.334-0400|FINE|oracle-glassfish3.1.2|org.eclipse.persistence.session.file:/opt/glassfish3/glassfish/domains/anon_domain_1/applications/WebPortalEAR/WebPortalEJB_jar/_anon_unit.sql|_ThreadID=27;_ThreadName=Thread-2;ClassName=null;MethodName=null;|SELECT
>> t1.ID, t1.NUMBER, t1.CITY_ID, t1.COUNTRY_ID, t1.STATE_ID FROM
>> company_zip_code t0, zip_code t1 WHERE ((t0.company_id = ?) AND (t1.ID =
>> t0.zip_code_id))
>> bind => [1 parameter bound]|#]
>>
>> [#|2012-06-20T10:26:34.357-0400|FINE|oracle-glassfish3.1.2|org.eclipse.persistence.session.file:/opt/glassfish3/glassfish/domains/anon_domain_1/applications/WebPortalEAR/WebPortalEJB_jar/_anon_unit.sql|_ThreadID=27;_ThreadName=Thread-2;ClassName=null;MethodName=null;|INSERT
>> INTO company_country (country_id, company_id) VALUES (?, ?)
>> bind => [2 parameters bound]|#]
>>
>> [#|2012-06-20T10:26:34.358-0400|FINE|oracle-glassfish3.1.2|org.eclipse.persistence.session.file:/opt/glassfish3/glassfish/domains/anon_domain_1/applications/WebPortalEAR/WebPortalEJB_jar/_anon_unit.sql|_ThreadID=27;_ThreadName=Thread-2;ClassName=null;MethodName=null;|INSERT
>> INTO company_state (state_id, company_id) VALUES (?, ?)
>> bind => [2 parameters bound]|#]
>>
>> [#|2012-06-20T10:26:34.359-0400|FINE|oracle-glassfish3.1.2|org.eclipse.persistence.session.file:/opt/glassfish3/glassfish/domains/anon_domain_1/applications/WebPortalEAR/WebPortalEJB_jar/_anon_unit.sql|_ThreadID=27;_ThreadName=Thread-2;ClassName=null;MethodName=null;|INSERT
>> INTO company_city (city_id, company_id) VALUES (?, ?)
>> bind => [2 parameters bound]|#]
>>
>> [#|2012-06-20T10:26:34.360-0400|FINE|oracle-glassfish3.1.2|org.eclipse.persistence.session.file:/opt/glassfish3/glassfish/domains/anon_domain_1/applications/WebPortalEAR/WebPortalEJB_jar/_anon_unit.sql|_ThreadID=27;_ThreadName=Thread-2;ClassName=null;MethodName=null;|INSERT
>> INTO company_zip_code (zip_code_id, company_id) VALUES (?, ?)
>> bind => [2 parameters bound]|#]
>>
>> [#|2012-06-20T10:26:34.361-0400|FINE|oracle-glassfish3.1.2|org.eclipse.persistence.session.file:/opt/glassfish3/glassfish/domains/anon_domain_1/applications/WebPortalEAR/WebPortalEJB_jar/_anon_unit.sql|_ThreadID=27;_ThreadName=Thread-2;ClassName=null;MethodName=null;|INSERT
>> INTO company_address (address_id, company_id) VALUES (?, ?)
>> bind => [2 parameters bound]|#]
>>
>> [#|2012-06-20T10:26:34.419-0400|INFO|oracle-glassfish3.1.2|javax.enterprise.system.std.com.sun.enterprise.server.logging|_ThreadID=27;_ThreadName=Thread-2;|AddCompanyLocationEvent
>> sent a NOTIFY event.|#]
>>
>>
>> Hope this helps.
>>
>>
>> On Tue, Jun 19, 2012 at 12:25 PM, Enrique Ubinas <
>> enrique.ubinas_at_gmail.com> wrote:
>>
>>> So I'm attempting to set up http long polling with Grizzly Comet on
>>> Glassfish 3.1.2. I've enabled Comet on my Glassfish server and for whatever
>>> reason its still not working. When I make a calls to
>>> cometContext.notify(obj), the CometEventHandler doesn't receive any events.
>>> On top of that, I also noticed that the addCometHandler method doesn't
>>> suspend the connection and returns immediately. Wireshark tells me that I
>>> get a response from the server with a content length of zero. Any help with
>>> this is greatly appreciated. Below is the relevant sections of my code.
>>> Thank you.
>>>
>>> This code is found in the doGet method of my HttpServlet sub class.
>>>
>>> [code]
>>> final CometContext<?> cometContext =
>>> CometEngine.getEngine().register(Constant.COMPANY_LOCATIONS_TOPIC);
>>> final CompanyLocationHandler handler = new CompanyLocationHandler();
>>>
>>> handler.attach(response);
>>> cometContext.addCometHandler(handler);
>>> [/code]
>>>
>>> This code is found in the service method of another HttpServlet sub
>>> class.
>>>
>>> [code]
>>> final CometContext<?> cometContext =
>>> CometEngine.getEngine().register(Constant.COMPANY_LOCATIONS_TOPIC);
>>> final Location companyLocation = new Location(locationId, address, city,
>>> state, zipCode, country);
>>>
>>> cometContext.notify(companyLocation);
>>> [/code]
>>>
>>> And this my implementation of the onEvent method in
>>> CompanyLocationHandler.
>>>
>>> [code]
>>> public void onEvent(final CometEvent event) throws IOException
>>> {
>>> if (event.getType() == CometEvent.NOTIFY)
>>> {
>>> final Location companyLocation = (Location)event.attachment();
>>> final PrintWriter printWriter = this.response.getWriter();
>>>
>>> try
>>> {
>>> this.response.setContentType("application/json");
>>>
>>> printWriter.write(companyLocation.toJson());
>>> printWriter.flush();
>>> }
>>> finally
>>> {
>>> printWriter.close();
>>> }
>>>
>>> event.getCometContext().resumeCometHandler(this);
>>> }
>>> }
>>> [/code]
>>>
>>>
>>>
>>
>
>