Re: [dods] Could not create logical database error

["Sinisa Milosevic" <sinisa@xxxxxxxxxxxxx>]

Hi,

Try to remove driver jar file from Server.ClassPath entry. Maybe problem is
different classloader for dods jars and jdbc driver classes.
I think it will be enough to put postgres driver jar into same directory
with EAF and dods jars (multiserver/lib/ext)

Regards,
Sinisa


----- Original Message ----- 
From: "Daniel Guryca" <daniel.guryca@xxxxxxxxxx>
To: <dods@xxxxxxxxxxxxx>
Sent: Tuesday, October 25, 2005 4:18 PM
Subject: [dods] Could not create logical database error


> Hi,
>
> I am trying to run EE6.5 with DODS and PostgreSQL but I am still getting
> the same error Could not create logical database error.
>
> I have tried to set database resources via conf file and also via JNDI.
> None of these works.
>
> To get to compile my project I had to change some build files (in
> business, data directories) - I only added classpathes to data class and
> business directories. (without this trick I was not able to compile my
> project with ant).
> Now it compiles with no problems. But still getting Could not create
> logical database error when starting Jonas server.
>
> Thank you for your advice.
>
> My conf:
>
> #
> #  sere
> #  Enhydra Application
> #
> #  Simple Enhydra application configuration file.
> #
>
> #
> # Logger configuration
> #
>
> LogClassName=com.lutris.logging.MonologLogger
> #Monolog = ../../../../conf/trace.properties
>
> Server.ClassPath[] =
>
"/opt/enhydra-enterprise-6.5/multiserver/lib/commons/jonas/postgresql/postgr
esql-7.2.jar"
>
> #
> # The fully qualified name of the application class.
> #
> Server.AppClass = sere.Sere
>
> #
> # Prefix used to derive presentation object class
> # names and paths from URLs.
> # Assumes run from the output directory for debugging.
> #
> Server.PresentationPrefix = "sere/presentation"
>
> #
> # Flag to indicate that application classes and resources should be
reloaded
> # automatically if ANY file in the CLASSPATH changes.  NOTE:  This is a
> # debugging option and may slow down the performance of your application.
> # The CLASSPATH should NOT contain any directories (or underlying
> directories)
> # that contain constantly changing files, i.e. a log file.  For example,
do
> # NOT include the application's output directory in the CLASSPATH because
it
> # contains the application log files in the underlying log directory.
> #
> Server.AutoReload = false
>
> Server.XMLC.DeferredParsing = false
>
> #
> # Maximum number of minutes a user session can last.
> #
> SessionManager.Lifetime = 60
>
> #
> # Maximum number of minutes a user may be idle before being logged off.
> #
> SessionManager.MaxIdleTime = 2
>
> #
> # Flag to indicate that SessionManager will be held in memory
> # during restart application (default is false).
> #
> #SessionManager.MemoryPersistence = true
>
> #
> # The session home implementation to use.  May
> # be one of {BASIC, PAGE_TO_DISK, PAGE_TO_DB, CUSTOM}.
> #
> #SessionManager.SessionHome.Mode = BASIC
>
> #
> # Maximum number of concurrent sessions.
> #
> #SessionManager.SessionHome.MaxSessions = 100
>
> #
> # PAGE_TO_* settings
> # ------------------
> # The following settings are required by all paged (DISK, DB)
> implementations.
> #
> # The maximum number of sessions that will be held in memory
simultaneously.
> #SessionManager.SessionHome.PageThreshold = 50
>
> # The maximum amount of time that a session will remain in memory
> # in an inactive (passive) state.  If this amount of time is exceeded
> # then the session is paged out.  The value is in seconds.
> #SessionManager.SessionHome.PageTimeThreshold = 60
>
> # The maximum amout of time that a thread will wait for a
> # session to be paged back into memory.  In milliseconds.
> #SessionManager.SessionHome.PageWait = 5000
>
> #
> # Flag to indicate that sessions should be paged and reloaded
> # during application restart (default is false).
> # This parameter has no effect if use MemoryPersistence = true.
> # Important: Don't use same directory for pageDir key in
> # PAGE_TO_DISK settings for different applications.
> #
> #SessionManager.SessionHome.SaveOnRestart = true
>
> #
> # PAGE_TO_DISK settings
> # ---------------------
> #
> # The directory where sessions will be paged.  This setting is required
> # when using PAGE_TO_DISK.
> #SessionManager.SessionHome.PageDir = /tmp/page
>
> #
> # PAGE_TO_DB session home settings
> # --------------------------------
> # NOTE: to use PAGE_TO_DB you'll need your database properly configured.
> #
> # If the following is not specified then sessions are paged to the
> default database.
> #SessionManager.SessionHome.DatabaseName = _enter_db_name_here
>
> # If the following is not specified then session data is written
> # to the table "PersistenSession"
> #SessionManager.SessionHome.DBTableName = PersistentSession
>
> #
> # CUSTOM session home settings
> # ----------------------------
> # The following settings are required when using custom session home
> interfaces.
> #
> #SessionManager.SessionUserTable.Class =
> #SessionManager.SessionHome.Class =
>
>
>
>
> #
> # If the URL "/" for this application is accessed, the user will be
> # redirected to this URL. This should be a relative URL.
> #
> Application.DefaultUrl = "WelcomePresentation.po"
>
> #
> # List of all available presentation tools which can be used for dynamic
> # manipulation of pages in presentation layer of the application. For
> each tool,
> # which is listed beyond, in process of application initialization, will
be
> # created factory object (for example XMLCFactory or JivanFactory) with
> not null
> # value. If this parameter is omitted, the default value "xmlc" will be
> assumed
> # which means that, in presentation layer, only XMLC can be used. In
> current
> # release available tools are: "xmlc" and "jivan"
> #
> Application.PresentationTools[] = xmlc
>
>
#---------------------------------------------------------------------------
--
> #                     Presentation Manager Configuration
>
#---------------------------------------------------------------------------
--
> #
> # Enables or disables caching of presentation object classes in memory.
> # Option, the default is true.
> #
> PresentationManager.CacheClasses = true
>
> #
> # Enables or disables caching of files (html, gif, etc) that are servered
as
> # part of the application. Option, the default is false.
> #
> PresentationManager.CacheFiles = true
>
>
#---------------------------------------------------------------------------
--
> #                   Database Manager Configuration
>
#---------------------------------------------------------------------------
--
> #
> #
> DatabaseManager.Databases[] = "sere"
> #
> # The default database used in this application.
> #
> DatabaseManager.DefaultDatabase = "sere"
>
> #DatabaseManager.DB.sere.Connection.DataSourceName = "pokus"
> #
> # Turn on/off debugging for transactions or queries. Valid values
> # are "true" or "false".
> #
> DatabaseManager.Debug = "true"
>
> #
> # The type of database. Normally this is "Standard".
> #
> DatabaseManager.DB.sere.ClassType = "PostgreSQL"
>
> #
> # The jdbc driver to use.
> #
> DatabaseManager.DB.sere.JdbcDriver = "org.postgresql.Driver"
>
> #
> # Database url.
> #
> DatabaseManager.DB.sere.Connection.Url =
> "jdbc:postgresql://localhost/sere?charSet=utf8"
>
> #
> # Database user name.  All connection are allocated by this user.
> #
> DatabaseManager.DB.sere.Connection.User = "pel"
>
> #
> # Database user password.
> #
> DatabaseManager.DB.sere.Connection.Password = ""
>
> #
> # The maximum number of connections that a connection
> # pool will hold.  If set to zero, then connections
> # are allocated indefinitly or until the database
> # refuses to allocate any new connections.
> #
> #DatabaseManager.DB.sere.Connection.MaxPoolSize = 0
>
> #
> # Maximum amount of time that a thread will wait for
> # a connection from the connection pool before an
> # exception is thrown.  This will prevent possible dead
> # locks.  The time out is in milliseconds.  If the
> # time out is <= zero, the allocation of connections
> # will wait indefinitely.
> #
> #DatabaseManager.DB.sere.Connection.AllocationTimeout = 10000
>
> #
> # Used to log database (SQL) activity.
> #
> #DatabaseManager.DB.sere.Connection.Logging = false
>
> #
> # The number of object identifiers that are allocated
> # as a group and held in memory.  These identifiers
> # are assigned to new data objects that are inserted
> # into the database.
> #
> #DatabaseManager.DB.sere.ObjectId.CacheSize = 20
> #DatabaseManager.DB.sere.ObjectId.MinValue = 1000000
>
> # Postgres specific
> DatabaseManager.ObjectIdColumnName = "objectid"
> DatabaseManager.VersionColumnName = "objectversion"
>
>
>
>
>
>
>


----------------------------------------------------------------------------
----


>
> --
> You receive this message as a subscriber of the dods@xxxxxxxxxxxxx mailing
list.
> To unsubscribe: mailto:dods-unsubscribe@xxxxxxxxxxxxx
> For general help: mailto:sympa@xxxxxxxxxxxxx?subject=help
> ObjectWeb mailing lists service home page: http://www.objectweb.org/wws
>