Thank you for your help. The work around discussed at that JIRA issue
link sort of works for me.
The statement:
ALTER TABLE t DROP COLUMN c1
fails with the error message:
Syntax error: Encountered "DROP" at line 1, column 32.
I guess that means Derby doesn't support dropping columns yet.
I'l
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
conn
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
I think in this ca
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
"The length, precision, or scale attribute for column, or type mapping
'VARCHAR(100)' 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
I'm using derby 10.2.2.0
I created my table using syntax like:
CREATE TABLE bl.tablename (ID INTEGER, Name INTEGER, Value CHAR(40))
I need to make the "Value" column longer. According to the reference at:
http://db.apache.org/derby/docs/10.2/ref/rrefsqlj81859.html
I should use something like: