File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
The moose likes Servlets and the fly likes JDBC Parameters as Context Parameters? Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Java » Servlets
Bookmark "JDBC Parameters as Context Parameters?" Watch "JDBC Parameters as Context Parameters?" New topic
Author

JDBC Parameters as Context Parameters?

Jenn Person
Ranch Hand

Joined: Jan 16, 2005
Posts: 89
I have my JDBC parameters set as context parameters in my web.xml file as such:



Is this ok to do? Or a bad idea? I know it works, and did it primarily so I could maintain these attributes through just the web.xml file.
[ March 29, 2007: Message edited by: Jenn Person ]
Sunil Vasudevan
Ranch Hand

Joined: Mar 05, 2007
Posts: 107
It is OK to do what you are doing.

But a better approach is to let your Web/App server handle database connections. They handle it in a more efficient manner.

Which web/app server are you using?
[ March 30, 2007: Message edited by: Sunil Vasudevan ]

Sunil.V<br />SCJP2, SCWCD1.4, SCBCD1.3
Rahul Bhattacharjee
Ranch Hand

Joined: Nov 29, 2005
Posts: 2308
Why do not you use the connection pool provided by the container as Sunil mentioned? Or , if you want to go by this approach then it would be bettter to have a db.properties file within your application , which would have all the connection related parameters.


Rahul Bhattacharjee
LinkedIn - Blog
A Kumar
Ranch Hand

Joined: Jul 04, 2004
Posts: 979
If it is for learning purposes..how to use context parameters then it is fine..

But for an application in production environment ,it is better to go by what the others mentioned in the above posts...
Deepan Devadasan
Ranch Hand

Joined: Jan 25, 2007
Posts: 226
Hi Folks...

I am curious to learn things, what you mentioned as 'other' methods...

How does Container/Server Managed DB connections or connection pooling work...

Please advice me on the above


Theepan Thevathasan
SCJP 1.4, SCWCD 1.4, SCMAD 1.0 SCBCD 1.3, MCP(.Net Frm 2.0 App Dev Fdn)
Jenn Person
Ranch Hand

Joined: Jan 16, 2005
Posts: 89
I've never used, or been aware of , a connection pool. I'll have to look into that.

Otherwise, besides less efficiency, are there any other setbacks to making them context parameters in terms of security perhaps?
Rahul Bhattacharjee
Ranch Hand

Joined: Nov 29, 2005
Posts: 2308
I do not see and security threat to your approach as this (web.xml) would be within the WEB-INF directory.In fact I have worked on some application where some parameters are passed to the application using the init-param.
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: JDBC Parameters as Context Parameters?