RE: [Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index] Re: Enhydra: enhydra5.0 and postgresql-7.2 -- how to connect?

It looks like your driver name and your URL are incorrect. Also, you
need to make sure that your jdbc.jar is in the classpath of your
multiserver. This is done in the multiserver startup script
ENHYDRA_HOME/bin/multiserver. Below is an example of what your app.conf
should look like for a postgresql database. 

#-----------------------------------------------------------------------
--------
# Database
#-----------------------------------------------------------------------
--------
# Added to fix the oid / version problem
#---------------------------------------
DatabaseManager.ObjectIdColumnName = "ObjectId"
DatabaseManager.VersionColumnName = "ObjectVersion"
#---------------------------------------
DatabaseManager.Databases[] = simpledb
DatabaseManager.DefaultDatabase = simpledb
DatabaseManager.Debug = false
DatabaseManager.DB.simpledb.ClassType = PostgreSQL
DatabaseManager.DB.simpledb.Connection.User = pguser
DatabaseManager.DB.simpledb.Connection.Password =
DatabaseManager.DB.simpledb.Connection.MaxPoolSize = 5
DatabaseManager.DB.simpledb.Connection.AllocationTimeout = 10
DatabaseManager.DB.simpledb.Connection.Logging = true
DatabaseManager.DB.simpledb.Connection.MaxPreparedStatements = 10
DatabaseManager.DB.simpledb.ObjectId.CacheSize = 2
DatabaseManager.DB.simpledb.ObjectId.MinValue = 1
DatabaseManager.DB.simpledb.JdbcDriver = org.postgresql.Driver
DatabaseManager.DB.simpledb.Connection.Url =
"jdbc:postgresql://database.mydomain.com:5432/simpledb"


> -----Original Message-----
> From: enhydra-admin@xxxxxxxxxxx 
> [mailto:enhydra-admin@xxxxxxxxxxx] On Behalf Of damar thapa
> Sent: Thursday, February 06, 2003 6:56 AM
> To: enhydra@xxxxxxxxxxx
> Subject: Enhydra: [Date Prev][Date Next][Thread Prev][Thread 
> Next][Date Index][Thread Index] Re: Enhydra: enhydra5.0 and 
> postgresql-7.2 -- how to connect?
> 
> 
> Hi,
> 
> Thanks,
> 
> The following is the content of my simpleDB.conf.in:
> 
> 
> #
> #  simpleDB
> #  Enhydra Application
> #
> #  Simple Enhydra application configuration file.
> #
> 
> #
> # Comma separated CLASSPATH directories and files used by 
> this application. # You must rebuild the jar after every 
> change to the app. # Server.ClassPath[] = 
> "/home/damar/simpledb/simpleDB/output/lib/simpleDB.jar"
> #Server.ClassPath[] = 
> "/home/damar/simpledb/simpleDB/output/../classes"
> 
> #
> # The fully qualified name of the application class.
> #
> Server.AppClass = simpledb.SimpleDB
> 
> #
> # Prefix used to derive presentation object class
> # names and paths from URLs.
> # Assumes run from the output directory for debugging.
> #
> Server.PresentationPrefix = "simpledb/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.AutoRecompilation = true
> 
> #
> # 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" # 
> PresentationManager.CacheFiles = true #
> 
> 
> #-------------------------------------------------------------
> ----------------
> #                   Database Manager Configuration
> #-------------------------------------------------------------
> ----------------
> #
> #
> DatabaseManager.Databases[] = "simpledb"
> #
> # The default database used in this application.
> #
> DatabaseManager.DefaultDatabase = "simpledb"
> #
> # Turn on/off debugging for transactions or queries. Valid 
> values # are "true" or "false". # DatabaseManager.Debug = 
> "false" # # The type of database. Normally this is 
> "Standard". # DatabaseManager.DB.simpledb.ClassType = 
> "PostgreSQL" # # The jdbc driver to use. # 
> DatabaseManager.DB.simpledb.JdbcDriver = 
> "org.postgresql.Driver" # # Database url. # 
> DatabaseManager.DB.simpledb.Connection.Url = 
> "jdbc:postgresql:simpledb" # # Database user name.  All 
> connection are allocated by this user. # 
> DatabaseManager.DB.simpledb.Connection.User = "damar" # # 
> Database user password. # 
> DatabaseManager.DB.simpledb.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.simpledb.Connection.MaxPoolSize = 30 # # 
> 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.simpledb.Connection.AllocationTimeout = 
> 10000 # # Used to log database (SQL) activity. # 
> DatabaseManager.DB.simpledb.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.simpledb.ObjectId.CacheSize = 20 
> DatabaseManager.DB.simpledb.ObjectId.MinValue = 1000000
> 
> DatabaseManager.ObjectIdColumnName = "ObjectId" 
> DatabaseManager.VersionColumnName = "ObjectVersion"
> 
> 
> 
> Thanks once again.
> 
> Damar
> 
> 
> damar thapa wrote:
> >> Hi,
> [...]
> >> 
> >> Any pointers would be highly appreciated.
> 
> >Most likely the problem is in your application .conf file. Could you
> >send it to the mailing list?
> 
> >Marco.
> 
> -- 
> Marco Leal
> MobiComp - Mobile Computing & Wireless Solutions 
http://www.mobicomp.com/

"Enjoy your job, make lots of money, work within the law. Choose any
two."




_______________________________________________
Enhydra mailing list
Enhydra@xxxxxxxxxxx http://www.enhydra.org/mailman/listinfo.cgi/enhydra