column « JDBC « Java Database Q&A





1. How do I check to see if a column name exists in a CachedRowSet?    stackoverflow.com

I am querying data from views that are subject to change. I need to know if the column exists before I do a crs.get*X*().I have found that I can query the ...

2. PreparedStatement, how can i skip a column?    coderanch.com

Hi, I want to insert values into a table that has four columns, I only want to update columns one and three though! Sometimes I will be doing an update instead and will update columns 2,3 and 4. My problem is that I keepp getting requested to update the second column, when in fact i want the value there to remain ...

4. Is there a way to setXXX a column to DEFAULT in a PreparedStatement?    coderanch.com

Thanks for the reply Dave! Unfortunately that defeats the point of using a PreparedStatement in preference of a plain old Statement. I would like to have a single prepared statement for this type of query, and execute it multiple times in a loop, setting different values from different columns. During some iterations, I will need to insert using the column's default ...

5. preparedStatement - increase column value    coderanch.com

Hello all! i would like to do the following: there is a table in my database with several columns. i want to increase the value in one of them. Which one is not known, it depends on the value of one parameter of the function . i declare using preparedStatement.setString() which column is to be changed. My problem is that i ...