Re: [xwiki-users] Problem with getting Xwiki to work with Oracle10g
XWiki is built differently for the war installation than the jetty/HSQL pack I think If you download the war file and install that way it will work. Caleb PERINAUD Christophe wrote: Here what we did is that we installed Xwiki from the pack jetty/HSQL. Once it work, we modified the hibernate configuration file to connect to Oracle DB. Here is our config file (if it helps ...) : ?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_sqlfalse/property property name=use_outer_jointrue/property property name=dbcp.defaultAutoCommitfalse/property property name=dbcp.maxActive50/property property name=dbcp.maxIdle5/property property name=dbcp.maxWait3/property property name=dbcp.whenExhaustedAction1/property property name=dbcp.ps.whenExhaustedAction1/property property name=dbcp.ps.maxActive20/property property name=dbcp.ps.maxWait12/property property name=dbcp.ps.maxIdle20/property property name=connection.urljdbc:oracle:thin:@IP.IP.IP.IP:1521:od46/property property name=connection.usernamexwiki/property property name=connection.password*/property property name=connection.driver_classoracle.jdbc.driver.OracleDriver/property property name=dialectorg.hibernate.dialect.Oracle10gDialect/property property name=connection.provider_classcom.xpn.xwiki.store.DBCPConnectionProvider/property property name=connection.pool_size2/property property name=statement_cache.size2/property property name=hibernate.connection.SetBigStringTryClobtrue/property property name=hibernate.jdbc.batch_size0/property mapping resource=xwiki.oracle.hbm.xml/ mapping resource=feeds.oracle.hbm.xml/ /session-factory /hibernate-configuration -Message d'origine- De : users-boun...@xwiki.org [mailto:users-boun...@xwiki.org] De la part de Oskar Marek Rzepinski Envoyé : mardi 19 janvier 2010 08:13 À : XWiki Users Objet : Re: [xwiki-users] Problem with getting Xwiki to work with Oracle10g Yes, I forgot to mention it, we copied it from the oracle folder, we copied this files: ojdbc14.jar orai18n.jar And we also tried it with ojdbc5.jar It getting us really crazy on this. 2010/1/19 PERINAUD Christophe christophe.perin...@kbl-bank.com Hi, Maybe stupid but did you install Oracle JDBC drivers in the WEB-INF/lib xwiki's folder ? Christophe Périnaud Windows Server 2003 SP2 in a VMWare instance Oracle 10g Java 1.6.0_12 Xwiki 2.0.3 from the pack Jetty/HSQL -Message d'origine- De : users-boun...@xwiki.org [mailto:users-boun...@xwiki.org] De la part de Oskar Marek Rzepinski Envoyé : mardi 19 janvier 2010 07:58 À : users@xwiki.org Objet : [xwiki-users] Problem with getting Xwiki to work with Oracle10g Hello everybody, we just stuck on installing xwiki on our devserver. We tried almost 10 times to get it work by ourselves but I didn't work. We still want to get it working. Here are the steps we did already: 1. we created a user xwiki on our DB server with the instructions from the official site 2. then we deployed xwiki on our server with the geronimo console 3. we made some changes to the hibernate configuration file, as you can see: ?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 !-- Please refer to the installation guide on http://platform.xwiki.org/xwiki/bin/view/AdminGuide/Installation for configuring your database. You'll need to do 2 things: 1) Copy your database driver JAR in WEB-INF/lib or in some shared lib directory 2) Uncomment the properties below for your specific DB (and comment the default database configuration if it doesn't match your DB) -- !-- Generic parameters common to all Databases -- property name=show_sqlfalse/ property property name=use_outer_jointrue/property property name=dbcp.defaultAutoCommitfalse/property property name=dbcp.maxActive50/property property name=dbcp.maxIdle5/property property name=dbcp.maxWait3/property property name=dbcp.whenExhaustedAction1/property property name=dbcp.ps.whenExhaustedAction1/property property name=dbcp.ps.maxActive20/property property name=dbcp.ps.maxWait12/property property name=dbcp.ps.maxIdle20/property !-- Without it, some queries fail in MS SQL. XWiki doesn't need scrollable result sets, anyway. -- property name=jdbc.use_scrollable_resultsetfalse/property !-- Oracle configuration. Uncomment if you want to
Re: [xwiki-users] Problem with getting Xwiki to work with Oracle10g
We have now some meetings, after them we will try once again with the jetty pack. @Caleb James DeLisle The steps I mentioned already we have done with the war file. We deployed it with the geronimo console. I will get back to this after we have tried the jetty pack and than I will answer and report if we were successful or not. 2010/1/19 Caleb James DeLisle calebdeli...@lavabit.com XWiki is built differently for the war installation than the jetty/HSQL pack I think If you download the war file and install that way it will work. Caleb PERINAUD Christophe wrote: Here what we did is that we installed Xwiki from the pack jetty/HSQL. Once it work, we modified the hibernate configuration file to connect to Oracle DB. Here is our config file (if it helps ...) : ?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_sqlfalse/property property name=use_outer_jointrue/property property name=dbcp.defaultAutoCommitfalse/property property name=dbcp.maxActive50/property property name=dbcp.maxIdle5/property property name=dbcp.maxWait3/property property name=dbcp.whenExhaustedAction1/property property name=dbcp.ps.whenExhaustedAction1/property property name=dbcp.ps.maxActive20/property property name=dbcp.ps.maxWait12/property property name=dbcp.ps.maxIdle20/property property name=connection.urljdbc:oracle:thin:@IP.IP.IP.IP :1521:od46/property property name=connection.usernamexwiki/property property name=connection.password*/property property name=connection.driver_classoracle.jdbc.driver.OracleDriver/property property name=dialectorg.hibernate.dialect.Oracle10gDialect/property property name=connection.provider_classcom.xpn.xwiki.store.DBCPConnectionProvider/property property name=connection.pool_size2/property property name=statement_cache.size2/property property name=hibernate.connection.SetBigStringTryClobtrue/property property name=hibernate.jdbc.batch_size0/property mapping resource=xwiki.oracle.hbm.xml/ mapping resource=feeds.oracle.hbm.xml/ /session-factory /hibernate-configuration -Message d'origine- De : users-boun...@xwiki.org [mailto:users-boun...@xwiki.org] De la part de Oskar Marek Rzepinski Envoyé : mardi 19 janvier 2010 08:13 À : XWiki Users Objet : Re: [xwiki-users] Problem with getting Xwiki to work with Oracle10g Yes, I forgot to mention it, we copied it from the oracle folder, we copied this files: ojdbc14.jar orai18n.jar And we also tried it with ojdbc5.jar It getting us really crazy on this. 2010/1/19 PERINAUD Christophe christophe.perin...@kbl-bank.com Hi, Maybe stupid but did you install Oracle JDBC drivers in the WEB-INF/lib xwiki's folder ? Christophe Périnaud Windows Server 2003 SP2 in a VMWare instance Oracle 10g Java 1.6.0_12 Xwiki 2.0.3 from the pack Jetty/HSQL -Message d'origine- De : users-boun...@xwiki.org [mailto:users-boun...@xwiki.org] De la part de Oskar Marek Rzepinski Envoyé : mardi 19 janvier 2010 07:58 À : users@xwiki.org Objet : [xwiki-users] Problem with getting Xwiki to work with Oracle10g Hello everybody, we just stuck on installing xwiki on our devserver. We tried almost 10 times to get it work by ourselves but I didn't work. We still want to get it working. Here are the steps we did already: 1. we created a user xwiki on our DB server with the instructions from the official site 2. then we deployed xwiki on our server with the geronimo console 3. we made some changes to the hibernate configuration file, as you can see: ?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 !-- Please refer to the installation guide on http://platform.xwiki.org/xwiki/bin/view/AdminGuide/Installation for configuring your database. You'll need to do 2 things: 1) Copy your database driver JAR in WEB-INF/lib or in some shared lib directory 2) Uncomment the properties below for your specific DB (and comment the default database configuration if it doesn't match your DB) -- !-- Generic parameters common to all Databases -- property name=show_sqlfalse/ property property name=use_outer_jointrue/property property name=dbcp.defaultAutoCommitfalse/property property name=dbcp.maxActive50/property property name=dbcp.maxIdle5/property property
Re: [xwiki-users] Problem with getting Xwiki to work with Oracle10g
Do shemas have been created in the DB ? Can you ask your DBA to see what is the last login date of the user ? It could help to know if the problem comes from the DB or if there is something wrong before trying to connect -Message d'origine- De : users-boun...@xwiki.org [mailto:users-boun...@xwiki.org] De la part de Oskar Marek Rzepinski Envoyé : mardi 19 janvier 2010 11:48 À : XWiki Users Objet : Re: [xwiki-users] Problem with getting Xwiki to work with Oracle10g So, we started our installation once again and it still does not work. Step-by-step: 1. We created a user xwiki on oracle with all privileges. We use oracle 10.2.0.40 2. We deployed the war file with the geronimo console. We use tomcat 6 javaee5 2.1.4 3. We than changed the configuration file, as already mentioned 4. We copied the ojdbc5.jar from oracle 11.1.0.7 and tried it also with ojdbc14.jar. 5. Then we restarted geronimo and started the xwiki container We use the oracle installtion and the geronimo server on a sun solaris server and solaris as the operating system. We still don't get the xwiki installed, and don't understand why. Thank you all for the pleasent help. 2010/1/19 Oskar Marek Rzepinski rzepin...@gmail.com We have now some meetings, after them we will try once again with the jetty pack. @Caleb James DeLisle The steps I mentioned already we have done with the war file. We deployed it with the geronimo console. I will get back to this after we have tried the jetty pack and than I will answer and report if we were successful or not. 2010/1/19 Caleb James DeLisle calebdeli...@lavabit.com XWiki is built differently for the war installation than the jetty/HSQL pack I think If you download the war file and install that way it will work. Caleb PERINAUD Christophe wrote: Here what we did is that we installed Xwiki from the pack jetty/HSQL. Once it work, we modified the hibernate configuration file to connect to Oracle DB. Here is our config file (if it helps ...) : ?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_sqlfalse/property property name=use_outer_jointrue/property property name=dbcp.defaultAutoCommitfalse/property property name=dbcp.maxActive50/property property name=dbcp.maxIdle5/property property name=dbcp.maxWait3/property property name=dbcp.whenExhaustedAction1/property property name=dbcp.ps.whenExhaustedAction1/property property name=dbcp.ps.maxActive20/property property name=dbcp.ps.maxWait12/property property name=dbcp.ps.maxIdle20/property property name=connection.urljdbc:oracle:thin:@IP.IP.IP.IP :1521:od46/property property name=connection.usernamexwiki/property property name=connection.password*/property property name=connection.driver_classoracle.jdbc.driver.OracleDriver /property property name=dialectorg.hibernate.dialect.Oracle10gDialect/property property name=connection.provider_classcom.xpn.xwiki.store.DBCPConne ctionProvider/property property name=connection.pool_size2/property property name=statement_cache.size2/property property name=hibernate.connection.SetBigStringTryClobtrue/property property name=hibernate.jdbc.batch_size0/property mapping resource=xwiki.oracle.hbm.xml/ mapping resource=feeds.oracle.hbm.xml/ /session-factory /hibernate-configuration -Message d'origine- De : users-boun...@xwiki.org [mailto:users-boun...@xwiki.org] De la part de Oskar Marek Rzepinski Envoyé : mardi 19 janvier 2010 08:13 À : XWiki Users Objet : Re: [xwiki-users] Problem with getting Xwiki to work with Oracle10g Yes, I forgot to mention it, we copied it from the oracle folder, we copied this files: ojdbc14.jar orai18n.jar And we also tried it with ojdbc5.jar It getting us really crazy on this. 2010/1/19 PERINAUD Christophe christophe.perin...@kbl-bank.com Hi, Maybe stupid but did you install Oracle JDBC drivers in the WEB-INF/lib xwiki's folder ? Christophe Périnaud Windows Server 2003 SP2 in a VMWare instance Oracle 10g Java 1.6.0_12 Xwiki 2.0.3 from the pack Jetty/HSQL -Message d'origine- De : users-boun...@xwiki.org [mailto:users-boun...@xwiki.org] De la part de Oskar Marek Rzepinski Envoyé : mardi 19 janvier 2010 07:58 À : users@xwiki.org Objet : [xwiki-users] Problem with getting Xwiki to work with Oracle10g Hello everybody, we just stuck on installing xwiki on our devserver. We
Re: [xwiki-users] Problem with getting Xwiki to work with Oracle10g
Now i remember that we cancelled the use of the war because of identical problems (and running out of time and mainly budget) I think that the Architecture Dept created a new war based on the Jetty distribution -Message d'origine- De : users-boun...@xwiki.org [mailto:users-boun...@xwiki.org] De la part de Oskar Marek Rzepinski Envoyé : mardi 19 janvier 2010 11:48 À : XWiki Users Objet : Re: [xwiki-users] Problem with getting Xwiki to work with Oracle10g So, we started our installation once again and it still does not work. Step-by-step: 1. We created a user xwiki on oracle with all privileges. We use oracle 10.2.0.40 2. We deployed the war file with the geronimo console. We use tomcat 6 javaee5 2.1.4 3. We than changed the configuration file, as already mentioned 4. We copied the ojdbc5.jar from oracle 11.1.0.7 and tried it also with ojdbc14.jar. 5. Then we restarted geronimo and started the xwiki container We use the oracle installtion and the geronimo server on a sun solaris server and solaris as the operating system. We still don't get the xwiki installed, and don't understand why. Thank you all for the pleasent help. 2010/1/19 Oskar Marek Rzepinski rzepin...@gmail.com We have now some meetings, after them we will try once again with the jetty pack. @Caleb James DeLisle The steps I mentioned already we have done with the war file. We deployed it with the geronimo console. I will get back to this after we have tried the jetty pack and than I will answer and report if we were successful or not. 2010/1/19 Caleb James DeLisle calebdeli...@lavabit.com XWiki is built differently for the war installation than the jetty/HSQL pack I think If you download the war file and install that way it will work. Caleb PERINAUD Christophe wrote: Here what we did is that we installed Xwiki from the pack jetty/HSQL. Once it work, we modified the hibernate configuration file to connect to Oracle DB. Here is our config file (if it helps ...) : ?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_sqlfalse/property property name=use_outer_jointrue/property property name=dbcp.defaultAutoCommitfalse/property property name=dbcp.maxActive50/property property name=dbcp.maxIdle5/property property name=dbcp.maxWait3/property property name=dbcp.whenExhaustedAction1/property property name=dbcp.ps.whenExhaustedAction1/property property name=dbcp.ps.maxActive20/property property name=dbcp.ps.maxWait12/property property name=dbcp.ps.maxIdle20/property property name=connection.urljdbc:oracle:thin:@IP.IP.IP.IP :1521:od46/property property name=connection.usernamexwiki/property property name=connection.password*/property property name=connection.driver_classoracle.jdbc.driver.OracleDriver /property property name=dialectorg.hibernate.dialect.Oracle10gDialect/property property name=connection.provider_classcom.xpn.xwiki.store.DBCPConne ctionProvider/property property name=connection.pool_size2/property property name=statement_cache.size2/property property name=hibernate.connection.SetBigStringTryClobtrue/property property name=hibernate.jdbc.batch_size0/property mapping resource=xwiki.oracle.hbm.xml/ mapping resource=feeds.oracle.hbm.xml/ /session-factory /hibernate-configuration -Message d'origine- De : users-boun...@xwiki.org [mailto:users-boun...@xwiki.org] De la part de Oskar Marek Rzepinski Envoyé : mardi 19 janvier 2010 08:13 À : XWiki Users Objet : Re: [xwiki-users] Problem with getting Xwiki to work with Oracle10g Yes, I forgot to mention it, we copied it from the oracle folder, we copied this files: ojdbc14.jar orai18n.jar And we also tried it with ojdbc5.jar It getting us really crazy on this. 2010/1/19 PERINAUD Christophe christophe.perin...@kbl-bank.com Hi, Maybe stupid but did you install Oracle JDBC drivers in the WEB-INF/lib xwiki's folder ? Christophe Périnaud Windows Server 2003 SP2 in a VMWare instance Oracle 10g Java 1.6.0_12 Xwiki 2.0.3 from the pack Jetty/HSQL -Message d'origine- De : users-boun...@xwiki.org [mailto:users-boun...@xwiki.org] De la part de Oskar Marek Rzepinski Envoyé : mardi 19 janvier 2010 07:58 À : users@xwiki.org Objet : [xwiki-users] Problem with getting Xwiki to work with Oracle10g Hello everybody, we just stuck on installing xwiki on our devserver. We tried
Re: [xwiki-users] Lucene defaultpage fails
Hi guys,
getting some informations since i can't find just at looking at the
code how this would append.
When you have the issue, does it appending since the time you started
XWiki or does it works and at some point it stops to work even if you
did not restarted XWiki. Basically is it always a startup issue ?
And in that case do you have anything in the beginning of the log like
a warning or something indicating that something wrong append during
lucene plugin initialization ?
On Tue, Jan 19, 2010 at 07:20, Gerritjan Koekkoek
gerritjankoekk...@gmail.com wrote:
The following command (thanks Pete) worked en reinitialized Lucene
after that lucenesearch worked again.
Hope to hear soon how to prevent that Lucene is not initialized?
xwiki.getXWiki().getPluginManager().getPlugin(lucene).init(xwiki.getXWikiC
ontext())
Op 18 jan 2010, om 10:46 heeft Guillaume Lerouge het volgende geschreven:
Hi,
yes, I'm frequently hitting this error too and I'm not sure why. Thomas
Mortagne looked at it last week but he doesn't have a fix yet.
I was provided with a workaround last friday, I'll see if I can post it on
code.xwiki.org
Guillaume
On Mon, Jan 18, 2010 at 10:05 AM, Petteri Karttunen
petteri.karttu...@gmail.com wrote:
Hi,
I'm also encountering this problem randomly since XWiki 2.0 but so far
haven't been able to find the initial cause. See also
http://www.mail-archive.com/users@xwiki.org/msg09549.html. As Marius
suggests it might have something to do with the plugin initialization
because re-initializing the plugin under those circumstances helps in my
case:
...
xwiki.getXWiki().getPluginManager().getPlugin(lucene).init(xwiki.getXWikiC
ontext()) ...
but this of course doesn't solve the problem behind.
-Pete
-Alkuperäinen viesti-
Lähettäjä: users-boun...@xwiki.org [mailto:users-boun...@xwiki.org]
Puolesta
Gerritjan Koekkoek
Lähetetty: 17. tammikuuta 2010 21:26
Vastaanottaja: XWiki Users
Aihe: Re: [xwiki-users] Lucene defaultpage fails
See below for extended error-report
I also paste the code
Op 17 jan 2010, om 18:12 heeft Flavius Olaru het volgende geschreven:
On Sun, Jan 17, 2010 at 1:35 PM, Gerritjan Koekkoek
gerritjankoekk...@gmail.com wrote:
Navigating to the Main.LuceneSearch page brings up the following error?
Failed to execute macro: velocity
org.xwiki.rendering.macro.MacroExecutionException: Failed to evaluate
Velocity Macro for content
[$xwiki.jsfx.use(uicomponents/search/search.js,
true)##
$xwiki.ssfx.use(uicomponents/search/search.css, true)##
The page has worked, but what can be wrong now.
The page itself is not changed from the distribution?
Gerritjan
___
users mailing list
users@xwiki.org
http://lists.xwiki.org/mailman/listinfo/users
Hi Gerritjan,
Can you paste in more information about the error?
--
Flavius Olaru
## Disable the document extra data: comments, attachments, history...
#set($docextras = [])
## ===
## Lucene search
## ===
## Inputs : $request.text
## Outputs : $list, $isScored
## ===
## Uncomment this line to overload the maximum list of wiki where to search
(also the one listed in the wikis combobox)
## #set($allwikinamelist = [xwiki, wiki1, wiki2])
##
## Uncomment this line to overload the wikis where to search
## #set($wikinames = xwiki,wiki,wiki)
##
## Uncomment this line to overload the languages to search
## #set($languages = default,en,de)
#set ($rssmode = ($!request.xpage == 'plain'))
## ---
## Space filtering
## ---
#set($extraClause = '')
#set($selectedSpace = $!request.space)
#if($selectedSpace != '' !$blacklistedSpaces.contains($selectedSpace))
#set($extraClause = AND web:${selectedSpace})
#end
## --
## Exclude Blacklisted spaces ($blacklistedSpaces is set in xwikivars.vm)
## Also exclude WebPreferences.
## --
#foreach ($blacklistedSpace in $blacklistedSpaces)
#set ($extraClause = AND NOT web:${blacklistedSpace}${extraClause})
#end
#if(!$hasAdmin !$isAdvancedUser)
#set ($extraClause = AND NOT name:WebPreferences${extraClause})
#end
## ---
## Space macros
## ---
#macro(spaceoption $space $selectedSpace)
option value=${space} #if($selectedSpace ==
$space)selected=selected#end$space/option
#end
#macro(spaceselect $selectedSpace $spaces)
select name=space title=$msg.get('xe.search.bar.spaces.title')
option value= #if($selectedSpace ==
'')selected=selected#end$msg.get('xe.search.bar.spaces.all')/option
#foreach($space in $xwiki.spaces)
#if (!$blacklistedSpaces.contains($space))
#spaceoption($space $selectedSpace)
#end
#end
/select
#end
## ---
## Wikis filtering
## ---
#set($wikinamelist = [])
#if(!$wikinames)
Re: [xwiki-users] Problem with getting Xwiki to work with Oracle10g
unfortunately I am a little out of my league, my installation uses postgres and jetty but I would suggest you create a database called xwiki and make the user xwiki the owner of that database, It's possible that it is getting hung up in the create database part and doing it manually would make it work, hard to tell from the error log. Caleb Oskar Marek Rzepinski wrote: So, we started our installation once again and it still does not work. Step-by-step: 1. We created a user xwiki on oracle with all privileges. We use oracle 10.2.0.40 2. We deployed the war file with the geronimo console. We use tomcat 6 javaee5 2.1.4 3. We than changed the configuration file, as already mentioned 4. We copied the ojdbc5.jar from oracle 11.1.0.7 and tried it also with ojdbc14.jar. 5. Then we restarted geronimo and started the xwiki container We use the oracle installtion and the geronimo server on a sun solaris server and solaris as the operating system. We still don't get the xwiki installed, and don't understand why. Thank you all for the pleasent help. 2010/1/19 Oskar Marek Rzepinski rzepin...@gmail.com We have now some meetings, after them we will try once again with the jetty pack. @Caleb James DeLisle The steps I mentioned already we have done with the war file. We deployed it with the geronimo console. I will get back to this after we have tried the jetty pack and than I will answer and report if we were successful or not. 2010/1/19 Caleb James DeLisle calebdeli...@lavabit.com XWiki is built differently for the war installation than the jetty/HSQL pack I think If you download the war file and install that way it will work. Caleb PERINAUD Christophe wrote: Here what we did is that we installed Xwiki from the pack jetty/HSQL. Once it work, we modified the hibernate configuration file to connect to Oracle DB. Here is our config file (if it helps ...) : ?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_sqlfalse/property property name=use_outer_jointrue/property property name=dbcp.defaultAutoCommitfalse/property property name=dbcp.maxActive50/property property name=dbcp.maxIdle5/property property name=dbcp.maxWait3/property property name=dbcp.whenExhaustedAction1/property property name=dbcp.ps.whenExhaustedAction1/property property name=dbcp.ps.maxActive20/property property name=dbcp.ps.maxWait12/property property name=dbcp.ps.maxIdle20/property property name=connection.urljdbc:oracle:thin:@IP.IP.IP.IP :1521:od46/property property name=connection.usernamexwiki/property property name=connection.password*/property property name=connection.driver_classoracle.jdbc.driver.OracleDriver/property property name=dialectorg.hibernate.dialect.Oracle10gDialect/property property name=connection.provider_classcom.xpn.xwiki.store.DBCPConnectionProvider/property property name=connection.pool_size2/property property name=statement_cache.size2/property property name=hibernate.connection.SetBigStringTryClobtrue/property property name=hibernate.jdbc.batch_size0/property mapping resource=xwiki.oracle.hbm.xml/ mapping resource=feeds.oracle.hbm.xml/ /session-factory /hibernate-configuration -Message d'origine- De : users-boun...@xwiki.org [mailto:users-boun...@xwiki.org] De la part de Oskar Marek Rzepinski Envoyé : mardi 19 janvier 2010 08:13 À : XWiki Users Objet : Re: [xwiki-users] Problem with getting Xwiki to work with Oracle10g Yes, I forgot to mention it, we copied it from the oracle folder, we copied this files: ojdbc14.jar orai18n.jar And we also tried it with ojdbc5.jar It getting us really crazy on this. 2010/1/19 PERINAUD Christophe christophe.perin...@kbl-bank.com Hi, Maybe stupid but did you install Oracle JDBC drivers in the WEB-INF/lib xwiki's folder ? Christophe Périnaud Windows Server 2003 SP2 in a VMWare instance Oracle 10g Java 1.6.0_12 Xwiki 2.0.3 from the pack Jetty/HSQL -Message d'origine- De : users-boun...@xwiki.org [mailto:users-boun...@xwiki.org] De la part de Oskar Marek Rzepinski Envoyé : mardi 19 janvier 2010 07:58 À : users@xwiki.org Objet : [xwiki-users] Problem with getting Xwiki to work with Oracle10g Hello everybody, we just stuck on installing xwiki on our devserver. We tried almost 10 times to get it work by ourselves but I didn't work. We still want to get it working. Here are the steps we did already: 1. we created a user xwiki on our DB server with the instructions from the official site 2. then we deployed xwiki on our server with the geronimo console 3. we made some changes to the hibernate
Re: [xwiki-users] Problem with getting Xwiki to work with Oracle10g
first at all, sory for my poor english. Second, could you attach entire stack trace? You should see CAUSED BY clause. Thats you need to see. Third, with no entire stack trace i think that the problem comes from Oracle and you need to fullfilling hibernate.cfg.xml properly with proper connection url. this is my conn url: jdbc:oracle:thin:@ (description=(address_list=(load_balance=on)(address=(protocol=tcp)(host=X.X.X.X)(port=1521))(address=(protocol=tcp)(host=X.X.X.X)(port=1521)))(connect_data=(service_name=myService.name))) hope this helps! Alonso 2010/1/19 Caleb James DeLisle calebdeli...@lavabit.com unfortunately I am a little out of my league, my installation uses postgres and jetty but I would suggest you create a database called xwiki and make the user xwiki the owner of that database, It's possible that it is getting hung up in the create database part and doing it manually would make it work, hard to tell from the error log. Caleb Oskar Marek Rzepinski wrote: So, we started our installation once again and it still does not work. Step-by-step: 1. We created a user xwiki on oracle with all privileges. We use oracle 10.2.0.40 2. We deployed the war file with the geronimo console. We use tomcat 6 javaee5 2.1.4 3. We than changed the configuration file, as already mentioned 4. We copied the ojdbc5.jar from oracle 11.1.0.7 and tried it also with ojdbc14.jar. 5. Then we restarted geronimo and started the xwiki container We use the oracle installtion and the geronimo server on a sun solaris server and solaris as the operating system. We still don't get the xwiki installed, and don't understand why. Thank you all for the pleasent help. 2010/1/19 Oskar Marek Rzepinski rzepin...@gmail.com We have now some meetings, after them we will try once again with the jetty pack. @Caleb James DeLisle The steps I mentioned already we have done with the war file. We deployed it with the geronimo console. I will get back to this after we have tried the jetty pack and than I will answer and report if we were successful or not. 2010/1/19 Caleb James DeLisle calebdeli...@lavabit.com XWiki is built differently for the war installation than the jetty/HSQL pack I think If you download the war file and install that way it will work. Caleb PERINAUD Christophe wrote: Here what we did is that we installed Xwiki from the pack jetty/HSQL. Once it work, we modified the hibernate configuration file to connect to Oracle DB. Here is our config file (if it helps ...) : ?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_sqlfalse/property property name=use_outer_jointrue/property property name=dbcp.defaultAutoCommitfalse/property property name=dbcp.maxActive50/property property name=dbcp.maxIdle5/property property name=dbcp.maxWait3/property property name=dbcp.whenExhaustedAction1/property property name=dbcp.ps.whenExhaustedAction1/property property name=dbcp.ps.maxActive20/property property name=dbcp.ps.maxWait12/property property name=dbcp.ps.maxIdle20/property property name=connection.urljdbc:oracle:thin:@IP.IP.IP.IP :1521:od46/property property name=connection.usernamexwiki/property property name=connection.password*/property property name=connection.driver_classoracle.jdbc.driver.OracleDriver/property property name=dialectorg.hibernate.dialect.Oracle10gDialect/property property name=connection.provider_classcom.xpn.xwiki.store.DBCPConnectionProvider/property property name=connection.pool_size2/property property name=statement_cache.size2/property property name=hibernate.connection.SetBigStringTryClobtrue/property property name=hibernate.jdbc.batch_size0/property mapping resource=xwiki.oracle.hbm.xml/ mapping resource=feeds.oracle.hbm.xml/ /session-factory /hibernate-configuration -Message d'origine- De : users-boun...@xwiki.org [mailto:users-boun...@xwiki.org] De la part de Oskar Marek Rzepinski Envoyé : mardi 19 janvier 2010 08:13 À : XWiki Users Objet : Re: [xwiki-users] Problem with getting Xwiki to work with Oracle10g Yes, I forgot to mention it, we copied it from the oracle folder, we copied this files: ojdbc14.jar orai18n.jar And we also tried it with ojdbc5.jar It getting us really crazy on this. 2010/1/19 PERINAUD Christophe christophe.perin...@kbl-bank.com Hi, Maybe stupid but did you install Oracle JDBC drivers in the WEB-INF/lib xwiki's folder ? Christophe Périnaud Windows Server 2003 SP2 in a VMWare instance Oracle
Re: [xwiki-users] Lucene defaultpage fails
Hello, My issues seem to happen randomly but not at startup. Plugin works well from some hours to some days but I'm not sure what triggers this. I haven't been able to debug anything of interest in plugin's logs. Only potential clue I have is that plugin is leaving index files open which -at least- leads Tomcat finally to too many files open -error at some point. lsof | grep lucene gives me a bunch of these: ... java.bin 10095 tomcat 666r REG 104,1 60931511 15634869 /srv/www/DATA/xwiki/lucene/_5r7.cfs (deleted) java.bin 10095 tomcat 667r REG 104,1 60931507 15634870 /srv/www/DATA/xwiki/lucene/_5r9.cfs (deleted) java.bin 10095 tomcat 668r REG 104,1 60931507 15634871 /srv/www/DATA/xwiki/lucene/_5rb.cfs (deleted) ... Also, xwiki gets the plugin object normally during the malfunctional state but it seems it just cannot read index. Could it be that the plugin becomes unusable not before a deleted index file becomes overwritten by the system? That could be the reason why the time it works varies so much (depending on the other file system usage of the underlying operating system)? WDT? -Pete -Alkuperäinen viesti- Lähettäjä: users-boun...@xwiki.org [mailto:users-boun...@xwiki.org] Puolesta Thomas Mortagne Lähetetty: 19. tammikuuta 2010 13:20 Vastaanottaja: XWiki Users Aihe: Re: [xwiki-users] Lucene defaultpage fails Hi guys, getting some informations since i can't find just at looking at the code how this would append. When you have the issue, does it appending since the time you started XWiki or does it works and at some point it stops to work even if you did not restarted XWiki. Basically is it always a startup issue ? And in that case do you have anything in the beginning of the log like a warning or something indicating that something wrong append during lucene plugin initialization ? On Tue, Jan 19, 2010 at 07:20, Gerritjan Koekkoek gerritjankoekk...@gmail.com wrote: The following command (thanks Pete) worked en reinitialized Lucene after that lucenesearch worked again. Hope to hear soon how to prevent that Lucene is not initialized? xwiki.getXWiki().getPluginManager().getPlugin(lucene).init(xwiki.getXWikiC ontext()) Op 18 jan 2010, om 10:46 heeft Guillaume Lerouge het volgende geschreven: Hi, yes, I'm frequently hitting this error too and I'm not sure why. Thomas Mortagne looked at it last week but he doesn't have a fix yet. I was provided with a workaround last friday, I'll see if I can post it on code.xwiki.org Guillaume On Mon, Jan 18, 2010 at 10:05 AM, Petteri Karttunen petteri.karttu...@gmail.com wrote: Hi, I'm also encountering this problem randomly since XWiki 2.0 but so far haven't been able to find the initial cause. See also http://www.mail-archive.com/users@xwiki.org/msg09549.html. As Marius suggests it might have something to do with the plugin initialization because re-initializing the plugin under those circumstances helps in my case: ... xwiki.getXWiki().getPluginManager().getPlugin(lucene).init(xwiki.getXWikiC ontext()) ... but this of course doesn't solve the problem behind. -Pete -Alkuperäinen viesti- Lähettäjä: users-boun...@xwiki.org [mailto:users-boun...@xwiki.org] Puolesta Gerritjan Koekkoek Lähetetty: 17. tammikuuta 2010 21:26 Vastaanottaja: XWiki Users Aihe: Re: [xwiki-users] Lucene defaultpage fails See below for extended error-report I also paste the code Op 17 jan 2010, om 18:12 heeft Flavius Olaru het volgende geschreven: On Sun, Jan 17, 2010 at 1:35 PM, Gerritjan Koekkoek gerritjankoekk...@gmail.com wrote: Navigating to the Main.LuceneSearch page brings up the following error? Failed to execute macro: velocity org.xwiki.rendering.macro.MacroExecutionException: Failed to evaluate Velocity Macro for content [$xwiki.jsfx.use(uicomponents/search/search.js, true)## $xwiki.ssfx.use(uicomponents/search/search.css, true)## The page has worked, but what can be wrong now. The page itself is not changed from the distribution? Gerritjan ___ users mailing list users@xwiki.org http://lists.xwiki.org/mailman/listinfo/users Hi Gerritjan, Can you paste in more information about the error? -- Flavius Olaru ## Disable the document extra data: comments, attachments, history... #set($docextras = []) ## === ## Lucene search ## === ## Inputs : $request.text ## Outputs : $list, $isScored ## === ## Uncomment this line to overload the maximum list of wiki where to search (also the one listed in the wikis combobox) ## #set($allwikinamelist = [xwiki, wiki1, wiki2]) ## ## Uncomment this line to overload the wikis where to search ## #set($wikinames = xwiki,wiki,wiki) ## ## Uncomment this line to overload the languages to search ## #set($languages = default,en,de) #set ($rssmode = ($!request.xpage == 'plain')) ##
Re: [xwiki-users] Lucene defaultpage fails
On Tue, Jan 19, 2010 at 13:26, Petteri Karttunen petteri.karttu...@gmail.com wrote: Hello, My issues seem to happen randomly but not at startup. Plugin works well from some hours to some days but I'm not sure what triggers this. I haven't been able to debug anything of interest in plugin's logs. Only potential clue I have is that plugin is leaving index files open which -at least- leads Tomcat finally to too many files open -error at some point. lsof | grep lucene gives me a bunch of these: ... java.bin 10095 tomcat 666r REG 104,1 60931511 15634869 /srv/www/DATA/xwiki/lucene/_5r7.cfs (deleted) java.bin 10095 tomcat 667r REG 104,1 60931507 15634870 /srv/www/DATA/xwiki/lucene/_5r9.cfs (deleted) java.bin 10095 tomcat 668r REG 104,1 60931507 15634871 /srv/www/DATA/xwiki/lucene/_5rb.cfs (deleted) ... Also, xwiki gets the plugin object normally during the malfunctional state but it seems it just cannot read index. Could it be that the plugin becomes unusable not before a deleted index file becomes overwritten by the system? That could be the reason why the time it works varies so much (depending on the other file system usage of the underlying operating system)? WDT? This one is http://jira.xwiki.org/jira/browse/XPLUCENE-30 but I don't see how it could be the source of the nullpointer exception issue. -Pete -Alkuperäinen viesti- Lähettäjä: users-boun...@xwiki.org [mailto:users-boun...@xwiki.org] Puolesta Thomas Mortagne Lähetetty: 19. tammikuuta 2010 13:20 Vastaanottaja: XWiki Users Aihe: Re: [xwiki-users] Lucene defaultpage fails Hi guys, getting some informations since i can't find just at looking at the code how this would append. When you have the issue, does it appending since the time you started XWiki or does it works and at some point it stops to work even if you did not restarted XWiki. Basically is it always a startup issue ? And in that case do you have anything in the beginning of the log like a warning or something indicating that something wrong append during lucene plugin initialization ? On Tue, Jan 19, 2010 at 07:20, Gerritjan Koekkoek gerritjankoekk...@gmail.com wrote: The following command (thanks Pete) worked en reinitialized Lucene after that lucenesearch worked again. Hope to hear soon how to prevent that Lucene is not initialized? xwiki.getXWiki().getPluginManager().getPlugin(lucene).init(xwiki.getXWikiC ontext()) Op 18 jan 2010, om 10:46 heeft Guillaume Lerouge het volgende geschreven: Hi, yes, I'm frequently hitting this error too and I'm not sure why. Thomas Mortagne looked at it last week but he doesn't have a fix yet. I was provided with a workaround last friday, I'll see if I can post it on code.xwiki.org Guillaume On Mon, Jan 18, 2010 at 10:05 AM, Petteri Karttunen petteri.karttu...@gmail.com wrote: Hi, I'm also encountering this problem randomly since XWiki 2.0 but so far haven't been able to find the initial cause. See also http://www.mail-archive.com/users@xwiki.org/msg09549.html. As Marius suggests it might have something to do with the plugin initialization because re-initializing the plugin under those circumstances helps in my case: ... xwiki.getXWiki().getPluginManager().getPlugin(lucene).init(xwiki.getXWikiC ontext()) ... but this of course doesn't solve the problem behind. -Pete -Alkuperäinen viesti- Lähettäjä: users-boun...@xwiki.org [mailto:users-boun...@xwiki.org] Puolesta Gerritjan Koekkoek Lähetetty: 17. tammikuuta 2010 21:26 Vastaanottaja: XWiki Users Aihe: Re: [xwiki-users] Lucene defaultpage fails See below for extended error-report I also paste the code Op 17 jan 2010, om 18:12 heeft Flavius Olaru het volgende geschreven: On Sun, Jan 17, 2010 at 1:35 PM, Gerritjan Koekkoek gerritjankoekk...@gmail.com wrote: Navigating to the Main.LuceneSearch page brings up the following error? Failed to execute macro: velocity org.xwiki.rendering.macro.MacroExecutionException: Failed to evaluate Velocity Macro for content [$xwiki.jsfx.use(uicomponents/search/search.js, true)## $xwiki.ssfx.use(uicomponents/search/search.css, true)## The page has worked, but what can be wrong now. The page itself is not changed from the distribution? Gerritjan ___ users mailing list users@xwiki.org http://lists.xwiki.org/mailman/listinfo/users Hi Gerritjan, Can you paste in more information about the error? -- Flavius Olaru ## Disable the document extra data: comments, attachments, history... #set($docextras = []) ## === ## Lucene search ## === ## Inputs : $request.text ## Outputs : $list, $isScored ## === ## Uncomment this line to overload the maximum list of wiki where to search (also the one listed in the wikis combobox) ## #set($allwikinamelist = [xwiki, wiki1, wiki2]) ## ##
Re: [xwiki-users] Bad HQL queries
Shouldn't there be a setting in DBCP configs?
paul
Le 18-janv.-10 à 13:44, Anca Luca a écrit :
Hi Sergiu,
On 01/18/2010 02:06 PM, Sergiu Dumitriu wrote:
On 01/18/2010 10:15 AM, Anca Luca wrote:
Hi Flavius,
On 01/17/2010 05:23 PM, Flavius Olaru wrote:
Hi,
I've done a installation on my localhost (Windows XP machine) of XE
2.1.1, Tomcat 6 and MySQL 5.1.
After this i wrote a bad hql query and executed it which brought
MySQL
to spyke the CPU usage to 100% and even more rendering both the
localhost and database unusable.
{{velocity}}
#set($badhql = , BaseObject obj, StringProperty stringprop,
LargeStringProperty largestringprop where (doc.name like '%$text
%' or
doc.content like '%$text%') or (obj.name=doc.fullName and
stringprop.id.id=obj.id and stringprop.value like '%$text%') or
(obj.name=doc.fullName and largestringprop.id.id=obj.id and
largestringprop.value like '%$text%'))
as we already discussed (but logging here for posterity), I don't
see why this
would be called a bad hql. It highly depends on the specific
instance, the
data in it, etc. Any query which is 'good' on one instance can be
'bad' on
another one.
This one IS bad, no matter how you try to look at it. It joins all
documents with all possible objects, and all possible string and
largestring properties, since the link between them is OR-ed, not
AND-ed. It should be a left(or right?)-join relationship, but
frankly in
my early, hasty tests with this kinds of joins in HQL, I never got
it to
work, since there are 4 tables to join. So, another approach would
be to
put the property test in an or exists(...), which is not as
performant
as a left join, but at least it selects properly matched objects and
properties.
agreed for this particular case, but the discussion was about hqls
which take
too much time. To the limit, somebody might _actually_ need all
these tables
joined, and we wouldn't call that bad, wouldn't we?
If we put the problem like this, then we have a conversation about
how to
enforce people to join tables only by foreign keys (which we don't
even have set
in xwiki iirc), which is another discussion.
Thanks,
Anca
Also, the responsiveness / unresponsiveness of the server depends
on the
configuration of the machine, but I agree that there can be
queries instances
that would render any machine (build with current technologies)
unusable.
I personally prefer to be able to write whatever I want, even if
it renders the
machine unusable, I needed it in some situations and I prefer this
to _not_ be
enforced: if I want a query to take longer, I should be able to do
it and setup
my own safety nets (warn user, etc). After all, it's an
application platform and
the application developers are (anyway, should be, in an ideal
world)
responsible of what they're writing.
#set($ok = $list.addAll(0, $xwiki.searchDocuments($badhql)))
{{include document=XWiki.Results/}}
{{/velocity}}
The bad thing is that $xwiki.searchDocuments brought me to this
state
(no programming rights.).
If there would be a possibility to allow 'bad queries' only for
programming APIs
(considering that all other calls should be safe), then this
could be a decent
middle way, otherwise I'm for no limits.
Now my question is: Are there any remedies against this? MySQL
configuration statements that prevent this kind of behaviour?
as Oana was remarking earlier in a conversation, the settings
could be done on
database server side, regardless of xwiki, and depending on what
your specific
needs on an instance are.
Thanks,
Anca
___
users mailing list
users@xwiki.org
http://lists.xwiki.org/mailman/listinfo/users
___
users mailing list
users@xwiki.org
http://lists.xwiki.org/mailman/listinfo/users
Re: [xwiki-users] Lucene defaultpage fails
In my case I have no control over the xwiki; it's hosted at xwiki.sas (or xwiki.com) I think the advantage is that Thomas has access to all the systemdata? Op 19 jan 2010, om 13:48 heeft Thomas Mortagne het volgende geschreven: On Tue, Jan 19, 2010 at 13:26, Petteri Karttunen petteri.karttu...@gmail.com wrote: Hello, My issues seem to happen randomly but not at startup. Plugin works well from some hours to some days but I'm not sure what triggers this. I haven't been able to debug anything of interest in plugin's logs. Only potential clue I have is that plugin is leaving index files open which -at least- leads Tomcat finally to too many files open -error at some point. lsof | grep lucene gives me a bunch of these: ... java.bin 10095 tomcat 666r REG 104,1 60931511 15634869 /srv/www/DATA/xwiki/lucene/_5r7.cfs (deleted) java.bin 10095 tomcat 667r REG 104,1 60931507 15634870 /srv/www/DATA/xwiki/lucene/_5r9.cfs (deleted) java.bin 10095 tomcat 668r REG 104,1 60931507 15634871 /srv/www/DATA/xwiki/lucene/_5rb.cfs (deleted) ... Also, xwiki gets the plugin object normally during the malfunctional state but it seems it just cannot read index. Could it be that the plugin becomes unusable not before a deleted index file becomes overwritten by the system? That could be the reason why the time it works varies so much (depending on the other file system usage of the underlying operating system)? WDT? This one is http://jira.xwiki.org/jira/browse/XPLUCENE-30 but I don't see how it could be the source of the nullpointer exception issue. -Pete -Alkuperäinen viesti- Lähettäjä: users-boun...@xwiki.org [mailto:users-boun...@xwiki.org] Puolesta Thomas Mortagne Lähetetty: 19. tammikuuta 2010 13:20 Vastaanottaja: XWiki Users Aihe: Re: [xwiki-users] Lucene defaultpage fails Hi guys, getting some informations since i can't find just at looking at the code how this would append. When you have the issue, does it appending since the time you started XWiki or does it works and at some point it stops to work even if you did not restarted XWiki. Basically is it always a startup issue ? And in that case do you have anything in the beginning of the log like a warning or something indicating that something wrong append during lucene plugin initialization ? On Tue, Jan 19, 2010 at 07:20, Gerritjan Koekkoek gerritjankoekk...@gmail.com wrote: The following command (thanks Pete) worked en reinitialized Lucene after that lucenesearch worked again. Hope to hear soon how to prevent that Lucene is not initialized? xwiki.getXWiki().getPluginManager().getPlugin(lucene).init(xwiki.getXWikiC ontext()) Op 18 jan 2010, om 10:46 heeft Guillaume Lerouge het volgende geschreven: Hi, yes, I'm frequently hitting this error too and I'm not sure why. Thomas Mortagne looked at it last week but he doesn't have a fix yet. I was provided with a workaround last friday, I'll see if I can post it on code.xwiki.org Guillaume On Mon, Jan 18, 2010 at 10:05 AM, Petteri Karttunen petteri.karttu...@gmail.com wrote: Hi, I'm also encountering this problem randomly since XWiki 2.0 but so far haven't been able to find the initial cause. See also http://www.mail-archive.com/users@xwiki.org/msg09549.html. As Marius suggests it might have something to do with the plugin initialization because re-initializing the plugin under those circumstances helps in my case: ... xwiki.getXWiki().getPluginManager().getPlugin(lucene).init(xwiki.getXWikiC ontext()) ... but this of course doesn't solve the problem behind. -Pete -Alkuperäinen viesti- Lähettäjä: users-boun...@xwiki.org [mailto:users-boun...@xwiki.org] Puolesta Gerritjan Koekkoek Lähetetty: 17. tammikuuta 2010 21:26 Vastaanottaja: XWiki Users Aihe: Re: [xwiki-users] Lucene defaultpage fails See below for extended error-report I also paste the code Op 17 jan 2010, om 18:12 heeft Flavius Olaru het volgende geschreven: On Sun, Jan 17, 2010 at 1:35 PM, Gerritjan Koekkoek gerritjankoekk...@gmail.com wrote: Navigating to the Main.LuceneSearch page brings up the following error? Failed to execute macro: velocity org.xwiki.rendering.macro.MacroExecutionException: Failed to evaluate Velocity Macro for content [$xwiki.jsfx.use(uicomponents/search/search.js, true)## $xwiki.ssfx.use(uicomponents/search/search.css, true)## The page has worked, but what can be wrong now. The page itself is not changed from the distribution? Gerritjan ___ users mailing list users@xwiki.org http://lists.xwiki.org/mailman/listinfo/users Hi Gerritjan, Can you paste in more information about the error? -- Flavius Olaru ## Disable the document extra data: comments, attachments, history... #set($docextras = []) ## === ## Lucene search ##
Re: [xwiki-users] Problem with getting Xwiki to work with Oracle10g
Sorry, that I didn't answer yesterday. My message was bounced from the list. i hope it works now. This was my message: Thank you all for willing to help me. Now I checked the stack trace. You can see it below. I cannot understand the error log. It says, as far as I understand it, that it cannot load the jdbc driver, but why? I copied it into the lib folder. 2010-01-19 15:39:53,711 WARN [RequestUtils] No FormBeanConfig found under 'view' 2010-01-19 15:39:53,996 INFO [ PlatformMBeanServerRegistration] JBossCache MBeans were successfully registered to the platform mbean server. 2010-01-19 15:39:53,996 INFO [ComponentRegistry] JBoss Cache version: JBossCache 'Malagueta' 3.2.1.GA http://3.2.1.ga/ 2010-01-19 15:39:54,274 INFO [PlatformMBeanServerRegistration] JBossCache MBeans were successfully registered to the platform mbean server. 2010-01-19 15:39:54,274 INFO [ComponentRegistry] JBoss Cache version: JBossCache 'Malagueta' 3.2.1.GA http://3.2.1.ga/ 2010-01-19 15:39:54,275 WARN [DefaultObservationManager] The [com.xpn.xwiki.store.XWikiCacheStore] listener has overwritten a previously registered listener [com.xpn.xwiki.store.XWikiCacheStore] since they both are registered under the same id [XWikiCacheStore]. In the future consider removing a Listener first if you really want to register it again. 2010-01-19 15:39:54,277 INFO [XWiki] Running storage migrations 2010-01-19 15:39:54,279 INFO [Configuration] configuring from resource: /WEB-INF/hibernate.cfg.xml 2010-01-19 15:39:54,299 INFO [Configuration] Reading mappings from resource : xwiki.oracle.hbm.xml 2010-01-19 15:39:54,716 INFO [HbmBinder] Mapping class: com.xpn.xwiki.doc.XWikiDocument - xwikidoc 2010-01-19 15:39:54,892 INFO [HbmBinder] Mapping class: com.xpn.xwiki.doc.rcs.XWikiRCSNodeInfo - xwikircs 2010-01-19 15:39:54,899 INFO [HbmBinder] Mapping class: com.xpn.xwiki.doc.rcs.XWikiRCSNodeContent - xwikircs 2010-01-19 15:39:54,951 INFO [HbmBinder] Mapping class: com.xpn.xwiki.doc.XWikiDeletedDocument - xwikirecyclebin 2010-01-19 15:39:54,982 INFO [HbmBinder] Mapping class: com.xpn.xwiki.doc.DeletedAttachment - xwikiattrecyclebin 2010-01-19 15:39:55,005 INFO [HbmBinder] Mapping class: com.xpn.xwiki.doc.XWikiLock - xwikilock 2010-01-19 15:39:55,007 INFO [HbmBinder] Mapping class: com.xpn.xwiki.doc.XWikiLink - xwikilinks 2010-01-19 15:39:55,009 INFO [HbmBinder] Mapping class: com.xpn.xwiki.doc.XWikiAttachment - xwikiattachment 2010-01-19 15:39:55,012 INFO [HbmBinder] Mapping class: com.xpn.xwiki.doc.XWikiAttachmentContent - xwikiattachment_content 2010-01-19 15:39:55,014 INFO [HbmBinder] Mapping class: com.xpn.xwiki.doc.XWikiAttachmentArchive - xwikiattachment_archive 2010-01-19 15:39:55,015 INFO [HbmBinder] Mapping class: com.xpn.xwiki.objects.classes.PropertyClass - xwikiclassesprop 2010-01-19 15:39:55,260 INFO [HbmBinder] Mapping joined-subclass: com.xpn.xwiki.objects.classes.NumberClass - xwikinumberclasses 2010-01-19 15:39:55,290 INFO [HbmBinder] Mapping joined-subclass: com.xpn.xwiki.objects.classes.StringClass - xwikistringclasses 2010-01-19 15:39:55,291 INFO [HbmBinder] Mapping joined-subclass: com.xpn.xwiki.objects.classes.DateClass - xwikidateclasses 2010-01-19 15:39:55,292 INFO [HbmBinder] Mapping joined-subclass: com.xpn.xwiki.objects.classes.PasswordClass - xwikistringclasses 2010-01-19 15:39:55,294 INFO [HbmBinder] Mapping joined-subclass: com.xpn.xwiki.objects.classes.TextAreaClass - xwikistringclasses 2010-01-19 15:39:55,295 INFO [HbmBinder] Mapping joined-subclass: com.xpn.xwiki.objects.classes.BooleanClass - xwikibooleanclasses 2010-01-19 15:39:55,296 INFO [HbmBinder] Mapping joined-subclass: com.xpn.xwiki.objects.classes.StaticListClass - xwikislistclasses 2010-01-19 15:39:55,298 INFO [HbmBinder] Mapping joined-subclass: com.xpn.xwiki.objects.classes.DBListClass - xwikidblistclasses 2010-01-19 15:39:55,299 INFO [HbmBinder] Mapping class: com.xpn.xwiki.objects.classes.BaseClass - xwikiclasses 2010-01-19 15:39:55,301 INFO [HbmBinder] Mapping class: com.xpn.xwiki.objects.BaseProperty - xwikiproperties 2010-01-19 15:39:55,302 INFO [HbmBinder] Mapping joined-subclass: com.xpn.xwiki.objects.IntegerProperty - xwikiintegers 2010-01-19 15:39:55,303 INFO [HbmBinder] Mapping joined-subclass: com.xpn.xwiki.objects.LongProperty - xwikilongs 2010-01-19 15:39:55,304 INFO [HbmBinder] Mapping joined-subclass: com.xpn.xwiki.objects.FloatProperty - xwikifloats 2010-01-19 15:39:55,305 INFO [HbmBinder] Mapping joined-subclass: com.xpn.xwiki.objects.DoubleProperty - xwikidoubles 2010-01-19 15:39:55,306 INFO [HbmBinder] Mapping joined-subclass: com.xpn.xwiki.objects.StringProperty - xwikistrings 2010-01-19 15:39:55,307 INFO [HbmBinder] Mapping joined-subclass: com.xpn.xwiki.objects.DateProperty - xwikidates 2010-01-19 15:39:55,307 INFO [HbmBinder] Mapping joined-subclass: com.xpn.xwiki.objects.LargeStringProperty - xwikilargestrings 2010-01-19 15:39:55,308 INFO [HbmBinder] Mapping joined-subclass:
