db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Rajesh Kartha <karth...@gmail.com>
Subject Re: Syntax error: Encountered "\'" at line 1, column 844.
Date Fri, 07 Jul 2006 22:26:46 GMT
Patrick Villacorta wrote:

> Hi,
>
> I'm trying to convert an HSQL SQL script to Derby SQL syntax. I've 
> gotten stuck with this error: "Syntax error: Encountered "\'" at line 
> 1, column 844.". Any insight on what's going on?
>
>
> Here's the Stack trace:
>
> jvm 1    | org.springframework.beans.factory.BeanCreationException: 
> Error creating bean with name 'liferaySchemaCreator' defined in file 
> [C:\logicblaze\source\fuse\target\fuse-1.2-SNAPSHOT\components\jndi\jndi-xbean.xml]:

> Initialization of bean failed; nested exception is 
> org.apache.ddlutils.DynaSqlException: Error while executing SQL 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:stylesheet 
> xmlns:xsl="http://www.w3.org/1999/XSL/Transform" version="1.0">  
> \u000a  <xsl:template match="/"> \u000a    <link rel="alternate" 
> type="application/rss+xml" title="Liferay RSS Feed" 
> href="http://@portal_url@/cms/servlet/news-rss-feed?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="document(''http://@portal_url@/c/journal/get_articles?templateId=BASIC-RSS-ITEM&amp

>
> jvm 1    | org.apache.ddlutils.DynaSqlException: Error while executing 
> SQL 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:stylesheet 
> xmlns:xsl="http://www.w3.org/1999/XSL/Transform" version="1.0">  
> \u000a  <xsl:template match="/"> \u000a    <link rel="alternate" 
> type="application/rss+xml" title="Liferay RSS Feed" 
> href="http://@portal_url@/cms/servlet/news-rss-feed?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="document(''http://@portal_url@/c/journal/get_articles?templateId=BASIC-RSS-ITEM&amp

>
> jvm 1    |      at 
> org.apache.ddlutils.platform.PlatformImplBase.evaluateBatch(PlatformImplBase.java:218)

>
> jvm 1    |      at 
> org.apache.ddlutils.platform.PlatformImplBase.evaluateBatch(PlatformImplBase.java:160)

>
> jvm 1    |      at 
> org.logicblaze.soa.SchemaCreator.afterPropertiesSet(SchemaCreator.java:89) 
>
> jvm 1    |      at 
> org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeInitMethods(AbstractAutowireCapableBeanFactory.java:1059)

>
> jvm 1    |      at 
> org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:363)

>
> jvm 1    |      at 
> org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:226)

>
> jvm 1    |      at 
> org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:147)

>
> jvm 1    |      at 
> org.springframework.beans.factory.support.DefaultListableBeanFactory.preInstantiateSingletons(DefaultListableBeanFactory.java:275)

>
> jvm 1    |      at 
> org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:320)

>
> jvm 1    |      at 
> org.apache.xbean.spring.context.ResourceXmlApplicationContext.<init>(ResourceXmlApplicationContext.java:83)

>
> jvm 1    |      at 
> org.apache.xbean.server.deployer.FileDeployer.createServiceForFile(FileDeployer.java:344)

>
> jvm 1    |      at 
> org.apache.xbean.server.deployer.FileDeployer.processDirectory(FileDeployer.java:277)

>
> jvm 1    |      at 
> org.apache.xbean.server.deployer.FileDeployer.processDirectory(FileDeployer.java:288)

>
> jvm 1    |      at 
> org.apache.xbean.server.deployer.FileDeployer.afterPropertiesSet(FileDeployer.java:88)

>
> jvm 1    |      at 
> org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeInitMethods(AbstractAutowireCapableBeanFactory.java:1059)

>
> jvm 1    |      at 
> org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:363)

>
> jvm 1    |      at 
> org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:226)

>
> jvm 1    |      at 
> org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:147)

>
> jvm 1    |      at 
> org.springframework.beans.factory.support.DefaultListableBeanFactory.preInstantiateSingletons(DefaultListableBeanFactory.java:275)

>
> jvm 1    |      at 
> org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:320)

>
> jvm 1    |      at 
> org.apache.xbean.spring.context.ClassPathXmlApplicationContext.<init>(ClassPathXmlApplicationContext.java:158)

>
> jvm 1    |      at 
> org.apache.xbean.spring.context.ClassPathXmlApplicationContext.<init>(ClassPathXmlApplicationContext.java:48)

