Yes, you built the server. I don’t think you need to install trafci.zip.
Best regards, Yuan -----Original Message----- From: Bin Lin [mailto:[email protected]] Sent: Friday, August 04, 2017 1:03 PM To: [email protected] Subject: Re: JDBC configuration 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) <[email protected]> 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: [email protected] > Cellphone: (+86) 13671935540 > > -----Original Message----- > From: Bin Lin [mailto:[email protected]] > Sent: Friday, August 04, 2017 6:32 AM > To: [email protected] > 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 >
