When I execute SQL query using PowerHub JDBC driver, it always gives connection status. Connecting to //powerhubmachine/pe_dic-server Connected to ////powerhubmachine/pe_dic-server (PowerHub 20.0) To remove this output, I temporarily redirect the output to ‘null’, as shown in snippet below: private void connect() throws IOException { try { PrintStream oriOut = System.out; System.setOut(new PrintStream(new OutputStream(){public void write [...]
Archive for the ‘Landmark’ Category
133 374OpenWorks: Create default Wallet
May 4th, 2009
3 Comments
As addition to the OpenWorks: OS Authentication in R5000. You can create default wallet without having to login into OpenWorks by running the script below. Before you run the script, you have to make sure that the following environment variable is populated correctly: OWHOME OWSYSSID ORACLE_HOME OW_HOME_DIR From your linux shell, please run the following: [...]
OpenWorks: OS Authentication in R5000
April 25th, 2009
1 Comment
OpenWorks R2003 use traditional external user as the authentication. By simply, creating user via sqlplus: create user osuser identified externally And you can connect to OpenWorks Oracle database by: sqlplus /@openworksdb In R5000, end user is still able to logon without password but the method is slightly different. R5000 uses Oracle Secure External Password Store. [...]
