Does anyone know what settings Avatica server requires to work with the
Apache Phoenix drivers?
When I run Avatica server with the following:
```java
public static void main(String[] args) throws SQLException,
InterruptedException {
Server h2server = Server.createTcpServer("-tcp", "-tcpAllowOthers",
"-tcpPort", "9092").start();
Server h2serverWeb = Server.createWebServer("-webAllowOthers",
"-webPort", "9091").start();
Connection h2connection =
DriverManager.getConnection("jdbc:h2:./test;MODE=PostgreSQL;DB_CLOSE_DELAY=-1;DB_CLOSE_ON_EXIT=FALSE;INIT=RUNSCRIPT
FROM 'src/test/resources/northwind.sql'", "sa", "");
ConfigurableJdbcMeta meta = new ConfigurableJdbcMeta(
"jdbc:h2:tcp://localhost:9092/./test", "sa", "");
LocalService service = new LocalService(meta);
HughProtobufHandler pHandler = new HughProtobufHandler(service);
HttpServer.Builder<Server> builder = new HttpServer.Builder<Server
>()
.withHandler(pHandler)
.withPort(9090);
HttpServer avaticaserver = builder.build();
avaticaserver.start();
avaticaserver.join();
}
```
And I try to connect with the ODBC Avatica Driver (Hortonworks Phoenix DSN).
It gives 500 internal server error.
Are there some default settings modified in avatica server running in
phoenix which would make normal avatica server incompatible with the
cloudera odbc driver for phoenix?
Reference
1.
https://www.cloudera.com/downloads/connectors/phoenix/odbc/1-0-8-1011.html
From,
Hugh Pearse
