java - JDBC password encryption in SQL Anywhere 16 -


anyone know nice solution encrypt password in connectionstring?

when i'll go normal way sybase/sap tools can connect dbisql.exe @encrypted_config_file.cfg

in encrypted_config_file.cfg informations servername, user , password stored. can encyrpt file dbhide.exe. database server can connect without telling user real password.

anyone solution in java or c, in connection string option or parameter

--using jconn3.jar  drivermanager.registerdriver((driver) class.forname( "com.sybase.jdbc3.jdbc.sybdriver" ).newinstance() );  con = drivermanager.getconnection("jdbc:sybase:tds:hostname:port?servicename=servername", "user", "password"); 

from sybase info-center site, seems need following:

string url = "jdbc:sybase:tds:myserver:3697"; properties props = new properties(); props.put("encrypt_password ", “true”); props.put("jce_provider_class", "org.bouncycastle.jce.provider.bouncycastleprovider");  /* set additional connnection properties needed */ props.put("user", "xyz"); props.put("password", "123");  /*  connection */ connection con = drivermanager.getconnection(url, props); 

hopefully helpful.


Comments