subject:"\[JBoss\-dev\] SQL function mapping"

Re: [JBoss-dev] SQL function mapping

2001-08-22 Thread Dain Sundstrom

Thanks, will commit change as soon as sourcefouge cvs is back on line.

-dain
- Original Message -
From: Marco Ladermann [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Tuesday, August 21, 2001 3:33 AM
Subject: Re: [JBoss-dev] SQL function mapping

 On Monday, 20. August 2001 19:20, Dain Sundstrom wrote:
  Thanks, checked it in.

  -dain

 snip

   It is simply two functions

   position(?2 in substring(?1 from ?3))+?3

 Sorry for complaining so late, but it is not as simple as this.

 position( 'findme' , 'wheretolookfor', 3) should be 0 and not 3  or am I
 wrong?

 Therefore use this for PostgreSQL:

 coalesce( nullif( position( ?1 in substring( ?1 from ?3 ) ), ?3 ) + ?3,
0 )

 Marco

 ___
 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] SQL function mapping

2001-08-21 Thread Marco Ladermann


On Monday, 20. August 2001 19:20, Dain Sundstrom wrote:
 Thanks, checked it in.

 -dain


snip

  It is simply two functions
 
  position(?2 in substring(?1 from ?3))+?3
 

Sorry for complaining so late, but it is not as simple as this.

position( 'findme' , 'wheretolookfor', 3) should be 0 and not 3  or am I 
wrong?

Therefore use this for PostgreSQL:

coalesce( nullif( position( ?1 in substring( ?1 from ?3 ) ), ?3 ) + ?3, 0 )

Marco

___
Jboss-development mailing list
[EMAIL PROTECTED]
http://lists.sourceforge.net/lists/listinfo/jboss-development

Re: [JBoss-dev] SQL function mapping

2001-08-21 Thread Dave Smith


Nope your right. When I first wrote the function I did not have the + ?3 
at the end so it worked fine ...

Marco Ladermann wrote:
 On Monday, 20. August 2001 19:20, Dain Sundstrom wrote:
 
Thanks, checked it in.

-dain


 
 snip
 
It is simply two functions

position(?2 in substring(?1 from ?3))+?3


 
 Sorry for complaining so late, but it is not as simple as this.
 
 position( 'findme' , 'wheretolookfor', 3) should be 0 and not 3  or am I 
 wrong?
 
 Therefore use this for PostgreSQL:
 
 coalesce( nullif( position( ?1 in substring( ?1 from ?3 ) ), ?3 ) + ?3, 0 )
 
 Marco
 
 ___
 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] SQL function mapping

2001-08-20 Thread Dave Smith




