Re: [exoplatform] problem with Oracle database for e

2007/11/28, Peter Nedonosko <peter.nedonosko@xxxxxxxxxxxxxxxxxx >:

Hi,

2007/11/28, 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&autoReconnect=true&useUnicode=true&characterEncoding=utf8"/>

it's not a oracle related jdbc url parameters - useUnicode=true&characterEncoding=utf8
Seems it's a error of a copy-paste from MySQL config, remove all parameters and try again.
Add by one and recheck each time if it so necessary for the project.

Peter.

        <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

--
You receive this message as a subscriber of the exoplatform@xxxxxxx mailing list.
To unsubscribe: mailto:exoplatform-unsubscribe@xxxxxxx
For general help: mailto:sympa@xxxxxxx ?subject=help
OW2 mailing lists service home page: http://www.ow2.org/wws

Search OW2 Mail Archive:
Advanced Search - Powered by Google