openjpa-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "C N Davies" <...@cndavies.com>
Subject RE: Table name too long
Date Tue, 29 Jun 2010 15:24:56 GMT
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] 
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örg Knoche wrote:
> Hello,
> 
> I think I have a problem related to Bug 866. I am using an Oracle 
> database and I'm getting the following Exception during the SchemaTool:
> 
> org.apache.openjpa.util.UserException: Table name 
> "TEST.DIAGNOSTIC_AVRDATA_SEGMENTEDAR" is 35-character long. The 
> database allows maximum 30-character for a table name.
> at
> org.apache.openjpa.jdbc.sql.DBDictionary.checkNameLength(DBDictionary.
> java:5215)
> 
> at
> org.apache.openjpa.jdbc.sql.DBDictionary.getCreateTableSQL(DBDictionar
> y.java:3304)
> 
> at
> org.apache.openjpa.jdbc.sql.OracleDictionary.getCreateTableSQL(OracleD
> ictionary.java:899)
> 
> 
> 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 
> name, so that in total the Table name is seen as too long. I am using 
> the
> 2.0.0 release of OpenJPA, but I also tried the 1.3.0 and 2.1.0 
> snapshots which showed the same behaviour.
> 
> Hoping for hints how to solve this.
> 
> Cheers,
> Joerg.
> 


Mime
View raw message