Groups > IBM > WebSphere Integration Developer > Re: WESB 6.1. Database access




WESB 6.1. Database access

WESB 6.1. Database access
Mon, 07 Apr 2008 04:52:10 EDT
Hi All,<br />
<br />
I'd like to call some sql statements against an external rdbs from within my
custom java component code.<br />
<br />
Is there a way to setup a pool of connections on the WESB server (was) and have
them available to be used from within the java code when needed without having
to create and connect yourself?<br />
<br />
Thanks heaps in advance.<br />
<br />
Cheers.<br />
<br />
Post Reply
Re: WESB 6.1. Database access
Mon, 07 Apr 2008 10:40:28 EDT
Post Reply
Re: WESB 6.1. Database access
Mon, 7 Apr 2008 12:28:23 -0400
Google for "JDBC DataSource WEbSphere Application Server" Thats what
you are 
looking for. You setup the datasource on the server, then just use JNDI to 
grab it and get connections. They'll come from a pool yadda yadda yadda

-- 
Dan Zrobok -Technical Architect - Perficient
WID/WPS/WESB Blog: http://blog.danzrobok.com


<dwforums@us.ibm.com> wrote in message 
news:1759694670.1207558360942.JavaMail.wassrvr@ltsgwas009.sby.ibm.com...
> Hi All,<br />
> <br />
> I'd like to call some sql statements against an external rdbs from within 
> my custom java component code.<br />
> <br />
> Is there a way to setup a pool of connections on the WESB server (was) and

> have them available to be used from within the java code when needed 
> without having to create and connect yourself?<br />
> <br />
> Thanks heaps in advance.<br />
> <br />
> Cheers.<br />
> <br />
> Boris. 

Post Reply
about | contact