1、JBoss服务器oracle数据源配置 <datasources> <local-tx-datasource> <jndi-name>biddb</jndi-name> <connection-url>jdbc:oracle:thin:@192.168.0.5:1521:biddb</connection-url> <driver-class>oracle.jdbc.driver.OracleDriver</driver-class> <user-name>bid_admin</user-name> <password>a123456</password> <min-pool-size>50</min-pool-size> <max-pool-size>200</max-pool-size> <exception-sorter-class-name> org.jboss.resource.adapter.jdbc.vendor.OracleExceptionSorter </exception-sorter-class-name> <metadata> <type-mapping>Oracle10g</type-mapping> </metadata> </local-tx-datasource> </datasources> 2、数据源连接代码 import java.sql.Connection; import java.sql.PreparedStatement; import java.sql.ResultSet; import javax.naming.Context; import javax.naming.InitialContext; import javax.naming.NamingException; import javax.sql.DataSource; /** * 提供JDBC连接数据源的功能 * @author nliu */ public final class ConnectionUtil { /** * Weblogic JNDI NAME SAMPLE:jdbc/bid(Weblogic JNDI_NAME:jdbc/bid) * JBoss JNDI NAME SAMPLE:java:/biddb(JBoss JNDI_NAME:biddb) */ private final static String JNDI_NAME="java:/biddb"; private static Connection con; private static DataSource ds; private static Context context=null; static{ try { context=new InitialContext(); } catch (NamingException e){ e.printStackTrace(); } } /** * 获取Conntion连接 * @return Connection */ public static synchronized Connection getConnection(){ try{ if(null == con || true == con.isClosed()) { con=ConnectionUtil.getDataSource().getConnection(); } }catch(Exception e){ e.printStackTrace(); } return con; } /** * 关闭ResultSet * @param rs */ public static void closeResultSet(ResultSet rs){ try{ if(null != rs){ rs.close(); } }catch(Exception e){ e.printStackTrace(); } } /** * 关闭PreparedStatement * @param ps */ public static void closePreparedStatement(PreparedStatement ps){ try{ if(null != ps){ ps.close(); } }catch(Exception e){ e.printStackTrace(); } } /** * 关闭Connection * @param con */ public static void closeConnection(Connection con){ try{ if(null != con&&con.isClosed()==false){ con.close(); } }catch(Exception e){ e.printStackTrace(); } } /** * 获取DataSource * @return DataSource * @throws NamingException */ private static DataSource getDataSource() throws NamingException{ if(null ==ds){ Context ctx = context; ds = (DataSource) ctx.lookup(JNDI_NAME); } return ds; } }