package com.sql;
import java.beans.PropertyVetoException;
import java.sql.Connection;
import java.sql.SQLException;

import com.mchange.v2.c3p0.ComboPooledDataSource;


public class SybaseConnPool {
private ComboPooledDataSource sybase_ds = new ComboPooledDataSource();
	
	public SybaseConnPool()
	{
		try {
			init();
		} catch (PropertyVetoException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
	}
	
	public void init() throws PropertyVetoException
	{
		sybase_ds.setDriverClass("com.sybase.jdbc3.jdbc.SybDriver");
		/*
		String connStr = "jdbc:sybase:Tds:" + GetIpAddr.getLoacalHostIp() 
						+ ":5000/battdata?language=us_english&charset=cp936";
		sybase_ds.setJdbcUrl(connStr);
		*/
		//sybase_ds.setJdbcUrl("jdbc:sybase:Tds:192.168.2.104:5000/battdata?language=us_english&charset=cp936");
		sybase_ds.setJdbcUrl("jdbc:sybase:Tds:192.168.48.129:5000/battdata?language=us_english&charset=cp936");
		sybase_ds.setUser("sa");
		sybase_ds.setPassword("");
		sybase_ds.setMaxPoolSize(3);
		sybase_ds.setMinPoolSize(1);
	}
	public Connection getConn()
	{
		Connection con = null;
		try {
			con = sybase_ds.getConnection();
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		return con;
	}
}