Install lcds: Hibernate problem

[Floh-VerbaVoice]

Hi,

I tried following the steps in http://help.adobe.com/en_US/LiveCycleDataServicesES/3.1/Installing/lcds31_install.html#JBoss

Here we're using OpenSuse with  JBoss 4.2.1. So I extracted lcds-samples.war to /opt/jboss/server/lc_mysql/deploy/lcds-samples.war/ then restarted JBoss. But there are errors:

2011-07-07 13:22:40,139 INFO  [org.jboss.web.tomcat.service.TomcatDeployer] deploy, ctxPath=/lcds-samples, warUrl=.../deploy/lcds-samples.war/
2011-07-07 13:14:23,285 INFO  [STDOUT] [LCDS][WARN] No login command was found for 'JBossWeb/2.0.0.GA'. Please ensure that the login-command tag has the correct server attribute value, or use 'all' to use the login command regardless of the server.
2011-07-07 13:14:23,587 ERROR [STDERR] Jul 7, 2011 1:14:23 PM org.hibernate.cfg.Environment <clinit>
INFO: Hibernate 3.2.5
2011-07-07 13:14:23,593 ERROR [STDERR] Jul 7, 2011 1:14:23 PM org.hibernate.cfg.Environment <clinit>
INFO: hibernate.properties not found
2011-07-07 13:14:23,595 ERROR [STDERR] Jul 7, 2011 1:14:23 PM org.hibernate.cfg.Environment buildBytecodeProvider
INFO: Bytecode provider name : cglib
2011-07-07 13:14:23,598 ERROR [STDERR] Jul 7, 2011 1:14:23 PM org.hibernate.cfg.Environment <clinit>
INFO: using JDK 1.4 java.sql.Timestamp handling
2011-07-07 13:14:23,640 ERROR [STDERR] Jul 7, 2011 1:14:23 PM org.hibernate.cfg.Configuration configure
INFO: configuring from resource: /hibernate.cfg.xml
2011-07-07 13:14:23,641 ERROR [STDERR] Jul 7, 2011 1:14:23 PM org.hibernate.cfg.Configuration getConfigurationInputStream
INFO: Configuration resource: /hibernate.cfg.xml
2011-07-07 13:14:23,683 ERROR [STDERR] Jul 7, 2011 1:14:23 PM org.hibernate.cfg.Configuration addResource
INFO: Reading mappings from resource : flex/samples/contact/Contact.hbm.xml
2011-07-07 13:14:23,753 ERROR [STDERR] Jul 7, 2011 1:14:23 PM org.hibernate.cfg.HbmBinder bindRootPersistentClassCommonValues
INFO: Mapping class: flex.samples.contact.Contact -> contact
2011-07-07 13:14:23,772 ERROR [STDERR] Jul 7, 2011 1:14:23 PM org.hibernate.cfg.Configuration doConfigure
INFO: Configured SessionFactory: null
2011-07-07 13:14:23,824 ERROR [STDERR] Jul 7, 2011 1:14:23 PM org.hibernate.connection.DriverManagerConnectionProvider configure
INFO: Using Hibernate built-in connection pool (not for production use!)
2011-07-07 13:14:23,824 ERROR [STDERR] Jul 7, 2011 1:14:23 PM org.hibernate.connection.DriverManagerConnectionProvider configure
INFO: Hibernate connection pool size: 1
2011-07-07 13:14:23,825 ERROR [STDERR] Jul 7, 2011 1:14:23 PM org.hibernate.connection.DriverManagerConnectionProvider configure
INFO: autocommit mode: false
2011-07-07 13:14:23,826 ERROR [STDERR] Jul 7, 2011 1:14:23 PM org.hibernate.connection.DriverManagerConnectionProvider configure
INFO: using driver: org.hsqldb.jdbcDriver at URL: jdbc:hsqldb:hsql://localhost:9002/flexdemodb
2011-07-07 13:14:23,827 ERROR [STDERR] Jul 7, 2011 1:14:23 PM org.hibernate.connection.DriverManagerConnectionProvider configure
INFO: connection properties: {user=sa, password=****}
2011-07-07 13:14:24,237 ERROR [STDERR] Jul 7, 2011 1:14:24 PM org.hibernate.cfg.SettingsFactory buildSettings
INFO: RDBMS: HSQL Database Engine, version: 1.8.0
2011-07-07 13:14:24,237 ERROR [STDERR] Jul 7, 2011 1:14:24 PM org.hibernate.cfg.SettingsFactory buildSettings
INFO: JDBC driver: HSQL Database Engine Driver, version: 1.8.0
2011-07-07 13:14:24,251 ERROR [STDERR] Jul 7, 2011 1:14:24 PM org.hibernate.dialect.Dialect <init>
INFO: Using dialect: org.hibernate.dialect.HSQLDialect
2011-07-07 13:14:24,263 ERROR [STDERR] Jul 7, 2011 1:14:24 PM org.hibernate.transaction.TransactionFactoryFactory buildTransactionFactory
INFO: Using default transaction strategy (direct JDBC transactions)
2011-07-07 13:14:24,266 ERROR [STDERR] Jul 7, 2011 1:14:24 PM org.hibernate.transaction.TransactionManagerLookupFactory getTransactionManagerLookup
INFO: No TransactionManagerLookup configured (in JTA environment, use of read-write or transactional second-level cache is not recommended)
2011-07-07 13:14:24,266 ERROR [STDERR] Jul 7, 2011 1:14:24 PM org.hibernate.cfg.SettingsFactory buildSettings
INFO: Automatic flush during beforeCompletion(): disabled
2011-07-07 13:14:24,267 ERROR [STDERR] Jul 7, 2011 1:14:24 PM org.hibernate.cfg.SettingsFactory buildSettings
INFO: Automatic session close at end of transaction: disabled
2011-07-07 13:14:24,267 ERROR [STDERR] Jul 7, 2011 1:14:24 PM org.hibernate.cfg.SettingsFactory buildSettings
INFO: JDBC batch size: 15
2011-07-07 13:14:24,267 ERROR [STDERR] Jul 7, 2011 1:14:24 PM org.hibernate.cfg.SettingsFactory buildSettings
INFO: JDBC batch updates for versioned data: disabled
2011-07-07 13:14:24,272 ERROR [STDERR] Jul 7, 2011 1:14:24 PM org.hibernate.cfg.SettingsFactory buildSettings
INFO: Scrollable result sets: enabled
2011-07-07 13:14:24,272 ERROR [STDERR] Jul 7, 2011 1:14:24 PM org.hibernate.cfg.SettingsFactory buildSettings
INFO: JDBC3 getGeneratedKeys(): disabled
2011-07-07 13:14:24,273 ERROR [STDERR] Jul 7, 2011 1:14:24 PM org.hibernate.cfg.SettingsFactory buildSettings
INFO: Connection release mode: auto
2011-07-07 13:14:24,273 ERROR [STDERR] Jul 7, 2011 1:14:24 PM org.hibernate.cfg.SettingsFactory buildSettings
INFO: Default batch fetch size: 1
2011-07-07 13:14:24,274 ERROR [STDERR] Jul 7, 2011 1:14:24 PM org.hibernate.cfg.SettingsFactory buildSettings
INFO: Generate SQL with comments: disabled
2011-07-07 13:14:24,274 ERROR [STDERR] Jul 7, 2011 1:14:24 PM org.hibernate.cfg.SettingsFactory buildSettings
INFO: Order SQL updates by primary key: disabled
2011-07-07 13:14:24,275 ERROR [STDERR] Jul 7, 2011 1:14:24 PM org.hibernate.cfg.SettingsFactory buildSettings
INFO: Order SQL inserts for batching: disabled
2011-07-07 13:14:24,275 ERROR [STDERR] Jul 7, 2011 1:14:24 PM org.hibernate.cfg.SettingsFactory createQueryTranslatorFactory
INFO: Query translator: org.hibernate.hql.ast.ASTQueryTranslatorFactory
2011-07-07 13:14:24,277 ERROR [STDERR] Jul 7, 2011 1:14:24 PM org.hibernate.hql.ast.ASTQueryTranslatorFactory <init>
INFO: Using ASTQueryTranslatorFactory
2011-07-07 13:14:24,278 ERROR [STDERR] Jul 7, 2011 1:14:24 PM org.hibernate.cfg.SettingsFactory buildSettings
INFO: Query language substitutions: {}
2011-07-07 13:14:24,278 ERROR [STDERR] Jul 7, 2011 1:14:24 PM org.hibernate.cfg.SettingsFactory buildSettings
INFO: JPA-QL strict compliance: disabled
2011-07-07 13:14:24,279 ERROR [STDERR] Jul 7, 2011 1:14:24 PM org.hibernate.cfg.SettingsFactory buildSettings
INFO: Second-level cache: enabled
2011-07-07 13:14:24,279 ERROR [STDERR] Jul 7, 2011 1:14:24 PM org.hibernate.cfg.SettingsFactory buildSettings
INFO: Query cache: disabled
2011-07-07 13:14:24,279 ERROR [STDERR] Jul 7, 2011 1:14:24 PM org.hibernate.cfg.SettingsFactory createCacheProvider
INFO: Cache provider: org.hibernate.cache.NoCacheProvider
2011-07-07 13:14:24,280 ERROR [STDERR] Jul 7, 2011 1:14:24 PM org.hibernate.cfg.SettingsFactory buildSettings
INFO: Optimize cache for minimal puts: disabled
2011-07-07 13:14:24,280 ERROR [STDERR] Jul 7, 2011 1:14:24 PM org.hibernate.cfg.SettingsFactory buildSettings
INFO: Structured second-level cache entries: disabled
2011-07-07 13:14:24,285 ERROR [STDERR] Jul 7, 2011 1:14:24 PM org.hibernate.cfg.SettingsFactory buildSettings
INFO: Echoing all SQL to stdout
2011-07-07 13:14:24,285 ERROR [STDERR] Jul 7, 2011 1:14:24 PM org.hibernate.cfg.SettingsFactory buildSettings
INFO: Statistics: disabled
2011-07-07 13:14:24,286 ERROR [STDERR] Jul 7, 2011 1:14:24 PM org.hibernate.cfg.SettingsFactory buildSettings
INFO: Deleted entity synthetic identifier rollback: disabled
2011-07-07 13:14:24,286 ERROR [STDERR] Jul 7, 2011 1:14:24 PM org.hibernate.cfg.SettingsFactory buildSettings
INFO: Default entity-mode: pojo
2011-07-07 13:14:24,287 ERROR [STDERR] Jul 7, 2011 1:14:24 PM org.hibernate.cfg.SettingsFactory buildSettings
INFO: Named query checking : enabled
2011-07-07 13:14:24,309 ERROR [STDERR] Jul 7, 2011 1:14:24 PM org.hibernate.impl.SessionFactoryImpl <init>
INFO: building session factory
2011-07-07 13:14:24,490 ERROR [STDERR] Jul 7, 2011 1:14:24 PM org.hibernate.impl.SessionFactoryObjectFactory addInstance
INFO: Not binding factory to JNDI, no JNDI name configured
2011-07-07 13:14:24,630 ERROR [STDERR] Jul 7, 2011 1:14:24 PM org.hibernate.connection.DriverManagerConnectionProvider configure
INFO: Using Hibernate built-in connection pool (not for production use!)
2011-07-07 13:14:24,631 ERROR [STDERR] Jul 7, 2011 1:14:24 PM org.hibernate.connection.DriverManagerConnectionProvider configure
INFO: Hibernate connection pool size: 1
2011-07-07 13:14:24,631 ERROR [STDERR] Jul 7, 2011 1:14:24 PM org.hibernate.connection.DriverManagerConnectionProvider configure
INFO: autocommit mode: false
2011-07-07 13:14:24,631 ERROR [STDERR] Jul 7, 2011 1:14:24 PM org.hibernate.connection.DriverManagerConnectionProvider configure
INFO: using driver: org.hsqldb.jdbcDriver at URL: jdbc:hsqldb:hsql://localhost:9002/flexdemodb
2011-07-07 13:14:24,632 ERROR [STDERR] Jul 7, 2011 1:14:24 PM org.hibernate.connection.DriverManagerConnectionProvider configure
INFO: connection properties: {user=sa, password=****}
2011-07-07 13:14:24,636 ERROR [STDERR] Jul 7, 2011 1:14:24 PM org.hibernate.cfg.SettingsFactory buildSettings
INFO: RDBMS: HSQL Database Engine, version: 1.8.0
2011-07-07 13:14:24,636 ERROR [STDERR] Jul 7, 2011 1:14:24 PM org.hibernate.cfg.SettingsFactory buildSettings
INFO: JDBC driver: HSQL Database Engine Driver, version: 1.8.0
2011-07-07 13:14:24,637 ERROR [STDERR] Jul 7, 2011 1:14:24 PM org.hibernate.dialect.Dialect <init>
INFO: Using dialect: org.hibernate.dialect.HSQLDialect
2011-07-07 13:14:24,638 ERROR [STDERR] Jul 7, 2011 1:14:24 PM org.hibernate.transaction.TransactionFactoryFactory buildTransactionFactory
INFO: Using default transaction strategy (direct JDBC transactions)
2011-07-07 13:14:24,638 ERROR [STDERR] Jul 7, 2011 1:14:24 PM org.hibernate.transaction.TransactionManagerLookupFactory getTransactionManagerLookup
INFO: No TransactionManagerLookup configured (in JTA environment, use of read-write or transactional second-level cache is not recommended)
2011-07-07 13:14:24,638 ERROR [STDERR] Jul 7, 2011 1:14:24 PM org.hibernate.cfg.SettingsFactory buildSettings
INFO: Automatic flush during beforeCompletion(): disabled
2011-07-07 13:14:24,639 ERROR [STDERR] Jul 7, 2011 1:14:24 PM org.hibernate.cfg.SettingsFactory buildSettings
INFO: Automatic session close at end of transaction: disabled
2011-07-07 13:14:24,639 ERROR [STDERR] Jul 7, 2011 1:14:24 PM org.hibernate.cfg.SettingsFactory buildSettings
INFO: JDBC batch size: 15
2011-07-07 13:14:24,640 ERROR [STDERR] Jul 7, 2011 1:14:24 PM org.hibernate.cfg.SettingsFactory buildSettings
INFO: JDBC batch updates for versioned data: disabled
2011-07-07 13:14:24,640 ERROR [STDERR] Jul 7, 2011 1:14:24 PM org.hibernate.cfg.SettingsFactory buildSettings
INFO: Scrollable result sets: enabled
2011-07-07 13:14:24,641 ERROR [STDERR] Jul 7, 2011 1:14:24 PM org.hibernate.cfg.SettingsFactory buildSettings
INFO: JDBC3 getGeneratedKeys(): disabled
2011-07-07 13:14:24,641 ERROR [STDERR] Jul 7, 2011 1:14:24 PM org.hibernate.cfg.SettingsFactory buildSettings
INFO: Connection release mode: auto
2011-07-07 13:14:24,641 ERROR [STDERR] Jul 7, 2011 1:14:24 PM org.hibernate.cfg.SettingsFactory buildSettings
INFO: Default batch fetch size: 1
2011-07-07 13:14:24,642 ERROR [STDERR] Jul 7, 2011 1:14:24 PM org.hibernate.cfg.SettingsFactory buildSettings
INFO: Generate SQL with comments: disabled
2011-07-07 13:14:24,642 ERROR [STDERR] Jul 7, 2011 1:14:24 PM org.hibernate.cfg.SettingsFactory buildSettings
INFO: Order SQL updates by primary key: disabled
2011-07-07 13:14:24,643 ERROR [STDERR] Jul 7, 2011 1:14:24 PM org.hibernate.cfg.SettingsFactory buildSettings
INFO: Order SQL inserts for batching: disabled
2011-07-07 13:14:24,643 ERROR [STDERR] Jul 7, 2011 1:14:24 PM org.hibernate.cfg.SettingsFactory createQueryTranslatorFactory
INFO: Query translator: org.hibernate.hql.ast.ASTQueryTranslatorFactory
2011-07-07 13:14:24,644 ERROR [STDERR] Jul 7, 2011 1:14:24 PM org.hibernate.hql.ast.ASTQueryTranslatorFactory <init>
INFO: Using ASTQueryTranslatorFactory
2011-07-07 13:14:24,644 ERROR [STDERR] Jul 7, 2011 1:14:24 PM org.hibernate.cfg.SettingsFactory buildSettings
INFO: Query language substitutions: {}
2011-07-07 13:14:24,644 ERROR [STDERR] Jul 7, 2011 1:14:24 PM org.hibernate.cfg.SettingsFactory buildSettings
INFO: JPA-QL strict compliance: disabled
2011-07-07 13:14:24,645 ERROR [STDERR] Jul 7, 2011 1:14:24 PM org.hibernate.cfg.SettingsFactory buildSettings
INFO: Second-level cache: enabled
2011-07-07 13:14:24,645 ERROR [STDERR] Jul 7, 2011 1:14:24 PM org.hibernate.cfg.SettingsFactory buildSettings
INFO: Query cache: disabled
2011-07-07 13:14:24,646 ERROR [STDERR] Jul 7, 2011 1:14:24 PM org.hibernate.cfg.SettingsFactory createCacheProvider
INFO: Cache provider: org.hibernate.cache.NoCacheProvider
2011-07-07 13:14:24,646 ERROR [STDERR] Jul 7, 2011 1:14:24 PM org.hibernate.cfg.SettingsFactory buildSettings
INFO: Optimize cache for minimal puts: disabled
2011-07-07 13:14:24,646 ERROR [STDERR] Jul 7, 2011 1:14:24 PM org.hibernate.cfg.SettingsFactory buildSettings
INFO: Structured second-level cache entries: disabled
2011-07-07 13:14:24,647 ERROR [STDERR] Jul 7, 2011 1:14:24 PM org.hibernate.cfg.SettingsFactory buildSettings
INFO: Echoing all SQL to stdout
2011-07-07 13:14:24,647 ERROR [STDERR] Jul 7, 2011 1:14:24 PM org.hibernate.cfg.SettingsFactory buildSettings
INFO: Statistics: disabled
2011-07-07 13:14:24,648 ERROR [STDERR] Jul 7, 2011 1:14:24 PM org.hibernate.cfg.SettingsFactory buildSettings
INFO: Deleted entity synthetic identifier rollback: disabled
2011-07-07 13:14:24,648 ERROR [STDERR] Jul 7, 2011 1:14:24 PM org.hibernate.cfg.SettingsFactory buildSettings
INFO: Default entity-mode: pojo
2011-07-07 13:14:24,648 ERROR [STDERR] Jul 7, 2011 1:14:24 PM org.hibernate.cfg.SettingsFactory buildSettings
INFO: Named query checking : enabled
2011-07-07 13:14:24,652 ERROR [STDERR] Jul 7, 2011 1:14:24 PM org.hibernate.impl.SessionFactoryImpl <init>
INFO: building session factory
2011-07-07 13:14:24,656 ERROR [STDERR] Jul 7, 2011 1:14:24 PM org.hibernate.impl.SessionFactoryObjectFactory addInstance
INFO: Not binding factory to JNDI, no JNDI name configured

