[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-optionNOWAITwait-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
RE: [JBoss-dev] NOWAIT option
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 nameOracle8/name select-for-update-supportedtrue/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-supportedtrue/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-typejava.lang.Boolean/java-type jdbc-typeBIT/jdbc-type sql-typeSMALLINT/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=truetrue/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-optionNOWAITwait-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
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 nameOracle8/name select-for-update-supportedtrue/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-supportedtrue/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-typejava.lang.Boolean/java-type jdbc-typeBIT/jdbc-type sql-typeSMALLINT/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=truetrue/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-optionNOWAITwait-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
RE: [JBoss-dev] NOWAIT option
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 nameOracle8/name select-for-update-supportedtrue/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-supportedtrue/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-typejava.lang.Boolean/java-type jdbc-typeBIT/jdbc-type sql-typeSMALLINT/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=truetrue/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-optionNOWAITwait-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
Re: [JBoss-dev] NOWAIT option
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 nameOracle8/name select-for-update-supportedtrue/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-supportedtrue/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-typejava.lang.Boolean/java-type jdbc-typeBIT/jdbc-type sql-typeSMALLINT/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=truetrue/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-optionNOWAITwait-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