Hi Yuan, Thank you for clarification.
So if I used 'git clone' to download the source code from Github and built it. Does this mean that I built the Trafodion server? And in my case, do I have to install the trafci.zip again in order to configure JDBC? Thank you. Best, Bin On Thu, Aug 3, 2017 at 6:22 PM, Liu, Yuan (Yuan) <yuan....@esgyn.cn> wrote: > 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 >