Eclipse Community Forums: Jubula » 9000 Byte Classpath Causes - JdbcSQLException: Value too long for column ATTR

Home » Archived » Jubula » 9000 Byte Classpath Causes - JdbcSQLException: Value too long for column ATTR_VALUE VARCHAR(4000)

9000 Byte Classpath Causes - JdbcSQLException: Value too long for column ATTR_VALUE VARCHAR(4000) [message #717226]

Fri, 19 August 2011 12:11

Eclipse User

I'm trying to use Jubula to test a large Swing application. The classpath is 8000 bytes, which is too long to fit in the 4000 byte AUT_CONF_ATTR.ATTR_VALUE column defined by Jubula's
org.eclipse.jubula.client.core::org.eclipse.jubula.client.core.model.AUTConfigPO @CollectionTable annotation.

Oracle limits VARCHAR columns to 4000 bytes. Some possibly ways to support a long classpath value would be:

1. Use a different SQL data type

2. Use a different storage strategy that understands how to break a large value across multiple rows.

3. Use a different storage strategy that understands how to break a large value across multiple columns (wouldn't be unlimited like rows but could support storing >4000).

Has someone already opened an enhancement request for this kind of change to Jubula?

Brian

[Updated on: Fri, 19 August 2011 16:41] by Moderator

Re: 9000 Byte Classpath Causes - JdbcSQLException: Value too long for column ATTR_VALUE VARCHAR(4000 [message #717247 is a reply to message #717226]

Fri, 19 August 2011 13:36

Eclipse User

You can file a bug against Jubula with this request. We'll have to check if this is supported by JPA and EclipseLink.

There is a solution if you are using a JVM which supports the "-javaagent" option and the "_JAVAOPTIONS" environment variable. All Sun/Oracle JVMs since 1.5 will work, others might. Just start your AUT with a script or an executable wrapper and put this script/exec in the "Executable File Name" field in the "AUT configuration" dialog. This way your application is set up like on a normal start and the instrumentation is done by the agent.

HTH

Achim

Previous Topic:	tests case to log in
Next Topic:	jubula git repository corrupt? [false alarm, sorry]

Goto Forum:

-=] Back to Top [=-

Current Time: Tue Jul 22 21:14:47 EDT 2025

.:: Contact :: Home ::.

Breadcrumbs

Sign up to our Newsletter