Dain
 I added the function mapping code to the EJB-QL to SQL translation engine. I
 added mappings for MS SQLServer, Oracle, MySQL and PostgreSQL to the
 standard jboss cmp xmp file.
 
 Notes:
 - These mappings are completely based on info from the 'SQL in a Nutshell'
 book, so they may not work (I don't use any of these databases).
 - PostgreSQL doesn't have a three argument position function, so I didn't

It is simply two functions

position(?2 in substring(?1 from ?3))+?3



 map it.
 - Send me any corrections or change it your self.
 - If not mapping is provided the system defaults to {fn concat(param1,
 param2)} style functions.
 
 The mappings follow this message.
 
 -dain
 
 
 Oracle:
 function-mapping
 function-nameconcat/function-name
 function-sql(?1 || ?2)/function-sql
 /function-mapping
 function-mapping
 function-namesubstring/function-name
 function-sqlsubstr(?1, ?2, ?3)/function-sql
 /function-mapping
 function-mapping
 function-namelength/function-name
 function-sqllen(?1)/function-sql
 /function-mapping
 function-mapping
 function-namelocate/function-name
 function-sqlinstr(?1, ?2, ?3)/function-sql
 /function-mapping
 function-mapping
 function-nameabs/function-name
 function-sqlabs(?1)/function-sql
 /function-mapping
 function-mapping
 function-namesqrt/function-name
 function-sqlsqrt(?1)/function-sql
 /function-mapping
 
 
 MS SQLServer:
 function-mapping
 function-nameconcat/function-name
 function-sql(?1 + ?2)/function-sql
 /function-mapping
 function-mapping
 function-namesubstring/function-name
 function-sqlsubstring(?1 FROM ?2 FOR ?3)/function-sql
 /function-mapping
 function-mapping
 function-namelength/function-name
 function-sqllen(?1)/function-sql
 /function-mapping
 function-mapping
 function-namelocate/function-name
 function-sqlcharindex(?1, ?2, ?3)/function-sql
 /function-mapping
 function-mapping
 function-nameabs/function-name
 function-sqlabs(?1)/function-sql
 /function-mapping
 function-mapping
 function-namesqrt/function-name
 function-sqlsqrt(?1)/function-sql
 /function-mapping
 
 MySQL:
 function-mapping
 function-nameconcat/function-name
 function-sqlconcat(?1, ?2)/function-sql
 /function-mapping
 function-mapping
 function-namesubstring/function-name
 function-sqlsubstring(?1 FROM ?2 FOR ?3)/function-sql
 /function-mapping
 function-mapping
 function-namelength/function-name
 function-sqllength(?1)/function-sql
 /function-mapping
 function-mapping
 function-namelocate/function-name
 function-sqllocate(?1, ?2, ?3)/function-sql
 /function-mapping
 function-mapping
 function-nameabs/function-name
 function-sqlabs(?1)/function-sql
 /function-mapping
 function-mapping
 function-namesqrt/function-name
 function-sqlsqrt(?1)/function-sql
 /function-mapping
 
 PostgreSQL:
 function-mapping
 function-nameconcat/function-name
 function-sql(?1 || ?2)/function-sql
 /function-mapping
 function-mapping
 function-namesubstring/function-name
 function-sqlsubstring(?1 FROM ?2 FOR ?3)/function-sql
 /function-mapping
 function-mapping
 function-namelength/function-name
 function-sqllength(?1)/function-sql
 /function-mapping
 function-mapping
 function-nameabs/function-name
 function-sqlabs(?1)/function-sql
 /function-mapping
 function-mapping
 function-namesqrt/function-name
 function-sqlsqrt(?1)/function-sql
 /function-mapping
 
 
 
 ___
 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] SQL function mapping

2001-08-20 Thread Bill Burke


Dain,

Can we expand this to CMP 1.x and for select-for-update?

Thanks,