I tried the following part in documentation (I know, we're not using 5.x but just to be sure if it helps):

Unfortunatelly it didn't help. So could you help me please?

cu Floh

[Rohit___Kumar · Accepted solution]

Hi,

If you pick up standard JBoss 4.2.1 installation, you should not have to add the the classloading xml / any configuration change. You need to:

1. Pick the lcds-samples.war from your installation and put it in exploded form under the deploy folder.

2. Ensure that the HSQLDB is started by running the startdb.bat script from the sampledb folder in the LCDS 3.1 installation.

Now just restarting the server should be all that you need to do.

Rohit

[Floh-VerbaVoice]

Hi Rohit,

I already did exactly those steps you described before. classloading xml is removed in the meanwhile. I started startdb.sh before starting jboss.

So what could be wrong?

cu Floh

[Rohit___Kumar]

Are you seeing any errors in the server logs (the one you pasted above is perfectly normal)? Turn on debug logging for LCDS in services-config.xml (see documentation for how to do it).

Rohit

[Floh-VerbaVoice]

Oh... do you mean the server may running well? So why are there " ERROR [STDERR]" which confused me? How can I test if LCDS is working? (we're new in LiveCycle DataServices)

Thank you very much!

cu Floh

[Rohit___Kumar]

Just try running some of lcds samples by navigating to http://localhost:8080/lcds-samples.

Rohit

[Floh-VerbaVoice]

Hi Rohit,

thank you very much. You're right. Is was already working from beginning. The log with "ERROR [STDERR]" confused me a lot. *sigh*

cu Floh