example application for jdbc

[vkviswanadh]

Hi , can any body give any link or any help, to write a small application which will have a data source (since I am little bit confused with these configuration files which are needed to change while writing a jdbc application or any EJB application [DAO class] ) , and calling that data source from a stand alone program.

Thanks
vvk

[jaikiran]

For configuring a datasource, you just need a *-ds.xml file which needs to be placed in the server/< serverName>/deploy folder. For more details about how to configure a datasource, have a look at http://wiki.jboss.org/wiki/Wiki.jsp?page=ConfigDataSources. That wiki article also has specific examples for different databases. Once you have successfully deployed the datasource, in order to use this datasource, you will have to do a JNDI lookup in your code as follows:

Context ctx = new InitialContext();
Datasource ds = (Datasource) ctx.lookup("java:/TheJNDINameThatYouSpecifiedForYourDatasource");

calling that data source from a stand alone program.

Have a look at http://wiki.jboss.org/wiki/Wiki.jsp?page=HowCanIAccessADataSourceFromAClient