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;
This blog is made to post some interesting things on Software Development and Quantitative Analysis. (T.Liu)
Tuesday, June 19, 2012
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
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;
2, Change -Dasa.jre=private into -Dsas.jre=public
3, Restart SAS
4, proc javainfo;
http://support.sas.com/kb/17/226.html
run;
Subscribe to:
Posts (Atom)