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.<clinit>(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
> > > >
> > >
> >
>

Reply via email to