Return-Path: 
 <dev-return-14989-apmail-openjpa-dev-archive=openjpa.apache.org@openjpa.apache.org>
Delivered-To: apmail-openjpa-dev-archive@www.apache.org
Received: (qmail 8708 invoked from network); 9 Feb 2010 14:04:29 -0000
Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.3)
  by minotaur.apache.org with SMTP; 9 Feb 2010 14:04:29 -0000
Received: (qmail 24827 invoked by uid 500); 9 Feb 2010 14:04:29 -0000
Delivered-To: apmail-openjpa-dev-archive@openjpa.apache.org
Received: (qmail 24782 invoked by uid 500); 9 Feb 2010 14:04:29 -0000
Mailing-List: contact dev-help@openjpa.apache.org; run by ezmlm
Precedence: bulk
List-Help: <mailto:dev-help@openjpa.apache.org>
List-Unsubscribe: <mailto:dev-unsubscribe@openjpa.apache.org>
List-Post: <mailto:dev@openjpa.apache.org>
List-Id: <dev.openjpa.apache.org>
Reply-To: dev@openjpa.apache.org
Delivered-To: mailing list dev@openjpa.apache.org
Received: (qmail 24619 invoked by uid 99); 9 Feb 2010 14:04:28 -0000
Received: from nike.apache.org (HELO nike.apache.org) (192.87.106.230)
    by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 09 Feb 2010 14:04:28 +0000
X-ASF-Spam-Status: No, hits=1.2 required=10.0
	tests=SPF_NEUTRAL,UNPARSEABLE_RELAY
X-Spam-Check-By: apache.org
Received-SPF: neutral (nike.apache.org: local policy)
Received: from [76.13.13.40] (HELO smtp101.prem.mail.ac4.yahoo.com)
 (76.13.13.40)
    by apache.org (qpsmtpd/0.29) with SMTP; Tue, 09 Feb 2010 14:04:20 +0000
Received: (qmail 64668 invoked from network); 9 Feb 2010 14:03:59 -0000
Received: from cpe-174-099-058-061.nc.res.rr.com (dwoods@174.99.58.61 with
 plain)
        by smtp101.prem.mail.ac4.yahoo.com with SMTP;
 09 Feb 2010 06:03:59 -0800 PST
X-Yahoo-SMTP: sCI.ryiswBB7FW.DxjU523c87MI-
X-YMail-OSG: 
 IhA_LSMVM1n4k9J.tzSoV70JF4U4tI_lxHcL0.u7sW.T8xgRU414G0fGqNqPRimyyHgJUZfnRa.WmhXy6Aa4cuSM91Lv80QcLzvyUF6.N2fPFM31xHwwsrfwC7qpHLHdgfTzqmoTbKB.K0uFRSpp_7jPkywJhkg7hJhrqEpGIblQnRSmtktLtKuhC0QVsR4LMJgOgwIXcaj.yeqDbvtXiKef1Ov8cxGezQoG4yJiurRgXyKb5akfKlIrSt7s32sIDRqF4uEQ4yqUMgeZrTfLzaXl_Mg-
X-Yahoo-Newman-Property: ymail-3
Message-ID: <4B716B4E.7000704@apache.org>
Date: Tue, 09 Feb 2010 09:03:58 -0500
From: Donald Woods <dwoods@apache.org>
User-Agent: Mozilla/5.0 (Macintosh; U; Intel Mac OS X 10.6; en-US;
 rv:1.9.1.7) Gecko/20100111 Lightning/1.0b1 Thunderbird/3.0.1
MIME-Version: 1.0
To: dev@openjpa.apache.org, srinivasulu.kristnam@fs.mphasis.com
Subject: Re: While connecting MySql Server i am getting the Error For input
 string: "JDBC"
References: <1265717964896-4540703.post@n2.nabble.com>
In-Reply-To: <1265717964896-4540703.post@n2.nabble.com>
X-Enigmail-Version: 1.0.1
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
X-Virus-Checked: Checked by ClamAV on apache.org

Are you trying to connect to a Microsoft SQL Server or a MySQL server?
Your email says MySQL, but the error message shows you are trying to use
the Microsoft SQL Server driver....

For MySQL, you would use -
<property name="openjpa.ConnectionDriverName"
value="com.mysql.jdbc.Driver"/>
<property name="openjpa.ConnectionURL"
value="jdbc:mysql://<SERVER_NAME>/<DB_NAME>"/>

where <SERVER_NAME> is the IP Address of your MySQL server and <DB_NAME>
is the DB name to connect to.



-Donald


On 2/9/10 7:19 AM, SreeAsh wrote:
> 
> Hi ,
> 
>   I am new to the JPA, I am using the MySql Server to OpenJPa, while
> connecting to the databse throwing the following error.
> 
> 
> <openjpa-1.2.0-r422266:683325 fatal user error>
> org.apache.openjpa.util.UserException: A connection could not be obtained
> for driver class "com.microsoft.sqlserver.jdbc.SQLServerDriver" and URL
> "jdbc:sqlserver://host\port;databaseName=MyDataBase".  You may have
> specified an invalid URL.
> Error For input string: "JDBC" and in
> 
> pelase see the persistence.xml file
> 
> <persistence-unit name="TestJpaPU" transaction-type="RESOURCE_LOCAL">
>    
> <provider>org.apache.openjpa.persistence.PersistenceProviderImpl</provider>
>     <class>com.test.jpa.TblCustAddress</class>
>     <class>com.test.jpa.TblCustContact</class>
>     <class>com.test.jpa.TblCustomer</class>
>     <properties>
>       <property name="openjpa.ConnectionUserName" value="user"/>
>       <property name="openjpa.ConnectionPassword" value="pass"/>
>       <property name="openjpa.ConnectionURL"
> value="jdbc:sqlserver://host\port;databaseName=Mydatabase"/>
>       <property name="openjpa.ConnectionDriverName"
> value="com.microsoft.sqlserver.jdbc.SQLServerDriver"/>
>     </properties>
>   </persistence-unit>
> 
> please help me to fix this issue....
> 
> regsrds
> Srini