Return-Path: X-Original-To: apmail-openjpa-users-archive@minotaur.apache.org Delivered-To: apmail-openjpa-users-archive@minotaur.apache.org Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by minotaur.apache.org (Postfix) with SMTP id B3EE417287 for ; Mon, 2 Feb 2015 18:21:40 +0000 (UTC) Received: (qmail 51258 invoked by uid 500); 2 Feb 2015 18:21:38 -0000 Delivered-To: apmail-openjpa-users-archive@openjpa.apache.org Received: (qmail 51215 invoked by uid 500); 2 Feb 2015 18:21:38 -0000 Mailing-List: contact users-help@openjpa.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: users@openjpa.apache.org Delivered-To: mailing list users@openjpa.apache.org Received: (qmail 51203 invoked by uid 99); 2 Feb 2015 18:21:38 -0000 Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136) by apache.org (qpsmtpd/0.29) with ESMTP; Mon, 02 Feb 2015 18:21:38 +0000 X-ASF-Spam-Status: No, hits=1.7 required=5.0 tests=FREEMAIL_ENVFROM_END_DIGIT,HTML_MESSAGE,RCVD_IN_DNSWL_LOW,SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (athena.apache.org: domain of solomax666@gmail.com designates 209.85.220.50 as permitted sender) Received: from [209.85.220.50] (HELO mail-pa0-f50.google.com) (209.85.220.50) by apache.org (qpsmtpd/0.29) with ESMTP; Mon, 02 Feb 2015 18:21:32 +0000 Received: by mail-pa0-f50.google.com with SMTP id rd3so85298680pab.9 for ; Mon, 02 Feb 2015 10:20:27 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20120113; h=mime-version:in-reply-to:references:date:message-id:subject:from:to :content-type; bh=NR7zRpmyb8VUzVTXo/PwEpFLudpNMoD/MBZOCL+EEho=; b=ItCYxSvg6SI+lJYf4JdamPAznq5KawJwynpryz24/7RPu0ULLGnsBYnDdg4i1pvdlz n4/r5yeYhKcEOf+iNr7S56degevkCt6YGO/LUwOdcYeM0zGlJ68DYTnaRfGc1I3HHpgX xCtRFJvOzcpRJCTIe7iXwjN4mcfndg0ojjXJJ7PxRGb/UhQGeabZWmnkpY5TSd1txcqt 5UrtFnxcJu87aElxzgUFo7VkkZ9UccQysetd688I3XhEffHY8iNfXDM6JMZCzfl+JTXO +hWgXgiC8cmrFnyi+atyCVj0ZpNbicer4FRhn12hPEYETIZxRbaZOAYhAnL45ta+eyq0 zZew== MIME-Version: 1.0 X-Received: by 10.68.197.161 with SMTP id iv1mr31411811pbc.147.1422901227066; Mon, 02 Feb 2015 10:20:27 -0800 (PST) Received: by 10.66.48.65 with HTTP; Mon, 2 Feb 2015 10:20:27 -0800 (PST) In-Reply-To: References: Date: Tue, 3 Feb 2015 01:20:27 +0700 Message-ID: Subject: Re: Huge String DB mapping From: Maxim Solodovnik To: users@openjpa.apache.org Content-Type: multipart/alternative; boundary=e89a8ff1cac830b593050e1f02e7 X-Virus-Checked: Checked by ClamAV on apache.org --e89a8ff1cac830b593050e1f02e7 Content-Type: text/plain; charset=UTF-8 Thanks for helping The problem was in JAVA version and it seems build without tests not working I have created the issue [1] and attached the patch for 2.3.x [1] https://issues.apache.org/jira/browse/OPENJPA-2567 On Sun, Feb 1, 2015 at 12:46 AM, Rick Curtis wrote: > Sorry about the slow reply.I'm fairly certain the problem is due to you > skipping to install the tests. To compile openjpa-persistence-locking it > requires org.apache.openjpa:openjpa-persistence-jdbc:jar:tests, but you > skipped installing that thing. Try to run mvn install ... it'll take a long > time, but that should do the trick. > > Thanks, > Rick > > On Thu, Jan 29, 2015 at 1:14 AM, Maxim Solodovnik > wrote: > > > Hello Rick, > > > > I tried to get and build sources to contribute but failed :( > > can you help me to resolve build errors? Or I need to write to dev@ > list? > > > > tried to build both trunk and branches/2.3.x > > > > mvn clean install -Dmaven.test.skip=true -DskipTests > > > > [ERROR] Failed to execute goal on project openjpa-persistence-locking: > > Could not resolve dependencies for project > > org.apache.openjpa:openjpa-persistence-locking:jar:2.3.1-SNAPSHOT: > Failure > > to find > > org.apache.openjpa:openjpa-persistence-jdbc:jar:tests:2.3.1-SNAPSHOT in > > http://repository.apache.org/snapshots was cached in the local > repository, > > resolution will not be reattempted until the update interval of > > apache.snapshots has elapsed or updates are forced -> [Help 1] > > > > mvn -version > > Apache Maven 3.2.3 > > > > java -version > > java version "1.7.0_72" > > Java(TM) SE Runtime Environment (build 1.7.0_72-b14) > > > > Thanks in advance > > > > On Wed, Jan 28, 2015 at 1:52 AM, Rick Curtis wrote: > > > > > > Are there any plans to add it? > > > No.... that being said this is open source and all of the source is > > > available[1]. > > > > > > I'll note that the MySQL dictionary has similar support for different > > blob > > > types[2], but not for String types. If you wanted to make a change for > > all > > > supported databases that would be a larger effort that just adding > > support > > > for MySQL. > > > > > > Good luck! > > > > > > Thanks, > > > Rick > > > > > > [1] http://openjpa.apache.org/source-code.html > > > [2] org.apache.openjpa.jdbc.sql.MySQLDictionary > > > > > > > > > > > > .getTypeName > > > > > > On Tue, Jan 27, 2015 at 1:44 PM, Maxim Solodovnik < > solomax666@gmail.com> > > > wrote: > > > > > > > Are there any plans to add it? Or maybe some other way like: > > > > @Lob(type=MEDIUM) > > > > > > > > WBR, Maxim > > > > (from mobile, sorry for the typos) > > > > On Jan 28, 2015 1:37 AM, "Rick Curtis" wrote: > > > > > > > > > It doesn't appear that there is support to take the column size > into > > > > > account when determining the type of a String field. > > > > > > > > > > On Tue, Jan 27, 2015 at 1:17 PM, Maxim Solodovnik < > > > solomax666@gmail.com> > > > > > wrote: > > > > > > > > > > > Mediumtext for MySQL, and something similar for other databases > we > > > > > > currently supporting :) > > > > > > > > > > > > WBR, Maxim > > > > > > (from mobile, sorry for the typos) > > > > > > On Jan 28, 2015 1:16 AM, "Rick Curtis" > wrote: > > > > > > > > > > > > > What is the column type that you want OpenJPA to map your > String > > > to? > > > > > > > > > > > > > > On Tue, Jan 27, 2015 at 12:53 PM, Maxim Solodovnik < > > > > > solomax666@gmail.com > > > > > > > > > > > > > > wrote: > > > > > > > > > > > > > > > Hello All, > > > > > > > > > > > > > > > > I'm trying to map Huge string to the DB: > > > > > > > > > > > > > > > > public static final int MAX_LOG_SIZE = 1 * 1024 * 1024; > > > > > > > > @Lob > > > > > > > > @Column(name="ful_message", length = MAX_LOG_SIZE) > > > > > > > > private String fullMessage; > > > > > > > > > > > > > > > > Unfortunately I get column of type TEXT in my MySQL database > :( > > > > (64K > > > > > > max) > > > > > > > > > > > > > > > > I tried to remove @Lob annotation, no luck > > > > > > > > > > > > > > > > OpenJPA 2.3.0 > > > > > > > > > > > > > > > > Am I doing something wrong? Or it is bug in OpenJPA? > > > > > > > > > > > > > > > > Thanks in advance! > > > > > > > > > > > > > > > > > > > > > > > > -- > > > > > > > > WBR > > > > > > > > Maxim aka solomax > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > -- > > > > > > > *Rick Curtis* > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > -- > > > > > *Rick Curtis* > > > > > > > > > > > > > > > > > > > > > -- > > > *Rick Curtis* > > > > > > > > > > > -- > > WBR > > Maxim aka solomax > > > > > > -- > *Rick Curtis* > -- WBR Maxim aka solomax --e89a8ff1cac830b593050e1f02e7--