package jef.database;
import java.sql.SQLException;
import org.junit.Test;
public class DataSourceTest {
@Test
public void testParseUrl() throws SQLException{
String[] x={
"jdbc:oracle:thin:@(DESCRIPTION =(ADDRESS = (PROTOCOL = TCP)(HOST = host2)(PORT = 1521))(ADDRESS = (PROTOCOL = TCP)(HOST = host1)(PORT = 1521))(LOAD_BALANCE = yes)(FAILOVER = ON)(CONNECT_DATA =(SERVER = DEDICATED)(SERVICE_NAME = db.domain)(FAILOVER_MODE=(TYPE = SELECT)(METHOD = BASIC)(RETIRES = 20)(DELAY = 15))))",
"jdbc:mysql://localhost:3306/allandb?useUnicode=true&characterEncoding=UTF-8",
"jdbc:microsoft:sqlserver://127.0.0.1:1433;DatabaseName=WapSvc;User=sa;Password=pwd",
"jdbc:oracle:thin:@hostname:1521:AAA",
"jdbc:derby://localhost:1527/databaseName;create=true",
"jdbc:postgresql://localhost:5432/soft",
"jdbc:postgresql://localhost/soft",
"jdbc:db2://aServer.myCompany.com:50002/name",
"jdbc:derby:./db1;create=true",
"jdbc:oracle:oci:@//example.com:5521:bjava21",
"jdbc:oracle:oci:@//example.com:bjava21",
"jdbc:oracle:oci:@sss",
//"jdbc:sybase:Tds:aServer.myCompany.com:2025"
};
for(String s:x){
ConnectInfo info=new ConnectInfo();
info.setUrl(s);
info.parse();
System.out.println(info);
}
}
}