Hi Wonseok,
No, TLE code with java2db won't print SQL, but it should print some processing
messages or not, depending on the settings. And global settings should not
override the PU logging that's set only for a single category. Right?
What happens if 2 or more categories are chosen at different levels for the same PU?
thanks,
-marina
Wonseok Kim wrote:
> Hi Marina,
>
> I tried to test your suggestions against GlassFish trunk.
> I used two samples JsfJpa.war which has "toplink.logging.level.sql=FINE"
> and JsfJpa2.war which has no logging setting.
>
> 1. JsfJpa.war - Correctly SQL category logs are logged and no other logs
> below default INFO are not present.
> 2. I changed the log level by management console to FINEST and confirmed
> that all level logs appear. After that I changed the log level to INFO
> and confirmed only SQL category FINE-level logs appears.
> 4. I deployed two apps - JsfJpa.war and JsfJpa2.war. I confirmed only
> the first app logs FINE-level SQL logs.
>
> For #3 Could you tell me what you expect in more detail? I tested all
> apps with "toplink.ddl-generation=drop-and-create-tables " and deploy
> --dropandcreatetables=true command. But I don't get what behavior could
> be different with javadb on. Do you mean SQLs triggered by AS using jdbc
> files generated by TopLink should appear also? I don't think that
> toplink.logging.level.<category> should apply to AS SQL triggering code
> which use different logger like "javax.enterprise.resource.jdo.codegen.ejb".
>
> You can check above logs in the attached server log.
>
> Thanks,
> Wonseok
>
> On 6/29/07, *Marina Vatkina* <Marina.Vatkina_at_sun.com
> <mailto:Marina.Vatkina_at_sun.com>> wrote:
>
> Hi Wonseok,
>
> The changes seem ok, with the following concerns:
> 1. Please check that setting a category-specific logging level
> doesn't override
> the overall level.
> 2. You should be able to go the the GF admin screen and change
> persistence log
> level there, then press "save" and the new global TLE log level
> should apply
> without overriding the category level (try switching between FINE
> and INFO).
> 3. Check if you get expected logging at deploy with java2db on.
> 3. Please check that category-specific logging level applies only to
> a single PU
> (I used 2 small apps for that purpose).
>
> thanks,
> -marina
>
> Wonseok Kim wrote:
> > Hi Tom, Marina,
> >
> > I implemented category-specific logging level property described in
> > issue 1338
> > https://glassfish.dev.java.net/issues/show_bug.cgi?id=1338
> > < https://glassfish.dev.java.net/issues/show_bug.cgi?id=1338>
> >
> > I introduced "toplink.logging.level.<category>" property in which
> > <category> is the string defined in SessionLog like below.
> >
> > public static final String SQL = "sql";
> > public static final String TRANSACTION = "transaction";
> > public static final String EVENT = "event";
> > public static final String CONNECTION = "connection";
> > public static final String QUERY = "query";
> > public static final String CACHE = "cache";
> > public static final String PROPAGATION = "propagation";
> > public static final String SEQUENCING = "sequencing";
> > public static final String EJB = "ejb";
> > public static final String DMS = "dms";
> > public static final String EJB_OR_METADATA = "ejb_or_metadata";
> > public static final String WEAVER = "weaver";
> > public static final String PROPERTIES = "properties";
> >
> > If a user put a property like "toplink.logging.level.sql" with valid
> > level value, this is set to SessionLog with setLevel(int level,
> String
> > category) method.
> > Most expected usecase of this property is that users want to see only
> > SQL logs without other verbose log. this is now possible with
> > toplink.logging.level.sql=FINE
> >
> > I also added category-specific log level facility to
> DefaultSessionLog
> > class like JavaLog because DefaultSessionLog is the mostly used
> one in
> > Java SE environment.
> >
> > Please review this and let me know if I missed something.
> > I confirmed that this new property works as expected both with
> JavaLog
> > and DefaultSessionLog.
> >
> > Thanks,
> > Wonseok
> >
> >
> >
> ------------------------------------------------------------------------
>
> >
> > Index:
> entity-persistence/src/java/oracle/toplink/essentials/config/TopLinkProperties.java
> > ===================================================================
> > RCS file:
> /cvs/glassfish/entity-persistence/src/java/oracle/toplink/essentials/config/TopLinkProperties.java,v
>
> > retrieving revision 1.7
> > diff -c -w -r1.7 TopLinkProperties.java
> > ***
> entity-persistence/src/java/oracle/toplink/essentials/config/TopLinkProperties.java
> 29 May 2007 14:57:43 -0000 1.7
> > ---
> entity-persistence/src/java/oracle/toplink/essentials/config/TopLinkProperties.java
> 28 Jun 2007 16:56:45 -0000
> > ***************
> > *** 113,118 ****
> > --- 113,125 ----
> > // Valid values are names of levels defined in
> java.util.logging.Level,
> > // default value is java.util.logging.Level.CONFIG.getName()
> > public static final String LOGGING_LEVEL =
> "toplink.logging.level";
> > +
> > + // Category-specific logging level prefix
> > + // Property names formed out of this prefix by appending a
> category name
> > + // e.g.) toplink.logging.level.sql
> > + // Valid categories are defined in SessionLog
> > + public static final String CATEGORY_LOGGING_LEVEL_ = "
> toplink.logging.level.";
> > +
> > // By default ("true") the date is always logged.
> > // This can be turned off ("false").
> > public static final String LOGGING_TIMESTAMP = "
> toplink.logging.timestamp";
> > Index:
> entity-persistence/src/java/oracle/toplink/essentials/internal/ejb/cmp3/EntityManagerSetupImpl.java
> > ===================================================================
> > RCS file:
> /cvs/glassfish/entity-persistence/src/java/oracle/toplink/essentials/internal/ejb/cmp3/EntityManagerSetupImpl.java,v
> > retrieving revision 1.55
> > diff -c -w -r1.55 EntityManagerSetupImpl.java
> > ***
> entity-persistence/src/java/oracle/toplink/essentials/internal/ejb/cmp3/EntityManagerSetupImpl.java
> 30 May 2007 21:16:17 -0000 1.55
> > ---
> entity-persistence/src/java/oracle/toplink/essentials/internal/ejb/cmp3/EntityManagerSetupImpl.java
> 28 Jun 2007 16:56:45 -0000
> > ***************
> > *** 998,1003 ****
> > --- 998,1015 ----
> > if(logLevelString != null) {
> >
> log.setLevel(AbstractSessionLog.translateStringToLoggingLevel(logLevelString));
>
> > }
> > + // category-specific logging level
> > + Map categoryLogLevelMap =
> PropertiesHandler.getPrefixValuesLogDebug(TopLinkProperties.CATEGORY_LOGGING_LEVEL_,
> m, session);
> > + if(!categoryLogLevelMap.isEmpty()) {
> > + Iterator it =
> categoryLogLevelMap.entrySet().iterator();
> > + while (it.hasNext()) {
> > + Map.Entry entry = (Map.Entry)it.next();
> > + String name = (String)entry.getKey();
> > + String value = (String)entry.getValue();
> > +
> log.setLevel(AbstractSessionLog.translateStringToLoggingLevel(value),
> name);
> > + }
> > + }
> > +
> > String tsString =
> getConfigPropertyAsStringLogDebug(TopLinkProperties.LOGGING_TIMESTAMP,
> m, session);
> > if (tsString != null) {
> > log.setShouldPrintDate(Boolean.parseBoolean
> (tsString));
> > Index:
> entity-persistence/src/java/oracle/toplink/essentials/internal/ejb/cmp3/base/PropertiesHandler.java
> > ===================================================================
> > RCS file:
> /cvs/glassfish/entity-persistence/src/java/oracle/toplink/essentials/internal/ejb/cmp3/base/PropertiesHandler.java,v
>
> > retrieving revision 1.8
> > diff -c -w -r1.8 PropertiesHandler.java
> > ***
> entity-persistence/src/java/oracle/toplink/essentials/internal/ejb/cmp3/base/PropertiesHandler.java
> 29 May 2007 14:57:44 -0000 1.8
> > ---
> entity-persistence/src/java/oracle/toplink/essentials/internal/ejb/cmp3/base/PropertiesHandler.java
> 28 Jun 2007 16:56:46 -0000
> > ***************
> > *** 160,165 ****
> > --- 160,166 ----
> > static {
> > addProp(new LoggerTypeProp());
> > addProp(new LoggingLevelProp());
> > + addProp(new CategoryLoggingLevelProp());
> > addProp(new TargetDatabaseProp());
> > addProp(new TargetServerProp());
> > addProp(new CacheSizeProp());
> > ***************
> > *** 411,416 ****
> > --- 412,435 ----
> > }
> > }
> >
> > + protected static class CategoryLoggingLevelProp extends Prop {
> > + CategoryLoggingLevelProp() {
> > + super(TopLinkProperties.CATEGORY_LOGGING_LEVEL_);
> > + valueArray = new Object[] {
> > + Level.OFF.getName(),
> > + Level.SEVERE.getName(),
> > + Level.OFF.getName(),
> > + Level.WARNING.getName(),
> > + Level.INFO.getName(),
> > + Level.CONFIG.getName(),
> > + Level.FINE.getName(),
> > + Level.FINER.getName(),
> > + Level.FINEST.getName(),
> > + Level.ALL.getName()
> > + };
> > + }
> > + }
> > +
> > protected static class TargetDatabaseProp extends Prop {
> > TargetDatabaseProp() {
> > super(TopLinkProperties.TARGET_DATABASE,
> TargetDatabase.DEFAULT);
> > Index:
> entity-persistence/src/java/oracle/toplink/essentials/logging/AbstractSessionLog.java
> > ===================================================================
> > RCS file:
> /cvs/glassfish/entity-persistence/src/java/oracle/toplink/essentials/logging/AbstractSessionLog.java,v
> > retrieving revision 1.8
> > diff -c -w -r1.8 AbstractSessionLog.java
> > ***
> entity-persistence/src/java/oracle/toplink/essentials/logging/AbstractSessionLog.java
> 22 May 2007 23:54:44 -0000 1.8
> > ---
> entity-persistence/src/java/oracle/toplink/essentials/logging/AbstractSessionLog.java
> 28 Jun 2007 16:56:46 -0000
> > ***************
> > *** 203,210 ****
> > /**
> > * PUBLIC:
> > * <p>
> > ! * Return the log level. Category is only needed in JavaLog
> > ! * to extract name space for the Logger which the log level
> belongs to.
> > * </p><p>
> > *
> > * @return the log level
> > --- 203,209 ----
> > /**
> > * PUBLIC:
> > * <p>
> > ! * Return the log level for the category name space.
> > * </p><p>
> > *
> > * @return the log level
> > ***************
> > *** 232,239 ****
> > /**
> > * PUBLIC:
> > * <p>
> > ! * Set the log level. Category is only needed in JavaLog
> > ! * to extract name space for the Logger which the log level
> belongs to.
> > * </p><p>
> > *
> > * @param level the new log level
> > --- 231,237 ----
> > /**
> > * PUBLIC:
> > * <p>
> > ! * Set the log level for the category name space.
> > * </p><p>
> > *
> > * @param level the new log level
> > ***************
> > *** 263,271 ****
> > /**
> > * PUBLIC:
> > * <p>
> > ! * Check if a message of the given level would actually be
> logged. Category
> > ! * is only needed in JavaLog to extract name space for the
> Logger which the log
> > ! * level belongs to. !isOff() is checked to screen out the
> possibility when both
> > * log level and log request level are set to OFF.
> > * </p><p>
> > *
> > --- 261,268 ----
> > /**
> > * PUBLIC:
> > * <p>
> > ! * Check if a message of the given level would actually be
> logged for the category name space.
> > ! * !isOff() is checked to screen out the possibility when both
> > * log level and log request level are set to OFF.
> > * </p><p>
> > *
> > Index:
> entity-persistence/src/java/oracle/toplink/essentials/logging/DefaultSessionLog.java
> > ===================================================================
> > RCS file:
> /cvs/glassfish/entity-persistence/src/java/oracle/toplink/essentials/logging/DefaultSessionLog.java,v
> > retrieving revision 1.5
> > diff -c -w -r1.5 DefaultSessionLog.java
> > ***
> entity-persistence/src/java/oracle/toplink/essentials/logging/DefaultSessionLog.java 22
> May 2007 23:54:44 -0000 1.5
> > ---
> entity-persistence/src/java/oracle/toplink/essentials/logging/DefaultSessionLog.java 28
> Jun 2007 16:56:46 -0000
> > ***************
> > *** 37,42 ****
> > --- 37,47 ----
> > package oracle.toplink.essentials.logging;
> >
> > import java.io.*;
> > + import java.util.HashMap;
> > + import java.util.Map ;
> > + import java.util.logging.Level;
> > + import java.util.logging.Logger;
> > +
> > import oracle.toplink.essentials.exceptions.*;
> > import oracle.toplink.essentials.internal.helper.*;
> >
> > ***************
> > *** 66,77 ****
> > --- 71,92 ----
> > protected String fileName;
> >
> > /**
> > + * Represents the Map that stores log levels per the name
> space strings.
> > + * The keys are category names. The values are log levels.
> > + */
> > + private Map<String, Integer> categoryLogLevelMap = new
> HashMap();
> > +
> > + /**
> > * PUBLIC:
> > * Create a new default session log.
> > */
> > public DefaultSessionLog() {
> > super();
> > this.level = INFO;
> > + for (int i = 0; i < loggerCategories.length ; i++) {
> > + String loggerCategory = loggerCategories[i];
> > + categoryLogLevelMap.put(loggerCategory, null);
> > + }
> > }
> >
> > /**
> > ***************
> > *** 90,95 ****
> > --- 105,148 ----
> > this.writer = writer;
> > }
> >
> > +
> > + @Override
> > + public int getLevel(String category) {
> > + if(category != null) {
> > + Integer logLevel = categoryLogLevelMap.get(category);
> > + // if category-specific log level is not set, use
> parent level.
> > + if(logLevel != null) {
> > + return logLevel.intValue();
> > + }
> > + }
> > + return level;
> > + }
> > +
> > + @Override
> > + public void setLevel(int level, String category) {
> > + if(category == null) {
> > + this.level = level;
> > + } else if(categoryLogLevelMap.containsKey(category)) {
> > + categoryLogLevelMap.put(category, level);
> > + }
> > + }
> > +
> > + /**
> > + * PUBLIC:
> > + * <p>
> > + * Check if a message of the given level would actually be
> logged by the logger
> > + * with name space built from the given session and category.
> > + * Return the shouldLog for the given category from
> > + * </p><p>
> > + * @return true if the given message level will be logged
> > + * </p>
> > + */
> > + @Override
> > + public boolean shouldLog(int level, String category) {
> > + return (getLevel(category) <= level);
> > + }
> > +
> > +
> > /**
> > * INTERNAL:
> > * Log the entry.
> > ***************
> > *** 97,103 ****
> > * This must be synchronized as it will be called by many
> threads in three-tier.
> > */
> > public synchronized void log(SessionLogEntry entry) {
> > ! if (!shouldLog(entry.getLevel())) {
> > return;
> > }
> >
> > --- 150,156 ----
> > * This must be synchronized as it will be called by many
> threads in three-tier.
> > */
> > public synchronized void log(SessionLogEntry entry) {
> > ! if (!shouldLog(entry.getLevel(), entry.getNameSpace())) {
> > return;
> > }
> >
> > Index:
> entity-persistence/src/java/oracle/toplink/essentials/logging/JavaLog.java
> > ===================================================================
> > RCS file:
> /cvs/glassfish/entity-persistence/src/java/oracle/toplink/essentials/logging/JavaLog.java,v
>
> > retrieving revision 1.9
> > diff -c -w -r1.9 JavaLog.java
> > ***
> entity-persistence/src/java/oracle/toplink/essentials/logging/JavaLog.java 22
> May 2007 23:54:44 -0000 1.9
> > ---
> entity-persistence/src/java/oracle/toplink/essentials/logging/JavaLog.java 28
> Jun 2007 16:56:46 -0000
> > ***************
> > *** 140,145 ****
> > --- 140,147 ----
> > */
> > public void setLevel(final int level, String category) {
> > final Logger logger = getLogger(category);
> > + if(logger == null) return;
> > +
> > AccessController.doPrivileged(new PrivilegedAction() {
> > public Object run() {
> > logger.setLevel(getJavaLevel(level));
>
>
>
> ------------------------------------------------------------------------
>
>
> [#|2007-07-02T22:45:18.243+0900|INFO|sun-appserver9.1|oracle.toplink.essentials.session.file:/home/wons/works/toplink-essentials/publish/glassfish/domains/domain1/applications/j2ee-modules/JsfJpa/WEB-INF/classes/-jsf-jpa-war|_ThreadID=17;_ThreadName=Thread-31;|TopLink, version: Oracle TopLink Essentials - 2.0 (Build SNAPSHOT (07/02/2007))|#]
>
> [#|2007-07-02T22:45:18.244+0900|INFO|sun-appserver9.1|oracle.toplink.essentials.session.file:/home/wons/works/toplink-essentials/publish/glassfish/domains/domain1/applications/j2ee-modules/JsfJpa/WEB-INF/classes/-jsf-jpa-war|_ThreadID=17;_ThreadName=Thread-31;|Server: unknown|#]
>
> [#|2007-07-02T22:45:19.901+0900|INFO|sun-appserver9.1|oracle.toplink.essentials.session.file:/home/wons/works/toplink-essentials/publish/glassfish/domains/domain1/applications/j2ee-modules/JsfJpa/WEB-INF/classes/-jsf-jpa-war|_ThreadID=17;_ThreadName=Thread-31;|file:/home/wons/works/toplink-essentials/publish/glassfish/domains/domain1/applications/j2ee-modules/JsfJpa/WEB-INF/classes/-jsf-jpa-war login successful|#]
>
> [#|2007-07-02T22:45:19.941+0900|INFO|sun-appserver9.1|oracle.toplink.essentials.session.file:/home/wons/works/toplink-essentials/publish/glassfish/domains/domain1/applications/j2ee-modules/JsfJpa/WEB-INF/classes/-jsf-jpa-war|_ThreadID=17;_ThreadName=Thread-31;|file:/home/wons/works/toplink-essentials/publish/glassfish/domains/domain1/applications/j2ee-modules/JsfJpa/WEB-INF/classes/-jsf-jpa-war logout successful|#]
>
> [#|2007-07-02T22:45:20.465+0900|WARNING|sun-appserver9.1|javax.enterprise.resource.jdo.codegen.ejb|_ThreadID=17;_ThreadName=Thread-31;_RequestID=dd44c2d2-94d5-439f-bab5-5cd5781c1315;|JDO76609: Got SQLException executing statement "CREATE TABLE WUSER (ID INTEGER GENERATED ALWAYS AS IDENTITY NOT NULL, LASTNAME VARCHAR(255) NOT NULL, USERNAME VARCHAR(255) NOT NULL, FIRSTNAME VARCHAR(255) NOT NULL, PASSWORD VARCHAR(255) NOT NULL, SINCE TIMESTAMP, PRIMARY KEY (ID))": java.sql.SQLException: Table/View 'WUSER' already exists in Schema 'APP'.|#]
>
> [#|2007-07-02T22:45:20.583+0900|INFO|sun-appserver9.1|javax.enterprise.system.tools.deployment|_ThreadID=17;_ThreadName=Thread-31;|deployed with moduleid = JsfJpa|#]
>
> [#|2007-07-02T22:45:20.901+0900|INFO|sun-appserver9.1|javax.enterprise.system.core.naming|_ThreadID=14;_ThreadName=httpWorkerThread-4848-0;java:comp/env/enterprise.jsf_jpa_war.UserManager/em;|naming.bind|#]
>
> [#|2007-07-02T22:45:21.195+0900|INFO|sun-appserver9.1|javax.enterprise.resource.webcontainer.jsf.config|_ThreadID=14;_ThreadName=httpWorkerThread-4848-0;/jsf-jpa-war;|Initializing Sun's JavaServer Faces implementation (1.2_04-b19-p03) for context '/jsf-jpa-war'|#]
>
> [#|2007-07-02T22:47:37.429+0900|INFO|sun-appserver9.1|oracle.toplink.essentials.session.file:/home/wons/works/toplink-essentials/publish/glassfish/domains/domain1/applications/j2ee-modules/JsfJpa/WEB-INF/classes/-jsf-jpa-war|_ThreadID=18;_ThreadName=httpSSLWorkerThread-8080-0;|TopLink, version: Oracle TopLink Essentials - 2.0 (Build SNAPSHOT (07/02/2007))|#]
>
> [#|2007-07-02T22:47:37.431+0900|INFO|sun-appserver9.1|oracle.toplink.essentials.session.file:/home/wons/works/toplink-essentials/publish/glassfish/domains/domain1/applications/j2ee-modules/JsfJpa/WEB-INF/classes/-jsf-jpa-war|_ThreadID=18;_ThreadName=httpSSLWorkerThread-8080-0;|Server: unknown|#]
>
> [#|2007-07-02T22:47:37.444+0900|INFO|sun-appserver9.1|oracle.toplink.essentials.session.file:/home/wons/works/toplink-essentials/publish/glassfish/domains/domain1/applications/j2ee-modules/JsfJpa/WEB-INF/classes/-jsf-jpa-war|_ThreadID=18;_ThreadName=httpSSLWorkerThread-8080-0;|file:/home/wons/works/toplink-essentials/publish/glassfish/domains/domain1/applications/j2ee-modules/JsfJpa/WEB-INF/classes/-jsf-jpa-war login successful|#]
>
> [#|2007-07-02T22:47:37.505+0900|FINE|sun-appserver9.1|oracle.toplink.essentials.session.file:/home/wons/works/toplink-essentials/publish/glassfish/domains/domain1/applications/j2ee-modules/JsfJpa/WEB-INF/classes/-jsf-jpa-war.sql|_ThreadID=18;_ThreadName=httpSSLWorkerThread-8080-0;ClassName=null;MethodName=null;_RequestID=3b2410ae-ceb7-432d-9bdd-4ea887104660;|SELECT ID, LASTNAME, USERNAME, FIRSTNAME, PASSWORD, SINCE FROM WUSER WHERE (USERNAME = CAST (? AS VARCHAR(32672) ))
> bind => [test1]|#]
>
> [#|2007-07-02T22:47:37.701+0900|FINE|sun-appserver9.1|oracle.toplink.essentials.session.file:/home/wons/works/toplink-essentials/publish/glassfish/domains/domain1/applications/j2ee-modules/JsfJpa/WEB-INF/classes/-jsf-jpa-war.sql|_ThreadID=18;_ThreadName=httpSSLWorkerThread-8080-0;ClassName=null;MethodName=null;_RequestID=3b2410ae-ceb7-432d-9bdd-4ea887104660;|INSERT INTO WUSER (LASTNAME, USERNAME, FIRSTNAME, PASSWORD, SINCE) VALUES (?, ?, ?, ?, ?)
> bind => [test1, test1, test1, test1, 2007-07-02 22:47:37.686]|#]
>
> [#|2007-07-02T22:47:37.805+0900|FINE|sun-appserver9.1|oracle.toplink.essentials.session.file:/home/wons/works/toplink-essentials/publish/glassfish/domains/domain1/applications/j2ee-modules/JsfJpa/WEB-INF/classes/-jsf-jpa-war.sql|_ThreadID=18;_ThreadName=httpSSLWorkerThread-8080-0;ClassName=null;MethodName=null;_RequestID=3b2410ae-ceb7-432d-9bdd-4ea887104660;|values IDENTITY_VAL_LOCAL()|#]
>
> [#|2007-07-02T22:49:34.296+0900|FINE|sun-appserver9.1|oracle.toplink.essentials.session.file:/home/wons/works/toplink-essentials/publish/glassfish/domains/domain1/applications/j2ee-modules/JsfJpa/WEB-INF/classes/-jsf-jpa-war.sql|_ThreadID=18;_ThreadName=httpSSLWorkerThread-8080-0;ClassName=null;MethodName=null;_RequestID=3b2410ae-ceb7-432d-9bdd-4ea887104660;|SELECT ID, LASTNAME, USERNAME, FIRSTNAME, PASSWORD, SINCE FROM WUSER WHERE (USERNAME = CAST (? AS VARCHAR(32672) ))
> bind => [test1]|#]
>
> [#|2007-07-02T22:50:32.454+0900|INFO|sun-appserver9.1|javax.enterprise.resource.webcontainer.jsf.config|_ThreadID=16;_ThreadName=httpWorkerThread-4848-1;;|Initializing Sun's JavaServer Faces implementation (1.2_04-b19-p03) for context ''|#]
>
> [#|2007-07-02T22:50:42.076+0900|INFO|sun-appserver9.1|com.sun.jsftemplating|_ThreadID=14;_ThreadName=httpWorkerThread-4848-0;|JSFT0006: WARNING: Failed to set property (rendered) with (null) value. This occured on the component named (alert) of type (com.sun.webui.jsf.component.Alert).|#]
>
> [#|2007-07-02T22:50:43.232+0900|INFO|sun-appserver9.1|com.sun.jbi.framework|_ThreadID=19;_ThreadName=sun-javaee-engine;|JBIFW1166: Engine sun-javaee-engine has been shut down.|#]
>
> [#|2007-07-02T22:50:43.233+0900|INFO|sun-appserver9.1|sun-http-binding.com.sun.jbi.httpsoapbc.HttpSoapBindingLifeCycle|_ThreadID=20;_ThreadName=sun-http-binding;|HTTP SOAP binding shutdown completed.|#]
>
> [#|2007-07-02T22:50:43.234+0900|INFO|sun-appserver9.1|com.sun.jbi.framework|_ThreadID=20;_ThreadName=sun-http-binding;|JBIFW1166: Binding sun-http-binding has been shut down.|#]
>
> [#|2007-07-02T22:50:43.236+0900|INFO|sun-appserver9.1|com.sun.jbi.framework|_ThreadID=16;_ThreadName=httpWorkerThread-4848-1;|JBIFW0012: JBI framework startup complete.|#]
>
> [#|2007-07-02T22:51:20.446+0900|INFO|sun-appserver9.1|javax.enterprise.system.tools.admin|_ThreadID=14;_ThreadName=httpWorkerThread-4848-0;com.sun.enterprise.admin.event.LogLevelChangeEvent -- server [1 Change(s), Id:3, ts:1183384280446];|ADM1041:Sent the event to instance:[com.sun.enterprise.admin.event.LogLevelChangeEvent -- server [1 Change(s), Id:3, ts:1183384280446]]|#]
>
> [#|2007-07-02T22:51:20.512+0900|INFO|sun-appserver9.1|javax.enterprise.system.tools.admin|_ThreadID=14;_ThreadName=httpWorkerThread-4848-0;com.sun.enterprise.admin.event.LogLevelChangeEvent -- server [1 Change(s), Id:4, ts:1183384280512];|ADM1041:Sent the event to instance:[com.sun.enterprise.admin.event.LogLevelChangeEvent -- server [1 Change(s), Id:4, ts:1183384280512]]|#]
>
> [#|2007-07-02T22:51:20.611+0900|INFO|sun-appserver9.1|javax.enterprise.system.tools.admin|_ThreadID=14;_ThreadName=httpWorkerThread-4848-0;com.sun.enterprise.admin.event.LogLevelChangeEvent -- server [1 Change(s), Id:5, ts:1183384280611];|ADM1041:Sent the event to instance:[com.sun.enterprise.admin.event.LogLevelChangeEvent -- server [1 Change(s), Id:5, ts:1183384280611]]|#]
>
> [#|2007-07-02T22:51:20.671+0900|INFO|sun-appserver9.1|javax.enterprise.system.tools.admin|_ThreadID=14;_ThreadName=httpWorkerThread-4848-0;com.sun.enterprise.admin.event.LogLevelChangeEvent -- server [1 Change(s), Id:6, ts:1183384280670];|ADM1041:Sent the event to instance:[com.sun.enterprise.admin.event.LogLevelChangeEvent -- server [1 Change(s), Id:6, ts:1183384280670]]|#]
>
> [#|2007-07-02T22:51:20.707+0900|INFO|sun-appserver9.1|javax.enterprise.system.tools.admin|_ThreadID=14;_ThreadName=httpWorkerThread-4848-0;com.sun.enterprise.admin.event.LogLevelChangeEvent -- server [1 Change(s), Id:7, ts:1183384280707];|ADM1041:Sent the event to instance:[com.sun.enterprise.admin.event.LogLevelChangeEvent -- server [1 Change(s), Id:7, ts:1183384280707]]|#]
>
> [#|2007-07-02T22:52:21.495+0900|FINER|sun-appserver9.1|oracle.toplink.essentials.session.file:/home/wons/works/toplink-essentials/publish/glassfish/domains/domain1/applications/j2ee-modules/JsfJpa/WEB-INF/classes/-jsf-jpa-war.connection|_ThreadID=18;_ThreadName=httpSSLWorkerThread-8080-0;ClassName=null;MethodName=null;_RequestID=3b2410ae-ceb7-432d-9bdd-4ea887104660;|client acquired|#]
>
> [#|2007-07-02T22:52:21.496+0900|FINEST|sun-appserver9.1|oracle.toplink.essentials.session.file:/home/wons/works/toplink-essentials/publish/glassfish/domains/domain1/applications/j2ee-modules/JsfJpa/WEB-INF/classes/-jsf-jpa-war.query|_ThreadID=18;_ThreadName=httpSSLWorkerThread-8080-0;ClassName=null;MethodName=null;_RequestID=3b2410ae-ceb7-432d-9bdd-4ea887104660;|Execute query ReportQuery(enterprise.jsf_jpa_war.Wuser)|#]
>
> [#|2007-07-02T22:52:21.497+0900|FINEST|sun-appserver9.1|oracle.toplink.essentials.session.file:/home/wons/works/toplink-essentials/publish/glassfish/domains/domain1/applications/j2ee-modules/JsfJpa/WEB-INF/classes/-jsf-jpa-war.connection|_ThreadID=18;_ThreadName=httpSSLWorkerThread-8080-0;ClassName=null;MethodName=null;_RequestID=3b2410ae-ceb7-432d-9bdd-4ea887104660;|reconnecting to external connection pool|#]
>
> [#|2007-07-02T22:52:21.497+0900|FINE|sun-appserver9.1|oracle.toplink.essentials.session.file:/home/wons/works/toplink-essentials/publish/glassfish/domains/domain1/applications/j2ee-modules/JsfJpa/WEB-INF/classes/-jsf-jpa-war.sql|_ThreadID=18;_ThreadName=httpSSLWorkerThread-8080-0;ClassName=null;MethodName=null;_RequestID=3b2410ae-ceb7-432d-9bdd-4ea887104660;|SELECT ID, LASTNAME, USERNAME, FIRSTNAME, PASSWORD, SINCE FROM WUSER WHERE (USERNAME = CAST (? AS VARCHAR(32672) ))
> bind => [test2]|#]
>
> [#|2007-07-02T22:52:21.501+0900|FINER|sun-appserver9.1|oracle.toplink.essentials.session.file:/home/wons/works/toplink-essentials/publish/glassfish/domains/domain1/applications/j2ee-modules/JsfJpa/WEB-INF/classes/-jsf-jpa-war.connection|_ThreadID=18;_ThreadName=httpSSLWorkerThread-8080-0;ClassName=null;MethodName=null;_RequestID=3b2410ae-ceb7-432d-9bdd-4ea887104660;|client acquired|#]
>
> [#|2007-07-02T22:52:21.502+0900|FINER|sun-appserver9.1|oracle.toplink.essentials.session.file:/home/wons/works/toplink-essentials/publish/glassfish/domains/domain1/applications/j2ee-modules/JsfJpa/WEB-INF/classes/-jsf-jpa-war.transaction|_ThreadID=18;_ThreadName=httpSSLWorkerThread-8080-0;ClassName=null;MethodName=null;_RequestID=3b2410ae-ceb7-432d-9bdd-4ea887104660;|TX binding to tx mgr, status=STATUS_ACTIVE|#]
>
> [#|2007-07-02T22:52:21.502+0900|FINEST|sun-appserver9.1|oracle.toplink.essentials.session.file:/home/wons/works/toplink-essentials/publish/glassfish/domains/domain1/applications/j2ee-modules/JsfJpa/WEB-INF/classes/-jsf-jpa-war.query|_ThreadID=18;_ThreadName=httpSSLWorkerThread-8080-0;ClassName=null;MethodName=null;_RequestID=3b2410ae-ceb7-432d-9bdd-4ea887104660;|Execute query DoesExistQuery()|#]
>
> [#|2007-07-02T22:52:21.503+0900|FINEST|sun-appserver9.1|oracle.toplink.essentials.session.file:/home/wons/works/toplink-essentials/publish/glassfish/domains/domain1/applications/j2ee-modules/JsfJpa/WEB-INF/classes/-jsf-jpa-war.transaction|_ThreadID=18;_ThreadName=httpSSLWorkerThread-8080-0;ClassName=null;MethodName=null;_RequestID=3b2410ae-ceb7-432d-9bdd-4ea887104660;|PERSIST operation called on: null.|#]
>
> [#|2007-07-02T22:52:21.503+0900|FINER|sun-appserver9.1|oracle.toplink.essentials.session.file:/home/wons/works/toplink-essentials/publish/glassfish/domains/domain1/applications/j2ee-modules/JsfJpa/WEB-INF/classes/-jsf-jpa-war.transaction|_ThreadID=18;_ThreadName=httpSSLWorkerThread-8080-0;ClassName=null;MethodName=null;_RequestID=3b2410ae-ceb7-432d-9bdd-4ea887104660;|TX beforeCompletion callback, status=STATUS_ACTIVE|#]
>
> [#|2007-07-02T22:52:21.503+0900|FINER|sun-appserver9.1|oracle.toplink.essentials.session.file:/home/wons/works/toplink-essentials/publish/glassfish/domains/domain1/applications/j2ee-modules/JsfJpa/WEB-INF/classes/-jsf-jpa-war.transaction|_ThreadID=18;_ThreadName=httpSSLWorkerThread-8080-0;ClassName=null;MethodName=null;_RequestID=3b2410ae-ceb7-432d-9bdd-4ea887104660;|begin unit of work commit|#]
>
> [#|2007-07-02T22:52:21.504+0900|FINER|sun-appserver9.1|oracle.toplink.essentials.session.file:/home/wons/works/toplink-essentials/publish/glassfish/domains/domain1/applications/j2ee-modules/JsfJpa/WEB-INF/classes/-jsf-jpa-war.transaction|_ThreadID=18;_ThreadName=httpSSLWorkerThread-8080-0;ClassName=null;MethodName=null;_RequestID=3b2410ae-ceb7-432d-9bdd-4ea887104660;|TX beginTransaction, status=STATUS_ACTIVE|#]
>
> [#|2007-07-02T22:52:21.505+0900|FINEST|sun-appserver9.1|oracle.toplink.essentials.session.file:/home/wons/works/toplink-essentials/publish/glassfish/domains/domain1/applications/j2ee-modules/JsfJpa/WEB-INF/classes/-jsf-jpa-war.query|_ThreadID=18;_ThreadName=httpSSLWorkerThread-8080-0;ClassName=null;MethodName=null;_RequestID=3b2410ae-ceb7-432d-9bdd-4ea887104660;|Execute query InsertObjectQuery(null)|#]
>
> [#|2007-07-02T22:52:21.506+0900|FINEST|sun-appserver9.1|oracle.toplink.essentials.session.file:/home/wons/works/toplink-essentials/publish/glassfish/domains/domain1/applications/j2ee-modules/JsfJpa/WEB-INF/classes/-jsf-jpa-war.connection|_ThreadID=18;_ThreadName=httpSSLWorkerThread-8080-0;ClassName=null;MethodName=null;_RequestID=3b2410ae-ceb7-432d-9bdd-4ea887104660;|reconnecting to external connection pool|#]
>
> [#|2007-07-02T22:52:21.506+0900|FINE|sun-appserver9.1|oracle.toplink.essentials.session.file:/home/wons/works/toplink-essentials/publish/glassfish/domains/domain1/applications/j2ee-modules/JsfJpa/WEB-INF/classes/-jsf-jpa-war.sql|_ThreadID=18;_ThreadName=httpSSLWorkerThread-8080-0;ClassName=null;MethodName=null;_RequestID=3b2410ae-ceb7-432d-9bdd-4ea887104660;|INSERT INTO WUSER (LASTNAME, USERNAME, FIRSTNAME, PASSWORD, SINCE) VALUES (?, ?, ?, ?, ?)
> bind => [test2, test2, test2, test2, 2007-07-02 22:52:21.501]|#]
>
> [#|2007-07-02T22:52:21.510+0900|FINEST|sun-appserver9.1|oracle.toplink.essentials.session.file:/home/wons/works/toplink-essentials/publish/glassfish/domains/domain1/applications/j2ee-modules/JsfJpa/WEB-INF/classes/-jsf-jpa-war.query|_ThreadID=18;_ThreadName=httpSSLWorkerThread-8080-0;ClassName=null;MethodName=null;_RequestID=3b2410ae-ceb7-432d-9bdd-4ea887104660;|Execute query ValueReadQuery()|#]
>
> [#|2007-07-02T22:52:21.511+0900|FINE|sun-appserver9.1|oracle.toplink.essentials.session.file:/home/wons/works/toplink-essentials/publish/glassfish/domains/domain1/applications/j2ee-modules/JsfJpa/WEB-INF/classes/-jsf-jpa-war.sql|_ThreadID=18;_ThreadName=httpSSLWorkerThread-8080-0;ClassName=null;MethodName=null;_RequestID=3b2410ae-ceb7-432d-9bdd-4ea887104660;|values IDENTITY_VAL_LOCAL()|#]
>
> [#|2007-07-02T22:52:21.513+0900|FINEST|sun-appserver9.1|oracle.toplink.essentials.session.file:/home/wons/works/toplink-essentials/publish/glassfish/domains/domain1/applications/j2ee-modules/JsfJpa/WEB-INF/classes/-jsf-jpa-war.sequencing|_ThreadID=18;_ThreadName=httpSSLWorkerThread-8080-0;ClassName=null;MethodName=null;_RequestID=3b2410ae-ceb7-432d-9bdd-4ea887104660;|assign sequence to the object (2 -> null)|#]
>
> [#|2007-07-02T22:52:21.515+0900|FINER|sun-appserver9.1|oracle.toplink.essentials.session.file:/home/wons/works/toplink-essentials/publish/glassfish/domains/domain1/applications/j2ee-modules/JsfJpa/WEB-INF/classes/-jsf-jpa-war.transaction|_ThreadID=18;_ThreadName=httpSSLWorkerThread-8080-0;ClassName=null;MethodName=null;_RequestID=3b2410ae-ceb7-432d-9bdd-4ea887104660;|TX afterCompletion callback, status=COMMITTED|#]
>
> [#|2007-07-02T22:52:21.515+0900|FINER|sun-appserver9.1|oracle.toplink.essentials.session.file:/home/wons/works/toplink-essentials/publish/glassfish/domains/domain1/applications/j2ee-modules/JsfJpa/WEB-INF/classes/-jsf-jpa-war.transaction|_ThreadID=18;_ThreadName=httpSSLWorkerThread-8080-0;ClassName=null;MethodName=null;_RequestID=3b2410ae-ceb7-432d-9bdd-4ea887104660;|end unit of work commit|#]
>
> [#|2007-07-02T22:52:49.189+0900|FINER|sun-appserver9.1|oracle.toplink.essentials.session.file:/home/wons/works/toplink-essentials/publish/glassfish/domains/domain1/applications/j2ee-modules/JsfJpa/WEB-INF/classes/-jsf-jpa-war.connection|_ThreadID=18;_ThreadName=httpSSLWorkerThread-8080-0;ClassName=null;MethodName=null;_RequestID=3b2410ae-ceb7-432d-9bdd-4ea887104660;|client acquired|#]
>
> [#|2007-07-02T22:52:49.189+0900|FINEST|sun-appserver9.1|oracle.toplink.essentials.session.file:/home/wons/works/toplink-essentials/publish/glassfish/domains/domain1/applications/j2ee-modules/JsfJpa/WEB-INF/classes/-jsf-jpa-war.query|_ThreadID=18;_ThreadName=httpSSLWorkerThread-8080-0;ClassName=null;MethodName=null;_RequestID=3b2410ae-ceb7-432d-9bdd-4ea887104660;|Execute query ReportQuery(enterprise.jsf_jpa_war.Wuser)|#]
>
> [#|2007-07-02T22:52:49.190+0900|FINEST|sun-appserver9.1|oracle.toplink.essentials.session.file:/home/wons/works/toplink-essentials/publish/glassfish/domains/domain1/applications/j2ee-modules/JsfJpa/WEB-INF/classes/-jsf-jpa-war.connection|_ThreadID=18;_ThreadName=httpSSLWorkerThread-8080-0;ClassName=null;MethodName=null;_RequestID=3b2410ae-ceb7-432d-9bdd-4ea887104660;|reconnecting to external connection pool|#]
>
> [#|2007-07-02T22:52:49.190+0900|FINE|sun-appserver9.1|oracle.toplink.essentials.session.file:/home/wons/works/toplink-essentials/publish/glassfish/domains/domain1/applications/j2ee-modules/JsfJpa/WEB-INF/classes/-jsf-jpa-war.sql|_ThreadID=18;_ThreadName=httpSSLWorkerThread-8080-0;ClassName=null;MethodName=null;_RequestID=3b2410ae-ceb7-432d-9bdd-4ea887104660;|SELECT ID, LASTNAME, USERNAME, FIRSTNAME, PASSWORD, SINCE FROM WUSER WHERE (USERNAME = CAST (? AS VARCHAR(32672) ))
> bind => [test2]|#]
>
> [#|2007-07-02T22:52:49.197+0900|FINEST|sun-appserver9.1|oracle.toplink.essentials.session.file:/home/wons/works/toplink-essentials/publish/glassfish/domains/domain1/applications/j2ee-modules/JsfJpa/WEB-INF/classes/-jsf-jpa-war.transaction|_ThreadID=18;_ThreadName=httpSSLWorkerThread-8080-0;ClassName=null;MethodName=null;_RequestID=3b2410ae-ceb7-432d-9bdd-4ea887104660;|Register the existing object 2|#]
>
> [#|2007-07-02T22:53:07.288+0900|INFO|sun-appserver9.1|javax.enterprise.system.tools.admin|_ThreadID=21;_ThreadName=httpWorkerThread-4848-2;com.sun.enterprise.admin.event.LogLevelChangeEvent -- server [1 Change(s), Id:8, ts:1183384387288];|ADM1041:Sent the event to instance:[com.sun.enterprise.admin.event.LogLevelChangeEvent -- server [1 Change(s), Id:8, ts:1183384387288]]|#]
>
> [#|2007-07-02T22:53:07.325+0900|INFO|sun-appserver9.1|javax.enterprise.system.tools.admin|_ThreadID=21;_ThreadName=httpWorkerThread-4848-2;com.sun.enterprise.admin.event.LogLevelChangeEvent -- server [1 Change(s), Id:9, ts:1183384387325];|ADM1041:Sent the event to instance:[com.sun.enterprise.admin.event.LogLevelChangeEvent -- server [1 Change(s), Id:9, ts:1183384387325]]|#]
>
> [#|2007-07-02T22:53:07.364+0900|INFO|sun-appserver9.1|javax.enterprise.system.tools.admin|_ThreadID=21;_ThreadName=httpWorkerThread-4848-2;com.sun.enterprise.admin.event.LogLevelChangeEvent -- server [1 Change(s), Id:10, ts:1183384387363];|ADM1041:Sent the event to instance:[com.sun.enterprise.admin.event.LogLevelChangeEvent -- server [1 Change(s), Id:10, ts:1183384387363]]|#]
>
> [#|2007-07-02T22:53:24.462+0900|FINE|sun-appserver9.1|oracle.toplink.essentials.session.file:/home/wons/works/toplink-essentials/publish/glassfish/domains/domain1/applications/j2ee-modules/JsfJpa/WEB-INF/classes/-jsf-jpa-war.sql|_ThreadID=22;_ThreadName=httpSSLWorkerThread-8080-1;ClassName=null;MethodName=null;_RequestID=7fa06857-e7c2-440a-b65b-b05a9e2dcb02;|SELECT ID, LASTNAME, USERNAME, FIRSTNAME, PASSWORD, SINCE FROM WUSER WHERE (USERNAME = CAST (? AS VARCHAR(32672) ))
> bind => [test3]|#]
>
> [#|2007-07-02T22:53:24.467+0900|FINE|sun-appserver9.1|oracle.toplink.essentials.session.file:/home/wons/works/toplink-essentials/publish/glassfish/domains/domain1/applications/j2ee-modules/JsfJpa/WEB-INF/classes/-jsf-jpa-war.sql|_ThreadID=22;_ThreadName=httpSSLWorkerThread-8080-1;ClassName=null;MethodName=null;_RequestID=7fa06857-e7c2-440a-b65b-b05a9e2dcb02;|INSERT INTO WUSER (LASTNAME, USERNAME, FIRSTNAME, PASSWORD, SINCE) VALUES (?, ?, ?, ?, ?)
> bind => [test3, test3, test3, test3, 2007-07-02 22:53:24.466]|#]
>
> [#|2007-07-02T22:53:24.470+0900|FINE|sun-appserver9.1|oracle.toplink.essentials.session.file:/home/wons/works/toplink-essentials/publish/glassfish/domains/domain1/applications/j2ee-modules/JsfJpa/WEB-INF/classes/-jsf-jpa-war.sql|_ThreadID=22;_ThreadName=httpSSLWorkerThread-8080-1;ClassName=null;MethodName=null;_RequestID=7fa06857-e7c2-440a-b65b-b05a9e2dcb02;|values IDENTITY_VAL_LOCAL()|#]
>
> [#|2007-07-02T22:57:58.950+0900|INFO|sun-appserver9.1|oracle.toplink.essentials.session.file:/home/wons/works/toplink-essentials/publish/glassfish/domains/domain1/applications/j2ee-modules/JsfJpa/WEB-INF/classes/-jsf-jpa-war|_ThreadID=16;_ThreadName=httpWorkerThread-4848-1;|file:/home/wons/works/toplink-essentials/publish/glassfish/domains/domain1/applications/j2ee-modules/JsfJpa/WEB-INF/classes/-jsf-jpa-war logout successful|#]
>
> [#|2007-07-02T22:59:06.919+0900|INFO|sun-appserver9.1|javax.enterprise.system.tools.admin|_ThreadID=21;_ThreadName=httpWorkerThread-4848-2;/tmp/s1astempdomain1server893184260/JsfJpa2.war;|ADM1006:Uploading the file to:[/tmp/s1astempdomain1server893184260/JsfJpa2.war]|#]
>
> [#|2007-07-02T22:59:07.811+0900|INFO|sun-appserver9.1|oracle.toplink.essentials.session.file:/home/wons/works/toplink-essentials/publish/glassfish/domains/domain1/applications/j2ee-modules/JsfJpa2/WEB-INF/classes/-jsf-jpa-war2|_ThreadID=23;_ThreadName=Thread-41;|TopLink, version: Oracle TopLink Essentials - 2.0 (Build SNAPSHOT (07/02/2007))|#]
>
> [#|2007-07-02T22:59:07.812+0900|INFO|sun-appserver9.1|oracle.toplink.essentials.session.file:/home/wons/works/toplink-essentials/publish/glassfish/domains/domain1/applications/j2ee-modules/JsfJpa2/WEB-INF/classes/-jsf-jpa-war2|_ThreadID=23;_ThreadName=Thread-41;|Server: unknown|#]
>
> [#|2007-07-02T22:59:07.818+0900|INFO|sun-appserver9.1|oracle.toplink.essentials.session.file:/home/wons/works/toplink-essentials/publish/glassfish/domains/domain1/applications/j2ee-modules/JsfJpa2/WEB-INF/classes/-jsf-jpa-war2|_ThreadID=23;_ThreadName=Thread-41;|file:/home/wons/works/toplink-essentials/publish/glassfish/domains/domain1/applications/j2ee-modules/JsfJpa2/WEB-INF/classes/-jsf-jpa-war2 login successful|#]
>
> [#|2007-07-02T22:59:07.822+0900|INFO|sun-appserver9.1|oracle.toplink.essentials.session.file:/home/wons/works/toplink-essentials/publish/glassfish/domains/domain1/applications/j2ee-modules/JsfJpa2/WEB-INF/classes/-jsf-jpa-war2|_ThreadID=23;_ThreadName=Thread-41;|file:/home/wons/works/toplink-essentials/publish/glassfish/domains/domain1/applications/j2ee-modules/JsfJpa2/WEB-INF/classes/-jsf-jpa-war2 logout successful|#]
>
> [#|2007-07-02T22:59:07.982+0900|INFO|sun-appserver9.1|javax.enterprise.system.tools.deployment|_ThreadID=23;_ThreadName=Thread-41;|deployed with moduleid = JsfJpa2|#]
>
> [#|2007-07-02T22:59:08.216+0900|INFO|sun-appserver9.1|javax.enterprise.system.core.naming|_ThreadID=16;_ThreadName=httpWorkerThread-4848-1;java:comp/env/enterprise.jsf_jpa_war.UserManager/em;|naming.bind|#]
>
> [#|2007-07-02T22:59:08.299+0900|INFO|sun-appserver9.1|javax.enterprise.resource.webcontainer.jsf.config|_ThreadID=16;_ThreadName=httpWorkerThread-4848-1;/jsf-jpa-war2;|Initializing Sun's JavaServer Faces implementation (1.2_04-b19-p03) for context '/jsf-jpa-war2'|#]
>
> [#|2007-07-02T22:59:37.253+0900|INFO|sun-appserver9.1|javax.enterprise.system.tools.admin|_ThreadID=21;_ThreadName=httpWorkerThread-4848-2;/tmp/s1astempdomain1server893184260/JsfJpa.war;|ADM1064:The upload file at [/tmp/s1astempdomain1server893184260/JsfJpa.war] exists and will be overwritten.|#]
>
> [#|2007-07-02T22:59:37.253+0900|INFO|sun-appserver9.1|javax.enterprise.system.tools.admin|_ThreadID=21;_ThreadName=httpWorkerThread-4848-2;/tmp/s1astempdomain1server893184260/JsfJpa.war;|ADM1006:Uploading the file to:[/tmp/s1astempdomain1server893184260/JsfJpa.war]|#]
>
> [#|2007-07-02T22:59:37.454+0900|INFO|sun-appserver9.1|oracle.toplink.essentials.session.file:/home/wons/works/toplink-essentials/publish/glassfish/domains/domain1/applications/j2ee-modules/JsfJpa/WEB-INF/classes/-jsf-jpa-war|_ThreadID=24;_ThreadName=Thread-42;|TopLink, version: Oracle TopLink Essentials - 2.0 (Build SNAPSHOT (07/02/2007))|#]
>
> [#|2007-07-02T22:59:37.455+0900|INFO|sun-appserver9.1|oracle.toplink.essentials.session.file:/home/wons/works/toplink-essentials/publish/glassfish/domains/domain1/applications/j2ee-modules/JsfJpa/WEB-INF/classes/-jsf-jpa-war|_ThreadID=24;_ThreadName=Thread-42;|Server: unknown|#]
>
> [#|2007-07-02T22:59:37.462+0900|INFO|sun-appserver9.1|oracle.toplink.essentials.session.file:/home/wons/works/toplink-essentials/publish/glassfish/domains/domain1/applications/j2ee-modules/JsfJpa/WEB-INF/classes/-jsf-jpa-war|_ThreadID=24;_ThreadName=Thread-42;|file:/home/wons/works/toplink-essentials/publish/glassfish/domains/domain1/applications/j2ee-modules/JsfJpa/WEB-INF/classes/-jsf-jpa-war login successful|#]
>
> [#|2007-07-02T22:59:37.463+0900|INFO|sun-appserver9.1|oracle.toplink.essentials.session.file:/home/wons/works/toplink-essentials/publish/glassfish/domains/domain1/applications/j2ee-modules/JsfJpa/WEB-INF/classes/-jsf-jpa-war|_ThreadID=24;_ThreadName=Thread-42;|file:/home/wons/works/toplink-essentials/publish/glassfish/domains/domain1/applications/j2ee-modules/JsfJpa/WEB-INF/classes/-jsf-jpa-war logout successful|#]
>
> [#|2007-07-02T22:59:37.512+0900|WARNING|sun-appserver9.1|javax.enterprise.resource.jdo.codegen.ejb|_ThreadID=24;_ThreadName=Thread-42;_RequestID=39c3cee8-2b4c-4e6f-98b9-e82beb013de0;|JDO76609: Got SQLException executing statement "CREATE TABLE WUSER (ID INTEGER GENERATED ALWAYS AS IDENTITY NOT NULL, LASTNAME VARCHAR(255) NOT NULL, USERNAME VARCHAR(255) NOT NULL, FIRSTNAME VARCHAR(255) NOT NULL, PASSWORD VARCHAR(255) NOT NULL, SINCE TIMESTAMP, PRIMARY KEY (ID))": java.sql.SQLException: Table/View 'WUSER' already exists in Schema 'APP'.|#]
>
> [#|2007-07-02T22:59:37.546+0900|INFO|sun-appserver9.1|javax.enterprise.system.tools.deployment|_ThreadID=24;_ThreadName=Thread-42;|deployed with moduleid = JsfJpa|#]
>
> [#|2007-07-02T22:59:37.707+0900|INFO|sun-appserver9.1|javax.enterprise.system.core.naming|_ThreadID=16;_ThreadName=httpWorkerThread-4848-1;java:comp/env/enterprise.jsf_jpa_war.UserManager/em;|naming.bind|#]
>
> [#|2007-07-02T22:59:37.781+0900|INFO|sun-appserver9.1|javax.enterprise.resource.webcontainer.jsf.config|_ThreadID=16;_ThreadName=httpWorkerThread-4848-1;/jsf-jpa-war;|Initializing Sun's JavaServer Faces implementation (1.2_04-b19-p03) for context '/jsf-jpa-war'|#]
>
> [#|2007-07-02T23:00:39.080+0900|INFO|sun-appserver9.1|oracle.toplink.essentials.session.file:/home/wons/works/toplink-essentials/publish/glassfish/domains/domain1/applications/j2ee-modules/JsfJpa2/WEB-INF/classes/-jsf-jpa-war2|_ThreadID=18;_ThreadName=httpSSLWorkerThread-8080-0;|TopLink, version: Oracle TopLink Essentials - 2.0 (Build SNAPSHOT (07/02/2007))|#]
>
> [#|2007-07-02T23:00:39.081+0900|INFO|sun-appserver9.1|oracle.toplink.essentials.session.file:/home/wons/works/toplink-essentials/publish/glassfish/domains/domain1/applications/j2ee-modules/JsfJpa2/WEB-INF/classes/-jsf-jpa-war2|_ThreadID=18;_ThreadName=httpSSLWorkerThread-8080-0;|Server: unknown|#]
>
> [#|2007-07-02T23:00:39.091+0900|INFO|sun-appserver9.1|oracle.toplink.essentials.session.file:/home/wons/works/toplink-essentials/publish/glassfish/domains/domain1/applications/j2ee-modules/JsfJpa2/WEB-INF/classes/-jsf-jpa-war2|_ThreadID=18;_ThreadName=httpSSLWorkerThread-8080-0;|file:/home/wons/works/toplink-essentials/publish/glassfish/domains/domain1/applications/j2ee-modules/JsfJpa2/WEB-INF/classes/-jsf-jpa-war2 login successful|#]
>
> [#|2007-07-02T23:01:17.025+0900|INFO|sun-appserver9.1|oracle.toplink.essentials.session.file:/home/wons/works/toplink-essentials/publish/glassfish/domains/domain1/applications/j2ee-modules/JsfJpa/WEB-INF/classes/-jsf-jpa-war|_ThreadID=22;_ThreadName=httpSSLWorkerThread-8080-1;|TopLink, version: Oracle TopLink Essentials - 2.0 (Build SNAPSHOT (07/02/2007))|#]
>
> [#|2007-07-02T23:01:17.026+0900|INFO|sun-appserver9.1|oracle.toplink.essentials.session.file:/home/wons/works/toplink-essentials/publish/glassfish/domains/domain1/applications/j2ee-modules/JsfJpa/WEB-INF/classes/-jsf-jpa-war|_ThreadID=22;_ThreadName=httpSSLWorkerThread-8080-1;|Server: unknown|#]
>
> [#|2007-07-02T23:01:17.039+0900|INFO|sun-appserver9.1|oracle.toplink.essentials.session.file:/home/wons/works/toplink-essentials/publish/glassfish/domains/domain1/applications/j2ee-modules/JsfJpa/WEB-INF/classes/-jsf-jpa-war|_ThreadID=22;_ThreadName=httpSSLWorkerThread-8080-1;|file:/home/wons/works/toplink-essentials/publish/glassfish/domains/domain1/applications/j2ee-modules/JsfJpa/WEB-INF/classes/-jsf-jpa-war login successful|#]
>
> [#|2007-07-02T23:01:17.041+0900|FINE|sun-appserver9.1|oracle.toplink.essentials.session.file:/home/wons/works/toplink-essentials/publish/glassfish/domains/domain1/applications/j2ee-modules/JsfJpa/WEB-INF/classes/-jsf-jpa-war.sql|_ThreadID=22;_ThreadName=httpSSLWorkerThread-8080-1;ClassName=null;MethodName=null;_RequestID=7fa06857-e7c2-440a-b65b-b05a9e2dcb02;|SELECT ID, LASTNAME, USERNAME, FIRSTNAME, PASSWORD, SINCE FROM WUSER WHERE (USERNAME = CAST (? AS VARCHAR(32672) ))
> bind => [test2]|#]
>
> [#|2007-07-02T23:01:17.050+0900|FINE|sun-appserver9.1|oracle.toplink.essentials.session.file:/home/wons/works/toplink-essentials/publish/glassfish/domains/domain1/applications/j2ee-modules/JsfJpa/WEB-INF/classes/-jsf-jpa-war.sql|_ThreadID=22;_ThreadName=httpSSLWorkerThread-8080-1;ClassName=null;MethodName=null;_RequestID=7fa06857-e7c2-440a-b65b-b05a9e2dcb02;|INSERT INTO WUSER (LASTNAME, USERNAME, FIRSTNAME, PASSWORD, SINCE) VALUES (?, ?, ?, ?, ?)
> bind => [test2, test2, test2, test2, 2007-07-02 23:01:17.048]|#]
>
> [#|2007-07-02T23:01:17.056+0900|FINE|sun-appserver9.1|oracle.toplink.essentials.session.file:/home/wons/works/toplink-essentials/publish/glassfish/domains/domain1/applications/j2ee-modules/JsfJpa/WEB-INF/classes/-jsf-jpa-war.sql|_ThreadID=22;_ThreadName=httpSSLWorkerThread-8080-1;ClassName=null;MethodName=null;_RequestID=7fa06857-e7c2-440a-b65b-b05a9e2dcb02;|values IDENTITY_VAL_LOCAL()|#]
>
> [#|2007-07-02T23:01:34.771+0900|FINE|sun-appserver9.1|oracle.toplink.essentials.session.file:/home/wons/works/toplink-essentials/publish/glassfish/domains/domain1/applications/j2ee-modules/JsfJpa/WEB-INF/classes/-jsf-jpa-war.sql|_ThreadID=22;_ThreadName=httpSSLWorkerThread-8080-1;ClassName=null;MethodName=null;_RequestID=7fa06857-e7c2-440a-b65b-b05a9e2dcb02;|SELECT ID, LASTNAME, USERNAME, FIRSTNAME, PASSWORD, SINCE FROM WUSER WHERE (USERNAME = CAST (? AS VARCHAR(32672) ))
> bind => [test2]|#]
>