Oracle repository error 'SQL error inserting text item'

Post any questions you have about using the Verj.io Studio, including client and server-side programming with Javascript or FPL, and integration with databases, web services etc.

Moderators: Jon, Steve, Ian, Dave

User avatar
Sarah
Ebase User
Posts: 63
Joined: Fri Sep 07, 2007 2:42 pm
Location: Sandy, UK
Contact:

Oracle repository error 'SQL error inserting text item'

#1

Postby Sarah » Wed Nov 14, 2007 6:03 pm

Error:

Importing a form with a field label containing more than 4000 characters failed on Oracle repository. "Error processing Import on item - SQL error inserting text item, Data size bigger than max size for this type: 4275"


Solution:

The zip file in the following link contains full instructions on how to:

1. Upgrade to the latest Oracle 10g jdbc driver, ojdbc14.jar
2. Amend the Oracle repository database table
3. Amend the datasource in the ufs.xml file
0 x

Who is online

Users browsing this forum: No registered users and 11 guests