InstantDB Project
About InstantDB
Project Mail Lists
Short History
Reporting Bugs
Screen Shots
3rd Party Examples
FAQs

Software
Downloads
Documentation
CVS Repositories
Roadmap
License

About Enhydra.org
Who We Are
News, Articles & Events
Getting Involved
Contact Us

Community
Demos
Contributions
Resources
Case Studies
On The Edge! -NEW-
Commercial Vendors

Eric

Thanks very much for putting this together for me. I can repduce the 
problem now and think I'm on the track of it. I'll be in touch again 
shortly.

Pete

----- Original Message -----
From: Eric Mackem <mackem@mitre.org>
Date: Thursday, January 11, 2001 1:32 pm
Subject: Re: InstantDB: Illegal string size errors

> Hi Peter,
> 
> Thanks for the test script.  I was initially also unable to reproduce
> the error,
> but finally ran into it under the conditions noted below.  Adding a
> BUFFER
> statement of any size at the end of the IMPORT statement prevents the
> error from
> occuring.
> 
> Here is the error message:
> 
> Enhydra InstantDB - Version 3.25
> The Initial Developer of the Original Code is Lutris Technologies Inc.
> Portions created by Lutris are Copyright (C) 1997-2000 Lutris
> Technologies, Inc.
> 
> All Rights Reserved.
> 
> Connected to jdbc:idb:/home/mackem/dbtest/Examples/sample.prp
> Driver   InstantDB JDBC Driver
> Version  Version 3.25
> 
> mySql1.txt drop table airports
> mySql1.txt CREATE TABLE airports( facility_id CHAR(11) )
> mySql1.txt ALTER TABLE airports ADD type CHAR(13)
> mySql1.txt ALTER TABLE airports ADD airport_id CHAR(4)
> mySql1.txt ALTER TABLE airports ADD region CHAR(3)
> mySql1.txt ALTER TABLE airports ADD state_abbrev CHAR(2)
> mySql1.txt ALTER TABLE airports ADD latitude double
> mySql1.txt ALTER TABLE airports ADD longitude double
> mySql1.txt ALTER TABLE airports ADD elevation int
> mySql1.txt ALTER TABLE airports ADD mag_var int
> mySql1.txt IMPORT airports FROM "airports.txt" USING
> "airports_schema.txt"
> mySql1.txt CREATE INDEX airports_airport_id_Index ON airports
> (airport_id)
> mySql1.txt java.sql.SQLException: Problem reading column, 
> airport_id, in
> table,
> airports, java.lang.Exception: Illegal string size: 3538997
> mySql1.txt java.sql.SQLException: Problem reading column, 
> airport_id, in
> table,
> airports, java.lang.Exception: Illegal string size: 3538997
> java.sql.SQLException: Problem reading column, airport_id, in table,
> airports,
> java.lang.Exception: Illegal string size: 3538997
> at org.enhydra.instantdb.db.SQLProg.execute(SQLProg.java:276)
> at
> org.enhydra.instantdb.jdbc.idbStatement.execute(idbStatement.java:235)
> at
> org.enhydra.instantdb.jdbc.idbStatement.executeUpdate
(idbStatement.java:103)
> 
> at org.enhydra.instantdb.SampleThread.run(ScriptTool.java:459)
> at java.lang.Thread.run(Thread.java:484)
> mySql1.txt select * from airports
> mySql1.txt java.sql.SQLException: Problem reading column, facility_id,
> in table,
> airports, java.lang.Exception: Illegal string size: 1459639808
> java.sql.SQLException: Problem reading column, facility_id, in table,
> airports,
> java.lang.Exception: Illegal string size: 1459639808
> at org.enhydra.instantdb.db.SQLProg.execute(SQLProg.java:276)
> at
> org.enhydra.instantdb.jdbc.idbStatement.execute(idbStatement.java:235)
> at
> org.enhydra.instantdb.jdbc.idbStatement.executeQuery
(idbStatement.java:91)
> 
> at org.enhydra.instantdb.SampleThread.run(ScriptTool.java:591)
> at java.lang.Thread.run(Thread.java:484)
> mySql1.txt create index i1 on airports (airport_id)
> mySql1.txt java.sql.SQLException: Problem reading column, 
> airport_id, in
> table,
> airports, java.lang.Exception: Illegal string size: 3538997
> mySql1.txt java.sql.SQLException: Problem reading column, 
> airport_id, in
> table,
> airports, java.lang.Exception: Illegal string size: 3538997
> java.sql.SQLException: Problem reading column, airport_id, in table,
> airports,
> java.lang.Exception: Illegal string size: 3538997
> at org.enhydra.instantdb.db.SQLProg.execute(SQLProg.java:276)
> at
> org.enhydra.instantdb.jdbc.idbStatement.execute(idbStatement.java:235)
> at
> org.enhydra.instantdb.jdbc.idbStatement.executeUpdate
(idbStatement.java:103)
> 
> at org.enhydra.instantdb.SampleThread.run(ScriptTool.java:459)
> at java.lang.Thread.run(Thread.java:484)
> Database sample is shutting down...
> Database sample shutdown complete.
> 
> 
> 
> 
> This is the script I used:
> 
> 
> 
> d org.enhydra.instantdb.jdbc.idbDriver;
> o jdbc:idb:/home/mackem/dbtest/Examples/sample.prp;
> 
> 
> drop table airports;
> CREATE TABLE airports( facility_id CHAR(11) );
> ALTER TABLE airports ADD type CHAR(13);
> ALTER TABLE airports ADD airport_id CHAR(4);
> ALTER TABLE airports ADD region CHAR(3);
> ALTER TABLE airports ADD state_abbrev CHAR(2);
> ALTER TABLE airports ADD latitude double;
> ALTER TABLE airports ADD longitude double;
> ALTER TABLE airports ADD elevation int;
> ALTER TABLE airports ADD mag_var int;
> 
> 
> 
> IMPORT airports FROM "airports.txt" USING "airports_schema.txt";
> 
> 
> CREATE INDEX airports_airport_id_Index ON airports (airport_id);
> 
> q select * from airports;
> 
> 
> create index i1 on airports (airport_id);
> 
> 
> c close;
> c exit;
> 
> 
> 
> 
> Next is airports_schema.txt:
> 
> [airports.txt]
> ColNameHeader=False
> CharacterSet=ANSI
> Format=CSVDelimited
> Col1=facility_id CHAR(11)
> Col2=type CHAR(13)
> Col3=airport_id CHAR(4)
> Col4=region CHAR(3)
> Col5=state_abbrev CHAR(2)
> Col6=latitude long
> Col7=longitude long
> Col8=elevation int
> Col9=mag_var int
> 
> 
> Since  my airports.txt file is so long, I will only include a few 
> lines,but here are the first 10 lines of data, (out of 20, 000, 
> but I had
> troubles with using more than 630 .....but that is another message.)
> The script should produce the error if you have more than 550 
> lines of
> similar data.  Duplicating these lines should work.   I had included
> this email with an attachment for the data file a couple of days ago,
> but for some reason  that did not make it onto the message board.  The
> script worked OK with 500 or fewer lines.
> 
> "27099.*A","AIRPORT","50C","AGL","WI",43.329170277777784,-
> 87.9973125,875,-1
> 
> "27099.12*A","AIRPORT","WI62","AGL","WI",43.26945,-
> 87.99814527777778,800,-1
> 
> "27099.3*A","AIRPORT","75WI","AGL","WI",43.58888638888889,-
> 87.78425416666667,640,-2
> 
> "27099.55*A","AIRPORT","40WI","AGL","WI",44.05829555555555,-
> 91.43070222222222,750,2
> "27101.*A","AIRPORT","30WI","AGL","WI",45.19193055555555,-
> 87.35927777777778,588,-3
> 
> "27102.*A","AIRPORT","Y23","AGL","WI",45.306526388888884,-
> 91.63660027777779,1056,0
> "27102.01*A","AIRPORT","WS13","AGL","WI",45.31194444444444,-
> 91.58972222222222,1050,1
> "27106.2*A","AIRPORT","3WI9","AGL","WI",44.99996111111111,-
> 91.38348944444445,940,1
> "27106.21*A","AIRPORT","4WI0","AGL","WI",44.933295,-
> 91.27237416666667,936,1
> "27106.22*H","HELIPORT","WS47","AGL","WI",44.949683611111105,-
> 91.36098888888888,905,1
> "27111.*C","SEAPLANE
> BASE","7WI1","AGL","WI",46.158564166666665,-90.88434833333334,1456,1
> 
> 
> Hope this helps,
> 
> Eric
> 
> 
> -------------------------------------------------------------------
> ----------
> To unsubscribe from this mailing list, send email to 
> majordomo@enhydra.orgwith the text "unsubscribe instantdb" in the 
> body of the email.
> If you have other questions regarding this mailing list, send 
> email to
> the list admin at owner-instantdb@enhydra.org.
> 

-----------------------------------------------------------------------------
To unsubscribe from this mailing list, send email to majordomo@enhydra.org
with the text "unsubscribe instantdb" in the body of the email.
If you have other questions regarding this mailing list, send email to
the list admin at owner-instantdb@enhydra.org.