Wait a moment! I forgot about map files.
You could encrypt only sqlmap.config - AFAIK map files should be placed on
the disk. I don't know how it is possible to protect SQL statements from
user :(

> -----Original Message-----
> From: Alexey Boroday [mailto:[EMAIL PROTECTED] 
> Sent: Wednesday, January 12, 2005 3:37 PM
> To: ibatis-user-cs@incubator.apache.org
> Subject: RE: plaintext passwords and exposed sql in 
> configuration files
> 
> Hello
> 
>  I'm set up connection string manually - from application 
> configuration
> file. I store encrypted passwords in it. So in iBATIS file 
> connectionString
> attribute contains one space only.
> 
>  You could ask password at runtime and concatenate it with 
> the connection
> string. Connection string should be ready ;) (ends with 'password=')
>  ConnectionString could be set via 
> SqlMapper.DataSource.ConnectionString
> 
>  All SQL statements will be transferred via network in 
> plaintext AFAIK so
> you should not care about it security ;)
> 
>  But if you still want to be secure - encrypt iBATIS config 
> files before
> contribute it. You will need decrypt it in the runtime and 
> configure iBATIS
> with SqlMapper.Configure that takes XmlDocument as parameter.
> 
> Good luck
> 
> > -----Original Message-----
> > From: Pablo Lopez [mailto:[EMAIL PROTECTED] 
> > Sent: Wednesday, January 12, 2005 2:49 PM
> > To: ibatis-user-cs@incubator.apache.org
> > Subject: plaintext passwords and exposed sql in configuration files
> > 
> > Hi everybody,
> > 
> > I'm new in using iBatis and I've managed to make it up and running, 
> > providing excellent features.
> > 
> > But there's one problem that I've come across: the username 
> > and password 
> > used for the connection with the database are stored in plaintext, 
> > either in the sqlmap.config or in the providers.config 
> files, as also 
> > all the SQL is in the datamaps.


___________________________________________________________________________

This communication is confidential and may be legally privileged. 
If you believe you are not an intended recipient, please inform the sender, 
delete the e-mail and do not copy, print or use it or disclose it to others. 
You can inform the sender by replying to this e-mail or by telephone (+380 44 
4906080).


Reply via email to