Hello,
I am a cocoon newbie, so any suggestions are greatly appreciated!
I have the following entry in my sitemap, to try and use the DatabaseReader:
<!-- =============== Files from Database ==================== -->
<map:match pattern="**images_db/**.jpg">
<map:read type="db-img-resource" src=""02000437"" mime-type="image/jpeg">
<map:parameter name="table" value="personBin"/>
<map:parameter name="image" value="photo"/>
<map:parameter name="key" value="pin"/>
</map:read>
</map:match>
The column named "pin" is an INT in the Sybase database. I get the following error in the sitemap.log.
What do I need to do to tell the DatabaseReader I am sending an INT and not a string in the src=""02000437"" line?
Cocoon 2.0.2
JDK 1.3
Tomcat 4.0.1
Thanks,
Beth
WARN (2002-06-03) 12:09.00:920 [sitemap.reader.img-db](/cocoon/otda_1/images_db/02000437.jpg) HttpProcessor[8080][2]/DatabaseReader: Could not get resource from Database
com.sybase.jdbc2.jdbc.SybSQLException: Implicit conversion from datatype 'CHAR' to 'INT' is not allowed. Use the CONVERT function to run this query.
at com.sybase.jdbc2.tds.Tds.processEed(Tds.java:2429)
at com.sybase.jdbc2.tds.Tds.nextResult(Tds.java:1865)
at com.sybase.jdbc2.jdbc.ResultGetter.nextResult(ResultGetter.java:69)
at com.sybase.jdbc2.jdbc.SybStatement.nextResult(SybStatement.java:201)
at com.sybase.jdbc2.jdbc.SybStatement.nextResult(SybStatement.java:182)
at com.sybase.jdbc2.jdbc.SybStatement.queryLoop(SybStatement.java:1401)
at com.sybase.jdbc2.jdbc.SybStatement.executeQuery(SybStatement.java:1386)
at com.sybase.jdbc2.jdbc.SybPreparedStatement.executeQuery(SybPreparedStatement.java:69)
at org.apache.cocoon.reading.DatabaseReader.setup(DatabaseReader.java:137)
at org.apache.cocoon.components.pipeline.CachingStreamPipeline.processReader(CachingStreamPipeline.java:135)
at org.apache.cocoon.components.pipeline.AbstractStreamPipeline.process(AbstractStreamPipeline.java:168)
at org.apache.cocoon.components.pipeline.CachingStreamPipeline.process(CachingStreamPipeline.java:293)
at org.apache.cocoon.www.otda_1.sitemap_xmap.matchN1011A(C:\Program Files\Apache Tomcat 4.0\work\localhost\cocoon\cocoon-files\org/apache/cocoon/www/otda_1\sitemap_xmap.java:1436)
at org.apache.cocoon.www.otda_1.sitemap_xmap.process(C:\Program Files\Apache Tomcat 4.0\work\localhost\cocoon\cocoon-files\org/apache/cocoon/www/otda_1\sitemap_xmap.java:761)
at org.apache.cocoon.www.otda_1.sitemap_xmap.process(C:\Program Files\Apache Tomcat 4.0\work\localhost\cocoon\cocoon-files\org/apache/cocoon/www/otda_1\sitemap_xmap.java:660)
at org.apache.cocoon.sitemap.Handler.process(Handler.java:222)
at org.apache.cocoon.sitemap.Manager.invoke(Manager.java:179)
at org.apache.cocoon.www.sitemap_xmap.matchN109E1(C:\Program Files\Apache Tomcat 4.0\work\localhost\cocoon\cocoon-files\org/apache/cocoon/www\sitemap_xmap.java:12247)
at org.apache.cocoon.www.sitemap_xmap.process(C:\Program Files\Apache Tomcat 4.0\work\localhost\cocoon\cocoon-files\org/apache/cocoon/www\sitemap_xmap.java:3870)
at org.apache.cocoon.www.sitemap_xmap.process(C:\Program Files\Apache Tomcat 4.0\work\localhost\cocoon\cocoon-files\org/apache/cocoon/www\sitemap_xmap.java:3127)
at org.apache.cocoon.sitemap.Handler.process(Handler.java:222)
at org.apache.cocoon.sitemap.Manager.invoke(Manager.java:179)
at org.apache.cocoon.sitemap.SitemapManager.process(SitemapManager.java:154)
at org.apache.cocoon.Cocoon.process(Cocoon.java:575)
at org.apache.cocoon.servlet.CocoonServlet.service(CocoonServlet.java:998)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:247)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:193)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:243)
at org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:566)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:472)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:201)
at org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:566)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:472)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943)
at org.apache.catalina.core.StandardContext.invoke(StandardContext.java:2344)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:164)
at org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:566)
at org.apache.catalina.valves.ErrorDispatcherValve.invoke(ErrorDispatcherValve.java:170)
at org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:564)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:170)
at org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:564)
at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:462)
at org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:564)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:472)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:163)
at org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:566)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:472)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943)
at org.apache.catalina.connector.http.HttpProcessor.process(HttpProcessor.java:1011)
at org.apache.catalina.connector.http.HttpProcessor.run(HttpProcessor.java:1106)
at java.lang.Thread.run(Unknown Source)
Beth Naquin
SAGEM MORPHO Inc.
1145 Broadway Plaza STE 200
Tacoma, WA 98402
253-597-8245