How to install IceScrum2 with your own DataBase

[Stéphane Maldini]

To install IceScrum2 with your own database, you have to change some core configuration in a single file. However you will need the Java driver from your DataBase provider.

This simple tutorial will show you how to do it in 3 steps.

1 - Download the Java driver in your [Tomcat-WebApps Root]/[icescrum2 Root]/WEB-INF/lib repertory. Let's taking MySQL driver for example (note : MySQL driver is already included in the icescrum2 libs). On MySQL official website, you will search for MySQL Java Connector and you will find mysql-connector-java-5.x.x-bin.jar file. Place it on the said lib repertory an go step 2.

2 - Log as an admin (default login: sa, pwd: sa). Use driverClassName provided by the Java Connector documentation. For MySQL this is : "org.gjt.mm.mysql.Driver".
Don't forget to change your database URL which begins usually with "jdbc:"[name of your database provider in lower case]://[DB adress]/[databaseName which contains icescrum2 tables].
You can also define your db login and db password here.

3 - Change database Dialect. In order to fully support your DB, you have to change the database dialect used : for mysql org.hibernate.dialect.MySQLInnoDBDialect


You will know if your database is supported on http://www.hibernate.org/80.html

[individuodk]

Oracle fails, why?

create table icescrum2_Builds (idBuild number(10,0) not null, date timestamp, description varchar2(3000 char), name varchar2(255 char), nbTotalTest number(10,0), state number(10,0), is2product_fk varchar2(255 char), primary key (idBuild))

GRAVE: ORA-00904: : invalid identifier

--> date is problematic column name

GRAVE: ORA-00972: identifier is too long

--> colums names are too long

is it posible a new version?

