connection to oracle database
infmas Feb 22, 2006 6:34 AMi have some problems to connect to oracle database, i have copied the JDBC driver jar file into the folder for the currently used jars and i have Modifed the hibernate.properties but the scripts generated was false and i this error was declanched :
[junit] 11:56:20,430 INFO Configuration : processing foreign key constraint
s
[junit] 11:56:20,539 INFO C3P0ConnectionProvider : C3P0 using driver: oracl
e.jdbc.driver.OracleDriver at URL: jdbc:oracle:thin:@localhost:1521:jbpmtest
[junit] 11:56:20,539 INFO C3P0ConnectionProvider : Connection properties: {
user=system, password=****}
[junit] 11:56:20,539 INFO C3P0ConnectionProvider : autocommit mode: false
[junit] Initializing c3p0 pool... com.mchange.v2.c3p0.PoolBackedDataSource@1
9d75ee [ connectionPoolDataSource -> com.mchange.v2.c3p0.WrapperConnectionPoolDa
taSource@187c55c [ acquireIncrement -> 1, acquireRetryAttempts -> 30, acquireRet
ryDelay -> 1000, autoCommitOnClose -> false, automaticTestTable -> null, breakAf
terAcquireFailure -> false, checkoutTimeout -> 0, connectionTesterClassName -> c
om.mchange.v2.c3p0.impl.DefaultConnectionTester, factoryClassLocation -> null, f
orceIgnoreUnresolvedTransactions -> false, idleConnectionTestPeriod -> 0, initia
lPoolSize -> 1, maxIdleTime -> 0, maxPoolSize -> 3, maxStatements -> 0, maxState
mentsPerConnection -> 0, minPoolSize -> 1, nestedDataSource -> com.mchange.v2.c3
p0.DriverManagerDataSource@2f0d54 [ description -> null, driverClass -> null, fa
ctoryClassLocation -> null, jdbcUrl -> jdbc:oracle:thin:@localhost:1521:jbpmtest
, properties -> {user=******, password=******} ] , preferredTestQuery -> null, p
ropertyCycle -> 300, testConnectionOnCheckin -> false, testConnectionOnCheckout
-> false, usesTraditionalReflectiveProxies -> false ] , factoryClassLocation ->
null, numHelperThreads -> 3, poolOwnerIdentityToken -> 19d75ee ]
[junit] java.sql.SQLException: Exception d'E/S: The Network Adapter could no
t establish the connection
[junit] at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:1
87)
[junit] at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:2
29)
[junit] at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:3
42)
[junit] at oracle.jdbc.driver.OracleConnection.(OracleConnection.j
ava:415)
[junit] at oracle.jdbc.driver.OracleDriver.getConnectionInstance(OracleD
river.java:485)
[junit] at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:337
)
[junit] at com.mchange.v2.c3p0.DriverManagerDataSource.getConnection(Dri
verManagerDataSource.java:68)
[junit] at com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooled
Connection(WrapperConnectionPoolDataSource.java:87)
[junit] at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool$1.acquireRe
source(C3P0PooledConnectionPool.java:83)
[junit] at com.mchange.v2.resourcepool.BasicResourcePool.assimilateResou
rce(BasicResourcePool.java:884)
[junit] at com.mchange.v2.resourcepool.BasicResourcePool.acquireUntil(Ba
sicResourcePool.java:601)
[junit] at com.mchange.v2.resourcepool.BasicResourcePool.access$400(Basi
cResourcePool.java:31)
[junit] at com.mchange.v2.resourcepool.BasicResourcePool$AcquireTask.run
(BasicResourcePool.java:1079)
[junit] at com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread.
run(ThreadPoolAsynchronousRunner.java:354)
thanks in advance