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:[email protected]] Sent: Wednesday, August 09, 2017 3:14 AM To: [email protected] 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) <[email protected]> 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:[email protected]] > Sent: Tuesday, August 08, 2017 8:05 AM > To: [email protected] > 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) <[email protected]> > 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:[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 > > > > > >
