Mailing-List: contact torque-user-help@db.apache.org; run by ezmlm
Precedence: bulk
Reply-To: "Apache Torque Users List" <torque-user@db.apache.org>
Received-SPF: pass (athena.apache.org: domain of shinkan@gmail.com designates
 66.249.92.175 as permitted sender)
DomainKey-Signature: a=rsa-sha1; c=nofws;
        d=gmail.com; s=gamma;
        h=message-id:date:from:to:subject:mime-version:content-type;
        b=T0h8DreLRT6ihBqtR7vF70i69ghamTgJzTr8SDNOMdeUB4ehcSbGQCyp30+2kYKlrV
         FXZtUQSuO/GfjRYjKakHpKeFytEmE2VYAOq7C8yFJkFfQysPvNjnzctdUl7IKKnBirom
         H9ywRc4ErWj6ZJGr7h2A5peeKwC+KchForTWw=
Message-ID: <166af1cf0808280200g1e3c93d7j711e9bbf99311720@mail.gmail.com>
Date: Thu, 28 Aug 2008 11:00:09 +0200
From: Shinkan <shinkan@gmail.com>
To: "Apache Torque Users List" <torque-user@db.apache.org>
Subject: Programatically set torque.dsfactory.<MY_BASE>.connection.url
MIME-Version: 1.0
Content-Type: multipart/alternative;
	boundary="----=_Part_1652_4833991.1219914009875"

------=_Part_1652_4833991.1219914009875
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

Hi everybody !

I encounter a quite disturbing problem with Torque.
I use it over Apache Derby, and I need to set a password encrypted secure
connection to my Derby base.
So the resulting JDBC connection line is something like :
"jdbc:derby:mybase;dataEncryption=true;bootPassword=mypass"
Due to obvious security reason, I CAN NOT put this connection string on a
config file for my app, or everybody would be able to read the pass, and
connect to the base using other ways that my application plans to.
So I MUST define the "torque.dsfactory.mybase.connection.url" somewhere else
than in "Torque.properties".

I tried this :
Torque.init(_torquePropertiesPath);
Torque.getConfiguration().setProperty("torque.dsfactory.mybase.connection.url",
_secureConnectionString);

But later in my app, when I use SomeTablePeer::retrieveByPk( ... );
Torque throws an SQLException error, pretending that "The url cannot be
null".
So I deduce this is because the "setProperty" doesn't set the
torque.dsfactory.mybase.connection.url correctly ...
If I put the connection string in Torque.properties, everything is OK. BUT I
CAN NOT.
So I would like to know how to proceed to set this connection.url without
using config files ...

Thanks in advance everyone !

-- 
Pierre.
Some people, when confronted with a problem, think "I know, I'll use XML".
Now they have two problems. -- Jamie Zawinski / James Robertson

------=_Part_1652_4833991.1219914009875--