i have pasted the Log catalina:
7-ene-2010 11:23:50 org.apache.catalina.core.AprLifecycleListener init
INFO: The APR based Apache Tomcat Native library which allows optimal performance in production environments was not found on the java.library.path: C:\k-zone\k-workspace\JAVA\App\jdk1.6.0_11\bin;.;C:\WINDOWS\Sun\Java\bin;C:\WINDOWS\system32;C:\WINDOWS;C:\Program Files\RA2HP\;C:\k-zone\k-workspace\JAVA\App\javafx-sdk1.0\bin;C:\k-zone\k-workspace\JAVA\App\javafx-sdk1.0\emulator\bin;C:\oracle\ora10g\bin;C:\WINDOWS\system32;C:\WINDOWS;C:\WINDOWS\System32\Wbem;C:\Program Files\ActivCard\ActivCard Gold\resources;C:\Program Files\HPQ\IAM\bin;c:\Program Files\ATI Technologies\ATI.ACE\Core-Static;C:\Program Files\QuickTime\QTSystem\;C:\Program Files\Attachmate\Reflection\;C:\Program Files\TortoiseSVN\bin
27-ene-2010 11:23:50 org.apache.coyote.http11.Http11Protocol init
INFO: Inicializando Coyote HTTP/1.1 en puerto http-8080
27-ene-2010 11:23:50 org.apache.catalina.startup.Catalina load
INFO: Initialization processed in 390 ms
27-ene-2010 11:23:50 org.apache.catalina.core.StandardService start
INFO: Arrancando servicio Catalina
27-ene-2010 11:23:50 org.apache.catalina.core.StandardEngine start
INFO: Starting Servlet Engine: Apache Tomcat/6.0.18
27-ene-2010 11:23:50 org.apache.catalina.core.StandardContext addApplicationListener
INFO: The listener "com.icesoft.faces.util.event.servlet.ContextEventRepeater" is already configured for this context. The duplicate definition has been ignored.
27-ene-2010 11:23:51 org.apache.catalina.session.StandardManager doLoad
27-ene-2010 11:23:59 org.hibernate.cfg.annotations.Version <clinit>
INFO: Hibernate Annotations 3.4.0.GA
27-ene-2010 11:23:59 org.hibernate.cfg.Environment <clinit>
INFO: Hibernate 3.3.0.SP1
27-ene-2010 11:23:59 org.hibernate.cfg.Environment <clinit>
INFO: hibernate.properties not found
27-ene-2010 11:23:59 org.hibernate.cfg.Environment buildBytecodeProvider
INFO: Bytecode provider name : javassist
27-ene-2010 11:23:59 org.hibernate.cfg.Environment <clinit>
INFO: using JDK 1.4 java.sql.Timestamp handling
27-ene-2010 11:23:59 org.hibernate.annotations.common.Version <clinit>
INFO: Hibernate Commons Annotations 3.1.0.GA
27-ene-2010 11:23:59 org.hibernate.cfg.Configuration configure
INFO: configuring from url: file:/C:/k-zone/k-workspace/JAVA/App/icescrum2_R2_14_2_bundle_tomcat6/icescrum2/work/Catalina/localhost/icescrum-web-R2/loader/META-INF/hibernate.cfg.xml
27-ene-2010 11:24:00 org.hibernate.cfg.Configuration doConfigure
INFO: Configured SessionFactory: null
27-ene-2010 11:24:00 org.hibernate.cfg.AnnotationBinder bindClass
INFO: Binding entity from annotated class: icescrum2.dao.model.impl.Product
27-ene-2010 11:24:00 org.hibernate.cfg.annotations.EntityBinder bindTable
INFO: Bind entity icescrum2.dao.model.impl.Product on table icescrum2_Product
27-ene-2010 11:24:00 org.hibernate.cfg.AnnotationBinder bindClass
INFO: Binding entity from annotated class: icescrum2.dao.model.impl.ProductBacklogItem
27-ene-2010 11:24:00 org.hibernate.cfg.annotations.EntityBinder bindTable
INFO: Bind entity icescrum2.dao.model.impl.ProductBacklogItem on table icescrum2_ProductBacklogItem
27-ene-2010 11:24:00 org.hibernate.cfg.AnnotationBinder bindClass
INFO: Binding entity from annotated class: icescrum2.dao.model.impl.Problem
27-ene-2010 11:24:00 org.hibernate.cfg.annotations.EntityBinder bindTable
INFO: Bind entity icescrum2.dao.model.impl.Problem on table icescrum2_Problem
27-ene-2010 11:24:00 org.hibernate.cfg.AnnotationBinder bindClass
INFO: Binding entity from annotated class: icescrum2.dao.model.impl.Release
27-ene-2010 11:24:00 org.hibernate.cfg.annotations.EntityBinder bindTable
INFO: Bind entity icescrum2.dao.model.impl.Release on table icescrum2_Release
27-ene-2010 11:24:00 org.hibernate.cfg.AnnotationBinder bindClass
INFO: Binding entity from annotated class: icescrum2.dao.model.impl.RemainingEstimationArray
27-ene-2010 11:24:00 org.hibernate.cfg.annotations.EntityBinder bindTable
INFO: Bind entity icescrum2.dao.model.impl.RemainingEstimationArray on table icescrum2_RemainingEstimation
27-ene-2010 11:24:00 org.hibernate.cfg.AnnotationBinder bindClass
INFO: Binding entity from annotated class: icescrum2.dao.model.impl.Role
27-ene-2010 11:24:00 org.hibernate.cfg.annotations.EntityBinder bindTable
INFO: Bind entity icescrum2.dao.model.impl.Role on table icescrum2_Roles
27-ene-2010 11:24:00 org.hibernate.cfg.AnnotationBinder bindClass
INFO: Binding entity from annotated class: icescrum2.dao.model.impl.CustomRole
27-ene-2010 11:24:00 org.hibernate.cfg.annotations.EntityBinder bindTable
INFO: Bind entity icescrum2.dao.model.impl.CustomRole on table icescrum2_CustomRoles
27-ene-2010 11:24:00 org.hibernate.cfg.AnnotationBinder bindClass
INFO: Binding entity from annotated class: icescrum2.dao.model.impl.Sprint
27-ene-2010 11:24:00 org.hibernate.cfg.annotations.EntityBinder bindTable
INFO: Bind entity icescrum2.dao.model.impl.Sprint on table icescrum2_Sprint
27-ene-2010 11:24:00 org.hibernate.cfg.AnnotationBinder bindClass
INFO: Binding entity from annotated class: icescrum2.dao.model.impl.Task
27-ene-2010 11:24:00 org.hibernate.cfg.annotations.EntityBinder bindTable
INFO: Bind entity icescrum2.dao.model.impl.Task on table icescrum2_Task
27-ene-2010 11:24:00 org.hibernate.cfg.AnnotationBinder bindClass
INFO: Binding entity from annotated class: icescrum2.dao.model.impl.Theme
27-ene-2010 11:24:00 org.hibernate.cfg.annotations.EntityBinder bindTable
INFO: Bind entity icescrum2.dao.model.impl.Theme on table icescrum2_Theme
27-ene-2010 11:24:00 org.hibernate.cfg.AnnotationBinder bindClass
INFO: Binding entity from annotated class: icescrum2.dao.model.impl.User
27-ene-2010 11:24:00 org.hibernate.cfg.annotations.EntityBinder bindTable
INFO: Bind entity icescrum2.dao.model.impl.User on table icescrum2_User
27-ene-2010 11:24:00 org.hibernate.cfg.AnnotationBinder bindClass
INFO: Binding entity from annotated class: icescrum2.dao.model.impl.Test
27-ene-2010 11:24:00 org.hibernate.cfg.annotations.EntityBinder bindTable
INFO: Bind entity icescrum2.dao.model.impl.Test on table icescrum2_Test
27-ene-2010 11:24:00 org.hibernate.cfg.AnnotationBinder bindClass
INFO: Binding entity from annotated class: icescrum2.dao.model.impl.Build
27-ene-2010 11:24:00 org.hibernate.cfg.annotations.EntityBinder bindTable
INFO: Bind entity icescrum2.dao.model.impl.Build on table icescrum2_Builds
27-ene-2010 11:24:00 org.hibernate.cfg.AnnotationBinder bindClass
INFO: Binding entity from annotated class: icescrum2.dao.model.impl.ExecTest
27-ene-2010 11:24:00 org.hibernate.cfg.annotations.EntityBinder bindTable
INFO: Bind entity icescrum2.dao.model.impl.ExecTest on table icescrum2_ExecTest
27-ene-2010 11:24:00 org.hibernate.cfg.AnnotationBinder bindClass
INFO: Binding entity from annotated class: icescrum2.dao.model.impl.Cliche
27-ene-2010 11:24:00 org.hibernate.cfg.annotations.EntityBinder bindTable
INFO: Bind entity icescrum2.dao.model.impl.Cliche on table icescrum2_Cliches
27-ene-2010 11:24:00 org.hibernate.cfg.annotations.CollectionBinder bindOneToManySecondPass
INFO: Mapping collection: icescrum2.dao.model.impl.Product.builds -> icescrum2_Builds
27-ene-2010 11:24:00 org.hibernate.cfg.annotations.CollectionBinder bindOneToManySecondPass
INFO: Mapping collection: icescrum2.dao.model.impl.Product.cliches -> icescrum2_Cliches
27-ene-2010 11:24:00 org.hibernate.cfg.annotations.CollectionBinder bindOneToManySecondPass
INFO: Mapping collection: icescrum2.dao.model.impl.Product.customRoles -> icescrum2_CustomRoles
27-ene-2010 11:24:00 org.hibernate.cfg.annotations.CollectionBinder bindOneToManySecondPass
INFO: Mapping collection: icescrum2.dao.model.impl.Product.problems -> icescrum2_Problem
27-ene-2010 11:24:00 org.hibernate.cfg.annotations.CollectionBinder bindOneToManySecondPass
INFO: Mapping collection: icescrum2.dao.model.impl.Product.productBacklogItems -> icescrum2_ProductBacklogItem
27-ene-2010 11:24:00 org.hibernate.cfg.annotations.CollectionBinder bindOneToManySecondPass
INFO: Mapping collection: icescrum2.dao.model.impl.Product.releases -> icescrum2_Release
27-ene-2010 11:24:00 org.hibernate.cfg.annotations.CollectionBinder bindOneToManySecondPass
INFO: Mapping collection: icescrum2.dao.model.impl.Product.roles -> icescrum2_Roles
27-ene-2010 11:24:00 org.hibernate.cfg.annotations.CollectionBinder bindOneToManySecondPass
INFO: Mapping collection: icescrum2.dao.model.impl.Product.themes -> icescrum2_Theme
27-ene-2010 11:24:00 org.hibernate.cfg.annotations.CollectionBinder bindOneToManySecondPass
INFO: Mapping collection: icescrum2.dao.model.impl.ProductBacklogItem.tasks -> icescrum2_Task
27-ene-2010 11:24:00 org.hibernate.cfg.annotations.CollectionBinder bindOneToManySecondPass
INFO: Mapping collection: icescrum2.dao.model.impl.ProductBacklogItem.tests -> icescrum2_Test
27-ene-2010 11:24:00 org.hibernate.cfg.annotations.CollectionBinder bindOneToManySecondPass
INFO: Mapping collection: icescrum2.dao.model.impl.Release.sprints -> icescrum2_Sprint
27-ene-2010 11:24:00 org.hibernate.cfg.annotations.CollectionBinder bindOneToManySecondPass
INFO: Mapping collection: icescrum2.dao.model.impl.CustomRole.pbis -> icescrum2_ProductBacklogItem
27-ene-2010 11:24:00 org.hibernate.cfg.annotations.CollectionBinder bindOneToManySecondPass
INFO: Mapping collection: icescrum2.dao.model.impl.Sprint.productBacklogItems -> icescrum2_ProductBacklogItem
27-ene-2010 11:24:00 org.hibernate.cfg.annotations.CollectionBinder bindOneToManySecondPass
INFO: Mapping collection: icescrum2.dao.model.impl.Theme.pbis -> icescrum2_ProductBacklogItem
27-ene-2010 11:24:00 org.hibernate.cfg.annotations.CollectionBinder bindOneToManySecondPass
INFO: Mapping collection: icescrum2.dao.model.impl.User.problems -> icescrum2_Problem
27-ene-2010 11:24:00 org.hibernate.cfg.annotations.CollectionBinder bindOneToManySecondPass
INFO: Mapping collection: icescrum2.dao.model.impl.User.productBacklogItems -> icescrum2_ProductBacklogItem
27-ene-2010 11:24:00 org.hibernate.cfg.annotations.CollectionBinder bindOneToManySecondPass
INFO: Mapping collection: icescrum2.dao.model.impl.User.roles -> icescrum2_Roles
27-ene-2010 11:24:00 org.hibernate.cfg.annotations.CollectionBinder bindOneToManySecondPass
INFO: Mapping collection: icescrum2.dao.model.impl.User.tasks -> icescrum2_Task
27-ene-2010 11:24:00 org.hibernate.cfg.annotations.CollectionBinder bindOneToManySecondPass
INFO: Mapping collection: icescrum2.dao.model.impl.User.tasksCreated -> icescrum2_Task
27-ene-2010 11:24:00 org.hibernate.cfg.annotations.CollectionBinder bindOneToManySecondPass
INFO: Mapping collection: icescrum2.dao.model.impl.Test.execTests -> icescrum2_ExecTest
27-ene-2010 11:24:00 org.hibernate.cfg.annotations.CollectionBinder bindOneToManySecondPass
INFO: Mapping collection: icescrum2.dao.model.impl.Build.execTests -> icescrum2_ExecTest
27-ene-2010 11:24:00 org.hibernate.validator.Version <clinit>
INFO: Hibernate Validator 3.1.0.CR2
27-ene-2010 11:24:00 org.hibernate.cfg.search.HibernateSearchEventListenerRegister enableHibernateSearch
INFO: Unable to find org.hibernate.search.event.FullTextIndexEventListener on the classpath. Hibernate Search is not enabled.
27-ene-2010 11:24:00 org.hibernate.connection.ConnectionProviderFactory newConnectionProvider
INFO: Initializing connection provider: org.springframework.orm.hibernate3.LocalDataSourceConnectionProvider
27-ene-2010 11:24:01 org.hibernate.cfg.SettingsFactory buildSettings
INFO: RDBMS: Oracle, version: Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning and Data Mining options
27-ene-2010 11:24:01 org.hibernate.cfg.SettingsFactory buildSettings
INFO: JDBC driver: Oracle JDBC driver, version: 10.2.0.4.0
27-ene-2010 11:24:01 org.hibernate.dialect.Dialect <init>
INFO: Using dialect: org.hibernate.dialect.Oracle10gDialect
27-ene-2010 11:24:01 org.hibernate.transaction.TransactionFactoryFactory buildTransactionFactory
INFO: Transaction strategy: org.springframework.orm.hibernate3.SpringTransactionFactory
27-ene-2010 11:24:01 org.hibernate.transaction.TransactionManagerLookupFactory getTransactionManagerLookup
INFO: No TransactionManagerLookup configured (in JTA environment, use of read-write or transactional second-level cache is not recommended)
27-ene-2010 11:24:01 org.hibernate.cfg.SettingsFactory buildSettings
INFO: Automatic flush during beforeCompletion(): disabled
27-ene-2010 11:24:01 org.hibernate.cfg.SettingsFactory buildSettings
INFO: Automatic session close at end of transaction: disabled
27-ene-2010 11:24:01 org.hibernate.cfg.SettingsFactory buildSettings
INFO: JDBC batch size: 15
27-ene-2010 11:24:01 org.hibernate.cfg.SettingsFactory buildSettings
INFO: JDBC batch updates for versioned data: disabled
27-ene-2010 11:24:01 org.hibernate.cfg.SettingsFactory buildSettings
INFO: Scrollable result sets: enabled
27-ene-2010 11:24:01 org.hibernate.cfg.SettingsFactory buildSettings
INFO: JDBC3 getGeneratedKeys(): disabled
27-ene-2010 11:24:01 org.hibernate.cfg.SettingsFactory buildSettings
INFO: Connection release mode: auto
27-ene-2010 11:24:01 org.hibernate.cfg.SettingsFactory buildSettings
INFO: Default batch fetch size: 1
27-ene-2010 11:24:01 org.hibernate.cfg.SettingsFactory buildSettings
INFO: Generate SQL with comments: disabled
27-ene-2010 11:24:01 org.hibernate.cfg.SettingsFactory buildSettings
INFO: Order SQL updates by primary key: disabled
27-ene-2010 11:24:01 org.hibernate.cfg.SettingsFactory buildSettings
INFO: Order SQL inserts for batching: disabled
27-ene-2010 11:24:01 org.hibernate.cfg.SettingsFactory createQueryTranslatorFactory
INFO: Query translator: org.hibernate.hql.ast.ASTQueryTranslatorFactory
27-ene-2010 11:24:01 org.hibernate.hql.ast.ASTQueryTranslatorFactory <init>
INFO: Using ASTQueryTranslatorFactory
27-ene-2010 11:24:01 org.hibernate.cfg.SettingsFactory buildSettings
INFO: Query language substitutions: {}
27-ene-2010 11:24:01 org.hibernate.cfg.SettingsFactory buildSettings
INFO: JPA-QL strict compliance: disabled
27-ene-2010 11:24:01 org.hibernate.cfg.SettingsFactory buildSettings
INFO: Second-level cache: disabled
27-ene-2010 11:24:01 org.hibernate.cfg.SettingsFactory buildSettings
INFO: Query cache: enabled
27-ene-2010 11:24:01 org.hibernate.cfg.SettingsFactory createRegionFactory
INFO: Cache region factory : org.hibernate.cache.impl.bridge.RegionFactoryCacheProviderBridge
27-ene-2010 11:24:01 org.hibernate.cache.impl.bridge.RegionFactoryCacheProviderBridge <init>
INFO: Cache provider: org.hibernate.cache.EhCacheProvider
27-ene-2010 11:24:01 org.hibernate.cfg.SettingsFactory buildSettings
INFO: Optimize cache for minimal puts: disabled
27-ene-2010 11:24:01 org.hibernate.cfg.SettingsFactory buildSettings
INFO: Structured second-level cache entries: disabled
27-ene-2010 11:24:01 org.hibernate.cfg.SettingsFactory createQueryCacheFactory
INFO: Query cache factory: org.hibernate.cache.StandardQueryCacheFactory
27-ene-2010 11:24:01 org.hibernate.cfg.SettingsFactory buildSettings
INFO: Statistics: disabled
27-ene-2010 11:24:01 org.hibernate.cfg.SettingsFactory buildSettings
INFO: Deleted entity synthetic identifier rollback: disabled
27-ene-2010 11:24:01 org.hibernate.cfg.SettingsFactory buildSettings
INFO: Default entity-mode: pojo
27-ene-2010 11:24:01 org.hibernate.cfg.SettingsFactory buildSettings
INFO: Named query checking : enabled
27-ene-2010 11:24:01 org.hibernate.impl.SessionFactoryImpl <init>
INFO: building session factory
27-ene-2010 11:24:02 org.hibernate.impl.SessionFactoryObjectFactory addInstance
INFO: Not binding factory to JNDI, no JNDI name configured
27-ene-2010 11:24:02 org.hibernate.tool.hbm2ddl.SchemaUpdate execute
INFO: Running hbm2ddl schema update
27-ene-2010 11:24:02 org.hibernate.tool.hbm2ddl.SchemaUpdate execute
INFO: fetching database metadata
27-ene-2010 11:24:02 org.hibernate.tool.hbm2ddl.SchemaUpdate execute
INFO: updating schema
27-ene-2010 11:24:02 org.hibernate.tool.hbm2ddl.DatabaseMetadata getTableMetadata
INFO: table not found: icescrum2_Builds
27-ene-2010 11:24:02 org.hibernate.tool.hbm2ddl.DatabaseMetadata getTableMetadata
INFO: table not found: icescrum2_Cliches
27-ene-2010 11:24:02 org.hibernate.tool.hbm2ddl.DatabaseMetadata getTableMetadata
INFO: table not found: icescrum2_CustomRoles
27-ene-2010 11:24:02 org.hibernate.tool.hbm2ddl.DatabaseMetadata getTableMetadata
INFO: table not found: icescrum2_ExecTest
27-ene-2010 11:24:02 org.hibernate.tool.hbm2ddl.DatabaseMetadata getTableMetadata
INFO: table not found: icescrum2_Problem
27-ene-2010 11:24:02 org.hibernate.tool.hbm2ddl.DatabaseMetadata getTableMetadata
INFO: table not found: icescrum2_Product
27-ene-2010 11:24:02 org.hibernate.tool.hbm2ddl.DatabaseMetadata getTableMetadata
INFO: table not found: icescrum2_ProductBacklogItem
27-ene-2010 11:24:02 org.hibernate.tool.hbm2ddl.DatabaseMetadata getTableMetadata
INFO: table not found: icescrum2_Release
27-ene-2010 11:24:02 org.hibernate.tool.hbm2ddl.DatabaseMetadata getTableMetadata
INFO: table not found: icescrum2_RemainingEstimation
27-ene-2010 11:24:03 org.hibernate.tool.hbm2ddl.DatabaseMetadata getTableMetadata
INFO: table not found: icescrum2_Roles
27-ene-2010 11:24:03 org.hibernate.tool.hbm2ddl.DatabaseMetadata getTableMetadata
INFO: table not found: icescrum2_Sprint
27-ene-2010 11:24:03 org.hibernate.tool.hbm2ddl.DatabaseMetadata getTableMetadata
INFO: table not found: icescrum2_Task
27-ene-2010 11:24:03 org.hibernate.tool.hbm2ddl.DatabaseMetadata getTableMetadata
INFO: table not found: icescrum2_Test
27-ene-2010 11:24:03 org.hibernate.tool.hbm2ddl.DatabaseMetadata getTableMetadata
INFO: table not found: icescrum2_Theme
27-ene-2010 11:24:03 org.hibernate.tool.hbm2ddl.DatabaseMetadata getTableMetadata
INFO: table not found: icescrum2_User
27-ene-2010 11:24:03 org.hibernate.tool.hbm2ddl.DatabaseMetadata getTableMetadata
INFO: table not found: icescrum2_Builds
27-ene-2010 11:24:03 org.hibernate.tool.hbm2ddl.DatabaseMetadata getTableMetadata
INFO: table not found: icescrum2_Cliches
27-ene-2010 11:24:03 org.hibernate.tool.hbm2ddl.DatabaseMetadata getTableMetadata
INFO: table not found: icescrum2_CustomRoles
27-ene-2010 11:24:03 org.hibernate.tool.hbm2ddl.DatabaseMetadata getTableMetadata
INFO: table not found: icescrum2_ExecTest
27-ene-2010 11:24:03 org.hibernate.tool.hbm2ddl.DatabaseMetadata getTableMetadata
INFO: table not found: icescrum2_Problem
27-ene-2010 11:24:03 org.hibernate.tool.hbm2ddl.DatabaseMetadata getTableMetadata
INFO: table not found: icescrum2_Product
27-ene-2010 11:24:03 org.hibernate.tool.hbm2ddl.DatabaseMetadata getTableMetadata
INFO: table not found: icescrum2_ProductBacklogItem
27-ene-2010 11:24:03 org.hibernate.tool.hbm2ddl.DatabaseMetadata getTableMetadata
INFO: table not found: icescrum2_Release
27-ene-2010 11:24:03 org.hibernate.tool.hbm2ddl.DatabaseMetadata getTableMetadata
INFO: table not found: icescrum2_RemainingEstimation
27-ene-2010 11:24:03 org.hibernate.tool.hbm2ddl.DatabaseMetadata getTableMetadata
INFO: table not found: icescrum2_Roles
27-ene-2010 11:24:03 org.hibernate.tool.hbm2ddl.DatabaseMetadata getTableMetadata
INFO: table not found: icescrum2_Sprint
27-ene-2010 11:24:03 org.hibernate.tool.hbm2ddl.DatabaseMetadata getTableMetadata
INFO: table not found: icescrum2_Task
27-ene-2010 11:24:03 org.hibernate.tool.hbm2ddl.DatabaseMetadata getTableMetadata
INFO: table not found: icescrum2_Test
27-ene-2010 11:24:03 org.hibernate.tool.hbm2ddl.DatabaseMetadata getTableMetadata
INFO: table not found: icescrum2_Theme
27-ene-2010 11:24:03 org.hibernate.tool.hbm2ddl.DatabaseMetadata getTableMetadata
INFO: table not found: icescrum2_User
27-ene-2010 11:24:03 org.hibernate.tool.hbm2ddl.DatabaseMetadata getTableMetadata
INFO: table not found: hibernate_sequence
27-ene-2010 11:24:03 org.hibernate.tool.hbm2ddl.SchemaUpdate execute
GRAVE: Unsuccessful: create table icescrum2_Builds (idBuild number(10,0) not null, date timestamp, description varchar2(3000 char), name varchar2(255 char), nbTotalTest number(10,0), state number(10,0), is2product_fk varchar2(255 char), primary key (idBuild))
27-ene-2010 11:24:03 org.hibernate.tool.hbm2ddl.SchemaUpdate execute
GRAVE: ORA-00904: : invalid identifier

