Re: [enhydra] Re: [dods] Could not create logical database error

[Daniel Guryca <daniel.guryca@xxxxxxxxxx>]

Sinisa Milosevic wrote:

> 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
> >
> >    
>
>
>  
>
> ------------------------------------------------------------------------
>
>
> --
> You receive this message as a subscriber of the enhydra@xxxxxxxxxxxxx mailing 
> list.
> To unsubscribe: mailto:enhydra-unsubscribe@xxxxxxxxxxxxx
> For general help: mailto:sympa@xxxxxxxxxxxxx?subject=help
> ObjectWeb mailing lists service home page: http://www.objectweb.org/wws
>  
So I tried what you discribed and it still does not work.

No I am getting Failed to make standard connection allocator error.

Any other ideas?
Thank you.