Are you looking for this piece of code?

  | // get data base connection
  | Context ctx = new InitialContext();
  | DataSource ds = (DataSource) ctx.lookup("java:/MyDS");
  | conn = ds.getConnection();
  | 
  | // get data base driver     
  | Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
  | 
  | // Execute the select
  | pstmtSelect = conn.prepareStatement("SELECT * FROM MyTable");
  | ResultSet rs = pstmtSelect.executeQuery();
  | 

Regards,
Reto

View the original post : 
http://www.jboss.com/index.html?module=bb&op=viewtopic&p=3936333#3936333

Reply to the post : 
http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=3936333


-------------------------------------------------------
This SF.Net email is sponsored by xPML, a groundbreaking scripting language
that extends applications into web and mobile media. Attend the live webcast
and join the prime developer group breaking into this new coding territory!
http://sel.as-us.falkag.net/sel?cmd=lnk&kid=110944&bid=241720&dat=121642
_______________________________________________
JBoss-user mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/jboss-user

Reply via email to