10 Feb
2010
10 Feb
'10
2:25 p.m.
Hi,
I need some help configuring Glassfish-managed DataSource for XWiki
Enterprise (stable 2.1.1).
In short, does anyone know how to tweak WEB-INF/hibernate.cfg.xml so
that Hibernate uses a JNDI resource that has been configured in
Glassfish? (for instance, i've defined jdbc/xwiki in Glassfish and would
like Hibernate to use it instead of the settings provided inside
WEB-INF/hibernate.cfg.xml).
The long version:
I'm trying to do a manual installation (as in:
http://platform.xwiki.org/xwiki/bin/view/AdminGuide/Installation#HInstallin…
)
on a Glassfish v3 app server, and would like to use a Glassfish managed
datasource (let's say using JNDI jdbc/xwiki as javax.sql.DataSource).
I haven't found explicit details on how to do this, so i started by
commenting out line
xwiki.store.hibernate.path=/WEB-INF/hibernate.cfg.xml
inside file WEB-INF/xwiki.cfg
and uncommenting the following inside WEB-INF/web.xml so that it's used
instead:
<resource-ref>
<description>DB Connection</description>
<res-ref-name>jdbc/xwiki</res-ref-name>
<res-type>javax.sql.DataSource</res-type>
<res-auth>Container</res-auth>
</resource-ref>
But this gave me the following error when, after deploying to Glassfish,
i tried to go to http://localhost:8080/xwiki/bin/view/Main/
HTTP Status 500 -
type Exception report
message
descriptionThe server encountered an internal error () that prevented
it from fulfilling this request.
exception
javax.servlet.ServletException: com.xpn.xwiki.XWikiException: Error number 3 in 0: Could
not initialize main XWiki context
Wrapped Exception: Error number 3001 in 3: Cannot load class
com.xpn.xwiki.store.migration.hibernate.XWikiHibernateMigrationManager from param
xwiki.store.migration.manager.class
Wrapped Exception: Error number 0 in 3: Exception while hibernate execute
Wrapped Exception: Hibernate Dialect must be explicitly set
root cause
com.xpn.xwiki.XWikiException: Error number 3 in 0: Could not initialize main XWiki
context
Wrapped Exception: Error number 3001 in 3: Cannot load class
com.xpn.xwiki.store.migration.hibernate.XWikiHibernateMigrationManager from param
xwiki.store.migration.manager.class
Wrapped Exception: Error number 0 in 3: Exception while hibernate execute
Wrapped Exception: Hibernate Dialect must be explicitly set
Glassfish logs contain the following two logs of this error:
53:44,236 [http://localhost:8080/xwiki/bin/view/Main/]
WARN
UserSuppliedConnectionProvider - No connection properties specified -
the user must supply JDBC connections
and also
53:44,269 [http://localhost:8080/xwiki/bin/view/Main/]
WARN
action.RequestProcessor - Unhandled Exception thrown: class
com.xpn.xwiki.XWikiException
They seem to show that i need to use WEB-INF/hibernate.xml.cfg
to set up the proper vendor Dialect
So i modified WEB-INF/xwiki.cfg so to use the line:
xwiki.store.hibernate.path=/WEB-INF/hibernate.cfg.xml
Then, inside WEB-INF/hibernate.cfg.xml i ONLY uncommented the line
<property
name="dialect">org.hibernate.dialect.MySQLDialect</property>
keeping all others (connection.username, connection.password ...)
commented so to check that the ones provided by Glassfish are being used
instead.
After undeploying previous and deploying this modified version i get a
different error when trying to visit
http://localhost:8080/xwiki/bin/view/Main
HTTP Status 500 -
type Exception report
message
descriptionThe server encountered an internal error () that prevented
it from fulfilling this request.
exception
javax.servlet.ServletException: com.xpn.xwiki.XWikiException: Error number 3 in 0: Could
not initialize main XWiki context
Wrapped Exception: Error number 3001 in 3: Cannot load class
com.xpn.xwiki.store.migration.hibernate.XWikiHibernateMigrationManager from param
xwiki.store.migration.manager.class
Wrapped Exception: Error number 0 in 3: Exception while hibernate execute
Wrapped Exception: Errors in named queries: listGroupsForUser, getSpaceDocsName,
getAllUsers, getAllDocuments, getSpaces, getAllPublicDocuments, getAllSpaceDocuments
root cause
com.xpn.xwiki.XWikiException: Error number 3 in 0: Could not initialize main XWiki
context
Wrapped Exception: Error number 3001 in 3: Cannot load class
com.xpn.xwiki.store.migration.hibernate.XWikiHibernateMigrationManager from param
xwiki.store.migration.manager.class
Wrapped Exception: Error number 0 in 3: Exception while hibernate execute
Wrapped Exception: Errors in named queries: listGroupsForUser, getSpaceDocsName,
getAllUsers, getAllDocuments, getSpaces, getAllPublicDocuments, getAllSpaceDocuments
And in Glassfish logs:
19:04,638 [http://localhost:8080/xwiki/bin/view/Main/]
WARN
UserSuppliedConnectionProvider - No connection properties specified -
the user must supply JDBC connections
and seven more like this one (i truncated the whole stack) that match
the errors in named queries reported above (listGroupsForUser,
getSpaceDocsName,getAllUsers,getAllDocuments,getSpaces,getAllPublicDocuments and
getAllSpaceDocuments) :
19:05,013 [http://localhost:8080/xwiki/bin/view/Main/]
ERROR
impl.SessionFactoryImpl - Error in named query: listGroupsForUser
org.hibernate.hql.ast.QuerySyntaxException: XWikiDocument is not mapped
[ select distinct doc.fullName from XWikiDocument as doc, BaseObject as
obj, StringProperty as prop where obj.name = doc.fullName and
obj.className='XWiki.XWikiGroups' and obj.id = prop.id.id and
prop.id.name='member' and (prop.value=:username or
prop.value=:shortname or prop.value=:veryshortname) ]
This time the errors seem related to the searches themselves...
I think that what might be happening is that Hibernate is not really
configured to be using Glassfish datasource, but instead it expects to
use the connection.username, connection.password,
connection.driver_class, connection.pool_size ... properties defined in
WEB-INF/hibernate.cfg.xml that i've commented out because i'd like to
use Glassfish-configured datasource.
I need help, so as to keep the properties that Hibernate reads from
WEB-INF/hibernate.cfg.xml to a minimum and pointing it to
Glassfish-defined JNDI resource instead.
Thank you very much !
Guillem Plasencia
11 Feb
11 Feb
1:51 p.m.
Hi,
i managed to solve the problems i had trying to use a Glassfish defined DataSource.
Here's how:
-Do
not be creative giving JNDI names in your app server, you must create a
DataSource named exactly jdbc/XWikiDS, which is the name that appears
inside WEB-INF/web.xml and probably is the name used inside XWiki code
-Uncomment the <resource-ref> element inside WEB-INF/web.xml
<resource-ref>
<description>DB Connection</description>
<res-ref-name>jdbc/XWikiDS</res-ref-name>
<res-type>javax.sql.DataSource</res-type>
<res-auth>Container</res-auth>
</resource-ref>
-Use the following connection.datasource property inside WEB-INF/hibernate.cfg.xml:
<property
name="connection.datasource">java:comp/env/jdbc/XWikiDS</property>
-Do
not forget to use this (inside WEB-INF/hibernate.cfg.xml), don't
comment it out, as was nicely explained in the documentation link below.
<property
name="dialect">org.hibernate.dialect.MySQLDialect</property>
-Do not comment out the <mapping> elements inside WEB-INF/hibernate.cfg.xml
<mapping resource="xwiki.hbm.xml"/>
<mapping resource="feeds.hbm.xml"/>
<mapping resource="activitystream.hbm.xml"/>
And now it works, using XWiki Enterprise stable 2.1.1 and Glassfish v3 build 74.2
I hope you don't mind i modified the documentation here
http://platform.xwiki.org/xwiki/bin/view/AdminGuide/Installation so that it's more
clear about the JNDI name to use and not commenting out the <mapping> elements
Thank you !
Guillem
----Mensaje original----
De: GUILLEMP(a)telefonica.net
Fecha: 10/02/2010 14:25
Para: <devs(a)xwiki.org>
Asunto: Using Glassfish managed datasource
Hi,
I need some help configuring Glassfish-managed DataSource for XWiki
Enterprise (stable 2.1.1).
In short, does anyone know how to tweak WEB-INF/hibernate.cfg.xml so
that Hibernate uses a JNDI resource that has been configured in
Glassfish? (for instance, i've defined jdbc/xwiki in Glassfish and would
like Hibernate to use it instead of the settings provided inside
WEB-INF/hibernate.cfg.xml).
The long version:
I'm trying to do a manual installation (as in:
http://platform.xwiki.org/xwiki/bin/view/AdminGuide/Installation#HInstallin…
)
on a Glassfish v3 app server, and would like to use a Glassfish managed
datasource (let's say using JNDI jdbc/xwiki as javax.sql.DataSource).
I haven't found explicit details on how to do this, so i started by
commenting out line
xwiki.store.hibernate.path=/WEB-INF/hibernate.cfg.xml
inside file WEB-INF/xwiki.cfg
and uncommenting the following inside WEB-INF/web.xml so that it's used
instead:
<resource-ref>
<description>DB Connection</description>
<res-ref-name>jdbc/xwiki</res-ref-name>
<res-type>javax.sql.DataSource</res-type>
<res-auth>Container</res-auth>
</resource-ref>
But this gave me the following error when, after deploying to Glassfish,
i tried to go to http://localhost:8080/xwiki/bin/view/Main/
HTTP Status 500 -
type Exception report
message
descriptionThe server encountered an internal error () that prevented
it from fulfilling this request.
exception
javax.servlet.ServletException: com.xpn.xwiki.XWikiException: Error number 3 in 0: Could
not initialize main XWiki context
Wrapped Exception: Error number 3001 in 3: Cannot load class
com.xpn.xwiki.store.migration.hibernate.XWikiHibernateMigrationManager from param
xwiki.store.migration.manager.class
Wrapped Exception: Error number 0 in 3: Exception while hibernate execute
Wrapped Exception: Hibernate Dialect must be explicitly set
root cause
com.xpn.xwiki.XWikiException: Error number 3 in 0: Could not initialize main XWiki
context
Wrapped Exception: Error number 3001 in 3: Cannot load class
com.xpn.xwiki.store.migration.hibernate.XWikiHibernateMigrationManager from param
xwiki.store.migration.manager.class
Wrapped Exception: Error number 0 in 3: Exception while hibernate execute
Wrapped Exception: Hibernate Dialect must be explicitly set
Glassfish logs contain the following two logs of this error:
53:44,236 [http://localhost:8080/xwiki/bin/view/Main/]
WARN
UserSuppliedConnectionProvider - No connection properties specified -
the user must supply JDBC connections
and also
53:44,269 [http://localhost:8080/xwiki/bin/view/Main/]
WARN
action.RequestProcessor - Unhandled Exception thrown: class
com.xpn.xwiki.XWikiException
They seem to show that i need to use WEB-INF/hibernate.xml.cfg
to set up the proper vendor Dialect
So i modified WEB-INF/xwiki.cfg so to use the line:
xwiki.store.hibernate.path=/WEB-INF/hibernate.cfg.xml
Then, inside WEB-INF/hibernate.cfg.xml i ONLY uncommented the line
<property
name="dialect">org.hibernate.dialect.MySQLDialect</property>
keeping all others (connection.username, connection.password ...)
commented so to check that the ones provided by Glassfish are being used
instead.
After undeploying previous and deploying this modified version i get a
different error when trying to visit
http://localhost:8080/xwiki/bin/view/Main
HTTP Status 500 -
type Exception report
message
descriptionThe server encountered an internal error () that prevented
it from fulfilling this request.
exception
javax.servlet.ServletException: com.xpn.xwiki.XWikiException: Error number 3 in 0: Could
not initialize main XWiki context
Wrapped Exception: Error number 3001 in 3: Cannot load class
com.xpn.xwiki.store.migration.hibernate.XWikiHibernateMigrationManager from param
xwiki.store.migration.manager.class
Wrapped Exception: Error number 0 in 3: Exception while hibernate execute
Wrapped Exception: Errors in named queries: listGroupsForUser, getSpaceDocsName,
getAllUsers, getAllDocuments, getSpaces, getAllPublicDocuments, getAllSpaceDocuments
root cause
com.xpn.xwiki.XWikiException: Error number 3 in 0: Could not initialize main XWiki
context
Wrapped Exception: Error number 3001 in 3: Cannot load class
com.xpn.xwiki.store.migration.hibernate.XWikiHibernateMigrationManager from param
xwiki.store.migration.manager.class
Wrapped Exception: Error number 0 in 3: Exception while hibernate execute
Wrapped Exception: Errors in named queries: listGroupsForUser, getSpaceDocsName,
getAllUsers, getAllDocuments, getSpaces, getAllPublicDocuments, getAllSpaceDocuments
And in Glassfish logs:
19:04,638 [http://localhost:8080/xwiki/bin/view/Main/]
WARN
UserSuppliedConnectionProvider - No connection properties specified -
the user must supply JDBC connections
and seven more like this one (i truncated the whole stack) that match
the errors in named queries reported above (listGroupsForUser,
getSpaceDocsName,getAllUsers,getAllDocuments,getSpaces,getAllPublicDocuments and
getAllSpaceDocuments) :
19:05,013 [http://localhost:8080/xwiki/bin/view/Main/]
ERROR
impl.SessionFactoryImpl - Error in named query: listGroupsForUser
org.hibernate.hql.ast.QuerySyntaxException: XWikiDocument is not mapped
[ select distinct doc.fullName from XWikiDocument as doc, BaseObject as
obj, StringProperty as prop where obj.name = doc.fullName and
obj.className='XWiki.XWikiGroups' and obj.id = prop.id.id and
prop.id.name='member' and (prop.value=:username or
prop.value=:shortname or prop.value=:veryshortname) ]
This time the errors seem related to the searches themselves...
I think that what might be happening is that Hibernate is not really
configured to be using Glassfish datasource, but instead it expects to
use the connection.username, connection.password,
connection.driver_class, connection.pool_size ... properties defined in
WEB-INF/hibernate.cfg.xml that i've commented out because i'd like to
use Glassfish-configured datasource.
I need help, so as to keep the properties that Hibernate reads from
WEB-INF/hibernate.cfg.xml to a minimum and pointing it to
Glassfish-defined JNDI resource instead.
Thank you very much !
Guillem Plasencia
5428
days inactive
5429
days old
1 comments
1 participants
participants (1)
-
GUILLEMP＠telefonica.net