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