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 !!! :( |
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 |
k thanks for the prompt reply !! Will definitely have a look at it when time permits !!! Thanks !!
|
Free forum by Nabble | Edit this page |