Mailing-List: contact user-help@geronimo.apache.org; run by ezmlm
Precedence: bulk
Reply-To: user@geronimo.apache.org
Received-SPF: pass (nike.apache.org: local policy)
DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws;
  s=s1024; d=yahoo.com;
  h=Received:X-Yahoo-SMTP:X-YMail-OSG:X-Yahoo-Newman-Property:Content-Type:Mime-Version:Subject:From:In-Reply-To:Date:Content-Transfer-Encoding:Message-Id:References:To:X-Mailer;
  b=UT4BTcO7uiDrxIHga7dhehLNorRw/RAIWEWkFvmuQHpqGkWSYuJMLF+Ng48EKugGY9rCKxl0lH0Gm1hXcNsB0uIJQ3807BCPw7MuZEpCR1PCAUcKcwhXVFYHEFHMGFDboQuhLxgjxlM36MUbMRUnMH9FD5uuiOiwqLbiynOfjtE=
  ;
Content-Type: text/plain; charset=us-ascii
Mime-Version: 1.0 (Apple Message framework v1077)
Subject: Re: Additional Parameters using TranQL Local Resource Adapter and
 MySQL
From: David Jencks <david_jencks@yahoo.com>
In-Reply-To: <DB62191F-8C66-43BC-902D-80238BDD2448@yahoo.com>
Date: Tue, 27 Apr 2010 17:58:46 -0700
Content-Transfer-Encoding: quoted-printable
Message-Id: <E4DFC1D9-616E-47A0-96D2-014F6B359EE6@yahoo.com>
References: <4BD5E65C.7090408@weberhofer.at>
 <DB62191F-8C66-43BC-902D-80238BDD2448@yahoo.com>
To: user@geronimo.apache.org

The patch you sent privately doesn't seem to agree with the mysql driver =
I have here.  It also doesn't include the important bit, which is to =
have the MCF classes delegate to the appropriate datasource class from =
the driver.

You can set the properties whether or not they are listed in the ra.xml. =
 Hopefully the admin console is smart enough to find them, but if not =
you can just edit your plan by hand.

The postgres properties are already in recent tranql postgres wrappers.

I'm uploaded snapshots of the current tranql.  I'm hoping to release =
them tomorrow, if you can try them out that would be great.

They are at http://snapshots.repository.codehaus.org/

thanks
david jencks
On Apr 26, 2010, at 1:49 PM, David Jencks wrote:

> At the moment all the parameters have to be exposed as config =
properties through the tranql wrapper.  They don't have to be listed in =
ra.xml however.
>=20
> If you can come up with a patch to tranql quickly it will get released =
ASAP... I'm currently waiting for my codehaus credentials to get =
straightened out, then I will work on releasing tranql.
>=20
> thanks
> david jencks
>=20
> On Apr 26, 2010, at 12:15 PM, Johannes Weberhofer, Weberhofer GmbH =
wrote:
>=20
>> I have a question related to the Geronimo 2.2 MySQL connector:
>>=20
>> Is there a way to define additional connection-parameters for =
database-pools using the TranQL Local Resource Adapter? I need =
specifically the "characterEncoding=3Dutf8" parameter whilst connecting =
to a MySQL database. The JDBC connect-string looks like: =
jdbc:mysql://localhost/eusodanoe?characterEncoding=3Dutf8 .
>>=20
>> Another issue I have is how to enforce an SSL connection on the =
postgres driver ( =
?ssl=3Dtrue&sslfactory=3Dorg.postgresql.ssl.NonValidatingFactory ).
>>=20
>> I hope, somebody can help me!
>>=20
>> Best regards,
>> Johannes Weberhofer
>=20