.e r             r     * * *  8 9              W W W !"#$%&'()*+,-DDSFileLjava/lang/String;ConstraintExpressionsqlQuery iniFileName verboseOutputZdOutLjava/io/PrintStream;()VCodeLineNumberTableLocalVariableTablethisLdods/servers/sql/JDBCTest;main([Ljava/lang/String;)VstmntLjava/sql/Statement;rsLjava/sql/ResultSet;eLjava/lang/Throwable;args[Ljava/lang/String;jdbct Exceptions. connect2DB()Ljava/sql/Statement;tmp"Ljava/lang/ClassNotFoundException;connLjava/sql/Connection;stmt jdbcDriver connectionURLunamepasswordinfLdods/util/iniFile;/0 processResult(Ljava/sql/ResultSet;)ZcIresultmetaLjava/sql/ResultSetMetaData;countlimitdoneprintColumnNames(Ljava/sql/ResultSetMetaData;)Vnametypeim metaStuff parse_options([Ljava/lang/String;)ZargretValgLgnu/getopt/Getopt; SourceFile JDBCTest.java |}DODS.ini wtSELECT * FROM * vt1 2{ z{dods/servers/sql/JDBCTest +-------------------------------------------3 45java/lang/StringBuffer .ini File: 67 89 SQL Query: Attempting to Connect to DBMS. Connected to database.Sending Query.: ;<Got ResultSet From DBMS. 4 Your Query Produced No Matches in The Database. =}java/lang/Throwable ERROR of Type: >?@ A9  Message: B9 Stack Trace: CD EForacle.jdbc.driver.OracleDriver0jdbc:oracle:thin:@whsun4.wh.whoi.edu:1526:nefsc2dods/util/iniFile |5JDBC GHdriver IJ connectionurlusernameUsing JDBC Driver: Using Connection URL: Using user: Using Password: KL java/lang/ClassNotFoundExceptionjava/sql/SQLException! Cannot Load JDBC Driver Class: ' Is the driver name spelled correctly?$ Is the .class file or the jar file- containing the driver on the CLASSPATH ?? Attempting to getConnection()M NOAttempting to createStatement()P QR STU VW XY Z[ xynull  \5 Scanned 6] rows... ^[ _[NULL () ` aW-gnu/getopt/GetoptJDBCTestq:i:v:h: |b cW d9nullVerbose Output: ON  iniFile: "" s*******************************************************************************************************************Usage:.JDBCTest [-q "SqlQuery"] [-v] [-i iniFileName]Where:E -q "SqlQuery" = This option specifies the SQL query for the DBMS._ SqlQuery must be a correctly formatted SQL Query for the target database.8 (It should be a SELECT statement.)= And it must be contained in quotes (").L -v = Turns on verbose mode. (This will show you all of the returned data% from the DBMS. Default: offV -i iniFileName = The name of the .ini file containing all of the JDBC information.1 The file MUST BE in your home directory. Default: "DODS.ini" Examples:R java dods.servers.sql.JDBCTest -q "Select distinct instrument_id from drifter"U java dods.servers.sql.JDBCTest -v -q "Select distinct instrument_id from drifter"a java dods.servers.sql.JDBCTest -v -i "my.ini -q" "Select distinct instrument_id from drifter"java/lang/Objectjava/lang/Exceptionjava/io/FileNotFoundExceptionjava/io/IOExceptionjava/lang/Systemoutjava/io/PrintStreamprintln(Ljava/lang/String;)Vappend,(Ljava/lang/String;)Ljava/lang/StringBuffer;toString()Ljava/lang/String;java/sql/Statement executeQuery((Ljava/lang/String;)Ljava/sql/ResultSet;closegetClass()Ljava/lang/Class;java/lang/ClassgetName getMessageprintStackTrace(Ljava/io/PrintStream;)Vexit(I)V setSection(Ljava/lang/String;)Z getProperty&(Ljava/lang/String;)Ljava/lang/String;forName%(Ljava/lang/String;)Ljava/lang/Class;java/sql/DriverManager getConnectionM(Ljava/lang/String;Ljava/lang/String;Ljava/lang/String;)Ljava/sql/Connection;java/sql/ConnectioncreateStatementjava/sql/ResultSet getMetaData()Ljava/sql/ResultSetMetaData;java/sql/ResultSetMetaDatagetColumnCount()Inext()Z getString(I)Ljava/lang/String;print(I)Ljava/lang/StringBuffer; getColumnNamegetColumnTypeNamejava/lang/Stringlength:(Ljava/lang/String;[Ljava/lang/String;Ljava/lang/String;)Vgetopt getOptarg!r st ut vt wt xy z{|}~O*,- ./1  ~Y L+W*   Y  Y  M,   ,N-  -  , `M Y,   Y!,"  # ,$% &j6;=>4?OBWC[E_FgHoIyK}LOPRU^XYZ[\]`a4[Gy)\ ~'1KL'M(N):):*Y+:,-L:./:M0/:N1/::2/:: Y3,  Y4-  Y5  Y6 ,7W3:9Y Y:;<=>?@ -AKB *CL+8zhimn optv(w+y4z<|E}MV_hq (/\ +Ft./-*t 't#tt9 ~S*DL+E=+F>6*Gb]6@*H:I* J  YKLI )  YMNO N%.8>CKekyH8-t(Cy9 ~m*E<)M>[*P:*Q: R:# YST: Y,M>,UVL) , >,UVL) R #(/Ocis{RIt#@t ]k t9 ~yq<WYX*YZM,[Y>Yhivq*va,\: Y] LI,\:^L,\: Y_]`LNF,\:a b c d e f g h i j k l m ) n o p q a <' DJsx{ #$%&+-./0123 456"7*829::B;J<R=Z>b?j@lAoERJ1t t6ttqoyb\