Mailing-List: contact cocoon-dev-help@xml.apache.org; run by ezmlm
Precedence: bulk
Reply-To: cocoon-dev@xml.apache.org
Date: 9 Jul 2002 15:58:50 -0000
Message-ID: <20020709155850.6730.qmail@nagoya.betaversion.org>
From: bugzilla@apache.org
To: cocoon-dev@xml.apache.org
Cc: 
Subject: DO NOT REPLY [Bug 10596] New:  -
    Database Tutorial generates SQL error when using Sybase Database

DO NOT REPLY TO THIS EMAIL, BUT PLEASE POST YOUR BUG 
RELATED COMMENTS THROUGH THE WEB INTERFACE AVAILABLE AT
<http://nagoya.apache.org/bugzilla/show_bug.cgi?id=10596>.
ANY REPLY MADE TO THIS MESSAGE WILL NOT BE COLLECTED AND 
INSERTED IN THE BUG DATABASE.

http://nagoya.apache.org/bugzilla/show_bug.cgi?id=10596

Database Tutorial generates SQL error when using Sybase Database

           Summary: Database Tutorial generates SQL error when using Sybase
                    Database
           Product: Cocoon 2
           Version: 2.0.3
          Platform: All
        OS/Version: All
            Status: NEW
          Severity: Normal
          Priority: Other
         Component: general components
        AssignedTo: cocoon-dev@xml.apache.org
        ReportedBy: bmitchel@niac.usra.edu
                CC: bmitchel@niac.usra.edu


System Parameters:
RedHat 7.2, Tomcat 4.02, Cocoon 2.0.3,Sun JDK 1.4.0, Sybase 11.9.2 database

While trying to use the database turorial, I found that when I tried to edit an
employee or a department I got the following error:
**********************************************************************************
org.apache.cocoon.ProcessingException: Exception in
ServerPagesGenerator.generate(): java.lang.RuntimeException: Error executing
statement: SELECT name, department_id FROM employee WHERE id = ? :
com.sybase.jdbc2.jdbc.SybSQLException: Implicit conversion from datatype 'CHAR'
to 'INT' is not allowed. Use the CONVERT function to run this query.
**********************************************************************************
This patch will change the necessary entries so it works properly:
**********************************************************************************
diff -Naur tutorial/docs/edit-dept.xsp tutorial/docs.sybase/edit-dept.xsp
--- tutorial/docs/edit-dept.xsp  Tue Jul  9 09:50:57 2002
+++ tutorial/docs.sybase/edit-dept.xsp Tue Jul  9 09:47:56 2002
@@ -24,7 +24,7 @@
             <esql:execute-query>
               <esql:query>
                 SELECT name FROM department
-                WHERE id = <esql:parameter><xsp-request:get-parameter
name="id"/></esql:parameter>
+               WHERE id = <esql:parameter
type="int"><xsp:expr>Integer.parseInt(<xsp-request:get-parameter name="id"
default="0"/>)</xsp:expr></esql:parameter>
               </esql:query>
               <esql:results>
                 <esql:row-results>
diff -Naur tutorial/docs/edit-empl.xsp tutorial/docs.sybase/edit-empl.xsp
--- tutorial/docs/edit-empl.xsp  Tue Jul  9 09:50:57 2002
+++ tutorial/docs.sybase/edit-empl.xsp Tue Jul  9 09:54:39 2002
@@ -23,7 +23,7 @@
           <esql:execute-query>
             <esql:query>
               SELECT name, department_id FROM employee 
-              WHERE id = <esql:parameter><xsp-request:get-parameter
name="id"/></esql:parameter>
+             WHERE id = <esql:parameter
type="int"><xsp:expr>Integer.parseInt(<xsp-request:get-parameter name="id"
default="0"/>)</xsp:expr></esql:parameter>
             </esql:query>               
             <esql:results>                               
               <esql:row-results>  
**********************************************************************************

---------------------------------------------------------------------
To unsubscribe, e-mail: cocoon-dev-unsubscribe@xml.apache.org
For additional commands, email: cocoon-dev-help@xml.apache.org