Bill

 -Original Message-
 From: [EMAIL PROTECTED]
 [mailto:[EMAIL PROTECTED]]On Behalf Of Dave
 Smith
 Sent: Monday, August 20, 2001 7:49 AM
 To: [EMAIL PROTECTED]
 Subject: Re: [JBoss-dev] SQL function mapping
 
 
 
 
 Dain
  I added the function mapping code to the EJB-QL to SQL 
 translation engine. I
  added mappings for MS SQLServer, Oracle, MySQL and PostgreSQL to the
  standard jboss cmp xmp file.
  
  Notes:
  - These mappings are completely based on info from the 'SQL in 
 a Nutshell'
  book, so they may not work (I don't use any of these databases).
  - PostgreSQL doesn't have a three argument position function, 
 so I didn't
 
 It is simply two functions
 
 position(?2 in substring(?1 from ?3))+?3
   
 
 
  map it.
  - Send me any corrections or change it your self.
  - If not mapping is provided the system defaults to {fn concat(param1,
  param2)} style functions.
  
  The mappings follow this message.
  
  -dain
  
  
  Oracle:
  function-mapping
  function-nameconcat/function-name
  function-sql(?1 || ?2)/function-sql
  /function-mapping
  function-mapping
  function-namesubstring/function-name
  function-sqlsubstr(?1, ?2, ?3)/function-sql
  /function-mapping
  function-mapping
  function-namelength/function-name
  function-sqllen(?1)/function-sql
  /function-mapping
  function-mapping
  function-namelocate/function-name
  function-sqlinstr(?1, ?2, ?3)/function-sql
  /function-mapping
  function-mapping
  function-nameabs/function-name
  function-sqlabs(?1)/function-sql
  /function-mapping
  function-mapping
  function-namesqrt/function-name
  function-sqlsqrt(?1)/function-sql
  /function-mapping
  
  
  MS SQLServer:
  function-mapping
  function-nameconcat/function-name
  function-sql(?1 + ?2)/function-sql
  /function-mapping
  function-mapping
  function-namesubstring/function-name
  function-sqlsubstring(?1 FROM ?2 FOR ?3)/function-sql
  /function-mapping
  function-mapping
  function-namelength/function-name
  function-sqllen(?1)/function-sql
  /function-mapping
  function-mapping
  function-namelocate/function-name
  function-sqlcharindex(?1, ?2, ?3)/function-sql
  /function-mapping
  function-mapping
  function-nameabs/function-name
  function-sqlabs(?1)/function-sql
  /function-mapping
  function-mapping
  function-namesqrt/function-name
  function-sqlsqrt(?1)/function-sql
  /function-mapping
  
  MySQL:
  function-mapping
  function-nameconcat/function-name
  function-sqlconcat(?1, ?2)/function-sql
  /function-mapping
  function-mapping
  function-namesubstring/function-name
  function-sqlsubstring(?1 FROM ?2 FOR ?3)/function-sql
  /function-mapping
  function-mapping
  function-namelength/function-name
  function-sqllength(?1)/function-sql
  /function-mapping
  function-mapping
  function-namelocate/function-name
  function-sqllocate(?1, ?2, ?3)/function-sql
  /function-mapping
  function-mapping
  function-nameabs/function-name
  function-sqlabs(?1)/function-sql
  /function-mapping
  function-mapping
  function-namesqrt/function-name
  function-sqlsqrt(?1)/function-sql
  /function-mapping
  
  PostgreSQL:
  function-mapping
  function-nameconcat/function-name
  function-sql(?1 || ?2)/function-sql
  /function-mapping
  function-mapping
  function-namesubstring/function-name
  function-sqlsubstring(?1 FROM ?2 FOR ?3)/function-sql
  /function-mapping
  function-mapping
  function-namelength/function-name
  function-sqllength(?1)/function-sql
  /function-mapping
  function-mapping
  function-nameabs/function-name
  function-sqlabs(?1)/function-sql
  /function-mapping
  function-mapping
  function-namesqrt/function-name
  function-sqlsqrt(?1)/function-sql
  /function-mapping
  
  
  
  ___
  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] SQL function mapping

2001-08-20 Thread Dain Sundstrom


Bill,

I think so.

I think all of these issues with datasource specific configuration are all
related.  I think we need to change the type-mapping section of the xml file
to something like datasource-config (best name I can think of), with
subsections for function mapping, type mappings, join style (maybe), and
general information like select-for-update support and syntax.

Any ideas on the layout of this xml?

We also have the option of doing the conversion in the connector layer and
always using the {...} sql extension format.

-dain


