Hi,
I am migrating my application from MSSQL to DB2. I had some issues
with JDBC/data type, but i was able to fix those issue except this
one.

When i run my web application, i can't update any record. using this
query.
update xyz set abc = '1' where pqr = '3'
I am using tomcat 5.0.28 and JDK 1.4.x

Where am I doing wrong. I am sure this is authentication issue. I am
using DB2ADMIN user. I can do all operations (select/insert/delete/
alter) using DB2 Admin console. but when i use tomcat/web apps, i can
only use select query.

Also, i have observed DB2 is very strict on data type while using
Prepared Statement.

So i can't do this
pstmt.setString (1, '2') if the data type of 1 is Int

Pls confirm if i am correct.

Any help is very much appreciated.

Thanks and best Regards,
Biswa.

On 2011-10-04 10:45, Biswa wrote:
What SQL error message do you get?

[...]

/Lennart

Hi Lennart,
Thank you for your reply. Sorry I was not able to get back earlier. I
was dead busy, all is good now. Application successfully migrated and
running on DB2. It was merely an authentication issue.

Thank you for your attention.

Best Regards,
Biswa.