Mailing-List: contact users-help@openjpa.apache.org; run by ezmlm
Precedence: bulk
Reply-To: users@openjpa.apache.org
Received-SPF: neutral (nike.apache.org: local policy)
Reply-To: <cnd@cndavies.com>
From: "C N Davies" <cnd@cndavies.com>
To: <users@openjpa.apache.org>
References: <4C29AE39.2080704@MPA-Garching.MPG.DE> <4C2A076F.80409@apache.org>
In-Reply-To: <4C2A076F.80409@apache.org>
Subject: RE: Table name too long
Date: Wed, 30 Jun 2010 01:24:56 +1000
Organization: C N Davies Pty Ltd
Message-ID: <01c101cb179f$3d4e1f40$b7ea5dc0$@cndavies.com>
MIME-Version: 1.0
Content-Type: text/plain;
	charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
Thread-Index: AQKqkg3Q+vS5u7PPmKrCVjNphEm/rQHpPByWkMrPfFA=
Content-Language: en-au

Looks like a defect but you can use the properties to set
openjpa.jdbc.DBDictionary  for  maxTableNameLength to set the maximum
length.  According to the doc the default is 128 characters but that's =
not
true!

Chris

-----Original Message-----
From: Donald Woods [mailto:dwoods@apache.org]=20
Sent: Wednesday, 30 June 2010 12:47 AM
To: users@openjpa.apache.org
Subject: Re: Table name too long

Which version of Oracle and the JDBC driver are you using?


-Donald


On 6/29/10 4:26 AM, J=F6rg Knoche wrote:
> Hello,
>=20
> I think I have a problem related to Bug 866. I am using an Oracle=20
> database and I'm getting the following Exception during the =
SchemaTool:
>=20
> org.apache.openjpa.util.UserException: Table name=20
> "TEST.DIAGNOSTIC_AVRDATA_SEGMENTEDAR" is 35-character long. The=20
> database allows maximum 30-character for a table name.
> at
> org.apache.openjpa.jdbc.sql.DBDictionary.checkNameLength(DBDictionary.
> java:5215)
>=20
> at
> org.apache.openjpa.jdbc.sql.DBDictionary.getCreateTableSQL(DBDictionar
> y.java:3304)
>=20
> at
> org.apache.openjpa.jdbc.sql.OracleDictionary.getCreateTableSQL(OracleD
> ictionary.java:899)
>=20
>=20
> The table name itself is cut off correctly after 30 characters, but it =

> seems that the check for the name length includes also the schema=20
> name, so that in total the Table name is seen as too long. I am using=20
> the
> 2.0.0 release of OpenJPA, but I also tried the 1.3.0 and 2.1.0=20
> snapshots which showed the same behaviour.
>=20
> Hoping for hints how to solve this.
>=20
> Cheers,
> Joerg.
>=20