Auto commit in Jakarta taglib?

[Roland Dong]

I have some programs which uses pre-jstl jakarta taglib.  I want to have the
query commit only if there is no errors. However, I could not find in tags
for setting autocommit.

Tried to add %conn.setAutoCommit(false);% but that doesn't work. So I am
wondering if there is a workaround other than rewriting everything using
other tag library(I know struts has it).

Thanks in advance.

RD


The is a code example I used to test auto commit.

=
%-- Taglib Directives --%
[EMAIL PROTECTED] uri=http://database.cait.org/dbtags; prefix=sql   %

-database connection--%
%@ include file=../includes/dbConnection.jsp%


sql:statement id=stmt conn=conn


  
  sql:query
 INSERT INTO school
 VALUES (
   '666',
   'rd',
   'street1',
   'city1',
   'county1',
   'state1',
   'zip1',
   'phone1'
  )
  /sql:query
  sql:execute /
   
sql:query
 INSERT INTO school1
 VALUES (
   '888',
   'rd',
   'street1',
   'city1',
   'county1',
   'state1',
   'zip1',
   'phone1'
  )
  /sql:query
  sql:execute /
   
 /sql:statement
  
  OK! 
 %-- Close database connection --%
sql:closeConnection conn=conn/
===
 


-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]

Re: Auto commit in Jakarta taglib?

[Shawn Bayern]

Ah - I just realized you were using DBTags, not JSTL.  If you're using a
JSP 1.2 container, you'll probably want to switch to JSTL anyway.

-- 
Shawn Bayern
JSTL in Action   http://www.manning.com/bayern

On Mon, 16 Jun 2003, Roland Dong wrote:

 
 
 I have some programs which uses pre-jstl jakarta taglib.  I want to have the
 query commit only if there is no errors. However, I could not find in tags
 for setting autocommit.
 
 Tried to add %conn.setAutoCommit(false);% but that doesn't work. So I am
 wondering if there is a workaround other than rewriting everything using
 other tag library(I know struts has it).
 
 Thanks in advance.
 
 RD
 
 
 The is a code example I used to test auto commit.
 
 =
 %-- Taglib Directives --%
 [EMAIL PROTECTED] uri=http://database.cait.org/dbtags; prefix=sql   %
 
 -database connection--%
 %@ include file=../includes/dbConnection.jsp%
 
 
 sql:statement id=stmt conn=conn
 
 
   
   sql:query
  INSERT INTO school
  VALUES (
'666',
'rd',
'street1',
'city1',
'county1',
'state1',
'zip1',
'phone1'
   )
   /sql:query
   sql:execute /

 sql:query
  INSERT INTO school1
  VALUES (
'888',
'rd',
'street1',
'city1',
'county1',
'state1',
'zip1',
'phone1'
   )
   /sql:query
   sql:execute /

  /sql:statement
   
   OK! 
  %-- Close database connection --%
 sql:closeConnection conn=conn/
 ===
  
 
 
 -
 To unsubscribe, e-mail: [EMAIL PROTECTED]
 For additional commands, e-mail: [EMAIL PROTECTED]
 


-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]

parseDate question

[James Norman]

I am trying to parse a String object into a date using the parseDate tag.  My code is 
as follows:

fmt:parseDate var=cellDate value=${cell.value} /
tdfmt:formatDate value=${cellDate} //td

And I get this exception:
 [ServletException in:/WEB-INF/jsp/displayers/requestsDisplayer.jsp] In parseDate, 
value attribute can not be parsed: 1055792945855' 

Where cell.value returns a String of 1055792945855.  Can this not be parsed into a 
date object?  Any help would be appreciated.

Thanks,
james