- Original Message -
From: Bill Burke [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Monday, August 20, 2001 9:12 AM
Subject: RE: [JBoss-dev] SQL function mapping


 Dain,

 Can we expand this to CMP 1.x and for select-for-update?

 Thanks,

 Bill

  -Original Message-
  From: [EMAIL PROTECTED]
  [mailto:[EMAIL PROTECTED]]On Behalf Of Dave
  Smith
  Sent: Monday, August 20, 2001 7:49 AM
  To: [EMAIL PROTECTED]
  Subject: Re: [JBoss-dev] SQL function mapping
 
 
 
 
  Dain
   I added the function mapping code to the EJB-QL to SQL
  translation engine. I
   added mappings for MS SQLServer, Oracle, MySQL and PostgreSQL to the
   standard jboss cmp xmp file.
  
   Notes:
   - These mappings are completely based on info from the 'SQL in
  a Nutshell'
   book, so they may not work (I don't use any of these databases).
   - PostgreSQL doesn't have a three argument position function,
  so I didn't
 
  It is simply two functions
 
  position(?2 in substring(?1 from ?3))+?3
 
 
 
   map it.
   - Send me any corrections or change it your self.
   - If not mapping is provided the system defaults to {fn concat(param1,
   param2)} style functions.
  
   The mappings follow this message.
  
   -dain
  
  
   Oracle:
   function-mapping
   function-nameconcat/function-name
   function-sql(?1 || ?2)/function-sql
   /function-mapping
   function-mapping
   function-namesubstring/function-name
   function-sqlsubstr(?1, ?2, ?3)/function-sql
   /function-mapping
   function-mapping
   function-namelength/function-name
   function-sqllen(?1)/function-sql
   /function-mapping
   function-mapping
   function-namelocate/function-name
   function-sqlinstr(?1, ?2, ?3)/function-sql
   /function-mapping
   function-mapping
   function-nameabs/function-name
   function-sqlabs(?1)/function-sql
   /function-mapping
   function-mapping
   function-namesqrt/function-name
   function-sqlsqrt(?1)/function-sql
   /function-mapping
  
  
   MS SQLServer:
   function-mapping
   function-nameconcat/function-name
   function-sql(?1 + ?2)/function-sql
   /function-mapping
   function-mapping
   function-namesubstring/function-name
   function-sqlsubstring(?1 FROM ?2 FOR ?3)/function-sql
   /function-mapping
   function-mapping
   function-namelength/function-name
   function-sqllen(?1)/function-sql
   /function-mapping
   function-mapping
   function-namelocate/function-name
   function-sqlcharindex(?1, ?2, ?3)/function-sql
   /function-mapping
   function-mapping
   function-nameabs/function-name
   function-sqlabs(?1)/function-sql
   /function-mapping
   function-mapping
   function-namesqrt/function-name
   function-sqlsqrt(?1)/function-sql
   /function-mapping
  
   MySQL:
   function-mapping
   function-nameconcat/function-name
   function-sqlconcat(?1, ?2)/function-sql
   /function-mapping
   function-mapping
   function-namesubstring/function-name
   function-sqlsubstring(?1 FROM ?2 FOR ?3)/function-sql
   /function-mapping
   function-mapping
   function-namelength/function-name
   function-sqllength(?1)/function-sql
   /function-mapping
   function-mapping
   function-namelocate/function-name
   function-sqllocate(?1, ?2, ?3)/function-sql
   /function-mapping
   function-mapping
   function-nameabs/function-name
   function-sqlabs(?1)/function-sql
   /function-mapping
   function-mapping
   function-namesqrt/function-name
   function-sqlsqrt(?1)/function-sql
   /function-mapping
  
   PostgreSQL:
   function-mapping
   function-nameconcat/function-name
   function-sql(?1 || ?2)/function-sql
   /function-mapping
   function-mapping
   function-namesubstring/function-name
   function-sqlsubstring(?1 FROM ?2 FOR ?3)/function-sql
   /function-mapping
   function-mapping
   function-namelength/function-name
   function-sqllength(?1)/function-sql
   /function-mapping
   function-mapping
   function-nameabs/function-name
   function-sqlabs(?1)/function-sql
   /function-mapping
   function-mapping
   function-namesqrt/function-name
   function-sqlsqrt(?1)/function-sql
   /function-mapping
  
  
  
   ___
   Jboss-development mailing list
   [EMAIL PROTECTED]
   http://lists.sourceforge.net/lists/listinfo/jboss-development

Re: [JBoss-dev] SQL function mapping

2001-08-20 Thread Dain Sundstrom


Thanks, checked it in.

-dain

- Original Message -
From: Dave Smith [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Monday, August 20, 2001 6:49 AM
Subject: Re: [JBoss-dev] SQL function mapping




 Dain
  I added the function mapping code to the EJB-QL to SQL translation
engine. I
  added mappings for MS SQLServer, Oracle, MySQL and PostgreSQL to the
  standard jboss cmp xmp file.
 
  Notes:
  - These mappings are completely based on info from the 'SQL in a
Nutshell'
  book, so they may not work (I don't use any of these databases).
  - PostgreSQL doesn't have a three argument position function, so I
didn't

 It is simply two functions

 position(?2 in substring(?1 from ?3))+?3



  map it.
  - Send me any corrections or change it your self.
  - If not mapping is provided the system defaults to {fn concat(param1,
  param2)} style functions.
 
  The mappings follow this message.
 
  -dain
 
 
  Oracle:
  function-mapping
  function-nameconcat/function-name
  function-sql(?1 || ?2)/function-sql
  /function-mapping
  function-mapping
  function-namesubstring/function-name
  function-sqlsubstr(?1, ?2, ?3)/function-sql
  /function-mapping
  function-mapping
  function-namelength/function-name
  function-sqllen(?1)/function-sql
  /function-mapping
  function-mapping
  function-namelocate/function-name
  function-sqlinstr(?1, ?2, ?3)/function-sql
  /function-mapping
  function-mapping
  function-nameabs/function-name
  function-sqlabs(?1)/function-sql
  /function-mapping
  function-mapping
  function-namesqrt/function-name
  function-sqlsqrt(?1)/function-sql
  /function-mapping
 
 
  MS SQLServer:
  function-mapping
  function-nameconcat/function-name
  function-sql(?1 + ?2)/function-sql
  /function-mapping
  function-mapping
  function-namesubstring/function-name
  function-sqlsubstring(?1 FROM ?2 FOR ?3)/function-sql
  /function-mapping
  function-mapping
  function-namelength/function-name
  function-sqllen(?1)/function-sql
  /function-mapping
  function-mapping
  function-namelocate/function-name
  function-sqlcharindex(?1, ?2, ?3)/function-sql
  /function-mapping
  function-mapping
  function-nameabs/function-name
  function-sqlabs(?1)/function-sql
  /function-mapping
  function-mapping
  function-namesqrt/function-name
  function-sqlsqrt(?1)/function-sql
  /function-mapping
 
  MySQL:
  function-mapping
  function-nameconcat/function-name
  function-sqlconcat(?1, ?2)/function-sql
  /function-mapping
  function-mapping
  function-namesubstring/function-name
  function-sqlsubstring(?1 FROM ?2 FOR ?3)/function-sql
  /function-mapping
  function-mapping
  function-namelength/function-name
  function-sqllength(?1)/function-sql
  /function-mapping
  function-mapping
  function-namelocate/function-name
  function-sqllocate(?1, ?2, ?3)/function-sql
  /function-mapping
  function-mapping
  function-nameabs/function-name
  function-sqlabs(?1)/function-sql
  /function-mapping
  function-mapping
  function-namesqrt/function-name
  function-sqlsqrt(?1)/function-sql
  /function-mapping
 
  PostgreSQL:
  function-mapping
  function-nameconcat/function-name
  function-sql(?1 || ?2)/function-sql
  /function-mapping
  function-mapping
  function-namesubstring/function-name
  function-sqlsubstring(?1 FROM ?2 FOR ?3)/function-sql
  /function-mapping
  function-mapping
  function-namelength/function-name
  function-sqllength(?1)/function-sql
  /function-mapping
  function-mapping
  function-nameabs/function-name
  function-sqlabs(?1)/function-sql
  /function-mapping
  function-mapping
  function-namesqrt/function-name
  function-sqlsqrt(?1)/function-sql
  /function-mapping
 
 
 
  ___
  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-dev] SQL function mapping

2001-08-19 Thread Dain Sundstrom


I added the function mapping code to the EJB-QL to SQL translation engine. I
added mappings for MS SQLServer, Oracle, MySQL and PostgreSQL to the
standard jboss cmp xmp file.

Notes:
- These mappings are completely based on info from the 'SQL in a Nutshell'
book, so they may not work (I don't use any of these databases).
- PostgreSQL doesn't have a three argument position function, so I didn't
map it.
- Send me any corrections or change it your self.
- If not mapping is provided the system defaults to {fn concat(param1,
param2)} style functions.

The mappings follow this message.

-dain


Oracle:
function-mapping
function-nameconcat/function-name
function-sql(?1 || ?2)/function-sql
/function-mapping
function-mapping
function-namesubstring/function-name
function-sqlsubstr(?1, ?2, ?3)/function-sql
/function-mapping
function-mapping
function-namelength/function-name
function-sqllen(?1)/function-sql
/function-mapping
function-mapping
function-namelocate/function-name
function-sqlinstr(?1, ?2, ?3)/function-sql
/function-mapping
function-mapping
function-nameabs/function-name
function-sqlabs(?1)/function-sql
/function-mapping
function-mapping
function-namesqrt/function-name
function-sqlsqrt(?1)/function-sql
/function-mapping


MS SQLServer:
function-mapping
function-nameconcat/function-name
function-sql(?1 + ?2)/function-sql
/function-mapping
function-mapping
function-namesubstring/function-name
function-sqlsubstring(?1 FROM ?2 FOR ?3)/function-sql
/function-mapping
function-mapping
function-namelength/function-name
function-sqllen(?1)/function-sql
/function-mapping
function-mapping
function-namelocate/function-name
function-sqlcharindex(?1, ?2, ?3)/function-sql
/function-mapping
function-mapping
function-nameabs/function-name
function-sqlabs(?1)/function-sql
/function-mapping
function-mapping
function-namesqrt/function-name
function-sqlsqrt(?1)/function-sql
/function-mapping

MySQL:
function-mapping
function-nameconcat/function-name
function-sqlconcat(?1, ?2)/function-sql
/function-mapping
function-mapping
function-namesubstring/function-name
function-sqlsubstring(?1 FROM ?2 FOR ?3)/function-sql
/function-mapping
function-mapping
function-namelength/function-name
function-sqllength(?1)/function-sql
/function-mapping
function-mapping
function-namelocate/function-name
function-sqllocate(?1, ?2, ?3)/function-sql
/function-mapping
function-mapping
function-nameabs/function-name
function-sqlabs(?1)/function-sql
/function-mapping
function-mapping
function-namesqrt/function-name
function-sqlsqrt(?1)/function-sql
/function-mapping

PostgreSQL:
function-mapping
function-nameconcat/function-name
function-sql(?1 || ?2)/function-sql
/function-mapping
function-mapping
function-namesubstring/function-name
function-sqlsubstring(?1 FROM ?2 FOR ?3)/function-sql
/function-mapping
function-mapping
function-namelength/function-name
function-sqllength(?1)/function-sql
/function-mapping
function-mapping
function-nameabs/function-name
function-sqlabs(?1)/function-sql
/function-mapping
function-mapping
function-namesqrt/function-name
function-sqlsqrt(?1)/function-sql
/function-mapping



___
Jboss-development mailing list
[EMAIL PROTECTED]
http://lists.sourceforge.net/lists/listinfo/jboss-development

Re: [JBoss-dev] SQL function mapping

Re: [JBoss-dev] SQL function mapping

Re: [JBoss-dev] SQL function mapping

Re: [JBoss-dev] SQL function mapping

RE: [JBoss-dev] SQL function mapping

Re: [JBoss-dev] SQL function mapping

Re: [JBoss-dev] SQL function mapping

[JBoss-dev] SQL function mapping

8 matches

Site Navigation

Mail list logo

Footer information