1 21 22 package org.apache.derbyTesting.functionTests.tests.jdbcapi; 23 24 import java.sql.Connection ; 25 import java.sql.DriverManager ; 26 import java.sql.ResultSetMetaData ; 27 import java.sql.ResultSet ; 28 import java.sql.Statement ; 29 import java.sql.SQLException ; 30 import java.sql.Types ; 31 32 import org.apache.derby.tools.ij; 33 import org.apache.derby.tools.JDBCDisplayUtil; 34 35 import org.apache.derbyTesting.functionTests.util.TestUtil; 36 37 43 44 public class resultsetJdbc20 { 45 private static String [] testObjects = { "TABLE T"}; 46 public static void main(String [] args) { 47 Connection con; 48 ResultSetMetaData met; 49 ResultSet rs; 50 Statement stmt; 51 52 String [] columnNames = {"i", "s", "r", "d", "dt", "t", "ts", "c", "v", "dc"}; 53 54 System.out.println("Test resultsetJdbc20 starting"); 55 56 try 57 { 58 ij.getPropertyArg(args); 61 con = ij.startJBMS(); 62 stmt = con.createStatement(); 63 TestUtil.cleanUpTest(stmt, testObjects); 65 66 stmt.execute("create table t (i int, s smallint, r real, "+ 70 "d double precision, dt date, t time, ts timestamp, "+ 71 "c char(10), v varchar(40) not null, dc dec(10,2))"); 72 stmt.execute("insert into t values(1,2,3.3,4.4,date('1990-05-05'),"+ 73 "time('12:06:06'),timestamp('1990-07-07 07:07:07.07'),"+ 74 "'eight','nine', 10.1)"); 75 76 rs = stmt.executeQuery("select * from t"); 77 met = rs.getMetaData(); 78 79 int colCount; 80 System.out.println("getColumnCount(): "+(colCount=met.getColumnCount())); 81 82 for (int i=1;i<=colCount;i++) { 84 if (i==2 && (met.getColumnClassName(i).equals("java.lang.Short"))) 87 { 88 System.out.println("getColumnName("+i+"): "+met.getColumnName(i)); 89 System.out.println("FAIL: should be java.lang.Integer - but is java.lang.Short. see beetle 5775"); 91 } 92 else 93 { 94 System.out.println("getColumnName("+i+"): "+met.getColumnName(i)); 95 System.out.println("getColumnClassName("+i+"): "+met.getColumnClassName(i)); 96 } 97 } 98 99 rs.close(); 100 101 TestUtil.cleanUpTest(stmt, testObjects); 102 stmt.close(); 103 con.close(); 104 105 } 106 catch (SQLException e) { 107 dumpSQLExceptions(e); 108 e.printStackTrace(); 109 } 110 catch (Throwable e) { 111 System.out.println("FAIL -- unexpected exception: "+e); 112 e.printStackTrace(); 113 } 114 115 System.out.println("Test resultsetJdbc20 finished"); 116 } 117 118 static private void dumpSQLExceptions (SQLException se) { 119 System.out.println("FAIL -- unexpected exception"); 120 while (se != null) { 121 System.out.println("SQLSTATE("+se.getSQLState()+"): "+se); 122 se = se.getNextException(); 123 } 124 } 125 126 } 127 | Popular Tags |