Re: JDBC configuration

2017-08-09 Thread Bin Lin 
Hello Kevin,

I copied the second command from the online instructions. Apparently, I
didn't notice the difference between the file names. Now it works as
expected.

Thank you for your help.

Best,
Bin

On Tue, Aug 8, 2017 at 6:16 PM, Xu, Kai-Hua (Kevin) <kaihua...@esgyn.cn>
wrote:

> Hi Bin
>
> I saw you were using jdbcT4-2.1.0.jar for compilation while jdbcT4.jar for
> running. Does the jadbcT.jar link to jdbcT4-2.1.0.jar? I doubt if it refs
> to the right jar.
> > $ $JAVA_HOME/bin/javac -classpath ../../lib/jdbcT4-2.1.0.jar *.java
> > ../common/*.java
> $ $JAVA_HOME/bin/java -classpath ../../lib/jdbcT4.jar:..:.
> > -Dt4jdbc.properties=../t4jdbc.properties StatementSample
>
> Best Regards,
> Kevin Xu
>
> -Original Message-
> From: Bin Lin [mailto:linbi...@gmail.com]
> Sent: Wednesday, August 09, 2017 3:14 AM
> To: dev@trafodion.incubator.apache.org
> Subject: Re: JDBC configuration
>
> Hi Kevin,
>
> The output of your provided command are as follows.
>
> *7048 Thu Apr 06 22:48:54 PDT 2017 org/trafodion/jdbc/t4/T4Driver.class*
>
> On Mon, Aug 7, 2017 at 6:42 PM, Xu, Kai-Hua (Kevin) <kaihua...@esgyn.cn>
> wrote:
>
> > Hi Bin,
> >
> > Could you please check your ../../lib/jdbcT4-2.1.0.jar with following
> > command? Is there any difference for the package name 'org.trafodion'
> > or 'org.apache.trafodion'? if so, I think you may have to make the
> > changes in common/sampleUtils.java.
> > jar -tvf ../../lib/jdbcT4-2.1.0.jar| grep T4Driver
> >
> >
> > Kevin
> >
> > -----Original Message-
> > From: Bin Lin [mailto:linbi...@gmail.com]
> > Sent: Tuesday, August 08, 2017 8:05 AM
> > To: dev@trafodion.incubator.apache.org
> > Subject: Re: JDBC configuration
> >
> > Hi there,
> >
> > I install the JDBC by following the instruction
> > http://trafodion.apache.org/docs/client_install/index.
> > html#_jdbc_based_clients.
> > When I tried to build and run the StatementSample test program to
> > verify JDBC Type-4 driver installation, the program was built without
> > errors. But there was a runtime exception. The outputs of the building
> > and running commands are as follows.
> >
> > $ $JAVA_HOME/bin/javac -classpath ../../lib/jdbcT4-2.1.0.jar *.java
> > ../common/*.java
> > Note: ../common/sampleUtils.java uses or overrides a deprecated API.
> > Note: Recompile with -Xlint:deprecation for details.
> >
> > $ $JAVA_HOME/bin/java -classpath ../../lib/jdbcT4.jar:..:.
> > -Dt4jdbc.properties=../t4jdbc.properties StatementSample
> > java.lang.ClassNotFoundException: org.trafodion.jdbc.t4.T4Driver at
> > java.net.URLClassLoader$1.run(URLClassLoader.java:359)
> > at java.net.URLClassLoader$1.run(URLClassLoader.java:348)
> > at java.security.AccessController.doPrivileged(Native Method) at
> > java.net.URLClassLoader.findClass(URLClassLoader.java:347)
> > at java.lang.ClassLoader.loadClass(ClassLoader.java:425)
> > at sun.misc.Launcher$AppClassLoader.loadClass(Launcher.java:312)
> > at java.lang.ClassLoader.loadClass(ClassLoader.java:358)
> > at java.lang.Class.forName0(Native Method) at
> > java.lang.Class.forName(Class.java:195)
> > at common.sampleUtils.(sampleUtils.java:72)
> > at StatementSample.main(StatementSample.java:41)
> > org.trafodion.jdbc.t4.T4Driver
> >
> > I checked that the class files (sampleUtils.class and
> > StatementSample.class) exist there. Does anybody know what is going
> > wrong here? I am running Trafodion in Linux system.
> >
> > Thank you.
> >
> > Best,
> > Bin
> >
> > On Thu, Aug 3, 2017 at 11:40 PM, Liu, Yuan (Yuan) <yuan@esgyn.cn>
> > wrote:
> >
> > > Yes, you built the server.  I don’t think you need to install
> trafci.zip.
> > >
> > >
> > > Best regards,
> > > Yuan
> > >
> > > -Original Message-
> > > From: Bin Lin [mailto:linbi...@gmail.com]
> > > Sent: Friday, August 04, 2017 1:03 PM
> > > To: dev@trafodion.incubator.apache.org
> > > 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

RE: JDBC configuration

2017-08-08 Thread Xu, Kai-Hua (Kevin) 
Hi Bin

I saw you were using jdbcT4-2.1.0.jar for compilation while jdbcT4.jar for 
running. Does the jadbcT.jar link to jdbcT4-2.1.0.jar? I doubt if it refs to 
the right jar.
> $ $JAVA_HOME/bin/javac -classpath ../../lib/jdbcT4-2.1.0.jar *.java 
> ../common/*.java
$ $JAVA_HOME/bin/java -classpath ../../lib/jdbcT4.jar:..:.
> -Dt4jdbc.properties=../t4jdbc.properties StatementSample

Best Regards,
Kevin Xu

-Original Message-
From: Bin Lin [mailto:linbi...@gmail.com] 
Sent: Wednesday, August 09, 2017 3:14 AM
To: dev@trafodion.incubator.apache.org
Subject: Re: JDBC configuration

Hi Kevin,

The output of your provided command are as follows.

*7048 Thu Apr 06 22:48:54 PDT 2017 org/trafodion/jdbc/t4/T4Driver.class*

On Mon, Aug 7, 2017 at 6:42 PM, Xu, Kai-Hua (Kevin) <kaihua...@esgyn.cn>
wrote:

> Hi Bin,
>
> Could you please check your ../../lib/jdbcT4-2.1.0.jar with following 
> command? Is there any difference for the package name 'org.trafodion' 
> or 'org.apache.trafodion'? if so, I think you may have to make the 
> changes in common/sampleUtils.java.
> jar -tvf ../../lib/jdbcT4-2.1.0.jar| grep T4Driver
>
>
> Kevin
>
> -Original Message-
> From: Bin Lin [mailto:linbi...@gmail.com]
> Sent: Tuesday, August 08, 2017 8:05 AM
> To: dev@trafodion.incubator.apache.org
> Subject: Re: JDBC configuration
>
> Hi there,
>
> I install the JDBC by following the instruction 
> http://trafodion.apache.org/docs/client_install/index.
> html#_jdbc_based_clients.
> When I tried to build and run the StatementSample test program to 
> verify JDBC Type-4 driver installation, the program was built without 
> errors. But there was a runtime exception. The outputs of the building 
> and running commands are as follows.
>
> $ $JAVA_HOME/bin/javac -classpath ../../lib/jdbcT4-2.1.0.jar *.java 
> ../common/*.java
> Note: ../common/sampleUtils.java uses or overrides a deprecated API.
> Note: Recompile with -Xlint:deprecation for details.
>
> $ $JAVA_HOME/bin/java -classpath ../../lib/jdbcT4.jar:..:.
> -Dt4jdbc.properties=../t4jdbc.properties StatementSample
> java.lang.ClassNotFoundException: org.trafodion.jdbc.t4.T4Driver at
> java.net.URLClassLoader$1.run(URLClassLoader.java:359)
> at java.net.URLClassLoader$1.run(URLClassLoader.java:348)
> at java.security.AccessController.doPrivileged(Native Method) at
> java.net.URLClassLoader.findClass(URLClassLoader.java:347)
> at java.lang.ClassLoader.loadClass(ClassLoader.java:425)
> at sun.misc.Launcher$AppClassLoader.loadClass(Launcher.java:312)
> at java.lang.ClassLoader.loadClass(ClassLoader.java:358)
> at java.lang.Class.forName0(Native Method) at
> java.lang.Class.forName(Class.java:195)
> at common.sampleUtils.(sampleUtils.java:72)
> at StatementSample.main(StatementSample.java:41)
> org.trafodion.jdbc.t4.T4Driver
>
> I checked that the class files (sampleUtils.class and
> StatementSample.class) exist there. Does anybody know what is going 
> wrong here? I am running Trafodion in Linux system.
>
> Thank you.
>
> Best,
> Bin
>
> On Thu, Aug 3, 2017 at 11:40 PM, Liu, Yuan (Yuan) <yuan@esgyn.cn>
> wrote:
>
> > Yes, you built the server.  I don’t think you need to install trafci.zip.
> >
> >
> > Best regards,
> > Yuan
> >
> > -Original Message-
> > From: Bin Lin [mailto:linbi...@gmail.com]
> > Sent: Friday, August 04, 2017 1:03 PM
> > To: dev@trafodion.incubator.apache.org
> > 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) <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.
>

Re: JDBC configuration

2017-08-08 Thread Bin Lin 
Hi Kevin,

The output of your provided command are as follows.

*7048 Thu Apr 06 22:48:54 PDT 2017 org/trafodion/jdbc/t4/T4Driver.class*

On Mon, Aug 7, 2017 at 6:42 PM, Xu, Kai-Hua (Kevin) <kaihua...@esgyn.cn>
wrote:

> Hi Bin,
>
> Could you please check your ../../lib/jdbcT4-2.1.0.jar with following
> command? Is there any difference for the package name 'org.trafodion' or
> 'org.apache.trafodion'? if so, I think you may have to make the changes in
> common/sampleUtils.java.
> jar -tvf ../../lib/jdbcT4-2.1.0.jar| grep T4Driver
>
>
> Kevin
>
> -Original Message-
> From: Bin Lin [mailto:linbi...@gmail.com]
> Sent: Tuesday, August 08, 2017 8:05 AM
> To: dev@trafodion.incubator.apache.org
> Subject: Re: JDBC configuration
>
> Hi there,
>
> I install the JDBC by following the instruction
> http://trafodion.apache.org/docs/client_install/index.
> html#_jdbc_based_clients.
> When I tried to build and run the StatementSample test program to verify
> JDBC Type-4 driver installation, the program was built without errors. But
> there was a runtime exception. The outputs of the building and running
> commands are as follows.
>
> $ $JAVA_HOME/bin/javac -classpath ../../lib/jdbcT4-2.1.0.jar *.java
> ../common/*.java
> Note: ../common/sampleUtils.java uses or overrides a deprecated API.
> Note: Recompile with -Xlint:deprecation for details.
>
> $ $JAVA_HOME/bin/java -classpath ../../lib/jdbcT4.jar:..:.
> -Dt4jdbc.properties=../t4jdbc.properties StatementSample
> java.lang.ClassNotFoundException: org.trafodion.jdbc.t4.T4Driver at
> java.net.URLClassLoader$1.run(URLClassLoader.java:359)
> at java.net.URLClassLoader$1.run(URLClassLoader.java:348)
> at java.security.AccessController.doPrivileged(Native Method) at
> java.net.URLClassLoader.findClass(URLClassLoader.java:347)
> at java.lang.ClassLoader.loadClass(ClassLoader.java:425)
> at sun.misc.Launcher$AppClassLoader.loadClass(Launcher.java:312)
> at java.lang.ClassLoader.loadClass(ClassLoader.java:358)
> at java.lang.Class.forName0(Native Method) at
> java.lang.Class.forName(Class.java:195)
> at common.sampleUtils.(sampleUtils.java:72)
> at StatementSample.main(StatementSample.java:41)
> org.trafodion.jdbc.t4.T4Driver
>
> I checked that the class files (sampleUtils.class and
> StatementSample.class) exist there. Does anybody know what is going wrong
> here? I am running Trafodion in Linux system.
>
> Thank you.
>
> Best,
> Bin
>
> On Thu, Aug 3, 2017 at 11:40 PM, Liu, Yuan (Yuan) <yuan@esgyn.cn>
> wrote:
>
> > Yes, you built the server.  I don’t think you need to install trafci.zip.
> >
> >
> > Best regards,
> > Yuan
> >
> > -Original Message-
> > From: Bin Lin [mailto:linbi...@gmail.com]
> > Sent: Friday, August 04, 2017 1:03 PM
> > To: dev@trafodion.incubator.apache.org
> > 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) <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
> > >
> >
>

RE: JDBC configuration

2017-08-07 Thread Xu, Kai-Hua (Kevin) 
Hi Bin,

Could you please check your ../../lib/jdbcT4-2.1.0.jar with following command? 
Is there any difference for the package name 'org.trafodion' or 
'org.apache.trafodion'? if so, I think you may have to make the changes in 
common/sampleUtils.java.  
jar -tvf ../../lib/jdbcT4-2.1.0.jar| grep T4Driver


Kevin

-Original Message-
From: Bin Lin [mailto:linbi...@gmail.com] 
Sent: Tuesday, August 08, 2017 8:05 AM
To: dev@trafodion.incubator.apache.org
Subject: Re: JDBC configuration

Hi there,

I install the JDBC by following the instruction 
http://trafodion.apache.org/docs/client_install/index.html#_jdbc_based_clients.
When I tried to build and run the StatementSample test program to verify JDBC 
Type-4 driver installation, the program was built without errors. But there was 
a runtime exception. The outputs of the building and running commands are as 
follows.

$ $JAVA_HOME/bin/javac -classpath ../../lib/jdbcT4-2.1.0.jar *.java 
../common/*.java
Note: ../common/sampleUtils.java uses or overrides a deprecated API.
Note: Recompile with -Xlint:deprecation for details.

$ $JAVA_HOME/bin/java -classpath ../../lib/jdbcT4.jar:..:.
-Dt4jdbc.properties=../t4jdbc.properties StatementSample
java.lang.ClassNotFoundException: org.trafodion.jdbc.t4.T4Driver at 
java.net.URLClassLoader$1.run(URLClassLoader.java:359)
at java.net.URLClassLoader$1.run(URLClassLoader.java:348)
at java.security.AccessController.doPrivileged(Native Method) at 
java.net.URLClassLoader.findClass(URLClassLoader.java:347)
at java.lang.ClassLoader.loadClass(ClassLoader.java:425)
at sun.misc.Launcher$AppClassLoader.loadClass(Launcher.java:312)
at java.lang.ClassLoader.loadClass(ClassLoader.java:358)
at java.lang.Class.forName0(Native Method) at 
java.lang.Class.forName(Class.java:195)
at common.sampleUtils.(sampleUtils.java:72)
at StatementSample.main(StatementSample.java:41)
org.trafodion.jdbc.t4.T4Driver

I checked that the class files (sampleUtils.class and
StatementSample.class) exist there. Does anybody know what is going wrong here? 
I am running Trafodion in Linux system.

Thank you.

Best,
Bin

On Thu, Aug 3, 2017 at 11:40 PM, Liu, Yuan (Yuan) <yuan@esgyn.cn> wrote:

> Yes, you built the server.  I don’t think you need to install trafci.zip.
>
>
> Best regards,
> Yuan
>
> -Original Message-
> From: Bin Lin [mailto:linbi...@gmail.com]
> Sent: Friday, August 04, 2017 1:03 PM
> To: dev@trafodion.incubator.apache.org
> 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) <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
> >
>

Re: JDBC configuration

2017-08-07 Thread Bin Lin 
Hi there,

I install the JDBC by following the instruction
http://trafodion.apache.org/docs/client_install/index.html#_jdbc_based_clients.
When I tried to build and run the StatementSample test program to verify
JDBC Type-4 driver installation, the program was built without errors. But
there was a runtime exception. The outputs of the building and running
commands are as follows.

$ $JAVA_HOME/bin/javac -classpath ../../lib/jdbcT4-2.1.0.jar *.java
../common/*.java
Note: ../common/sampleUtils.java uses or overrides a deprecated API.
Note: Recompile with -Xlint:deprecation for details.

$ $JAVA_HOME/bin/java -classpath ../../lib/jdbcT4.jar:..:.
-Dt4jdbc.properties=../t4jdbc.properties StatementSample
java.lang.ClassNotFoundException: org.trafodion.jdbc.t4.T4Driver
at java.net.URLClassLoader$1.run(URLClassLoader.java:359)
at java.net.URLClassLoader$1.run(URLClassLoader.java:348)
at java.security.AccessController.doPrivileged(Native Method)
at java.net.URLClassLoader.findClass(URLClassLoader.java:347)
at java.lang.ClassLoader.loadClass(ClassLoader.java:425)
at sun.misc.Launcher$AppClassLoader.loadClass(Launcher.java:312)
at java.lang.ClassLoader.loadClass(ClassLoader.java:358)
at java.lang.Class.forName0(Native Method)
at java.lang.Class.forName(Class.java:195)
at common.sampleUtils.(sampleUtils.java:72)
at StatementSample.main(StatementSample.java:41)
org.trafodion.jdbc.t4.T4Driver

I checked that the class files (sampleUtils.class and
StatementSample.class) exist there. Does anybody know what is going wrong
here? I am running Trafodion in Linux system.

Thank you.

Best,
Bin

On Thu, Aug 3, 2017 at 11:40 PM, Liu, Yuan (Yuan) <yuan@esgyn.cn> wrote:

> Yes, you built the server.  I don’t think you need to install trafci.zip.
>
>
> Best regards,
> Yuan
>
> -Original Message-
> From: Bin Lin [mailto:linbi...@gmail.com]
> Sent: Friday, August 04, 2017 1:03 PM
> To: dev@trafodion.incubator.apache.org
> 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) <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
> >
>

RE: JDBC configuration

2017-08-04 Thread Liu, Yuan (Yuan) 
Yes, you built the server.  I don’t think you need to install trafci.zip.


Best regards,
Yuan

-Original Message-
From: Bin Lin [mailto:linbi...@gmail.com] 
Sent: Friday, August 04, 2017 1:03 PM
To: dev@trafodion.incubator.apache.org
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) <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
>

Re: JDBC configuration

2017-08-03 Thread Bin Lin 
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)  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
>

RE: JDBC configuration

2017-08-03 Thread Liu, Yuan (Yuan) 
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