[exoplatform] problem with Oracle database for e

[Charly Clairmont <charly.clairmont@xxxxxxxxx>]

Hello !

I try to use a oracle database to store the eXoPortal metadata. I can
not connect me to my Oracle database.


My database Configuration file:

<?xml version="1.0" encoding="ISO-8859-1"?>
<configuration>
  <component> 
    <key>org.exoplatform.services.database.impl.ExoCacheProvider</key>
    <type>org.exoplatform.services.database.impl.ExoCacheProvider</type>
  </component>

  <component> 
    <key>org.exoplatform.services.database.HibernateService</key>
    <jmx-name>database:type=HibernateService</jmx-name>

<type>org.exoplatform.services.database.impl.HibernateServiceImpl</type>
    <init-params>
      <properties-param>
        <name>hibernate.properties</name>
        <description>Default Hibernate Service</description>
        <property name="hibernate.show_sql" value="false"/>
        <property name="hibernate.cglib.use_reflection_optimizer"
value="true"/>
        <property name="hibernate.connection.url"
value="jdbc:oracle:thin:@//localhost:1521/comp4s.altic.org?relaxAutoCommit=true&amp;autoReconnect=true&amp;useUnicode=true&amp;characterEncoding=utf8"/>
        <property name="hibernate.connection.driver_class"
value="oracle.jdbc.driver.OracleDriver"/>
        <property name="hibernate.connection.autocommit" value="true"/>
        <property name="hibernate.connection.username" value="exo"/>
        <property name="hibernate.connection.password" value="exo"/>
        <property name="hibernate.default_schema" value="exo"/>
        <property name="hibernate.dialect"
value="org.hibernate.dialect.Oracle9Dialect"/>
        <property name="hibernate.c3p0.min_size" value="5"/>
        <property name="hibernate.c3p0.max_size" value="20"/>
        <property name="hibernate.c3p0.timeout" value="1800"/>
        <property name="hibernate.c3p0.max_statements" value="50"/>
      </properties-param>
    </init-params>
  </component>

</configuration>


My logs lines:

[INFO] C3P0ConnectionProvider - C3P0 using driver:
oracle.jdbc.driver.OracleDriver at URL:
jdbc:oracle:thin:@//localhost:1521/comp4s.altic.org?relaxAutoCommit=true&autoReconnect=true&useUnicode=true&characterEncoding=utf8
[INFO] C3P0ConnectionProvider - Connection properties: {user=exo,
password=****, autocommit=true}
[INFO] C3P0ConnectionProvider - autocommit mode: true
Initializing c3p0 pool...
com.mchange.v2.c3p0.PoolBackedDataSource@17757ad
[ connectionPoolDataSource ->
com.mchange.v2.c3p0.WrapperConnectionPoolDataSource@4c585f
[ acquireIncrement -> 1, autoCommitOnClose -> false,
connectionTesterClassName ->
com.mchange.v2.c3p0.impl.DefaultConnectionTester, factoryClassLocation
-> null, forceIgnoreUnresolvedTransactions -> false,
idleConnectionTestPeriod -> 0, initialPoolSize -> 5, maxIdleTime ->
1800, maxPoolSize -> 20, maxStatements -> 50, minPoolSize -> 5,
nestedDataSource -> com.mchange.v2.c3p0.DriverManagerDataSource@1d590d
[ description -> null, driverClass -> null, factoryClassLocation ->
null, jdbcUrl ->
jdbc:oracle:thin:@//localhost:1521/comp4s.altic.org?relaxAutoCommit=true&autoReconnect=true&useUnicode=true&characterEncoding=utf8,
 properties -> {user=exo, password=exo, autocommit=true} ] , propertyCycle -> 
300, testConnectionOnCheckout -> false ] , factoryClassLocation -> null, 
numHelperThreads -> 3 ] 
java.sql.SQLException: Exception d'E/S: Got minus one from a read call
        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.driver.OracleConnection.<init>(OracleConnection.java:418)
        at
oracle.jdbc.driver.OracleDriver.getConnectionInstance(OracleDriver.java:521)
        at
oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:325)
        at java.sql.DriverManager.getConnection(DriverManager.java:525)
        at java.sql.DriverManager.getConnection(DriverManager.java:140)
        at
com.mchange.v2.c3p0.DriverManagerDataSource.getConnection(DriverManagerDataSource.java:66)
        at
com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooledConnection(WrapperConnectionPoolDataSource.java:76)
        at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool
$1.acquireResource(C3P0PooledConnectionPool.java:66)
        at
com.mchange.v2.resourcepool.BasicResourcePool.assimilateResource(BasicResourcePool.java:787)
        at
com.mchange.v2.resourcepool.BasicResourcePool.acquireUntil(BasicResourcePool.java:548)
        at com.mchange.v2.resourcepool.BasicResourcePool.access
$000(BasicResourcePool.java:35)
        at com.mchange.v2.resourcepool.BasicResourcePool
$AcquireTask.run(BasicResourcePool.java:972)
        at com.mchange.v2.async.ThreadPoolAsynchronousRunner
$PoolThread.run(ThreadPoolAsynchronousRunner.java:148)
java.sql.SQLException: Exception d'E/S: Got minus one from a read call
        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.driver.OracleConnection.<init>(OracleConnection.java:418)
        at