27-ene-2010 11:24:03 org.hibernate.tool.hbm2ddl.SchemaUpdate execute
GRAVE: Unsuccessful: create table icescrum2_Cliches (idCliche number(10,0) not null, datePrise timestamp, defectBacklogPoints number(10,0), defectEstimatedVelocity number(10,0), defectProductRemainingPoints number(10,0), defectReleaseRemainingPoints number(10,0), estimatedStories number(10,0), finishedStories number(10,0), fonctionalStoryBacklogPoints number(10,0), fonctionalStoryEstimatedVelocity number(10,0), fonctionalStoryProductRemainingPoints number(10,0), fonctionalStoryReleaseRemainingPoints number(10,0), identifiedStories number(10,0), lockedStories number(10,0), plannedStories number(10,0), problems number(10,0), source varchar2(255 char), technicalStoryBacklogPoints number(10,0), technicalStoryEstimatedVelocity number(10,0), technicalStoryProductRemainingPoints number(10,0), technicalStoryReleaseRemainingPoints number(10,0), validatedStories number(10,0), writtenTests number(10,0), is2product_fk varchar2(255 char), primary key (idCliche))
27-ene-2010 11:24:03 org.hibernate.tool.hbm2ddl.SchemaUpdate execute
GRAVE: ORA-00972: identifier is too long

