4 Replies Latest reply on Jul 28, 2010 8:53 AM by AnkitY

    HCA Schema Update on MSSQL Server

    adam.brenneis

      Hi all,

      I'm working on deploying the HCA SA into a JBOSS/MSSQLServer environment.  It was going smoothly until I got to the schema-update script for the SNC building block.  It throws out quite a few 'severe' messages; first concerning an unknown 'blob' data type, then cascading to errors about missing tables.  I looked closely at one and it makes sense that the Attachment bean would require a blob column.

      I'm not all that familiar with hibernate and SQLServer, but it seems there may be something wrong with the dialect being used?

        • 1. Re: HCA Schema Update on MSSQL Server
          AnkitY Level 2

          Hi Adam,

           

          Can you please attach the logs so that we can analyse the issue.

           

          Thanks

          Ankit

          • 2. Re: HCA Schema Update on MSSQL Server
            adam.brenneis Level 1

            I can't seem to figure out how to attach things here, so I'll try to paste in some of the output below.  If there was a particular log file that you were looking for, just let me know.

             

            *********************************

            Starting installer

            ANT_HOME set to: C:\dev\human_capital_applications_2_0\sa\building_blocks\snc_2_0\install\..\..\..\tools\t hirdparty\ant_tp\apache-ant-1.7.1

            ANT_OPTS set to: -Xmx512m

            JAVA_HOME set to: C:\Program Files\Java\jdk1.6.0_20

            CLASSPATH set to: .;

            *********************************

            Buildfile: build.xml

                 [echo] Basedir is C:\dev\human_capital_applications_2_0\sa\building_blocks\snc_2_0\install. Import dir is C:\dev\human_capital_applications_2_0\sa\building_blocks\snc_2_0\install

                 [echo] hostname is: VMLCES2C

                 [echo] Basedir is C:\dev\human_capital_applications_2_0\sa\building_blocks\snc_2_0\install. Import dir is C:\dev\human_capital_applications_2_0\sa\install

                 [echo] hostname is: VMLCES2C

                 [echo] C:/Adobe/Adobe LiveCycle ES2/LiveCycle_ES_SDK and its dependencies validated

                 [echo] CMN is at: C:\dev\human_capital_applications_2_0\sa\building_blocks\snc_2_0\install/../../../buildin g_blocks/cmn_2_0/dist

                 [echo] SA Tools Found: C:\dev\human_capital_applications_2_0\sa\tools

                 [echo] Junit is at : C:\dev\human_capital_applications_2_0\sa\tools/thirdparty/junit_tp/junit-4.5/junit-4.5.ja r


            call-deployer:

                 [echo] Basedir is C:\dev\human_capital_applications_2_0\sa\building_blocks\snc_2_0\deployer. Import dir is C:\dev\human_capital_applications_2_0\sa\building_blocks\snc_2_0\install

                 [echo] hostname is: VMLCES2C

                 [echo] Basedir is C:\dev\human_capital_applications_2_0\sa\building_blocks\snc_2_0\deployer. Import dir is C:\dev\human_capital_applications_2_0\sa\install

                 [echo] hostname is: VMLCES2C

                 [echo] C:/Adobe/Adobe LiveCycle ES2/LiveCycle_ES_SDK and its dependencies validated

                 [echo] CMN is at: C:\dev\human_capital_applications_2_0\sa\building_blocks\snc_2_0\install/../../../buildin g_blocks/cmn_2_0/dist

                 [echo] SA Tools Found: C:\dev\human_capital_applications_2_0\sa\tools

                 [echo] Junit is at : C:\dev\human_capital_applications_2_0\sa\tools/thirdparty/junit_tp/junit-4.5/junit-4.5.ja r


            schema-update:

                 [java] Jul 27, 2010 9:51:03 AM org.hibernate.cfg.Environment <clinit>

                 [java] INFO: Hibernate 3.2.6

                 [java] Jul 27, 2010 9:51:03 AM org.hibernate.cfg.Environment <clinit>

                 [java] INFO: loaded properties from resource hibernate.properties: {hibernate.bytecode.use_reflection_optimizer=false, hibernate.bytecode.provider=javassist}

                 [java] Jul 27, 2010 9:51:03 AM org.hibernate.cfg.Environment buildBytecodeProvider

                 [java] INFO: Bytecode provider name : javassist

                 [java] Jul 27, 2010 9:51:03 AM org.hibernate.cfg.Environment <clinit>

                 [java] INFO: using JDK 1.4 java.sql.Timestamp handling

                 [java] Jul 27, 2010 9:51:03 AM org.hibernate.cfg.Configuration configure

                 [java] INFO: configuring from file: hibernate-test.cfg.xml

                 [java] Jul 27, 2010 9:51:03 AM org.hibernate.cfg.Configuration addResource

                 [java] INFO: Reading mappings from resource : StaticContent.hbm.xml

                 [java] Jul 27, 2010 9:51:03 AM org.hibernate.cfg.HbmBinder bindRootPersistentClassCommonValues

                 [java] INFO: Mapping class: com.adobe.solutions.snc.transfer.StaticContentTO -> bb_snc_static_content

                 [java] Jul 27, 2010 9:51:03 AM org.hibernate.cfg.HbmBinder bindCollection

                 [java] INFO: Mapping collection: com.adobe.solutions.snc.transfer.StaticContentTO.data -> bb_snc_static_content_to_data

                 [java] Jul 27, 2010 9:51:03 AM org.hibernate.cfg.Configuration addResource

                 [java] INFO: Reading mappings from resource : Attachment.hbm.xml

                 [java] Jul 27, 2010 9:51:03 AM org.hibernate.cfg.HbmBinder bindRootPersistentClassCommonValues

                 [java] INFO: Mapping class: com.adobe.solutions.snc.transfer.AttachmentTO -> bb_snc_attachment

                 [java] Jul 27, 2010 9:51:03 AM org.hibernate.cfg.Configuration addResource

                 [java] INFO: Reading mappings from resource : Selector.hbm.xml

                 [java] Jul 27, 2010 9:51:03 AM org.hibernate.cfg.HbmBinder bindRootPersistentClassCommonValues

                 [java] INFO: Mapping class: com.adobe.solutions.snc.transfer.SelectorTO -> bb_snc_selector

                 [java] Jul 27, 2010 9:51:03 AM org.hibernate.cfg.HbmBinder bindCollection

                 [java] INFO: Mapping collection: com.adobe.solutions.snc.transfer.SelectorTO.dependencyList -> bb_snc_selector_dependency

                 [java] Jul 27, 2010 9:51:03 AM org.hibernate.cfg.Configuration addResource

                 [java] INFO: Reading mappings from resource : SelectorOptions.hbm.xml

                 [java] Jul 27, 2010 9:51:03 AM org.hibernate.cfg.HbmBinder bindRootPersistentClassCommonValues

                 [java] INFO: Mapping class: com.adobe.solutions.snc.transfer.SelectorOptionsTO -> bb_snc_selector_options

                 [java] Jul 27, 2010 9:51:03 AM org.hibernate.cfg.Configuration addResource

                 [java] INFO: Reading mappings from resource : SelectorGroup.hbm.xml

                 [java] Jul 27, 2010 9:51:03 AM org.hibernate.cfg.HbmBinder bindRootPersistentClassCommonValues

                 [java] INFO: Mapping class: com.adobe.solutions.snc.transfer.SelectorGroupTO -> bb_snc_selector_group

                 [java] Jul 27, 2010 9:51:03 AM org.hibernate.cfg.HbmBinder bindCollection

                 [java] INFO: Mapping collection: com.adobe.solutions.snc.transfer.SelectorGroupTO.selectors -> bb_snc_sg_to_si

                 [java] Jul 27, 2010 9:51:03 AM org.hibernate.cfg.HbmBinder bindCollection

                 [java] INFO: Mapping collection: com.adobe.solutions.snc.transfer.SelectorGroupTO.dependencyList -> bb_snc_sg_dependency

                 [java] Jul 27, 2010 9:51:03 AM org.hibernate.cfg.Configuration addResource

                 [java] INFO: Reading mappings from resource : EligibilityExpression.hbm.xml

                 [java] Jul 27, 2010 9:51:04 AM org.hibernate.cfg.HbmBinder bindRootPersistentClassCommonValues

                 [java] INFO: Mapping class: com.adobe.solutions.snc.transfer.EligibilityExpressionTO -> bb_snc_eligibility_expression

                 [java] Jul 27, 2010 9:51:04 AM org.hibernate.cfg.Configuration addResource

                 [java] INFO: Reading mappings from resource : Provider.hbm.xml

                 [java] Jul 27, 2010 9:51:04 AM org.hibernate.cfg.HbmBinder bindRootPersistentClassCommonValues

                 [java] INFO: Mapping class: com.adobe.solutions.snc.transfer.ProviderTO -> bb_snc_provider

                 [java] Jul 27, 2010 9:51:04 AM org.hibernate.cfg.Configuration addResource

                 [java] INFO: Reading mappings from resource : Form.hbm.xml

                 [java] Jul 27, 2010 9:51:04 AM org.hibernate.cfg.HbmBinder bindRootPersistentClassCommonValues

                 [java] INFO: Mapping class: com.adobe.solutions.snc.transfer.FormTO -> bb_snc_form

                 [java] Jul 27, 2010 9:51:04 AM org.hibernate.cfg.Configuration addResource

                 [java] INFO: Reading mappings from resource : Variable.hbm.xml

                 [java] Jul 27, 2010 9:51:04 AM org.hibernate.cfg.HbmBinder bindRootPersistentClassCommonValues

                 [java] INFO: Mapping class: com.adobe.solutions.snc.transfer.VariableTO -> bb_snc_variable

                 [java] Jul 27, 2010 9:51:04 AM org.hibernate.cfg.Configuration addResource

                 [java] INFO: Reading mappings from resource : User.hbm.xml

                 [java] Jul 27, 2010 9:51:04 AM org.hibernate.cfg.HbmBinder bindRootPersistentClassCommonValues

                 [java] INFO: Mapping class: com.adobe.solutions.snc.transfer.UserTO -> bb_snc_user

                 [java] Jul 27, 2010 9:51:04 AM org.hibernate.cfg.Configuration addResource

                 [java] INFO: Reading mappings from resource : Product.hbm.xml

                 [java] Jul 27, 2010 9:51:04 AM org.hibernate.cfg.HbmBinder bindRootPersistentClassCommonValues

                 [java] INFO: Mapping class: com.adobe.solutions.snc.transfer.ProductTO -> bb_snc_product

                 [java] Jul 27, 2010 9:51:04 AM org.hibernate.cfg.HbmBinder bindCollection

                 [java] INFO: Mapping collection: com.adobe.solutions.snc.transfer.ProductTO.contentSet -> bb_snc_product_to_content

                 [java] Jul 27, 2010 9:51:04 AM org.hibernate.cfg.Configuration addResource

                 [java] INFO: Reading mappings from resource : ProcessMapping.hbm.xml

                 [java] Jul 27, 2010 9:51:04 AM org.hibernate.cfg.HbmBinder bindRootPersistentClassCommonValues

                 [java] INFO: Mapping class: com.adobe.solutions.snc.transfer.ProcessMappingTO -> bb_snc_process_mapping

                 [java] Jul 27, 2010 9:51:04 AM org.hibernate.cfg.Configuration addResource

                 [java] INFO: Reading mappings from resource : ContentChain.hbm.xml

                 [java] Jul 27, 2010 9:51:04 AM org.hibernate.cfg.HbmBinder bindRootPersistentClassCommonValues

                 [java] INFO: Mapping class: com.adobe.solutions.snc.transfer.ContentChainTO -> bb_snc_content_chain

                 [java] Jul 27, 2010 9:51:04 AM org.hibernate.cfg.HbmBinder bindCollection

                 [java] INFO: Mapping collection: com.adobe.solutions.snc.transfer.ContentChainTO.contentList -> bb_snc_cc_to_content

                 [java] Jul 27, 2010 9:51:04 AM org.hibernate.cfg.Configuration addResource

                 [java] INFO: Reading mappings from resource : ProductForm.hbm.xml

                 [java] Jul 27, 2010 9:51:04 AM org.hibernate.cfg.HbmBinder bindRootPersistentClassCommonValues

                 [java] INFO: Mapping class: com.adobe.solutions.snc.transfer.ProductFormTO -> bb_snc_product_form

                 [java] Jul 27, 2010 9:51:04 AM org.hibernate.cfg.Configuration addResource

                 [java] INFO: Reading mappings from resource : LocalizedString.hbm.xml

                 [java] Jul 27, 2010 9:51:04 AM org.hibernate.cfg.HbmBinder bindRootPersistentClassCommonValues

                 [java] INFO: Mapping class: com.adobe.solutions.snc.transfer.LocalizedStringTO -> bb_snc_localized_string

                 [java] Jul 27, 2010 9:51:04 AM org.hibernate.cfg.Configuration addResource

                 [java] INFO: Reading mappings from resource : ConfigurationSetting.hbm.xml

                 [java] Jul 27, 2010 9:51:04 AM org.hibernate.cfg.HbmBinder bindRootPersistentClassCommonValues

                 [java] INFO: Mapping class: com.adobe.solutions.snc.transfer.ConfigurationSettingTO -> bb_snc_configuration_setting

                 [java] Jul 27, 2010 9:51:05 AM org.hibernate.cfg.Configuration addResource

                 [java] INFO: Reading mappings from resource : CaseData.hbm.xml

                 [java] Jul 27, 2010 9:51:05 AM org.hibernate.cfg.HbmBinder bindRootPersistentClassCommonValues

                 [java] INFO: Mapping class: com.adobe.solutions.snc.transfer.CaseDataTO -> bb_snc_case_data

                 [java] Jul 27, 2010 9:51:05 AM org.hibernate.cfg.Configuration addResource

                 [java] INFO: Reading mappings from resource : CaseStatus.hbm.xml

                 [java] Jul 27, 2010 9:51:05 AM org.hibernate.cfg.HbmBinder bindRootPersistentClassCommonValues

                 [java] INFO: Mapping class: com.adobe.solutions.snc.transfer.CaseStatusTO -> bb_snc_case_status

                 [java] Jul 27, 2010 9:51:05 AM org.hibernate.cfg.Configuration addResource

                 [java] INFO: Reading mappings from resource : FormChain.hbm.xml

                 [java] Jul 27, 2010 9:51:05 AM org.hibernate.cfg.HbmBinder bindRootPersistentClassCommonValues

                 [java] INFO: Mapping class: com.adobe.solutions.snc.transfer.FormChainTO -> bb_snc_form_chain

                 [java] Jul 27, 2010 9:51:05 AM org.hibernate.cfg.HbmBinder bindCollection

                 [java] INFO: Mapping collection: com.adobe.solutions.snc.transfer.FormChainTO.productFormList -> bb_snc_fc_to_pf

                 [java] Jul 27, 2010 9:51:05 AM org.hibernate.cfg.Configuration addResource

                 [java] INFO: Reading mappings from resource : Panel.hbm.xml

                 [java] Jul 27, 2010 9:51:05 AM org.hibernate.cfg.HbmBinder bindRootPersistentClassCommonValues

                 [java] INFO: Mapping class: com.adobe.solutions.snc.transfer.PanelTO -> bb_snc_panel

                 [java] Jul 27, 2010 9:51:05 AM org.hibernate.cfg.Configuration addResource

                 [java] INFO: Reading mappings from resource : Tag.hbm.xml

                 [java] Jul 27, 2010 9:51:05 AM org.hibernate.cfg.HbmBinder bindRootPersistentClassCommonValues

                 [java] INFO: Mapping class: com.adobe.solutions.snc.transfer.TagTO -> bb_snc_tag

                 [java] Jul 27, 2010 9:51:05 AM org.hibernate.cfg.Configuration addResource

                 [java] INFO: Reading mappings from resource : TagMap.hbm.xml

                 [java] Jul 27, 2010 9:51:05 AM org.hibernate.cfg.HbmBinder bindRootPersistentClassCommonValues

                 [java] INFO: Mapping class: com.adobe.solutions.snc.transfer.TagMapTO -> bb_snc_tag_map

                 [java] Jul 27, 2010 9:51:05 AM org.hibernate.cfg.Configuration addResource

                 [java] INFO: Reading mappings from resource : Wizard.hbm.xml

                 [java] Jul 27, 2010 9:51:05 AM org.hibernate.cfg.HbmBinder bindRootPersistentClassCommonValues

                 [java] INFO: Mapping class: com.adobe.solutions.snc.transfer.WizardTO -> bb_snc_wizard

                 [java] Jul 27, 2010 9:51:05 AM org.hibernate.cfg.Configuration doConfigure

                 [java] INFO: Configured SessionFactory: null

                 [java] Using connection properties from the command line

                 [java] Jul 27, 2010 9:51:06 AM org.hibernate.dialect.Dialect <init>

                 [java] INFO: Using dialect: org.hibernate.dialect.SQLServerDialect

                 [java] Jul 27, 2010 9:51:06 AM com.adobe.solutions.dao.hibernate.HibernateUtil identifyDialect

                 [java] INFO: Using dialect [org.hibernate.dialect.SQLServerDialect] - Detected DB Product name - Microsoft SQL Server and version 10

                 [java] Jul 27, 2010 9:51:06 AM org.hibernate.cfg.HbmBinder bindCollectionSecondPass

                 [java] INFO: Mapping collection: com.adobe.solutions.snc.transfer.SelectorTO.optionsList -> bb_snc_selector_options

                 [java] Jul 27, 2010 9:51:06 AM org.hibernate.cfg.HbmBinder bindCollectionSecondPass

                 [java] INFO: Mapping collection: com.adobe.solutions.snc.transfer.ProviderTO.productList -> bb_snc_product

                 [java] Jul 27, 2010 9:51:06 AM org.hibernate.cfg.HbmBinder bindCollectionSecondPass

                 [java] INFO: Mapping collection: com.adobe.solutions.snc.transfer.CaseDataTO.servicesStatusList -> bb_snc_case_status

                 [java] Jul 27, 2010 9:51:06 AM org.hibernate.cfg.HbmBinder bindCollectionSecondPass

                 [java] INFO: Mapping collection: com.adobe.solutions.snc.transfer.WizardTO.settings -> bb_snc_configuration_setting

                 [java] Jul 27, 2010 9:51:06 AM org.hibernate.cfg.HbmBinder bindCollectionSecondPass

                 [java] INFO: Mapping collection: com.adobe.solutions.snc.transfer.WizardTO.panels -> bb_snc_panel

                 [java] Jul 27, 2010 9:51:06 AM org.hibernate.cfg.HbmBinder bindCollectionSecondPass

                 [java] INFO: Mapping collection: com.adobe.solutions.snc.transfer.WizardTO.providers -> bb_snc_provider

                 [java] Jul 27, 2010 9:51:06 AM org.hibernate.connection.DriverManagerConnectionProvider configure

                 [java] INFO: Using Hibernate built-in connection pool (not for production use!)

                 [java] Jul 27, 2010 9:51:06 AM org.hibernate.connection.DriverManagerConnectionProvider configure

                 [java] INFO: Hibernate connection pool size: 20

                 [java] Jul 27, 2010 9:51:06 AM org.hibernate.connection.DriverManagerConnectionProvider configure

                 [java] INFO: autocommit mode: false

                 [java] Jul 27, 2010 9:51:06 AM org.hibernate.connection.DriverManagerConnectionProvider configure

                 [java] INFO: using driver: com.microsoft.sqlserver.jdbc.SQLServerDriver at URL: jdbc:sqlserver://vmlces2c-db:1433;DatabaseName=lces2db

                 [java] Jul 27, 2010 9:51:06 AM org.hibernate.connection.DriverManagerConnectionProvider configure

                 [java] INFO: connection properties: {user=lces2, password=****}

                 [java] Jul 27, 2010 9:51:06 AM org.hibernate.cfg.SettingsFactory buildSettings

                 [java] INFO: RDBMS: Microsoft SQL Server, version: 10.50.1600

                 [java] Jul 27, 2010 9:51:06 AM org.hibernate.cfg.SettingsFactory buildSettings

                 [java] INFO: JDBC driver: Microsoft SQL Server 2005 JDBC Driver, version: 1.2.2828.100

                 [java] Jul 27, 2010 9:51:06 AM org.hibernate.dialect.Dialect <init>

                 [java] INFO: Using dialect: org.hibernate.dialect.SQLServerDialect

                 [java] Jul 27, 2010 9:51:06 AM org.hibernate.transaction.TransactionFactoryFactory buildTransactionFactory

                 [java] INFO: Using default transaction strategy (direct JDBC transactions)

                 [java] Jul 27, 2010 9:51:06 AM org.hibernate.transaction.TransactionManagerLookupFactory getTransactionManagerLookup

                 [java] INFO: No TransactionManagerLookup configured (in JTA environment, use of read-write or transactional second-level cache is not recommended)

                 [java] Jul 27, 2010 9:51:06 AM org.hibernate.cfg.SettingsFactory buildSettings

                 [java] INFO: Automatic flush during beforeCompletion(): disabled

                 [java] Jul 27, 2010 9:51:06 AM org.hibernate.cfg.SettingsFactory buildSettings

                 [java] INFO: Automatic session close at end of transaction: disabled

                 [java] Jul 27, 2010 9:51:06 AM org.hibernate.cfg.SettingsFactory buildSettings

                 [java] INFO: Scrollable result sets: enabled

                 [java] Jul 27, 2010 9:51:06 AM org.hibernate.cfg.SettingsFactory buildSettings

                 [java] INFO: JDBC3 getGeneratedKeys(): enabled

                 [java] Jul 27, 2010 9:51:06 AM org.hibernate.cfg.SettingsFactory buildSettings

                 [java] INFO: Connection release mode: auto

                 [java] Jul 27, 2010 9:51:06 AM org.hibernate.cfg.SettingsFactory buildSettings

                 [java] INFO: Maximum outer join fetch depth: 0

                 [java] Jul 27, 2010 9:51:06 AM org.hibernate.cfg.SettingsFactory buildSettings

                 [java] INFO: Default batch fetch size: 1

                 [java] Jul 27, 2010 9:51:06 AM org.hibernate.cfg.SettingsFactory buildSettings

                 [java] INFO: Generate SQL with comments: disabled

                 [java] Jul 27, 2010 9:51:06 AM org.hibernate.cfg.SettingsFactory buildSettings

                 [java] INFO: Order SQL updates by primary key: disabled

                 [java] Jul 27, 2010 9:51:06 AM org.hibernate.cfg.SettingsFactory buildSettings

                 [java] INFO: Order SQL inserts for batching: disabled

                 [java] Jul 27, 2010 9:51:06 AM org.hibernate.cfg.SettingsFactory createQueryTranslatorFactory

                 [java] INFO: Query translator: org.hibernate.hql.ast.ASTQueryTranslatorFactory

                 [java] Jul 27, 2010 9:51:06 AM org.hibernate.hql.ast.ASTQueryTranslatorFactory <init>

                 [java] INFO: Using ASTQueryTranslatorFactory

                 [java] Jul 27, 2010 9:51:06 AM org.hibernate.cfg.SettingsFactory buildSettings

                 [java] INFO: Query language substitutions: {}

                 [java] Jul 27, 2010 9:51:06 AM org.hibernate.cfg.SettingsFactory buildSettings

                 [java] INFO: JPA-QL strict compliance: disabled

                 [java] Jul 27, 2010 9:51:06 AM org.hibernate.cfg.SettingsFactory buildSettings

                 [java] INFO: Second-level cache: disabled

                 [java] Jul 27, 2010 9:51:06 AM org.hibernate.cfg.SettingsFactory buildSettings

                 [java] INFO: Query cache: disabled

                 [java] Jul 27, 2010 9:51:06 AM org.hibernate.cfg.SettingsFactory buildSettings

                 [java] INFO: Optimize cache for minimal puts: disabled

                 [java] Jul 27, 2010 9:51:06 AM org.hibernate.cfg.SettingsFactory buildSettings

                 [java] INFO: Structured second-level cache entries: disabled

                 [java] Jul 27, 2010 9:51:06 AM org.hibernate.cfg.SettingsFactory buildSettings

                 [java] INFO: Echoing all SQL to stdout

                 [java] Jul 27, 2010 9:51:06 AM org.hibernate.cfg.SettingsFactory buildSettings

                 [java] INFO: Statistics: disabled

                 [java] Jul 27, 2010 9:51:06 AM org.hibernate.cfg.SettingsFactory buildSettings

                 [java] INFO: Deleted entity synthetic identifier rollback: disabled

                 [java] Jul 27, 2010 9:51:06 AM org.hibernate.cfg.SettingsFactory buildSettings

                 [java] INFO: Default entity-mode: pojo

                 [java] Jul 27, 2010 9:51:06 AM org.hibernate.cfg.SettingsFactory buildSettings

                 [java] INFO: Named query checking : enabled

                 [java] Jul 27, 2010 9:51:06 AM org.hibernate.impl.SessionFactoryImpl <init>

                 [java] INFO: building session factory

                 [java] Jul 27, 2010 9:51:07 AM org.hibernate.impl.SessionFactoryObjectFactory addInstance

                 [java] INFO: Not binding factory to JNDI, no JNDI name configured

                 [java] Jul 27, 2010 9:51:07 AM org.hibernate.tool.hbm2ddl.SchemaUpdate execute

                 [java] INFO: Running hbm2ddl schema update

                 [java] Jul 27, 2010 9:51:07 AM org.hibernate.tool.hbm2ddl.SchemaUpdate execute

                 [java] INFO: fetching database metadata

                 [java] Jul 27, 2010 9:51:07 AM org.hibernate.tool.hbm2ddl.SchemaUpdate execute

                 [java] INFO: updating schema

                 [java] Jul 27, 2010 9:51:07 AM org.hibernate.tool.hbm2ddl.DatabaseMetadata getTableMetadata

                 [java] INFO: table not found: bb_snc_attachment

                 [java] Jul 27, 2010 9:51:07 AM org.hibernate.tool.hbm2ddl.DatabaseMetadata getTableMetadata

                 [java] INFO: table not found: bb_snc_case_data

                 [java] Jul 27, 2010 9:51:07 AM org.hibernate.tool.hbm2ddl.DatabaseMetadata getTableMetadata

                 [java] INFO: table not found: bb_snc_case_status

                 [java] Jul 27, 2010 9:51:07 AM org.hibernate.tool.hbm2ddl.TableMetadata <init>

                 [java] INFO: table found: lces2db.lces2.bb_snc_cc_to_content

                 [java] Jul 27, 2010 9:51:07 AM org.hibernate.tool.hbm2ddl.TableMetadata <init>

                 [java] INFO: columns: [position, contentchainid, contentid, contentclass]

                 [java] Jul 27, 2010 9:51:07 AM org.hibernate.tool.hbm2ddl.TableMetadata <init>

                 [java] INFO: foreign keys: [fk4aeb6b1efe2bd1c3]

                 [java] Jul 27, 2010 9:51:07 AM org.hibernate.tool.hbm2ddl.TableMetadata <init>

                 [java] INFO: indexes: [pk__bb_snc_c__250f895618d6a699]

                 [java] Jul 27, 2010 9:51:07 AM org.hibernate.tool.hbm2ddl.TableMetadata <init>

                 [java] INFO: table found: lces2db.lces2.bb_snc_configuration_setting

                 [java] Jul 27, 2010 9:51:07 AM org.hibernate.tool.hbm2ddl.TableMetadata <init>

                 [java] INFO: columns: [id, name, value, wizardid]

                 [java] Jul 27, 2010 9:51:07 AM org.hibernate.tool.hbm2ddl.TableMetadata <init>

                 [java] INFO: foreign keys: [fk2710693160f7f129]

                 [java] Jul 27, 2010 9:51:07 AM org.hibernate.tool.hbm2ddl.TableMetadata <init>

                 [java] INFO: indexes: [pk__bb_snc_c__3213e83f1ca7377d]

                 [java] Jul 27, 2010 9:51:07 AM org.hibernate.tool.hbm2ddl.TableMetadata <init>

                 [java] INFO: table found: lces2db.lces2.bb_snc_content_chain

                 [java] Jul 27, 2010 9:51:07 AM org.hibernate.tool.hbm2ddl.TableMetadata <init>

                 [java] INFO: columns: [product, id, reasonfordenial, navigationtype, description, name, eligibilityexpression, wizardid, processmappings]

                 [java] Jul 27, 2010 9:51:07 AM org.hibernate.tool.hbm2ddl.TableMetadata <init>

                 [java] INFO: foreign keys: [fk1386cea560f7f129, fk1386cea59b24fffc, fk1386cea5d1e9562b]

                 [java] Jul 27, 2010 9:51:07 AM org.hibernate.tool.hbm2ddl.TableMetadata <init>

                 [java] INFO: indexes: [pk__bb_snc_c__3213e83f2077c861]

                 [java] Jul 27, 2010 9:51:07 AM org.hibernate.tool.hbm2ddl.TableMetadata <init>

                 [java] INFO: table found: lces2db.lces2.bb_snc_eligibility_expression

                 [java] Jul 27, 2010 9:51:07 AM org.hibernate.tool.hbm2ddl.TableMetadata <init>

                 [java] INFO: columns: [silent, expression, id, operationname, ordinality, name, servicename, expressiontype, wizardid]

                 [java] Jul 27, 2010 9:51:07 AM org.hibernate.tool.hbm2ddl.TableMetadata <init>

                 [java] INFO: foreign keys: [fk26b4caa060f7f129]

                 [java] Jul 27, 2010 9:51:07 AM org.hibernate.tool.hbm2ddl.TableMetadata <init>

                 [java] INFO: indexes: [pk__bb_snc_e__3213e83f24485945, uq__bb_snc_e__1c9b706b2724c5f0]

                 [java] Jul 27, 2010 9:51:07 AM org.hibernate.tool.hbm2ddl.TableMetadata <init>

                 [java] INFO: table found: lces2db.lces2.bb_snc_fc_to_pf

                 [java] Jul 27, 2010 9:51:07 AM org.hibernate.tool.hbm2ddl.TableMetadata <init>

                 [java] INFO: columns: [position, productformid, formchainid]

                 [java] Jul 27, 2010 9:51:07 AM org.hibernate.tool.hbm2ddl.TableMetadata <init>

                 [java] INFO: foreign keys: [fkcdd70ace21e7887f, fkcdd70aceb96c3093]

                 [java] Jul 27, 2010 9:51:07 AM org.hibernate.tool.hbm2ddl.TableMetadata <init>

                 [java] INFO: indexes: [pk__bb_snc_f__191b2b042af556d4]

                 [java] Jul 27, 2010 9:51:07 AM org.hibernate.tool.hbm2ddl.TableMetadata <init>

                 [java] INFO: table found: lces2db.lces2.bb_snc_form

                 [java] Jul 27, 2010 9:51:07 AM org.hibernate.tool.hbm2ddl.TableMetadata <init>

                 [java] INFO: columns: [inputformname, status, delimitedactionmappings, updatetimestamp, applicationwebroot, inputdata, id, contentrooturi, statuschangetimestamp, creationtimestamp, description, name, onstatuschangeservice, wizardid]

                 [java] Jul 27, 2010 9:51:07 AM org.hibernate.tool.hbm2ddl.TableMetadata <init>

                 [java] INFO: foreign keys: [fk9c7e165a60f7f129]

                 [java] Jul 27, 2010 9:51:07 AM org.hibernate.tool.hbm2ddl.TableMetadata <init>

                 [java] INFO: indexes: [pk__bb_snc_f__3213e83f2ec5e7b8]

                 [java] Jul 27, 2010 9:51:07 AM org.hibernate.tool.hbm2ddl.TableMetadata <init>

                 [java] INFO: table found: lces2db.lces2.bb_snc_form_chain

                 [java] Jul 27, 2010 9:51:07 AM org.hibernate.tool.hbm2ddl.TableMetadata <init>

                 [java] INFO: columns: [product, id, reasonfordenial, navigationtype, description, rendertype, name, eligibilityexpression, wizardid, processmappings]

                 [java] Jul 27, 2010 9:51:07 AM org.hibernate.tool.hbm2ddl.TableMetadata <init>

                 [java] INFO: foreign keys: [fkcfc6a49cd1e9562b, fkcfc6a49c9b24fffc, fkcfc6a49c60f7f129]

                 [java] Jul 27, 2010 9:51:07 AM org.hibernate.tool.hbm2ddl.TableMetadata <init>

                 [java] INFO: indexes: [pk__bb_snc_f__3213e83f3296789c]

                 [java] Jul 27, 2010 9:51:07 AM org.hibernate.tool.hbm2ddl.TableMetadata <init>

                 [java] INFO: table found: lces2db.lces2.bb_snc_localized_string

                 [java] Jul 27, 2010 9:51:07 AM org.hibernate.tool.hbm2ddl.TableMetadata <init>

                 [java] INFO: columns: [localizedvalue, id, localizationkey, language, wizardid, country]

                 [java] Jul 27, 2010 9:51:07 AM org.hibernate.tool.hbm2ddl.TableMetadata <init>

                 [java] INFO: foreign keys: [fk65f21eb60f7f129]

                 [java] Jul 27, 2010 9:51:07 AM org.hibernate.tool.hbm2ddl.TableMetadata <init>

                 [java] INFO: indexes: [pk__bb_snc_l__3213e83f36670980]

                 [java] Jul 27, 2010 9:51:07 AM org.hibernate.tool.hbm2ddl.TableMetadata <init>

                 [java] INFO: table found: lces2db.lces2.bb_snc_panel

                 [java] Jul 27, 2010 9:51:07 AM org.hibernate.tool.hbm2ddl.TableMetadata <init>

                 [java] INFO: columns: [tags, heading1, hint, isvisible, id, isenabled, description, sequence, name, customrenderer, eligibilityexpression, heading2, heading3, wizardid]

                 [java] Jul 27, 2010 9:51:07 AM org.hibernate.tool.hbm2ddl.TableMetadata <init>

                 [java] INFO: foreign keys: [fkf3cb332e60f7f129]

                 [java] Jul 27, 2010 9:51:07 AM org.hibernate.tool.hbm2ddl.TableMetadata <init>

                 [java] INFO: indexes: [pk__bb_snc_p__3213e83f3a379a64]

                 [java] Jul 27, 2010 9:51:07 AM org.hibernate.tool.hbm2ddl.TableMetadata <init>

                 [java] INFO: table found: lces2db.lces2.bb_snc_process_mapping

                 [java] Jul 27, 2010 9:51:07 AM org.hibernate.tool.hbm2ddl.TableMetadata <init>

                 [java] INFO: columns: [postrender, id, onstart, caseapplicationasxml, submit, oncomplete, prerender, postsubmit, presubmit, render]

                 [java] Jul 27, 2010 9:51:07 AM org.hibernate.tool.hbm2ddl.TableMetadata <init>

                 [java] INFO: foreign keys: []

                 [java] Jul 27, 2010 9:51:07 AM org.hibernate.tool.hbm2ddl.TableMetadata <init>

                 [java] INFO: indexes: [pk__bb_snc_p__3213e83f3e082b48]

                 [java] Jul 27, 2010 9:51:07 AM org.hibernate.tool.hbm2ddl.TableMetadata <init>

                 [java] INFO: table found: lces2db.lces2.bb_snc_product

                 [java] Jul 27, 2010 9:51:07 AM org.hibernate.tool.hbm2ddl.TableMetadata <init>

                 [java] INFO: columns: [id, providerid, statuschangetimestamp, creationtimestamp, status, updatetimestamp, description, sequence, name, onstatuschangeservice, eligibilityexpression]

                 [java] Jul 27, 2010 9:51:07 AM org.hibernate.tool.hbm2ddl.TableMetadata <init>

                 [java] INFO: foreign keys: []

                 [java] Jul 27, 2010 9:51:07 AM org.hibernate.tool.hbm2ddl.TableMetadata <init>

                 [java] INFO: indexes: [pk__bb_snc_p__3213e83f41d8bc2c]

                 [java] Jul 27, 2010 9:51:07 AM org.hibernate.tool.hbm2ddl.TableMetadata <init>

                 [java] INFO: table found: lces2db.lces2.bb_snc_product_form

                 [java] Jul 27, 2010 9:51:07 AM org.hibernate.tool.hbm2ddl.TableMetadata <init>

                 [java] INFO: columns: [isrequiressignatures, disableclientsidecache, formid, id, reasonfordenial, productid, description, hidden, name, ismandatory, renderformat, eligibilityexpression, wizardid, processmappings]

                 [java] Jul 27, 2010 9:51:07 AM org.hibernate.tool.hbm2ddl.TableMetadata <init>

                 [java] INFO: foreign keys: [fkf2c0c9aad8d4869b, fkf2c0c9aa6ee58d57, fkf2c0c9aad1e9562b, fkf2c0c9aa60f7f129]

                 [java] Jul 27, 2010 9:51:07 AM org.hibernate.tool.hbm2ddl.TableMetadata <init>

                 [java] INFO: indexes: [pk__bb_snc_p__3213e83f45a94d10]

                 [java] Jul 27, 2010 9:51:07 AM org.hibernate.tool.hbm2ddl.TableMetadata <init>

                 [java] INFO: table found: lces2db.lces2.bb_snc_product_to_content

                 [java] Jul 27, 2010 9:51:07 AM org.hibernate.tool.hbm2ddl.TableMetadata <init>

                 [java] INFO: columns: [contentid, productid, contentclass]

                 [java] Jul 27, 2010 9:51:07 AM org.hibernate.tool.hbm2ddl.TableMetadata <init>

                 [java] INFO: foreign keys: [fk2127371b6ee58d57]

                 [java] Jul 27, 2010 9:51:07 AM org.hibernate.tool.hbm2ddl.TableMetadata <init>

                 [java] INFO: indexes: []

                 [java] Jul 27, 2010 9:51:07 AM org.hibernate.tool.hbm2ddl.DatabaseMetadata getTableMetadata

                 [java] INFO: table not found: bb_snc_provider

                 [java] Jul 27, 2010 9:51:07 AM org.hibernate.tool.hbm2ddl.TableMetadata <init>

                 [java] INFO: table found: lces2db.lces2.bb_snc_selector

                 [java] Jul 27, 2010 9:51:07 AM org.hibernate.tool.hbm2ddl.TableMetadata <init>

                 [java] INFO: columns: [minvalue, text, variableid, maxvalue, validationpattern, isvisible, isenabled, id, displaypattern, immediateevaluation, description, uitype, ismandatory, renderer, wizardid, tooltip]

                 [java] Jul 27, 2010 9:51:07 AM org.hibernate.tool.hbm2ddl.TableMetadata <init>

                 [java] INFO: foreign keys: [fk936942756c06ef8b, fk9369427560f7f129]

                 [java] Jul 27, 2010 9:51:07 AM org.hibernate.tool.hbm2ddl.TableMetadata <init>

                 [java] INFO: indexes: [pk__bb_snc_s__3213e83f4a6e022d]

                 [java] Jul 27, 2010 9:51:07 AM org.hibernate.tool.hbm2ddl.TableMetadata <init>

                 [java] INFO: table found: lces2db.lces2.bb_snc_selector_dependency

                 [java] Jul 27, 2010 9:51:07 AM org.hibernate.tool.hbm2ddl.TableMetadata <init>

                 [java] INFO: columns: [position, selectorid, dependencyid]

                 [java] Jul 27, 2010 9:51:07 AM org.hibernate.tool.hbm2ddl.TableMetadata <init>

                 [java] INFO: foreign keys: [fkf1173b5558324d3d, fkf1173b55d78398d1]

                 [java] Jul 27, 2010 9:51:07 AM org.hibernate.tool.hbm2ddl.TableMetadata <init>

                 [java] INFO: indexes: [pk__bb_snc_s__c282f3714e3e9311]

                 [java] Jul 27, 2010 9:51:07 AM org.hibernate.tool.hbm2ddl.TableMetadata <init>

                 [java] INFO: table found: lces2db.lces2.bb_snc_selector_group

                 [java] Jul 27, 2010 9:51:07 AM org.hibernate.tool.hbm2ddl.TableMetadata <init>

                 [java] INFO: columns: [isenabled, id, isprofile, description, name, hint, eligibilityexpression, isvisible, renderer, wizardid]

                 [java] Jul 27, 2010 9:51:07 AM org.hibernate.tool.hbm2ddl.TableMetadata <init>

                 [java] INFO: foreign keys: [fkd126303560f7f129]

                 [java] Jul 27, 2010 9:51:07 AM org.hibernate.tool.hbm2ddl.TableMetadata <init>

                 [java] INFO: indexes: [pk__bb_snc_s__3213e83f520f23f5]

                 [java] Jul 27, 2010 9:51:07 AM org.hibernate.tool.hbm2ddl.TableMetadata <init>

                 [java] INFO: table found: lces2db.lces2.bb_snc_selector_options

                 [java] Jul 27, 2010 9:51:07 AM org.hibernate.tool.hbm2ddl.TableMetadata <init>

                 [java] INFO: columns: [position, id, selectorid, optiondisplaytext, description, optionvalue]

                 [java] Jul 27, 2010 9:51:07 AM org.hibernate.tool.hbm2ddl.TableMetadata <init>

                 [java] INFO: foreign keys: [fkc4642ad4d78398d1]

                 [java] Jul 27, 2010 9:51:07 AM org.hibernate.tool.hbm2ddl.TableMetadata <init>

                 [java] INFO: indexes: [pk__bb_snc_s__3213e83f55dfb4d9]

                 [java] Jul 27, 2010 9:51:07 AM org.hibernate.tool.hbm2ddl.TableMetadata <init>

                 [java] INFO: table found: lces2db.lces2.bb_snc_sg_dependency

                 [java] Jul 27, 2010 9:51:07 AM org.hibernate.tool.hbm2ddl.TableMetadata <init>

                 [java] INFO: columns: [position, dependencyid, selectorgroupid]

                 [java] Jul 27, 2010 9:51:07 AM org.hibernate.tool.hbm2ddl.TableMetadata <init>

                 [java] INFO: foreign keys: [fk9016fd4058324d3d, fk9016fd406e666099]

                 [java] Jul 27, 2010 9:51:07 AM org.hibernate.tool.hbm2ddl.TableMetadata <init>

                 [java] INFO: indexes: [pk__bb_snc_s__b7fa935859b045bd]

                 [java] Jul 27, 2010 9:51:07 AM org.hibernate.tool.hbm2ddl.TableMetadata <init>

                 [java] INFO: table found: lces2db.lces2.bb_snc_sg_to_si

                 [java] Jul 27, 2010 9:51:07 AM org.hibernate.tool.hbm2ddl.TableMetadata <init>

                 [java] INFO: columns: [position, selectorid, selectorgroupid, selectorclass]

                 [java] Jul 27, 2010 9:51:07 AM org.hibernate.tool.hbm2ddl.TableMetadata <init>

                 [java] INFO: foreign keys: [fke7df3f856e666099]

                 [java] Jul 27, 2010 9:51:07 AM org.hibernate.tool.hbm2ddl.TableMetadata <init>

                 [java] INFO: indexes: [pk__bb_snc_s__b7fa93585d80d6a1]

                 [java] Jul 27, 2010 9:51:07 AM org.hibernate.tool.hbm2ddl.TableMetadata <init>

                 [java] INFO: table found: lces2db.lces2.bb_snc_static_content

                 [java] Jul 27, 2010 9:51:07 AM org.hibernate.tool.hbm2ddl.TableMetadata <init>

                 [java] INFO: columns: [attachmentid, delimitedactionmappings, contenttype, uri, id, product, title, category, mimetype, reasonfordenial, hidden, description, name, eligibilityexpression, wizardid, processmappings]

                 [java] Jul 27, 2010 9:51:07 AM org.hibernate.tool.hbm2ddl.TableMetadata <init>

                 [java] INFO: foreign keys: [fk94e5e1bed1e9562b, fk94e5e1be60f7f129, fk94e5e1be9b24fffc]

                 [java] Jul 27, 2010 9:51:07 AM org.hibernate.tool.hbm2ddl.TableMetadata <init>

                 [java] INFO: indexes: [pk__bb_snc_s__3213e83f61516785]

                 [java] Jul 27, 2010 9:51:07 AM org.hibernate.tool.hbm2ddl.TableMetadata <init>

                 [java] INFO: table found: lces2db.lces2.bb_snc_static_content_to_data

                 [java] Jul 27, 2010 9:51:07 AM org.hibernate.tool.hbm2ddl.TableMetadata <init>

                 [java] INFO: columns: [staticcontentid, dataid, dataclass]

                 [java] Jul 27, 2010 9:51:07 AM org.hibernate.tool.hbm2ddl.TableMetadata <init>

                 [java] INFO: foreign keys: [fk57f5596d7fbccbaf]

                 [java] Jul 27, 2010 9:51:07 AM org.hibernate.tool.hbm2ddl.TableMetadata <init>

                 [java] INFO: indexes: []

                 [java] Jul 27, 2010 9:51:07 AM org.hibernate.tool.hbm2ddl.TableMetadata <init>

                 [java] INFO: table found: lces2db.lces2.bb_snc_tag

                 [java] Jul 27, 2010 9:51:07 AM org.hibernate.tool.hbm2ddl.TableMetadata <init>

                 [java] INFO: columns: [id, description, name, wizardid]

                 [java] Jul 27, 2010 9:51:07 AM org.hibernate.tool.hbm2ddl.TableMetadata <init>

                 [java] INFO: foreign keys: [fk57a12b4460f7f129]

                 [java] Jul 27, 2010 9:51:07 AM org.hibernate.tool.hbm2ddl.TableMetadata <init>

                 [java] INFO: indexes: [pk__bb_snc_t__3213e83f66161ca2, uq__bb_snc_t__1c9b706b68f2894d]

                 [java] Jul 27, 2010 9:51:07 AM org.hibernate.tool.hbm2ddl.TableMetadata <init>

                 [java] INFO: table found: lces2db.lces2.bb_snc_tag_map

                 [java] Jul 27, 2010 9:51:07 AM org.hibernate.tool.hbm2ddl.TableMetadata <init>

                 [java] INFO: columns: [id, tagid, dataid, dataclass]

                 [java] Jul 27, 2010 9:51:07 AM org.hibernate.tool.hbm2ddl.TableMetadata <init>

                 [java] INFO: foreign keys: [fkfebde14a8c9ead]

                 [java] Jul 27, 2010 9:51:07 AM org.hibernate.tool.hbm2ddl.TableMetadata <init>

                 [java] INFO: indexes: [pk__bb_snc_t__3213e83f6cc31a31, uq__bb_snc_t__589c62a46f9f86dc]

                 [java] Jul 27, 2010 9:51:07 AM org.hibernate.tool.hbm2ddl.DatabaseMetadata getTableMetadata

                 [java] INFO: table not found: bb_snc_user

                 [java] Jul 27, 2010 9:51:07 AM org.hibernate.tool.hbm2ddl.TableMetadata <init>

                 [java] INFO: table found: lces2db.lces2.bb_snc_variable

                 [java] Jul 27, 2010 9:51:07 AM org.hibernate.tool.hbm2ddl.TableMetadata <init>

                 [java] INFO: columns: [variabletype, id, name, xpathbinding, defaultvalue, wizardid]

                 [java] Jul 27, 2010 9:51:07 AM org.hibernate.tool.hbm2ddl.TableMetadata <init>

                 [java] INFO: foreign keys: [fk1e8211260f7f129]

                 [java] Jul 27, 2010 9:51:07 AM org.hibernate.tool.hbm2ddl.TableMetadata <init>

                 [java] INFO: indexes: [uq__bb_snc_v__1c9b706b764c846b, pk__bb_snc_v__3213e83f737017c0]

                 [java] Jul 27, 2010 9:51:07 AM org.hibernate.tool.hbm2ddl.TableMetadata <init>

                 [java] INFO: table found: lces2db.lces2.bb_snc_wizard

                 [java] Jul 27, 2010 9:51:07 AM org.hibernate.tool.hbm2ddl.TableMetadata <init>

                 [java] INFO: columns: [id, description, name, hint]

                 [java] Jul 27, 2010 9:51:07 AM org.hibernate.tool.hbm2ddl.TableMetadata <init>

                 [java] INFO: foreign keys: []

                 [java] Jul 27, 2010 9:51:07 AM org.hibernate.tool.hbm2ddl.TableMetadata <init>

                 [java] INFO: indexes: [pk__bb_snc_w__3213e83f7a1d154f, uq__bb_snc_w__72e12f1b7cf981fa]

                 [java] Jul 27, 2010 9:51:07 AM org.hibernate.tool.hbm2ddl.DatabaseMetadata getTableMetadata

                 [java] INFO: table not found: bb_snc_attachment

                 [java] Jul 27, 2010 9:51:07 AM org.hibernate.tool.hbm2ddl.DatabaseMetadata getTableMetadata

                 [java] INFO: table not found: bb_snc_case_data

                 [java] Jul 27, 2010 9:51:07 AM org.hibernate.tool.hbm2ddl.DatabaseMetadata getTableMetadata

                 [java] INFO: table not found: bb_snc_case_status

                 [java] Jul 27, 2010 9:51:07 AM org.hibernate.tool.hbm2ddl.DatabaseMetadata getTableMetadata

                 [java] INFO: table not found: bb_snc_provider

                 [java] Jul 27, 2010 9:51:07 AM org.hibernate.tool.hbm2ddl.DatabaseMetadata getTableMetadata

                 [java] INFO: table not found: bb_snc_user

                 [java] Jul 27, 2010 9:51:07 AM org.hibernate.tool.hbm2ddl.SchemaUpdate execute

                 [java] SEVERE: Unsuccessful: create table bb_snc_attachment (id varchar(255) not null, fileName varchar(255) null, mimeType varchar(255) null, uri varchar(255) null, data_size int null, attachment_data blob null, storeType varchar(255) null, primary key (id))

                 [java] Jul 27, 2010 9:51:07 AM org.hibernate.tool.hbm2ddl.SchemaUpdate execute

                 [java] SEVERE: Column, parameter, or variable #6: Cannot find data type blob.

                 [java] Jul 27, 2010 9:51:07 AM org.hibernate.tool.hbm2ddl.SchemaUpdate execute

                 [java] SEVERE: Unsuccessful: create table bb_snc_case_data (id varchar(255) not null, referenceId varchar(255) null, umUserOid varchar(255) null, actionDate datetime null, verificationSelectorIds varchar(4096) null, verificationData blob null, primary key (id))

                 [java] Jul 27, 2010 9:51:07 AM org.hibernate.tool.hbm2ddl.SchemaUpdate execute

                 [java] SEVERE: Column, parameter, or variable #6: Cannot find data type blob.

                 [java] Jul 27, 2010 9:51:07 AM org.hibernate.tool.hbm2ddl.SchemaUpdate execute

                 [java] SEVERE: Unsuccessful: create table bb_snc_case_status (id varchar(255) not null, contentClass varchar(255) null, contentId varchar(255) null, caseId varchar(255) null, supportedActions varchar(255) null, status varchar(255) null, message varchar(4096) null, document blob null, caseDataId varchar(255) null, actionDate datetime null, sentTo varchar(255) null, deliveryMethod varchar(255) null, sentData blob null, sequence int null, primary key (id))

                 [java] Jul 27, 2010 9:51:07 AM org.hibernate.tool.hbm2ddl.SchemaUpdate execute

                 [java] SEVERE: Column, parameter, or variable #8: Cannot find data type blob.

                 [java] Jul 27, 2010 9:51:07 AM org.hibernate.tool.hbm2ddl.SchemaUpdate execute

                 [java] SEVERE: Unsuccessful: create table bb_snc_provider (id varchar(255) not null, name varchar(255) not null, description varchar(255) null, street varchar(255) null, city varchar(255) null, zipcode varchar(255) null, country varchar(255) null, managerName varchar(255) null, telephoneNumber varchar(255) null, emailAlias varchar(255) null, creationTimeStamp datetime null, lastUpdateTimeStamp datetime null, caseSubParams blob null, processMappings varchar(255) null, sequence int null, wizardId varchar(255) not null, primary key (id), unique (name, wizardId))

                 [java] Jul 27, 2010 9:51:07 AM org.hibernate.tool.hbm2ddl.SchemaUpdate execute

                 [java] SEVERE: Column, parameter, or variable #13: Cannot find data type blob.

                 [java] Jul 27, 2010 9:51:07 AM org.hibernate.tool.hbm2ddl.SchemaUpdate execute

                 [java] SEVERE: Unsuccessful: create table bb_snc_user (id varchar(255) not null, umOid varchar(255) not null unique, profileData blob null, primary key (id))

                 [java] Jul 27, 2010 9:51:07 AM org.hibernate.tool.hbm2ddl.SchemaUpdate execute

                 [java] SEVERE: Column, parameter, or variable #3: Cannot find data type blob.

                 [java] Jul 27, 2010 9:51:07 AM org.hibernate.tool.hbm2ddl.SchemaUpdate execute

                 [java] SEVERE: Unsuccessful: alter table bb_snc_case_status add constraint FK7F8D7D8B253D9D67 foreign key (caseDataId) references bb_snc_case_data

                 [java] Jul 27, 2010 9:51:07 AM org.hibernate.tool.hbm2ddl.SchemaUpdate execute

                 [java] SEVERE: Cannot find the object "bb_snc_case_status" because it does not exist or you do not have permissions.

                 [java] Jul 27, 2010 9:51:07 AM org.hibernate.tool.hbm2ddl.SchemaUpdate execute

                 [java] SEVERE: Unsuccessful: alter table bb_snc_product add constraint FK4ADB5399B54743F5 foreign key (providerId) references bb_snc_provider

                 [java] Jul 27, 2010 9:51:07 AM org.hibernate.tool.hbm2ddl.SchemaUpdate execute

                 [java] SEVERE: Foreign key 'FK4ADB5399B54743F5' references invalid table 'bb_snc_provider'.

                 [java] Jul 27, 2010 9:51:07 AM org.hibernate.tool.hbm2ddl.SchemaUpdate execute

                 [java] SEVERE: Unsuccessful: alter table bb_snc_provider add constraint FK1187548760F7F129 foreign key (wizardId) references bb_snc_wizard

                 [java] Jul 27, 2010 9:51:07 AM org.hibernate.tool.hbm2ddl.SchemaUpdate execute

                 [java] SEVERE: Cannot find the object "bb_snc_provider" because it does not exist or you do not have permissions.

                 [java] Jul 27, 2010 9:51:07 AM org.hibernate.tool.hbm2ddl.SchemaUpdate execute

                 [java] SEVERE: Unsuccessful: alter table bb_snc_provider add constraint FK11875487D1E9562B foreign key (processMappings) references bb_snc_process_mapping

                 [java] Jul 27, 2010 9:51:07 AM org.hibernate.tool.hbm2ddl.SchemaUpdate execute

                 [java] SEVERE: Cannot find the object "bb_snc_provider" because it does not exist or you do not have permissions.

                 [java] Jul 27, 2010 9:51:07 AM org.hibernate.tool.hbm2ddl.SchemaUpdate execute

                 [java] SEVERE: Unsuccessful: alter table bb_snc_static_content add constraint FK94E5E1BE77D9619 foreign key (attachmentId) references bb_snc_attachment

                 [java] Jul 27, 2010 9:51:07 AM org.hibernate.tool.hbm2ddl.SchemaUpdate execute

                 [java] SEVERE: Foreign key 'FK94E5E1BE77D9619' references invalid table 'bb_snc_attachment'.

                 [java] Jul 27, 2010 9:51:07 AM org.hibernate.tool.hbm2ddl.SchemaUpdate execute

                 [java] INFO: schema update complete

                 [java] Jul 27, 2010 9:51:07 AM org.hibernate.impl.SessionFactoryImpl close

                 [java] INFO: closing

                 [java] Jul 27, 2010 9:51:07 AM org.hibernate.connection.DriverManagerConnectionProvider close

                 [java] INFO: cleaning up connection pool: jdbc:sqlserver://vmlces2c-db:1433;DatabaseName=lces2db


            BUILD SUCCESSFUL

            Total time: 6 seconds

            • 3. Re: HCA Schema Update on MSSQL Server
              adam.brenneis Level 1

              I figured these settings from the SA's ant.properties file might also be pertinent:

               

              database.driver.jar=C:/jboss/server/lc_sqlserver/lib/sqljdbc.jar

              database.driver.class=com.microsoft.sqlserver.jdbc.SQLServerDriver

              database.connection.url=jdbc:sqlserver://vmlces2c-db:1433;DatabaseName=lces2db

              • 4. Re: HCA Schema Update on MSSQL Server
                AnkitY Level 2

                Hi Adam,

                 

                There are two approaches you can try, unfortunately none is straightforward.

                1. Create the missing tables manually with blob replaced with appropriate MSSQL type.

                2. Replace "BLOB" in hbm files with appropriate type, recompile SNC and then run HCA again.

                 

                Thanks

                Ankit