Return-Path: X-Original-To: apmail-jackrabbit-dev-archive@www.apache.org Delivered-To: apmail-jackrabbit-dev-archive@www.apache.org Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by minotaur.apache.org (Postfix) with SMTP id 720297101 for ; Tue, 4 Oct 2011 02:37:58 +0000 (UTC) Received: (qmail 75068 invoked by uid 500); 4 Oct 2011 02:37:58 -0000 Delivered-To: apmail-jackrabbit-dev-archive@jackrabbit.apache.org Received: (qmail 74873 invoked by uid 500); 4 Oct 2011 02:37:58 -0000 Mailing-List: contact dev-help@jackrabbit.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: dev@jackrabbit.apache.org Delivered-To: mailing list dev@jackrabbit.apache.org Received: (qmail 74857 invoked by uid 99); 4 Oct 2011 02:37:57 -0000 Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136) by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 04 Oct 2011 02:37:57 +0000 X-ASF-Spam-Status: No, hits=3.0 required=5.0 tests=FORGED_YAHOO_RCVD,FREEMAIL_FROM,SPF_NEUTRAL,T_TO_NO_BRKTS_FREEMAIL,URI_HEX X-Spam-Check-By: apache.org Received-SPF: neutral (athena.apache.org: local policy) Received: from [216.139.236.26] (HELO sam.nabble.com) (216.139.236.26) by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 04 Oct 2011 02:37:52 +0000 Received: from joe.nabble.com ([192.168.236.139]) by sam.nabble.com with esmtp (Exim 4.72) (envelope-from ) id 1RAuss-0007n6-Rx for dev@jackrabbit.apache.org; Mon, 03 Oct 2011 19:37:30 -0700 Date: Mon, 3 Oct 2011 19:37:30 -0700 (PDT) From: yacur To: dev@jackrabbit.apache.org Message-ID: <1317695850846-3869765.post@n4.nabble.com> Subject: Jackrabbit 2.2.8 connection to MySQL 5.x MIME-Version: 1.0 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: quoted-printable After getting the right user/password in MySQL. Even though the app tries = to create some tables ( PM_SOMEUNIQUEPREFIX_NAMES, pm_someuniqueprefixes_binval, pm_someuniqueprefixes_bundlw, pm_someuniqueprefixes_ref )=20 when running the test case, I get the following exception: Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException: Duplicate entry '=C3=8A?=C2=BA?=C3=8A?=C2=BA?=C3=8A?=C2=BA?=C3=8A?=C2=BA?' = for key 'PM_SOMEUNIQUEPREFIX_BUNDLE_IDX' =09at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) =09at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAcce= ssorImpl.java:39) =09at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstru= ctorAccessorImpl.java:27) =09at java.lang.reflect.Constructor.newInstance(Constructor.java:513) =09at com.mysql.jdbc.Util.handleNewInstance(Util.java:406) =09at com.mysql.jdbc.Util.getInstance(Util.java:381) =09at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1015) =09at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:956) =09at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3491) =09at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3423) =09at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1936) =09at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2060) =09at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2542) =09at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:173= 4) =09at com.mysql.jdbc.PreparedStatement.execute(PreparedStatement.java:995) =09 *Anyone has any idea or has come across this exception before?????* -- View this message in context: http://jackrabbit.510166.n4.nabble.com/Jackra= bbit-2-2-8-connection-to-MySQL-5-x-tp3869765p3869765.html Sent from the Jackrabbit - Dev mailing list archive at Nabble.com.