Re: [Resin-interest] support spatial queries in amber

2009-12-17 Thread Riccardo Cohen 
Thanks Jeff  Scott

Of course Resin quality stability and performance are the priority also 
for me. And for the moment I use simple sql queries instead of Amber.

Amber comes with Resin as many other features like hessian, comet etc. - 
all in one. That also makes Resin very attractive and as spatial 
queries becomes more and more popular (and really useful), it makes 
sense that Amber could handle spatial queries.
That's a wish at least.
Thanks.

Jeff Schnitzer wrote:
 It's worth mentioning that Hibernate works great as a JPA provider for
 Resin.  I haven't tried it, but there's this:
 
 http://www.hibernatespatial.org/
 
 Jeff
 
 On Wed, Dec 16, 2009 at 9:25 AM, Scott Ferguson f...@caucho.com wrote:
 Riccardo Cohen wrote:
 I really would like to know what is the Caucho point of view about this...

 At the moment, Amber development is being put on hold (except critical
 bugs), until we finish the web profile, because our main strategy is to
 focus on the core quality for both Resin and Quercus.

 So we would not be looking at adding spatial support for another 6
 months at minimum, and even then we may decide Amber is still a lower
 priority than core Resin quality.

 -- Scott
 Thanks

 Riccardo Cohen wrote:

 Hello
 I use mysql with spatial index and would like to use amber queries with
 spatial field
 I tried these sort of queries :

 select p from Prop p where
 Spatial.within(p.pos,Spatial.mPointFromText('MULTIPOINT(238500
 6229301,238500 6260453,283700 6260453,283700 6229301)',0))

 But the java program stops (with no exception) when I call createQuery()...

 I found nothing in amber doc, but I've read here :

 http://www.jpox.org/docs/1_2/spatial.html

 that there could be spatial support in jpql.

 Is there any plan to add spatial support in amber ?
 Thanks





 ___
 resin-interest mailing list
 resin-interest@caucho.com
 http://maillist.caucho.com/mailman/listinfo/resin-interest

 
 
 ___
 resin-interest mailing list
 resin-interest@caucho.com
 http://maillist.caucho.com/mailman/listinfo/resin-interest
 

-- 
Riccardo Cohen
Architecte du Logiciel
http://www.architectedulogiciel.fr
+33 (0)6.09.83.64.49
Membre du réseau http://www.reflexe-conseil-centre.org




___
resin-interest mailing list
resin-interest@caucho.com
http://maillist.caucho.com/mailman/listinfo/resin-interest

Re: [Resin-interest] support spatial queries in amber

2009-12-16 Thread Riccardo Cohen 
I really would like to know what is the Caucho point of view about this...
Thanks

Riccardo Cohen wrote:
 Hello
 I use mysql with spatial index and would like to use amber queries with 
 spatial field
 I tried these sort of queries :
 
 select p from Prop p where 
 Spatial.within(p.pos,Spatial.mPointFromText('MULTIPOINT(238500 
 6229301,238500 6260453,283700 6260453,283700 6229301)',0))
 
 But the java program stops (with no exception) when I call createQuery()...
 
 I found nothing in amber doc, but I've read here :
 
 http://www.jpox.org/docs/1_2/spatial.html
 
 that there could be spatial support in jpql.
 
 Is there any plan to add spatial support in amber ?
 Thanks

-- 
Riccardo Cohen
Architecte du Logiciel
http://www.architectedulogiciel.fr
+33 (0)6.09.83.64.49
Membre du réseau http://www.reflexe-conseil-centre.org




___
resin-interest mailing list
resin-interest@caucho.com
http://maillist.caucho.com/mailman/listinfo/resin-interest

Re: [Resin-interest] support spatial queries in amber

2009-12-16 Thread Scott Ferguson 
Riccardo Cohen wrote:
 I really would like to know what is the Caucho point of view about this...
   
At the moment, Amber development is being put on hold (except critical 
bugs), until we finish the web profile, because our main strategy is to 
focus on the core quality for both Resin and Quercus.

So we would not be looking at adding spatial support for another 6 
months at minimum, and even then we may decide Amber is still a lower 
priority than core Resin quality.

-- Scott
 Thanks

 Riccardo Cohen wrote:
   
 Hello
 I use mysql with spatial index and would like to use amber queries with 
 spatial field
 I tried these sort of queries :

 select p from Prop p where 
 Spatial.within(p.pos,Spatial.mPointFromText('MULTIPOINT(238500 
 6229301,238500 6260453,283700 6260453,283700 6229301)',0))

 But the java program stops (with no exception) when I call createQuery()...

 I found nothing in amber doc, but I've read here :

 http://www.jpox.org/docs/1_2/spatial.html

 that there could be spatial support in jpql.

 Is there any plan to add spatial support in amber ?
 Thanks
 

   




___
resin-interest mailing list
resin-interest@caucho.com
http://maillist.caucho.com/mailman/listinfo/resin-interest

Re: [Resin-interest] support spatial queries in amber

2009-12-16 Thread Jeff Schnitzer 
It's worth mentioning that Hibernate works great as a JPA provider for
Resin.  I haven't tried it, but there's this:

http://www.hibernatespatial.org/

Jeff

On Wed, Dec 16, 2009 at 9:25 AM, Scott Ferguson f...@caucho.com wrote:
 Riccardo Cohen wrote:
 I really would like to know what is the Caucho point of view about this...

 At the moment, Amber development is being put on hold (except critical
 bugs), until we finish the web profile, because our main strategy is to
 focus on the core quality for both Resin and Quercus.

 So we would not be looking at adding spatial support for another 6
 months at minimum, and even then we may decide Amber is still a lower
 priority than core Resin quality.

 -- Scott
 Thanks

 Riccardo Cohen wrote:

 Hello
 I use mysql with spatial index and would like to use amber queries with
 spatial field
 I tried these sort of queries :

 select p from Prop p where
 Spatial.within(p.pos,Spatial.mPointFromText('MULTIPOINT(238500
 6229301,238500 6260453,283700 6260453,283700 6229301)',0))

 But the java program stops (with no exception) when I call createQuery()...

 I found nothing in amber doc, but I've read here :

 http://www.jpox.org/docs/1_2/spatial.html

 that there could be spatial support in jpql.

 Is there any plan to add spatial support in amber ?
 Thanks







 ___
 resin-interest mailing list
 resin-interest@caucho.com
 http://maillist.caucho.com/mailman/listinfo/resin-interest



___
resin-interest mailing list
resin-interest@caucho.com
http://maillist.caucho.com/mailman/listinfo/resin-interest

[Resin-interest] support spatial queries in amber

2009-12-10 Thread Riccardo Cohen 
Hello
I use mysql with spatial index and would like to use amber queries with 
spatial field
I tried these sort of queries :

select p from Prop p where 
Spatial.within(p.pos,Spatial.mPointFromText('MULTIPOINT(238500 
6229301,238500 6260453,283700 6260453,283700 6229301)',0))

But the java program stops (with no exception) when I call createQuery()...

I found nothing in amber doc, but I've read here :

http://www.jpox.org/docs/1_2/spatial.html

that there could be spatial support in jpql.

Is there any plan to add spatial support in amber ?
Thanks
-- 
Riccardo Cohen
Architecte du Logiciel
http://www.architectedulogiciel.fr
+33 (0)6.09.83.64.49
Membre du réseau http://www.reflexe-conseil-centre.org




___
resin-interest mailing list
resin-interest@caucho.com
http://maillist.caucho.com/mailman/listinfo/resin-interest