Mailing-List: contact commons-user-help@jakarta.apache.org; run by ezmlm
Precedence: bulk
Reply-To: "Jakarta Commons Users List" <commons-user@jakarta.apache.org>
Received-SPF: pass (asf.osuosl.org: local policy)
Message-ID: <44C13E5D.3020906@activemath.org>
Date: Fri, 21 Jul 2006 22:51:41 +0200
From: Paul Libbrecht <paul@activemath.org>
Reply-To: paul@activemath.org
User-Agent: Thunderbird 1.5.0.4 (Macintosh/20060530)
MIME-Version: 1.0
To: Jakarta Commons Users List <commons-user@jakarta.apache.org>
Subject: Re: Can Jelly SQL branch on table existence, or error conditions?
References: <0C260F619E428642BFA6380177C3ADF303EE849B@exmsea005.us.wamu.net>
In-Reply-To: <0C260F619E428642BFA6380177C3ADF303EE849B@exmsea005.us.wamu.net>
Content-Type: multipart/signed; protocol="application/x-pkcs7-signature";
 micalg=sha1; boundary="------------ms080301020906020606010706"

--------------ms080301020906020606010706
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit

David,

you definitely need to see at least the unit test scripts.

All taglibs in jelly src distribution is under 
<jelly-home>/jelly-tags/<taglib-name> you can see the current version of 
the svn trunk at
    
http://svn.apache.org/viewvc/jakarta/commons/proper/jelly/trunk/jelly-tags/sql/
among others, I see a catch at:
  src/test//org/apache/commons/jelly/tags/sql/example3.jelly
Sorry for the wrong track.. there's no try just a catch...

As to the var attribute of the query tag... this is really just the 
result... it is of class org.apache.commons.jelly.tags.sql.ResultImpl I 
think. Better see the javadoc to see the things you can do on it.
Among others, if <query var="r"/> then ${r.rows} will give you an array 
of maps of length ${r.rowCount}. I'm commenting all this only by reading 
the source right now... so consider these as hints.

hope that helps.

paul

Karr, David wrote:
> 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
>
>   


--------------ms080301020906020606010706
Content-Type: application/x-pkcs7-signature; name="smime.p7s"
Content-Transfer-Encoding: base64
Content-Disposition: attachment; filename="smime.p7s"
Content-Description: S/MIME Cryptographic Signature