27-ene-2010 11:24:03 org.hibernate.tool.hbm2ddl.SchemaUpdate execute
GRAVE: Unsuccessful: create table icescrum2_ExecTest (idExecTest number(10,0) not null, date timestamp, state number(10,0), is2build_fk number(10,0), is2test_fk number(10,0), primary key (idExecTest))
27-ene-2010 11:24:03 org.hibernate.tool.hbm2ddl.SchemaUpdate execute
GRAVE: ORA-00904: : invalid identifier

27-ene-2010 11:24:03 org.hibernate.tool.hbm2ddl.SchemaUpdate execute
GRAVE: Unsuccessful: create table icescrum2_Product (idProduct varchar2(255 char) not null, activateMailNotify number(1,0), activateTaskFollowingPolicy number(1,0), description varchar2(1000 char), disableProductJoin number(1,0), enableAutoCloseStory number(1,0), enableResetTest number(1,0), enableSwitchRole number(1,0), nbDefectOnFirstSprintActivated number(10,0), nbTechnicalOnFirstSprintActivated number(10,0), nbUSOnFirstSprintActivated number(10,0), planningPokerGameType number(10,0) not null, productName varchar2(255 char) not null, startDate date, primary key (idProduct))
27-ene-2010 11:24:03 org.hibernate.tool.hbm2ddl.SchemaUpdate execute
GRAVE: ORA-00972: identifier is too long

