Hi,
Does the framework currently supports DB2 persistence ? I've set up a project using your provided Maven Archetype package. It works fine with default HSQL setup. However when I tried to do it with DB2 - it fails to deploy. The problem seems to be in Jetty environment DBCP configuration, but I am not 100% sure. The exception that appears in Jetty output is:
[artifact:mvn] [ INFO] 18:49:57 ConnectionProviderFactory - Initializing connection provider: org.hibernate.ejb.connection.InjectedDataSourceConnectionProvider
[artifact:mvn] [ INFO] 18:49:57 InjectedDataSourceConnectionProvider - Using provided datasource
[artifact:mvn] [ WARN] 18:49:57 SettingsFactory - Could not obtain connection to query metadata
[artifact:mvn] org.apache.commons.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory ([jcc][t4][2030][11211][4.2.73] A communication error occurred during operations on the connection's underlying socket, socket input stream,
[artifact:mvn] or socket output stream. Error location: Reply.fill(). Message: Insufficient data. ERRORCODE=-4499, SQLSTATE=08001)
[artifact:mvn] at org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:1225)
[artifact:mvn] at org.apache.commons.dbcp.BasicDataSource.getConnection(BasicDataSource.java:880)
[artifact:mvn] at org.hibernate.ejb.connection.InjectedDataSourceConnectionProvider.getConnection(InjectedDataSourceConnectionProvider.java:71)
[artifact:mvn] at org.hibernate.cfg.SettingsFactory.buildSettings(SettingsFactory.java:113)
[artifact:mvn] at org.hibernate.cfg.Configuration.buildSettingsInternal(Configuration.java:2863)
[artifact:mvn] at org.hibernate.cfg.Configuration.buildSettings(Configuration.java:2859)
[artifact:mvn] at org.hibernate.cfg.Configuration.buildSessionFactory(Configuration.java:1870)
[artifact:mvn] at org.hibernate.ejb.Ejb3Configuration.buildEntityManagerFactory(Ejb3Configuration.java:906)
[artifact:mvn] at org.hibernate.ejb.HibernatePersistence.createContainerEntityManagerFactory(HibernatePersistence.java:74)
[artifact:mvn] at org.springframework.orm.jpa.LocalContainerEntityManagerFactoryBean.createNativeEntityManagerFactory(LocalContainerEntityManagerFactoryBean.java:225)
I am not sure if some additional configuration needs to be added to jetty-env.xml
The version of DB2 is 9.7
This forum is in readonly mode and serves as an archive of old information. All posting, registration and commenting abilities have been turned off. To get help, the Broadleaf team reguarly monitors the broadleaf-commerce tag on Stack Overflow so please ask your questions there.