Mail Archive Home | exo-portal List | April 2008 Index
| Date Index --> | Thread Index --> |
Hi,
I am using exo-eXoUltimateProduct-r23239-tomcat
I am trying to change the database to oracle.
I have changed all the necessary files like
database-configuration.xml,jcr-configuration.xml,repository-configuration.xml
The database-configuration.xml is as follows.
<?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:name"/>
<property name="hibernate.connection.driver_class"
value="oracle.jdbc.OracleDriver"/>
<property name="hibernate.connection.autocommit" value="true"/>
<property name="hibernate.connection.username" value="UserName"/>
<property name="hibernate.connection.password" value="password"/>
<property name="hibernate.dialect"
value="org.hibernate.dialect.ORACLEDialect"/>
<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>
<!--
<component>
<key>org.exoplatform.services.database.DatabaseService</key>
<type>org.exoplatform.services.database.impl.XAPoolTxSupportDatabaseService</type>
<init-params>
<properties-param>
<name>default</name>
<description>Connection configuration</description>
<property name='connection.driver' value='org.hsqldb.jdbcDriver'/>
<property name='connection.url'
value='jdbc:hsqldb:file:../temp/data/exodb'/>
<property name='connection.login' value='sa'/>
<property name='connection.password' value=''/>
<property name='connection.min-size' value='3'/>
<property name='connection.max-size' value='5'/>
</properties-param>
</init-params>
</component>
-->
<external-component-plugins>
<target-component>org.exoplatform.services.naming.InitialContextInitializer</target-component>
<component-plugin>
<name>bind.datasource</name>
<set-method>addPlugin</set-method>
<type>org.exoplatform.services.naming.BindReferencePlugin</type>
<init-params>
<value-param>
<name>bind-name</name>
<value>jdbcexo</value>
</value-param>
<value-param>
<name>class-name</name>
<value>javax.sql.DataSource</value>
</value-param>
<value-param>
<name>factory</name>
<value>org.apache.commons.dbcp.BasicDataSourceFactory</value>
</value-param>
<properties-param>
<name>ref-addresses</name>
<description>ref-addresses</description>
<property name="driverClassName" value="oracle.jdbc.OracleDriver"/>
<property name="url" value="jdbc:oracle:thin:@localhost:1521:name"/>
<property name="username" value="UserName"/>
<property name="password" value="password"/>
</properties-param>
</init-params>
</component-plugin>
</external-component-plugins>
</configuration>
similarly I have changed the
jcr-configuration.xml,repository-configuration.xml.
I am getting the following exception.
ERROR: cannot create portal container. ServletContext:
org.apache.catalina.core.
ApplicationContextFacade@650892
java.lang.RuntimeException: Cannot instantiate component class
org.exoplatform.s
ervices.cms.templates.impl.TemplateServiceImpl
at
org.exoplatform.container.jmx.MX4JComponentAdapter.getComponentInstan
ce(MX4JComponentAdapter.java:76)
at
org.picocontainer.defaults.DefaultPicoContainer.getInstance(DefaultPi
coContainer.java:322)
at
org.picocontainer.defaults.DefaultPicoContainer.getComponentInstances
OfType(DefaultPicoContainer.java:281)
at
org.exoplatform.container.PortalContainer.getComponentInstancesOfType
(PortalContainer.java:112)
at
org.picocontainer.defaults.LifecycleVisitor.visitContainer(LifecycleV
isitor.java:97)
at
org.picocontainer.defaults.DefaultPicoContainer.accept(DefaultPicoCon
tainer.java:416)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.
java:39)
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAcces
sorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at
org.picocontainer.defaults.AbstractPicoVisitor.traverse(AbstractPicoV
isitor.java:32)
at
org.picocontainer.defaults.LifecycleVisitor.traverse(LifecycleVisitor
.java:63)
at
org.picocontainer.defaults.LifecycleVisitor.start(LifecycleVisitor.ja
va:113)
at
org.picocontainer.defaults.DefaultPicoContainer.start(DefaultPicoCont
ainer.java:369)
at
org.exoplatform.container.PortalContainer.start(PortalContainer.java:
84)
at
org.exoplatform.container.RootContainer.createPortalContainer(RootCon
tainer.java:103)
at
org.exoplatform.portal.application.PortalController.init(PortalContro
ller.java:65)
at
org.apache.catalina.core.StandardWrapper.loadServlet(StandardWrapper.
java:1161)
at
org.apache.catalina.core.StandardWrapper.load(StandardWrapper.java:98
1)
at
org.apache.catalina.core.StandardContext.loadOnStartup(StandardContex
t.java:4044)
at
org.apache.catalina.core.StandardContext.start(StandardContext.java:4
350)
at
org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase
.java:761)
at
org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:74
1)
at
org.apache.catalina.core.StandardHost.addChild(StandardHost.java:525)
at
org.apache.catalina.startup.HostConfig.deployDescriptor(HostConfig.ja
va:626)
at
org.apache.catalina.startup.HostConfig.deployDescriptors(HostConfig.j
ava:553)
at
org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:488
)
at org.apache.catalina.startup.HostConfig.start(HostConfig.java:1138)
at
org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java
:311)
at
org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(Lifecycl
eSupport.java:120)
at
org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1023)
at org.apache.catalina.core.StandardHost.start(StandardHost.java:719)
at
org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1015)
at
org.apache.catalina.core.StandardEngine.start(StandardEngine.java:443
)
at
org.apache.catalina.core.StandardService.start(StandardService.java:4
48)
at
org.apache.catalina.core.StandardServer.start(StandardServer.java:710
)
at org.apache.catalina.startup.Catalina.start(Catalina.java:552)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.
java:39)
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAcces
sorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:288)
at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:413)
Caused by: java.lang.RuntimeException: Cannot instantiate component class
org.ex
oplatform.services.jcr.impl.RepositoryServiceImpl
at
org.exoplatform.container.jmx.MX4JComponentAdapter.getComponentInstan
ce(MX4JComponentAdapter.java:76)
at
org.picocontainer.defaults.DefaultPicoContainer.getInstance(DefaultPi
coContainer.java:322)
at
org.picocontainer.defaults.DefaultPicoContainer.getComponentInstanceO
fType(DefaultPicoContainer.java:313)
at
org.exoplatform.container.ExoContainer.createComponent(ExoContainer.j
ava:123)
at
org.exoplatform.container.jmx.MX4JComponentAdapter.getComponentInstan
ce(MX4JComponentAdapter.java:57)
... 42 more
Caused by: java.lang.RuntimeException: Cannot instantiate component class
org.ex
oplatform.services.jcr.impl.config.RepositoryServiceConfigurationImpl
at
org.exoplatform.container.jmx.MX4JComponentAdapter.getComponentInstan
ce(MX4JComponentAdapter.java:76)
at
org.picocontainer.defaults.DefaultPicoContainer.getInstance(DefaultPi
coContainer.java:322)
at
org.picocontainer.defaults.DefaultPicoContainer.getComponentInstanceO
fType(DefaultPicoContainer.java:313)
at
org.exoplatform.container.ExoContainer.createComponent(ExoContainer.j
ava:123)
at
org.exoplatform.container.jmx.MX4JComponentAdapter.getComponentInstan
ce(MX4JComponentAdapter.java:57)
... 46 more
Caused by: java.lang.reflect.InvocationTargetException
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native
Method)
at
sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstruct
orAccessorImpl.java:39)
at
sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingC
onstructorAccessorImpl.java:27)
at java.lang.reflect.Constructor.newInstance(Constructor.java:513)
at
org.exoplatform.container.ExoContainer.createComponent(ExoContainer.j
ava:131)
at
org.exoplatform.container.jmx.MX4JComponentAdapter.getComponentInstan
ce(MX4JComponentAdapter.java:57)
... 50 more
Caused by:
org.exoplatform.services.jcr.config.RepositoryConfigurationException:
Fail to init from xml! Reason:
org.exoplatform.services.jcr.config.RepositoryCo
nfigurationException: Database exception. java.sql.SQLException: ORA-01460:
unim
plemented or unreasonable conversion requested
. SQL: INSERT INTO JCR_CONFIG (NAME, CONFIG) VALUES (?,?)
at
org.exoplatform.services.jcr.impl.config.RepositoryServiceConfigurati
onImpl.<init>(RepositoryServiceConfigurationImpl.java:98)
... 56 more
Caused by:
org.exoplatform.services.jcr.config.RepositoryConfigurationException:
Database exception. java.sql.SQLException: ORA-01460: unimplemented or
unreason
able conversion requested
. SQL: INSERT INTO JCR_CONFIG (NAME, CONFIG) VALUES (?,?)
at
org.exoplatform.services.jcr.impl.config.JDBCConfigurationPersister.w
rite(JDBCConfigurationPersister.java:271)
at
org.exoplatform.services.jcr.impl.config.RepositoryServiceConfigurati
onImpl.<init>(RepositoryServiceConfigurationImpl.java:90)
... 56 more
Caused by: java.sql.SQLException: ORA-01460: unimplemented or unreasonable
conve
rsion requested
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134)
at oracle.jdbc.ttc7.TTIoer.processError(TTIoer.java:289)
at oracle.jdbc.ttc7.Oall7.receive(Oall7.java:573)
at oracle.jdbc.ttc7.TTC7Protocol.doOall7(TTC7Protocol.java:1891)
at
oracle.jdbc.ttc7.TTC7Protocol.parseExecuteFetch(TTC7Protocol.java:109
3)
at
oracle.jdbc.driver.OracleStatement.executeNonQuery(OracleStatement.ja
va:2047)
at
oracle.jdbc.driver.OracleStatement.doExecuteOther(OracleStatement.jav
a:1940)
at
oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStateme
nt.java:2709)
at
oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePrepar
edStatement.java:589)
at
org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(Del
egatingPreparedStatement.java:101)
at
org.exoplatform.services.jcr.impl.config.JDBCConfigurationPersister.w
rite(JDBCConfigurationPersister.java:254)
... 57 more
Please let me know how to fix this issue.
Thanks
| Date Index --> | Thread Index --> |
Powered by MHonArc.
Copyright © 2006-2007, OW2 Consortium | contact | webmaster.