27-ene-2010 11:24:04 org.hibernate.tool.hbm2ddl.SchemaUpdate execute
GRAVE: Unsuccessful: alter table icescrum2_Builds add constraint FKF6F5C821EC71B0AA foreign key (is2product_fk) references icescrum2_Product
27-ene-2010 11:24:04 org.hibernate.tool.hbm2ddl.SchemaUpdate execute
GRAVE: ORA-00942: table or view does not exist

27-ene-2010 11:24:04 org.hibernate.tool.hbm2ddl.SchemaUpdate execute
GRAVE: Unsuccessful: alter table icescrum2_Cliches add constraint FKD49D017EC71B0AA foreign key (is2product_fk) references icescrum2_Product
27-ene-2010 11:24:04 org.hibernate.tool.hbm2ddl.SchemaUpdate execute
GRAVE: ORA-00942: table or view does not exist

27-ene-2010 11:24:04 org.hibernate.tool.hbm2ddl.SchemaUpdate execute
GRAVE: Unsuccessful: alter table icescrum2_CustomRoles add constraint FK7AB0AAF0EC71B0AA foreign key (is2product_fk) references icescrum2_Product
27-ene-2010 11:24:04 org.hibernate.tool.hbm2ddl.SchemaUpdate execute
GRAVE: ORA-00942: table or view does not exist

