db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Patrick Villacorta <pvillaco...@exist.com>
Subject Re: Syntax error: Encountered "\'" at line 1, column 844.
Date Sat, 08 Jul 2006 05:29:45 GMT
Thanks Rajesh, I'll give this a try

Regards,
Patrick


Rajesh Kartha wrote:
> Hi Patrick,
>
> The Insert you mentioned in your mail works fine in Derby when run 
> under the ij tool separately:
>
> ij version 10.1
> ij> connect 'jdbc:derby:testdb;create=true';
> WARNING 01J01: Database 'testdb' not created, connection made to 
> existing database instead.
> ij> CREATE TABLE JOURNALTEMPLATE(COMPANYID VARCHAR(75) NOT 
> NULL,TEMPLATEID VARCHAR(75) NOT NULL,GROUPID VARCHAR(75) NOT
> NULL,USERID VARCHAR(75) NOT NULL,USERNAME VARCHAR(75),CREATEDATE 
> TIMESTAMP,MODIFIEDDATE TIMESTAMP,STRUCTUREID VARCHAR(75
> ),NAME VARCHAR(75),DESCRIPTION LONG VARCHAR,XSL LONG VARCHAR,LANGTYPE 
> VARCHAR(75),SMALLIMAGE SMALLINT,SMALLIMAGEURL VARC
> HAR(75),CONSTRAINT SPKJOURNALTEMPLATE PRIMARY KEY(COMPANYID,TEMPLATEID));
> 0 rows inserted/updated/deleted
> ij>
> INSERT INTO JOURNALTEMPLATE 
> VALUES('liferay.com','ABOUTUS-NEWS','2','admin','Joe 
> Bloggs','2006-04-05 22:59:21.108','2006
> -04-05 22:59:21.108','ABOUTUS-NEWS','About Us News','Custom template 
> for News','<?xml version="1.0"?>\u000a\u000a<xsl:st
> ylesheet xmlns:xsl="http://www.w3.org/1999/XSL/Transform" 
> version="1.0">  \u000a  <xsl:template match="/"> \u000a    <li
> nk rel="alternate" type="application/rss+xml" title="Liferay RSS Feed" 
> href="http://@portal_url@/cms/servlet/news-rss-fe
> ed?mimeType=application/rss+xml"/>  \u000a    <xsl:if 
> test="root/dynamic-element[@name=''main-text'']/dynamic-content !=
> ''''">\u000a      <xsl:value-of disable-output-escaping="yes" 
> select="root/dynamic-element[@name=''main-text'']/dynamic
> -content"/> \u000a      <br/>\u000a      <br/>\u000a    
> </xsl:if>\u000a    <xsl:variable name="articles" select="documen
> t(''http://@portal_url@/c/journal/get_articles?templateId=BASIC-RSS-ITEM&amp;delta=4&amp;orderBy=displayDate'')/result-s

>
> et/result"/>  \u000a    <xsl:for-each select="$articles"> \u000a      
> <b> \u000a        <a> \u000a          <xsl:attribu
> te name="href"> \u000a            <xsl:value-of 
> disable-output-escaping="yes" select="root/dynamic-element[@name=''link'
> ']/dynamic-content"/> \u000a          </xsl:attribute>  
> \u000a          <xsl:value-of disable-output-escaping="yes" sele
> ct="reserved-info/title"/> \u000a        </a> \u000a      </b>  
> \u000a      <br/>  \u000a      <font color="#777777"> \u
> 000a        <xsl:text>(</xsl:text>  \u000a        <xsl:value-of 
> disable-output-escaping="yes" select="root/dynamic-eleme
> nt[@name=''creator'']/dynamic-content"/>  \u000a        
> <xsl:text>)</xsl:text> \u000a      </font>  \u000a      <br/>
 \
> u000a      <xsl:value-of disable-output-escaping="yes" 
> select="root/dynamic-element[@name=''description'']/dynamic-conte
> nt"/>  \u000a      <br/>  \u000a      <br/> \u000a    </xsl:for-each>

> \u000a  </xsl:template> \u000a</xsl:stylesheet>','
> xsl',0,'');
> 1 row inserted/updated/deleted
> ij> select * from JOURNALTEMPLATE;
> COMPANYID                                                                  
> |TEMPLATEID
>                               
> |GROUPID                                                                    
> |USERID
>                                                               |USERNAME
>                   |CREATEDATE                
> |MODIFIEDDATE              |STRUCTUREID
>                             
> |NAME                                                                       
> |DESCRIPTION
>                                                                                     
                            
> |XSL
>
>   
> |LANGTYPE                                                                   
> |SMALL&|SMALLIMAGEURL
>
> ------------------------------------------------------------------------------------------------------------------------

>
> ------------------------------------------------------------------------------------------------------------------------

>
> ------------------------------------------------------------------------------------------------------------------------

>
> ------------------------------------------------------------------------------------------------------------------------

>
> ------------------------------------------------------------------------------------------------------------------------

>
> ------------------------------------------------------------------------------------------------------------------------

>
> ------------------------------------------------------------------------------------------------------------------------

>
> ------------------------------------------------------------------------------------------------------------------------

>
> ------------------------------------------
> liferay.com                                                                
> |ABOUTUS-NEWS
>                               
> |2                                                                          
> |admin
>                                                               |Joe Bloggs
>                   |2006-04-05 22:59:21.108   |2006-04-05 
> 22:59:21.108   |ABOUTUS-NEWS
>                             |About Us 
> News                                                              
> |Custom templat
> e for 
> News                                                                                
                       
> |<?xml
> version="1.0"?>\u000a\u000a<xsl:stylesheet 
> xmlns:xsl="http://www.w3.org/1999/XSL/Transform" version="1.0">  
> \u000a  <xs
> l:&|xsl                                                                        
> |0     |
>
>
> 1 row selected
>
> In your case, the error  "Syntax error: Encountered "\'" at line 1, 
> column 844." seem to be coming from
> <snip>......<xsl:variable name="articles" select="document(' 
> .....</snip>. in the statement, which works fine when run as a SQL 
> statement
> in ij.
>
> Also, I noticed you are using the Apache ddlUtils,  is it possible to 
> run  the migration separately outside using ddlUtils without the 
> Spring framework.
> Maybe the following link will be useful is doing so:
> http://db.apache.org/derby/integrate/db_ddlutils.html
>
> Regards,
> Rajesh
>


Mime
View raw message