Return-Path: Delivered-To: apmail-incubator-ibatis-user-java-archive@www.apache.org Received: (qmail 69833 invoked from network); 7 Apr 2005 14:15:06 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (209.237.227.199) by minotaur.apache.org with SMTP; 7 Apr 2005 14:15:06 -0000 Received: (qmail 26860 invoked by uid 500); 7 Apr 2005 14:15:05 -0000 Delivered-To: apmail-incubator-ibatis-user-java-archive@incubator.apache.org Received: (qmail 26844 invoked by uid 500); 7 Apr 2005 14:15:05 -0000 Mailing-List: contact ibatis-user-java-help@incubator.apache.org; run by ezmlm Precedence: bulk Reply-To: ibatis-user-java@incubator.apache.org List-Help: List-Unsubscribe: List-Post: List-Id: Delivered-To: mailing list ibatis-user-java@incubator.apache.org Received: (qmail 26831 invoked by uid 99); 7 Apr 2005 14:15:05 -0000 X-ASF-Spam-Status: No, hits=0.4 required=10.0 tests=DNS_FROM_RFC_ABUSE,HTML_60_70,HTML_MESSAGE,RCVD_BY_IP,SPF_HELO_PASS,SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (hermes.apache.org: domain of larry.meadors@gmail.com designates 64.233.184.199 as permitted sender) Received: from wproxy.gmail.com (HELO wproxy.gmail.com) (64.233.184.199) by apache.org (qpsmtpd/0.28) with ESMTP; Thu, 07 Apr 2005 07:15:03 -0700 Received: by wproxy.gmail.com with SMTP id 36so715710wra for ; Thu, 07 Apr 2005 07:15:01 -0700 (PDT) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:reply-to:to:subject:in-reply-to:mime-version:content-type:references; b=JzUcPaBt1webf2yFMvRHcCRXtbVxzXLoX3WfJySJs4odUzkkUgig1bDhTNYuNdx42aMZXcGQGWW8XGorCNgq7FGT31MGLgTMocQkBDBMCCsYOxpbuVQbX3fjlvcMDkK7nURZCQxpQcao0m3jJsaOVLnQ+inMdL6bBVzqf1srfSQ= Received: by 10.54.47.52 with SMTP id u52mr969366wru; Thu, 07 Apr 2005 07:15:01 -0700 (PDT) Received: by 10.54.39.32 with HTTP; Thu, 7 Apr 2005 07:15:00 -0700 (PDT) Message-ID: Date: Thu, 7 Apr 2005 08:15:00 -0600 From: Larry Meadors Reply-To: lmeadors@apache.org To: ibatis-user-java@incubator.apache.org, Brandon Goodin Subject: Re: About MySQL Driver Properties in In-Reply-To: <2fe5ef5b0504070712435e7345@mail.gmail.com> Mime-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_860_15096839.1112883300820" References: <2fe5ef5b0504070712435e7345@mail.gmail.com> X-Virus-Checked: Checked X-Spam-Rating: minotaur.apache.org 1.6.2 0/1000/N ------=_Part_860_15096839.1112883300820 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Content-Disposition: inline that used to work in 1.x, but i have not tried it in 2.x > On Apr 7, 2005 3:59 AM, Akihiro Kubota = =20 > wrote: > > > > > > > > > > > > > > > > > > > > > value=3D"jdbc: > mysql://localhost:3306/exam?zeroDateTimeBehavior=3DconvertToNull" > > /> > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > As you can see the BOLD part of the mysqlconfig.xml file. > > > > > > > > Is there a way for the transactionManager to include properties specifi= c=20 > to > > the > > > > database? > > > > > > > > For example like : > > > > > > > > ... > > > > > > > > > value=3D"jdbc:mysql://localhost:3306/exam? "/> > > > > > value=3D"convertToNull"/> > > > > > > > > > > > > > > > > I will really appreciate for this kind of change. > > > > > > > > Thanks! > > > > > > > > > > > > > ------=_Part_860_15096839.1112883300820 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Content-Disposition: inline that used to work in 1.x, but i have not tried it in 2.x


On Apr 7, 2005 3:59 AM, Akihiro Kubota <Akihiro.Kubota@asia.bigfoot.com> = wrote:
>
>
>
> <transactionManager type=3D"= JDBC">
>
>       &nb= sp;   <dataSource type=3D"SIMPLE">
>
>= ;            &n= bsp;   <property name=3D"JDBC.Driver" value=3D"com.mysql.jdbc.Driver" /&= gt;
>
>         &n= bsp; <property name=3D"JDBC.ConnectionURL"
> value=3D&qu= ot;jdbc:mysql://localhost:3306/exam?zeroDateTimeBehavior=3DconvertToNull<= /a>"
> />
>
>      =           <property name=3D"JDBC.Username" value=3D"${username}" />
&= gt;
>          &nbs= p;     <property name=3D"JDBC.Password" value=3D"${password}" />
&= gt;
>          &nbs= p;     <property name=3D"JDBC.DefaultAutoCommit" value=3D"true"/>
= >
>          &nb= sp;     <property name=3D"Pool.MaximumActiveConnections" value=3D"15" /&g= t;
>
>         &nb= sp;      <property name=3D"Pool.MaximumIdleConnections" value=3D"15" />=
>
>          = ;      <property name=3D"Pool.MaximumWait" value=3D"1000" />
><= br>>           </da= taSource>
>
>      </transa= ctionManager>
>
>
>
> As you can see the BOLD pa= rt of the mysqlconfig.xml file.
>
>
>
> Is there a = way for the transactionManager to include properties specific to
> th= e
>
> database?
>
>
>
> For example lik= e :
>
>
>
>      &nbs= p;         ...
>
>=             &nb= sp;   <property name=3D"JDBC.Driver" value=3D"com.mysql.jdbc.Driver" /&= gt;
>
>         &n= bsp; <property name=3D"JDBC.ConnectionURL"
> value=3D&qu= ot;jdbc:mysql://localhost:3306/exam= ? "/>
>
>       =     <property name=3D"JDBC.Driver.zeroDateTimeBehavi= or"
> value=3D"convertToNull"/>
>
>&nbs= p;            &= nbsp;  <property name=3D"JDBC.Username" value=3D"${username}" />
&= gt;
>          &nbs= p;     <property name=3D"JDBC.Password" value=3D"${password}" />
&= gt;
>
>
> I will really appreciate for this kind of chang= e.
>
>
>
> Thanks!
>
>
>
><= br>>
>

------=_Part_860_15096839.1112883300820--