Hi all - I'm trying to set up oracle using GAST and am getting an error
message that says "such column list already indexed". It stops the database
setup routine and after that I get null pointer exceptions when trying to
use geonetwork. If I use the embedded db the setup works fine with no
errors.
I've search through the forum but haven't found anything about it, anyone
else having this problem? I really need to get this working, any hints
would be greatly appreciated.
Hi Pat,
Indeed that is a known problem. It is due to the order in which the indexes are added by the druid API that takes care of the schema creation. I have updated the SQL file for Oracle. If you can test that and let me know if it works, I can put a fix in v2.4.0 in time.
Do the following:
- make a backup of the SQL file for Oracle under found under geonetwork/gast/setup/sql
- put the file attached in its place
- use GAST to create the database on Oracle
Hi Jeroen - no luck, same error. It does work if I comment out the two
Create Index lines but I assume that will affect performance?
Jeroen Ticheler - GeoCat wrote:
Hi Pat,
Indeed that is a known problem. It is due to the order in which the
indexes are added by the druid API that takes care of the schema
creation. I have updated the SQL file for Oracle. If you can test that
and let me know if it works, I can put a fix in v2.4.0 in time.
Do the following:
- make a backup of the SQL file for Oracle under found under
geonetwork/gast/setup/sql
- put the file attached in its place
- use GAST to create the database on Oracle
Ciao,
Jeroen
On Jul 14, 2009, at 12:29 PM, PatB wrote:
Hi all - I'm trying to set up oracle using GAST and am getting an
error
message that says "such column list already indexed". It stops the
database
setup routine and after that I get null pointer exceptions when
trying to
use geonetwork. If I use the embedded db the setup works fine with no
errors.
I've search through the forum but haven't found anything about it,
anyone
else having this problem? I really need to get this working, any
hints
would be greatly appreciated.
------------------------------------------------------------------------------
Enter the BlackBerry Developer Challenge
This is your chance to win up to $100,000 in prizes! For a limited
time,
vendors submitting new applications to BlackBerry App World(TM) will
have
the opportunity to enter the BlackBerry Developer Challenge. See
full prize
details at: http://p.sf.net/sfu/Challenge
_______________________________________________
GeoNetwork-users mailing list
GeoNetwork-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/geonetwork-users
GeoNetwork OpenSource is maintained at http://sourceforge.net/projects/geonetwork
------------------------------------------------------------------------------
Enter the BlackBerry Developer Challenge
This is your chance to win up to $100,000 in prizes! For a limited time,
vendors submitting new applications to BlackBerry App World(TM) will have
the opportunity to enter the BlackBerry Developer Challenge. See full
prize
details at: http://p.sf.net/sfu/Challenge
_______________________________________________
GeoNetwork-users mailing list
GeoNetwork-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/geonetwork-users
GeoNetwork OpenSource is maintained at http://sourceforge.net/projects/geonetwork