Re: Jahia postgresql problem. catalina.out

Javier TurĂ©gano <[email protected]> Tue, 13 Nov 2007 16:18:35 +0100 (CET)
Newsgroups gmane.comp.cms.jahia.install
Message-ID <[email protected]>
We decided to give a try to the export and import option you have
commented. Is it posible to export a site running a version of Jahia,
5.0.0 in our case, and import in a new fresh 5.0.3 instalation? Is it a
good idea?

Also the export process from the administration menu crashes with this
message:

User message=3DError while processing request, System message=3DException in
processing pipeline, root cause:User message=3DException occured, System
message=3DException occured, root cause:null

Exception StackTrace: Cause level : 0 (level 0 is the most precise exceptio=
n)
java.lang.NullPointerException

I can send a complete trace if needed.

Thanks.

El Mar, 13 de Noviembre de 2007, 3:14 pm, Sergiy Shyrkov escribi=F3:
> Hi Javier,
>
> there is no standard procedure defined for migrating existing HSQL
> database to PostgreSQL.
> You can export your Jahia virtual site from Jahia instance, running on
> HSQL, and import it on a fresh installation of Jahia, configured for
> PostgreSQL.
>
> Kind regards
> Sergiy
>
> Javier Tur=E9gano wrote:
>> OK, giving the right privileges to jahia user was the point. Now Jahia
>> is
>> working ok with the remote postgresql db.
>>
>> What I am dubting if the process of migration from the hsql to the
>> postgres was right. First i have character coding issues, maybe HSQL and
>> postgres were not working in the same locale configuration. Has anybody
>> migrated from HSQL to Postgres succesfully? I think our process is not
>> the
>> right one.
>>
>> By the other hand I am getting the next error in the catalina.out log:
>>
>> org.hibernate.exception.SQLGrammarException: Could not execute JDBC
>> batch
>> update
>>
>> I dont know exactly where can the problem come form.
>>
>>
>
>


-- =

---------------------------------
Javier Tur=E9gano Molina
Jefe de Proyecto

Andago Ingenier=EDa
www.andago.com
t: 916011373 Ext. 45
f: 916011372
--------------------------------
ADE7 A690 29BB C644 3021  3919 C702 E423 014A D1F6

_______________________________________________
install_list mailing list
[email protected]
http://lists.jahia.org/cgi-bin/mailman/listinfo/install_list