Trivial connectivity issue
i am using Result Set to get the output of my select statement of my prepared statement . But the problem is that when i am using Class.forName() and driver manager to set up the connection i am able to succesfully get the results in the result set for all the cases. But if am using data sources provided by application server WebSphere to make the connection i am not able to get the results fro certain cases. i am using struts framework.
[448 byte] By [
atin.sooda] at [2007-11-27 1:18:34]
# 1
I suspect your WebSphere datasource configuration.See http://publib.boulder.ibm.com/infocenter/wsphelp/index.jsp?topic=/com.ibm.faq.wsad/html/Server/1113202.htmlfor more information.btw, did you add the jdbc driver to your WebSphere common libraries ?
# 2
> I suspect your WebSphere datasource configuration.
> See
> http://publib.boulder.ibm.com/infocenter/wsphelp/index
> .jsp?topic=/com.ibm.faq.wsad/html/Server/1113202.html
> for more information.
>
> btw, did you add the jdbc driver to your WebSphere
> common libraries ?
If that would have been the case as pointed out by you then it should not work for nay query... but as specified be me.. i m getting this problem for a limited number of cases,
# 4
> are you using the same jdbc driver in your code and
> with websphere datasource ?
I guess yeah but not very sure on this... But will it make such a big diffference... M not able to understand the fact that why is the query failing for only a few conditions. It is just a simple select query having only one paramater in where clause.. Only for some value of this parameter the query is not returning any result if i m using datasource of WebSphere and not the Class.forName() approach
