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

[Pasta Bolognese]

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