Skip to main content


Eclipse Community Forums
Forum Search:

Search      Help    Register    Login    Home
Home » Archived » Eclipse Process Manager (Stardust) » MARS2: Unsupported database type: MSSQL
MARS2: Unsupported database type: MSSQL [message #1749486] Wed, 07 December 2016 10:07 Go to next message
Guan Han Jie is currently offline Guan Han JieFriend
Messages: 4
Registered: December 2016
Junior Member
Hello,

I was following the setup documentation "MSSQL Setup" to switch from Derby database to MSSQL.

However I ran into a problem having the database is not supported.

Did I missed out any of the libraries?
Re: MARS2: Unsupported database type: MSSQL [message #1749560 is a reply to message #1749486] Thu, 08 December 2016 07:01 Go to previous messageGo to next message
Robert Emsbach is currently offline Robert EmsbachFriend
Messages: 186
Registered: October 2011
Location: Singapore
Senior Member

Your 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.
Re: MARS2: Unsupported database type: MSSQL [message #1750468 is a reply to message #1749560] Wed, 21 December 2016 11:04 Go to previous messageGo to next message
chris suen is currently offline chris suenFriend
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 Go to previous messageGo to next message
Guan Han Jie is currently offline Guan Han JieFriend
Messages: 4
Registered: December 2016
Junior Member
Robert Emsbach wrote on Thu, 08 December 2016 07:01
Your 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

Re: MARS2: Unsupported database type: MSSQL [message #1750596 is a reply to message #1750578] Fri, 23 December 2016 07:40 Go to previous messageGo to next message
chris suen is currently offline chris suenFriend
Messages: 19
Registered: November 2016
Junior Member
I have also tested the db connection with other JDBC client. it is working fine. Suspect something not right when using -dbtype MSSQL.
Re: MARS2: Unsupported database type: MSSQL [message #1750600 is a reply to message #1750596] Fri, 23 December 2016 07:50 Go to previous message
chris suen is currently offline chris suenFriend
Messages: 19
Registered: November 2016
Junior Member
Just another thought, is there any other version of sysconsole other than what is stated in our pom.xml file header below?
<groupId>local</groupId>
<artifactId>sysconsole</artifactId>
<packaging>jar</packaging>
<version>1.0-SNAPSHOT</version>
Previous Topic:Stardust portal-Participant Manager Tab empty
Next Topic:participant manager empty tab
Goto Forum:
  


Current Time: Mon Oct 07 11:35:45 GMT 2024

Powered by FUDForum. Page generated in 0.04667 seconds
.:: Contact :: Home ::.

Powered by: FUDforum 3.0.2.
Copyright ©2001-2010 FUDforum Bulletin Board Software

Back to the top