11 Replies Latest reply on Aug 4, 2009 3:06 PM by geronimo

    Error msg: Getting database metadata

    geronimo
      Hi

      New to Seam and already trying to get something implemented at work.

      Using (all local instances):
      Seam 2.1.1
      JBoss 5.0.1
      Ant 1.7
      MSSQLServer2005

      'seam generate' is outputting the following:

      C:\seam211>seam generate
      SEAM_HOME: C:\seam211
      Using seam-gen sources from: C:\seam211\seam-gen
      Buildfile: C:\seam211\seam-gen\build.xml

      init:

      init-properties:
           [echo] C:/jboss501

      validate-workspace:

      validate-project:

      init-generate:

      generate-model:
           [echo] Reverse engineering database using JDBC driver C:/mssqlserverdriver/
      sqljdbc4.jar
           [echo] project=C:/projects/Northwind1
           [echo] model=com.pete.northwind1
      [hibernate] Executing Hibernate Tool with a JDBC Configuration (for reverse engi
      neering)
      [hibernate] 1. task: hbm2java (Generates a set of .java files)
      [hibernate] 29-Jul-2009 13:01:48 org.hibernate.cfg.Environment <clinit>
      [hibernate] INFO: Hibernate 3.2.4.sp1
      [hibernate] 29-Jul-2009 13:01:48 org.hibernate.cfg.Environment <clinit>
      [hibernate] INFO: hibernate.properties not found
      [hibernate] 29-Jul-2009 13:01:48 org.hibernate.cfg.Environment buildBytecodeProv
      ider
      [hibernate] INFO: Bytecode provider name : cglib
      [hibernate] 29-Jul-2009 13:01:48 org.hibernate.cfg.Environment <clinit>
      [hibernate] INFO: using JDK 1.4 java.sql.Timestamp handling
      [hibernate] 29-Jul-2009 13:01:48 org.hibernate.cfg.reveng.OverrideRepository add
      File
      [hibernate] INFO: Override file: C:\projects\Northwind1\resources\seam-gen.reven
      g.xml
      [hibernate] 29-Jul-2009 13:01:48 org.hibernate.connection.DriverManagerConnectio
      nProvider configure
      [hibernate] INFO: Using Hibernate built-in connection pool (not for production u
      se!)
      [hibernate] 29-Jul-2009 13:01:48 org.hibernate.connection.DriverManagerConnectio
      nProvider configure
      [hibernate] INFO: Hibernate connection pool size: 20
      [hibernate] 29-Jul-2009 13:01:48 org.hibernate.connection.DriverManagerConnectio
      nProvider configure
      [hibernate] INFO: autocommit mode: false
      [hibernate] 29-Jul-2009 13:01:49 org.hibernate.connection.DriverManagerConnectio
      nProvider configure
      [hibernate] INFO: using driver: com.microsoft.sqlserver.jdbc.SQLServerDriver at
      URL: jdbc:sqlserver://localhost/GERONIMO
      [hibernate] 29-Jul-2009 13:01:49 org.hibernate.connection.DriverManagerConnectio
      nProvider configure
      [hibernate] INFO: connection properties: {user=sa, password=****}
      [hibernate] 29-Jul-2009 13:02:03 org.hibernate.cfg.SettingsFactory buildSettings

      [hibernate] WARNING: Could not obtain connection metadata
      [hibernate] com.microsoft.sqlserver.jdbc.SQLServerException: The TCP/IP connecti
      on to the host localhost/GERONIMO, port 1433 has failed. Error: "null. Verify th
      e connection properties, check that an instance of SQL Server is running on the
      host and accepting TCP/IP connections at the port, and that no firewall is block
      ing TCP connections to the port.".
      [hibernate]     at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDrive
      rError(SQLServerException.java:170)
      [hibernate]     at com.microsoft.sqlserver.jdbc.SQLServerConnection.connectHelpe
      r(SQLServerConnection.java:1049)
      [hibernate]     at com.microsoft.sqlserver.jdbc.SQLServerConnection.login(SQLSer
      verConnection.java:833)
      [hibernate]     at com.microsoft.sqlserver.jdbc.SQLServerConnection.connect(SQLS
      erverConnection.java:716)
      [hibernate]     at com.microsoft.sqlserver.jdbc.SQLServerDriver.connect(SQLServe
      rDriver.java:841)
      [hibernate]     at java.sql.DriverManager.getConnection(DriverManager.java:582)
      [hibernate]     at java.sql.DriverManager.getConnection(DriverManager.java:154)
      [hibernate]     at org.hibernate.connection.DriverManagerConnectionProvider.getC
      onnection(DriverManagerConnectionProvider.java:110)
      [hibernate]     at org.hibernate.cfg.SettingsFactory.buildSettings(SettingsFacto
      ry.java:84)
      [hibernate]     at org.hibernate.cfg.Configuration.buildSettings(Configuration.j
      ava:2005)
      [hibernate]     at org.hibernate.cfg.JDBCMetaDataConfiguration.readFromJDBC(JDBC
      MetaDataConfiguration.java:40)
      [hibernate]     at org.hibernate.tool.ant.JDBCConfigurationTask.doConfiguration(
      JDBCConfigurationTask.java:81)
      [hibernate]     at org.hibernate.tool.ant.ConfigurationTask.getConfiguration(Con
      figurationTask.java:55)
      [hibernate]     at org.hibernate.tool.ant.HibernateToolTask.getConfiguration(Hib
      ernateToolTask.java:302)
      [hibernate]     at org.hibernate.tool.ant.HibernateToolTask.getProperties(Hibern
      ateToolTask.java:318)
      [hibernate]     at org.hibernate.tool.ant.ExporterTask.configureExporter(Exporte
      rTask.java:94)
      [hibernate]     at org.hibernate.tool.ant.Hbm2JavaExporterTask.configureExporter
      (Hbm2JavaExporterTask.java:34)
      [hibernate]     at org.hibernate.tool.ant.ExporterTask.execute(ExporterTask.java
      :39)
      [hibernate]     at org.hibernate.tool.ant.HibernateToolTask.execute(HibernateToo
      lTask.java:186)
      [hibernate]     at org.apache.tools.ant.UnknownElement.execute(UnknownElement.ja
      va:288)
      [hibernate]     at sun.reflect.GeneratedMethodAccessor1.invoke(Unknown Source)
      [hibernate]     at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMet
      hodAccessorImpl.java:25)
      [hibernate]     at java.lang.reflect.Method.invoke(Method.java:597)
      [hibernate]     at org.apache.tools.ant.dispatch.DispatchUtils.execute(DispatchU
      tils.java:105)
      [hibernate]     at org.apache.tools.ant.Task.perform(Task.java:348)
      [hibernate]     at org.apache.tools.ant.Target.execute(Target.java:357)
      [hibernate]     at org.apache.tools.ant.Target.performTasks(Target.java:385)
      [hibernate]     at org.apache.tools.ant.Project.executeSortedTargets(Project.jav
      a:1329)
      [hibernate]     at org.apache.tools.ant.Project.executeTarget(Project.java:1298)

      [hibernate]     at org.apache.tools.ant.helper.DefaultExecutor.executeTargets(De
      faultExecutor.java:41)
      [hibernate]     at org.apache.tools.ant.Project.executeTargets(Project.java:1181
      )
      [hibernate]     at org.apache.tools.ant.Main.runBuild(Main.java:698)
      [hibernate]     at org.apache.tools.ant.Main.startAnt(Main.java:199)
      [hibernate]     at org.apache.tools.ant.launch.Launcher.run(Launcher.java:257)
      [hibernate]     at org.apache.tools.ant.launch.Launcher.main(Launcher.java:104)
      [hibernate] 29-Jul-2009 13:02:03 org.hibernate.dialect.Dialect <init>
      [hibernate] INFO: Using dialect: org.hibernate.dialect.SQLServerDialect
      [hibernate] 29-Jul-2009 13:02:03 org.hibernate.transaction.TransactionFactoryFac
      tory buildTransactionFactory
      [hibernate] INFO: Using default transaction strategy (direct JDBC transactions)
      [hibernate] 29-Jul-2009 13:02:03 org.hibernate.transaction.TransactionManagerLoo
      kupFactory getTransactionManagerLookup
      [hibernate] INFO: No TransactionManagerLookup configured (in JTA environment, us
      e of read-write or transactional second-level cache is not recommended)
      [hibernate] 29-Jul-2009 13:02:03 org.hibernate.cfg.SettingsFactory buildSettings

      [hibernate] INFO: Automatic flush during beforeCompletion(): disabled
      [hibernate] 29-Jul-2009 13:02:03 org.hibernate.cfg.SettingsFactory buildSettings

      [hibernate] INFO: Automatic session close at end of transaction: disabled
      [hibernate] 29-Jul-2009 13:02:03 org.hibernate.cfg.SettingsFactory buildSettings

      [hibernate] INFO: Scrollable result sets: disabled
      [hibernate] 29-Jul-2009 13:02:03 org.hibernate.cfg.SettingsFactory buildSettings

      [hibernate] INFO: JDBC3 getGeneratedKeys(): disabled
      [hibernate] 29-Jul-2009 13:02:03 org.hibernate.cfg.SettingsFactory buildSettings

      [hibernate] INFO: Connection release mode: auto
      [hibernate] 29-Jul-2009 13:02:03 org.hibernate.cfg.SettingsFactory buildSettings

      [hibernate] INFO: Default catalog: Northwind
      [hibernate] 29-Jul-2009 13:02:03 org.hibernate.cfg.SettingsFactory buildSettings

      [hibernate] INFO: Default batch fetch size: 1
      [hibernate] 29-Jul-2009 13:02:03 org.hibernate.cfg.SettingsFactory buildSettings

      [hibernate] INFO: Generate SQL with comments: disabled
      [hibernate] 29-Jul-2009 13:02:03 org.hibernate.cfg.SettingsFactory buildSettings

      [hibernate] INFO: Order SQL updates by primary key: disabled
      [hibernate] 29-Jul-2009 13:02:03 org.hibernate.cfg.SettingsFactory buildSettings

      [hibernate] INFO: Order SQL inserts for batching: disabled
      [hibernate] 29-Jul-2009 13:02:03 org.hibernate.cfg.SettingsFactory createQueryTr
      anslatorFactory
      [hibernate] INFO: Query translator: org.hibernate.hql.ast.ASTQueryTranslatorFact
      ory
      [hibernate] 29-Jul-2009 13:02:03 org.hibernate.hql.ast.ASTQueryTranslatorFactory
      <init>
      [hibernate] INFO: Using ASTQueryTranslatorFactory
      [hibernate] 29-Jul-2009 13:02:03 org.hibernate.cfg.SettingsFactory buildSettings

      [hibernate] INFO: Query language substitutions: {}
      [hibernate] 29-Jul-2009 13:02:03 org.hibernate.cfg.SettingsFactory buildSettings

      [hibernate] INFO: JPA-QL strict compliance: disabled
      [hibernate] 29-Jul-2009 13:02:03 org.hibernate.cfg.SettingsFactory buildSettings

      [hibernate] INFO: Second-level cache: enabled
      [hibernate] 29-Jul-2009 13:02:04 org.hibernate.cfg.SettingsFactory buildSettings

      [hibernate] INFO: Query cache: disabled
      [hibernate] 29-Jul-2009 13:02:04 org.hibernate.cfg.SettingsFactory createCachePr
      ovider
      [hibernate] INFO: Cache provider: org.hibernate.cache.HashtableCacheProvider
      [hibernate] 29-Jul-2009 13:02:04 org.hibernate.cfg.SettingsFactory buildSettings

      [hibernate] INFO: Optimize cache for minimal puts: disabled
      [hibernate] 29-Jul-2009 13:02:04 org.hibernate.cfg.SettingsFactory buildSettings

      [hibernate] INFO: Structured second-level cache entries: disabled
      [hibernate] 29-Jul-2009 13:02:04 org.hibernate.cfg.SettingsFactory buildSettings

      [hibernate] INFO: Statistics: disabled
      [hibernate] 29-Jul-2009 13:02:04 org.hibernate.cfg.SettingsFactory buildSettings

      [hibernate] INFO: Deleted entity synthetic identifier rollback: disabled
      [hibernate] 29-Jul-2009 13:02:04 org.hibernate.cfg.SettingsFactory buildSettings

      [hibernate] INFO: Default entity-mode: pojo
      [hibernate] 29-Jul-2009 13:02:04 org.hibernate.cfg.SettingsFactory buildSettings

      [hibernate] INFO: Named query checking : enabled
      [hibernate] 29-Jul-2009 13:02:18 org.hibernate.connection.DriverManagerConnectio
      nProvider close
      [hibernate] INFO: cleaning up connection pool: jdbc:sqlserver://localhost/GERONI
      MO
      [hibernate] An exception occurred while running exporter #2:hbm2java (Generates
      a set of .java files)
      [hibernate] To get the full stack trace run ant with -verbose
      [hibernate] org.hibernate.exception.JDBCConnectionException: Getting database me
      tadata
      [hibernate] com.microsoft.sqlserver.jdbc.SQLServerException: The TCP/IP connecti
      on to the host localhost/GERONIMO, port 1433 has failed. Error: "null. Verify th
      e connection properties, check that an instance of SQL Server is running on the
      host and accepting TCP/IP connections at the port, and that no firewall is block
      ing TCP connections to the port.".

      BUILD FAILED
      C:\seam211\seam-gen\build.xml:1164: org.hibernate.exception.JDBCConnectionExcept
      ion: Getting database metadata

      Total time: 31 seconds

      C:\seam211>

      Can anybody help me determine the reason? I have tried with a couple of different user credentials but get same output. Couldn't connect to this db with Netbeans either even though could connect to a networked db through Netbeans

      Thanks for any help
      Pete
        • 1. Re: Error msg: Getting database metadata
          qwertywin

          one thing you might want to try and whip up a class and see if you can just get a regular JDBC connection, using your jdbc driver.


          given


          [hibernate] com.microsoft.sqlserver.jdbc.SQLServerException: The TCP/IP connecti
          on to the host localhost/GERONIMO, port 1433 has failed. Error: "null. Verify th
          e connection properties, check that an instance of SQL Server is running on the
          host and accepting TCP/IP connections at the port, and that no firewall is block
          ing TCP connections to the port.".



          I believe this will be the root of your problem.




          • 2. Re: Error msg: Getting database metadata
            qwertywin

            to clarify i mean outside of seam




            Class.forName("sqlserver driver");
            
            Connection conn = DriverManager.getConnection("jdbc://sqlserver/localhost/GERONIMO", "user", "pass" );



            remember to check if you can select from it also.

            • 3. Re: Error msg: Getting database metadata
              asookazian

              alternatively, there is a test connection button in the new connection profile screen of the Seam web project creation wizard:




              But anyway it seems that the connection URL and/or username/pswd are incorrect.


              Also, remember that MSSQL does not support sequences and that hbm2java does not automatically add @GeneratedValue(strategy = GenerationType.IDENTITY) to your @Id getter method.


              You can add this yourself in the seam-gen.reveng.xml file as follows to have hbm2java add the annotation for each table you need it for:


              <table catalog="theCatalog"
                       schema="dbo"
                       name="MyEntity">         
                     <primary-key>  
                         <generator class="identity"/>  
                     </primary-key>
                </table>

              • 4. Re: Error msg: Getting database metadata
                asookazian

                In fact, here is what you will see if you do not have the @GeneratedValue annotation on your @Id getter method:


                14:25:55,779 INFO  [STDOUT] Hibernate: 
                    insert 
                    into
                        boBETS.dbo.ApplicationSite
                        (AddedDate, AddedByUserID, UpdatedByUserID, InternalSiteID, ParentSiteID, SiteName, UpdatedDate, SiteID) 
                    values
                        (?, ?, ?, ?, ?, ?, ?, ?)
                14:25:55,795 WARN  [JDBCExceptionReporter] SQL Error: 544, SQLState: S0001
                14:25:55,795 ERROR [JDBCExceptionReporter] Cannot insert explicit value for identity column in table 'ApplicationSite' when IDENTITY_INSERT is set to OFF.



                This is the code that generated that error:


                @Startup
                @Name("insertAppSite")
                @Scope(ScopeType.APPLICATION)
                public class TestStartupInsertApplicationSite {
                
                     @In
                     private EntityManager entityManager;
                     
                     @Logger
                     private Log log;
                     
                     @Create
                     @Begin(join=true, flushMode=FlushModeType.MANUAL)
                     @Transactional
                     public void startup(){
                          ApplicationUser appUser = entityManager.find(ApplicationUser.class, 0);
                          
                          ApplicationSite appSite = new ApplicationSite();
                          appSite.setSiteName("arbiTestSite");
                          appSite.setInternalSiteId(666);
                          appSite.setParentSiteId(333);
                          appSite.setApplicationUserByAddedByUserId(appUser);
                          appSite.setAddedDate(new Date());
                          appSite.setApplicationUserByUpdatedByUserId(appUser);
                          appSite.setUpdatedDate(new Date());
                          
                          entityManager.persist(appSite);
                          entityManager.flush();
                          
                          List<ApplicationSite> list = entityManager.createQuery("from ApplicationSite").getResultList();
                          for(ApplicationSite myAppSite : list) {
                               log.info("myAppSite.siteId = "+myAppSite.getSiteId());
                          }
                     }
                }



                Note that there is no explicit call to appSite.setSiteId() in the startup() method.  Most likely Hibernate is setting it to 0 (zero) because siteId is defined as an int in the entity class.

                • 5. Re: Error msg: Getting database metadata
                  geronimo
                  Thanks very much for the help, the initial problem was indeed the connection string (jdbc:sqlserver://WXP0040\GERONIMO - works). After playing around with it for a while I finally have a prototype which displays a link to one table (Employees) in Northwind.
                  However now I have the following error:
                  javax.el.ELException: /EmployeesList.xhtml @32,62 rendered="#{empty employeesList.resultList}": Error reading 'resultList' on type com.pete.northwind1.EmployeesList_$$_javassist_1

                  stack trace:
                  javax.faces.FacesException: javax.el.ELException: /EmployeesList.xhtml @32,62 rendered="#{empty employeesList.resultList}": Error reading 'resultList' on type com.pete.northwind1.EmployeesList_$$_javassist_1
                       at javax.faces.component.UIComponentBase.isRendered(UIComponentBase.java:393)
                       at org.ajax4jsf.renderkit.RendererBase.renderChild(RendererBase.java:276)
                       at org.ajax4jsf.renderkit.RendererBase.renderChildren(RendererBase.java:262)
                       at org.richfaces.renderkit.html.PanelRenderer.doEncodeChildren(PanelRenderer.java:220)
                       at org.richfaces.renderkit.html.PanelRenderer.doEncodeChildren(PanelRenderer.java:215)
                       at org.ajax4jsf.renderkit.RendererBase.encodeChildren(RendererBase.java:121)
                       at javax.faces.component.UIComponentBase.encodeChildren(UIComponentBase.java:837)
                       at javax.faces.component.UIComponent.encodeAll(UIComponent.java:930)
                       at javax.faces.component.UIComponent.encodeAll(UIComponent.java:933)
                       at com.sun.facelets.FaceletViewHandler.renderView(FaceletViewHandler.java:592)
                       at org.ajax4jsf.application.ViewHandlerWrapper.renderView(ViewHandlerWrapper.java:108)
                       at org.ajax4jsf.application.AjaxViewHandler.renderView(AjaxViewHandler.java:196)
                       at com.sun.faces.lifecycle.RenderResponsePhase.execute(RenderResponsePhase.java:110)
                       at com.sun.faces.lifecycle.Phase.doPhase(Phase.java:100)
                       at com.sun.faces.lifecycle.LifecycleImpl.render(LifecycleImpl.java:139)
                       at javax.faces.webapp.FacesServlet.service(FacesServlet.java:266)
                       at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
                       at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
                       at org.jboss.seam.servlet.SeamFilter$FilterChainImpl.doFilter(SeamFilter.java:83)
                       at org.jboss.seam.web.IdentityFilter.doFilter(IdentityFilter.java:40)
                       at org.jboss.seam.servlet.SeamFilter$FilterChainImpl.doFilter(SeamFilter.java:69)
                       at org.jboss.seam.web.MultipartFilter.doFilter(MultipartFilter.java:90)
                       at org.jboss.seam.servlet.SeamFilter$FilterChainImpl.doFilter(SeamFilter.java:69)
                       at org.jboss.seam.web.ExceptionFilter.doFilter(ExceptionFilter.java:64)
                       at org.jboss.seam.servlet.SeamFilter$FilterChainImpl.doFilter(SeamFilter.java:69)
                       at org.jboss.seam.web.RedirectFilter.doFilter(RedirectFilter.java:45)
                       at org.jboss.seam.servlet.SeamFilter$FilterChainImpl.doFilter(SeamFilter.java:69)
                       at org.ajax4jsf.webapp.BaseXMLFilter.doXmlFilter(BaseXMLFilter.java:177)
                       at org.ajax4jsf.webapp.BaseFilter.handleRequest(BaseFilter.java:267)
                       at org.ajax4jsf.webapp.BaseFilter.processUploadsAndHandleRequest(BaseFilter.java:380)
                       at org.ajax4jsf.webapp.BaseFilter.doFilter(BaseFilter.java:507)
                       at org.jboss.seam.web.Ajax4jsfFilter.doFilter(Ajax4jsfFilter.java:56)
                       at org.jboss.seam.servlet.SeamFilter$FilterChainImpl.doFilter(SeamFilter.java:69)
                       at org.jboss.seam.web.LoggingFilter.doFilter(LoggingFilter.java:58)
                       at org.jboss.seam.servlet.SeamFilter$FilterChainImpl.doFilter(SeamFilter.java:69)
                       at org.jboss.seam.web.HotDeployFilter.doFilter(HotDeployFilter.java:53)
                       at org.jboss.seam.servlet.SeamFilter$FilterChainImpl.doFilter(SeamFilter.java:69)
                       at org.jboss.seam.servlet.SeamFilter.doFilter(SeamFilter.java:158)
                       at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
                       at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
                       at org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilter.java:96)
                       at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
                       at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
                       at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:235)
                       at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
                       at org.jboss.web.tomcat.security.SecurityAssociationValve.invoke(SecurityAssociationValve.java:190)
                       at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:433)
                       at org.jboss.web.tomcat.security.JaccContextValve.invoke(JaccContextValve.java:92)
                       at org.jboss.web.tomcat.security.SecurityContextEstablishmentValve.process(SecurityContextEstablishmentValve.java:126)
                       at org.jboss.web.tomcat.security.SecurityContextEstablishmentValve.invoke(SecurityContextEstablishmentValve.java:70)
                       at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
                       at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
                       at org.jboss.web.tomcat.service.jca.CachedConnectionValve.invoke(CachedConnectionValve.java:158)
                       at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
                       at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:330)
                       at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:829)
                       at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:601)
                       at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:447)
                       at java.lang.Thread.run(Thread.java:619)
                  Caused by: javax.el.ELException: /EmployeesList.xhtml @32,62 rendered="#{empty employeesList.resultList}": Error reading 'resultList' on type com.pete.northwind1.EmployeesList_$$_javassist_1
                       at com.sun.facelets.el.TagValueExpression.getValue(TagValueExpression.java:76)
                       at javax.faces.component.UIComponentBase.isRendered(UIComponentBase.java:390)
                       ... 58 more
                  Caused by: java.lang.IllegalArgumentException: org.hibernate.hql.ast.QuerySyntaxException: Employees is not mapped [select employees from Employees employees]
                       at org.hibernate.ejb.AbstractEntityManagerImpl.throwPersistenceException(AbstractEntityManagerImpl.java:601)
                       at org.hibernate.ejb.AbstractEntityManagerImpl.createQuery(AbstractEntityManagerImpl.java:96)
                       at org.jboss.seam.persistence.EntityManagerProxy.createQuery(EntityManagerProxy.java:81)
                       at org.jboss.seam.framework.EntityQuery.createQuery(EntityQuery.java:175)
                       at org.jboss.seam.framework.EntityQuery.initResultList(EntityQuery.java:73)
                       at org.jboss.seam.framework.EntityQuery.getResultList(EntityQuery.java:65)
                       at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
                       at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
                       at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
                       at java.lang.reflect.Method.invoke(Method.java:597)
                       at org.jboss.seam.util.Reflections.invoke(Reflections.java:22)
                       at org.jboss.seam.intercept.RootInvocationContext.proceed(RootInvocationContext.java:31)
                       at org.jboss.seam.intercept.SeamInvocationContext.proceed(SeamInvocationContext.java:56)
                       at org.jboss.seam.transaction.RollbackInterceptor.aroundInvoke(RollbackInterceptor.java:28)
                       at org.jboss.seam.intercept.SeamInvocationContext.proceed(SeamInvocationContext.java:68)
                       at org.jboss.seam.transaction.TransactionInterceptor$1.work(TransactionInterceptor.java:95)
                       at org.jboss.seam.util.Work.workInTransaction(Work.java:47)
                       at org.jboss.seam.transaction.TransactionInterceptor.aroundInvoke(TransactionInterceptor.java:89)
                       at org.jboss.seam.intercept.SeamInvocationContext.proceed(SeamInvocationContext.java:68)
                       at org.jboss.seam.core.MethodContextInterceptor.aroundInvoke(MethodContextInterceptor.java:44)
                       at org.jboss.seam.intercept.SeamInvocationContext.proceed(SeamInvocationContext.java:68)
                       at org.jboss.seam.intercept.RootInterceptor.invoke(RootInterceptor.java:107)
                       at org.jboss.seam.intercept.JavaBeanInterceptor.interceptInvocation(JavaBeanInterceptor.java:185)
                       at org.jboss.seam.intercept.JavaBeanInterceptor.invoke(JavaBeanInterceptor.java:103)
                       at com.pete.northwind1.EmployeesList_$$_javassist_1.getResultList(EmployeesList_$$_javassist_1.java)
                       at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
                       at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
                       at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
                       at java.lang.reflect.Method.invoke(Method.java:597)
                       at javax.el.BeanELResolver.getValue(BeanELResolver.java:62)
                       at javax.el.CompositeELResolver.getValue(CompositeELResolver.java:54)
                       at com.sun.faces.el.FacesCompositeELResolver.getValue(FacesCompositeELResolver.java:72)
                       at org.jboss.el.parser.AstPropertySuffix.getValue(AstPropertySuffix.java:53)
                       at org.jboss.el.parser.AstValue.getValue(AstValue.java:67)
                       at org.jboss.el.parser.AstEmpty.getValue(AstEmpty.java:29)
                       at org.jboss.el.ValueExpressionImpl.getValue(ValueExpressionImpl.java:186)
                       at com.sun.facelets.el.TagValueExpression.getValue(TagValueExpression.java:71)
                       ... 59 more
                  Caused by: org.hibernate.hql.ast.QuerySyntaxException: Employees is not mapped [select employees from Employees employees]
                       at org.hibernate.hql.ast.util.SessionFactoryHelper.requireClassPersister(SessionFactoryHelper.java:181)
                       at org.hibernate.hql.ast.tree.FromElementFactory.addFromElement(FromElementFactory.java:110)
                       at org.hibernate.hql.ast.tree.FromClause.addFromElement(FromClause.java:93)
                       at org.hibernate.hql.ast.HqlSqlWalker.createFromElement(HqlSqlWalker.java:277)
                       at org.hibernate.hql.antlr.HqlSqlBaseWalker.fromElement(HqlSqlBaseWalker.java:3056)
                       at org.hibernate.hql.antlr.HqlSqlBaseWalker.fromElementList(HqlSqlBaseWalker.java:2945)
                       at org.hibernate.hql.antlr.HqlSqlBaseWalker.fromClause(HqlSqlBaseWalker.java:688)
                       at org.hibernate.hql.antlr.HqlSqlBaseWalker.query(HqlSqlBaseWalker.java:544)
                       at org.hibernate.hql.antlr.HqlSqlBaseWalker.selectStatement(HqlSqlBaseWalker.java:281)
                       at org.hibernate.hql.antlr.HqlSqlBaseWalker.statement(HqlSqlBaseWalker.java:229)
                       at org.hibernate.hql.ast.QueryTranslatorImpl.analyze(QueryTranslatorImpl.java:251)
                       at org.hibernate.hql.ast.QueryTranslatorImpl.doCompile(QueryTranslatorImpl.java:183)
                       at org.hibernate.hql.ast.QueryTranslatorImpl.compile(QueryTranslatorImpl.java:134)
                       at org.hibernate.engine.query.HQLQueryPlan.<init>(HQLQueryPlan.java:101)
                       at org.hibernate.engine.query.HQLQueryPlan.<init>(HQLQueryPlan.java:80)
                       at org.hibernate.engine.query.QueryPlanCache.getHQLQueryPlan(QueryPlanCache.java:94)
                       at org.hibernate.impl.AbstractSessionImpl.getHQLQueryPlan(AbstractSessionImpl.java:156)
                       at org.hibernate.impl.AbstractSessionImpl.createQuery(AbstractSessionImpl.java:135)
                       at org.hibernate.impl.SessionImpl.createQuery(SessionImpl.java:1650)
                       at org.hibernate.ejb.AbstractEntityManagerImpl.createQuery(AbstractEntityManagerImpl.java:93)
                       ... 94 more

                  This seems to be coming down to a mapping problem. Why has the mapping not worked out?
                  Is it to do with SQLServer and the String EJBQL in the Employees.java:

                  @Name("employeesList")
                  public class EmployeesList extends EntityQuery<Employees> {

                       private static final String EJBQL = "select employees from Employees employees";

                       private static final String[] RESTRICTIONS = {};

                       private Employees employees = new Employees();

                       public EmployeesList() {
                            setEjbql(EJBQL);
                            setRestrictionExpressionStrings(Arrays.asList(RESTRICTIONS));
                            setMaxResults(25);
                       }

                       public Employees getEmployees() {
                            return employees;
                       }
                  }


                  Thanks in advance
                  Pete
                  • 6. Re: Error msg: Getting database metadata
                    geronimo
                    How come when I use a fully qualified Class name as per:

                    private static final String EJBQL = "select employees from com.pete.northwind1.Employees employees";

                    the error:

                    javax.el.ELException: /EmployeesList.xhtml @32,62 rendered="#{empty employeesList.resultList}": Error reading 'resultList' on type com.pete.northwind1.EmployeesList_$$_javassist_1

                    does not appear and the EmployeesList page displays although it is not returning the table entries, the resultList is still obviously empty.

                    Sorry about all the stoopid questions
                    Thanks
                    Pete
                    • 7. Re: Error msg: Getting database metadata
                      asookazian

                      show the code for Employees entity class.


                      top of the class should look similar to this:


                      @Entity
                      @Table(name = "Employees")
                      public class Employees implements java.io.Serializable {...}



                      also show your *-dev-ds.xml, components.xml, persistence-dev.xml files (I'm assuming you're ant build was using dev mode).

                      • 8. Re: Error msg: Getting database metadata
                        geronimo
                        Thanks for taking the time

                        Employees class:
                        package com.pete.northwind1;
                        // Generated 30-Jul-2009 16:05:47 by Hibernate Tools 3.2.2.GA

                        import java.io.Serializable;
                        import java.util.Date;
                        import java.util.HashSet;
                        import java.util.Set;
                        import javax.persistence.CascadeType;
                        import javax.persistence.Column;
                        import javax.persistence.Entity;
                        import javax.persistence.FetchType;
                        import javax.persistence.Id;
                        import javax.persistence.JoinColumn;
                        import javax.persistence.ManyToOne;
                        import javax.persistence.OneToMany;
                        import javax.persistence.Table;
                        import javax.persistence.Temporal;
                        import javax.persistence.TemporalType;
                        import org.hibernate.validator.NotNull;

                        /**
                        * Employees generated by hbm2java
                        */
                        @Entity
                        @Table(name = "Employees", schema = "dbo")
                        public class Employees implements java.io.Serializable {

                             private int employeeId;
                             private Employees employees;
                             private Serializable lastName;
                             private Serializable firstName;
                             private Serializable title;
                             private Serializable titleOfCourtesy;
                             private Date birthDate;
                             private Date hireDate;
                             private Serializable address;
                             private Serializable city;
                             private Serializable region;
                             private Serializable postalCode;
                             private Serializable country;
                             private Serializable homePhone;
                             private Serializable extension;
                             private byte[] photo;
                             private Serializable notes;
                             private Serializable photoPath;
                             private Set<Employees> employeeses = new HashSet<Employees>(0);
                             private Set<Employees> employeeses_1 = new HashSet<Employees>(0);

                             public Employees() {
                             }

                             public Employees(int employeeId, Serializable lastName,
                                       Serializable firstName) {
                                  this.employeeId = employeeId;
                                  this.lastName = lastName;
                                  this.firstName = firstName;
                             }
                             public Employees(int employeeId, Employees employees,
                                       Serializable lastName, Serializable firstName, Serializable title,
                                       Serializable titleOfCourtesy, Date birthDate, Date hireDate,
                                       Serializable address, Serializable city, Serializable region,
                                       Serializable postalCode, Serializable country,
                                       Serializable homePhone, Serializable extension, byte[] photo,
                                       Serializable notes, Serializable photoPath,
                                       Set<Employees> employeeses, Set<Employees> employeeses_1) {
                                  this.employeeId = employeeId;
                                  this.employees = employees;
                                  this.lastName = lastName;
                                  this.firstName = firstName;
                                  this.title = title;
                                  this.titleOfCourtesy = titleOfCourtesy;
                                  this.birthDate = birthDate;
                                  this.hireDate = hireDate;
                                  this.address = address;
                                  this.city = city;
                                  this.region = region;
                                  this.postalCode = postalCode;
                                  this.country = country;
                                  this.homePhone = homePhone;
                                  this.extension = extension;
                                  this.photo = photo;
                                  this.notes = notes;
                                  this.photoPath = photoPath;
                                  this.employeeses = employeeses;
                                  this.employeeses_1 = employeeses_1;
                             }

                             @Id
                             @Column(name = "EmployeeID", unique = true, nullable = false)
                             @NotNull
                             public int getEmployeeId() {
                                  return this.employeeId;
                             }

                             public void setEmployeeId(int employeeId) {
                                  this.employeeId = employeeId;
                             }
                             @ManyToOne(fetch = FetchType.LAZY)
                             @JoinColumn(name = "ReportsTo")
                             public Employees getEmployees() {
                                  return this.employees;
                             }

                             public void setEmployees(Employees employees) {
                                  this.employees = employees;
                             }

                             @Column(name = "LastName", nullable = false)
                             @NotNull
                             public Serializable getLastName() {
                                  return this.lastName;
                             }

                             public void setLastName(Serializable lastName) {
                                  this.lastName = lastName;
                             }

                             @Column(name = "FirstName", nullable = false)
                             @NotNull
                             public Serializable getFirstName() {
                                  return this.firstName;
                             }

                             public void setFirstName(Serializable firstName) {
                                  this.firstName = firstName;
                             }

                             @Column(name = "Title")
                             public Serializable getTitle() {
                                  return this.title;
                             }

                             public void setTitle(Serializable title) {
                                  this.title = title;
                             }

                             @Column(name = "TitleOfCourtesy")
                             public Serializable getTitleOfCourtesy() {
                                  return this.titleOfCourtesy;
                             }

                             public void setTitleOfCourtesy(Serializable titleOfCourtesy) {
                                  this.titleOfCourtesy = titleOfCourtesy;
                             }
                             @Temporal(TemporalType.TIMESTAMP)
                             @Column(name = "BirthDate", length = 23)
                             public Date getBirthDate() {
                                  return this.birthDate;
                             }

                             public void setBirthDate(Date birthDate) {
                                  this.birthDate = birthDate;
                             }
                             @Temporal(TemporalType.TIMESTAMP)
                             @Column(name = "HireDate", length = 23)
                             public Date getHireDate() {
                                  return this.hireDate;
                             }

                             public void setHireDate(Date hireDate) {
                                  this.hireDate = hireDate;
                             }

                             @Column(name = "Address")
                             public Serializable getAddress() {
                                  return this.address;
                             }

                             public void setAddress(Serializable address) {
                                  this.address = address;
                             }

                             @Column(name = "City")
                             public Serializable getCity() {
                                  return this.city;
                             }

                             public void setCity(Serializable city) {
                                  this.city = city;
                             }

                             @Column(name = "Region")
                             public Serializable getRegion() {
                                  return this.region;
                             }

                             public void setRegion(Serializable region) {
                                  this.region = region;
                             }

                             @Column(name = "PostalCode")
                             public Serializable getPostalCode() {
                                  return this.postalCode;
                             }

                             public void setPostalCode(Serializable postalCode) {
                                  this.postalCode = postalCode;
                             }

                             @Column(name = "Country")
                             public Serializable getCountry() {
                                  return this.country;
                             }

                             public void setCountry(Serializable country) {
                                  this.country = country;
                             }

                             @Column(name = "HomePhone")
                             public Serializable getHomePhone() {
                                  return this.homePhone;
                             }

                             public void setHomePhone(Serializable homePhone) {
                                  this.homePhone = homePhone;
                             }

                             @Column(name = "Extension")
                             public Serializable getExtension() {
                                  return this.extension;
                             }

                             public void setExtension(Serializable extension) {
                                  this.extension = extension;
                             }

                             @Column(name = "Photo")
                             public byte[] getPhoto() {
                                  return this.photo;
                             }

                             public void setPhoto(byte[] photo) {
                                  this.photo = photo;
                             }

                             @Column(name = "Notes")
                             public Serializable getNotes() {
                                  return this.notes;
                             }

                             public void setNotes(Serializable notes) {
                                  this.notes = notes;
                             }

                             @Column(name = "PhotoPath")
                             public Serializable getPhotoPath() {
                                  return this.photoPath;
                             }

                             public void setPhotoPath(Serializable photoPath) {
                                  this.photoPath = photoPath;
                             }
                             @OneToMany(cascade = CascadeType.ALL, fetch = FetchType.LAZY, mappedBy = "employees")
                             public Set<Employees> getEmployeeses() {
                                  return this.employeeses;
                             }

                             public void setEmployeeses(Set<Employees> employeeses) {
                                  this.employeeses = employeeses;
                             }
                             @OneToMany(cascade = CascadeType.ALL, fetch = FetchType.LAZY, mappedBy = "employees")
                             public Set<Employees> getEmployeeses_1() {
                                  return this.employeeses_1;
                             }

                             public void setEmployeeses_1(Set<Employees> employeeses_1) {
                                  this.employeeses_1 = employeeses_1;
                             }

                        }

                        *-dev-ds.xml:
                        <?xml version="1.0" encoding="UTF-8"?>

                        <!DOCTYPE datasources
                            PUBLIC "-//JBoss//DTD JBOSS JCA Config 1.5//EN"
                            "http://www.jboss.org/j2ee/dtd/jboss-ds_1_5.dtd">
                           
                        <datasources>
                          
                           <local-tx-datasource>
                              <jndi-name>Northwind1Datasource</jndi-name>
                              <connection-url>jdbc:sqlserver://WXP0040\GERONIMO</connection-url>
                              <driver-class>com.microsoft.sqlserver.jdbc.SQLServerDriver</driver-class>
                              <user-name>pspe</user-name>
                              <password>P.ssw0rd</password>
                        <!--
                              <exception-sorter-class-name>
                                 org.jboss.resource.adapter.jdbc.vendor.MySQLExceptionSorter
                              </exception-sorter-class-name>
                              <metadata>
                                 <type-mapping>mySQL</type-mapping>
                              </metadata>
                        -->
                           </local-tx-datasource>
                           
                        </datasources>

                        components:
                        <?xml version="1.0" encoding="UTF-8"?>
                        <components xmlns="http://jboss.com/products/seam/components"
                                    xmlns:core="http://jboss.com/products/seam/core"
                                    xmlns:persistence="http://jboss.com/products/seam/persistence"
                                    xmlns:drools="http://jboss.com/products/seam/drools"
                                    xmlns:bpm="http://jboss.com/products/seam/bpm"
                                    xmlns:security="http://jboss.com/products/seam/security"
                                    xmlns:mail="http://jboss.com/products/seam/mail"
                                    xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
                                    xsi:schemaLocation=
                                        "http://jboss.com/products/seam/core http://jboss.com/products/seam/core-2.1.xsd
                                         http://jboss.com/products/seam/persistence http://jboss.com/products/seam/persistence-2.1.xsd
                                         http://jboss.com/products/seam/drools http://jboss.com/products/seam/drools-2.1.xsd
                                         http://jboss.com/products/seam/bpm http://jboss.com/products/seam/bpm-2.1.xsd
                                         http://jboss.com/products/seam/security http://jboss.com/products/seam/security-2.1.xsd
                                         http://jboss.com/products/seam/mail http://jboss.com/products/seam/mail-2.1.xsd
                                         http://jboss.com/products/seam/components http://jboss.com/products/seam/components-2.1.xsd">

                           <core:init debug="@debug@" jndi-pattern="@jndiPattern@"/>

                           <component name="org.jboss.seam.debug.hotDeployFilter">
                              <property name="urlPattern">*.seam</property>
                           </component>

                           <core:manager concurrent-request-timeout="500"
                                         conversation-timeout="120000"
                                         conversation-id-parameter="cid"
                                         parent-conversation-id-parameter="pid"/>

                           <persistence:managed-persistence-context name="entityManager"
                                                             auto-create="true"
                                                  entity-manager-factory="#{Northwind1EntityManagerFactory}"/>

                           <persistence:entity-manager-factory name="Northwind1EntityManagerFactory"
                                              persistence-unit-name="Northwind1"/>

                           <drools:rule-base name="securityRules">
                              <drools:rule-files><value>/security.drl</value></drools:rule-files>
                           </drools:rule-base>

                           <security:rule-based-permission-resolver security-rules="#{securityRules}"/>

                           <security:identity authenticate-method="#{authenticator.authenticate}" remember-me="true"/>

                           <event type="org.jboss.seam.security.notLoggedIn">
                              <action execute="#{redirect.captureCurrentView}"/>
                           </event>
                           <event type="org.jboss.seam.security.loginSuccessful">
                              <action execute="#{redirect.returnToCapturedView}"/>
                           </event>

                           <mail:mail-session host="localhost" port="2525" username="test" password="test" />

                           <!-- For use with jBPM pageflow or process management -->
                           <!--
                           <bpm:jbpm>
                              <bpm:process-definitions></bpm:process-definitions>
                              <bpm:pageflow-definitions></bpm:pageflow-definitions>
                           </bpm:jbpm>
                           -->

                        </components>

                        persistence-dev-war.xml:
                        <?xml version="1.0" encoding="UTF-8"?>
                        <!-- Persistence deployment descriptor for dev profile -->
                        <persistence xmlns="http://java.sun.com/xml/ns/persistence"
                                     xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
                                     xsi:schemaLocation="http://java.sun.com/xml/ns/persistence http://java.sun.com/xml/ns/persistence/persistence_1_0.xsd"
                                     version="1.0">
                                    
                           <persistence-unit name="Northwind1" transaction-type="JTA">
                              <provider>org.hibernate.ejb.HibernatePersistence</provider>
                              <jta-data-source>java:/Northwind1Datasource</jta-data-source>
                              <properties>
                                 <property name="hibernate.dialect" value="org.hibernate.dialect.SQLServerDialect"/>
                                 <property name="hibernate.hbm2ddl.auto" value="update"/>
                                 <property name="hibernate.show_sql" value="true"/>
                                 <property name="hibernate.format_sql" value="true"/>
                                 <property name="hibernate.transaction.manager_lookup_class" value="org.hibernate.transaction.JBossTransactionManagerLookup"/>
                              </properties>
                           </persistence-unit>
                           
                        </persistence>
                        • 9. Re: Error msg: Getting database metadata
                          asookazian

                          yours:


                          <connection-url>jdbc:sqlserver://WXP0040\GERONIMO</connection-url>



                          mine:


                          <connection-url>jdbc:sqlserver://CORG0DB901:1433;databaseName=boBETS</connection-url>



                          You're missing the databaseName in your connection-url and you don't have the catalog attribute defined in @Table (which is not required but you should have at least one of these AFAIK).


                          Try adding the databaseName in your connection-url and give it a shot.


                          • 10. Re: Error msg: Getting database metadata
                            geronimo
                            Thanks Arbi

                            I have implemented your suggestion but it has not made any difference.
                            Also as I said earlier when I use a fully qualified name the ELException/ResultList error dissappears. But I have taken a closer look at the JBoss output which occurs when I click on the Entity link on the project main page. It all looks ok to my inexperienced eye but the very last line indicates that there are no persistent classes found. Where is it looking? Where should they be?


                            C:\jboss501\bin>run
                            ===============================================================================

                              JBoss Bootstrap Environment

                              JBOSS_HOME: C:\jboss501

                              JAVA: C:\Sun\SDK5\jdk\bin\java

                              JAVA_OPTS: -Dprogram.name=run.bat -server -Xms128m -Xmx512m -XX:MaxPermSize=25
                            6m -Dorg.jboss.resolver.warning=true -Dsun.rmi.dgc.client.gcInterval=3600000 -Ds
                            un.rmi.dgc.server.gcInterval=3600000

                              CLASSPATH: C:\jboss501\bin\run.jar

                            ===============================================================================

                            13:22:06,306 INFO  [ServerImpl] Starting JBoss (Microcontainer)...
                            13:22:06,306 INFO  [ServerImpl] Release ID: JBoss [Morpheus] 5.0.1.GA (build: SV
                            NTag=JBoss_5_0_1_GA date=200902231221)
                            13:22:06,306 INFO  [ServerImpl] Bootstrap URL: null
                            13:22:06,306 INFO  [ServerImpl] Home Dir: C:\jboss501
                            13:22:06,306 INFO  [ServerImpl] Home URL: file:/C:/jboss501/
                            13:22:06,306 INFO  [ServerImpl] Library URL: file:/C:/jboss501/lib/
                            13:22:06,306 INFO  [ServerImpl] Patch URL: null
                            13:22:06,306 INFO  [ServerImpl] Common Base URL: file:/C:/jboss501/common/
                            13:22:06,306 INFO  [ServerImpl] Common Library URL: file:/C:/jboss501/common/lib
                            /
                            13:22:06,306 INFO  [ServerImpl] Server Name: default
                            13:22:06,306 INFO  [ServerImpl] Server Base Dir: C:\jboss501\server
                            13:22:06,306 INFO  [ServerImpl] Server Base URL: file:/C:/jboss501/server/
                            13:22:06,306 INFO  [ServerImpl] Server Config URL: file:/C:/jboss501/server/defa
                            ult/conf/
                            13:22:06,306 INFO  [ServerImpl] Server Home Dir: C:\jboss501\server\default
                            13:22:06,306 INFO  [ServerImpl] Server Home URL: file:/C:/jboss501/server/defaul
                            t/
                            13:22:06,306 INFO  [ServerImpl] Server Data Dir: C:\jboss501\server\default\data

                            13:22:06,306 INFO  [ServerImpl] Server Library URL: file:/C:/jboss501/server/def
                            ault/lib/
                            13:22:06,306 INFO  [ServerImpl] Server Log Dir: C:\jboss501\server\default\log
                            13:22:06,306 INFO  [ServerImpl] Server Native Dir: C:\jboss501\server\default\tm
                            p\native
                            13:22:06,306 INFO  [ServerImpl] Server Temp Dir: C:\jboss501\server\default\tmp
                            13:22:06,306 INFO  [ServerImpl] Server Temp Deploy Dir: C:\jboss501\server\defau
                            lt\tmp\deploy
                            13:22:07,338 INFO  [ServerImpl] Starting Microcontainer, bootstrapURL=file:/C:/j
                            boss501/server/default/conf/bootstrap.xml
                            13:22:08,213 INFO  [VFSCacheFactory] Initializing VFSCache [org.jboss.virtual.pl
                            ugins.cache.CombinedVFSCache]
                            13:22:08,213 INFO  [VFSCacheFactory] Using VFSCache [CombinedVFSCache[real-cache
                            : null]]
                            13:22:08,697 INFO  [CopyMechanism] VFS temp dir: C:\jboss501\server\default\tmp
                            13:22:08,697 INFO  [ZipEntryContext] VFS force nested jars copy-mode is enabled.

                            13:22:11,510 INFO  [ServerInfo] Java version: 1.6.0_13,Sun Microsystems Inc.
                            13:22:11,510 INFO  [ServerInfo] Java Runtime: Java(TM) SE Runtime Environment (b
                            uild 1.6.0_13-b03)
                            13:22:11,510 INFO  [ServerInfo] Java VM: Java HotSpot(TM) Server VM 11.3-b02,Sun
                            Microsystems Inc.
                            13:22:11,510 INFO  [ServerInfo] OS-System: Windows XP 5.1,x86
                            13:22:11,650 INFO  [JMXKernel] Legacy JMX core initialized
                            13:22:16,916 INFO  [ProfileServiceImpl] Loading profile: default from: org.jboss
                            .system.server.profileservice.repository.SerializableDeploymentRepository@1e6cf0
                            7(root=C:\jboss501\server, key=org.jboss.profileservice.spi.ProfileKey@143b82c3[
                            domain=default,server=default,name=default])
                            13:22:16,931 INFO  [ProfileImpl] Using repository:org.jboss.system.server.profil
                            eservice.repository.SerializableDeploymentRepository@1e6cf07(root=C:\jboss501\se
                            rver, key=org.jboss.profileservice.spi.ProfileKey@143b82c3[domain=default,server
                            =default,name=default])
                            13:22:16,931 INFO  [ProfileServiceImpl] Loaded profile: ProfileImpl@12cd736{key=
                            org.jboss.profileservice.spi.ProfileKey@143b82c3[domain=default,server=default,n
                            ame=default]}
                            13:22:20,775 INFO  [WebService] Using RMI server codebase: http://127.0.0.1:8083
                            /
                            13:22:31,869 INFO  [NativeServerConfig] JBoss Web Services - Stack Native Core
                            13:22:31,869 INFO  [NativeServerConfig] 3.0.5.GA
                            13:22:57,713 INFO  [JMXConnectorServerService] JMX Connector server: service:jmx
                            :rmi://127.0.0.1/jndi/rmi://127.0.0.1:1090/jmxconnector
                            13:22:58,228 INFO  [MailService] Mail Service bound to java:/Mail
                            13:23:01,541 WARN  [JBossASSecurityMetadataStore] WARNING! POTENTIAL SECURITY RI
                            SK. It has been detected that the MessageSucker component which sucks messages f
                            rom one node to another has not had its password changed from the installation d
                            efault. Please see the JBoss Messaging user guide for instructions on how to do
                            this.
                            13:23:01,619 WARN  [AnnotationCreator] No ClassLoader provided, using TCCL: org.
                            jboss.managed.api.annotation.ManagementComponent
                            13:23:01,822 INFO  [TransactionManagerService] JBossTS Transaction Service (JTA
                            version) - JBoss Inc.
                            13:23:01,822 INFO  [TransactionManagerService] Setting up property manager MBean
                            and JMX layer
                            13:23:02,447 INFO  [TransactionManagerService] Initializing recovery manager
                            13:23:02,650 INFO  [TransactionManagerService] Recovery manager configured
                            ....
                            13:23:28,588 INFO  [Component] Component: org.jboss.seam.web.loggingFilter, scop
                            e: APPLICATION, type: JAVA_BEAN, class: org.jboss.seam.web.LoggingFilter
                            13:23:28,588 INFO  [Component] Component: org.jboss.seam.web.multipartFilter, sc
                            ope: APPLICATION, type: JAVA_BEAN, class: org.jboss.seam.web.MultipartFilter
                            13:23:28,588 INFO  [Component] Component: org.jboss.seam.web.parameters, scope:
                            STATELESS, type: JAVA_BEAN, class: org.jboss.seam.faces.Parameters
                            13:23:28,588 INFO  [Component] Component: org.jboss.seam.web.redirectFilter, sco
                            pe: APPLICATION, type: JAVA_BEAN, class: org.jboss.seam.web.RedirectFilter
                            13:23:28,603 INFO  [Component] Component: org.jboss.seam.web.servletContexts, sc
                            ope: EVENT, type: JAVA_BEAN, class: org.jboss.seam.web.ServletContexts
                            13:23:28,603 INFO  [Component] Component: org.jboss.seam.web.session, scope: SES
                            SION, type: JAVA_BEAN, class: org.jboss.seam.web.Session
                            13:23:28,603 INFO  [Component] Component: org.jboss.seam.web.userPrincipal, scop
                            e: APPLICATION, type: JAVA_BEAN, class: org.jboss.seam.faces.UserPrincipal
                            13:23:28,603 INFO  [Component] Component: securityRules, scope: APPLICATION, typ
                            e: JAVA_BEAN, class: org.jboss.seam.drools.RuleBase
                            13:23:28,619 INFO  [Contexts] starting up: org.jboss.seam.security.persistentPer
                            missionResolver
                            13:23:28,619 WARN  [PersistentPermissionResolver] no permission store available
                            - please install a PermissionStore with the name 'org.jboss.seam.security.jpaPer
                            missionStore' if persistent permissions are required.
                            13:23:28,619 INFO  [Contexts] starting up: Northwind1EntityManagerFactory
                            13:23:28,681 INFO  [HibernateSearchEventListenerRegister] Unable to find org.hib
                            ernate.search.event.FullTextIndexEventListener on the classpath. Hibernate Searc
                            h is not enabled.
                            13:23:28,681 INFO  [NamingHelper] JNDI InitialContext properties:{java.naming.fa
                            ctory.initial=org.jnp.interfaces.NamingContextFactory, java.naming.factory.url.p
                            kgs=org.jboss.naming:org.jnp.interfaces}
                            13:23:28,681 INFO  [DatasourceConnectionProvider] Using datasource: java:/Northw
                            ind1Datasource
                            13:23:28,697 INFO  [SettingsFactory] RDBMS: Microsoft SQL Server, version: 9.00.
                            4035
                            13:23:28,697 INFO  [SettingsFactory] JDBC driver: Microsoft SQL Server JDBC Driv
                            er 2.0, version: 2.0.1803.100
                            13:23:28,697 INFO  [Dialect] Using dialect: org.hibernate.dialect.SQLServerDiale
                            ct
                            13:23:28,697 INFO  [TransactionFactoryFactory] Transaction strategy: org.hiberna
                            te.ejb.transaction.JoinableCMTTransactionFactory
                            13:23:28,697 INFO  [TransactionManagerLookupFactory] instantiating TransactionMa
                            nagerLookup: org.hibernate.transaction.JBossTransactionManagerLookup
                            13:23:28,713 INFO  [TransactionManagerLookupFactory] instantiated TransactionMan
                            agerLookup
                            13:23:28,713 INFO  [SettingsFactory] Automatic flush during beforeCompletion():
                            disabled
                            13:23:28,713 INFO  [SettingsFactory] Automatic session close at end of transacti
                            on: disabled
                            13:23:28,713 INFO  [SettingsFactory] Scrollable result sets: enabled
                            13:23:28,713 INFO  [SettingsFactory] JDBC3 getGeneratedKeys(): enabled
                            13:23:28,713 INFO  [SettingsFactory] Connection release mode: auto
                            13:23:28,713 INFO  [SettingsFactory] Default batch fetch size: 1
                            13:23:28,713 INFO  [SettingsFactory] Generate SQL with comments: disabled
                            13:23:28,713 INFO  [SettingsFactory] Order SQL updates by primary key: disabled
                            13:23:28,713 INFO  [SettingsFactory] Order SQL inserts for batching: disabled
                            13:23:28,728 INFO  [SettingsFactory] Query translator: org.hibernate.hql.ast.AST
                            QueryTranslatorFactory
                            13:23:28,728 INFO  [ASTQueryTranslatorFactory] Using ASTQueryTranslatorFactory
                            13:23:28,728 INFO  [SettingsFactory] Query language substitutions: {}
                            13:23:28,728 INFO  [SettingsFactory] JPA-QL strict compliance: enabled
                            13:23:28,728 INFO  [SettingsFactory] Second-level cache: enabled
                            13:23:28,728 INFO  [SettingsFactory] Query cache: disabled
                            13:23:28,728 INFO  [SettingsFactory] Cache region factory : org.hibernate.cache.
                            impl.NoCachingRegionFactory
                            13:23:28,728 INFO  [SettingsFactory] Optimize cache for minimal puts: disabled
                            13:23:28,744 INFO  [SettingsFactory] Structured second-level cache entries: disa
                            bled
                            13:23:28,744 INFO  [SettingsFactory] Echoing all SQL to stdout
                            13:23:28,744 INFO  [SettingsFactory] Statistics: disabled
                            13:23:28,744 INFO  [SettingsFactory] Deleted entity synthetic identifier rollbac
                            k: disabled
                            13:23:28,744 INFO  [SettingsFactory] Default entity-mode: pojo
                            13:23:28,744 INFO  [SettingsFactory] Named query checking : enabled
                            13:23:28,744 INFO  [SessionFactoryImpl] building session factory
                            13:23:28,760 INFO  [SessionFactoryObjectFactory] Not binding factory to JNDI, no
                            JNDI name configured
                            13:23:28,760 INFO  [SchemaUpdate] Running hbm2ddl schema update
                            13:23:28,760 INFO  [SchemaUpdate] fetching database metadata
                            13:23:28,760 INFO  [SchemaUpdate] updating schema
                            13:23:28,760 INFO  [SchemaUpdate] schema update complete
                            13:23:28,760 INFO  [NamingHelper] JNDI InitialContext properties:{java.naming.fa
                            ctory.initial=org.jnp.interfaces.NamingContextFactory, java.naming.factory.url.p
                            kgs=org.jboss.naming:org.jnp.interfaces}
                            13:23:28,760 INFO  [Contexts] starting up: org.jboss.seam.security.permissionMap
                            per
                            13:23:28,775 INFO  [Contexts] starting up: org.jboss.seam.navigation.pages
                            13:23:28,806 INFO  [Contexts] starting up: org.jboss.seam.ui.facelet.faceletsJBo
                            ssLogging
                            13:23:28,806 INFO  [Contexts] starting up: org.jboss.seam.security.entityPermiss
                            ionChecker
                            13:23:28,806 INFO  [Contexts] starting up: org.jboss.seam.security.facesSecurity
                            Events
                            13:23:28,806 INFO  [Initialization] done initializing Seam
                            13:23:28,822 INFO  [SeamFilter] Initializing filter: org.jboss.seam.web.hotDeplo
                            yFilter
                            13:23:28,822 INFO  [SeamFilter] Initializing filter: org.jboss.seam.web.loggingF
                            ilter
                            13:23:28,822 INFO  [SeamFilter] Initializing filter: org.jboss.seam.web.ajax4jsf
                            Filter
                            13:23:28,900 INFO  [CacheManager] Selected [org.ajax4jsf.cache.LRUMapCacheFactor
                            y] cache factory
                            13:23:28,916 INFO  [LRUMapCacheFactory] Creating LRUMap cache instance using par
                            ameters: {facelets.DEVELOPMENT=true, org.richfaces.CONTROL_SKINNING=disable, com
                            .sun.faces.duplicateJARPattern=^tmp\d+(\S*\.jar), org.richfaces.CONTROL_SKINNING
                            _CLASSES=disable, org.richfaces.SKIN=classic, com.sun.faces.injectionProvider=or
                            g.jboss.web.jsf.integration.injection.JBossDelegatingInjectionProvider, org.rich
                            faces.LoadScriptStrategy=ALL, org.richfaces.LoadStyleStrategy=ALL, javax.faces.D
                            EFAULT_SUFFIX=.xhtml}
                            13:23:28,916 INFO  [LRUMapCacheFactory] Creating LRUMap cache instance of defaul
                            t capacity
                            13:23:28,963 INFO  [CacheManager] Selected [org.ajax4jsf.cache.LRUMapCacheFactor
                            y] cache factory
                            13:23:28,963 INFO  [LRUMapCacheFactory] Creating LRUMap cache instance using par
                            ameters: {facelets.DEVELOPMENT=true, org.richfaces.CONTROL_SKINNING=disable, com
                            .sun.faces.duplicateJARPattern=^tmp\d+(\S*\.jar), org.richfaces.CONTROL_SKINNING
                            _CLASSES=disable, org.richfaces.SKIN=classic, com.sun.faces.injectionProvider=or
                            g.jboss.web.jsf.integration.injection.JBossDelegatingInjectionProvider, org.rich
                            faces.LoadScriptStrategy=ALL, org.richfaces.LoadStyleStrategy=ALL, javax.faces.D
                            EFAULT_SUFFIX=.xhtml}
                            13:23:28,978 INFO  [LRUMapCacheFactory] Creating LRUMap cache instance of defaul
                            t capacity
                            13:23:28,978 INFO  [SeamFilter] Initializing filter: org.jboss.seam.web.redirect
                            Filter
                            13:23:28,978 INFO  [SeamFilter] Initializing filter: org.jboss.seam.web.exceptio
                            nFilter
                            13:23:28,978 INFO  [SeamFilter] Initializing filter: org.jboss.seam.web.multipar
                            tFilter
                            13:23:28,978 INFO  [SeamFilter] Initializing filter: org.jboss.seam.web.identity
                            Filter
                            13:23:29,041 INFO  [TomcatDeployment] deploy, ctxPath=/
                            13:23:29,244 INFO  [TomcatDeployment] deploy, ctxPath=/jmx-console
                            13:23:29,385 INFO  [Http11Protocol] Starting Coyote HTTP/1.1 on http-127.0.0.1-8
                            080
                            13:23:29,447 INFO  [AjpProtocol] Starting Coyote AJP/1.3 on ajp-127.0.0.1-8009
                            13:23:29,463 INFO  [ServerImpl] JBoss (Microcontainer) [5.0.1.GA (build: SVNTag=
                            JBoss_5_0_1_GA date=200902231221)] Started in 1m:23s:157ms
                            13:23:48,978 INFO  [Contexts] starting up: org.jboss.seam.security.identity
                            13:23:48,994 INFO  [Contexts] starting up: org.jboss.seam.security.ruleBasedPerm
                            issionResolver
                            13:23:51,306 INFO  [RuleBase] parsing rules: /security.drl
                            13:23:51,885 INFO  [Contexts] starting up: org.jboss.seam.web.session
                            13:23:57,572 INFO  [compiler] Added Library from: vfszip:/C:/jboss501/server/def
                            ault/deploy/Northwind1.war/WEB-INF/lib/jboss-seam-pdf.jar/META-INF/seam-pdf.tagl
                            ib.xml
                            13:23:57,588 INFO  [compiler] Added Library from: vfszip:/C:/jboss501/server/def
                            ault/deploy/Northwind1.war/WEB-INF/lib/jboss-seam-rss.jar/META-INF/seam-rss.tagl
                            ib.xml
                            13:23:57,650 INFO  [compiler] Added Library from: vfszip:/C:/jboss501/server/def
                            ault/deploy/Northwind1.war/WEB-INF/lib/richfaces-ui.jar/META-INF/a4j.taglib.xml
                            13:23:57,666 INFO  [compiler] Added Library from: vfszip:/C:/jboss501/server/def
                            ault/deploy/Northwind1.war/WEB-INF/lib/richfaces-ui.jar/META-INF/ajax4jsf.taglib
                            .xml
                            13:23:57,666 INFO  [compiler] Added Library from: vfszip:/C:/jboss501/server/def
                            ault/deploy/Northwind1.war/WEB-INF/lib/richfaces-ui.jar/META-INF/jsp.taglib.xml
                            13:23:57,822 INFO  [compiler] Added Library from: vfszip:/C:/jboss501/server/def
                            ault/deploy/Northwind1.war/WEB-INF/lib/richfaces-ui.jar/META-INF/rich.taglib.xml

                            13:23:57,838 INFO  [compiler] Added Library from: vfszip:/C:/jboss501/server/def
                            ault/deploy/Northwind1.war/WEB-INF/lib/richfaces-ui.jar/META-INF/richfaces.tagli
                            b.xml
                            13:23:57,900 INFO  [compiler] Added Library from: vfszip:/C:/jboss501/server/def
                            ault/deploy/Northwind1.war/WEB-INF/lib/jsf-facelets.jar/META-INF/jsf-core.taglib
                            .xml
                            13:23:57,916 INFO  [compiler] Added Library from: vfszip:/C:/jboss501/server/def
                            ault/deploy/Northwind1.war/WEB-INF/lib/jsf-facelets.jar/META-INF/jsf-html.taglib
                            .xml
                            13:23:57,947 INFO  [compiler] Added Library from: vfszip:/C:/jboss501/server/def
                            ault/deploy/Northwind1.war/WEB-INF/lib/jsf-facelets.jar/META-INF/jsf-ui.taglib.x
                            ml
                            13:23:57,978 INFO  [compiler] Added Library from: vfszip:/C:/jboss501/server/def
                            ault/deploy/Northwind1.war/WEB-INF/lib/jsf-facelets.jar/META-INF/jstl-core.tagli
                            b.xml
                            13:23:57,994 INFO  [compiler] Added Library from: vfszip:/C:/jboss501/server/def
                            ault/deploy/Northwind1.war/WEB-INF/lib/jsf-facelets.jar/META-INF/jstl-fn.taglib.
                            xml
                            13:23:57,994 INFO  [compiler] Added Library from: vfszip:/C:/jboss501/server/def
                            ault/deploy/Northwind1.war/WEB-INF/lib/jboss-seam-excel.jar/META-INF/seam-excel.
                            taglib.xml
                            13:23:57,994 INFO  [compiler] Added Library from: vfszip:/C:/jboss501/server/def
                            ault/deploy/Northwind1.war/WEB-INF/lib/jboss-seam-mail.jar/META-INF/seam-mail.ta
                            glib.xml
                            13:23:58,025 INFO  [compiler] Added Library from: vfszip:/C:/jboss501/server/def
                            ault/deploy/Northwind1.war/WEB-INF/lib/jboss-seam-ui.jar/META-INF/s.taglib.xml
                            13:24:07,369 WARN  [QuerySplitter] no persistent classes found for query class:
                            select employees from com.pete.northwind1.Employees employees
                            • 11. Re: Error msg: Getting database metadata
                              geronimo
                              Ooops that was from a previous JBoss restart

                              Should've been:


                              C:\jboss501\bin>run
                              ===============================================================================

                                JBoss Bootstrap Environment

                                JBOSS_HOME: C:\jboss501

                                JAVA: C:\Sun\SDK5\jdk\bin\java

                                JAVA_OPTS: -Dprogram.name=run.bat -server -Xms128m -Xmx512m -XX:MaxPermSize=25
                              6m -Dorg.jboss.resolver.warning=true -Dsun.rmi.dgc.client.gcInterval=3600000 -Ds
                              un.rmi.dgc.server.gcInterval=3600000

                                CLASSPATH: C:\jboss501\bin\run.jar

                              ===============================================================================

                              13:33:47,338 INFO  [ServerImpl] Starting JBoss (Microcontainer)...
                              13:33:47,338 INFO  [ServerImpl] Release ID: JBoss [Morpheus] 5.0.1.GA (build: SV
                              NTag=JBoss_5_0_1_GA date=200902231221)
                              ...
                              ...
                              13:34:56,697 INFO  [SessionFactoryObjectFactory] Bound factory to JNDI name: per
                              sistence.unit:unitName=#Northwind1
                              13:34:56,697 WARN  [SessionFactoryObjectFactory] InitialContext did not implemen
                              t EventContext
                              13:34:56,728 INFO  [SchemaUpdate] Running hbm2ddl schema update
                              13:34:56,728 INFO  [SchemaUpdate] fetching database metadata
                              13:34:56,744 INFO  [SchemaUpdate] updating schema
                              13:34:58,744 INFO  [TableMetadata] table found: Northwind.dbo.Employees
                              13:34:58,744 INFO  [TableMetadata] columns: [region, hiredate, postalcode, emplo
                              yeeid, lastname, firstname, photo, city, country, extension, title, titleofcourt
                              esy, address, birthdate, notes, reportsto, homephone, photopath]
                              13:34:58,760 INFO  [TableMetadata] foreign keys: [fk14ac0f651068cd50, fk_employe
                              es_employees]
                              13:34:58,760 INFO  [TableMetadata] indexes: [postalcode, pk_employees, lastname]

                              13:34:58,760 INFO  [SchemaUpdate] schema update complete
                              13:34:58,760 INFO  [NamingHelper] JNDI InitialContext properties:{java.naming.fa
                              ctory.initial=org.jnp.interfaces.NamingContextFactory, java.naming.factory.url.p
                              kgs=org.jboss.naming:org.jnp.interfaces}
                              13:34:58,822 INFO  [TomcatDeployment] deploy, ctxPath=/Northwind1
                              13:35:03,025 INFO  [ServletContextListener] Welcome to Seam 2.1.1.GA
                              13:35:07,760 INFO  [Scanner] skipping class org/jboss/seam/remoting/gwt/GWT14Ser
                              vice.class because it cannot be loaded (may reference a type which is not availa
                              ble on the classpath)
                              13:35:07,994 INFO  [Initialization] Namespace: http://jboss.com/products/seam/fr
                              amework, package: org.jboss.seam.framework, prefix: org.jboss.seam.core.framewor
                              k
                              13:35:07,994 INFO  [Initialization] Namespace: http://jboss.com/products/seam/as
                              ync, package: org.jboss.seam.async, prefix: org.jboss.seam.async
                              13:35:07,994 INFO  [Initialization] Namespace: http://jboss.com/products/seam/th
                              eme, package: org.jboss.seam.theme, prefix: org.jboss.seam.theme
                              13:35:08,010 INFO  [Initialization] Namespace: http://jboss.com/products/seam/se
                              curity, package: org.jboss.seam.security.management, prefix: org.jboss.seam.secu
                              rity
                              13:35:08,010 INFO  [Initialization] Namespace: http://jboss.com/products/seam/bp
                              m, package: org.jboss.seam.bpm, prefix: org.jboss.seam.bpm
                              13:35:08,010 INFO  [Initialization] Namespace: http://jboss.com/products/seam/ma
                              il, package: org.jboss.seam.mail, prefix: org.jboss.seam.mail
                              13:35:08,010 INFO  [Initialization] Namespace: http://jboss.com/products/seam/se
                              curity, package: org.jboss.seam.security, prefix: org.jboss.seam.security
                              13:35:08,010 INFO  [Initialization] Namespace: http://jboss.com/products/seam/we
                              b, package: org.jboss.seam.web, prefix: org.jboss.seam.web
                              13:35:08,010 INFO  [Initialization] Namespace: http://jboss.com/products/seam/ca
                              ptcha, package: org.jboss.seam.captcha, prefix: org.jboss.seam.captcha
                              13:35:08,025 INFO  [Initialization] Namespace: http://jboss.com/products/seam/na
                              vigation, package: org.jboss.seam.navigation, prefix: org.jboss.seam.navigation
                              13:35:08,025 INFO  [Initialization] Namespace: http://jboss.com/products/seam/in
                              ternational, package: org.jboss.seam.international, prefix: org.jboss.seam.inter
                              national
                              13:35:08,025 INFO  [Initialization] Namespace: http://jboss.com/products/seam/co
                              re, package: org.jboss.seam.core, prefix: org.jboss.seam.core
                              13:35:08,025 INFO  [Initialization] Namespace: http://jboss.com/products/seam/ca
                              che, package: org.jboss.seam.cache, prefix: org.jboss.seam.cache
                              13:35:08,025 INFO  [Initialization] Namespace: http://jboss.com/products/seam/pd
                              f, package: org.jboss.seam.pdf, prefix:
                              13:35:08,041 INFO  [Initialization] Namespace: http://jboss.com/products/seam/jm
                              s, package: org.jboss.seam.jms, prefix: org.jboss.seam.jms
                              13:35:08,041 INFO  [Initialization] Namespace: http://jboss.com/products/seam/ui
                              , package: org.jboss.seam.ui, prefix: org.jboss.seam.ui
                              13:35:08,041 INFO  [Initialization] Namespace: http://jboss.com/products/seam/ex
                              cel, package: org.jboss.seam.excel, prefix: org.jboss.seam.excel
                              13:35:08,041 INFO  [Initialization] Namespace: http://jboss.com/products/seam/re
                              moting, package: org.jboss.seam.remoting, prefix: org.jboss.seam.remoting
                              13:35:08,041 INFO  [Initialization] Namespace: http://jboss.com/products/seam/tr
                              ansaction, package: org.jboss.seam.transaction, prefix: org.jboss.seam.transacti
                              on
                              13:35:08,041 INFO  [Initialization] Namespace: http://jboss.com/products/seam/se
                              curity, package: org.jboss.seam.security.permission, prefix: org.jboss.seam.secu
                              rity
                              13:35:08,056 INFO  [Initialization] Namespace: http://jboss.com/products/seam/dr
                              ools, package: org.jboss.seam.drools, prefix: org.jboss.seam.drools
                              13:35:08,056 INFO  [Initialization] Namespace: http://jboss.com/products/seam/sp
                              ring, package: org.jboss.seam.ioc.spring, prefix: org.jboss.seam.ioc.spring
                              13:35:08,056 INFO  [Initialization] Namespace: http://jboss.com/products/seam/do
                              cument, package: org.jboss.seam.document, prefix: org.jboss.seam.document
                              13:35:08,056 INFO  [Initialization] Namespace: http://jboss.com/products/seam/pe
                              rsistence, package: org.jboss.seam.persistence, prefix: org.jboss.seam.persisten
                              ce
                              13:35:08,056 INFO  [Initialization] reading /WEB-INF/components.xml
                              13:35:08,150 INFO  [Initialization] reading properties from: /seam.properties
                              13:35:08,150 INFO  [Initialization] reading properties from: /jndi.properties
                              13:35:08,166 INFO  [Initialization] initializing Seam
                              13:35:08,228 INFO  [Component] Component: org.jboss.seam.core.init, scope: APPLI
                              CATION, type: JAVA_BEAN, class: org.jboss.seam.core.Init
                              13:35:08,260 INFO  [Initialization] two components with same name, higher preced
                              ence wins: org.jboss.seam.core.manager
                              13:35:08,275 INFO  [Initialization] two components with same name, higher preced
                              ence wins: org.jboss.seam.transaction.synchronizations
                              13:35:08,275 INFO  [Initialization] two components with same name, higher preced
                              ence wins: org.jboss.seam.jms.topicConnection
                              13:35:08,275 INFO  [Initialization] two components with same name, higher preced
                              ence wins: org.jboss.seam.web.isUserInRole
                              13:35:08,275 INFO  [Initialization] two components with same name, higher preced
                              ence wins: org.jboss.seam.core.locale
                              13:35:08,275 INFO  [Initialization] two components with same name, higher preced
                              ence wins: org.jboss.seam.core.locale
                              13:35:08,275 INFO  [Initialization] two components with same name, higher preced
                              ence wins: org.jboss.seam.web.userPrincipal
                              13:35:08,291 INFO  [Initialization] two components with same name, higher preced
                              ence wins: org.jboss.seam.persistence.persistenceProvider
                              13:35:08,291 INFO  [Initialization] two components with same name, higher preced
                              ence wins: org.jboss.seam.core.resourceLoader
                              13:35:08,291 INFO  [Initialization] two components with same name, higher preced
                              ence wins: org.jboss.seam.core.expressions
                              13:35:08,291 INFO  [Initialization] two components with same name, higher preced
                              ence wins: org.jboss.seam.web.parameters
                              13:35:09,322 INFO  [Initialization] Installing components...
                              13:35:09,353 INFO  [Component] Component: Northwind1EntityManagerFactory, scope:
                              APPLICATION, type: JAVA_BEAN, class: org.jboss.seam.persistence.EntityManagerFa
                              ctory
                              ...
                              ...
                              JBoss_5_0_1_GA date=200902231221)] Started in 1m:23s:797ms
                              13:38:00,556 INFO  [Contexts] starting up: org.jboss.seam.security.identity
                              13:38:00,572 INFO  [Contexts] starting up: org.jboss.seam.security.ruleBasedPerm
                              issionResolver
                              13:38:02,931 INFO  [RuleBase] parsing rules: /security.drl
                              13:38:03,541 INFO  [Contexts] starting up: org.jboss.seam.web.session
                              13:38:09,119 INFO  [compiler] Added Library from: vfszip:/C:/jboss501/server/def
                              ault/deploy/Northwind1.war/WEB-INF/lib/jboss-seam-pdf.jar/META-INF/seam-pdf.tagl
                              ib.xml
                              13:38:09,135 INFO  [compiler] Added Library from: vfszip:/C:/jboss501/server/def
                              ault/deploy/Northwind1.war/WEB-INF/lib/jboss-seam-rss.jar/META-INF/seam-rss.tagl
                              ib.xml
                              13:38:09,181 INFO  [compiler] Added Library from: vfszip:/C:/jboss501/server/def
                              ault/deploy/Northwind1.war/WEB-INF/lib/richfaces-ui.jar/META-INF/a4j.taglib.xml
                              13:38:09,197 INFO  [compiler] Added Library from: vfszip:/C:/jboss501/server/def
                              ault/deploy/Northwind1.war/WEB-INF/lib/richfaces-ui.jar/META-INF/ajax4jsf.taglib
                              .xml
                              13:38:09,197 INFO  [compiler] Added Library from: vfszip:/C:/jboss501/server/def
                              ault/deploy/Northwind1.war/WEB-INF/lib/richfaces-ui.jar/META-INF/jsp.taglib.xml
                              13:38:09,353 INFO  [compiler] Added Library from: vfszip:/C:/jboss501/server/def
                              ault/deploy/Northwind1.war/WEB-INF/lib/richfaces-ui.jar/META-INF/rich.taglib.xml

                              13:38:09,369 INFO  [compiler] Added Library from: vfszip:/C:/jboss501/server/def
                              ault/deploy/Northwind1.war/WEB-INF/lib/richfaces-ui.jar/META-INF/richfaces.tagli
                              b.xml
                              13:38:09,431 INFO  [compiler] Added Library from: vfszip:/C:/jboss501/server/def
                              ault/deploy/Northwind1.war/WEB-INF/lib/jsf-facelets.jar/META-INF/jsf-core.taglib
                              .xml
                              13:38:09,447 INFO  [compiler] Added Library from: vfszip:/C:/jboss501/server/def
                              ault/deploy/Northwind1.war/WEB-INF/lib/jsf-facelets.jar/META-INF/jsf-html.taglib
                              .xml
                              13:38:09,478 INFO  [compiler] Added Library from: vfszip:/C:/jboss501/server/def
                              ault/deploy/Northwind1.war/WEB-INF/lib/jsf-facelets.jar/META-INF/jsf-ui.taglib.x
                              ml
                              13:38:09,525 INFO  [compiler] Added Library from: vfszip:/C:/jboss501/server/def
                              ault/deploy/Northwind1.war/WEB-INF/lib/jsf-facelets.jar/META-INF/jstl-core.tagli
                              b.xml
                              13:38:09,541 INFO  [compiler] Added Library from: vfszip:/C:/jboss501/server/def
                              ault/deploy/Northwind1.war/WEB-INF/lib/jsf-facelets.jar/META-INF/jstl-fn.taglib.
                              xml
                              13:38:09,541 INFO  [compiler] Added Library from: vfszip:/C:/jboss501/server/def
                              ault/deploy/Northwind1.war/WEB-INF/lib/jboss-seam-excel.jar/META-INF/seam-excel.
                              taglib.xml
                              13:38:09,556 INFO  [compiler] Added Library from: vfszip:/C:/jboss501/server/def
                              ault/deploy/Northwind1.war/WEB-INF/lib/jboss-seam-mail.jar/META-INF/seam-mail.ta
                              glib.xml
                              13:38:09,572 INFO  [compiler] Added Library from: vfszip:/C:/jboss501/server/def
                              ault/deploy/Northwind1.war/WEB-INF/lib/jboss-seam-ui.jar/META-INF/s.taglib.xml
                              13:38:35,478 WARN  [QuerySplitter] no persistent classes found for query class:
                              select employees from com.pete.northwind1.Employees employees