You are viewing a plain text version of this content. The canonical link for it is here.
Posted to users@maven.apache.org by Jason Perry <jp...@brightcove.com> on 2010/12/22 21:38:52 UTC
maven sql plugin and clobs
Hi,
I am running into a problem when trying trying to import a .sql file that
has clob data. Anyone run into this or know of a workaround? Here is the
failure:
[INFO]
------------------------------------------------------------------------
[ERROR] BUILD ERROR
[INFO]
------------------------------------------------------------------------
[INFO] ORA-06550: line 6, column 15:
PLS-00103: Encountered the symbol "
<html>
<head>
<meta http-equiv="Content-Type" content="text/htm" when expecting one of the
following:
( - + case mod new not null <an identifier>
<a double-quoted delimited-identifier> <a bind variable> avg
count current exists max min prior sql stddev sum variance
execute forall merge time timestamp interval date
<a string literal with character set specification>
<a number> <a single-quoted SQL string> pipe
<an alternatively-quoted string literal
Thanks,
-- Jay
Re: maven sql plugin and clobs
Posted by Wayne Fay <wa...@gmail.com>.
> I am running into a problem when trying trying to import a .sql file that
> has clob data. Anyone run into this or know of a workaround? Here is the
Did you try escaping the quotes? The error makes me think that you
could make it work if you just monkey with the clob data. Depending on
how often it changes, this may or may not be an acceptable solution.
I know there was talk of a sqlplus plugin at some point on this list
that might be useful for you but don't know if anyone actually
implemented it. Check Google and Nabble for the ml archive.
Wayne
---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@maven.apache.org
For additional commands, e-mail: users-help@maven.apache.org
Re: maven sql plugin and clobs
Posted by Jay Perry <bo...@gmail.com>.
Hi,
I'm not exactly sure how it is generated as our DB Admin is on vacation
since he updates the file. About the version of Oracle we are using it is
10.2.1. I can see about escaping those values just to narrow down the
issue. I'll also look into how the sqlplus option is done. Let me know if
any of you can think of anything else.
Thanks,
Jay
--
View this message in context: http://maven.40175.n5.nabble.com/maven-sql-plugin-and-clobs-tp3315695p3331402.html
Sent from the Maven - Users mailing list archive at Nabble.com.
---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@maven.apache.org
For additional commands, e-mail: users-help@maven.apache.org
Re: maven sql plugin and clobs
Posted by Mark Struberg <st...@yahoo.de>.
How did you generate/create the clob script?
I'm using clobs in mysql migrationdata imports and they work fine. I'm using mysqldump to create the sql file which correctly escapes those values.
I assume you have Oracle 11? (up 2 Oracle 10 it was imo only able to export to their own bin format)
LieGrue,
strub
--- On Wed, 12/22/10, Jason Perry <jp...@brightcove.com> wrote:
> From: Jason Perry <jp...@brightcove.com>
> Subject: maven sql plugin and clobs
> To: users@maven.apache.org
> Date: Wednesday, December 22, 2010, 8:38 PM
> Hi,
>
> I am running into a problem when trying trying to import a
> .sql file that
> has clob data. Anyone run into this or know of a
> workaround? Here is the
> failure:
>
> [INFO]
> ------------------------------------------------------------------------
> [ERROR] BUILD ERROR
> [INFO]
> ------------------------------------------------------------------------
> [INFO] ORA-06550: line 6, column 15:
> PLS-00103: Encountered the symbol "
> <html>
> <head>
> <meta http-equiv="Content-Type" content="text/htm" when
> expecting one of the
> following:
>
> ( - + case mod new not null <an
> identifier>
> <a double-quoted
> delimited-identifier> <a bind variable> avg
> count current exists max min prior sql
> stddev sum variance
> execute forall merge time timestamp
> interval date
> <a string literal with character set
> specification>
> <a number> <a single-quoted SQL
> string> pipe
> <an alternatively-quoted string
> literal
>
> Thanks,
> -- Jay
>
---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@maven.apache.org
For additional commands, e-mail: users-help@maven.apache.org