Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
kondaluavula
Starting Member
2 Posts |
 Posted - 2008-10-13 : 09:12:21
|
| Hi Friends, I had problem with sql query insertion and updation. these 2 queries will be working fine in console but the problem is the values can not be inserted to the Database. my code is Connection con = connections.getConnection("Test"); PreparedStatement recInsert = con.prepareStatement("insert into searchable_cataloguerecord(cataloguerecordid,owner_library_id,wholecataloguerecord,xml_wholerecord) values(?,?,?,?)"); PreparedStatement pstmt = con.prepareStatement("update searchable_cataloguerecord set wholecataloguerecord=?,xml_wholerecord=? where cataloguerecordid=? and owner_library_id=?"); recInsert.setInt(1, 3); recInsert.setInt(2, 1); recInsert.setString(3, text); recInsert.setString(4, newXml); recInsert.executeUpdate();If any one have an idea of this help meThanks & Regards,Edukondalu Avula |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2008-10-13 : 09:14:00
|
What is the tool you use?
E 12°55'05.63"N 56°04'39.26" |
 |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-10-13 : 09:30:17
|
| is it that you're getting error or is it that your values are not correctly inserted/updated? |
|
|
|
kondaluavula
Starting Member
2 Posts |
Posted - 2008-10-14 : 01:36:42
|
quote:
Originally posted by visakh16
is it that you're getting error or is it that your values are not correctly inserted/updated?i am not get any errors in console
|
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-10-14 : 01:38:31
|
quote:
Originally posted by kondaluavula
quote:
Originally posted by visakh16
is it that you're getting error or is it that your values are not correctly inserted/updated?i am not get any errors in console
then explain what discrepancy you're finding with inserted data with some sample |
|
|
|
|
|
|
|
|
i had problem with sql query insertion