Win a copy of Programmer's Guide to Java SE 8 Oracle Certified Associate (OCA) this week in the OCAJP forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

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

 
santosh vashist
Greenhorn
Posts: 25
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 42
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi Santosh
please use the following as the parameter to the context.loolUp
java:comp/env/jdbc/myDataSource
instead of simply using myDataSource.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic