Oracle access with Scala

http://manuel.bernhardt.io/2014/02/04/a-quick-tour-of-relational-database-access-with-scala/

http://scalikejdbc.org/

We went for ScalikeJDBC because of Oracle and SQL Server licensing issues with Slick. http://slick.typesafe.com/doc/2.0.0/extensions.html

ORACLE: How do I set up passwords to NEVER expire?

Run the below query to set up SYSTEM password never expire

SQL> select profile from dba_users where username = 'SYSTEM';

PROFILE

--------------------------

DEFAULT

SQL> alter profile DEFAULT limit password_life_time unlimited;

Profile altered.


After doing this...Reset the password of the user again.

SQL> alter user SYSTEM identified by new-password;

User altered.

By doing this,the password will never expire.