[gdal-dev] GeoRaster: problem updating on predefined existing table

[Pasta Bolognese]

that is a good news ! so now I need just to wait that the OSGeo4W
team add the gdal17-oracle package.

thanks !

On Tue, Jul 13, 2010 at 2:11 AM, Ivan Lucena <ivan.lucena at pmldnet.com> wrote:
> I just noticed from your ticket [http://trac.osgeo.org/gdal/ticket/3681] that you are using GDAL 1.6.3. Right?
>
> A lot has changed since then. I run the same sequence of options as you and everything works fine in GDAL 1.8dev.
>
> I believe it should work fine with the current released version too. GDAL 1.7.2.
>
> Please update it and try again.
>
> Regards.
>
>>  -------Original Message-------
>>  From: Pasta Bolognese <pasta.bolognese at gmail.com>
>>  To: Ivan Lucena <ivan.lucena at pmldnet.com>
>>  Cc: gdal-dev at lists.osgeo.org
>>  Subject: Re: [gdal-dev] GeoRaster: problem updating on predefined existing table
>>  Sent: Jul 12 '10 09:59
>>
>>  doing more experiments it results that the error is given ONLY when
>>  the schema is given.
>>
>>  gdal_translate -of georaster c:\tmp\map.png ^
>>                 georaster:geoserver/geoserver,MFDEVDB,GEOSERVER.PASTA
>>  _RASTERS,raster ^
>>                 -co "INSERT=VALUES(SDO_GEOR.INIT('pasta_rdt_01'))"
>>
>>  It is using the table GEOSERVER.PASTA _RASTERS. It would work only
>>  once. After that it would give the same error ORA-00955)
>>
>>  gdal_translate -of georaster c:\tmp\map.png ^
>>                 georaster:geoserver/geoserver,MFDEVDB,PASTA _RASTERS,raster ^
>>                 -co "INSERT=VALUES(SDO_GEOR.INIT('pasta_rdt_01'))"
>>
>>  It is using the table PASTA _RASTERSThis would work all the time..
>>
>>  Is it working as expected ?
>>
>>  On Mon, Jul 12, 2010 at 2:54 PM, Pasta Bolognese
>>  <pasta.bolognese at gmail.com> wrote:
>>  >> >
>>  >> >  C:\>gdal_translate -of georaster  c:\tmp\map.png
>>  >> >  georaster:geoserver/geoserver,MFDEVDB
>>  >> >
>>  >> >  and it works well. Then I've imported another immage using the same
>>  >> >  command and it worked well too !
>>  >>
>>  >> Note that you didn't specify table & column so a table named "GDAL_IMPORT", column "RASTER" was created for you as default.
>>  >
>>  > exactly
>>  >
>>  >>
>>  >> >
>>  >> >  Then I have decided to use a predefined table.... and here the problems:
>>  >> >
>>  >> >  C:\>gdal_translate -of georaster  c:\tmp\map.png
>>  >> >  georaster:geoserver/geoserver,MFDEVDB,geoserver.pasta
>>  >>
>>  >> This command is missing the column name after "schema.table" so it is assuming column name "RASTER" as default. Does the table "pasta" existed before that command?
>>  >
>>  > exactly. The table PASTA is created automatically by the command itself.
>>  >
>>  >>
>>  >> >  Input file size is 1014, 863
>>  >> >  0...10...20...30...40...50...60...70...80...90...100 - done.
>>  >> >  Ouput dataset: (georaster:geoserver,geoserver,MFDEVDB,RDT_33$,33) on
>>  >> >  PASTA,RASTER
>>  >> >
>>  >
>>  > at this point the table is created by GDAL
>>  >
>>  >> >  C:\>gdal_translate -of georaster  c:\tmp\map.png
>>  >> >  georaster:geoserver/geoserver,MFDEVDB,geoserver.pasta
>>  >> >  Input file size is 1014, 863
>>  >> >  ERROR 1: ORA-00955: name is already used by an existing object
>>  >> >  ORA-06512: at line 10
>>  >> >
>>  >> >  ERROR 1: Create Table Error!
>>  >> >
>>  >>
>>  >> Again, this command is missing the column name too, so I believe it is trying to re-create the table "Pasta" with column "RASTER". Whatever is happening is caused by the error on the command.
>>  >>
>>  >
>>  > At this point GDAL should add a new line to the same table....
>>  >
>>  > infact even giving the table name and the column name: (again, the
>>  > table is created automatically by GDAL)
>>  >
>>  >
>>  > C:\>gdal_translate -of georaster  c:\tmp\map.png
>>  > georaster:geoserver/geoserver,MFDEVDB,geoserver.pasta,raster
>>  > Input file size is 1014, 863
>>  > 0...10...20...30...40...50...60...70...80...90...100 - done.
>>  > Ouput dataset: (georaster:geoserver,geoserver,MFDEVDB,RDT_42$,42) on
>>  > PASTA,RASTER
>>  >
>>  > C:\>gdal_translate -of georaster  c:\tmp\map.png
>>  > georaster:geoserver/geoserver,MFDEVDB,geoserver.pasta,raster
>>  > Input file size is 1014, 863
>>  > ERROR 1: ORA-00955: name is already used by an existing object
>>  > ORA-06512: at line 10
>>  >
>>  > ERROR 1: Create Table Error!
>>  >
>>
>