A bit more information if it helps.
I created the database using derby 10.1.1.0
I upgraded recently to 10.2.2.0
The upgrade process at:
http://www.us.apachecon.com/presentations/TH17/TH17%20-%20Apache%20Derby%2010.2.ppt
says to upgrade your database by passing "upgrade = true" as part of the
connection string which I did using the following:
Class.forName("org.apache.derby.jdbc.EmbeddedDriver");
Properties props = new Properties();
props.setProperty("create", "true");
props.setProperty("upgrade", "true");
Connection conn = DriverManager.getConnection("jdbc:derby:bx",
props);
Hopefully this is correct.
Alex.
Alex Moots wrote:
Thanks for the quick response, but the query:
ALTER TABLE bl.USERSPROPERTIES ALTER COLUMN Value SET DATA TYPE
CHAR(32000)
Still gives me the same error message:
The length, precision, or scale attribute for column, or type mapping
'CHAR(32000)' is not valid
The documentation at:
file:///D:/java/db-derby-10.2.2.0-bin/docs/html/ref/rrefsqlj13733.html
should probably be updated if CHAR's length is limited to ~32000.
Alex.
Bryan Pendleton wrote:
"The length, precision, or scale attribute for column, or type
mapping 'VARCHAR(1000000)' is not valid."
Varchar is definitely limited to 32 thousand bytes as its max length,
see: http://db.apache.org/derby/docs/dev/ref/rrefsqlj41207.html
If you really need a enormous length value, I think you need to
use a CLOB.
thanks,
bryan
--
Alex Moots www.BuilderLynx.com
Builder Lynx t: 416-425-2925 f: 416-425-4233
