[opencms-dev] critical error during OpenCms initialiazation

[Kareem Abdulfattah Al Jabr]

Hi all,

 

I have migrated my database from MySQL to Oracle 11g I can see all 31
tables created with all data. I have modified the opencms.properties
file to connect to oracle but I get the below error,

 

The following critical error occurred:

Critical error during OpenCms initialization: Unable to initialize the
user driv

er.

Giving up, unable to start OpenCms.

 

My opencms.properties content is as follow:

 

#

# Configuration of the driver manager

########################################################################
#########

driver.vfs=db

driver.project=db

driver.user=db

driver.history=db

 

 

 

#

# Declaration of database pools

########################################################################
#########

db.pools=default

 

#

# Configuration of the default database pool

########################################################################
#########

# name of the JDBC driver

db.pool.default.jdbcDriver=oracle.jdbc.driver.OracleDriver

 

# URL of the JDBC driver

db.pool.default.jdbcUrl=jdbc:oracle:thin:@10.0.1.227:1522:mydb

 

# optional parameters for the URL of the JDBC driver

db.pool.default.jdbcUrl.params=

 

# user name to connect to the database

db.pool.default.user=opencms

 

# password to connect to the database

db.pool.default.password=opencms

 

# the URL to make the JDBC DriverManager return connections from the
DBCP pool

db.pool.default.poolUrl=opencms:default

 

# the maximum number of objects that can be borrowed from the pool

db.pool.default.maxActive=25

 

# the maximum amount of time before throwing an exception when the pool
is exhausted

db.pool.default.maxWait=2000

 

# the minimum number of objects that will kept connected

db.pool.default.minIdle=3

 

# the maximum number of objects that can sit idled in the pool

db.pool.default.maxIdle=10

 

# action to take when the pool is exhausted {grow|block|fail}

db.pool.default.whenExhaustedAction=block

 

# connections will be validated before they are borrowed from the pool

db.pool.default.testOnBorrow=false

 

# connections will be validated by evictor thread

db.pool.default.testWhileIdle=true

 

# number of milliseconds to sleep between runs of the evictor thread

# -1 means no idle connection evictor thread will be run

db.pool.default.timeBetweenEvictionRuns=3600000

 

# number of connections tested in a run of the evictor thread

db.pool.default.numTestsPerEvictionRun=3

 

# minimum amount of time in milliseconds a connection may be idle in the
pool before it is eligable for eviction

db.pool.default.minEvictableIdleTime=1800000

 

# the query to validate connections

#db.pool.default.testQuery=SELECT STRUCTURE_ID FROM
CMS_OFFLINE_STRUCTURE WHERE RESOURCE_PATH = '/'

db.pool.default.testQuery=

 

# number of attempts to connect to the database during startup (default
= 10)

db.pool.default.connects=10

 

# sleep time between two attempts to connect to the database during
startup in ms (default = 5000)

db.pool.default.wait=5000

 

#

# Configuration for statement pooling

########################################################################
#########

db.statements.default.pooling=true

db.statements.default.maxActive=200

db.statements.default.maxWait=2000

db.statements.default.maxIdle=100

db.statements.default.whenExhaustedAction=block

 

#

# Configuration of the database driver manager

########################################################################
#########

db.name=oracle

 

db.vfs.driver=org.opencms.db.oracle.CmsVfsDriver

db.vfs.pool=opencms:default

db.vfs.sqlmanager=org.opencms.db.oracle.CmsSqlManager

 

db.project.driver=org.opencms.db.oracle.CmsProjectDriver

db.project.pool=opencms:default

db.project.sqlmanager=org.opencms.db.oracle.CmsSqlManager

 

db.user.driver=org.opencms.db.oracle.CmsUserDriver

db.user.pool=opencms:default

db.user.sqlmanager=org.opencms.db.oracle.CmsSqlManager

 

db.history.driver=org.opencms.db.oracle.CmsHistoryDriver

db.history.pool=opencms:default

db.history.sqlmanager=org.opencms.db.oracle.CmsSqlManager

 

db.cos.pool=opencms:default

 

#

# Ethernet address used for UUID generation

# Server name used for various messages

########################################################################
#########

server.ethernet.address=00:03:ba:16:ed:4e

server.name=OpenCmsServer

 

#

# Enable/Disable OpenCms Setup Wizard

# The wizard sets the flag to false after the setup.

# To use the wizard again, reset it manually to true.

# By setting no value, wizard can always be used.

########################################################################
#########

wizard.enabled=false

 

#

# Enable/Disable exception thrown during servlet initialization.

# If disabled there is no attempt to reinitialize the servlet, so the
servlet

# container has to be restarted, as required by some servlet containers
that

# does not like servlets throwing exceptions during initialization.

# valid values are true, false and auto. default is auto

########################################################################
#########

servlet.exception.enabled=auto

 

 

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://webmail.opencms.org/pipermail/opencms-dev/attachments/20100505/f4a0ee43/attachment.htm>