Following up to my post, in
case anyone trying to set up Postgres clustering lands on this thread.
See:
https://issues.apache.org/jira/browse/JCR-1174?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
Postgresql doesn't provide the varbinary type. Copy
org/apache/jackrabbit/core/journal/default.ddl to
org/apache/jackrabbit/core/journal/postgresql.ddl and change the
varbinary to bytea
Debbie Troxel wrote:
I'm running the 1.3.3
Resource Adapter under Glassfish on Linux.
The persistence managers for the repository and versioning are
connecting to Postgres. This seems to be working and I can
successfully run some simple tests.
When I try to add a Cluster config to the repository.xml, I get an
error (below) when the application server starts up.
Here is the Cluster config:
<Cluster id="dbdev">
<Journal
class="org.apache.jackrabbit.core.journal.DatabaseJournal">
<param name="revision" value="${rep.home}/revision.log" />
<param name="driver" value="org.postgresql.Driver" />
<param name="url"
value="jdbc:postgresql://localhost:5432/XXX" />
<param name="schema" value="postgresql"/>
<param name="user" value="XXX"/>
<param name="password" value="XXX"/>
</Journal>
</Cluster>
If I comment out the above, there are no errors on start up and
everything seems OK. The Journal db parameters are all the same as
what I use for the SimpleDBPersistenceManager, except there I also
provide the schemaObjectPrefix and set externalBlobs=false.
I am doing something obviously wrong? Is there a way to get more
detailed logging? Any suggestions?
Thanks very much for any help!
Debbie
Error stack trace from server.log:
[#|2007-12-04T16:23:23.478-0500|SEVERE|sun-appserver-pe9.0|javax.enterprise.system.core.naming|_ThreadID=10;_ThreadName=main;_RequestID=db5fa69d-7e65-43b9-a42e-5b5946043a3b;|NAM0004:
Exception during name lookup : {0}
javax.resource.ResourceException: Failed to create session: Unable to
initialize connection.
at
org.apache.jackrabbit.jca.JCAManagedConnectionFactory.createRepository(JCAManagedConnectionFactory.java:293)
at
org.apache.jackrabbit.jca.JCAManagedConnectionFactory.createConnectionFactory(JCAManagedConnectionFactory.java:124)
at
com.sun.enterprise.naming.factory.ConnectorObjectFactory.getObjectInstance(ConnectorObjectFactory.java:117)
at
javax.naming.spi.NamingManager.getObjectInstance(NamingManager.java:304)
at
com.sun.enterprise.naming.SerialContext.lookup(SerialContext.java:314)
at javax.naming.InitialContext.lookup(InitialContext.java:392)
at
com.sun.enterprise.naming.NamingManagerImpl.bindObjects(NamingManagerImpl.java:369)
at
com.sun.enterprise.web.WebContainer.loadWebModule(WebContainer.java:1451)
at
com.sun.enterprise.web.WebContainer.loadStandaloneWebModule(WebContainer.java:973)
at
com.sun.enterprise.web.WebContainer.loadWebModules(WebContainer.java:918)
at
com.sun.enterprise.web.WebContainer.start(WebContainer.java:775)
at
com.sun.enterprise.web.PEWebContainer.startInstance(PEWebContainer.java:722)
at
com.sun.enterprise.web.PEWebContainerLifecycle.onStartup(PEWebContainerLifecycle.java:72)
at
com.sun.enterprise.server.ondemand.ServiceGroup.startLifecycleServices(ServiceGroup.java:266)
at
com.sun.enterprise.server.ondemand.WebServiceGroup.startLifecycleServices(WebServiceGroup.java:210)
at
com.sun.enterprise.server.ondemand.WebServiceGroup.start(WebServiceGroup.java:60)
at
com.sun.enterprise.server.ondemand.ServiceGroup$1.run(ServiceGroup.java:180)
at
com.sun.enterprise.server.ondemand.WebServiceGroup.start(WebServiceGroup.java:60)
at
com.sun.enterprise.server.ondemand.ServiceGroup$1.run(ServiceGroup.java:180)
at java.security.AccessController.doPrivileged(Native Method)
at
com.sun.enterprise.server.ondemand.ServiceGroup.startChildren(ServiceGroup.java:177)
at
com.sun.enterprise.server.ondemand.MainServiceGroup.start(MainServiceGroup.java:45)
at
com.sun.enterprise.server.ondemand.ServerEntryListenerImpl.notifyEntry(ServerEntryListenerImpl.java:72)
at
com.sun.enterprise.server.ondemand.entry.ServerEntryHelper.sendEvent(ServerEntryHelper.java:62)
at
com.sun.enterprise.server.ondemand.entry.ServerEntryHelper.generateAppLoaderEntryContext(ServerEntryHelper.java:47)
at
com.sun.enterprise.server.AbstractLoader.generateEntryContext(AbstractLoader.java:831)
at
com.sun.enterprise.server.AbstractLoader.notifyAppEvent(AbstractLoader.java:837)
at
com.sun.enterprise.server.DummyWebModuleLoader.load(DummyWebModuleLoader.java:62)
at
com.sun.enterprise.server.AbstractManager.load(AbstractManager.java:206)
at
com.sun.enterprise.server.ApplicationLifecycle.onStartup(ApplicationLifecycle.java:201)
at
com.sun.enterprise.server.ApplicationServer.onStartup(ApplicationServer.java:326)
at
com.sun.enterprise.server.ondemand.OnDemandServer.onStartup(OnDemandServer.java:112)
at com.sun.enterprise.server.PEMain.run(PEMain.java:326)
at com.sun.enterprise.server.PEMain.main(PEMain.java:260)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at com.sun.enterprise.server.PELaunch.main(PELaunch.java:272)
|#]
[#|2007-12-04T16:23:23.487-0500|SEVERE|sun-appserver-pe9.0|javax.enterprise.system.core.naming|_ThreadID=10;_ThreadName=main;jcr/testRepository;_RequestID=db5fa69d-7e65-43b9-a42e-5b5946043a3b;|NAM0006:
JMS Destination object not found: jcr/testRepository|#]
[#|2007-12-04T16:23:23.489-0500|SEVERE|sun-appserver-pe9.0|javax.enterprise.system.core.naming|_ThreadID=10;_ThreadName=main;_RequestID=db5fa69d-7e65-43b9-a42e-5b5946043a3b;|javax.naming.CommunicationException
javax.naming.CommunicationException: serial context communication ex
[Root exception is javax.resource.ResourceException: Failed to create
session: Unable to initialize connection.]
at
com.sun.enterprise.naming.SerialContext.lookup(SerialContext.java:338)
at javax.naming.InitialContext.lookup(InitialContext.java:392)
at
com.sun.enterprise.naming.NamingManagerImpl.bindObjects(NamingManagerImpl.java:369)
at
com.sun.enterprise.web.WebContainer.loadWebModule(WebContainer.java:1451)
at
com.sun.enterprise.web.WebContainer.loadStandaloneWebModule(WebContainer.java:973)
at
com.sun.enterprise.web.WebContainer.loadWebModules(WebContainer.java:918)
at
com.sun.enterprise.web.WebContainer.start(WebContainer.java:775)
at
com.sun.enterprise.web.PEWebContainer.startInstance(PEWebContainer.java:722)
at
com.sun.enterprise.web.PEWebContainerLifecycle.onStartup(PEWebContainerLifecycle.java:72)
at
com.sun.enterprise.server.ondemand.ServiceGroup.startLifecycleServices(ServiceGroup.java:266)
at
com.sun.enterprise.server.ondemand.WebServiceGroup.startLifecycleServices(WebServiceGroup.java:210)
at
com.sun.enterprise.server.ondemand.WebServiceGroup.start(WebServiceGroup.java:60)
at
com.sun.enterprise.server.ondemand.ServiceGroup$1.run(ServiceGroup.java:180)
at java.security.AccessController.doPrivileged(Native Method)
at
com.sun.enterprise.server.ondemand.ServiceGroup.startChildren(ServiceGroup.java:177)
at
com.sun.enterprise.server.ondemand.MainServiceGroup.start(MainServiceGroup.java:45)
at
com.sun.enterprise.server.ondemand.ServerEntryListenerImpl.notifyEntry(ServerEntryListenerImpl.java:72)
at
com.sun.enterprise.server.ondemand.entry.ServerEntryHelper.sendEvent(ServerEntryHelper.java:62)
at
com.sun.enterprise.server.ondemand.entry.ServerEntryHelper.generateAppLoaderEntryContext(ServerEntryHelper.java:47)
at
com.sun.enterprise.server.AbstractLoader.generateEntryContext(AbstractLoader.java:831)
at
com.sun.enterprise.server.ondemand.entry.ServerEntryHelper.generateAppLoaderEntryContext(ServerEntryHelper.java:47)
at
com.sun.enterprise.server.AbstractLoader.generateEntryContext(AbstractLoader.java:831)
at
com.sun.enterprise.server.AbstractLoader.notifyAppEvent(AbstractLoader.java:837)
at
com.sun.enterprise.server.DummyWebModuleLoader.load(DummyWebModuleLoader.java:62)
at
com.sun.enterprise.server.AbstractManager.load(AbstractManager.java:206)
at
com.sun.enterprise.server.ApplicationLifecycle.onStartup(ApplicationLifecycle.java:201)
at
com.sun.enterprise.server.ApplicationServer.onStartup(ApplicationServer.java:326)
at
com.sun.enterprise.server.ondemand.OnDemandServer.onStartup(OnDemandServer.java:112)
at com.sun.enterprise.server.PEMain.run(PEMain.java:326)
at com.sun.enterprise.server.PEMain.main(PEMain.java:260)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at com.sun.enterprise.server.PELaunch.main(PELaunch.java:272)
Caused by: javax.resource.ResourceException: Failed to create session:
Unable to initialize connection.
at
org.apache.jackrabbit.jca.JCAManagedConnectionFactory.createRepository(JCAManagedConnectionFactory.java:293)
at
org.apache.jackrabbit.jca.JCAManagedConnectionFactory.createConnectionFactory(JCAManagedConnectionFactory.java:124)
at
com.sun.enterprise.naming.factory.ConnectorObjectFactory.getObjectInstance(ConnectorObjectFactory.java:117)
at
javax.naming.spi.NamingManager.getObjectInstance(NamingManager.java:304)
at
com.sun.enterprise.naming.SerialContext.lookup(SerialContext.java:314)
... 32 more
|