>
> jvm 1    |      at 
> org.apache.xbean.server.spring.main.SpringBootstrap.loadMain(SpringBootstrap.java:265)

>
> jvm 1    |      at 
> org.apache.xbean.server.spring.main.SpringBootstrap.boot(SpringBootstrap.java:287) 
>
> jvm 1    |      at 
> org.apache.xbean.server.spring.main.SpringBootstrap.main(SpringBootstrap.java:90) 
>
> jvm 1    |      at 
> org.logicblaze.soa.BootstrapMain.main(BootstrapMain.java:41)
> jvm 1    |      at sun.reflect.NativeMethodAccessorImpl.invoke0(Native 
> Method)
> jvm 1    |      at 
> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) 
>
> jvm 1    |      at 
> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)

>
> jvm 1    |      at java.lang.reflect.Method.invoke(Method.java:585)
> jvm 1    |      at org.logicblaze.soa.Main.runTaskClass(Main.java:164)
> jvm 1    |      at org.logicblaze.soa.Main.main(Main.java:76)
> jvm 1    |      at sun.reflect.NativeMethodAccessorImpl.invoke0(Native 
> Method)
> jvm 1    |      at 
> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) 
>
> jvm 1    |      at 
> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)

>
> jvm 1    |      at java.lang.reflect.Method.invoke(Method.java:585)
> jvm 1    |      at 
> org.tanukisoftware.wrapper.WrapperSimpleApp.run(WrapperSimpleApp.java:197) 
>
> jvm 1    |      at java.lang.Thread.run(Thread.java:595)
> jvm 1    | Caused by: SQL Exception: Syntax error: Encountered "\'" at 
> line 1, column 844.
> jvm 1    |      at 
> org.apache.derby.impl.jdbc.Util.generateCsSQLException(Util.java)
> jvm 1    |      at 
> org.apache.derby.impl.jdbc.TransactionResourceImpl.wrapInSQLException(TransactionResourceImpl.java)

>
> jvm 1    |      at 
> org.apache.derby.impl.jdbc.TransactionResourceImpl.handleException(TransactionResourceImpl.java)

>
> jvm 1    |      at 
> org.apache.derby.impl.jdbc.EmbedConnection.handleException(EmbedConnection.java) 
>
> jvm 1    |      at 
> org.apache.derby.impl.jdbc.ConnectionChild.handleException(ConnectionChild.java) 
>
> jvm 1    |      at 
> org.apache.derby.impl.jdbc.EmbedStatement.execute(EmbedStatement.java)
> jvm 1    |      at 
> org.apache.derby.impl.jdbc.EmbedStatement.executeUpdate(EmbedStatement.java) 
>
> jvm 1    |      at 
> org.apache.ddlutils.platform.PlatformImplBase.evaluateBatch(PlatformImplBase.java:202)

>
> jvm 1    |      ... 37 more
> wrapper  | <-- Wrapper Stopped
>
>
> Here's the complete SQL statement:
>
> 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:stylesheet 
> xmlns:xsl="http://www.w3.org/1999/XSL/Transform" version="1.0">  
> \u000a  <xsl:template match="/"> \u000a    <link rel="alternate" 
> type="application/rss+xml" title="Liferay RSS Feed" 
> href="http://@portal_url@/cms/servlet/news-rss-feed?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="document(''http://@portal_url@/c/journal/get_articles?templateId=BASIC-RSS-ITEM&amp;delta=4&amp;orderBy=displayDate'')/result-set/result"/>
 
> \u000a    <xsl:for-each select="$articles"> \u000a      <b> 
> \u000a        <a> \u000a          <xsl:attribute 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" select="reserved-info/title"/> 
> \u000a        </a> \u000a      </b>  \u000a      <br/>  \u000a    
 
> <font color="#777777"> \u000a        <xsl:text>(</xsl:text>  
> \u000a        <xsl:value-of disable-output-escaping="yes" 
> select="root/dynamic-element[@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-content"/>  
> \u000a      <br/>  \u000a      <br/> \u000a    </xsl:for-each> \u000a
 
> </xsl:template> \u000a</xsl:stylesheet>','xsl',0,'');
>
>
> The create table statement might help:
>
> 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 VARCHAR(75),CONSTRAINT SPKJOURNALTEMPLATE 
> PRIMARY KEY(COMPANYID,TEMPLATEID));
>
>
> Thanks,
> Patrick
>
>
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