oracle.jdbc.driver.OracleDriver.getConnectionInstance(OracleDriver.java:521)
        at
oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:325)
        at java.sql.DriverManager.getConnection(DriverManager.java:525)
        at java.sql.DriverManager.getConnection(DriverManager.java:140)
        at
com.mchange.v2.c3p0.DriverManagerDataSource.getConnection(DriverManagerDataSource.java:66)
        at
com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooledConnection(WrapperConnectionPoolDataSource.java:76)
        at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool
$1.acquireResource(C3P0PooledConnectionPool.java:66)
        at
com.mchange.v2.resourcepool.BasicResourcePool.assimilateResource(BasicResourcePool.java:787)
        at
com.mchange.v2.resourcepool.BasicResourcePool.acquireUntil(BasicResourcePool.java:548)
        at com.mchange.v2.resourcepool.BasicResourcePool.access
$000(BasicResourcePool.java:35)
        at com.mchange.v2.resourcepool.BasicResourcePool
$AcquireTask.run(BasicResourcePool.java:972)
        at com.mchange.v2.async.ThreadPoolAsynchronousRunner
$PoolThread.run(ThreadPoolAsynchronousRunner.java:148)
java.sql.SQLException: Exception d'E/S: Got minus one from a read call
        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.driver.OracleConnection.<init>(OracleConnection.java:418)
        at
oracle.jdbc.driver.OracleDriver.getConnectionInstance(OracleDriver.java:521)
        at
oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:325)
        at java.sql.DriverManager.getConnection(DriverManager.java:525)
        at java.sql.DriverManager.getConnection(DriverManager.java:140)
        at
com.mchange.v2.c3p0.DriverManagerDataSource.getConnection(DriverManagerDataSource.java:66)
        at
com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooledConnection(WrapperConnectionPoolDataSource.java:76)
        at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool
$1.acquireResource(C3P0PooledConnectionPool.java:66)
        at
com.mchange.v2.resourcepool.BasicResourcePool.assimilateResource(BasicResourcePool.java:787)
        at
com.mchange.v2.resourcepool.BasicResourcePool.acquireUntil(BasicResourcePool.java:548)
        at com.mchange.v2.resourcepool.BasicResourcePool.access
$000(BasicResourcePool.java:35)
        at com.mchange.v2.resourcepool.BasicResourcePool
$AcquireTask.run(BasicResourcePool.java:972)
        at com.mchange.v2.async.ThreadPoolAsynchronousRunner
$PoolThread.run(ThreadPoolAsynchronousRunner.java:148)
java.sql.SQLException: Exception d'E/S: Got minus one from a read call
        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.driver.OracleConnection.<init>(OracleConnection.java:418)
        at
oracle.jdbc.driver.OracleDriver.getConnectionInstance(OracleDriver.java:521)
        at
oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:325)
        at java.sql.DriverManager.getConnection(DriverManager.java:525)
        at java.sql.DriverManager.getConnection(DriverManager.java:140)
        at
com.mchange.v2.c3p0.DriverManagerDataSource.getConnection(DriverManagerDataSource.java:66)
        at
com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooledConnection(WrapperConnectionPoolDataSource.java:76)
        at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool
$1.acquireResource(C3P0PooledConnectionPool.java:66)
        at
com.mchange.v2.resourcepool.BasicResourcePool.assimilateResource(BasicResourcePool.java:787)
        at
com.mchange.v2.resourcepool.BasicResourcePool.acquireUntil(BasicResourcePool.java:548)
        at com.mchange.v2.resourcepool.BasicResourcePool.access
$000(BasicResourcePool.java:35)
        at com.mchange.v2.resourcepool.BasicResourcePool
$AcquireTask.run(BasicResourcePool.java:972)
        at com.mchange.v2.async.ThreadPoolAsynchronousRunner
$PoolThread.run(ThreadPoolAsynchronousRunner.java:148)
Exception in thread "Thread-2"
org.picocontainer.PicoIntrospectionException: Failed when calling stop
on org.exoplatform.container.PortalContainer@258c74
        at
org.picocontainer.defaults.LifecycleVisitor.traverse(LifecycleVisitor.java:81)
        at
org.picocontainer.defaults.LifecycleVisitor.stop(LifecycleVisitor.java:121)
        at
org.picocontainer.defaults.DefaultPicoContainer.stop(DefaultPicoContainer.java:383)
        at
org.exoplatform.container.RootContainer.stop(RootContainer.java:155)
        at org.exoplatform.container.RootContainer
$ShutdownThread.run(RootContainer.java:151)
Caused by: java.lang.IllegalStateException: Not started
        at
org.picocontainer.defaults.DefaultPicoContainer.stop(DefaultPicoContainer.java:382)
        at
org.exoplatform.container.PortalContainer.stop(PortalContainer.java:88)
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
        at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
        at java.lang.reflect.Method.invoke(Method.java:585)
        at
org.picocontainer.defaults.LifecycleVisitor.traverse(LifecycleVisitor.java:75)
        ... 4 more
Caused by:


I'm sure for my connection parameters. If any body have an Idea...

Tahnks for all.

-- 
Charly Clairmont <charly.clairmont@xxxxxxxxx>
ALTIC