27-ene-2010 11:24:04 org.hibernate.tool.hbm2ddl.SchemaUpdate execute
GRAVE: Unsuccessful: alter table icescrum2_ExecTest add constraint FKDFA0DA1F34E2FDCA foreign key (is2build_fk) references icescrum2_Builds
27-ene-2010 11:24:04 org.hibernate.tool.hbm2ddl.SchemaUpdate execute
GRAVE: ORA-00942: table or view does not exist

27-ene-2010 11:24:04 org.hibernate.tool.hbm2ddl.SchemaUpdate execute
GRAVE: Unsuccessful: alter table icescrum2_ExecTest add constraint FKDFA0DA1F3C17083E foreign key (is2test_fk) references icescrum2_Test
27-ene-2010 11:24:04 org.hibernate.tool.hbm2ddl.SchemaUpdate execute
GRAVE: ORA-00942: table or view does not exist

27-ene-2010 11:24:04 org.hibernate.tool.hbm2ddl.SchemaUpdate execute
GRAVE: Unsuccessful: alter table icescrum2_Problem add constraint FKC78C0DC3EC71B0AA foreign key (is2product_fk) references icescrum2_Product
27-ene-2010 11:24:04 org.hibernate.tool.hbm2ddl.SchemaUpdate execute
GRAVE: ORA-00942: table or view does not exist

