Home » Archived » Eclipse Process Manager (Stardust) » MARS2: Unsupported database type: MSSQL
| |
Re: MARS2: Unsupported database type: MSSQL [message #1750468 is a reply to message #1749560] |
Wed, 21 December 2016 11:04 |
chris suen Messages: 19 Registered: November 2016 |
Junior Member |
|
|
Hi I got the same error. the following are the log output. Appreciate if anyone have any solution for this issue. thanks
2016-12-08 09:46:05,231 INFO [main] () config.Parameters - CARNOT version: 1.0.1.93
2016-12-08 09:46:05,239 INFO [main] () config.GlobalParameters - Loading properties via provider factory org.eclipse.stardust.common.config.DefaultPropertiesProvider$Factory (priority 1).
2016-12-08 09:46:05,243 INFO [main] () config.DefaultPropertiesProvider - Property bundle carnot.properties bootstrapped from classloader sun.misc.Launcher$AppClassLoader@6bc7c054:
2016-12-08 09:46:05,244 INFO [main] () config.DefaultPropertiesProvider - AuditTrail.Schema =
2016-12-08 09:46:05,244 INFO [main] () config.DefaultPropertiesProvider - AuditTrail.UsePreparedStatements = false
2016-12-08 09:46:05,244 INFO [main] () config.DefaultPropertiesProvider - AuditTrail.DriverClass = org.apache.derby.jdbc.ClientDriver
2016-12-08 09:46:05,244 INFO [main] () config.DefaultPropertiesProvider - Logging.Format = %d{yyyy-MM-dd HH:mm:ss,SSS} %-5p [%t] (%x) %c{2} - %m%n
2016-12-08 09:46:05,244 INFO [main] () config.DefaultPropertiesProvider - Logging.Filters =
2016-12-08 09:46:05,244 INFO [main] () config.DefaultPropertiesProvider - AuditTrail.Type = DERBY
2016-12-08 09:46:05,245 INFO [main] () config.DefaultPropertiesProvider - Logging.Directory = C:\Users\RX\sysconsole/log
2016-12-08 09:46:05,245 INFO [main] () config.DefaultPropertiesProvider - Logging.MaxFileSize = 4194304
2016-12-08 09:46:05,245 INFO [main] () config.DefaultPropertiesProvider - AuditTrail.UseLockTables =
2016-12-08 09:46:05,245 INFO [main] () config.DefaultPropertiesProvider - Secure.Session.Factory =
2016-12-08 09:46:05,245 INFO [main] () config.DefaultPropertiesProvider - License.LicenseFilePath =
2016-12-08 09:46:05,245 INFO [main] () config.DefaultPropertiesProvider - AuditTrail.User = carnot
2016-12-08 09:46:05,245 INFO [main] () config.DefaultPropertiesProvider - Logging.LogLevel = INFO
2016-12-08 09:46:05,245 INFO [main] () config.DefaultPropertiesProvider - Web.ServiceFactory = org.eclipse.stardust.engine.core.runtime.beans.POJOServiceFactory
2016-12-08 09:46:05,245 INFO [main] () config.DefaultPropertiesProvider - GUI.WorklistRotation = true
2016-12-08 09:46:05,245 INFO [main] () config.DefaultPropertiesProvider - Security.DefaultPartition = default
2016-12-08 09:46:05,245 INFO [main] () config.DefaultPropertiesProvider - Client.ServiceFactory = org.eclipse.stardust.engine.core.runtime.beans.POJOServiceFactory
2016-12-08 09:46:05,245 INFO [main] () config.DefaultPropertiesProvider - QueryService.Guarded = true
2016-12-08 09:46:05,246 INFO [main] () config.DefaultPropertiesProvider - Security.DefaultRealm = carnot
2016-12-08 09:46:05,246 INFO [main] () config.DefaultPropertiesProvider - Security.Authentication.ConfigurationName =
2016-12-08 09:46:05,246 INFO [main] () config.DefaultPropertiesProvider - Security.PromptPartition = false
2016-12-08 09:46:05,246 INFO [main] () config.DefaultPropertiesProvider - Dependent.Properties =
2016-12-08 09:46:05,246 INFO [main] () config.DefaultPropertiesProvider - Mail.Host = localhost
2016-12-08 09:46:05,246 INFO [main] () config.DefaultPropertiesProvider - AuditTrail.URL = jdbc:derby://localhost:1527/ipp;create=true
2016-12-08 09:46:05,246 INFO [main] () config.DefaultPropertiesProvider - Security.PromptRealm = false
2016-12-08 09:46:05,246 INFO [main] () config.DefaultPropertiesProvider - Credential.Provider =
2016-12-08 09:46:05,246 INFO [main] () config.DefaultPropertiesProvider - Security.PromptDomain = false
2016-12-08 09:46:05,246 INFO [main] () config.DefaultPropertiesProvider - Model.RepositoryDirectoryPath =
2016-12-08 09:46:05,246 INFO [main] () config.DefaultPropertiesProvider - Mail.Sender = user@localhost
2016-12-08 09:46:05,247 INFO [main] () config.DefaultPropertiesProvider - GUI.WorklistRetrievalInterval = 20
2016-12-08 09:46:05,251 INFO [main] () log.extensions - Initializing static extensions resolver
2016-12-08 09:46:05,252 INFO [main] () log.extensions - Initializing Service Provider extensions resolver
2016-12-08 09:46:05,252 INFO [main] () log.extensions - Using extensions manager: org.eclipse.stardust.engine.core.runtime.beans.PartitionAwareExtensionsManager@27f8302d
2016-12-08 09:46:05,259 INFO [main] () console.ConsoleCommand - Create Infinity schema:
2016-12-08 09:46:05,260 INFO [main] () console.ConsoleCommand - Database type : MSSQL
2016-12-08 09:46:05,260 INFO [main] () console.ConsoleCommand - Database URL : jdbc:sqlserver://127.0.0.1/databaseName=Test
2016-12-08 09:46:05,261 INFO [main] () console.ConsoleCommand - Database user : sa
2016-12-08 09:46:05,261 INFO [main] () console.ConsoleCommand - Database schema : sysSchema
2016-12-08 09:46:05,261 INFO [main] () console.ConsoleCommand - Database driver : com.microsoft.sqlserver.jdbc.SQLServerDriver
2016-12-08 09:46:05,304 INFO [main] () console.ConsoleCommand -
2016-12-08 09:46:06,162 WARN [main] () console.DefaultConsoleProcessor - Operation could not be performed: Unsupported database type: MSSQL
2016-12-08 09:46:06,164 WARN [main] () console.DefaultConsoleProcessor -
org.eclipse.stardust.common.error.InternalException: Unsupported database type: MSSQL
at org.eclipse.stardust.engine.core.persistence.jdbc.DBDescriptor.create(DBDescriptor.java:181)
at org.eclipse.stardust.engine.core.persistence.jdbc.DBDescriptor$1.getValue(DBDescriptor.java:117)
at org.eclipse.stardust.common.config.GlobalParameters.getOrInitialize(GlobalParameters.java:467)
at org.eclipse.stardust.common.config.GlobalParameters.initializeIfAbsent(GlobalParameters.java:437)
at org.eclipse.stardust.engine.core.persistence.jdbc.DBDescriptor.create(DBDescriptor.java:89)
at org.eclipse.stardust.engine.core.persistence.jdbc.Session.<init>(Session.java:215)
at org.eclipse.stardust.engine.core.persistence.jdbc.SessionFactory.createSession(SessionFactory.java:82)
at org.eclipse.stardust.engine.cli.sysconsole.AuditTrailCommand.run(AuditTrailCommand.java:126)
at org.eclipse.stardust.common.utils.console.DefaultConsoleProcessor.execute(DefaultConsoleProcessor.java:128)
at org.eclipse.stardust.engine.cli.sysconsole.Main.run(Main.java:77)
at org.eclipse.stardust.engine.cli.sysconsole.Main.main(Main.java:66)
|
|
|
Re: MARS2: Unsupported database type: MSSQL [message #1750578 is a reply to message #1749560] |
Thu, 22 December 2016 23:39 |
Guan Han Jie Messages: 4 Registered: December 2016 |
Junior Member |
|
|
Robert Emsbach wrote on Thu, 08 December 2016 07:01Your DB dialect setting looks correct. The error message could be misleading. Please check your DB connection parameters, add sysconsole parameter -v for verbose output and check/share the log file.
Hi Robert, sorry for late reply as I have some other matters to attend during the whole month.
After running the script:
C:\Users\RX\sysconsole\bin>sysconsole -v -r com.microsoft.sqlserver.jdbc.SQLServerDriver -dbtype MSSQL -dbschema Test -l jdbc:sqlserver://127.0.0.1/databaseName=Test -d sa -s s@ createschema
Here is the log generated:
2016-12-23 07:36:49,119 INFO [main] () config.Parameters - CARNOT version: 1.0.1.93
2016-12-23 07:36:49,126 INFO [main] () config.GlobalParameters - Loading properties via provider factory org.eclipse.stardust.common.config.DefaultPropertiesProvider$Factory (priority 1).
2016-12-23 07:36:49,131 INFO [main] () config.DefaultPropertiesProvider - Property bundle carnot.properties bootstrapped from classloader sun.misc.Launcher$AppClassLoader@6bc7c054:
2016-12-23 07:36:49,131 INFO [main] () config.DefaultPropertiesProvider - AuditTrail.Schema =
2016-12-23 07:36:49,132 INFO [main] () config.DefaultPropertiesProvider - AuditTrail.UsePreparedStatements = false
2016-12-23 07:36:49,132 INFO [main] () config.DefaultPropertiesProvider - AuditTrail.DriverClass = org.apache.derby.jdbc.ClientDriver
2016-12-23 07:36:49,132 INFO [main] () config.DefaultPropertiesProvider - Logging.Format = %d{yyyy-MM-dd HH:mm:ss,SSS} %-5p [%t] (%x) %c{2} - %m%n
2016-12-23 07:36:49,132 INFO [main] () config.DefaultPropertiesProvider - Logging.Filters =
2016-12-23 07:36:49,132 INFO [main] () config.DefaultPropertiesProvider - AuditTrail.Type = DERBY
2016-12-23 07:36:49,132 INFO [main] () config.DefaultPropertiesProvider - Logging.Directory = C:\Users\RX\sysconsole/log
2016-12-23 07:36:49,132 INFO [main] () config.DefaultPropertiesProvider - Logging.MaxFileSize = 4194304
2016-12-23 07:36:49,132 INFO [main] () config.DefaultPropertiesProvider - AuditTrail.UseLockTables =
2016-12-23 07:36:49,132 INFO [main] () config.DefaultPropertiesProvider - Secure.Session.Factory =
2016-12-23 07:36:49,132 INFO [main] () config.DefaultPropertiesProvider - License.LicenseFilePath =
2016-12-23 07:36:49,133 INFO [main] () config.DefaultPropertiesProvider - AuditTrail.User = carnot
2016-12-23 07:36:49,133 INFO [main] () config.DefaultPropertiesProvider - Logging.LogLevel = INFO
2016-12-23 07:36:49,133 INFO [main] () config.DefaultPropertiesProvider - Web.ServiceFactory = org.eclipse.stardust.engine.core.runtime.beans.POJOServiceFactory
2016-12-23 07:36:49,133 INFO [main] () config.DefaultPropertiesProvider - GUI.WorklistRotation = true
2016-12-23 07:36:49,133 INFO [main] () config.DefaultPropertiesProvider - Security.DefaultPartition = default
2016-12-23 07:36:49,133 INFO [main] () config.DefaultPropertiesProvider - Client.ServiceFactory = org.eclipse.stardust.engine.core.runtime.beans.POJOServiceFactory
2016-12-23 07:36:49,133 INFO [main] () config.DefaultPropertiesProvider - QueryService.Guarded = true
2016-12-23 07:36:49,133 INFO [main] () config.DefaultPropertiesProvider - Security.DefaultRealm = carnot
2016-12-23 07:36:49,133 INFO [main] () config.DefaultPropertiesProvider - Security.Authentication.ConfigurationName =
2016-12-23 07:36:49,133 INFO [main] () config.DefaultPropertiesProvider - Security.PromptPartition = false
2016-12-23 07:36:49,133 INFO [main] () config.DefaultPropertiesProvider - Dependent.Properties =
2016-12-23 07:36:49,134 INFO [main] () config.DefaultPropertiesProvider - Mail.Host = localhost
2016-12-23 07:36:49,134 INFO [main] () config.DefaultPropertiesProvider - AuditTrail.URL = jdbc:derby://localhost:1527/ipp;create=true
2016-12-23 07:36:49,134 INFO [main] () config.DefaultPropertiesProvider - Security.PromptRealm = false
2016-12-23 07:36:49,134 INFO [main] () config.DefaultPropertiesProvider - Credential.Provider =
2016-12-23 07:36:49,134 INFO [main] () config.DefaultPropertiesProvider - Security.PromptDomain = false
2016-12-23 07:36:49,134 INFO [main] () config.DefaultPropertiesProvider - Model.RepositoryDirectoryPath =
2016-12-23 07:36:49,134 INFO [main] () config.DefaultPropertiesProvider - Mail.Sender = user@localhost
2016-12-23 07:36:49,134 INFO [main] () config.DefaultPropertiesProvider - GUI.WorklistRetrievalInterval = 20
2016-12-23 07:36:49,139 INFO [main] () log.extensions - Initializing static extensions resolver
2016-12-23 07:36:49,140 INFO [main] () log.extensions - Initializing Service Provider extensions resolver
2016-12-23 07:36:49,140 INFO [main] () log.extensions - Using extensions manager: org.eclipse.stardust.engine.core.runtime.beans.PartitionAwareExtensionsManager@27f8302d
2016-12-23 07:36:49,147 INFO [main] () console.ConsoleCommand - Create Infinity schema:
2016-12-23 07:36:49,148 INFO [main] () console.ConsoleCommand - Database type : MSSQL
2016-12-23 07:36:49,148 INFO [main] () console.ConsoleCommand - Database URL : jdbc:sqlserver://127.0.0.1/databaseName=Test
2016-12-23 07:36:49,149 INFO [main] () console.ConsoleCommand - Database user : sa
2016-12-23 07:36:49,149 INFO [main] () console.ConsoleCommand - Database schema : Test
2016-12-23 07:36:49,149 INFO [main] () console.ConsoleCommand - Database driver : com.microsoft.sqlserver.jdbc.SQLServerDriver
2016-12-23 07:36:49,197 INFO [main] () console.ConsoleCommand -
2016-12-23 07:36:50,496 WARN [main] () console.DefaultConsoleProcessor - Operation could not be performed: Unsupported database type: MSSQL
2016-12-23 07:36:50,497 WARN [main] () console.DefaultConsoleProcessor -
org.eclipse.stardust.common.error.InternalException: Unsupported database type: MSSQL
at org.eclipse.stardust.engine.core.persistence.jdbc.DBDescriptor.create(DBDescriptor.java:181)
at org.eclipse.stardust.engine.core.persistence.jdbc.DBDescriptor$1.getValue(DBDescriptor.java:117)
at org.eclipse.stardust.common.config.GlobalParameters.getOrInitialize(GlobalParameters.java:467)
at org.eclipse.stardust.common.config.GlobalParameters.initializeIfAbsent(GlobalParameters.java:437)
at org.eclipse.stardust.engine.core.persistence.jdbc.DBDescriptor.create(DBDescriptor.java:89)
at org.eclipse.stardust.engine.core.persistence.jdbc.Session.<init>(Session.java:215)
at org.eclipse.stardust.engine.core.persistence.jdbc.SessionFactory.createSession(SessionFactory.java:82)
at org.eclipse.stardust.engine.cli.sysconsole.AuditTrailCommand.run(AuditTrailCommand.java:126)
at org.eclipse.stardust.common.utils.console.DefaultConsoleProcessor.execute(DefaultConsoleProcessor.java:128)
at org.eclipse.stardust.engine.cli.sysconsole.Main.run(Main.java:77)
at org.eclipse.stardust.engine.cli.sysconsole.Main.main(Main.java:66)
[Updated on: Thu, 22 December 2016 23:49] Report message to a moderator
|
|
| | |
Goto Forum:
Current Time: Mon Oct 14 11:57:17 GMT 2024
Powered by FUDForum. Page generated in 0.04002 seconds
|