Upload CSS Button Click - Exception

classic Classic list List threaded Threaded
3 messages Options
Reply | Threaded
Open this post in threaded view
|

Upload CSS Button Click - Exception

karthik Jayaraman
Hi to all,

I have configured my orbeon to use mysql DB. Now here s my problem. When i click upload css from my form builder and select a css file, i am getting the error

                  "error in communicating with the database. please contact the administrator"

when i checked orbeon log the following exception was present




-----------------------------------------------------------------------------------------------------


2010-03-26 19:18:05,739 ERROR SQLProcessor  - PreparedStatement:

                                                   
                                                  insert
                                                      into orbeon_form_data_attach
                                                        (created, last_modified, username, app, form, document_id, deleted,
                                                            file_name, file_content)
                                                               select case when last_deleted is null or last_deleted = 'Y' then
    ?
    else
    last_created
    end as lc,
         
                                                             ? ,
                                                             ? ,
                                                             ? ,
                                                             ? ,
                                                             ? ,
                                                           
                                                            'N',
                                                             ? ,
                                                                 ?
        from (
    select v1.*,  (
        select deleted
        from orbeon_form_data_attach
        where
            app =  ?
            and form =  ?
                and document_id =  ?
                and file_name =  ?
            and last_modified = v1.last_last_modified
            ) last_deleted
            from
    (select max(last_modified) last_last_modified , max(created) last_created
    from (
            select max(last_modified) last_modified, max(created) created
            from orbeon_form_data_attach
            where
                app =  ?
                and form =  ?
                    and document_id =  ?
                    and file_name =  ?
         union all  select null last_modified, null created from dual
    )v2) v1 )v;
                                           
2010-03-26 19:18:05,739 INFO  DatabaseContext  - Rolling back JDBC connection for datasource: [com.mysql.jdbc.Driver|jdbc:mysql://localhost:3306/orbeon03232010|root].
2010-03-26 19:18:05,927 ERROR ProcessorService  - Exception at line 321 of oxf:/apps/cps/persistence/mysql/crud.xpl
org.orbeon.oxf.common.OXFException: Invalid sql-type attribute: blob
        at org.orbeon.oxf.processor.sql.interpreters.QueryInterpreter.end(QueryInterpreter.java:582)


-----------------------------------------------------------------------------------------------


Now i am seeking some ones help !!!   :(
Reply | Threaded
Open this post in threaded view
|

Re: Upload CSS Button Click - Exception

Alessandro  Vernet
Administrator
This is because at this point, the MySQL persistence layer does not
support attachments, as noted in the Limitations sections of the MySQL
persistence layer page.

http://wiki.orbeon.com/forms/doc/developer-guide/form-runner/mysql-persistence-layer

Now, the MySQL persistence layer is just a few weeks old, so bear with
us on this one. Or maybe this is something you can help with: you will
find the relevant source is in
resources/apps/fr/persistence/mysql/crud.xpl.

Alex

On Fri, Mar 26, 2010 at 6:52 AM, karthik Jayraman <[hidden email]> wrote:

>
> Hi to all,
>
> I have configured my orbeon to use mysql DB. Now here s my problem. When i
> click upload css from my form builder and select a css file, i am getting
> the error
>
>                  "error in communicating with the database. please contact
> the administrator"
>
> when i checked orbeon log the following exception was present
>
>
>
>
> -----------------------------------------------------------------------------------------------------
>
>
> 2010-03-26 19:18:05,739 ERROR SQLProcessor  - PreparedStatement:
>
>
>                                                  insert
>                                                      into
> orbeon_form_data_attach
>                                                        (created,
> last_modified, username, app, form, document_id, deleted,
>                                                            file_name,
> file_content)
>                                                               select case
> when last_deleted is null or last_deleted = 'Y' then
>         ?
>        else
>        last_created
>        end as lc,
>
>                                                             ? ,
>                                                             ? ,
>                                                             ? ,
>                                                             ? ,
>                                                             ? ,
>
>                                                            'N',
>                                                             ? ,
>                                                                 ?
>        from (
>    select v1.*,  (
>        select deleted
>        from orbeon_form_data_attach
>        where
>            app =  ?
>            and form =  ?
>                and document_id =  ?
>                and file_name =  ?
>            and last_modified = v1.last_last_modified
>            ) last_deleted
>            from
>    (select max(last_modified) last_last_modified , max(created)
> last_created
>    from (
>            select max(last_modified) last_modified, max(created) created
>            from orbeon_form_data_attach
>            where
>                app =  ?
>                and form =  ?
>                    and document_id =  ?
>                    and file_name =  ?
>         union all  select null last_modified, null created from dual
>    )v2) v1 )v;
>
> 2010-03-26 19:18:05,739 INFO  DatabaseContext  - Rolling back JDBC
> connection for datasource:
> [com.mysql.jdbc.Driver|jdbc:mysql://localhost:3306/orbeon03232010|root].
> 2010-03-26 19:18:05,927 ERROR ProcessorService  - Exception at line 321 of
> oxf:/apps/cps/persistence/mysql/crud.xpl
> org.orbeon.oxf.common.OXFException: Invalid sql-type attribute: blob
>        at
> org.orbeon.oxf.processor.sql.interpreters.QueryInterpreter.end(QueryInterpreter.java:582)
>
>
> -----------------------------------------------------------------------------------------------
>
>
> Now i am seeking some ones help !!!   :(
> --
> View this message in context: http://n4.nabble.com/Upload-CSS-Button-Click-Exception-tp1692219p1692219.html
> Sent from the Orbeon Forms (ops-users) mailing list archive at Nabble.com.
>
>
> --
> You receive this message as a subscriber of the [hidden email] mailing list.
> To unsubscribe: mailto:[hidden email]
> For general help: mailto:[hidden email]?subject=help
> OW2 mailing lists service home page: http://www.ow2.org/wws
>
>


--
Orbeon Forms - Web forms, open-source, for the Enterprise -
http://www.orbeon.com/
My Twitter: http://twitter.com/avernet


--
You receive this message as a subscriber of the [hidden email] mailing list.
To unsubscribe: mailto:[hidden email]
For general help: mailto:[hidden email]?subject=help
OW2 mailing lists service home page: http://www.ow2.org/wws
--
Follow Orbeon on Twitter: @orbeon
Follow me on Twitter: @avernet
Reply | Threaded
Open this post in threaded view
|

Re: Upload CSS Button Click - Exception

karthik Jayaraman
k thanks for the prompt reply !! Will definitely have a look at it when time permits !!! Thanks !!