Yep, I see.

Steve, as you are an expert in the mean time I have 2 questions.

Looking here
http://download.oracle.com/docs/cd/E11882_01/appdev.112/e11827/geor_ref.htm#autoId12

1)
I see some samples for exportTo without calling createTemporary. Would  
this work in our case ?

2)
Looking at function getRasterData, I see an example

DECLARE
   gr sdo_georaster;
   lb blob;
BEGIN
   SELECT georaster INTO gr FROM georaster_table WHERE georid=2;
   dbms_lob.createTemporary(lb, FALSE);
   sdo_geor.getRasterData(gr, 0, lb, 'compress=JPEG-F');
   dbms_lob.freeTemporary(lb);
END;

Is it possible to call freeTemporary  when using exportTo instead of  
getRasterData ?

Some confusion here on my side :-)




Zitat von Steve Way <steve....@infotech-enterprises.com>:

> Actually it is not an Oracle *Issue* as such but more as design.
>
> When I first discovered this issue (when designing the GeoRaster   
> Plugin), I spent a lot of time trying to figure it out.  It all   
> comes down to two functions called: createTemporary() and   
> freeTemporary().
>
> Christian, you will see from your code, that you are calling the   
> createTemporary() in your callable statement, but not the   
> freeTemporary().  With a callable statement like this, you cannot   
> call the freeTemporary() as you would need to do this AFTER you have  
>  retrieved the blob from Oracle, and as with java, PL/SQL you are   
> unable to call a function after a return.
>
> Therefore, the only way to do this is use the Oracle Spatial Java   
> API to createTemporary and freeTemporary against an Oracle BLOB type.
>
> Regards,
> Steve
>
>
>
> -----Original Message-----
> From: christian.muel...@nvoe.at [mailto:christian.muel...@nvoe.at]
> Sent: 06 September 2011 14:18
> To: Harikumar Reddy
> Cc: Simone Giannecchini; geoserver-users@lists.sourceforge.net; Steve Way
> Subject: Re: [Geoserver-users] Geoserver 2.1.0 stops very frequently
>
> Hmmm, I would say you are sitting on a time bomb because there is a   
> good chance that the temp space becomes full again.
>
> Do you have a support contract with Oracle giving you the   
> possibility to  open a ticket.
>
> @Steve, do you have the possibility to open a ticket
>
> I fear that this problem will reoccur many times in the future.
>
> Christian
>
>
> Zitat von Harikumar Reddy <harik....@gmail.com>:
>
>> Hi Christian,
>>
>> Thankyou for georaster oracle function url. Yesterday, our oracle
>> admin has not restarted the database after temporary table space
>> creation. He has restarted the database today. I think now geoserver
>> is working fine., but i can only confirm myself about the geoserver
>> consistency by observing till this weekend.
>>
>> Regards,
>> Hari.
>>
>>
>> On Tue, Sep 6, 2011 at 10:58 AM, <christian.muel...@nvoe.at> wrote:
>>
>>> Some additional Info.
>>>
>>> Here is the Oracle Function causing the problem
>>> http://download.oracle.com/**docs/cd/E11882_01/appdev.112/**
>>> e11827/geor_ref.htm#CHEDHBII<http://download.oracle.com/docs/cd/E1188
>>> 2_01/appdev.112/e11827/geor_ref.htm#CHEDHBII>
>>>
>>> Geoserver uses this function to export the image into a BLOB.
>>>
>>>
>>> Cheers
>>> Christian
>>>
>>>
>>> Zitat von Harikumar Reddy <harik....@gmail.com>:
>>>
>>>  Hi Christian,
>>>>
>>>> Thankyou for response. Oracle admin freed up oracle temporary table
>>>> space (when they checked free space was zero kb as you have
>>>> expected) and created new temporary table space also., but it didnt
>>>> corrected geoserver problem.
>>>>
>>>> we may need to do R & D and observe the results, from image
>>>> processing & oracle side (with oracle admin).
>>>>
>>>> Regards,
>>>> Hari.
>>>>
>>>> On Mon, Sep 5, 2011 at 10:53 PM, <christian.muel...@nvoe.at> wrote:
>>>>
>>>>  Hi Hari, I am not working with Oracle, as a consequence I have less
>>>>> experience, but:
>>>>>
>>>>> creating an extra Oracle table space is ok, the question was if the
>>>>> table space was full at the moment geoserver refuses work.
>>>>>
>>>>> Was it ?
>>>>>
>>>>> If the temp tablespace is full then we have the reason but no solution.
>>>>> You
>>>>> have to open an oracle ticket because this seems to be an Oracle problem.
>>>>> Of
>>>>> course I can assist you in describing the situation since I
>>>>> developed the georaster plugin.
>>>>>
>>>>>
>>>>> Cheers
>>>>> Christian
>>>>>
>>>>>
>>>>>
>>>>>
>>>>> Zitat von Harikumar Reddy <harik....@gmail.com>:
>>>>>
>>>>>  Hi Christian,
>>>>>
>>>>>>
>>>>>> Our oracle admin has created oracle temporary table space, but
>>>>>> still this problem exists. Any further investigation i need to
>>>>>> do...Please advise me, if you have any idea...The geoserver error
>>>>>> is not specific to the problem in log file.
>>>>>>
>>>>>> Thanking you,
>>>>>>
>>>>>> Regards,
>>>>>> Hari.
>>>>>>
>>>>>>
>>>>>> On Sat, Sep 3, 2011 at 12:38 PM, <christian.muel...@nvoe.at> wrote:
>>>>>>
>>>>>>  Hi, I examined your log file and there is nothing special. There
>>>>>> is only
>>>>>>
>>>>>>> one exception which has nothing to do with our problem here.
>>>>>>>
>>>>>>> Another user, Steve Way had similar problems and did investigations.
>>>>>>> Look
>>>>>>> here
>>>>>>> http://osgeo-org.1803224.n2.******nabble.com/Question-about-****<
>>>>>>> http://nabble.com/Question-**about-**<http://nabble.com/Question-
>>>>>>> about-**>
>>>>>>> >
>>>>>>>
>>>>>>> GeoServer-or-GeoTools-support-******for-Oracle-Spatial-****
>>>>>>> td6283994.**html<
>>>>>>> http://osgeo-**org.1803224.n2.**nabble.com/**Question-about-**
>>>>>>> GeoServer-or-*<http://org.1803224.n2.nabble.com/**Question-about-
>>>>>>> GeoServer-or-*>
>>>>>>>  *GeoTools-support-for-Oracle-****Spatial-td6283994.html<http:/**
>>>>>>> /osgeo-org.1803224.n2.nabble.**com/Question-about-GeoServer-**
>>>>>>> or-GeoTools-support-for-**Oracle-Spatial-td6283994.html<http://os
>>>>>>> geo-org.1803224.n2.nabble.com/Question-about-GeoServer-or-GeoTool
>>>>>>> s-support-for-Oracle-Spatial-td6283994.html>
>>>>>>> >
>>>>>>>
>>>>>>> >
>>>>>>>
>>>>>>>
>>>>>>> The important fact:
>>>>>>> It seems that Oracle uses its temporary table space to create the
>>>>>>> image.
>>>>>>> Unfortunately it does not release this space afterwards and as a
>>>>>>> consequence, the temporary table space reaches its limit.
>>>>>>>
>>>>>>> Please do the following:
>>>>>>> Wait for the next geoserver stop and have an Oracle admin ready
>>>>>>> to look at the temporary table space. If it is filled up we may
>>>>>>> have found the reason.
>>>>>>>
>>>>>>> Cheers
>>>>>>> Christian
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>> Zitat von Harikumar Reddy <harik....@gmail.com>:
>>>>>>>
>>>>>>>
>>>>>>>  Hi Simone,
>>>>>>>
>>>>>>>
>>>>>>>> I have imported raster data into oracle spatial 11g r2 as
>>>>>>>> georaster and configured with ImageMosaicJDBC plugin datastore.
>>>>>>>>
>>>>>>>>  - Geoserver version is 2.1.0.
>>>>>>>>  - Connections: 5
>>>>>>>>  - GeoServer RAM 4GB
>>>>>>>>  - JAI Memory 1GB
>>>>>>>>  - Environment : Linux Cent OS
>>>>>>>>  - Dervlet container : Tomcat 6.0
>>>>>>>>  - deployment environment : Springsource TCserver environment
>>>>>>>>  - Database : Oracle spatial 11g R2
>>>>>>>>  - Raster images type : Georaster (SPOT images)
>>>>>>>>  - Jai & Jai Image IO are still showing false even after
>>>>>>>> successful  installation.
>>>>>>>>
>>>>>>>> I am a pure geotechnician, so i have less knowledge on hardware
>>>>>>>> configuration side. Please let me know, if you need any other
>>>>>>>> information.
>>>>>>>>
>>>>>>>> Thanking you,
>>>>>>>>
>>>>>>>> Regards,
>>>>>>>> Hari.
>>>>>>>>
>>>>>>>> On Fri, Sep 2, 2011 at 10:34 PM, Simone Giannecchini <
>>>>>>>> simone.giannecchini@geo-****solu**tions.it
>>>>>>>> <http://solutions.it>< simone.giannecchini@**geo-**solutions.it
>>>>>>>> <http://geo-solutions.it><
>>>>>>>> simone.**giannecch...@geo-solutions.it<simone.giannecchini@geo-s
>>>>>>>> olutions.it>
>>>>>>>> >
>>>>>>>> >>
>>>>>>>> wrote:
>>>>>>>>
>>>>>>>>  Ciao Hari,
>>>>>>>>
>>>>>>>>  I would need to know a bit more about how you configured this
>>>>>>>> data
>>>>>>>>> and
>>>>>>>>> about the server config otherwiser I would be alone in the dark.
>>>>>>>>>
>>>>>>>>> Regards,
>>>>>>>>> Simone Giannecchini
>>>>>>>>> ------------------------------******-------------------------
>>>>>>>>> Ing. Simone Giannecchini
>>>>>>>>> GeoSolutions S.A.S.
>>>>>>>>> Founder
>>>>>>>>>
>>>>>>>>> Via Poggio alle Viti 1187
>>>>>>>>> 55054  Massarosa (LU)
>>>>>>>>> Italy
>>>>>>>>>
>>>>>>>>> phone: +39 0584 962313
>>>>>>>>> fax:      +39 0584 962313
>>>>>>>>> mob:    +39 333 8128928
>>>>>>>>>
>>>>>>>>> http://www.geo-solutions.it
>>>>>>>>> http://geo-solutions.blogspot.******com/<http://geo-solutions.****
>>>>>>>>> blogspot.com/
>>>>>>>>> <http://geo-solutions.**blogspot.com/<http://geo-solutions.blog
>>>>>>>>> spot.com/>
>>>>>>>>> >>
>>>>>>>>>
>>>>>>>>> http://www.youtube.com/user/******GeoSolutionsIT<http://www.you
>>>>>>>>> tube.com/user/****GeoSolutionsIT>
>>>>>>>>> <http://www.**youtube.com/user/****GeoSolutionsIT<http://www.yo
>>>>>>>>> utube.com/user/**GeoSolutionsIT>
>>>>>>>>> >
>>>>>>>>>
>>>>>>>>> <http://www.**youtube.com/**user/**GeoSolutionsIT<http://youtub
>>>>>>>>> e.com/user/**GeoSolutionsIT>
>>>>>>>>> <http://**www.youtube.com/user/**GeoSolutionsIT<http://www.yout
>>>>>>>>> ube.com/user/GeoSolutionsIT>
>>>>>>>>> >
>>>>>>>>>
>>>>>>>>> >
>>>>>>>>> http://www.linkedin.com/in/******simonegiannecchini<http://www.
>>>>>>>>> linkedin.com/in/****simonegiannecchini>
>>>>>>>>> <http://**www.linkedin.com/in/****simonegiannecchini<http://www
>>>>>>>>> .linkedin.com/in/**simonegiannecchini>
>>>>>>>>> >
>>>>>>>>> <http://www.**linkedin.com/in/****simonegiannecchini<http://lin
>>>>>>>>> kedin.com/in/**simonegiannecchini>
>>>>>>>>> <http://**www.linkedin.com/in/**simonegiannecchini<http://www.l
>>>>>>>>> inkedin.com/in/simonegiannecchini>
>>>>>>>>> >
>>>>>>>>> >
>>>>>>>>>
>>>>>>>>> http://twitter.com/simogeo
>>>>>>>>>
>>>>>>>>> ------------------------------******-------------------------
>>>>>>>>>
>>>>>>>>>
>>>>>>>>>
>>>>>>>>> On Fri, Sep 2, 2011 at 5:50 PM, Harikumar Reddy
>>>>>>>>> <harik....@gmail.com
>>>>>>>>> >
>>>>>>>>> wrote:
>>>>>>>>> > Hi Simone,
>>>>>>>>> >
>>>>>>>>> > Thankyou for quick reply.
>>>>>>>>> >
>>>>>>>>> > I am working directly in production environment (only for
>>>>>>>>> imageries).
>>>>>>>>> So
>>>>>>>>> I
>>>>>>>>> > need to inform client priorly. If newer version will surely
>>>>>>>>> > solve
>>>>>>>>> the
>>>>>>>>> > problem, then i can request them. For checking locally, we
>>>>>>>>> > dont
>>>>>>>>> have
>>>>>>>>> those
>>>>>>>>> > imageries with us. We are working through secured gateways. I
>>>>>>>>> haven't
>>>>>>>>> > observed this problem before in 2.0.2 version. I have
>>>>>>>>> > configured
>>>>>>>>> around
>>>>>>>>> 110
>>>>>>>>> > GB SPOT imageries 2 months before (now also i have to remove
>>>>>>>>> > old
>>>>>>>>> and
>>>>>>>>> need
>>>>>>>>> to
>>>>>>>>> > configure same area with updated imageries). Any work around
>>>>>>>>> > is
>>>>>>>>> possible
>>>>>>>>> ?
>>>>>>>>> >
>>>>>>>>> > Could you please suggest me that is it caused due to memory
>>>>>>>>> problems
>>>>>>>>> > (hardware side or geoserver side). From logs URI not
>>>>>>>>> > receiving
>>>>>>>>> error
>>>>>>>>> i
>>>>>>>>> have
>>>>>>>>> > seen...but i need to investigate this problem.
>>>>>>>>> >
>>>>>>>>> > Regards,
>>>>>>>>> > Hari.
>>>>>>>>> >
>>>>>>>>> > On Fri, Sep 2, 2011 at 8:11 PM, Simone Giannecchini
>>>>>>>>> >  <simone.giannecchini@geo-****sol**utions.it
>>>>>>>>> ><http://solutions.it <
>>>>>>>>> simone.giannecchini@**geo-**solutions.it
>>>>>>>>> <http://geo-solutions.it><
>>>>>>>>> simone.**giannecch...@geo-solutions.it<simone.giannecchini@geo-
>>>>>>>>> solutions.it>
>>>>>>>>> >
>>>>>>>>>
>>>>>>>>> >>
>>>>>>>>>
>>>>>>>>> wrote:
>>>>>>>>> >>
>>>>>>>>> >> Ciao Hari,
>>>>>>>>> >> quick suggestion since we fixed a few glitches with raster
>>>>>>>>> >> data in 2,1.0, can you try to upgrade to 2.1.1 or even to
>>>>>>>>> >> 2.1.x nightly
>>>>>>>>> and
>>>>>>>>> >> then check this issues again?
>>>>>>>>> >>
>>>>>>>>> >> Regards,
>>>>>>>>> >> Simone Giannecchini
>>>>>>>>> >> ------------------------------******------------------------
>>>>>>>>> >> -
>>>>>>>>> >> Ing. Simone Giannecchini
>>>>>>>>> >> GeoSolutions S.A.S.
>>>>>>>>> >> Founder
>>>>>>>>> >>
>>>>>>>>> >> Via Poggio alle Viti 1187
>>>>>>>>> >> 55054  Massarosa (LU)
>>>>>>>>> >> Italy
>>>>>>>>> >>
>>>>>>>>> >> phone: +39 0584 962313
>>>>>>>>> >> fax:      +39 0584 962313
>>>>>>>>> >> mob:    +39 333 8128928
>>>>>>>>> >>
>>>>>>>>> >> http://www.geo-solutions.it
>>>>>>>>> >>
>>>>>>>>> >> http://geo-solutions.blogspot.******com/<http://geo-solution
>>>>>>>>> >> s.**
>>>>>>>>> **
>>>>>>>>> blogspot.com/
>>>>>>>>> <http://geo-solutions.**blogspot.com/<http://geo-solutions.blog
>>>>>>>>> spot.com/>
>>>>>>>>> >>
>>>>>>>>>
>>>>>>>>> >>
>>>>>>>>> http://www.youtube.com/user/******GeoSolutionsIT<http://www.you
>>>>>>>>> tube.com/user/****GeoSolutionsIT>
>>>>>>>>> <http://www.**youtube.com/user/****GeoSolutionsIT<http://www.yo
>>>>>>>>> utube.com/user/**GeoSolutionsIT>
>>>>>>>>> >
>>>>>>>>>
>>>>>>>>> <http://www.**youtube.com/**user/**GeoSolutionsIT<http://youtub
>>>>>>>>> e.com/user/**GeoSolutionsIT>
>>>>>>>>> <http://**www.youtube.com/user/**GeoSolutionsIT<http://www.yout
>>>>>>>>> ube.com/user/GeoSolutionsIT>
>>>>>>>>> >
>>>>>>>>>
>>>>>>>>> >
>>>>>>>>> >>
>>>>>>>>> http://www.linkedin.com/in/******simonegiannecchini<http://www.
>>>>>>>>> linkedin.com/in/****simonegiannecchini>
>>>>>>>>> <http://**www.linkedin.com/in/****simonegiannecchini<http://www
>>>>>>>>> .linkedin.com/in/**simonegiannecchini>
>>>>>>>>> >
>>>>>>>>>
>>>>>>>>> <http://www.**linkedin.com/in/****simonegiannecchini<http://lin
>>>>>>>>> kedin.com/in/**simonegiannecchini>
>>>>>>>>> <http://**www.linkedin.com/in/**simonegiannecchini<http://www.l
>>>>>>>>> inkedin.com/in/simonegiannecchini>
>>>>>>>>> >
>>>>>>>>> >
>>>>>>>>>
>>>>>>>>> >> http://twitter.com/simogeo
>>>>>>>>> >>
>>>>>>>>> >> ------------------------------******------------------------
>>>>>>>>> >> -
>>>>>>>>> >>
>>>>>>>>> >>
>>>>>>>>> >>
>>>>>>>>> >> On Fri, Sep 2, 2011 at 2:46 PM, Harikumar Reddy <
>>>>>>>>> harik....@gmail.com>
>>>>>>>>> >> wrote:
>>>>>>>>> >> > Hari
>>>>>>>>> >
>>>>>>>>> >
>>>>>>>>> >
>>>>>>>>> ------------------------------******--------------------------*
>>>>>>>>> *
>>>>>>>>> --**--**
>>>>>>>>> ------------------
>>>>>>>>> > Special Offer -- Download ArcSight Logger for FREE!
>>>>>>>>> > Finally, a world-class log management solution at an even
>>>>>>>>> > better price-free! And you'll get a free "Love Thy Logs"
>>>>>>>>> > t-shirt when you download Logger. Secure your free   
>>>>>>>>> ArcSight Logger TODAY!
>>>>>>>>> >
>>>>>>>>> http://p.sf.net/sfu/******arcsisghtdev2dev<http://p.sf.net/sfu/
>>>>>>>>> ****arcsisghtdev2dev>
>>>>>>>>> <http://p.sf.**net/sfu/**arcsisghtdev2dev<http://p.sf.net/sfu/*
>>>>>>>>> *arcsisghtdev2dev>
>>>>>>>>> >
>>>>>>>>> <http://p.sf.**net/sfu/**arcsisghtdev2dev<http://p.sf.**
>>>>>>>>> net/sfu/arcsisghtdev2dev
>>>>>>>>> <http://p.sf.net/sfu/arcsisghtdev2dev>>
>>>>>>>>> >
>>>>>>>>> > ______________________________******_________________
>>>>>>>>> > Geoserver-users mailing list
>>>>>>>>> >  Geoserver-users@lists.****source**forge.net <
>>>>>>>>> http://sourceforge.net><
>>>>>>>>> Geoserver-users@**lists.**sourceforge.net<http://lists.sourcefo
>>>>>>>>> rge.net>
>>>>>>>>> <Geoserver-**us...@lists.sourceforge.net<Geoserver-users@lists.
>>>>>>>>> sourceforge.net>
>>>>>>>>> >
>>>>>>>>>
>>>>>>>>> >
>>>>>>>>> >
>>>>>>>>> > https://lists.sourceforge.net/******lists/listinfo/geoserver-
>>>>>>>>> > ***
>>>>>>>>> *users<https://lists.sourceforge.net/****lists/listinfo/geoserv
>>>>>>>>> er-**users>
>>>>>>>>> <https://lists.**sourceforge.net/**lists/**listinfo/geoserver-u
>>>>>>>>> sers<https://lists.sourceforge.net/**lists/listinfo/geoserver-u
>>>>>>>>> sers>
>>>>>>>>> >
>>>>>>>>> <https://lists.**sourceforge.**net/lists/**listinfo/**
>>>>>>>>> geoserver-users<http://sourceforge.net/lists/**listinfo/geoserv
>>>>>>>>> er-users>
>>>>>>>>> <https://lists.**sourceforge.net/lists/**listinfo/geoserver-use
>>>>>>>>> rs<https://lists.sourceforge.net/lists/listinfo/geoserver-users
>>>>>>>>> >
>>>>>>>>> >
>>>>>>>>> >
>>>>>>>>> >
>>>>>>>>> >
>>>>>>>>>
>>>>>>>>>
>>>>>>>>>
>>>>>>>>>
>>>>>>>>
>>>>>>> ------------------------------******--------------------------**
>>>>>>> --**--**----
>>>>>>> This message was sent using IMP, the Internet Messaging Program.
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>
>>>>>
>>>>> ------------------------------****----------------------------**--*
>>>>> *---- This message was sent using IMP, the Internet Messaging
>>>>> Program.
>>>>>
>>>>>
>>>>>
>>>>>
>>>>
>>>
>>>
>>> ------------------------------**------------------------------**----
>>>
>>> This message was sent using IMP, the Internet Messaging Program.
>>>
>>>
>>>
>>
>
>
>
> ----------------------------------------------------------------
> This message was sent using IMP, the Internet Messaging Program.
>
>
>
> DISCLAIMER:
>
> This email may contain confidential information and is intended only  
>  for the use of the specific individual(s) to which it is addressed.  
>  If you are not the intended recipient of this email, you are hereby  
>  notified that any unauthorized use, dissemination or copying of  
> this  email or the information contained in it or attached to it is   
> strictly prohibited. If you received this message in error, please   
> immediately notify the sender at Infotech or   
> mail.ad...@infotech-enterprises.com and delete the original message.
>



----------------------------------------------------------------
This message was sent using IMP, the Internet Messaging Program.



------------------------------------------------------------------------------
Using storage to extend the benefits of virtualization and iSCSI
Virtualization increases hardware utilization and delivers a new level of
agility. Learn what those decisions are and how to modernize your storage 
and backup environments for virtualization.
http://www.accelacomm.com/jaw/sfnl/114/51434361/
_______________________________________________
Geoserver-users mailing list
Geoserver-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users

Reply via email to