RE: WAS 4.0 Datasource -- WDSCI-L

Chris

WAS Admin Console.

Seems that it is very strange about stopping/starting app servers/web apps.
Sometimes it does and sometimes it doesn't!

I think ive solved the naming problem by restarting the app server and the
web application, but im sure I did that before

Yes, I am using the libraries property, and that seems to be working now too

Cheers
Colin.W

-----Original Message-----
From: Price, Chris [mailto:chris_price@xxxxxxxxx] 
Sent: 13 January 2004 14:10
To: 'Websphere Development Studio Client for iSeries'
Subject: RE: [WDSCI-L] 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.
_______________________________________________
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