WEIRD problem - JDBC oracle driver
I am not quite sure if this is the right place to place my question, but since I am in desperation, I will do so with your understanding.
I have a JSP web application running on a windows box. On the server I have a bunch of classes. One of the classes makes a connection to Oracle 10g database. It, however, used to talk to Oracle 9i. Everything worked well in 9i, but now it cannot perform anything with Clobs for some odd reason.So, what I did was to recompile the class with Oracle 10g jdbc drivers. I moved the recompiled class over to our test box, and BAM it worked great! However, when I moved it to our production server, it still gives out the same error message. I HAVE NO IDEA WHY THIS IS HAPPENING. The production and the test boxes are identical.Does anyone have any clues as to why this is happening? What I have believed is that the classes are self-contained, meaning they do NOT dynamically link to other classes. But, I am getting very skeptical about this. It seems like my problem happens because my app tries to load the oracle jdbc on the fly. However, the funny thing is CLASSPATH is not even set on the machines. I guess TOMCAT has its own CLASSPATH? I am not so sure.
I am very sorry about babbling, but I have been struggling with this problem for way too long.
ANY help or comments (even some word of encouragement) would be greatly appreciated.
