Empty Search Results on TableList
jesse Jul 1, 2008 5:18 PMI have created a few projects in seam that work great, however, I just ran into a situation where it seemed to generate fine however, when opening in the browser the page appears fine but the data list below the search parameters is empty. There are 10 rows in the table and there are 10 rows on the screen but the rows are all empty.
The other table's data appears fine. Has anyone else ran into this situation?
jboss-4.2.2.GA
jboss-seam-2.0.2.SP1
C:\junk>seam generate Buildfile: C:\jboss-seam-2.0.2.SP1\seam-gen\build.xml init: init-properties: [echo] C:/jboss-4.2.2.GA validate-workspace: validate-project: init-generate: generate-model: [echo] Reverse engineering database using JDBC driver C:\Program Files\webMethods7\common\lib\ojdbc14.jar [echo] project=C:/junk/msdsadmin [echo] model=com.mydomain.msdsadmin [hibernate] Executing Hibernate Tool with a JDBC Configuration (for reverse engineering) [hibernate] 1. task: hbm2java (Generates a set of .java files) [hibernate] Jul 1, 2008 8:57:39 AM org.hibernate.cfg.Environment <clinit> [hibernate] INFO: Hibernate 3.2.4.sp1 [hibernate] Jul 1, 2008 8:57:39 AM org.hibernate.cfg.Environment <clinit> [hibernate] INFO: hibernate.properties not found [hibernate] Jul 1, 2008 8:57:39 AM org.hibernate.cfg.Environment buildBytecodeProvider [hibernate] INFO: Bytecode provider name : cglib [hibernate] Jul 1, 2008 8:57:39 AM org.hibernate.cfg.Environment <clinit> [hibernate] INFO: using JDK 1.4 java.sql.Timestamp handling [hibernate] Jul 1, 2008 8:57:39 AM org.hibernate.cfg.reveng.OverrideRepository addFile [hibernate] INFO: Override file: C:\junk\msdsadmin\resources\seam-gen.reveng.xml [hibernate] Jul 1, 2008 8:57:39 AM org.hibernate.connection.DriverManagerConnectionProvider configure [hibernate] INFO: Using Hibernate built-in connection pool (not for production use!) [hibernate] Jul 1, 2008 8:57:39 AM org.hibernate.connection.DriverManagerConnectionProvider configure [hibernate] INFO: Hibernate connection pool size: 20 [hibernate] Jul 1, 2008 8:57:39 AM org.hibernate.connection.DriverManagerConnectionProvider configure [hibernate] INFO: autocommit mode: false [hibernate] Jul 1, 2008 8:57:39 AM org.hibernate.connection.DriverManagerConnectionProvider configure [hibernate] INFO: using driver: oracle.jdbc.driver.OracleDriver at URL: jdbc:oracle:thin:@<database>:1521:apexd b [hibernate] Jul 1, 2008 8:57:39 AM org.hibernate.connection.DriverManagerConnectionProvider configure [hibernate] INFO: connection properties: {user=dotcomcm, password=****} [hibernate] Jul 1, 2008 8:57:43 AM org.hibernate.cfg.SettingsFactory buildSettings [hibernate] INFO: RDBMS: Oracle, version: Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - 64bit Production [hibernate] With the Partitioning, OLAP and Data Mining options [hibernate] Jul 1, 2008 8:57:43 AM org.hibernate.cfg.SettingsFactory buildSettings [hibernate] INFO: JDBC driver: Oracle JDBC driver, version: 10.2.0.1.0 [hibernate] Jul 1, 2008 8:57:43 AM org.hibernate.dialect.Dialect <init> [hibernate] INFO: Using dialect: org.hibernate.dialect.OracleDialect [hibernate] Jul 1, 2008 8:57:43 AM org.hibernate.transaction.TransactionFactoryFactory buildTransactionFactory [hibernate] INFO: Using default transaction strategy (direct JDBC transactions) [hibernate] Jul 1, 2008 8:57:43 AM org.hibernate.transaction.TransactionManagerLookupFactory getTransactionManagerLookup [hibernate] INFO: No TransactionManagerLookup configured (in JTA environment, use of read-write or transactional second-level cache is not recommended) [hibernate] Jul 1, 2008 8:57:43 AM org.hibernate.cfg.SettingsFactory buildSettings [hibernate] INFO: Automatic flush during beforeCompletion(): disabled [hibernate] Jul 1, 2008 8:57:43 AM org.hibernate.cfg.SettingsFactory buildSettings [hibernate] INFO: Automatic session close at end of transaction: disabled [hibernate] Jul 1, 2008 8:57:43 AM org.hibernate.cfg.SettingsFactory buildSettings [hibernate] INFO: JDBC batch size: 15 [hibernate] Jul 1, 2008 8:57:43 AM org.hibernate.cfg.SettingsFactory buildSettings [hibernate] INFO: JDBC batch updates for versioned data: disabled [hibernate] Jul 1, 2008 8:57:43 AM org.hibernate.cfg.SettingsFactory buildSettings [hibernate] INFO: Scrollable result sets: enabled [hibernate] Jul 1, 2008 8:57:43 AM org.hibernate.cfg.SettingsFactory buildSettings [hibernate] INFO: JDBC3 getGeneratedKeys(): disabled [hibernate] Jul 1, 2008 8:57:43 AM org.hibernate.cfg.SettingsFactory buildSettings [hibernate] INFO: Connection release mode: auto [hibernate] Jul 1, 2008 8:57:43 AM org.hibernate.cfg.SettingsFactory buildSettings [hibernate] INFO: Default schema: DOTCOMCM [hibernate] Jul 1, 2008 8:57:43 AM org.hibernate.cfg.SettingsFactory buildSettings [hibernate] INFO: Default batch fetch size: 1 [hibernate] Jul 1, 2008 8:57:43 AM org.hibernate.cfg.SettingsFactory buildSettings [hibernate] INFO: Generate SQL with comments: disabled [hibernate] Jul 1, 2008 8:57:43 AM org.hibernate.cfg.SettingsFactory buildSettings [hibernate] INFO: Order SQL updates by primary key: disabled [hibernate] Jul 1, 2008 8:57:43 AM org.hibernate.cfg.SettingsFactory buildSettings [hibernate] INFO: Order SQL inserts for batching: disabled [hibernate] Jul 1, 2008 8:57:43 AM org.hibernate.cfg.SettingsFactory createQueryTranslatorFactory [hibernate] INFO: Query translator: org.hibernate.hql.ast.ASTQueryTranslatorFactory [hibernate] Jul 1, 2008 8:57:43 AM org.hibernate.hql.ast.ASTQueryTranslatorFactory <init> [hibernate] INFO: Using ASTQueryTranslatorFactory [hibernate] Jul 1, 2008 8:57:43 AM org.hibernate.cfg.SettingsFactory buildSettings [hibernate] INFO: Query language substitutions: {} [hibernate] Jul 1, 2008 8:57:43 AM org.hibernate.cfg.SettingsFactory buildSettings [hibernate] INFO: JPA-QL strict compliance: disabled [hibernate] Jul 1, 2008 8:57:43 AM org.hibernate.cfg.SettingsFactory buildSettings [hibernate] INFO: Second-level cache: enabled [hibernate] Jul 1, 2008 8:57:43 AM org.hibernate.cfg.SettingsFactory buildSettings [hibernate] INFO: Query cache: disabled [hibernate] Jul 1, 2008 8:57:43 AM org.hibernate.cfg.SettingsFactory createCacheProvider [hibernate] INFO: Cache provider: org.hibernate.cache.HashtableCacheProvider [hibernate] Jul 1, 2008 8:57:43 AM org.hibernate.cfg.SettingsFactory buildSettings [hibernate] INFO: Optimize cache for minimal puts: disabled [hibernate] Jul 1, 2008 8:57:43 AM org.hibernate.cfg.SettingsFactory buildSettings [hibernate] INFO: Structured second-level cache entries: disabled [hibernate] Jul 1, 2008 8:57:43 AM org.hibernate.cfg.SettingsFactory buildSettings [hibernate] INFO: Statistics: disabled [hibernate] Jul 1, 2008 8:57:43 AM org.hibernate.cfg.SettingsFactory buildSettings [hibernate] INFO: Deleted entity synthetic identifier rollback: disabled [hibernate] Jul 1, 2008 8:57:43 AM org.hibernate.cfg.SettingsFactory buildSettings [hibernate] INFO: Default entity-mode: pojo [hibernate] Jul 1, 2008 8:57:43 AM org.hibernate.cfg.SettingsFactory buildSettings [hibernate] INFO: Named query checking : enabled [hibernate] Jul 1, 2008 8:57:43 AM org.hibernate.cfg.reveng.dialect.OracleMetaDataDialect$1 convertRow [hibernate] INFO: {TABLE_NAME=AV_MSDS_INFO, REMARKS=null, TABLE_TYPE=TABLE, TABLE_SCHEM=DOTCOMCM, TABLE_CAT=null} [hibernate] Jul 1, 2008 8:57:43 AM org.hibernate.cfg.reveng.dialect.OracleMetaDataDialect$1 convertRow [hibernate] INFO: {TABLE_NAME=AV_MSDS_PN, REMARKS=null, TABLE_TYPE=TABLE, TABLE_SCHEM=DOTCOMCM, TABLE_CAT=null} [hibernate] Jul 1, 2008 8:57:45 AM org.hibernate.cfg.reveng.JDBCReader processPrimaryKey [hibernate] WARNING: The JDBC driver didn't report any primary key columns in AV_MSDS_INFO. Asking rev.eng. strategy [hibernate] Jul 1, 2008 8:57:45 AM org.hibernate.cfg.reveng.JDBCReader processPrimaryKey [hibernate] WARNING: Rev.eng. strategy did not report any primary key columns for AV_MSDS_INFO [hibernate] Jul 1, 2008 8:57:47 AM org.hibernate.cfg.reveng.JDBCReader processPrimaryKey [hibernate] WARNING: The JDBC driver didn't report any primary key columns in AV_MSDS_PN. Asking rev.eng. strategy [hibernate] Jul 1, 2008 8:57:47 AM org.hibernate.cfg.reveng.JDBCReader processPrimaryKey [hibernate] WARNING: Rev.eng. strategy did not report any primary key columns for AV_MSDS_PN [hibernate] Jul 1, 2008 8:57:49 AM org.hibernate.connection.DriverManagerConnectionProvider close [hibernate] INFO: cleaning up connection pool: jdbc:oracle:thin:@orcl-prd-3.aviallinc.com:1521:apexdb [hibernate] Jul 1, 2008 8:57:49 AM org.hibernate.tool.Version <clinit> [hibernate] INFO: Hibernate Tools 3.2.0.CR1 [javaformatter] Java formatting of 4 files completed. Skipped 0 file(s). generate-ui: [echo] Building project 'msdsadmin' to generate views and controllers init: [mkdir] Created dir: C:\junk\msdsadmin\exploded-archives\msdsadmin.jar [mkdir] Created dir: C:\junk\msdsadmin\exploded-archives\msdsadmin.ear [mkdir] Created dir: C:\junk\msdsadmin\exploded-archives\msdsadmin.war [mkdir] Created dir: C:\junk\msdsadmin\dist compile: [javac] Compiling 5 source files to C:\junk\msdsadmin\exploded-archives\msdsadmin.jar copyclasses: jar: [copy] Copying 2 files to C:\junk\msdsadmin\exploded-archives\msdsadmin.jar [copy] Copying 1 file to C:\junk\msdsadmin\exploded-archives\msdsadmin.jar\META-INF [copy] Copying 1 file to C:\junk\msdsadmin\exploded-archives\msdsadmin.jar\META-INF [copy] Copying 1 file to C:\junk\msdsadmin\exploded-archives\msdsadmin.jar [hibernate] Executing Hibernate Tool with a JPA Configuration [hibernate] 1. task: generic exportertemplate: view/list.xhtml.ftl [hibernate] Jul 1, 2008 8:57:52 AM org.hibernate.cfg.annotations.Version <clinit> [hibernate] INFO: Hibernate Annotations 3.3.0.GA [hibernate] Jul 1, 2008 8:57:52 AM org.hibernate.ejb.Version <clinit> [hibernate] INFO: Hibernate EntityManager 3.3.1.GA [hibernate] Jul 1, 2008 8:57:52 AM org.hibernate.cfg.AnnotationBinder bindClass [hibernate] INFO: Binding entity from annotated class: com.mydomain.msdsadmin.AvMsdsInfo [hibernate] Jul 1, 2008 8:57:52 AM org.hibernate.cfg.annotations.EntityBinder bindTable [hibernate] INFO: Bind entity com.mydomain.msdsadmin.AvMsdsInfo on table AV_MSDS_INFO [hibernate] Jul 1, 2008 8:57:52 AM org.hibernate.cfg.AnnotationBinder bindClass [hibernate] INFO: Binding entity from annotated class: com.mydomain.msdsadmin.AvMsdsPn [hibernate] Jul 1, 2008 8:57:52 AM org.hibernate.cfg.annotations.EntityBinder bindTable [hibernate] INFO: Bind entity com.mydomain.msdsadmin.AvMsdsPn on table AV_MSDS_PN [hibernate] Jul 1, 2008 8:57:53 AM org.hibernate.validator.Version <clinit> [hibernate] INFO: Hibernate Validator 3.0.0.GA [hibernate] 2. task: generic exportertemplate: view/view.xhtml.ftl [hibernate] 3. task: generic exportertemplate: view/view.page.xml.ftl [hibernate] 4. task: generic exportertemplate: view/edit.xhtml.ftl [hibernate] 5. task: generic exportertemplate: view/edit.page.xml.ftl [hibernate] 6. task: generic exportertemplate: src/EntityList.java.ftl [hibernate] 7. task: generic exportertemplate: view/list.page.xml.ftl [hibernate] 8. task: generic exportertemplate: src/EntityHome.java.ftl [hibernate] 9. task: generic exportertemplate: view/layout/menu.xhtml.ftl [javaformatter] Java formatting of 5 files completed. Skipped 0 file(s). [echo] Type 'seam restart' and go to http://localhost:8080/msdsadmin generate: BUILD SUCCESSFUL Total time: 15 seconds