Fw: [dods] Could not create logical database error

["Sinisa Milosevic" <sinisa@xxxxxxxxxxxxx>]

----- Original Message ----- 
From: "Daniel Guryca" <daniel.guryca@xxxxxxxxxx>
To: <dods@xxxxxxxxxxxxx>
Sent: Monday, October 31, 2005 8:13 AM
Subject: Re: [dods] Could not create logical database error


> Sinisa Milosevic wrote:
>
> >Hi Daniel,
> >
> >Problem is somewhere in configuration. You have a lot of examples which
> >works with databases in Enhydra (all examples works with HSQL database,
but
> >also we tested DODS with other database vendors (PostgreSQL and MySQL
> >also)). All application configuration parameters are stored in
application
> >web.xml files and in context.xml (DataSource definition).
> >
> >Did you get any stack trace in log file?
> >
> >Regarding your move to Enhydra Server. In Enhydra Enterprise 6.5 and
Enhydra
> >Server 6.5, there are same version of Enhydra components (EAF, DODS,
> >XMLC....). So question for migration is : Do you need J2EE environment
for
> >your application (Enhydra Enterprise) or you can live with standard
Tomcat +
> >EAF + Enhydra tools (Enhydra Server)?
> >
> >Regards,
> >Sinisa
> >
> >----- Original Message ----- 
> >From: "Daniel Guryca" <daniel.guryca@xxxxxxxxxx>
> >To: <dods@xxxxxxxxxxxxx>
> >Sent: Thursday, October 27, 2005 2:31 AM
> >Subject: Re: [dods] Could not create logical database error
> >
> >
> >
> >
> >>Daniel Guryca wrote:
> >>
> >>
> >>
> >>>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/postg
r
> >
> >
> >>>>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 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
> >>>>
> >>>>
> >>>>
> >>>>
> >>>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.
> >>>
>
>>>------------------------------------------------------------------------
> >>>
> >>>
> >>>--
> >>>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
> >>>
> >>>
> >>>
> >>>
> >>I have tried also Mysql database with Mysql J-Connector driver.
> >>I am still getting same errors.
> >>
> >>If I use these directives:
> >>DatabaseManager.DB.sere.ConnectionAllocator =
> >>com.lutris.appserver.server.sql.datasource.DataSourceConnectionAllocator
> >>
> >>DatabaseManager.DB.sere.Connection.ConnectionFactory =
> >>com.lutris.appserver.server.sql.DataSourceDBConnectionFactory
> >>
> >>in my application.conf the printed error is Could not create logical
> >>database.
> >>
> >>If I don't use these directives the printed error is Failed to make
> >>standard connection allocator.
> >>
> >>I have no other ideas what more to combine. (so I am going to say
> >>good-bye to Enterprise and going to test noenterprise enhydra version.
> >>
> >>Any ideas are welcome.
> >>Thank you.
> >>
> >>
> >>
> >>
> >
> >
>
>---------------------------------------------------------------------------
-
> >----
> >
> >
> >
> >
> >>--
> >>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 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
> >
> >
> I have found the problem. The problem was in configuration file
> (app.conf) of my application. With that file it did not work even if I
> set directives(in web.xml) to use this file instead of web.xml file.
> Interesting thing is that other then database directives (in my app.conf
> file) were working properly. So it confused me.
>
> Now with web.xml configuration everything works properly.
> Thank you for your patience.
>
>


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


>
> --
> 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 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