Hi Bin, 1 the trafci.zip is a client tool. If you want to connect to Trafodion server remotely, you can install it on client side and connect to Trafodion. By default, Trafodion sever side also includes trafci.
2 You don’t need to create catalog, catalog has 3 fixed values: TRAFDOION(for trafodion tables), HBASE(for local hbase tables),HIVE(for hive tables). For schemas, the default schema of trafodion is SEABASE. For HBase tables, there are two fixed schema name: "_CELL_", "_ROW_". For Hive tables, the schema is the same in Hive. Best regards, Yuan Email: yuan....@esgyn.cn Cellphone: (+86) 13671935540 -----Original Message----- From: Bin Lin [mailto:linbi...@gmail.com] Sent: Friday, August 04, 2017 6:32 AM To: dev@trafodion.incubator.apache.org Subject: JDBC configuration Hi there, I have two questions when I was trying to configure JDBC. 1. I downloaded the Trafodion Clients package which contains the trafci installer, trafci.zip. My question is whether I have to install trafci by this installer. I have built the entire Trafodion system from the source code, and I can use trafci command to create tables and run queries interactively. 2. The instructions for editing t4jdbc.properties file says that SQL catalog and SQL schema must exist on the database. Do these mean that I have to create a SQL catalog and a SQL schema in the Trafodion database first? In addition, does the t4jdbc.properties file in the samples folder work by default? Thank you. Best, Bin