The value of schema isn't passed to the database driver for config.
Jackrabbit uses the value to look up a sql script resource file. That
file has db specific commands for creating the required tables as
necessary.
As a rule of thumb the value matches the database in use. In this case,
set the value to "postgresql" for a postgresql database.
--David
sthikkireddy wrote:
Hi list,
I am deploying the magnolia with the changes for database
configuration. I configured magnolia repository to postgreSQL. My
jackrabbit-pgsql-search.xml file is as follows
<param name="driver" value="org.postgresql.Driver"/>
<param name="url"
value="jdbc:postgresql://127.0.0.1:5432/magnolia_public?autoReconnect=true"/>
<param name="schema" value="public"/>
<param name="user" value="postgres"/>
<param name="password" value="postgres"/>
But it is throwing the error as follows
ERROR info.magnolia.jackrabbit.ProviderImpl
ProviderImpl.java(init:176) 15.05.2007 14:37:03 Unable to initialize
repository: Cannot instantiate persistence manager
org.apache.jackrabbit.core.state.db.SimpleDbPersistenceManager:
Configuration error: unknown schema 'public'
javax.jcr.RepositoryException: Cannot instantiate persistence manager
org.apache.jackrabbit.core.state.db.SimpleDbPersistenceManager:
Configuration error: unknown schema 'public': Configuration error:
unknown schema 'public'
what should be the problem. I have created two databases as
magnolia_author and magnolia_public. What should be the schema value
in the above code. I have not specified any value for schema in pgsql.
we are using pgadmin as a tool for DB admin console.
regards
sthikkireddy
----------------------------------------------------------------
for list details see
http://documentation.magnolia.info/docs/en/editor/stayupdated.html
----------------------------------------------------------------
----------------------------------------------------------------
for list details see
http://documentation.magnolia.info/docs/en/editor/stayupdated.html
----------------------------------------------------------------
