0 Replies Latest reply on Feb 22, 2006 6:34 AM by Aymen MASMOUDI

    connection to oracle database

    Aymen MASMOUDI Newbie

      i 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