配置weblogic连接oracle的数据源
Name:JDBC-DEV1JNDI Name:jdbc.datasource.DS1
AdminServer
Row Prefetch Size: 48
Stream Chunk Size:256
URL:jdbc:oracle:thin:@192.168.0.118:1521:AAT
Driver Class Name:oracle.jdbc.OracleDriver
连接oracle及postgresql的连接字符串
package com.lwf.eus.util;import java.sql.Connection;import java.sql.DriverManager;import java.sql.PreparedStatement;import java.sql.SQLException;import java.sql.Statement;import javax.naming.Context;import javax.naming.InitialContext;import javax.naming.NamingException;import javax.sql.DataSource;public class ConnectionManager {public static Connection getConnectionOracle(){Connection conn = null;String url = "jdbc:oracle:thin:@192.168.0.118:1521:AAT";String userName = "xxx";String pwd = "xxx";try {Class.forName("oracle.jdbc.driver.OracleDriver").newInstance();conn = DriverManager.getConnection(url,userName,pwd);} catch (SQLException e) {e.printStackTrace();} catch (ClassNotFoundException e) {e.printStackTrace();} catch (InstantiationException e) {e.printStackTrace();} catch (IllegalAccessException e) {e.printStackTrace();} catch (Exception e){e.printStackTrace();}return conn;}public static Connection getConnection(){Connection conn = null;String url = "jdbc:postgresql://192.168.0.180/getseus";String userName = "xxx";String pwd = "xxx";try {Class.forName("org.postgresql.Driver").newInstance();conn = DriverManager.getConnection(url,userName,pwd);} catch (SQLException e) {e.printStackTrace();} catch (ClassNotFoundException e) {e.printStackTrace();} catch (InstantiationException e) {e.printStackTrace();} catch (IllegalAccessException e) {e.printStackTrace();} catch (Exception e){e.printStackTrace();}return conn;}public static Connection getConnectionFromDS(){Connection conn = null;Context ctx = null;try {ctx = new InitialContext();DataSource ds = (DataSource)ctx.lookup("JNDIPG");conn = ds.getConnection();} catch (NamingException e) {// TODO Auto-generated catch blocke.printStackTrace();} catch (SQLException e) {// TODO Auto-generated catch blocke.printStackTrace();}return conn;}public static Connection getConnectionFromDSofOracle(){Connection conn = null;Context ctx = null;try {ctx = new InitialContext();DataSource ds = (DataSource)ctx.lookup("JNDIORACLE");conn = ds.getConnection();} catch (NamingException e) {// TODO Auto-generated catch blocke.printStackTrace();} catch (SQLException e) {// TODO Auto-generated catch blocke.printStackTrace();}return conn;}public static Statement createStatement(Connection conn){Statement st = null;try {st = conn.createStatement();} catch (SQLException e) {e.printStackTrace();}return st;}}
页:
[1]