请问c3p0连接池怎么读properties配置文件?
我怎么试都不行,总是:driverClass--->null
properties文件如下:driverClass=com.microsoft.sqlserver.jdbc.SQLServerDriver
jdbcUrl=jdbc:sqlserver://127.0.0.1:1433;DatabaseName=stock2
user=sa
password=ba123不知道为什么就是读不了,向高手求救,希望给点代码提示一下,谢谢了!,我在官网那里搞了一上午都没弄出什么来。
现在只能在new 一个ComboPooledDataSource后,一个个设置,这样很不方便,每次改的时候都要从新编译!!ComboPooledDataSource ds = new ComboPooledDataSource();
ds.setDriverClass( "com.microsoft.sqlserver.jdbc.SQLServerDriver" );
ds.setJdbcUrl( "jdbc:sqlserver://127.0.0.1:1433;DatabaseName=stock2" );
ds.setUser("sa");
ds.setPassword("ba123");
我怎么试都不行,总是:driverClass--->null
properties文件如下:driverClass=com.microsoft.sqlserver.jdbc.SQLServerDriver
jdbcUrl=jdbc:sqlserver://127.0.0.1:1433;DatabaseName=stock2
user=sa
password=ba123不知道为什么就是读不了,向高手求救,希望给点代码提示一下,谢谢了!,我在官网那里搞了一上午都没弄出什么来。
现在只能在new 一个ComboPooledDataSource后,一个个设置,这样很不方便,每次改的时候都要从新编译!!ComboPooledDataSource ds = new ComboPooledDataSource();
ds.setDriverClass( "com.microsoft.sqlserver.jdbc.SQLServerDriver" );
ds.setJdbcUrl( "jdbc:sqlserver://127.0.0.1:1433;DatabaseName=stock2" );
ds.setUser("sa");
ds.setPassword("ba123");
解决方案 »
- 用Java Socket请求网页数据,遇到301永久重定向问题
- java 打出jar包后 读写excel数据源
- 在JAVA Application 里播放音频!!!!!
- Applet init() 提问
- Java侦听系统终止事件,做好扫尾工作
- 请高手指教如何用链表(list)的问题
- 关于日期的问题?
- JAVA虚拟机的回收是基于什么原理???如何实现java游戏的暂停功能???----请各位指点!
- 我的这个applet为什么一直运行啊?
- 关于类啊!这个问题从我开始学习java开始~!就一直困扰着我啊希望大家帮忙~!分不够还可以加啊
- 如何用编码方式忽略 CTRL_LOGOFF_EVENT?
- 有关模态JDialog问题
java.util.Properties
Properties prop = new Properties();
prop.load(InputStream inStream);
prop.getProperty(String key);
rg.getString("");
p.load(this.getClass().getResourceAsStream(c3p0Properties));
ds = new ComboPooledDataSource();
ds.setProperties(p);
2009-2-13 11:59:52 com.mchange.v2.log.MLog <clinit>
信息: MLog clients using java 1.4+ standard logging.
2009-2-13 11:59:53 com.mchange.v2.c3p0.C3P0Registry banner
信息: Initializing c3p0-0.9.1.2 [built 21-May-2007 15:04:56; debug? true; trace: 10]
2009-2-13 11:59:53 com.mchange.v2.c3p0.impl.AbstractPoolBackedDataSource getPoolManager
信息: Initializing c3p0 pool... com.mchange.v2.c3p0.ComboPooledDataSource [ acquireIncrement -> 3, acquireRetryAttempts -> 30, acquireRetryDelay -> 1000, autoCommitOnClose -> false, automaticTestTable -> null, breakAfterAcquireFailure -> false, checkoutTimeout -> 0, connectionCustomizerClassName -> null, connectionTesterClassName -> com.mchange.v2.c3p0.impl.DefaultConnectionTester, dataSourceName -> 2sa1hd7zugo04o1c4fygx|ef5502, debugUnreturnedConnectionStackTraces -> false, description -> null, driverClass -> null, factoryClassLocation -> null, forceIgnoreUnresolvedTransactions -> false, identityToken -> 2sa1hd7zugo04o1c4fygx|ef5502, idleConnectionTestPeriod -> 0, initialPoolSize -> 3, jdbcUrl -> null, maxAdministrativeTaskTime -> 0, maxConnectionAge -> 0, maxIdleTime -> 0, maxIdleTimeExcessConnections -> 0, maxPoolSize -> 15, maxStatements -> 0, maxStatementsPerConnection -> 0, minPoolSize -> 3, numHelperThreads -> 3, numThreadsAwaitingCheckoutDefaultUser -> 0, preferredTestQuery -> null, properties -> {driverClass=com.microsoft.sqlserver.jdbc.SQLServerDriver, user=******, password=******, jdbcUrl=jdbc:sqlserver://127.0.0.1:1433;DatabaseName=stock2}, propertyCycle -> 0, testConnectionOnCheckin -> false, testConnectionOnCheckout -> false, unreturnedConnectionTimeout -> 0, usesTraditionalReflectiveProxies -> false ]
2009-2-13 12:00:22 com.mchange.v2.resourcepool.BasicResourcePool$AcquireTask run
警告: com.mchange.v2.resourcepool.BasicResourcePool$AcquireTask@8e32e7 -- 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: No suitable driver
at java.sql.DriverManager.getDriver(Unknown Source)
at com.mchange.v2.c3p0.DriverManagerDataSource.driver(DriverManagerDataSource.java:223)
at com.mchange.v2.c3p0.DriverManagerDataSource.getConnection(DriverManagerDataSource.java:134)
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)properties是加载成功的,因为提示信息里有:
properties -> {driverClass=com.microsoft.sqlserver.jdbc.SQLServerDriver, user=******, password=******, jdbcUrl=jdbc:sqlserver://127.0.0.1:1433;DatabaseName=stock2},
我只是不知道为什么,那个driverClass -> null,和jdbcUrl -> null,?怎么还是null啊
不过不知道他具体要求的是什么=====================================================================
你还使用
ds.setDriverClass( "com.microsoft.sqlserver.jdbc.SQLServerDriver" );
ds.setJdbcUrl( "jdbc:sqlserver://127.0.0.1:1433;DatabaseName=stock2" );
ds.setUser("sa");
ds.setPassword("ba123");
这种方式,只不过你面的字符串是propertie.getProperty("XXXX");也可以,没啥区别,反正只需要改properties文件
=================================================================
ComboPooledDataSource ds = new ComboPooledDataSource();
ds.setDriverClass( "com.microsoft.sqlserver.jdbc.SQLServerDriver" );
ds.setJdbcUrl( "jdbc:sqlserver://127.0.0.1:1433;DatabaseName=stock2" );
ds.setUser("sa");
ds.setPassword("ba123"); 每次都用重新编译不方便啊,我不知道c3p0要怎么把properties加载上去才行,
上面的这样设置了ds.setProperties(p);都不行!!
//加载Properties文件ds.setDriverClass(p.getProperty("driver.class"));
ds.setJdbcUrl(p.getProperty("jdbc.url"));
ds.setUser(p.getProperty("user"));
ds.setPassword(p.getProperty("password"));
这种形式不可以么?
这样以后又变更个修改Properties文件就可以了
at java.sql.DriverManager.getDriver(Unknown Source)
at com.mchange.v2.c3p0.DriverManagerDataSource.driver(DriverManagerDataSource.java:223)
at com.mchange.v2.c3p0.DriverManagerDataSource.getConnection(DriverManagerDataSource.java:134)
at 看你错误提示,应该是没有加入oracle的驱动jar包吧!!