Pages

Tuesday, June 19, 2012

Java DB and ij

1, Java DB, aka Derby, is shipped with Java 6+.
2, ij is the Interactive Scription Tool of Derby.

Common Commands of ij:

ij>connect 'jdbc:derby:/www/jvdb';
ij>show connections;
ij>show tables;
ij>run 'my.sql';
ij>set schema user1;
...CRUD...
ij>help;
ij>describe user1.TABLE1;
ij>disconnect;
ij>exit;

Monday, June 11, 2012

Run SAS Scripts in Java, JSP and etc.

1, Download SASDriversforJDBCandCONNECT (e.g. SAS Drivers for JDBC and SAS/CONNECT for Windows)
2, ...

http://support.sas.com/demosdownloads/setupintro.jsp

Configuring SAS 9.1 to Use Java 5 or above on Windows

1, Locate C:\Program Files\SAS\SAS 9.1\nls\en\SASV9.CFG
2, Change -Dasa.jre=private into -Dsas.jre=public
3, Restart SAS
4, proc javainfo;
http://support.sas.com/kb/17/226.html
  run;