Jenny, Looks like you are getting an SQL Exception and the code is not able to access the message file to tell you what the exception is. This could be a problem with the way the JDBC Driver is installed. Could you check that this file is available in the JDBC Driver zip file... If u are using Oracle, I presume u would have classes12.zip somewhere in your path...

Best Regards,<br />Nagendra Prasad.

Jian Yi
Ranch Hand

Joined: Feb 01, 2002
Posts: 127

posted Aug 19, 2003 07:47:00

0

Thanks a lot!!! It's working!!! wow~~~

Jian Yi
Ranch Hand

Joined: Feb 01, 2002
Posts: 127

posted Aug 19, 2003 08:04:00

0

Hi Prasad, Shall I close the DataSource and Context at the end? I know I need to close the connection. But not sure about those two. Thanks, Jenny

I think DataSource handling is Websphere's job in this case ... Bhupesh

Nagendra Prasad
Ranch Hand

Joined: Jul 11, 2002
Posts: 219

posted Aug 29, 2003 05:25:00

0

Hi Jenny, Sorry was not tracking this post for some time.. you might have had all your queries resolved by now.. but a pointer all the same: the datasource is generally initialised the first time anything is needed from the system. Then we use it to obtain the connections we need. We close the connections etc once we are done with the 'SQL' bit in the code. typically this is the logic used: (Please not this is sytactically incomplete)

So... you dont do anything to the datasource or the initial context. You limit your activities to the connections!