21 Jan
2010
21 Jan
'10
1:52 p.m.
Hello Vincent.
Thank you for your kindly reply.
Yes we used the HBM file for oracle. We did all the things that were
mentioned in the installtion guide for the xwiki. Creation of user on
oracle, deployment, changement of the hibernate-cfg and copying the jdbc
driver to the right place. I don't know if the problem is an issue of the
xwiki. I would rather think that it is a problem of the geronimo server that
we use. On the log of the geronimo server there is a warning that in the war
file there is no geronimo-web.xml configuration. In that file you should
give the geronimo server the information of using the database connection as
I could read it form the geronimo doc
The second big problem of using the xwiki is that we have here a deadline
and there is simple no more time for trying to install it.
I don't regret to try this lot on installing xwiki but I had hoped, when
there is on the official page an info about xwikis compatibility for oracle
that it would work. I cannot also say that we won't try xwiki in the future
for an another project but currently it is because of the time. Maybe you
can make some more tests in the future to really prove the oracle-support
for xwiki. I think it would make it much more easier for slightly bigger
companies to use xwiki if they really knew that it works properly.
Altough thank you very much for the help.
Best regards Oskar
2010/1/21 Vincent Massol <vincent(a)massol.net>
Hi Oskar,
Too bad that you couldn't get it to work. I haven't followed but you're use
the xwiki oracle HBM mapping file right?
AFAIK several users of xwiki are using Oracle. I know for sure it used to
work and we haven't done changes to the database mapping so it would be
strange it's not working anymore. What's possible though is that some
features don't work without tweaking of the hibernate mapping or minor
changes to the code (for ex Oracle considers NULL and empty strings as the
same thing AFAIR) but the majority of features should work fine. And for
features that don't work we can work together to fix them.
Thanks
-Vincent
On Jan 21, 2010, at 1:23 PM, Oskar Marek Rzepinski wrote:
Hello everybody,
now after a lot of testing I think I have to look for an another wiki. I
have the right driver, I checked this. The configuration is also not the
problem, all parameters are O.K. I think that we have a problem with the
geronimo server that don't let us connect to the database. It is really
annoying that we won't get the xwiki running. The problem is, that for
performance reasons we won't use any other database system or an another
container than geronimo(tomcat). Thanks to all, who tried to help me.
Best regards Oskar
2010/1/20 Alonso Isidoro Roman <alonsoir(a)gmail.com>
> 2010/1/20 Caleb James DeLisle <calebdelisle(a)lavabit.com>
>
>> The problem is definitely that XWiki can't get at the jdbc connector so
I
>> don't
>> think creating the database will help, also XWiki uses a complicated
> schema
>> so creating the tables manually is not really an option.
>>
>> i think i did not suggest to create manually the schema!
>
>
>> I would go into the WEB-INF/lib and find the jdbc connector jar you
> added,
>> open it with a zip program, (jar is just a special type of zip file)
look
>> inside
>> and make sure it has the file oracle/jdbc/driver/OracleDriver.class
>> Maybe you are using the wrong jdbc.
>>
>> thats a good advice!
>
>
>> Your persistence is admirable!
>>
>> Caleb
>>
>> Oskar Marek Rzepinski wrote:
>>> Hi Alonso.
>>>
>>> Thank you for all the hints. You are writing about creating table. How
> do
>> I
>>> create the table? I thought, that xwiki is doing this after the right
>>> configuration. Am I right? Or have you a simple how-to for creating
the
>>> table? I have on oracle the user
xwiki with all privileges. The
>> deployment
>>> with the geronimo consle also worked fine. I am still thinking about
> the
>>> oracle if I have to do something more than creating only the user with
>> the
>>> right grants as it is said in the installation guide on the xwiki
page.
>>> Thanks again
>>>
>>>
>>> regards Oskar
>>>
>>>
>>> 2010/1/20 Alonso Isidoro Roman <alonsoir(a)gmail.com>
>>>
>>>> Hi Oscar,
>>>> i dont know about to think, only thing that i can imagine is the jar
> is
>> not
>>>> ok, corrupted or something like that.
>>>>
>>>> pls, try downloading again the jar, put it in /WEB-INF/lib xwiki´s
>> folder,
>>>> create a user xwiki with proper grants (create database, create
table,
>>>> etc...), put the war into webapps
jboss folder and breathe!
>>>>
>>>>
>>>>
>>
>
http://www.oracle.com/technology/software/tech/java/sqlj_jdbc/htdocs/jdbc10…
>>>>
>>>> sorry for not be able to help you anymore!
>>>>
>>>> regards
_______________________________________________
users mailing list
users(a)xwiki.org
http://lists.xwiki.org/mailman/listinfo/users