Yes.
Bill Burke wrote:
> Which is why I wanted the NOWAIT flag in type-mappings so that when the bean
> deployed an exception would be thrown if nowait was turned on. Agree?
>
> Bill
>
>
>>-----Original Message-----
>>From: [EMAIL PROTECTED]
>>[mailto:[EMAIL PROTECTED]]On Behalf Of Dave
>>Smith
>>Sent: Friday, August 10, 2001 12:11 PM
>>To: [EMAIL PROTECTED]
>>Subject: Re: [JBoss-dev] NOWAIT option
>>
>>
>>PosgreSQL does not support the NOWAIT option. It is not in the SQL92 spec.
>>
>>Bill Burke wrote:
>>
>>>How do you know if appending NOWAIT to the select statement is correct
>>>syntax for all DBMS? What's wrong with my old suggestion?
>>>
>>Have templates
>>
>>>for specific DB queries like select-for-update.
>>>
>>>>From my old post:
>>>
>>>What do you think of these ideas? What I wanted to do was extend the
>>>database typemappings in standardjaws.xml.
>>>
>>> <type-mappings>
>>> <type-mapping-definition>
>>> <name>Oracle8</name>
>>>
>>><select-for-update-supported>true</select-for-update-supported>
>>> <select-for-update-format>![CDATA[SELECT %i
>>>
>>FROM %t WHERE %w
>>
>>>FOR
>>>UPDATE]]</select-for-update-format>
>>><select-for-update-no-wait-supported>true</select-for-update-supported>
>>>
>><select-for-update-no-wait-format>![CDATA[SELECT %i FROM %t
>>
>>>WHERE %w
>>>FOR
>>>UPDATE NOWAIT ]]</select-for-update-format>
>>>
>><mapping>
>>
>>> <java-type>java.lang.Boolean</java-type>
>>> <jdbc-type>BIT</jdbc-type>
>>> <sql-type>SMALLINT</sql-type>
>>> </mapping>
>>>
>>>where "%i" is the items to be select, "%t" is the tablename,
>>>
>>and "%w" is the
>>
>>>where clause. If a bean turns on select-for-update and it is
>>>
>>not supported
>>
>>>by the type-mapping, then an exception should be thrown on deployment.
>>>Maybe your rowid thingy should be put in there as well in the
>>>
>>same manner.
>>
>>>And then in jaws.xml
>>>
>>><select-for-update wait="true">true</select-for-update>
>>>
>>>>-----Original Message-----
>>>>From: [EMAIL PROTECTED]
>>>>[mailto:[EMAIL PROTECTED]]On Behalf Of Vinay
>>>>Menon
>>>>Sent: Friday, August 10, 2001 4:18 AM
>>>>To: JBossDev
>>>>Subject: [JBoss-dev] NOWAIT option
>>>>
>>>>
>>>>Hello,
>>>> Had made a little change to JawsEntityMetaData and the
>>>>JDBCLoad thingey
>>>>to support the NOWAIT, select for update option. Worthwhile if
>>>>
>>I post the
>>
>>>>change here? The idea is simple
>>>>
>>>>1. Have a field in jaws.xml called <wait-option>
>>>>2. Don't specify it if you don't need anything special. If you want a no
>>>>wait option specify it as <wait-option>NOWAIT<wait-option> or any other
>>>>option that is dbms specific
>>>>3. In the LoadEntityCommand append this text to the select for
>>>>update sql if
>>>><select-for-update> has been specified to be true.
>>>>
>>>>
>>>>Vinay
>>>>
>>>>
>>>>_______________________________________________
>>>>Jboss-development mailing list
>>>>[EMAIL PROTECTED]
>>>>http://lists.sourceforge.net/lists/listinfo/jboss-development
>>>>
>>>>
>>>>
>>>>
>>>
>>>
>>>_______________________________________________
>>>Jboss-development mailing list
>>>[EMAIL PROTECTED]
>>>http://lists.sourceforge.net/lists/listinfo/jboss-development
>>>
>>>
>>>
>>
>>
>>_______________________________________________
>>Jboss-development mailing list
>>[EMAIL PROTECTED]
>>http://lists.sourceforge.net/lists/listinfo/jboss-development
>>
>>
>
>
>
> _______________________________________________
> Jboss-development mailing list
> [EMAIL PROTECTED]
> http://lists.sourceforge.net/lists/listinfo/jboss-development
>
>
_______________________________________________
Jboss-development mailing list
[EMAIL PROTECTED]
http://lists.sourceforge.net/lists/listinfo/jboss-development
