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. ------------------------------------------------------------------------------ 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
