Hi Team,
I am trying to use SQL Database from back-end instead of H2 database (which is default). When I put the configuration in the conf file, the connection is successfull but while running the database migration script, some errors pop up and it stops there. Basically, I want to have SQL database as a back-end for one of the nodes.
Errors as below
[INFO ] 2022-08-31T18:11:29,609Z [main] internal.Node. - Machine: DESKTOP-KG45542
[INFO ] 2022-08-31T18:11:29,609Z [main] internal.Node. - Working Directory: K:\Udemy_Corda\youtube\HDFCBank
[INFO ] 2022-08-31T18:11:29,610Z [main] internal.Node. - Starting as node on 150.129.159.65:10008
[INFO ] 2022-08-31T18:11:29,779Z [main] cordapp.JarScanningCordappLoader. - Looking for CorDapps in [K:\Udemy_Corda\youtube\HDFCBank\cordapps]
[INFO ] 2022-08-31T18:11:29,807Z [main] cordapp.JarScanningCordappLoader. - No CorDapp paths provided
[INFO ] 2022-08-31T18:11:30,675Z [main] internal.Node. - MessagingService active change to: false
[INFO ] 2022-08-31T18:11:30,923Z [main] internal.Node. - Flow external operation executor has a max of 8 threads
[INFO ] 2022-08-31T18:11:30,989Z [main] BasicInfo. - Running database schema migration scripts …
[INFO ] 2022-08-31T18:11:31,021Z [main] hikari.HikariDataSource. - HikariPool-1 - Starting…
[INFO ] 2022-08-31T18:11:33,491Z [main] hikari.HikariDataSource. - HikariPool-1 - Start completed.
[INFO ] 2022-08-31T18:11:34,565Z [main] jvm.JdbcExecutor. - select schema_name()
[INFO ] 2022-08-31T18:11:34,580Z [main] jvm.JdbcExecutor. - SELECT CASE ServerProperty(‘EngineEdition’)
WHEN 1 THEN ‘Personal’
WHEN 2 THEN ‘Standard’
WHEN 3 THEN ‘Enterprise’
WHEN 4 THEN ‘Express’
WHEN 5 THEN ‘Azure’
ELSE ‘Unknown’
END
[INFO ] 2022-08-31T18:11:36,955Z [main] jvm.JdbcExecutor. - SELECT CONVERT([sysname], DATABASEPROPERTYEX(N’ICICIBank_Database’, ‘Collation’))
[INFO ] 2022-08-31T18:11:37,040Z [main] jvm.JdbcExecutor. - SELECT CASE ServerProperty(‘EngineEdition’)
WHEN 1 THEN ‘Personal’
WHEN 2 THEN ‘Standard’
WHEN 3 THEN ‘Enterprise’
WHEN 4 THEN ‘Express’
WHEN 5 THEN ‘Azure’
ELSE ‘Unknown’
END
[INFO ] 2022-08-31T18:11:37,240Z [main] jvm.JdbcExecutor. - select schema_name()
[INFO ] 2022-08-31T18:11:37,240Z [main] jvm.JdbcExecutor. - SELECT TOP 1 MD5SUM FROM DATABASECHANGELOG WHERE MD5SUM IS NOT NULL
[INFO ] 2022-08-31T18:11:37,245Z [main] jvm.JdbcExecutor. - select schema_name()
[INFO ] 2022-08-31T18:11:37,246Z [main] jvm.JdbcExecutor. - select schema_name()
[INFO ] 2022-08-31T18:11:37,247Z [main] jvm.JdbcExecutor. - SELECT COUNT() FROM DATABASECHANGELOG
[INFO ] 2022-08-31T18:11:37,254Z [main] changelog.StandardChangeLogHistoryService. - Reading from DATABASECHANGELOG
[INFO ] 2022-08-31T18:11:37,254Z [main] jvm.JdbcExecutor. - select schema_name()
[INFO ] 2022-08-31T18:11:37,255Z [main] jvm.JdbcExecutor. - SELECT * FROM DATABASECHANGELOG ORDER BY DATEEXECUTED ASC, ORDEREXECUTED ASC
[INFO ] 2022-08-31T18:11:37,289Z [main] jvm.JdbcExecutor. - select schema_name()
[INFO ] 2022-08-31T18:11:37,289Z [main] jvm.JdbcExecutor. - SELECT COUNT() FROM DATABASECHANGELOGLOCK
[INFO ] 2022-08-31T18:11:37,295Z [main] jvm.JdbcExecutor. - select schema_name()
[INFO ] 2022-08-31T18:11:37,296Z [main] jvm.JdbcExecutor. - SELECT COUNT(*) FROM DATABASECHANGELOGLOCK
[INFO ] 2022-08-31T18:11:37,419Z [main] jvm.JdbcExecutor. - select schema_name()
[INFO ] 2022-08-31T18:11:37,420Z [main] jvm.JdbcExecutor. - SELECT LOCKED FROM DATABASECHANGELOGLOCK WHERE ID=1
[INFO ] 2022-08-31T18:11:37,423Z [main] jvm.JdbcExecutor. - select schema_name()
[INFO ] 2022-08-31T18:11:37,431Z [main] lockservice.StandardLockService. - Successfully acquired change log lock
[INFO ] 2022-08-31T18:11:37,449Z [main] migration.VaultStateMigration. - Migrating vault state data to V4 tables {changeSet=migration/vault-schema.changelog-v9.xml::update-vault-states::R3.Corda, databaseChangeLog=master.changelog.json}
[INFO ] 2022-08-31T18:11:37,473Z [main] migration.MigrationServicesForResolution. - Couldn’t find network parameters file: K:\Udemy_Corda\youtube\HDFCBank\network-parameters. This is expected if the node is starting for the first time. {changeSet=migration/vault-schema.changelog-v9.xml::update-vault-states::R3.Corda, databaseChangeLog=master.changelog.json}
[ERROR] 2022-08-31T18:11:37,524Z [main] changelog.ChangeSet. - Change Set migration/vault-schema.changelog-v9.xml::update-vault-states::R3.Corda failed. Error: Could not create Hibernate configuration: Failed to find a SessionFactoryFactory to handle jdbc:sqlserver://DESKTOP-KG45542\sqlexpress:1433;sslProtocol=TLS;jaasConfigurationName=SQLJDBCDriver;statementPoolingCacheSize=0;serverPreparedStatementDiscardThreshold=10;enablePrepareOnFirstPreparedStatementCall=false;fips=false;socketTimeout=0;authentication=NotSpecified;authenticationScheme=nativeAuthentication;xopenStates=false;sendTimeAsDatetime=true;trustStoreType=JKS;trustServerCertificate=false;TransparentNetworkIPResolution=true;serverNameAsACE=false;sendStringParametersAsUnicode=true;selectMethod=direct;responseBuffering=adaptive;queryTimeout=-1;packetSize=8000;multiSubnetFailover=false;loginTimeout=30;lockTimeout=-1;lastUpdateCount=true;encrypt=false;disableStatementPooling=true;databaseName=ICICIBank_Database;columnEncryptionSetting=Disabled;applicationName=Microsoft JDBC Driver for SQL Server;applicationIntent=readwrite; - factories present for [H2, PostgreSQL] {changeSet=migration/vault-schema.changelog-v9.xml::update-vault-states::R3.Corda, databaseChangeLog=master.changelog.json}
[INFO ] 2022-08-31T18:11:37,524Z [main] jvm.JdbcExecutor. - select schema_name()
[INFO ] 2022-08-31T18:11:37,541Z [main] lockservice.StandardLockService. - Successfully released change log lock
[ERROR] 2022-08-31T18:11:37,556Z [main] internal.NodeStartupLogging. - Failed to create the datasource: Migration failed for change set migration/vault-schema.changelog-v9.xml::update-vault-states::R3.Corda:
Reason: net.corda.nodeapi.internal.persistence.HibernateConfigException: Could not create Hibernate configuration: Failed to find a SessionFactoryFactory to handle jdbc:sqlserver://DESKTOP-KG45542\sqlexpress:1433;sslProtocol=TLS;jaasConfigurationName=SQLJDBCDriver;statementPoolingCacheSize=0;serverPreparedStatementDiscardThreshold=10;enablePrepareOnFirstPreparedStatementCall=false;fips=false;socketTimeout=0;authentication=NotSpecified;authenticationScheme=nativeAuthentication;xopenStates=false;sendTimeAsDatetime=true;trustStoreType=JKS;trustServerCertificate=false;TransparentNetworkIPResolution=true;serverNameAsACE=false;sendStringParametersAsUnicode=true;selectMethod=direct;responseBuffering=adaptive;queryTimeout=-1;packetSize=8000;multiSubnetFailover=false;loginTimeout=30;lockTimeout=-1;lastUpdateCount=true;encrypt=false;disableStatementPooling=true;databaseName=ICICIBank_Database;columnEncryptionSetting=Disabled;applicationName=Microsoft JDBC Driver for SQL Server;applicationIntent=readwrite; - factories present for [H2, PostgreSQL]. See the logs for further information and the cause. [Error Code: database-failed-startup For further information, please go to R3 Documentation - Home]
net.corda.nodeapi.internal.persistence.CouldNotCreateDataSourceException: Could not create the DataSource: Migration failed for change set migration/vault-schema.changelog-v9.xml::update-vault-states::R3.Corda:
Reason: net.corda.nodeapi.internal.persistence.HibernateConfigException: Could not create Hibernate configuration: Failed to find a SessionFactoryFactory to handle jdbc:sqlserver://DESKTOP-KG45542\sqlexpress:1433;sslProtocol=TLS;jaasConfigurationName=SQLJDBCDriver;statementPoolingCacheSize=0;serverPreparedStatementDiscardThreshold=10;enablePrepareOnFirstPreparedStatementCall=false;fips=false;socketTimeout=0;authentication=NotSpecified;authenticationScheme=nativeAuthentication;xopenStates=false;sendTimeAsDatetime=true;trustStoreType=JKS;trustServerCertificate=false;TransparentNetworkIPResolution=true;serverNameAsACE=false;sendStringParametersAsUnicode=true;selectMethod=direct;responseBuffering=adaptive;queryTimeout=-1;packetSize=8000;multiSubnetFailover=false;loginTimeout=30;lockTimeout=-1;lastUpdateCount=true;encrypt=false;disableStatementPooling=true;databaseName=ICICIBank_Database;columnEncryptionSetting=Disabled;applicationName=Microsoft JDBC Driver for SQL Server;applicationIntent=readwrite; - factories present for [H2, PostgreSQL]
at net.corda.node.internal.AbstractNodeKt.startHikariPool(AbstractNode.kt:1356) ~[corda-node-4.9.jar:?]
at net.corda.node.internal.AbstractNode.runDatabaseMigrationScripts(AbstractNode.kt:479) ~[corda-node-4.9.jar:?]
at net.corda.node.internal.Node.runDatabaseMigrationScripts(Node.kt:579) ~[corda-node-4.9.jar:?]
at net.corda.node.internal.subcommands.RunMigrationScriptsCli$runProgram$2.run(RunMigrationScriptsCli.kt:25) ~[corda-node-4.9.jar:?]
at net.corda.node.internal.NodeStartup$initialiseAndRun$5.invoke(NodeStartup.kt:230) ~[corda-node-4.9.jar:?]
at net.corda.node.internal.NodeStartup$initialiseAndRun$5.invoke(NodeStartup.kt:169) ~[corda-node-4.9.jar:?]
at net.corda.node.internal.NodeStartupLogging$DefaultImpls.attempt(NodeStartup.kt:561) ~[corda-node-4.9.jar:?]
at net.corda.node.internal.NodeStartup.attempt(NodeStartup.kt:169) ~[corda-node-4.9.jar:?]
at net.corda.node.internal.NodeStartup.initialiseAndRun(NodeStartup.kt:229) ~[corda-node-4.9.jar:?]
at net.corda.node.internal.NodeStartup.initialiseAndRun$default(NodeStartup.kt:181) ~[corda-node-4.9.jar:?]
at net.corda.node.internal.subcommands.RunMigrationScriptsCli.runProgram(RunMigrationScriptsCli.kt:23) ~[corda-node-4.9.jar:?]
at net.corda.cliutils.CliWrapperBase.call(CordaCliWrapper.kt:153) ~[corda-tools-cliutils-4.9.jar:?]
at net.corda.cliutils.CliWrapperBase.call(CordaCliWrapper.kt:116) ~[corda-tools-cliutils-4.9.jar:?]
at picocli.CommandLine.execute(CommandLine.java:1173) ~[picocli-3.9.6.jar:3.9.6]
at picocli.CommandLine.access$800(CommandLine.java:141) ~[picocli-3.9.6.jar:3.9.6]
at picocli.CommandLine$RunLast.handle(CommandLine.java:1367) ~[picocli-3.9.6.jar:3.9.6]
at picocli.CommandLine$RunLast.handle(CommandLine.java:1335) ~[picocli-3.9.6.jar:3.9.6]
at picocli.CommandLine$AbstractParseResultHandler.handleParseResult(CommandLine.java:1243) ~[picocli-3.9.6.jar:3.9.6]
at picocli.CommandLine.parseWithHandlers(CommandLine.java:1526) ~[picocli-3.9.6.jar:3.9.6]
at net.corda.cliutils.CordaCliWrapperKt.start(CordaCliWrapper.kt:89) ~[corda-tools-cliutils-4.9.jar:?]
at net.corda.node.Corda.main(Corda.kt:13) ~[corda-node-4.9.jar:?]
Caused by: net.corda.nodeapi.internal.persistence.DatabaseMigrationException: Migration failed for change set migration/vault-schema.changelog-v9.xml::update-vault-states::R3.Corda:
Reason: net.corda.nodeapi.internal.persistence.HibernateConfigException: Could not create Hibernate configuration: Failed to find a SessionFactoryFactory to handle jdbc:sqlserver://DESKTOP-KG45542\sqlexpress:1433;sslProtocol=TLS;jaasConfigurationName=SQLJDBCDriver;statementPoolingCacheSize=0;serverPreparedStatementDiscardThreshold=10;enablePrepareOnFirstPreparedStatementCall=false;fips=false;socketTimeout=0;authentication=NotSpecified;authenticationScheme=nativeAuthentication;xopenStates=false;sendTimeAsDatetime=true;trustStoreType=JKS;trustServerCertificate=false;TransparentNetworkIPResolution=true;serverNameAsACE=false;sendStringParametersAsUnicode=true;selectMethod=direct;responseBuffering=adaptive;queryTimeout=-1;packetSize=8000;multiSubnetFailover=false;loginTimeout=30;lockTimeout=-1;lastUpdateCount=true;encrypt=false;disableStatementPooling=true;databaseName=ICICIBank_Database;columnEncryptionSetting=Disabled;applicationName=Microsoft JDBC Driver for SQL Server;applicationIntent=readwrite; - factories present for [H2, PostgreSQL]
at net.corda.nodeapi.internal.persistence.SchemaMigration.runMigration(SchemaMigration.kt:69) ~[corda-node-api-4.9.jar:?]
at net.corda.node.internal.AbstractNode$runDatabaseMigrationScripts$3.invoke(AbstractNode.kt:482) ~[corda-node-4.9.jar:?]
at net.corda.node.internal.AbstractNode$runDatabaseMigrationScripts$3.invoke(AbstractNode.kt:201) ~[corda-node-4.9.jar:?]
at net.corda.node.internal.AbstractNodeKt.startHikariPool(AbstractNode.kt:1342) ~[corda-node-4.9.jar:?]
… 20 more
Caused by: liquibase.exception.MigrationFailedException: Migration failed for change set migration/vault-schema.changelog-v9.xml::update-vault-states::R3.Corda:
Reason: net.corda.nodeapi.internal.persistence.HibernateConfigException: Could not create Hibernate configuration: Failed to find a SessionFactoryFactory to handle jdbc:sqlserver://DESKTOP-KG45542\sqlexpress:1433;sslProtocol=TLS;jaasConfigurationName=SQLJDBCDriver;statementPoolingCacheSize=0;serverPreparedStatementDiscardThreshold=10;enablePrepareOnFirstPreparedStatementCall=false;fips=false;socketTimeout=0;authentication=NotSpecified;authenticationScheme=nativeAuthentication;xopenStates=false;sendTimeAsDatetime=true;trustStoreType=JKS;trustServerCertificate=false;TransparentNetworkIPResolution=true;serverNameAsACE=false;sendStringParametersAsUnicode=true;selectMethod=direct;responseBuffering=adaptive;queryTimeout=-1;packetSize=8000;multiSubnetFailover=false;loginTimeout=30;lockTimeout=-1;lastUpdateCount=true;encrypt=false;disableStatementPooling=true;databaseName=ICICIBank_Database;columnEncryptionSetting=Disabled;applicationName=Microsoft JDBC Driver for SQL Server;applicationIntent=readwrite; - factories present for [H2, PostgreSQL]
at liquibase.changelog.ChangeSet.execute(ChangeSet.java:637) ~[liquibase-core-3.6.3.jar:?]
at liquibase.changelog.visitor.UpdateVisitor.visit(UpdateVisitor.java:53) ~[liquibase-core-3.6.3.jar:?]
at liquibase.changelog.ChangeLogIterator.run(ChangeLogIterator.java:83) ~[liquibase-core-3.6.3.jar:?]
at liquibase.Liquibase.update(Liquibase.java:202) ~[liquibase-core-3.6.3.jar:?]
at liquibase.Liquibase.update(Liquibase.java:179) ~[liquibase-core-3.6.3.jar:?]
at liquibase.Liquibase.update(Liquibase.java:175) ~[liquibase-core-3.6.3.jar:?]
at liquibase.Liquibase.update(Liquibase.java:168) ~[liquibase-core-3.6.3.jar:?]
at net.corda.nodeapi.internal.persistence.SchemaMigration.runMigration(SchemaMigration.kt:67) ~[corda-node-api-4.9.jar:?]
at net.corda.node.internal.AbstractNode$runDatabaseMigrationScripts$3.invoke(AbstractNode.kt:482) ~[corda-node-4.9.jar:?]
at net.corda.node.internal.AbstractNode$runDatabaseMigrationScripts$3.invoke(AbstractNode.kt:201) ~[corda-node-4.9.jar:?]
at net.corda.node.internal.AbstractNodeKt.startHikariPool(AbstractNode.kt:1342) ~[corda-node-4.9.jar:?]
… 20 more
Caused by: net.corda.nodeapi.internal.persistence.HibernateConfigException: Could not create Hibernate configuration: Failed to find a SessionFactoryFactory to handle jdbc:sqlserver://DESKTOP-KG45542\sqlexpress:1433;sslProtocol=TLS;jaasConfigurationName=SQLJDBCDriver;statementPoolingCacheSize=0;serverPreparedStatementDiscardThreshold=10;enablePrepareOnFirstPreparedStatementCall=false;fips=false;socketTimeout=0;authentication=NotSpecified;authenticationScheme=nativeAuthentication;xopenStates=false;sendTimeAsDatetime=true;trustStoreType=JKS;trustServerCertificate=false;TransparentNetworkIPResolution=true;serverNameAsACE=false;sendStringParametersAsUnicode=true;selectMethod=direct;responseBuffering=adaptive;queryTimeout=-1;packetSize=8000;multiSubnetFailover=false;loginTimeout=30;lockTimeout=-1;lastUpdateCount=true;encrypt=false;disableStatementPooling=true;databaseName=ICICIBank_Database;columnEncryptionSetting=Disabled;applicationName=Microsoft JDBC Driver for SQL Server;applicationIntent=readwrite; - factories present for [H2, PostgreSQL]
at net.corda.nodeapi.internal.persistence.CordaPersistence$hibernateConfig$2$1.invoke(CordaPersistence.kt:113) ~[corda-node-api-4.9.jar:?]
at net.corda.nodeapi.internal.persistence.CordaPersistence$hibernateConfig$2$1.invoke(CordaPersistence.kt:90) ~[corda-node-api-4.9.jar:?]
at net.corda.nodeapi.internal.persistence.CordaPersistence.withErrorHandler(CordaPersistence.kt:248) ~[corda-node-api-4.9.jar:?]
at net.corda.nodeapi.internal.persistence.CordaPersistence.transaction(CordaPersistence.kt:237) ~[corda-node-api-4.9.jar:?]
at net.corda.nodeapi.internal.persistence.CordaPersistence.transaction(CordaPersistence.kt:210) ~[corda-node-api-4.9.jar:?]
at net.corda.nodeapi.internal.persistence.CordaPersistence.transaction(CordaPersistence.kt:217) ~[corda-node-api-4.9.jar:?]
at net.corda.nodeapi.internal.persistence.CordaPersistence.transaction$default(CordaPersistence.kt:217) ~[corda-node-api-4.9.jar:?]
at net.corda.nodeapi.internal.persistence.CordaPersistence$hibernateConfig$2.invoke(CordaPersistence.kt:107) ~[corda-node-api-4.9.jar:?]
at net.corda.nodeapi.internal.persistence.CordaPersistence$hibernateConfig$2.invoke(CordaPersistence.kt:90) ~[corda-node-api-4.9.jar:?]
at kotlin.SynchronizedLazyImpl.getValue(LazyJVM.kt:74) ~[kotlin-stdlib-1.2.71.jar:1.2.71-release-64 (1.2.71)]
at net.corda.nodeapi.internal.persistence.CordaPersistence.getHibernateConfig(CordaPersistence.kt) ~[corda-node-api-4.9.jar:?]
at net.corda.nodeapi.internal.persistence.CordaPersistence.getEntityManagerFactory(CordaPersistence.kt:119) ~[corda-node-api-4.9.jar:?]
at net.corda.nodeapi.internal.persistence.DatabaseTransaction$sessionDelegate$1.invoke(DatabaseTransaction.kt:37) ~[corda-node-api-4.9.jar:?]
at net.corda.nodeapi.internal.persistence.DatabaseTransaction$sessionDelegate$1.invoke(DatabaseTransaction.kt:22) ~[corda-node-api-4.9.jar:?]
at kotlin.SynchronizedLazyImpl.getValue(LazyJVM.kt:74) ~[kotlin-stdlib-1.2.71.jar:1.2.71-release-64 (1.2.71)]
at net.corda.nodeapi.internal.persistence.DatabaseTransaction.getSession(DatabaseTransaction.kt) ~[corda-node-api-4.9.jar:?]
at net.corda.nodeapi.internal.persistence.DatabaseTransactionKt.currentDBSession(DatabaseTransaction.kt:13) ~[corda-node-api-4.9.jar:?]
at net.corda.node.utilities.AppendOnlyPersistentMapBase.getAllPersisted(AppendOnlyPersistentMap.kt:52) ~[corda-node-4.9.jar:?]
at net.corda.node.migration.MigrationServicesForResolution$networkParametersService$1$currentHash$1.invoke(MigrationServicesForResolution.kt:104) ~[corda-node-4.9.jar:?]
at net.corda.node.migration.MigrationServicesForResolution$networkParametersService$1$currentHash$1.invoke(MigrationServicesForResolution.kt:96) ~[corda-node-4.9.jar:?]
at net.corda.nodeapi.internal.persistence.CordaPersistence.withErrorHandler(CordaPersistence.kt:248) ~[corda-node-api-4.9.jar:?]
at net.corda.nodeapi.internal.persistence.CordaPersistence.transaction(CordaPersistence.kt:237) ~[corda-node-api-4.9.jar:?]
at net.corda.nodeapi.internal.persistence.CordaPersistence.transaction(CordaPersistence.kt:210) ~[corda-node-api-4.9.jar:?]
at net.corda.nodeapi.internal.persistence.CordaPersistence.transaction(CordaPersistence.kt:217) ~[corda-node-api-4.9.jar:?]
at net.corda.nodeapi.internal.persistence.CordaPersistence.transaction$default(CordaPersistence.kt:217) ~[corda-node-api-4.9.jar:?]
at net.corda.node.migration.MigrationServicesForResolution$networkParametersService$1.(MigrationServicesForResolution.kt:103) ~[corda-node-4.9.jar:?]
at net.corda.node.migration.MigrationServicesForResolution.(MigrationServicesForResolution.kt:96) ~[corda-node-4.9.jar:?]
at net.corda.node.migration.CordaMigration$initialiseNodeServices$1.invoke(CordaMigration.kt:67) ~[corda-node-4.9.jar:?]
at net.corda.node.migration.CordaMigration$initialiseNodeServices$1.invoke(CordaMigration.kt:31) ~[corda-node-4.9.jar:?]
at net.corda.nodeapi.internal.persistence.CordaPersistence.inTopLevelTransaction(CordaPersistence.kt:277) ~[corda-node-api-4.9.jar:?]
at net.corda.nodeapi.internal.persistence.CordaPersistence.transaction(CordaPersistence.kt:242) ~[corda-node-api-4.9.jar:?]
at net.corda.nodeapi.internal.persistence.CordaPersistence.transaction(CordaPersistence.kt:210) ~[corda-node-api-4.9.jar:?]
at net.corda.nodeapi.internal.persistence.CordaPersistence.transaction(CordaPersistence.kt:217) ~[corda-node-api-4.9.jar:?]
at net.corda.nodeapi.internal.persistence.CordaPersistence.transaction$default(CordaPersistence.kt:217) ~[corda-node-api-4.9.jar:?]
at net.corda.node.migration.CordaMigration.initialiseNodeServices(CordaMigration.kt:64) ~[corda-node-4.9.jar:?]
at net.corda.node.migration.VaultStateMigration.execute(VaultStateMigration.kt:81) ~[corda-node-4.9.jar:?]
at liquibase.change.custom.CustomChangeWrapper.generateStatements(CustomChangeWrapper.java:183) ~[liquibase-core-3.6.3.jar:?]
at liquibase.database.AbstractJdbcDatabase.executeStatements(AbstractJdbcDatabase.java:1209) ~[liquibase-core-3.6.3.jar:?]
at liquibase.changelog.ChangeSet.execute(ChangeSet.java:600) ~[liquibase-core-3.6.3.jar:?]
at liquibase.changelog.visitor.UpdateVisitor.visit(UpdateVisitor.java:53) ~[liquibase-core-3.6.3.jar:?]
at liquibase.changelog.ChangeLogIterator.run(ChangeLogIterator.java:83) ~[liquibase-core-3.6.3.jar:?]
at liquibase.Liquibase.update(Liquibase.java:202) ~[liquibase-core-3.6.3.jar:?]
at liquibase.Liquibase.update(Liquibase.java:179) ~[liquibase-core-3.6.3.jar:?]
at liquibase.Liquibase.update(Liquibase.java:175) ~[liquibase-core-3.6.3.jar:?]
at liquibase.Liquibase.update(Liquibase.java:168) ~[liquibase-core-3.6.3.jar:?]
at net.corda.nodeapi.internal.persistence.SchemaMigration.runMigration(SchemaMigration.kt:67) ~[corda-node-api-4.9.jar:?]
at net.corda.node.internal.AbstractNode$runDatabaseMigrationScripts$3.invoke(AbstractNode.kt:482) ~[corda-node-4.9.jar:?]
at net.corda.node.internal.AbstractNode$runDatabaseMigrationScripts$3.invoke(AbstractNode.kt:201) ~[corda-node-4.9.jar:?]
at net.corda.node.internal.AbstractNodeKt.startHikariPool(AbstractNode.kt:1342) ~[corda-node-4.9.jar:?]
… 20 more
Caused by: net.corda.nodeapi.internal.persistence.HibernateConfigException: Failed to find a SessionFactoryFactory to handle jdbc:sqlserver://DESKTOP-KG45542\sqlexpress:1433;sslProtocol=TLS;jaasConfigurationName=SQLJDBCDriver;statementPoolingCacheSize=0;serverPreparedStatementDiscardThreshold=10;enablePrepareOnFirstPreparedStatementCall=false;fips=false;socketTimeout=0;authentication=NotSpecified;authenticationScheme=nativeAuthentication;xopenStates=false;sendTimeAsDatetime=true;trustStoreType=JKS;trustServerCertificate=false;TransparentNetworkIPResolution=true;serverNameAsACE=false;sendStringParametersAsUnicode=true;selectMethod=direct;responseBuffering=adaptive;queryTimeout=-1;packetSize=8000;multiSubnetFailover=false;loginTimeout=30;lockTimeout=-1;lastUpdateCount=true;encrypt=false;disableStatementPooling=true;databaseName=ICICIBank_Database;columnEncryptionSetting=Disabled;applicationName=Microsoft JDBC Driver for SQL Server;applicationIntent=readwrite; - factories present for [H2, PostgreSQL]
at net.corda.nodeapi.internal.persistence.HibernateConfiguration$Companion.findSessionFactoryFactory(HibernateConfiguration.kt:46) ~[corda-node-api-4.9.jar:?]
at net.corda.nodeapi.internal.persistence.HibernateConfiguration$Companion.access$findSessionFactoryFactory(HibernateConfiguration.kt:29) ~[corda-node-api-4.9.jar:?]
at net.corda.nodeapi.internal.persistence.HibernateConfiguration.(HibernateConfiguration.kt:55) ~[corda-node-api-4.9.jar:?]
at net.corda.nodeapi.internal.persistence.CordaPersistence$hibernateConfig$2$1.invoke(CordaPersistence.kt:109) ~[corda-node-api-4.9.jar:?]
at net.corda.nodeapi.internal.persistence.CordaPersistence$hibernateConfig$2$1.invoke(CordaPersistence.kt:90) ~[corda-node-api-4.9.jar:?]
at net.corda.nodeapi.internal.persistence.CordaPersistence.withErrorHandler(CordaPersistence.kt:248) ~[corda-node-api-4.9.jar:?]
at net.corda.nodeapi.internal.persistence.CordaPersistence.transaction(CordaPersistence.kt:237) ~[corda-node-api-4.9.jar:?]
at net.corda.nodeapi.internal.persistence.CordaPersistence.transaction(CordaPersistence.kt:210) ~[corda-node-api-4.9.jar:?]
at net.corda.nodeapi.internal.persistence.CordaPersistence.transaction(CordaPersistence.kt:217) ~[corda-node-api-4.9.jar:?]
at net.corda.nodeapi.internal.persistence.CordaPersistence.transaction$default(CordaPersistence.kt:217) ~[corda-node-api-4.9.jar:?]
at net.corda.nodeapi.internal.persistence.CordaPersistence$hibernateConfig$2.invoke(CordaPersistence.kt:107) ~[corda-node-api-4.9.jar:?]
at net.corda.nodeapi.internal.persistence.CordaPersistence$hibernateConfig$2.invoke(CordaPersistence.kt:90) ~[corda-node-api-4.9.jar:?]
at kotlin.SynchronizedLazyImpl.getValue(LazyJVM.kt:74) ~[kotlin-stdlib-1.2.71.jar:1.2.71-release-64 (1.2.71)]
at net.corda.nodeapi.internal.persistence.CordaPersistence.getHibernateConfig(CordaPersistence.kt) ~[corda-node-api-4.9.jar:?]
at net.corda.nodeapi.internal.persistence.CordaPersistence.getEntityManagerFactory(CordaPersistence.kt:119) ~[corda-node-api-4.9.jar:?]
at net.corda.nodeapi.internal.persistence.DatabaseTransaction$sessionDelegate$1.invoke(DatabaseTransaction.kt:37) ~[corda-node-api-4.9.jar:?]
at net.corda.nodeapi.internal.persistence.DatabaseTransaction$sessionDelegate$1.invoke(DatabaseTransaction.kt:22) ~[corda-node-api-4.9.jar:?]
at kotlin.SynchronizedLazyImpl.getValue(LazyJVM.kt:74) ~[kotlin-stdlib-1.2.71.jar:1.2.71-release-64 (1.2.71)]
at net.corda.nodeapi.internal.persistence.DatabaseTransaction.getSession(DatabaseTransaction.kt) ~[corda-node-api-4.9.jar:?]
at net.corda.nodeapi.internal.persistence.DatabaseTransactionKt.currentDBSession(DatabaseTransaction.kt:13) ~[corda-node-api-4.9.jar:?]
at net.corda.node.utilities.AppendOnlyPersistentMapBase.getAllPersisted(AppendOnlyPersistentMap.kt:52) ~[corda-node-4.9.jar:?]
at net.corda.node.migration.MigrationServicesForResolution$networkParametersService$1$currentHash$1.invoke(MigrationServicesForResolution.kt:104) ~[corda-node-4.9.jar:?]
at net.corda.node.migration.MigrationServicesForResolution$networkParametersService$1$currentHash$1.invoke(MigrationServicesForResolution.kt:96) ~[corda-node-4.9.jar:?]
at net.corda.nodeapi.internal.persistence.CordaPersistence.withErrorHandler(CordaPersistence.kt:248) ~[corda-node-api-4.9.jar:?]
at net.corda.nodeapi.internal.persistence.CordaPersistence.transaction(CordaPersistence.kt:237) ~[corda-node-api-4.9.jar:?]
at net.corda.nodeapi.internal.persistence.CordaPersistence.transaction(CordaPersistence.kt:210) ~[corda-node-api-4.9.jar:?]
at net.corda.nodeapi.internal.persistence.CordaPersistence.transaction(CordaPersistence.kt:217) ~[corda-node-api-4.9.jar:?]
at net.corda.nodeapi.internal.persistence.CordaPersistence.transaction$default(CordaPersistence.kt:217) ~[corda-node-api-4.9.jar:?]
at net.corda.node.migration.MigrationServicesForResolution$networkParametersService$1.(MigrationServicesForResolution.kt:103) ~[corda-node-4.9.jar:?]
at net.corda.node.migration.MigrationServicesForResolution.(MigrationServicesForResolution.kt:96) ~[corda-node-4.9.jar:?]
at net.corda.node.migration.CordaMigration$initialiseNodeServices$1.invoke(CordaMigration.kt:67) ~[corda-node-4.9.jar:?]
at net.corda.node.migration.CordaMigration$initialiseNodeServices$1.invoke(CordaMigration.kt:31) ~[corda-node-4.9.jar:?]
at net.corda.nodeapi.internal.persistence.CordaPersistence.inTopLevelTransaction(CordaPersistence.kt:277) ~[corda-node-api-4.9.jar:?]
at net.corda.nodeapi.internal.persistence.CordaPersistence.transaction(CordaPersistence.kt:242) ~[corda-node-api-4.9.jar:?]
at net.corda.nodeapi.internal.persistence.CordaPersistence.transaction(CordaPersistence.kt:210) ~[corda-node-api-4.9.jar:?]
at net.corda.nodeapi.internal.persistence.CordaPersistence.transaction(CordaPersistence.kt:217) ~[corda-node-api-4.9.jar:?]
at net.corda.nodeapi.internal.persistence.CordaPersistence.transaction$default(CordaPersistence.kt:217) ~[corda-node-api-4.9.jar:?]
at net.corda.node.migration.CordaMigration.initialiseNodeServices(CordaMigration.kt:64) ~[corda-node-4.9.jar:?]
at net.corda.node.migration.VaultStateMigration.execute(VaultStateMigration.kt:81) ~[corda-node-4.9.jar:?]
at liquibase.change.custom.CustomChangeWrapper.generateStatements(CustomChangeWrapper.java:183) ~[liquibase-core-3.6.3.jar:?]
at liquibase.database.AbstractJdbcDatabase.executeStatements(AbstractJdbcDatabase.java:1209) ~[liquibase-core-3.6.3.jar:?]
at liquibase.changelog.ChangeSet.execute(ChangeSet.java:600) ~[liquibase-core-3.6.3.jar:?]
at liquibase.changelog.visitor.UpdateVisitor.visit(UpdateVisitor.java:53) ~[liquibase-core-3.6.3.jar:?]
at liquibase.changelog.ChangeLogIterator.run(ChangeLogIterator.java:83) ~[liquibase-core-3.6.3.jar:?]
at liquibase.Liquibase.update(Liquibase.java:202) ~[liquibase-core-3.6.3.jar:?]
at liquibase.Liquibase.update(Liquibase.java:179) ~[liquibase-core-3.6.3.jar:?]
at liquibase.Liquibase.update(Liquibase.java:175) ~[liquibase-core-3.6.3.jar:?]
at liquibase.Liquibase.update(Liquibase.java:168) ~[liquibase-core-3.6.3.jar:?]
at net.corda.nodeapi.internal.persistence.SchemaMigration.runMigration(SchemaMigration.kt:67) ~[corda-node-api-4.9.jar:?]
at net.corda.node.internal.AbstractNode$runDatabaseMigrationScripts$3.invoke(AbstractNode.kt:482) ~[corda-node-4.9.jar:?]
at net.corda.node.internal.AbstractNode$runDatabaseMigrationScripts$3.invoke(AbstractNode.kt:201) ~[corda-node-4.9.jar:?]
at net.corda.node.internal.AbstractNodeKt.startHikariPool(AbstractNode.kt:1342) ~[corda-node-4.9.jar:?]
… 20 more
Thanks,
Kiran Sagar