setting and using connection pools in serverside jdbc codes..please help
posted 16 years ago
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
posted 15 years ago
Hi Santosh please use the following as the parameter to the context.loolUp java:comp/env/jdbc/myDataSource instead of simply using myDataSource.