Datasource

[Jibran]

We currently have an application running on JBoss Server 4.0. I am designing a JSP page that needs to access the database to retrieve some results. This page is inside a seperate .WAR file. My question is that, is there a way to connect directly to the database used by JBoss e.g. using Datasource. What is datasource and how can it be used to connect from a different modules within the same application e.g. other JAVA classes. I am kind of new to enterprise applications and need some help on this. I want to avoid using Connection code below and use Datasource which is already active somehow:

      Connection conn = DriverManager.getConnection
      ("jdbc:microsoft:sqlserver://server:1433","user","password"); 
      Statement stmt = conn.createStatement();
      ResultSet rset= stmt.executeQuery("select * from table");
      while(rset.next()){ string = rset.getString(1);} 
      conn.close();
      stmt.close();
      rset.close();
      }catch (SQLException ex){}

Any help will be great.

[Dököll]

Thanks for posting part of your code good buddy...

I suspect you ar using a bean, is that it?

I'll fetch your notes later and see what can be salvaged.

In a bit!

[JosAH]

@Dököll
No, the OP wants to use a DataSource defined by the vendor (JBoss). A DataSource is an object associated with a name in a JNDI Context. JBoss supplies the Context and you can lookup the DataSource given its name. The OP doesn't want to use a DriverManager and get a Connection from it; the OP wants to get a Connection from the DataSource so there is no need to look at the supplied code. Normally these JNDI definition details can be found in some xml file.

kind regards,

Jos