problrm in prepared statement
[283 byte] By [fredyd] at [2007-9-26 3:47:54] 
I am trying to updating a table using prepared statement using executeupdate(). I need to write to a reject file if my update fails , the rejected resultset. I have tried to use getresultset() on preparedstatement and it does not work. any sugessions please.fred
Hi,
An executeUpdate returns to you an integer and not a resultset.Hence you won't be getting any resultset.You can try checking for a nonzero number returned by executeUpdate() to signify a sucess.
Hope this will help you.
Anil.
Developer Technical Support.
Sun Microsystems,India.
http://www.sun.com/developers/support
ramanil_indts at 2007-6-29 12:31:02 >
Database Connectivity New Topic
- What is the best way to use Date object with JDBC?
- JDBC_ODBC connection through servet
- no suitable driver
- jdbc Applet -Access connection
- Help!! Cannot use updatable resultset with MS access
- HELP-Resultset method: getString w/ LONGVARCHAR
- Oracle Connection Pooling
- A great help required...for a jdbc driver..free one
Database Connectivity Hot Topic
Database Connectivity
All Classified
- Archived Forums
- Enterprise & Remote Computing
- Java Essentials
- Desktop
- Core
- Solaris Operating System
- Security
- Database Connectivity
- Java Mobility Forums
- Web & Directory Servers
- Development Tools
- Application & Integration Servers
- Java HotSpot Virtual Machine
- Other Topics
- E-Mail, Calendar, & Collaboration
- Developer Tools
- General
- Administration Tools
- Sun Hardware
- Storage Forums
- Java Enterprise System
- StarOffice
- Open Source Technologies
- BigAdmin
- Real-Time
- Java Coding