How to change main db schema?

Support
#1

Hi,
I try to create a new Cuba project (latest plugin and framework version) with datasource mssql.
The db should use another schema then dbo.
But, how to tell Cuba not to use dbo schema?
I tried currentSchema=schemaname in the URL, additional parameters…
nothing works.
I only get this error message:
Execution failed for task ‘:app-core:updateDb’.

com.microsoft.sqlserver.jdbc.SQLServerException: The specified schema name “dbo” either does not exist or you do not have permission to use it.

Roland

#2

Hi,
There is some info in the Developers Manual:
https://doc.cuba-platform.com/manual-7.2/db_schema_connection.html

#3

Hi Alexander,

I tried that in multiple ways… but it does not work.
Here as an example my actual settings I try to use:
cuba.dataSourceProvider = application
cuba.dataSource.jdbcUrl=jdbc:sqlserver://servername.database.windows.net;databaseName=dbname-sql-db-dev;authentication=activedirectorypassword;currentSchema=jmix_test_cuba
cuba.dataSource.username = user@domain.com
cuba.dataSource.password = pwd$01
cuba.dataSource.dbName = dbname
cuba.dataSource.connectionParams = -sql-db-dev;authentication=activedirectorypassword;currentSchema=jmix_test_cuba
cuba.dataSource.host = servername.database.windows.net

One other topic is, that the Studio GUI does not accept DB names like: dbname-sql-db-dev
The only way to get it running, is splitting the DBName and put the second part into the connectionParams.

The error message I get with this settings:
Execution failed for task ‘:app-core:updateDb’.

com.microsoft.sqlserver.jdbc.SQLServerException: The specified schema name “dbo” either does not exist or you do not have permission to use it.

Which means, “dbo” schemaName is still used.

And, I am facing the same issue in JMIX…

#4

Have you also modified parameters of the task in build.gradle?

UPD: ah, sorry, it’s necessary only for JNDI data source.

#5

I also tried jndi datasource and did the sttings in build.gradle