wood burning stoves 2.0*
The moose likes BEA/Weblogic and the fly likes setting and using connection pools in serverside jdbc codes..please help Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Products » BEA/Weblogic
Bookmark "setting and using connection pools in serverside jdbc codes..please help" Watch "setting and using connection pools in serverside jdbc codes..please help" New topic
Author

setting and using connection pools in serverside jdbc codes..please help

santosh vashist
Greenhorn

Joined: May 14, 2001
Posts: 25
hi all,
i am using mssqlserver4 driver to connect to database..
i have set the properties in weblogic.properties file..
i have also set
weblogic.jdbc.datasource.myDatasource=SQLPOOL..
where SQLPool is my connection pool name..
1.now tell me.."mydatasource" becomes the JNDI name
which has to be connected as
javax.sql.Datasorce ds=(javax.sql.datasource) ctx.lookup("mydatasource");
i have followed these steps but when i run the code..
it just prints
"mydatasource"
and stops...why so?
Does the Jndi name has to be given according to the directory structure or..so
like
weblogic.jdbc.datasource.weblogic.jdbc.jts.SQLPool=SQLPool..
i am confused...
is mssqlserver a txdadatasource or just datasource..
please help me
santhosh
Ram Kondawar
Ranch Hand

Joined: May 29, 2001
Posts: 42
Hi Santosh
please use the following as the parameter to the context.loolUp
java:comp/env/jdbc/myDataSource
instead of simply using myDataSource.
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: setting and using connection pools in serverside jdbc codes..please help
 
Similar Threads
database connection pooling with weblogic 8.1
JNDI datasource
Problem starting WTE in WSAD 5.0.1
please help me
How to bind DataSource using context.bind. Connection pooling etc.