Problem with Data Source, Please help..

[Jack Daniel]

Hi everybody,

Somebody has to help me please :-)

ok we were before working on J2ee web applications using Websphere Studio 3.5.3 and VisualAge for Java 3.5.3 on the development side and Websphere Application Server (WAS) 3.5.3 on the production side.

We have recently upgraded to
Websphere development studio client(WDSC) for iseries V5.1 ( development side) and WAS - Express on the production side;

Now for migrating the previous applications, ok i have initially migrated the application(s) to WDSC, that was fine and when I was testing the application on the development side server (WTE on WDSC) just like how i have done on (WTE on VAJ), I get into a problem when working with data source .


Firstly In visualAge for java, it was simple in testing with data source on the development server;

But when working with WDSC i am getting confused;no proper documentation..

I was looking at
http://publib.boulder.ibm.com/infocenter/iadthelp/index.jsp
and tried to figure out how to create a data source in WDSC for application testing on
Websphere Test environment (WTE),

If any of you guys can help me, that would be GREAT.


Ok, talking about the documentation:

I have supplied the following information: when I was testing my application

JDBC Provider: DB2 UDB for iSeries (Toolbox)
Implementation class: com.ibm.as400.access.AS400JDBCDriver

Is there any problem here??


and at the data source, I have mentioned the correct JNDI name that I have used in the application code;
but yeah I was wondering that definitely how can i get connected t the database, when I am not providing
the database URL anywhere... So I tried mentioning that in the
Resource Properties,.. but still I am not able to connect to database using a datasource..

Anybody has done this anytime before on WDSC for iSeries V5.1 (data source thing )

Also I can connect to the databse using the DATA perspective where I can query just like the SQL wizard;
So Is there a way I can get the connection to the data source from the connection I have at the Data Perspective??

Thanks a lot for your help
cheers

[Jim Hicks]

Its kind of hard to help when you don't list the exception. However, the driver I use in WDSC 5.1 is:

com.ibm.as400.access.AS400JDBCConnectionPoolDataSource

[Jack Daniel]

Hey Thanks

I have got it solved..

Cheers :-)

[Sudhir Meduri]

Similar problem I'm trying to connect Websphere 5.1 to MySQL
it says look up context error can not locate the implementation class
..MySQLConnectionPool class

I set the jar file in the Shared Libraries with node scope, wondering whats going wrong.

Need to say the doc's are not that friendly.

Any helpful ideas

Thanks

[Jack Daniel]

ohh, are you talking about the production server, WAS 5.1 ?? because the previous post was regarding development server included in WDSC 5.1;

As far as production server settings go, I am still to get out of the problem with EAR file deployment.

If I get any clue, i will let you know later..