2,596
社区成员
发帖
与我相关
我的任务
分享
public class TestConn {
private static final String username = "root";
private static final String password = "netcool";
private static final String mysql = "jdbc:sybase:Tds:172.20.8.178:4100/alerts";
private static Connection conn = null;
private static Statement stmt = null;
private static ResultSet rs = null;
private static String sql = "";
private static String sname;
private static int score;
public static void main(String[] args) throws ClassNotFoundException {
try {
//sybase.jar com.sybase.jdbc.SybDriver
Class.forName("com.sybase.jdbc3.jdbc.SybDriver");
System.out.println("Successfully download JDBC!");
conn = DriverManager.getConnection(mysql, username, password);
System.out.println("Successfully connect to DB!");
System.out.println(conn);
} catch (SQLException e) {
System.err.println(e.getMessage());
}
try {
stmt = conn.createStatement();
String sql = "select count(1) from status";
rs = stmt.executeQuery(sql);
List list = new ArrayList();
while(rs.next()){
list.add(rs.getString(1));
System.out.println(rs.getInt(1));
}
System.out.println(list.get(0).toString());
} catch (SQLException e) {
e.printStackTrace();
}finally{
try {
rs.close();
stmt.close();
conn.close();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
}
}
<!-- c3p0连接池配置 -->
<bean id="dataSourceNrptdev" class="com.mchange.v2.c3p0.ComboPooledDataSource">
<property name="user" value="${nrptdev.user}" />
<property name="password" value="${nrptdev.password}" />
<property name="driverClass" value="${nrptdev.driverClass}" />
<property name="jdbcUrl" value="${nrptdev.url}" />
netcoolEvent.driverClass=com.sybase.jdbc3.jdbc.SybDriver
netcoolEvent.url=jdbc:sybase:Tds:172.20.8.178:4100/alerts
netcoolEvent.user=root
netcoolEvent.password=netcool
Caused by: org.mybatis.spring.MyBatisSystemException: nested exception is org.apache.ibatis.exceptions.PersistenceException:
### Error querying database. Cause: org.springframework.jdbc.CannotGetJdbcConnectionException: Could not get JDBC Connection; nested exception is java.sql.SQLException: An attempt by a client to checkout a Connection has timed out.
### The error may exist in com/nantian/netcool/dao/NCEventMapper.xml
### The error may involve com.nantian.netcool.dao.INCEventDao.getCount
### The error occurred while executing a query
### Cause: org.springframework.jdbc.CannotGetJdbcConnectionException: Could not get JDBC Connection; nested exception is java.sql.SQLException: An attempt by a client to checkout a Connection has timed out.
at org.mybatis.spring.MyBatisExceptionTranslator.translateExceptionIfPossible(MyBatisExceptionTranslator.java:75)
[2015-12-23 17:11:15,417] WARN com.mchange.v2.resourcepool.BasicResourcePool 1841 - com.mchange.v2.resourcepool.BasicResourcePool$AcquireTask@15f0f82 -- Acquisition Attempt Failed!!! Clearing pending acquires. While trying to acquire a needed new resource, we failed to succeed more than the maximum number of allowed acquisition attempts (30). Last acquisition attempt exception:
java.sql.SQLException: JZ0SJ: 没有在此数据库中发现元数据存取器信息。 请按 jConnect 文档中所述安装 所需的表。
at com.sybase.jdbc3.jdbc.ErrorMessage.raiseError(Unknown Source)