[xwiki-users] Configuring JNDI data sourse - xwiki-users@xwiki.org - lists.xwiki.org

List overview All Threads
Download

[xwiki-users] Configuring JNDI data sourse

[xwiki-users] How to add TAGs to...

[xwiki-users] Is it possible to...

project_trainees＠amritatech.com

10 Apr 2008 10 Apr '08

11:38 a.m.

Hi, "Configure JNDI data store in application container, where you xwiki instance is running." How it should be done ? can any one help? Regards, Project trainees.

Reply

Show replies by date

Aleksandar Vidakovic

10 Apr 10 Apr

1:52 p.m.

Salut project trainees, I use XWiki 1.3 and changed the hibernate.cfg.xml like this: [config] <?xml version='1.0' encoding='utf-8'?> <!DOCTYPE hibernate-configuration PUBLIC "-//Hibernate/Hibernate Configuration DTD//EN" "http://hibernate.sourceforge.net/hibernate-configuration-3.0.dtd">  <hibernate-configuration> <session-factory> <property name="show_sql">false</property> <property name="use_outer_join">true</property>   <property name="connection.datasource">java:jdbc/XWikiDS</property> <property name="dialect">org.hibernate.dialect.PostgreSQLDialect</property> <mapping resource="xwiki.hbm.xml"/> <mapping resource="feeds.hbm.xml"/> </session-factory> </hibernate-configuration> [/config] Hope this helps. Cheers, Aleks project_trainees(a)amritatech.com wrote:

Hi, "Configure JNDI data store in application container, where you xwiki instance is running." How it should be done ? can any one help? Regards, Project trainees. _______________________________________________ users mailing list users(a)xwiki.org http://lists.xwiki.org/mailman/listinfo/users

Reply

project_trainees＠amritatech.com

2:37 p.m.

Hi, We are using XE 1.2.1 and Mysql 5.0. I configured hibernate.cfg.xml using the given code but it showing an error when pointing the browser to http://localhost:8181/xwiki/bin/view/main/webhome HTTP ERROR: 500 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: Could not parse configuration: file:/C:/xwiki_home/webapps/xwiki/WEB-INF/hibernate.cfg.xml RequestURI=/xwiki/bin/view/main/webhome Powered by Jetty:// Can U help? Thanks. Regards, Project trainees. Aleks wrote: Salut project trainees,

I use XWiki 1.3 and changed the hibernate.cfg.xml like this: [config] <?xml version='1.0' encoding='utf-8'?> <!DOCTYPE hibernate-configuration PUBLIC "-//Hibernate/Hibernate Configuration DTD//EN" "http://hibernate.sourceforge.net/hibernate-configuration-3.0.dtd">  <hibernate-configuration> <session-factory> <property name="show_sql">false</property> <property name="use_outer_join">true</property>   <property name="connection.datasource">java:jdbc/XWikiDS</property> <property name="dialect">org.hibernate.dialect.PostgreSQLDialect</property> <mapping resource="xwiki.hbm.xml"/> <mapping resource="feeds.hbm.xml"/> </session-factory> </hibernate-configuration> [/config] Hope this helps. Cheers, Aleks project_trainees(a)amritatech.com wrote:

Hi, "Configure JNDI data store in application container, where you xwiki instance is running." How it should be done ? can any one help? Regards, Project trainees. _______________________________________________ users mailing list users(a)xwiki.org http://lists.xwiki.org/mailman/listinfo/users

_______________________________________________ users mailing list users(a)xwiki.org http://lists.xwiki.org/mailman/listinfo/users

Reply

Aleksandar Vidakovic

5:40 p.m.

To use JNDI you have to define a datasource (it seems that you haven't done this). The configuration of a datasource depends on which container you use. In your case (Jetty) go to http://docs.codehaus.org/display/JETTY/JNDI and see section "Configuring DataSources". Cheers, Aleks project_trainees(a)amritatech.com wrote:

Hi, We are using XE 1.2.1 and Mysql 5.0. I configured hibernate.cfg.xml using the given code but it showing an error when pointing the browser to http://localhost:8181/xwiki/bin/view/main/webhome HTTP ERROR: 500 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: Could not parse configuration: file:/C:/xwiki_home/webapps/xwiki/WEB-INF/hibernate.cfg.xml RequestURI=/xwiki/bin/view/main/webhome Powered by Jetty:// Can U help? Thanks. Regards, Project trainees. Aleks wrote: Salut project trainees,

I use XWiki 1.3 and changed the hibernate.cfg.xml like this: [config] <?xml version='1.0' encoding='utf-8'?> <!DOCTYPE hibernate-configuration PUBLIC "-//Hibernate/Hibernate Configuration DTD//EN" "http://hibernate.sourceforge.net/hibernate-configuration-3.0.dtd">  <hibernate-configuration> <session-factory> <property name="show_sql">false</property> <property name="use_outer_join">true</property>   <property name="connection.datasource">java:jdbc/XWikiDS</property> <property name="dialect">org.hibernate.dialect.PostgreSQLDialect</property> <mapping resource="xwiki.hbm.xml"/> <mapping resource="feeds.hbm.xml"/> </session-factory> </hibernate-configuration> [/config] Hope this helps. Cheers, Aleks project_trainees(a)amritatech.com wrote:

Hi, "Configure JNDI data store in application container, where you xwiki instance is running." How it should be done ? can any one help? Regards, Project trainees. _______________________________________________ users mailing list users(a)xwiki.org http://lists.xwiki.org/mailman/listinfo/users

_______________________________________________ users mailing list users(a)xwiki.org http://lists.xwiki.org/mailman/listinfo/users

_______________________________________________ users mailing list users(a)xwiki.org http://lists.xwiki.org/mailman/listinfo/users

Reply

[Ricardo Rodriguez] Your EPEC Network ICT Team

11 Apr 11 Apr

3:25 p.m.

Hi! project_trainees(a)amritatech.com wrote:

Hi, "Configure JNDI data store in application container, where you xwiki instance is running." How it should be done ? can any one help? Regards, Project trainees.

Have you picked up the statement up here from http://xwikisql.gradsoft.ua/docs/XWikiSqlPluginGuide.html ? I think it will be clearer for everybody if you include this link or any other pointing to the source of the information! JNDI could be used for accessing any database, but this is a matter concerning Java, more than XWiki: you don't want to use a JNDI datasource for XWiki to store its database (or you do, but this is not what I understand from your messages :-) Being this table within XWiki schema, there is a lot of methods in XWiki API that will allow you to gain access to this data. But if you want to use the familiar SQL, XWikiSql plugin from GradSoft and/or Groovy groovy.sql.Sql can be of help. XWikiSQL plugin requires a JNDI source to be defined. groovy.sql.Sql doesn't. But I don't know what of both betters is the best one or it could depend on the scenario. As for Groovy, look for instance at this simple script I am using to retrieve data from another MySQL database: <% import groovy.sql.Sql db = Sql.newInstance("jdbc:mysql://myhost/mydatabase", "username", "password", "com.mysql.jdbc.Driver") List samplesIA = db.rows('SELECT * FROM saltmines s where es like "I" and ess like "A" and ids>=1') %> As I am trying to understand how this must be done, I will this thread posted with any new finding or solution. Your feedback is more than welcome! Thanks. Hope this helps, Ricardo -- Ricardo Rodríguez Your EPEC Network ICT Team

Reply

6099

days inactive

6100

days old

xwiki-users@xwiki.org

Manage subscription

4 comments

3 participants

tags (0)

participants (3)

[Ricardo Rodriguez] Your EPEC Network ICT Team
Aleksandar Vidakovic
project_trainees＠amritatech.com