User Profile

Collapse

Profile Sidebar

Collapse
Debabrata Jana
Debabrata Jana
Last Activity: Nov 14 '09, 07:21 AM
Joined: Mar 3 '07
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts
  • Debabrata Jana
    started a topic Schema level session idle time out in oracle
    in Oracle

    Schema level session idle time out in oracle

    Hi,

    I am using Oracle 10g as a database server. I have two schema suppose s1 and s2. Suppose, I login to the s1 schema and as well as s2 schema. These two connection is active in two different session. Now, I want that, If I keep idle for more than 2 minutes in the session for s1 schema, then the session for s1 schema should disconnected from the DB, but the session for s2 schema should remain connected to the DB.
    ...
    See more | Go to post
    • Debabrata Jana
      started a topic Oracle JDBC Connection Problem
      in Java

      Oracle JDBC Connection Problem

      Please go through the JAVA code below:
      Code:
      class Main{
public Connection getConnection(){
        Connection l_con = null;
        try {
            String hostname = "172.10.23.1:1527";	//Host IP:port No
            String dbsid = "TESTSID";			//SID Name or Service Name
            String username = "TESTUSER";	//Database user
            String password =
      ...
      See more | Go to post
      Last edited by JosAH; Feb 23 '09, 09:29 AM. Reason: fixed the [code] ... [/code] tags
      • Debabrata Jana
        started a topic Problem to use FOR loop to fetch record from a ref cursor
        in Oracle

        Problem to use FOR loop to fetch record from a ref cursor

        Hi,
        Please go through the code given below.
        Code:
        PROCEDURE generateDetailReport(reportId IN NUMBER,DIR IN Varchar2,FileName IN Varchar2) As
  REPORT_NAME VARCHAR2(100);
  REPORT_HDR VARCHAR2(500);
  REPORT_FOOTER VARCHAR2(500);
  REPORT_SQL VARCHAR2(4000);
  RECORDS_PER_PAGE NUMBER;
  TYPE CURSOR_TYPE IS REF CURSOR;
  REPORT_CUR CURSOR_TYPE;
  BEGIN
        ...
        See more | Go to post
        Last edited by debasisdas; Feb 18 '09, 06:15 AM. Reason: added code tags
        • Debabrata Jana
          started a topic Overrride or overload _jspService
          in Java

          Overrride or overload _jspService

          Dear friends

          Can I override or overload the _jspService(jav ax.servlet.http .HttpServletReq uest request, javax.servlet.h ttp.HttpServlet Response response) method in a jsp page?

          If yes then how?..

          Please explain it with an example...

          thanks & regards

          Debabrata
          See more | Go to post
          • Debabrata Jana
            started a topic class.forName vs DriverManager.registerDriver
            in Java

            class.forName vs DriverManager.registerDriver

            Dear Friend
            Please explain the topic---

            which one is better to use class.forName or DriverManager.r egisterDriver at the time when we want to get a connection with database.
            Please explain it..


            And please also explain which one is dynamic?

            Thanks and regards

            Debabrata
            See more | Go to post
            • Debabrata Jana
              started a topic Multiple inheritance
              in Java

              Multiple inheritance

              Dear Friends
              I have a confution.....
              In java all the class are extends java.lang.Objec t class.
              Now suppose you write a class ----
              public class B extends A
              {
              // Some code here
              }

              Logically, Here class B exteds class A and also extends class java.lang.Objec t. Now java does not support multiple inheritance. Then how does java handle this situation?...
              See more | Go to post
              • Debabrata Jana
                started a topic Is this legal?
                in Java

                Is this legal?

                hi all,
                Please answer this and give reasons.
                Is this legal?
                long longArr[];
                int intArr[] = { 7 ,8 , 9};
                longArr = intArr;

                Thanks and regards
                Debabrata
                See more | Go to post
                • Debabrata Jana
                  started a topic Solaris 5.8 writing file size limit
                  in General

                  Solaris 5.8 writing file size limit

                  Hi all,

                  I use solaris 5.8 OS.
                  I have three OS user :

                  1) orac9ias
                  2)oracle9i
                  3)backup

                  I use the following command to export a oracle export backup (I use oracle9i release 1):

                  exp userid=adm/$adm_password@$ database_sid owner=$module_c ode file=$mod_filen ame.dmp log=$mod_filena me.log
                  [
                  exp userid=scott/tiger@prod owner=scott file=scott_back up.dmp log=scott_backu p.log...
                  See more | Go to post
                  No activity results to display
                  Show More
                  Working...