JDBC datasource with password prompt

[huwtrimet.org]

I need to set up a JDBC datasource to connect to our secured PCI credit card database, people in the database group prefers me not saving the password in the JDBC datasource profile. 

What else could be the alternatives?

Can I have the report prompt for password during runtime?

 

Thanks in advance.

[huwtrimet.org]

Gurus, can you offer some insights on this?

[kitakura]

I could be wrong but I think you can.

 

1. Create a subreport

2. Main report's subreport properties, use Connection/Data Source Expression like below:

java.sql.DriverManager.getConnection("jdbc:oracle:thin:@//XXXXXX:1521/XXXX", "username", $P{param_password})

3. Make a Parameter "param_password" and set to always prompt

 

I have not tested it...

 

 

[swood]

Use a JNDI data source. The password will be on the server and not visible or editable on the screen.

 

 

Sherman

Jaspersoft

[huwtrimet.org]

Hi Sherman, Happy New Year to you!

 

I noticed the JDBC datasource password in the database table is encrypted, I want to know which filter is controlling the encryption, also can I choose SHA or MD5?

 

Thanks in advance

[swood]

There is the PasswordEncoder bean in WEB-INF/applicationContext-security.xml. It extends the Spring org.springframework.security.providers.encoding.PasswordEncoder class. You can see the options in WEB-INF/applicationContext-security.xml and in the Spring Javadoc.

 

 

Sherman

Jaspersoft