commons-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Karr, David" <david.k...@wamu.net>
Subject RE: Can Jelly SQL branch on table existence, or error conditions?
Date Fri, 21 Jul 2006 17:52:25 GMT
Where is an example of how to wrap a "sql:update" in a try/catch?  I
found some limited examples by grepping the core source tree (I can't
find the source for the SQL tag library anywhere), but I don't
understand them. 

> -----Original Message-----
> From: Paul Libbrecht [mailto:paul@activemath.org] 
> Sent: Friday, July 21, 2006 12:38 AM
> To: Jakarta Commons Users List
> Subject: Re: Can Jelly SQL branch on table existence, or 
> error conditions?
> 
> At worst the core's try/catch should help you, or ?
> Feel free to suggest added tags such as "tableAvailable" or 
> "dbMetadata" 
> or...
> paul
> 
> Karr, David wrote:
> > I'm guessing the primary commons-user answerers are in a very 
> > different time zone, so I guess I'm going to burst out a bunch of 
> > questions, instead of waiting for answers for each one.
> >
> > In my Jelly SQL script, I'm going to need to drop and 
> recreate a set 
> > of tables.  In order for this to work, it has to deal with any 
> > variation of those tables existing or not.  For instance, 
> if the table 
> > doesn't exist, dropping the table will fail in some way, so 
> I'll need 
> > to be able to ignore the error, perhaps.  If I did this 
> with plain sql 
> > tasks in Ant, it will just fail the Ant script if the drop 
> fails, and 
> > I don't see how to get back info into the Ant script indicating 
> > whether the table exists or not.
> >
> > Is this feasible in Jelly SQL?
> >
> >   
> 
> 

---------------------------------------------------------------------
To unsubscribe, e-mail: commons-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: commons-user-help@jakarta.apache.org


Mime
View raw message