oracle queries

-
Covert Date to Timestamp
  1. TO_TIMESTAMP(SYSDATE,'DD-MM-RRRR HH24:MI:SS') FROM DUAL;

Comments

Post a Comment

Popular posts from this blog

Java Task Service - Sterling Integrator

-
import com.sterlingcommerce.woodstock.workflow.Document; import java.io.InputStream; import java.io.InputStreamReader; import java.io.BufferedReader; Document doc = wfc.getPrimaryDocument(); Document outPutDoc = wfc.newDocument(); ; InputStream inS = doc .getInputStream(); BufferedReader br = new BufferedReader( new InputStreamReader( inS )); String strData = “<SampleData>” ; String strLine; while ((strLine = br .readLine()) != null ) {     strData = strData.concat(strLine); } br.close(); strData = strData + “</SampleData>”; outPutDoc. setBody( strData .toString().getBytes()); wfc.putPrimaryDocument( outPutDoc );
Read more

Hibernate Connection Fails if there is Database inconsistency or DB fail-over (Oracle RAC)

-
        /**      * A static method with returns Hibernate Sessoin Object.      *      * @return {@link Session}      */     public static Session getSession() throws HibernateException {         Session appSession = sessionFactory .openSession();         try         {                 if (appSession.connection().isClosed()||!appSession.isConnected()||!appSession.isOpen()){                         System. out .println( "Session Closed, Creating Session again..." );                  ...
Read more

​ Configure External Databases to IBM Sterling B2B Integrator

-
We can add multiple ​​ external databases to IBM Sterling B2B Integrator. To add custom database need to do the following things, 1. Stop IBM Sterling B2B Integrator 2. Navigate to SI_INSTALL_DIR\properties and edit jdbc_customer.properties.in and add the below properties. 3. Run setupfiles.bat/sh (SI_INSTALL_DIR\bin\setupfiles.bat/sh) 4. Start IBM Sterling B2B Integrator Note: SI_EXTENSION is my pool name. We can name whatever we want. ​ ​ MS SQL Server Database Need to change the test query depending on server, For MS SQL Server Database SI_EXTENSION.testOnReserveQuery=SELECT GETDATE() Oracle Database Need to change the test query depending on server, For Oracle Database SI_EXTENSION.testOnReserveQuery=SELECT * FROM DUAL jdbc_customer.properties.in SI_EXTENSION.driver=com.microsoft.sqlserver.jdbc.SQLServerDriver SI_EXTENSION.url=jdbc:sqlserver://localhost:1433;databaseName=SI_EXTENSION;SelectMethod=cursor SI_EXTENSION.user=sa SI_EXTENSION.password= #SI_EX...
Read more