K Padmavathi

Hi,
I need one help from you. In JDBC connection pool using jboss server, It is compiled successfully but when I am trying to run that program it is showing request resourse not found (DSMain1.java) but it is there in .war file (WEB-INF folder). please tel me the solution.

I placed mysql-ds.xml file in server/default/deploy.
mysql-ds.xml

<?xml version="1.0" encoding="UTF-8"?> <data-sources> <local-tx-datasource> <jndi-name>MySqlDataSourceNameJNDI</jndi-name> <driver-class>com.mysql.jdbc.Driver</driver-class> <connection-url>jdbc:mysql://localhost:3306/test</connection-url> <driver-class>com.mysql.jdbc.Driver</driver-class> <username>root</username> <passowrd>root</passowrd> <use-java-context>false</use-java-context> <min-pool-size>10</min-pool-size> <max-pool-size>200</max-pool-size> <idle-timeout-minutes>1</idle-timeout-minutes> </local-tx-datasource> </data-sources>

java classes are

DSUtil.java
import java.sql.*; import java.util.Properties; import javax.naming.Context; import javax.naming.InitialContext; import javax.sql.DataSource; public class DSUtil1 { static Context ctx=null; static{ try{ Properties p=new Properties(); p.put("java.naming.factory.initial", "org.jnp.interfaces.Naming.CoontextFactory"); p.put("java.naming.provider.url","localhost:1099"); p.put("java.naming.factory.url.pkgs","org.jboss.naming"); ctx=new InitialContext(); }catch(Exception e){ e.printStackTrace(); } } public static Connection getMySqlConnection(){ Connection con=null; try{ Object obj=ctx.lookup("MySqlDataSourceJNDI"); DataSource ds=(DataSource)obj; con=ds.getConnection(); }catch(Exception e){ e.printStackTrace(); } return con; } public static void cleanup(ResultSet rs,Statement st,Connection con){ try{ if(rs!=null)rs.close(); if(st!=null)st.close(); if(con!=null)con.close(); }catch(Exception e){ e.printStackTrace(); } } }

DSMain.java
import java.sql.Connection; import java.sql.ResultSet; import java.sql.Statement; public class DSMain1 { /** * @param args */ public static void main(String[] args) { // TODO Auto-generated method stub Connection con=null; Statement st=null; ResultSet rs=null; try{ con=DSUtil1.getMySqlConnection(); st=con.createStatement(); rs=st.executeQuery("select * from jlcstudents"); while(rs.next()){ System.out.println(rs.getInt(1)); } }catch(Exception e){ e.printStackTrace(); } } }

I added all .jar to the class path. please tel me solution........

it is showing the error

HTTP Status 404 - /JDBCConnectionPool/WEB-INF/classes/DSMain1.java
--------------------------------------------------------------------------------
type Status report
message /JDBCConnectionPool/WEB-INF/classes/DSMain1.java
description The requested resource (/JDBCConnectionPool/WEB-INF/classes/DSMain1.java) is not available.