Re: 回复: Ignite - SQL Column names Case not preserved.

Sat, 28 Dec 2019 12:20:18 -0800 

Thanks for the suggestion

I am using Pure SQL to create tables.
I dont know how to use this option on the SQL Create syntax.

I tried using the below code.
        cfg.setCacheConfiguration(
                new
CacheConfiguration().setName("PUBLIC").setSqlSchema("PUBLIC").setSqlEscapeAll(true)
        );
After when I create the table I see the same behaviour as before.

I also tried creating cache as below.
cfg.setCacheConfiguration(
                new
CacheConfiguration().setName("SQL_PUBLIC_ACC").setSqlSchema("PUBLIC").setSqlEscapeAll(true)
        );
But this is not allowing me to create table after that.
java.sql.SQLException: Table already exists: ACC
        at
org.apache.ignite.internal.jdbc.thin.JdbcThinConnection.sendRequest(JdbcThinConnection.java:751)


Is there a way to use this parameter with SQL create table?





--
Sent from: http://apache-ignite-users.70518.x6.nabble.com/

Reply via email to