Member Avatar for Ansraj

Please give me solution for this problem problem while connecting DB2 database with JSP in netbeans on Windows 7 ultimate 64bit platform......
Error code that is appear on the browser while running connectivity code is->
"Failure in loading native library db2jcct2, java.lang.UnsatisfiedLinkError: C:\Program Files\IBM\SQLLIB\BIN\db2jcct2.dll: Can't load AMD 64-bit .dll on a IA 32-bit platform: ERRORCODE=-4472, SQLSTATE=null"

Edited by peter_budo because: MOving to JSP section
  • 3 Contributors
  • 2 Replies
  • 164 Views
  • 1 Month Discussion Span
  • Latest Post Latest Post by okule

Recommended Answers

All 2 Replies

Member Avatar for SagarSe7en

Please Provide some code.

No Code Means No HELP.

Member Avatar for okule

When use type2 driver, error occurs, but when use type4 driver, no error.

When use connection pooling, you need to set propertie of driverType(Set to 4).
http://docs.oracle.com/cd/E18930_01/html/821-2416/beamw.html#glhim

When use not connection pooling and use java program that uses jdbc driver, As described below, you need to do the programming

conn = DriverManager.getConnection("jdbc:db2://localhost:50000/mydb", "user", "password");

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.