Win a copy of Head First Agile this week in the Agile forum!
  • Post Reply Bookmark Topic Watch Topic
  • New Topic

Axis Web Service not catching 0RA-28001 DB Password Expired exception  RSS feed

Mohith Sanjay
Posts: 1
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi everybody,

I am attempting to insert one row at a time to an Oracle DB, through an Axis Web Service. The DB connection is configured in the Tomcat server.xml. I am using preparedStatement.executeUpdate to run the insert query. It was working fine until the DB Password expired. The executeUpdate is returning 1 (ie. one row updated) but the data does not reach the DB. In the catalina.out, I am not seeing any exception either. I understand that since password has expired, data will not reach the DB. But my question is: Why is there no exception shown in catalina.out? How is executeUpdate returning 1? After resetting the password, I deliberately gave a wrong password and ran the client. This time, the ORA-01017: invalid username/password; logon denied exception came in catalina.out. Could someone explain what is happening? javascript:emoticon(''); Thanks in advance..
It is sorta covered in the JavaRanch Style Guide.
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!