• Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other Pie Elite all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Jeanne Boyarsky
  • Ron McLeod
  • Paul Clapham
  • Liutauras Vilda
Sheriffs:
  • paul wheaton
  • Rob Spoor
  • Devaka Cooray
Saloon Keepers:
  • Stephan van Hulst
  • Tim Holloway
  • Carey Brown
  • Frits Walraven
  • Tim Moores
Bartenders:
  • Mikalai Zaikin

Problem with Data Source, Please help..

 
Ranch Hand
Posts: 163
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
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
 
Greenhorn
Posts: 11
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
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
Ranch Hand
Posts: 163
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Hey Thanks

I have got it solved..

Cheers :-)
 
Greenhorn
Posts: 22
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
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
Ranch Hand
Posts: 163
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
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..
 
I knew I would regret that burrito. But this tiny ad has never caused regrets:
a bit of art, as a gift, that will fit in a stocking
https://gardener-gift.com
reply
    Bookmark Topic Watch Topic
  • New Topic