This week's book giveaway is in the OO, Patterns, UML and Refactoring forum. We're giving away four copies of Refactoring for Software Design Smells: Managing Technical Debt and have Girish Suryanarayana, Ganesh Samarthyam & Tushar Sharma on-line! See this thread for details.
Try setInt(). If that doesn't work, then you can try this technique. psuedo-code 1. Get a database connection. 2. Get the metadata object. 3. Execute a getColumns() on that table. 4. Find the correct column name and get its column type from the result set. 5. Using the column type as the type for your setXXX() statement. -Peter [This message has been edited by Peter Tran (edited January 16, 2001).]