27-ene-2010 11:24:04 org.hibernate.tool.hbm2ddl.SchemaUpdate execute
GRAVE: Unsuccessful: alter table icescrum2_ProductBacklogItem add constraint FKF0BB1F9DEC71B0AA foreign key (is2product_fk) references icescrum2_Product
27-ene-2010 11:24:04 org.hibernate.tool.hbm2ddl.SchemaUpdate execute
GRAVE: ORA-00942: table or view does not exist

27-ene-2010 11:24:04 org.hibernate.tool.hbm2ddl.SchemaUpdate execute
GRAVE: Unsuccessful: alter table icescrum2_Release add constraint FK1B00732BEC71B0AA foreign key (is2product_fk) references icescrum2_Product
27-ene-2010 11:24:04 org.hibernate.tool.hbm2ddl.SchemaUpdate execute
GRAVE: ORA-00942: table or view does not exist

27-ene-2010 11:24:04 org.hibernate.tool.hbm2ddl.SchemaUpdate execute
GRAVE: Unsuccessful: alter table icescrum2_Roles add constraint FK195A52E1EC71B0AA foreign key (is2product_fk) references icescrum2_Product
27-ene-2010 11:24:04 org.hibernate.tool.hbm2ddl.SchemaUpdate execute
GRAVE: ORA-00942: table or view does not exist

