Hi, On 29.06.2010 17:24, C N Davies wrote: > 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!
I already tried to fiddle around with maxTableNameLenght, but setting it to values less than 30, results in the same problem, since the table names are truncated to the value set there, but the check includes the schema name again, so that it exceeds the value. Setting it to larger values led to the problem that the tablenames were too large for the Oracle database to store them (ORA-00972: identifier is too long). > -----Original Message----- > From: Donald Woods [mailto:[email protected]] > Sent: Wednesday, 30 June 2010 12:47 AM > To: [email protected] > Subject: Re: Table name too long > > Which version of Oracle and the JDBC driver are you using? The Oracle version is 10.2.0.1.0 JDBC drivers 10.2.0.1.0 as suggested by the documentation, but I also tried 11.2.0.1.0 and 10.2.0.4 with no success. Cheers, Joerg.
