× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.


  1.  Home
  2. WDSCI-L
  3. January 2004

RE: WAS 4.0 Datasource

How are you configuring the WAS datasource - via the WAS Admin Console, or
some other way?

I've just checked my WAS installation, (which I haven't looked at in a
while).
We are using com.ibm.db2.jdbc.app.DB2StdConnectionPoolDataSource, as you had
originally, with properties defined for user, password, naming and
libraries.

Do you have a libraries property? As far as I know (which isn't much) you
don't need one, but try one if you haven't (either explicity setting the
libraries or using *libl.

Hope this helps,
Chris.

-----Original Message-----
From: Colin Williams [mailto:colin.williams@xxxxxxxxxxxx]
Sent: 13 January 2004 13:47
To: 'Websphere Development Studio Client for iSeries'
Subject: RE: [WDSCI-L] WAS 4.0 Datasource


Chris,

I change to using com.ibm.as400.access.AS400JDBCConnectionPoolDataSource and
driver=native instead of
com.ibm.db2.jdbc.app.DB2StdConnectionPoolDataSource,
But the naming=system parameter is still getting ignored. 

Anything else I can try?

Cheers


-----Original Message-----
From: Price, Chris [mailto:chris_price@xxxxxxxxx] 
Sent: 13 January 2004 12:55
To: 'Websphere Development Studio Client for iSeries'
Subject: RE: [WDSCI-L] WAS 4.0 Datasource


I belive so, although there are some differences in the options the two
drivers accept.

All the "normal" options, like naming are the same...

-----Original Message-----
From: Colin Williams [mailto:colin.williams@xxxxxxxxxxxx]
Sent: 13 January 2004 12:59
To: 'Websphere Development Studio Client for iSeries'
Subject: RE: [WDSCI-L] WAS 4.0 Datasource


Chris,

Will the toolbox driver then pass on the properties to the native driver?

Cheers
Colin.W

-----Original Message-----
From: Price, Chris [mailto:chris_price@xxxxxxxxx] 
Sent: 13 January 2004 12:49
To: 'Websphere Development Studio Client for iSeries'
Subject: RE: [WDSCI-L] WAS 4.0 Datasource



If you use the toolbox driver with the option "driver=native", then the
toolbox driver will select whether to use the native driver or the toolbox
driver, according to the location of the DB.

-----Original Message-----
From: Colin Williams [mailto:colin.williams@xxxxxxxxxxxx]
Sent: 13 January 2004 12:49
To: 'Websphere Development Studio Client for iSeries'
Subject: [WDSCI-L] WAS 4.0 Datasource


Guys,

Ive developed a web app in WDSC for deployment on WAS 4.0 Advanced.

This app uses dbbeans to access the database via WAS defined datasources
using connection pooling provided by the toolbox driver
com.ibm.as400.access.AS400JDBCConnectionPoolDataSource . 

I have gone through the pain barrier and this db access is mostly working.

This all works on WDSC, but I have come up against a problem when I deploy
to WAS 4.0.

When I want to access the local AS400, I use datasource defined using the
db2 native access provided by
com.ibm.db2.jdbc.app.DB2StdConnectionPoolDataSource. 

To allow me to use standard library list I set naming=system. For some
reason this property works fine with the toolbox driver, but seems to be
ignored by native driver.

Does anyone know why, and if there is a way round this. Ive tried
naming=sys, naming = system, naming=*SYS, still no joy.

Cheers
Colin.W

For the latest on Bertram Books products and services and for
up-to-the-minute book news visit www.bertrams.com


This e-mail and any attachments may contain information that is confidential
and privileged and is solely for the use of the intended recipient. If you
are not the intended recipient please notify the sender and delete this
e-mail and any attachments immediately







_______________________________________________
This is the Websphere Development Studio Client for iSeries  (WDSCI-L)
mailing list To post a message email: WDSCI-L@xxxxxxxxxxxx To subscribe,
unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/wdsci-l
or email: WDSCI-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/wdsci-l.
_______________________________________________
This is the Websphere Development Studio Client for iSeries  (WDSCI-L)
mailing list To post a message email: WDSCI-L@xxxxxxxxxxxx To subscribe,
unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/wdsci-l
or email: WDSCI-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/wdsci-l.

For the latest on Bertram Books products and services and for
up-to-the-minute book news visit www.bertrams.com


This e-mail and any attachments may contain information that is confidential
and privileged and is solely for the use of the intended recipient. If you
are not the intended recipient please notify the sender and delete this
e-mail and any attachments immediately







_______________________________________________
This is the Websphere Development Studio Client for iSeries  (WDSCI-L)
mailing list To post a message email: WDSCI-L@xxxxxxxxxxxx To subscribe,
unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/wdsci-l
or email: WDSCI-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/wdsci-l.
_______________________________________________
This is the Websphere Development Studio Client for iSeries  (WDSCI-L)
mailing list To post a message email: WDSCI-L@xxxxxxxxxxxx To subscribe,
unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/wdsci-l
or email: WDSCI-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/wdsci-l.

For the latest on Bertram Books products and services and for
up-to-the-minute book news visit www.bertrams.com


This e-mail and any attachments may contain information that is confidential
and privileged and is solely for the use of the intended recipient. If you
are not the intended recipient please notify the sender and delete this
e-mail and any attachments immediately







_______________________________________________
This is the Websphere Development Studio Client for iSeries  (WDSCI-L)
mailing list
To post a message email: WDSCI-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/wdsci-l
or email: WDSCI-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/wdsci-l.

As an Amazon Associate we earn from qualifying purchases.

This thread ...
Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.