Not quite. I get:
dspace_test=> \dt bitstreamregistry
No matching relations found.
dspace_test=> \d
dspace_test=> \dt bitstreamformatregistry
List of relations
Schema | Name | Type | Owner
--------+-------------------------+-------+-------------
public | bitstreamformatregistry | table | dspace_test
(1 row)
dspace_test=> \d bitstreamformatregistry
Table "public.bitstreamformatregistry"
Column | Type | Modifiers
---------------------+------------------------+-----------
bitstream_format_id | integer | not null
mimetype | character varying(256) |
short_description | character varying(128) |
description | text |
support_level | integer |
internal | boolean |
Indexes:
"bitstreamformatregistry_pkey" PRIMARY KEY, btree (bitstream_format_id)
"bitstreamformatregistry_short_description_key" UNIQUE, btree
(short_description)
dspace_test=> select * from bitstreamformatregistry;
bitstream_format_id | mimetype | short_description | description |
support_level | internal
---------------------+----------+-------------------+-------------+---------------+----------
(0 rows)
________________________________________
From: Vishal Kakapuri [EMAIL PROTECTED]
Sent: 28 March 2008 10:12
To: Mark Diggory
Cc: George Vernon; [email protected]
Subject: Re: [Dspace-tech] 1.5 install
static String canonicalize(String column){static String
canonicalize(String column){
if ("oracle".equals(ConfigurationManager.getProperty("db.name")))
{
// oracle requires uppercase
return column.toUpperCase();
}
// postgres default lowercase
611 - return column.toLowerCase();
}
I guess somehow your column is coming null for "bitstreamformatregistry"
Do you data something like this in this table:
dspace=> \dt bitstreamformatregistry
List of relations
Schema | Name | Type | Owner
--------+-------------------------+-------+--------
public | bitstreamformatregistry | table | dspace
(1 row)
dspace=> \d bitstreamformatregistry
Table "public.bitstreamformatregistry"
Column | Type | Modifiers
---------------------+------------------------+-----------
bitstream_format_id | integer | not null
mimetype | character varying(256) |
short_description | character varying(128) |
description | text |
support_level | integer |
internal | boolean |
Indexes:
"bitstreamformatregistry_pkey" PRIMARY KEY, btree (bitstream_format_id)
"bitstreamformatregistry_short_description_key" UNIQUE, btree
(short_description)
dspace=> select * from bitstreamformatregistry;
bitstream_format_id | mimetype
| short_description
| description
| support_level | internal
---------------------+---------------------------------------------------------------------------+---------------------------
---------+----------------------------------------------------------------------+---------------+----------
1 | application/octet-stream
| Unknown
| Unknown data format
| 0 | f
2 | text/plain
| License
| Item-specific license agreed upon to submission
| 1 | t
3 | application/pdf
| Adobe PDF
.................
.................
Regards,
Vishal
On 3/28/08, Mark Diggory <[EMAIL PROTECTED]> wrote:
> Hello George,
>
> I just ran a test on my workstation to do a fresh install of DSpace
> 1.5.0 and was successful. So I suspect it is something with your
> environment/configuration. Can you give me more detail about your
> setup (database version, OS)? Are those 4 tables the only ones
> created? there should be 40.
>
> Cheers,
> Mark
>
>
> On Mar 27, 2008, at 9:13 AM, George Vernon wrote:
>
> > Trying a test install and getting the following error at the 'ant
> > fresh install'. Has anyone else come across this?
> >
> >
> >
> >
> >
> > (log.init.config)
> >
> > [java] 2008-03-27 15:02:51,479 FATAL
> > org.dspace.administer.RegistryLoader @
> > anonymous::error_loading_registries:
> >
> > [java] java.lang.NullPointerException
> >
> > [java] at org.dspace.storage.rdbms.TableRow.canonicalize
> > (TableRow.java:611)
> >
> > [java] at org.dspace.storage.rdbms.TableRow.hasColumn
> > (TableRow.java:110)
> >
> >
> >
> >
> >
> > The tables appear to have been created correctly:
> >
> >
> >
> > dspace_test=> \dt
> >
> > List of relations
> >
> > Schema | Name | Type | Owner
> >
> > --------+----------------------------+-------+-------------
> >
> > public | bi_2_dis | table | dspace_test
> >
> > public | bi_2_dmap | table | dspace_test
> >
> > .
> >
> > .
> >
> > public | workflowitem | table | dspace_test
> >
> > public | workspaceitem | table | dspace_test
> >
> > (40 rows)
> >
> >
> >
> > dspace_test=>
> >
> >
> >
> > The full response from ant was:
> >
> >
> >
> > [EMAIL PROTECTED]:/usr/local/dspace_test/dspace/target/
> > dspace-1.5.0-build.dir> ant fresh_install
> >
> > Buildfile: build.xml
> >
> >
> >
> > init_installation:
> >
> > [mkdir] Created dir: /home/dspace_test/bin
> >
> > [mkdir] Created dir: /home/dspace_test/config
> >
> > [mkdir] Created dir: /home/dspace_test/lib
> >
> > [mkdir] Created dir: /home/dspace_test/webapps
> >
> > [mkdir] Created dir: /home/dspace_test/assetstore
> >
> > [mkdir] Created dir: /home/dspace_test/handle-server
> >
> > [mkdir] Created dir: /home/dspace_test/search
> >
> > [mkdir] Created dir: /home/dspace_test/log
> >
> > [mkdir] Created dir: /home/dspace_test/upload
> >
> > [mkdir] Created dir: /home/dspace_test/reports
> >
> >
> >
> > init_configs:
> >
> > [copy] Copying 43 files to /home/dspace_test/config
> >
> >
> >
> > setup_database:
> >
> > [java] 2008-03-27 15:02:40,880 INFO
> > org.dspace.core.ConfigurationManager @ Loading system provided
> > config property (-Ddspace.configuration): config/dspace.cfg
> >
> > [java] 2008-03-27 15:02:40,884 INFO
> > org.dspace.core.ConfigurationManager @ Using default log4j provided
> > log configuration,if uninitended, check your dspace.cfg for
> > (log.init.config)
> >
> > [java] 2008-03-27 15:02:40,884 INFO
> > org.dspace.storage.rdbms.InitializeDatabase @ Initializing Database
> >
> > [java] 2008-03-27 15:02:49,029 INFO
> > org.dspace.core.ConfigurationManager @ Loading system provided
> > config property (-Ddspace.configuration): config/dspace.cfg
> >
> > [java] 2008-03-27 15:02:49,033 INFO
> > org.dspace.core.ConfigurationManager @ Using default log4j provided
> > log configuration,if uninitended, check your dspace.cfg for
> > (log.init.config)
> >
> >
> >
> > load_registries:
> >
> > [java] 2008-03-27 15:02:50,956 INFO
> > org.dspace.core.ConfigurationManager @ Loading system provided
> > config property (-Ddspace.configuration): config/dspace.cfg
> >
> > [java] 2008-03-27 15:02:50,960 INFO
> > org.dspace.core.ConfigurationManager @ Using default log4j provided
> > log configuration,if uninitended, check your dspace.cfg for
> > (log.init.config)
> >
> > [java] 2008-03-27 15:02:51,479 FATAL
> > org.dspace.administer.RegistryLoader @
> > anonymous::error_loading_registries:
> >
> > [java] java.lang.NullPointerException
> >
> > [java] at org.dspace.storage.rdbms.TableRow.canonicalize
> > (TableRow.java:611)
> >
> > [java] at org.dspace.storage.rdbms.TableRow.hasColumn
> > (TableRow.java:110)
> >
> > [java] at org.dspace.storage.rdbms.TableRow.setColumn
> > (TableRow.java:466)
> >
> > [java] at org.dspace.storage.rdbms.DatabaseManager.insert
> > (DatabaseManager.java:589)
> >
> > [java] at org.dspace.storage.rdbms.DatabaseManager.create
> > (DatabaseManager.java:384)
> >
> > [java] at org.dspace.content.BitstreamFormat.create
> > (BitstreamFormat.java:400)
> >
> > [java] at org.dspace.administer.RegistryLoader.loadFormat
> > (RegistryLoader.java:203)
> >
> > [java] at
> > org.dspace.administer.RegistryLoader.loadBitstreamFormats
> > (RegistryLoader.java:169)
> >
> > [java] at org.dspace.administer.RegistryLoader.main
> > (RegistryLoader.java:107)
> >
> >
> >
> > BUILD FAILED
> >
> > /usr/local/dspace_test/dspace/target/dspace-1.5.0-build.dir/
> > build.xml:424: Java returned: 1
> >
> >
> >
> > Total time: 11 seconds
> >
> > ----------------------------------------------------------------------
> > ---
> > Check out the new SourceForge.net Marketplace.
> > It's the best place to buy or sell services for
> > just about anything Open Source.
> > http://ad.doubleclick.net/clk;164216239;13503038;w?http://sf.net/
> > marketplace_______________________________________________
> > DSpace-tech mailing list
> > [email protected]
> > https://lists.sourceforge.net/lists/listinfo/dspace-tech
>
>
> -------------------------------------------------------------------------
> Check out the new SourceForge.net Marketplace.
> It's the best place to buy or sell services for
> just about anything Open Source.
> http://ad.doubleclick.net/clk;164216239;13503038;w?http://sf.net/marketplace
> _______________________________________________
> DSpace-tech mailing list
> [email protected]
> https://lists.sourceforge.net/lists/listinfo/dspace-tech
>
-------------------------------------------------------------------------
Check out the new SourceForge.net Marketplace.
It's the best place to buy or sell services for
just about anything Open Source.
http://ad.doubleclick.net/clk;164216239;13503038;w?http://sf.net/marketplace
_______________________________________________
DSpace-tech mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/dspace-tech
