Shiro Authn JDBC/JNDI example

ShiroAuthnLookup.java

/**
 * This is a psuedo java class to demonstrate how to pull user permissions from 
 * a JNDI java database connection.
 **/
public class ShiroAuthnLookup
{
  	private List<String> getPermissions(String userName) throws
		SQLException
	{
		try (Connection c = getJNDIConnection())
		{
			List<String> perms = new ArrayList<>();
			PreparedStatement stmt = c.prepareStatement("SELECT permission FROM permissions WHERE user_id = ?");
			stmt.setString(1, userName);

			ResultSet rs = stmt.executeQuery();

			while (rs.next())
			{
				perms.add(rs.getString(1));
			}
			log.debug("Returning permissions {} for {}", perms, userName);
			return perms;
		}
	}
  
  private Connection getJNDIConnection() throws SQLException
	{
		String jndiName = "jdbc/yourDbDS";

		Connection result = null;
		try
		{
			final Context initialContext = new InitialContext();

			log.trace("Looking up java:comp/env");
			Context dbContext = (Context) initialContext.lookup("java:comp/env");
			log.trace("comp details: {}", initialContext.list("java:comp/env"));
			log.trace("Looking up jdbc JNDI {}", jndiName);
			DataSource dataSource = (DataSource) dbContext.lookup(jndiName);

			if (dataSource != null)
			{
				result = dataSource.getConnection();
			}
			else
			{
				log.error("Could not lookup datasource!");
			}
		}
		catch (NamingException ex)
		{
			log.error("Naming exception occurred {}", ex);
		}
		return result;
	}
}