27-ene-2010 11:24:04 org.hibernate.tool.hbm2ddl.SchemaUpdate execute
GRAVE: Unsuccessful: alter table icescrum2_Theme add constraint FK197339EDEC71B0AA foreign key (is2product_fk) references icescrum2_Product
27-ene-2010 11:24:04 org.hibernate.tool.hbm2ddl.SchemaUpdate execute
GRAVE: ORA-00942: table or view does not exist

27-ene-2010 11:24:04 org.hibernate.tool.hbm2ddl.SchemaUpdate execute
INFO: schema update complete
27-ene-2010 11:24:04 org.hibernate.cache.UpdateTimestampsCache <init>
INFO: starting update timestamps cache at region: org.hibernate.cache.UpdateTimestampsCache
27-ene-2010 11:24:04 org.hibernate.cache.EhCacheProvider buildCache
ADVERTENCIA: Could not find configuration [org.hibernate.cache.UpdateTimestampsCache]; using defaults.
27-ene-2010 11:24:04 org.hibernate.cache.StandardQueryCache <init>
INFO: starting query cache at region: org.hibernate.cache.StandardQueryCache
27-ene-2010 11:24:04 org.hibernate.cache.EhCacheProvider buildCache
ADVERTENCIA: Could not find configuration [org.hibernate.cache.StandardQueryCache]; using defaults.
27-ene-2010 11:24:06 org.apache.cxf.endpoint.ServerImpl initDestination
INFO: Setting the server's publish address to be /
27-ene-2010 11:24:06 org.apache.cxf.transport.servlet.CXFServlet updateContext
INFO: Load the bus with application context
27-ene-2010 11:24:07 org.apache.cxf.bus.spring.BusApplicationContext getConfigResources
INFO: No cxf.xml configuration file detected, relying on defaults.
27-ene-2010 11:24:07 org.apache.cxf.transport.servlet.AbstractCXFServlet replaceDestinationFactory
INFO: Servlet transport factory already registered
27-ene-2010 11:24:07 org.apache.coyote.http11.Http11Protocol start
INFO: Arrancando Coyote HTTP/1.1 en puerto http-8080
27-ene-2010 11:24:07 org.apache.jk.common.ChannelSocket init
INFO: JK: ajp13 listening on /0.0.0.0:8009
27-ene-2010 11:24:07 org.apache.jk.server.JkMain start
INFO: Jk running ID=0 time=0/15 config=null
27-ene-2010 11:24:07 org.apache.catalina.startup.Catalina start
INFO: Server startup in 17011 ms

[Manu]

Hi individuodk,

Thanks for pointing this error.
You can try using Icescrum with its embedded database for now, we'll take this issue in account for future release.

Regards,

[Tweedeldee]

Hi,

first of all, thanks for the great work you are providing on IceScrum

Is there any news on this issue ?
I didn't saw any mention of it in either the "known bugs" nor the "fixed bugs" section of the release. =/

Thanks for your feedbacks

[Manu]

Hi Tweedeldee,
No, sorry, this issue hasn't been fixed yet.
I've added it in the known issues section of the release note for now.

Regards,

[Tweedeldee]

Hi,

Thanks for the quick reply, it prevented me from losing some time while trying it out.

Regards,