Hallo Jan Marco,
Bedankt voor je antwoord. Ik zou graag e.e.a. uitzoeken voor MSSQL en m’n bevindingen ook plaatsen hier, probleem is alleen dat ik niet weet waar ik zou moeten beginnen omdat de foutmeldingen me weinig zeggen. Wat ze me zeggen is dat het met java te maken heeft (als ik het goed begrepen heb, waarin foondump geschreven is).
Bijvoorbeeld de eerste melding:
java.lang.ArrayIndexOutOfBoundsException
Het enige wat mij dit zegt (en dat kan natuurlijk helemaal fout zijn) is dat er een bug in foondump zit, omdat een array verkeerd gevuld wordt (index out of bound betekent voor mij dat je bijvoorbeeld een 11e element in een array van 10 groot probeert te stoppen).
Nu zou het best zo kunnen zijn dat dit niet zozeer een bug is, als wel het gevolg van een verkeerd ingericht MSSQL database… maar er is helemaal geen informatie voorhanden wát dan fout is.
Zoals ik al zei, de table layout heb ik gekopieerd van de MySQL query. Hier is de MSSQL script:
[quote]CREATE TABLE [dbo].[fd_metadata] (
[metaname] [varchar] (32) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
[metavalue] [varchar] (32) COLLATE SQL_Latin1_General_CP1_CI_AS NULL
) ON [primary]
GO
CREATE TABLE [dbo].[fs_town_street] (
[townname] [varchar] (32) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
[streetname] [varchar] (64) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL
) ON [primary]
GO
CREATE TABLE [dbo].[fs_towns] (
[townname] [varchar] (32) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL
) ON [primary]
GO
CREATE TABLE [dbo].[gis_gifinfo] (
[seqno] [int] NOT NULL ,
[scale] [int] NOT NULL ,
[x_low] [int] NOT NULL ,
[y_low] [int] NOT NULL ,
[x_hi] [int] NOT NULL ,
[y_hi] [int] NOT NULL
) ON [primary]
GO
CREATE TABLE [dbo].[gis_postalcoords] (
[id] [int] NOT NULL ,
[postalcode] [varchar] (6) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[rd_x] [int] NOT NULL ,
[rd_y] [int] NOT NULL
) ON [primary]
GO
CREATE TABLE [dbo].[pink_categories] (
[catid] [int] NOT NULL ,
[category] [varchar] (96) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL
) ON [primary]
GO
CREATE TABLE [dbo].[pink_info] (
[id] [int] NOT NULL ,
[lineno] [int] NOT NULL ,
[recno] [int] NOT NULL ,
[type] [int] NULL ,
[infovalue] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL
) ON [primary]
GO
CREATE TABLE [dbo].[pink_phonenumbers] (
[id] [int] NOT NULL ,
[phonenumber] [varchar] (24) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
[type] [int] NOT NULL
) ON [primary]
GO
CREATE TABLE [dbo].[pink_subscriber] (
[id] [int] NOT NULL ,
[fullname] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[streetname] [varchar] (64) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[streetnameextension] [varchar] (8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[housenumber] [varchar] (8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[housenumberextension] [varchar] (32) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[residence] [char] (2) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[postalcode] [varchar] (9) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[townname] [varchar] (32) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[areacode] [varchar] (8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[subscribernumber] [varchar] (16) COLLATE SQL_Latin1_General_CP1_CI_AS NULL
) ON [primary]
GO
CREATE TABLE [dbo].[pink_subscribercategories] (
[catid] [int] NOT NULL ,
[subid] [int] NOT NULL
) ON [primary]
GO
CREATE TABLE [dbo].[pink_unique] (
[md5] [char] (32) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
[id] [int] NULL
) ON [primary]
GO
CREATE TABLE [dbo].[white_info] (
[id] [int] NOT NULL ,
[lineno] [int] NOT NULL ,
[recno] [int] NOT NULL ,
[type] [int] NULL ,
[infovalue] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL
) ON [primary]
GO
CREATE TABLE [dbo].[white_phonenumbers] (
[id] [int] NOT NULL ,
[phonenumber] [varchar] (24) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
[type] [int] NOT NULL
) ON [primary]
GO
CREATE TABLE [dbo].[white_subscriber] (
[seq] [int] IDENTITY (1, 1) NOT NULL ,
[id] [int] NULL ,
[lastname] [varchar] (128) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[fullname] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[streetname] [varchar] (64) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[streetnameextension] [varchar] (8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[housenumber] [varchar] (8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[housenumberextension] [varchar] (32) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[residence] [char] (2) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[postalcode] [varchar] (9) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[townname] [varchar] (32) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[areacode] [varchar] (8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[subscribernumber] [varchar] (16) COLLATE SQL_Latin1_General_CP1_CI_AS NULL
) ON [primary]
GO[/quote]