Re: can we set a default schema for calcite connection to avoid writing schema names in sql

takes the work, it will be much easier. -- Original -- From: "Gavin Ray";; Send time: Sunday, Feb 20, 2022 0:59 AM To: "dev"; Subject: Re: can we set a default schema for calcite connection to avoid writing schema names in sql

Re: can we set a default schema for calcite connection to avoid writing schema names in sql

> >> >> ---------- Original ------ >> From: "Gavin Ray";; >> Send time: Saturday, Feb 19, 2022 0:37 AM >> To: "dev"; >> >> Subject: Re: can we set a default schema for calcite connection to avoid >> wri

Re: can we set a default schema for calcite connection to avoid writing schema names in sql

-- Original -- > From: "Gavin Ray";; > Send time: Saturday, Feb 19, 2022 0:37 AM > To: "dev"; > > Subject: Re: can we set a default schema for calcite connection to avoid > writing schema names in sql > > > > Sure > > Here is a s

Re: can we set a default schema for calcite connection to avoid writing schema names in sql

? Regards -- Original -- From: "Gavin Ray";; Send time: Saturday, Feb 19, 2022 0:37 AM To: "dev"; Subject: Re: can we set a default schema for calcite connection to avoid writing schema names in sql Sure Here is a singleton object that use

Re: can we set a default schema for calcite connection to avoid writing schema names in sql

ong ret = null; if(rs.next()) { ret = rs.getLong(1); } rs.close(); return ret; } } -- Original -- From: "Gavin Ray";; Send time: Saturday, Feb 19, 2022 0:37 AM To: "dev"; Subject: Re: can we

Re: can we set a default schema for calcite connection to avoid writing schema names in sql

aseSensitive(false)) > .build(); > > > > > -- Original ------ > From: "Gavin Ray";; > Send time: Sunday, Feb 13, 2022 10:25 AM > To: "dev"; > > Subject: Re: can we set a default schema for calcite connection to avoid &

Re: can we set a default schema for calcite connection to avoid writing schema names in sql

t; > -- Original -- > From: "Gavin Ray";; > Send time: Sunday, Feb 13, 2022 10:25 AM > To: "dev"; > > Subject: Re: can we set a default schema for calcite connection to avoid > writing schema names in sql > > > >

Re: can we set a default schema for calcite connection to avoid writing schema names in sql

.build(); -- Original -- From: "Gavin Ray";; Send time: Sunday, Feb 13, 2022 10:25 AM To: "dev"; Subject: Re: can we set a default schema for calcite connection to avoid writing schema names in sql You can create an empty root schema, add a Re

Re: can we set a default schema for calcite connection to avoid writing schema names in sql

e:", info); > > CalciteConnection conn = > > connection.unwrap(CalciteConnection.class); > > SchemaPlus rootSchema = conn.getRootSchema(); > > Schema schema = new ReflectiveSchema(target); > > rootSchema.ad

Re: can we set a default schema for calcite connection to avoid writing schema names in sql

should be done before the connection is opened. -- Original -- From: "Gavin Ray";; Send time: Sunday, Feb 13, 2022 1:43 AM To: "dev"; Subject: Re: can we set a default schema for calcite connection to avoid writing schema names in sql He

Re: can we set a default schema for calcite connection to avoid writing schema names in sql

; > > > > ---------- Original ---------- > From: "xiaobo ";; > Send time: Friday, Feb 11, 2022 11:20 PM > To: "dev"; > > Subject: can we set a default schema for calcite connection to avoid > writing schema names in sql >

Re: can we set a default schema for calcite connection to avoid writing schema names in sql

ot;xiaobo ";; Send time: Friday, Feb 11, 2022 11:20 PM To: "dev"; Subject: can we set a default schema for calcite connection to avoid writing schema names in sql we have tried the following and it does not work Class.forName("org.apache.calcite.jdbc.Driver

can we set a default schema for calcite connection to avoid writing schema names in sql

we have tried the following and it does not work Class.forName("org.apache.calcite.jdbc.Driver");        Properties info = new Properties();        info.setProperty("lex", "JAVA");        info.setProperty(CalciteConnectionProperty.CASE_SENSITIVE.camelName(), "false");