Re: datasource configuration

Thu, 02 Jun 2005 05:44:42 -0700 


What is the configuration here ?

What OS / version ?
What database / version ?
What version of Jahia ?
It's the first time I see this fail halfway through. The only thing I could think of would be some kind of connection pool configuration problem or something like that. 

Regards,
 Serge Huber.

tom * wrote:


Hi,

well the logging in debug mode contains the following lines:
=2005-05-19 16:35:06,715 DEBUG bin.Jahia initServicesRegistry - Start the Services Registry ... =2005-05-19 16:35:06,747 DEBUG registries.ServicesRegistry <init> - ***** Starting Services Registry ***** =2005-05-19 16:35:06,747 DEBUG registries.ServicesRegistry getServiceInstance - Attempting to instantiate service class 
[org.jahia.services.cache.CacheFactory]
=2005-05-19 16:35:06,778 DEBUG registries.ServicesRegistry loadService - Registering services ended. Current 
registry size=1
=2005-05-19 16:35:06,778 DEBUG registries.ServicesRegistry init - Loaded Service [JahiaCacheService] class 
[org.jahia.services.cache.CacheFactory]
=2005-05-19 16:35:06,778 DEBUG registries.ServicesRegistry getServiceInstance - Attempting to instantiate service class 
[org.jahia.services.acl.JahiaACLManagerService]
=2005-05-19 16:35:06,856 DEBUG database.ConnectionDispenser getConnection - Retrieving new connection from pool... =2005-05-19 16:35:08,168 DEBUG acl.JahiaACLManagerService init - Preloading 10000 ACLs from the database =2005-05-19 16:35:08,918 DEBUG acl.AclDBUtils preloadPageACLs - Preloading Page ACL =2005-05-19 16:35:09,028 DEBUG acl.AclDBUtils preloadPageACLs - preloading Page ACL, has loaded 279 ACLs 
in cache
=2005-05-19 16:35:09,028 DEBUG acl.AclDBUtils preloadPageFieldACLs - Preloading Page Field ACL =2005-05-19 16:35:09,293 DEBUG acl.AclDBUtils preloadPageFieldACLs - preloading Page Field ACL, has loaded 278 
ACLs in cache
=2005-05-19 16:35:09,293 DEBUG acl.AclDBUtils preloadContainerListACLs - Preloading Container List ACL =2005-05-19 16:35:09,450 DEBUG acl.AclDBUtils preloadContainerListACLs - preloading Container List ACL, has loaded 
463 ACLs in cache
=2005-05-19 16:35:09,450 DEBUG registries.ServicesRegistry loadService - Registering services ended. Current 
registry size=2
=2005-05-19 16:35:09,450 DEBUG registries.ServicesRegistry init - Loaded Service [JahiaACLManagerService] 
class [org.jahia.services.acl.JahiaACLManagerService]
=2005-05-19 16:35:09,450 DEBUG registries.ServicesRegistry getServiceInstance - Attempting to instantiate service class 
[org.jahia.services.database.JahiaIncrementorsDBBaseService]
=2005-05-19 16:35:09,465 DEBUG database.JahiaIncrementorsDBBaseService
<init>                    - ***** Starting the Jahia Incrementors DB
Base Service *****
=2005-05-19 16:35:09,465 DEBUG registries.ServicesRegistry loadService - Registering services ended. Current 
registry size=3
=2005-05-19 16:35:09,465 DEBUG registries.ServicesRegistry init - Loaded Service 
[JahiaIncrementorsDBService] class
[org.jahia.services.database.JahiaIncrementorsDBBaseService]
=2005-05-19 16:35:09,465 DEBUG registries.ServicesRegistry getServiceInstance - Attempting to instantiate service class 
[org.jahia.services.files.JahiaFileTransferBaseService]
=2005-05-19 16:35:09,481 DEBUG files.JahiaFileTransferBaseService <init> - Starting JahiaFileTransferBaseService =2005-05-19 16:35:09,481 DEBUG files.JahiaFileTransferBaseService init - Initializing JahiaFileTransferBaseService =2005-05-19 16:35:09,481 DEBUG registries.ServicesRegistry loadService - Registering services ended. Current 
registry size=4
=2005-05-19 16:35:09,481 DEBUG registries.ServicesRegistry init - Loaded Service [JahiaFileTransferService] 
class [org.jahia.services.files.JahiaFileTransferBaseService]
=2005-05-19 16:35:09,481 DEBUG registries.ServicesRegistry getServiceInstance - Attempting to instantiate service class 
[org.jahia.services.files.JahiaTextFileBaseService]
=2005-05-19 16:35:09,481 DEBUG files.JahiaTextFileBaseService <init> - ***** Starting JahiaTextFileService ***** =2005-05-19 16:35:09,559 DEBUG registries.ServicesRegistry loadService - Registering services ended. Current 
registry size=5
=2005-05-19 16:35:09,559 DEBUG registries.ServicesRegistry init - Loaded Service [JahiaTextFileService] 
class [org.jahia.services.files.JahiaTextFileBaseService]
=2005-05-19 16:35:09,559 DEBUG registries.ServicesRegistry getServiceInstance - Attempting to instantiate service class 
[org.jahia.services.pages.JahiaPageTemplateBaseService]




