hi everybody, i am chaitanya, i have a serious problem with tomcat6.0 server. i am struggling since 2 days.
Previously i developed a web application using websphere application server. now i migrated my server from websphere application server to tomcat6.0 server.
previously i developed the application with websphere and java1.4 and ibm db2.
i am using ibm db2 database. i used user dsn to connect to database through my application. it was successful. recently i came to know that we have to use system dsn to connect to database. i modified the connection. again it was a success.
now i migrated to tomcat6.0 and java1.5 and ibmdb2.
i just deployed my application on tomcat6.0. the deployment was successful. when i am trying to execute the project an error is coming. the application is unable to connect to database.
this is the error message when i am trying to connect with system dsn.
----------------java.sql.SQLException: [IBM][CLI Driver][DB2/NT] SQL0204N "SYSTEM.EMP_DETAILS" is an undefined name. SQLSTATE=4270
this is the error message when i am trying to connect with user dsn.
----------------java.sql.SQLException: [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified
i thought that the problem is with java1.5. so i reconfigured the server with java1.4. the installation of tomcat6.0 was sucess. but the server is not starting. so i once again reconfigured the server with java1.5. then the server started. why is this happening?
i thought that the problem lies with the database so i shifted the database to oracle. then also the same problem is arising.
Hi Anusha. DON'T use the JDBC/ODBC bridge driver. It's water buffalo dung, except that if you spread it on plant's they'll die. It's only intended as a last-resort facility when no better driver is available. In the case of DB2, IBM provides several native DB2 UDB JDBC drivers and you should be using one of those.
An IDE is no substitute for an Intelligent Developer.