Can I use this datasource from a JSP to access the database ?
Yes you can, but not recommended. JSPs are meant for just rendering the view
If yes can someone point me to a code example ?
Here's an example:
2 >The above file is located here :: JBOSS_HOME\server\default\deploy
Does this mean that if I have two applications A & B - they can both access the same DB using this Datasource ?
Yes, they can through JNDI lookup.
Can I make the datasource more private ( as in only visible to my application ? )
You can package the datasource within your application instead of placing it in the deploy folder. But once its available in the JNDI namespace, it can be looked up by other applications, provided they know the jndi-name of your datasource.