Mailing List
Home
Forum Home
Cocoon - MVC web framework based on XML/XSL
Maven - Project building tool
Axis - Java SOAP implementation
Lucene - Full-featured text search engine APIs
Log4J - A log library
Fop - Create PDF, PCL, PS, SVG, XML driven by XSL formatting objects.
POI - Java Excel, Word and other Microsoft Office files manipulating library
Oracle database, Microsoft SQL server ...
MySQL - an open source database
Red Hat Linux Installation and Config discussions ...
Subjects
log4j warning: No appenders could be found
java security AccessControlException: access denied (java io FilePermission clie
java lang InstantiationException: org apache tools ant Main
Apache Axis Tutorial
Struts <logic iterate >
log4j properties How to parse outpu to multiple files
configuring log4j with BEA Weblogic 8 1
How to use XSL FOP Java together
JSP precompile
Servlet File Download dialog problem (IE6,Adobe 6 0)
Proposal: Adding jar manifest classpath in jar and war plugins
Unsupported major minor version 48 0 problem while running the an
   telope task
java security AccessControlException: access denied (java io FilePermission
axis wsdl2java Ant Task usage
net sf hibernate MappingException: Error reading resource: test/User hbm xml
Building EAR ANT Script for websphere 5 0
CREATING WAR Files
jsp data into Excel
Classpath problem
Jboss 3 2 3+ vs Tomcat Axis Question
RE: How to include jars and add them into the MANIFEST MF/Class Path
attribute
Printing problem
InstantiationException
Couldn 't find trusted certificate
Please : How can one install ant 1 6 0 under Eclipse 2 1 ?
Excel: Too many different cell formats
Running junit tests fails
XDoclet, Struts and Maven: Where to start? SOLUTION
1 3 final: now giving me java io FileNotFoundException (Too many
open files)
AXIS: tomcat timeout ?
 
Search:  
Power your search with and, or, +, -, or "some phrase" operators.
problems with esql logicsheet and insert

problems with esql logicsheet and insert

2004-01-03       - By Davide

 Back
Reply:     1     2  

At 11:37 AM 03-01-04, you wrote:
>Hi; i have the following xsp to perform an insert into a table
>
><xsp:include>java.sql</xsp:include>
>         <xsp:logic>
>                 java.util.Date Source code of java.util.Date.html>java.util.Date Source code of java.util.Date java.util.Date Source code of java.util.Date.java.html>Source code of <a href=http://www.docjar.com/docs/api/java/util/Date.html>java.util.Date</a> <a href=http://www.docjar.com/html/api/java/util/Date.java.html><img src=/j.gif alt=' border=0> now=new java.util.Date Source code of java.util.Date.html>java.util.Date Source code of java.util.Date java.util.Date Source code of java.util.Date.java.html>Source code of <a href=http://www.docjar.com/docs/api/java/util/Date.html>java.util.Date</a> <a href=http://www.docjar.com/html/api/java/util/Date.java.html><img src=/j.gif alt=' border=0>();
>         </xsp:logic>
>         <esql:connection>
>                 <esql:pool>mcnavigator</esql:pool>
>                 <esql:execute-query>
>                         <esql:query>Insert into comments (Comment_ID,
> User_ID, Comment_text, Commented_URL, Comment_Date, Comment_browser) values (
>                                 '<xsp-session-fw:getxml
> context="authentication" path="/authentication/ID"/>',
>                                 '<xsp-request:get-parameter
> name="comment_text"/>',
>                                 '<xsp-request:get-parameter name="link"/>',
>                                 '<xsp:expr>new
> java.sql.Timestamp Source code of java.sql.Timestamp(now.getTime())</xsp:expr>',
>                                 '<xsp-request:get-header
> name="user-agent"/>');
>                         </esql:query>
>                 </esql:execute-query>
>         </esql:connection>
>
>When i execute it, i get a Unhandled exception type SQLException, but if I
>simply copy the query into mysql it runs;
>Is there something wrong?
>
>Best Regards, Davide
>
>
>-- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ------
>To unsubscribe, e-mail: users-unsubscribe@(protected)
>For additional commands, e-mail: users-help@(protected)


this is the detailed error:

org.apache.cocoon.ProcessingException Source code of org.apache.cocoon.ProcessingException: Language Exception:
org.apache.cocoon.components.language.LanguageException Source code of org.apache.cocoon.components.language.LanguageException: Error compiling
add_to_db_xsp: ERROR 1
(org\apache\cocoon\www\mcnavigator\xsp\add_to_db_xsp.java): ... if
(_esql_query != null) { _esql_queries.push(_esql_query); } // start error
(lines 328-328) "Unhandled exception type SQLException" _esql_query =
_esql_connection.createQuery( // end error String.valueOf(""),
String.valueOf( "" ... Line 328, column 0: Unhandled exception type
SQLException




-- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ------
To unsubscribe, e-mail: users-unsubscribe@(protected)
For additional commands, e-mail: users-help@(protected)