You are viewing a plain text version of this content. The canonical link for it is here.

Posted to user@geronimo.apache.org by MShah <mo...@yahoo.com> on 2007/10/11 20:52:38 UTC

JDBC url to access a Geronimo connection pool?

I am using jtds jdbc driver to connect to sql server in my web application. 
I created a connection pool to connect to the specific MS SQL Server DB
instance, but my code requires a connection pool url, I am wondering what
that should be for geronimo to connect to SQL Server.  I have used weblogic
in the past and it has a url as jdbc:weblogic:pool:XXXXX

What is the equivalent of this for Geronimo?  Any inputs will be much
appreciated.

Thanks,
M. Shah
-- 
View this message in context: http://www.nabble.com/JDBC-url-to-access-a-Geronimo-connection-pool--tf4609299s134.html#a13162420
Sent from the Apache Geronimo - Users mailing list archive at Nabble.com.

Re: JDBC url to access a Geronimo connection pool?

Posted by David Jencks <da...@yahoo.com>.

On Oct 11, 2007, at 11:52 AM, MShah wrote:

>
> I am using jtds jdbc driver to connect to sql server in my web  
> application.
> I created a connection pool to connect to the specific MS SQL  
> Server DB
> instance, but my code requires a connection pool url, I am  
> wondering what
> that should be for geronimo to connect to SQL Server.  I have used  
> weblogic
> in the past and it has a url as jdbc:weblogic:pool:XXXXX
>
> What is the equivalent of this for Geronimo?  Any inputs will be much
> appreciated.

 From your description I don't understand what you have done.  How  
did you create the connection pool?  What code needs this url? What  
is it used for?

Normally to create a connection pool/datasource in geronimo you  
create a plan to deploy a tranql jdbc wrapper rar for the driver you  
are using.  You can to this by hand but usually it is more convenient  
to use the admin console database wizard.  I believe there is no  
mssql-specific support so you would have to use the generic tranql  
rar which only supports local transactions, not xa.  For this rar you  
would use whatever jdbc url is appropriate for the jtds driver you  
are using, which presumably is explained it its documentation.

Hope this helps
david jencks

>
> Thanks,
> M. Shah
> -- 
> View this message in context: http://www.nabble.com/JDBC-url-to- 
> access-a-Geronimo-connection-pool--tf4609299s134.html#a13162420
> Sent from the Apache Geronimo - Users mailing list archive at  
> Nabble.com.
>