MIAGCSqGSIb3DQEHAqCAMIACAQExCzAJBgUrDgMCGgUAMIAGCSqGSIb3DQEHAQAAoIIJCzCC
AuAwggJJoAMCAQICEBANIdCEetTckq5axVFVAfswDQYJKoZIhvcNAQEEBQAwYjELMAkGA1UE
BhMCWkExJTAjBgNVBAoTHFRoYXd0ZSBDb25zdWx0aW5nIChQdHkpIEx0ZC4xLDAqBgNVBAMT
I1RoYXd0ZSBQZXJzb25hbCBGcmVlbWFpbCBJc3N1aW5nIENBMB4XDTA2MDExMDAwMDExN1oX
DTA3MDExMDAwMDExN1owRTEfMB0GA1UEAxMWVGhhd3RlIEZyZWVtYWlsIE1lbWJlcjEiMCAG
CSqGSIb3DQEJARYTcGF1bEBhY3RpdmVtYXRoLm9yZzCCASIwDQYJKoZIhvcNAQEBBQADggEP
ADCCAQoCggEBAL9dkkc63E+UArn899mOJLPBA0rBlP7I2XMBKO4VGFvJ29KrujSUoBraY/jS
Wxi62pg7Yy2sycDkyLW2GT41f9QES1Llhg0mkDbbkFKdJIqT0H04kTfCvaPjC/bX1eXTdKgW
BBzSkBBP0I2nAdkjmb8AmsvhG7h3pjpiZc+oZ5BNkY3gdO4EimrOkyaBNpeP2tzFaieFzJE9
g0qiG4/qd9cmBR5wK28tXQNZeS/XwsUQNjQjeoyrZMCfDT/gomYWH9UAcCyyhHNO7GwVeCga
Zg5ngvfDZZ+Tdqn9ixhtoAyZxacNLFCqVDlg2sy6wb+ZgGUXtPJ1SVPMk9EixYSNqn0CAwEA
AaMwMC4wHgYDVR0RBBcwFYETcGF1bEBhY3RpdmVtYXRoLm9yZzAMBgNVHRMBAf8EAjAAMA0G
CSqGSIb3DQEBBAUAA4GBACN5VjbmGWGwpf2SCWYqj+UEpleTGIDKHNPM6U1wd8jb8MBddVqO
MVjie5q0QCyoR5+ZU60zhEn7dxPyZV4owST7NVLdGIQj/JEqhsUQxmajhG4SWvyccnH9sdoC
PIth0WO2QXa/YcY+06uUVZiTFVOOcmKQtqW/A5gPBPcBRADGMIIC4DCCAkmgAwIBAgIQEA0h
0IR61NySrlrFUVUB+zANBgkqhkiG9w0BAQQFADBiMQswCQYDVQQGEwJaQTElMCMGA1UEChMc
VGhhd3RlIENvbnN1bHRpbmcgKFB0eSkgTHRkLjEsMCoGA1UEAxMjVGhhd3RlIFBlcnNvbmFs
IEZyZWVtYWlsIElzc3VpbmcgQ0EwHhcNMDYwMTEwMDAwMTE3WhcNMDcwMTEwMDAwMTE3WjBF
MR8wHQYDVQQDExZUaGF3dGUgRnJlZW1haWwgTWVtYmVyMSIwIAYJKoZIhvcNAQkBFhNwYXVs
QGFjdGl2ZW1hdGgub3JnMIIBIjANBgkqhkiG9w0BAQEFAAOCAQ8AMIIBCgKCAQEAv12SRzrc
T5QCufz32Y4ks8EDSsGU/sjZcwEo7hUYW8nb0qu6NJSgGtpj+NJbGLramDtjLazJwOTItbYZ
PjV/1ARLUuWGDSaQNtuQUp0kipPQfTiRN8K9o+ML9tfV5dN0qBYEHNKQEE/QjacB2SOZvwCa
y+EbuHemOmJlz6hnkE2RjeB07gSKas6TJoE2l4/a3MVqJ4XMkT2DSqIbj+p31yYFHnArby1d
A1l5L9fCxRA2NCN6jKtkwJ8NP+CiZhYf1QBwLLKEc07sbBV4KBpmDmeC98Nln5N2qf2LGG2g
DJnFpw0sUKpUOWDazLrBv5mAZRe08nVJU8yT0SLFhI2qfQIDAQABozAwLjAeBgNVHREEFzAV
gRNwYXVsQGFjdGl2ZW1hdGgub3JnMAwGA1UdEwEB/wQCMAAwDQYJKoZIhvcNAQEEBQADgYEA
I3lWNuYZYbCl/ZIJZiqP5QSmV5MYgMoc08zpTXB3yNvwwF11Wo4xWOJ7mrRALKhHn5lTrTOE
Sft3E/JlXijBJPs1Ut0YhCP8kSqGxRDGZqOEbhJa/Jxycf2x2gI8i2HRY7ZBdr9hxj7Tq5RV
mJMVU45yYpC2pb8DmA8E9wFEAMYwggM/MIICqKADAgECAgENMA0GCSqGSIb3DQEBBQUAMIHR
MQswCQYDVQQGEwJaQTEVMBMGA1UECBMMV2VzdGVybiBDYXBlMRIwEAYDVQQHEwlDYXBlIFRv
d24xGjAYBgNVBAoTEVRoYXd0ZSBDb25zdWx0aW5nMSgwJgYDVQQLEx9DZXJ0aWZpY2F0aW9u
IFNlcnZpY2VzIERpdmlzaW9uMSQwIgYDVQQDExtUaGF3dGUgUGVyc29uYWwgRnJlZW1haWwg
Q0ExKzApBgkqhkiG9w0BCQEWHHBlcnNvbmFsLWZyZWVtYWlsQHRoYXd0ZS5jb20wHhcNMDMw
NzE3MDAwMDAwWhcNMTMwNzE2MjM1OTU5WjBiMQswCQYDVQQGEwJaQTElMCMGA1UEChMcVGhh
d3RlIENvbnN1bHRpbmcgKFB0eSkgTHRkLjEsMCoGA1UEAxMjVGhhd3RlIFBlcnNvbmFsIEZy
ZWVtYWlsIElzc3VpbmcgQ0EwgZ8wDQYJKoZIhvcNAQEBBQADgY0AMIGJAoGBAMSmPFVzVftO
ucqZWh5owHUEcJ3f6f+jHuy9zfVb8hp2vX8MOmHyv1HOAdTlUAow1wJjWiyJFXCO3cnwK4Va
qj9xVsuvPAsH5/EfkTYkKhPPK9Xzgnc9A74r/rsYPge/QIACZNenprufZdHFKlSFD0gEf6e2
0TxhBEAeZBlyYLf7AgMBAAGjgZQwgZEwEgYDVR0TAQH/BAgwBgEB/wIBADBDBgNVHR8EPDA6
MDigNqA0hjJodHRwOi8vY3JsLnRoYXd0ZS5jb20vVGhhd3RlUGVyc29uYWxGcmVlbWFpbENB
LmNybDALBgNVHQ8EBAMCAQYwKQYDVR0RBCIwIKQeMBwxGjAYBgNVBAMTEVByaXZhdGVMYWJl
bDItMTM4MA0GCSqGSIb3DQEBBQUAA4GBAEiM0VCD6gsuzA2jZqxnD3+vrL7CF6FDlpSdf0wh
uPg2H6otnzYvwPQcUCCTcDz9reFhYsPZOhl+hLGZGwDFGguCdJ4lUJRix9sncVcljd2pnDmO
jCBPZV+V2vf3h9bGCE6u9uo05RAaWzVNd+NWIXiC3CEZNd4ksdMdRv9dX2VPMYIDZDCCA2AC
AQEwdjBiMQswCQYDVQQGEwJaQTElMCMGA1UEChMcVGhhd3RlIENvbnN1bHRpbmcgKFB0eSkg
THRkLjEsMCoGA1UEAxMjVGhhd3RlIFBlcnNvbmFsIEZyZWVtYWlsIElzc3VpbmcgQ0ECEBAN
IdCEetTckq5axVFVAfswCQYFKw4DAhoFAKCCAcMwGAYJKoZIhvcNAQkDMQsGCSqGSIb3DQEH
ATAcBgkqhkiG9w0BCQUxDxcNMDYwNzIxMjA1MTQxWjAjBgkqhkiG9w0BCQQxFgQU3ZlzjCXm
vWjbHXYGS5wt0xTYGSwwUgYJKoZIhvcNAQkPMUUwQzAKBggqhkiG9w0DBzAOBggqhkiG9w0D
AgICAIAwDQYIKoZIhvcNAwICAUAwBwYFKw4DAgcwDQYIKoZIhvcNAwICASgwgYUGCSsGAQQB
gjcQBDF4MHYwYjELMAkGA1UEBhMCWkExJTAjBgNVBAoTHFRoYXd0ZSBDb25zdWx0aW5nIChQ
dHkpIEx0ZC4xLDAqBgNVBAMTI1RoYXd0ZSBQZXJzb25hbCBGcmVlbWFpbCBJc3N1aW5nIENB
AhAQDSHQhHrU3JKuWsVRVQH7MIGHBgsqhkiG9w0BCRACCzF4oHYwYjELMAkGA1UEBhMCWkEx
JTAjBgNVBAoTHFRoYXd0ZSBDb25zdWx0aW5nIChQdHkpIEx0ZC4xLDAqBgNVBAMTI1RoYXd0
ZSBQZXJzb25hbCBGcmVlbWFpbCBJc3N1aW5nIENBAhAQDSHQhHrU3JKuWsVRVQH7MA0GCSqG
SIb3DQEBAQUABIIBAEXwiIIoGvqffhI9DkGtjwZz1VCliWlCWZS1pSiwZvqJgAeQU8JtSWoy
kcYcdmzxRM/B7ykuoSt1qSh2iQ5/3IxfiVCoCUKgaYrjTyH8ILa0ZKA+m6D8W7qGW0XaD64w
PFJeKUaO0+oAqaVMWwdUftgjkMf3wfh5l6XXwWPbiHnFtrDtzdE/SCg/6GKnUB4PsnkP3DIQ
64gZMPHazz2VNqu5jDS5zOclopW15/Jg/kKnYZ7W6gJz3bvokrNhdkUic7wX5pqgo2VRakjl
DqRAZNnAiNnsPX48vJ9GgXtc7q0qJB+IWx5ALuK6OReWWzl3gRhQiuRXOzoX1JoMx//cDxQA
AAAAAAA=
--------------ms080301020906020606010706--