Java Database Connectivity (JDBC)

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

[SQLServer JDBC Driver]No rows affected.

843859Nov 7 2006 — edited Nov 19 2006

hi

iam getting the following exception when iam trying to insert a record in the table

the query is

insert into archived_table
(schedule_log_key, archived_table_id, campaign_sskey)
VALUES( 12925, 'o3611AYI_SW5IwSTxmPPYoECyHC6i1wTGLW3TAGiUTiWY', '33339')

java.sql.SQLException: [epy][SQLServer JDBC Driver]No rows affected.
at com.epy.jdbc.base.BaseExceptions.createException(Unknown Source)
at com.epy.jdbc.base.BaseExceptions.getException(Unknown Source)
at com.epy.jdbc.base.BaseStatement.executeUpdateInternal(Unknown Source)
at com.epy.jdbc.base.BaseStatement.executeUpdate(Unknown Source)
at com.epy.db.EpiStatement.executeUpdate(EpiStatement.java:452)

this is happening when iam executing number of threads at a time, and iam synchronizing the insertion code. no problem with the unique/fK/PK keys. only one or two threads are giving this error and remaining threads executing succesfully. .

any one aware of this problem, please help me.
thanks in advance..

Locked Post

New comments cannot be posted to this locked post.

Locked on Dec 17 2006

Added on Nov 7 2006

#java-database-connectivity-jdbc

3 comments

665 views