column « result « Java Database Q&A

1. jdbc result set metadata: getting physical column names on aliased columns

I'm using jdbc to execute query statements (in jruby)

# made-up example
sql = "select " +
         "c.type as cartype, " +

2. Supressing Null column in a Result Set

Hi All How can we suppress a Null column in a reslutset? I mean, suppose a table has three columns and only two columns has data and the third column is entirely Null, when i fetch the resultset, i get this null column also. But while using this result set i have to suppress the empty column. How can this be ...