then it goes on with registering and instantiating until here:
=2005-05-19 16:35:12,887 DEBUG lock.LockEngine <init> - ***** Starting 
org.jahia.engines.lock.LockEngine engine *****
=2005-05-19 16:35:12,887 DEBUG registries.EnginesRegistry init - Engine [lock] successfully registered. =2005-05-19 16:35:12,887 DEBUG registries.EnginesRegistry getEngineInstance - Attempting to instantiate engine class 
[org.jahia.engines.users.EditUserPreferences_Engine]
=2005-05-19 16:35:12,887 DEBUG users.EditUserPreferences_Engine <init> - ***** Starting 
org.jahia.engines.users.EditUserPreferences_Engine engine *****
=2005-05-19 16:35:12,887 DEBUG registries.EnginesRegistry init - Engine [edituserpreferences] successfully 
registered.
=2005-05-19 16:35:12,887 DEBUG registries.EnginesRegistry getEngineInstance - Attempting to instantiate engine class 
[org.jahia.engines.users.NewUserRegistration_Engine]
=2005-05-19 16:35:12,903 DEBUG users.NewUserRegistration_Engine <init> - ***** Starting 
org.jahia.engines.users.NewUserRegistration_Engine engine *****
=2005-05-19 16:35:12,903 DEBUG registries.EnginesRegistry init - Engine [newuserregistration] successfully 
registered.
=2005-05-19 16:35:12,903 DEBUG registries.EnginesRegistry getEngineInstance - Attempting to instantiate engine class 
[org.jahia.engines.mysettings.MySettingsEngine]
=2005-05-19 16:35:12,903 DEBUG mysettings.MySettingsEngine <init> - ***** Starting 
org.jahia.engines.mysettings.MySettingsEngine engine *****
=2005-05-19 16:35:12,903 DEBUG registries.EnginesRegistry init - Engine [mysettings] successfully 
registered.
=2005-05-19 16:35:12,918 DEBUG
registries.JahiaFieldDefinitionsRegistry <init>                    -
Starting FieldDefinitions Registry
=2005-05-19 16:35:14,122 DEBUG utils.FileUtils <init> - Starting fileUtils 
=2005-05-19 16:35:16,075 DEBUG
registries.JahiaContainerDefinitionsRegistry <init> - Starting ContainerDefinitions Registry =2005-05-19 16:35:16,184 ERROR containers.JahiaContainerDefinitionsDB db_load_container_definition - Error in db_load_container_definition 
: Invalid operation: result set closed -> BAILING OUT
=2005-05-19 16:35:16,184 ERROR bin.Jahia init - Error during initialization of Jahia =2005-05-19 16:35:16,184 DEBUG exceptions.JahiaException init - (PrintWriter s) called. =2005-05-19 16:35:16,200 DEBUG exceptions.JahiaException init - called. 
org.jahia.exceptions.JahiaException: Cannot load fields from the
database, Error in db_load_container_definition : Invalid operation:
result set closed -> BAILING OUT
        at 
org.jahia.services.containers.JahiaContainerDefinitionsDB.db_load_container_definition(JahiaContainerDefinitionsDB.java:136)
        at 
org.jahia.services.containers.JahiaContainersBaseService.loadContainerDefinition(JahiaContainersBaseService.java:1998)
        at 
org.jahia.registries.JahiaContainerDefinitionsRegistry.loadAllDefinitions(JahiaContainerDefinitionsRegistry.java:104)
        at 
org.jahia.registries.JahiaContainerDefinitionsRegistry.init(JahiaContainerDefinitionsRegistry.java:80)
        at org.jahia.bin.Jahia.init(Jahia.java:461)
So it seems to me the datasource is accessible. The datasource connection is tested with the sql string "SELECT 
ID_JAHIA_CTN_DEF FROM JAHIA_CTN_DEF", which also succeeds.

Greets,
Tom.

Reply via email to