Project

General

Profile

Bug #1774

TigPutDBProperty('schema-version','5.1') failing with derby

Added by Teemu K about 4 years ago. Updated almost 4 years ago.

Status:
Closed
Priority:
Normal
Target version:
Start date:
2014-03-11
Due date:
% Done:

100%

Estimated time:
Database:
n/a
Applicable version:
git/devel
Source Code Disclaimer:
Additional charges approved:
No

Description

I'm trying to create a derby database using the command:

sh scripts/db-create-derby.sh /path/to/my/db

Looking at the script output, everything seems to work correctly, except at the end:

@call TigPutDBProperty('schema-version','5.1');

ERROR 38000: The exception 'java.sql.SQLException: An attempt was made to get a data value of type 'LONG VARCHAR' from a data value of type 'java.sql.Clob'.' was thrown while evaluating an expression.

ERROR 22005: An attempt was made to get a data value of type 'LONG VARCHAR' from a data value of type 'java.sql.Clob'.@

Trying to run tigase-server then results in:

@Please upgrade database schema now.

Current scheme version is: null, expected: 5.1@

git: 3afdb62abc25140c17ec923a212c9d28ef41a1d7

Associated revisions

Revision 003a24eb (diff)
Added by Wojciech Kapcia Tigase team member almost 4 years ago

fix schema loader not shutting down derby database; fix issue with loading derby schema; fix #1774, related to #1717

History

#1 Avatar?id=6023&size=24x24 Updated by Artur Hefczyc Tigase team member about 4 years ago

  • Assignee set to Wojciech Kapcia

#2 Updated by Wojciech Kapcia Tigase team member almost 4 years ago

  • Target version set to tigase-server-7.0.0
  • Applicable version changed from 5.2.0-master to git/devel

#3 Updated by Wojciech Kapcia Tigase team member almost 4 years ago

  • Status changed from New to Closed
  • % Done changed from 0 to 100

Also available in: Atom PDF