java ssh jdbc 链接 oracle 问题。新手弄了两天了，999

org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:473)
        at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory$1.run(AbstractAutowireCapableBeanFactory.java:409)
        at java.security.AccessController.doPrivileged(Native Method)
        at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:380)
        at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:264)
        at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:222)
        at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:261)
        at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:185)
        at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:164)
        at org.springframework.beans.factory.support.DefaultListableBeanFactory.preInstantiateSingletons(DefaultListableBeanFactory.java:423)
        at org.springframework.context.support.AbstractApplicationContext.finishBeanFactoryInitialization(AbstractApplicationContext.java:728)
        at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:380)
        at org.springframework.web.context.ContextLoader.createWebApplicationContext(ContextLoader.java:255)
        at org.springframework.web.context.ContextLoader.initWebApplicationContext(ContextLoader.java:199)
        at org.springframework.web.context.ContextLoaderListener.contextInitialized(ContextLoaderListener.java:45)
        at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:3830)
        at org.apache.catalina.core.StandardContext.start(StandardContext.java:4337)
        at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:791)
        at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:771)
        at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:525)
        at org.apache.catalina.startup.HostConfig.deployDirectory(HostConfig.java:920)
        at org.apache.catalina.startup.HostConfig.deployDirectories(HostConfig.java:883)
        at org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:492)
        at org.apache.catalina.startup.HostConfig.start(HostConfig.java:1138)
        at org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:311)
        at org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSupport.java:117)
        at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1053)
        at org.apache.catalina.core.StandardHost.start(StandardHost.java:719)
        at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1045)
        at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:443)
        at org.apache.catalina.core.StandardService.start(StandardService.java:516)
        at org.apache.catalina.core.StandardServer.start(StandardServer.java:710)
        at org.apache.catalina.startup.Catalina.start(Catalina.java:566)
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
        at java.lang.reflect.Method.invoke(Unknown Source)
        at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:288)
        at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:413)
Caused by: com.mchange.v2.resourcepool.CannotAcquireResourceException: A ResourcePool could not acquire a resource from its primary factory or source.
        at com.mchange.v2.resourcepool.BasicResourcePool.awaitAvailable(BasicResourcePool.java:1319)
        at com.mchange.v2.resourcepool.BasicResourcePool.prelimCheckoutResource(BasicResourcePool.java:557)
        at com.mchange.v2.resourcepool.BasicResourcePool.checkoutResource(BasicResourcePool.java:477)
        at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool.checkoutPooledConnection(C3P0PooledConnectionPool.java:525)
        ... 49 more
[2013-05-14 11:28:05,546] [com.mchange.v2.resourcepool.BasicResourcePool] WARN  - com.mchange.v2.resourcepool.BasicResourcePool$AcquireTask@1252b15 -- 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: Io 异常: Connection refused(DESCRIPTION=(TMP=)(VSNNUM=153092352)(ERR=12505)(ERROR_STACK=(ERROR=(CODE=12505)(EMFI=4))))
        at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134)
        at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:179)
        at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:334)
        at oracle.jdbc.ttc7.TTC7Protocol.handleIOException(TTC7Protocol.java:3649)
        at oracle.jdbc.ttc7.TTC7Protocol.logon(TTC7Protocol.java:353)
        at oracle.jdbc.driver.OracleConnection.<init>(OracleConnection.java:368)
        at oracle.jdbc.driver.OracleDriver.getConnectionInstance(OracleDriver.java:549)
        at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:349)
        at com.mchange.v2.c3p0.DriverManagerDataSource.getConnection(DriverManagerDataSource.java:135)
        at com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooledConnection(WrapperConnectionPoolDataSource.java:182)
        at com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooledConnection(WrapperConnectionPoolDataSource.java:171)
        at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool$1PooledConnectionResourcePoolManager.acquireResource(C3P0PooledConnectionPool.java:137)
        at com.mchange.v2.resourcepool.BasicResourcePool.doAcquire(BasicResourcePool.java:1014)
        at com.mchange.v2.resourcepool.BasicResourcePool.access$800(BasicResourcePool.java:32)
        at com.mchange.v2.resourcepool.BasicResourcePool$AcquireTask.run(BasicResourcePool.java:1810)
        at com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread.run(ThreadPoolAsynchronousRunner.java:547)
五月 14, 2013 11:28:07 上午 org.apache.coyote.http11.Http11Protocol start
INFO: Starting Coyote HTTP/1.1 on http-8088
五月 14, 2013 11:28:07 上午 org.apache.jk.common.ChannelSocket init
INFO: JK: ajp13 listening on /0.0.0.0:8009
五月 14, 2013 11:28:07 上午 org.apache.jk.server.JkMain start
INFO: Jk running ID=0 time=0/15  config=null
五月 14, 2013 11:28:07 上午 org.apache.catalina.startup.Catalina start
INFO: Server startup in 34492 ms
jdbc.properties 配置代码：
#oracle
jdbc.driverClass = oracle.jdbc.driver.OracleDriver
jdbc.url ="jdbcracle:thin:@127.0.0.1:1521:myOra1";
jdbc.username ="system";
jdbc.password ="change_on_install";
hibernate.dialect = org.hibernate.dialect.Oracle9iDialect
hibernate.jdbc.batch_size = 10
hibernate.jdbc.fetch_size = 18
hibernate.hbm2ddl.auto = update
hibernate.show_sql = true
hibernate.cache.use_query_cache = false
hibernate.cache.use_second_level_cache = true
hibernate.cache.provider_class = org.hibernate.cache.HashtableCacheProvider

public class ConnectJdbc {
//驱动程序就是之前在classpath中配置的jdbc的驱动程序jar中
public static final String drive = "oracle.jdbc.driver.OracleDriver";
public static final String url = "jdbc:oracle:thin:@127.0.0.1:1521:myOra1";
public static final String DBUSER="system";
public static final String password="change_on_install";
public static void main(String[] args) throws Exception{
// TODO Auto-generated method stub
try {
Connection conn = null;//表示数据库连接
    Statement stmt= null;//表示数据库的更新
    ResultSet result = null;//查询数据库
Class.forName(drive);//使用class类来加载程序
conn =DriverManager.getConnection(url,DBUSER,password); //连接数据库
//Statement接口要通过connection接口来进行实例化操作
stmt = conn.createStatement();
//执行SQL语句来查询数据库
result =stmt.executeQuery("SELECT loginName FROM t_user");
while(result.next()){//判断有没有下一行
String  loginName =result.getString(1);
System.out.println("loginName:"+loginName+";");
}
result.close();//数据库先开后关
stmt.close();
conn.close();//关闭数据库

} catch (Exception e) {
System.out.println("e"+e.getMessage());
}
}
}ojdbc14.jar 包。  我单独建个类可以链接获取数据。就是jdbc链接不得

jdbc.url ="jdbcracle:thin:@127.0.0.1:1521:myOra1";

jdbc.url ="jdbcracle:thin:@127.0.0.1:1521:myOra1";
改为
jdbc.url ="jdbc:oracle:thin:@127.0.0.1:1521:myOra1";

谢谢5楼。不过不是这问题，我复制的时候那符号变成了表情。再复制一次就没了。问题昨天下午也决绝了。jdbc.url ="jdbc:oracle:thin:@127.0.0.1:1521:myOra1";
是多了双引号的问题
jdbc.url =jdbc:oracle:thin:@127.0.0.1:1521:myOra1
。不过还是非常感谢。

Connection connection = DriverManager.getConnection( "jdbc:oracle:thin:@192.168.0.1:1521:orcl", "username", "password");

首先你配置文件改下
jdbc.properties 配置代码：
#oracle
jdbc.driverClass = com.mysql.jdbc.Driver
jdbc.url ="jdbc:mysql://192.168.1.106:3306/test";   //你MYSQL如果装在本地可以用local服务器的话打对应的IP   test 改成你的数据库名字
jdbc.username ="root";   //用户名改成你的MYSQL用户名
jdbc.password ="";   //密码也是改成你的MYSQL密码
hibernate.dialect = org.hibernate.dialect.MySQLDialect
hibernate.jdbc.batch_size = 10
hibernate.jdbc.fetch_size = 18
hibernate.hbm2ddl.auto = update
hibernate.show_sql = true
hibernate.cache.use_query_cache = false
hibernate.cache.use_second_level_cache = true
hibernate.cache.provider_class = org.hibernate.cache.HashtableCacheProvider

直接配置jdbc.properties和spring的配置文件中的hibernate部分就好了

其中jdbc.properties放在src的根目录下，那段hibernate配置文件时applicationContext中hibernate的配置的东西

问题在7楼的时候已说明解决了。
第一次发帖，不太懂要点结贴。最近又比较忙，更换oracle...，
不好意思!谢谢大家，有你们在，世界真美！

调试易

java ssh jdbc 链接 oracle 问题。新手弄了两天了，999

解决方案 »