DriverManagerDataSource dataSource = new DriverManagerDataSource();
dataSource.setDriverClassName( “oracle.jdbc.driver.OracleDriver”);
dataSource.setUrl( “jdbc:oracle:thin:@localhost:1521:ORCL”);
dataSource.setUsername( “scott”);
dataSource.setPassword( “tiger”);
JdbcTemplate jdbcTemplate = new JdbcTemplate(dataSource);
jdbcTemplate.update(“insert into spring4 values(?,?,?)”,1001,“赵云”,10000);
执行上面的程序会报错,数据库连接错误:
原因:dataSource.setUrl( “jdbc:oracle:thin:@localhost:1521:ORCL”);
本地主机为:127.0.0.1
但是,tnsnames.ora中文件的配置如下:
IP配置不一致导致报错
解决:dataSource.setUrl( “jdbc:oracle:thin:@172.18.9.24:1521:ORCL”);