Java同时连接mysql和oracle
Java同时连接mysql和oracle,我用的连接池,结果运行的时候出错
出错信息:
Exception in thread "main" java.lang.ClassCastException: oracle.jdbc.driver.T4CConnection cannot be cast to com.mysql.jdbc.Connection
at DBQueryBean.oracleQuery(DBQueryBean.java:54)
at test.main(test.java:18)
main 函数是这么写的:
public static void main(String[] args) throws SQLException{
DBQueryBean dBQueryBean;
dBQueryBean = new DBQueryBean();
String ServerName="tsus_tracking";//从上下文得到你要访问的数据库的名字
String sql ="select date_format(VisitTime,'%Y-%m-%d') as Hour, count(*) from 2008061523_Auto_Incoming_Log where VisitTime >= '2008-06-04' and VisitTime < '2008-06-05' group by Hour";
// dBQueryBean.mySQLQuery(ServerName,sql);
String dbname = "orcl";
String oracleSql ="select * from report";
dBQueryBean.oracleQuery(dbname, oracleSql);
System.out.println();
System.exit(0);
}
请问这是什么原因阿?