This discussion is archived
2 Replies Latest reply: Oct 18, 2006 2:24 AM by 800725 RSS

SQL file

800725 Newbie
Currently Being Moderated
First of all, very sorry I could not find a proper forum to post this. Moreover I am not sure this is problem in the domain of Java or not. Nevertheless, I am having the problem and want suggestions if anyone has one.
I have created an applicaition which uses JDBC. Nothing's wrong with the application but the problem is everytime I run the application, a file called "SQL.txt" (or something like that) keeps appending. I am sure this thing is happening after I developed the project but cannot come to any logical conclusion. The file grows at a great pace (last time I deleted it, it was 50MB). I am sure I did not create any suchfiles through my application. Can someone explain? This could create huge problems in the system it is finally installed.
  • 1. Re: SQL file
    JoachimSauer Journeyer
    Currently Being Moderated
    Something in your program is logging to that file. No JDBC standard component (that I know of) does such a thing.

    So it's either
    1.) A library you're using (maybe a Connection Pool or something)
    2.) the JDBC driver you're using
    3.) a component of your program that you don't know
  • 2. Re: SQL file
    800725 Newbie
    Currently Being Moderated
    Posting a part of the content of the file I was talking about. May be someone will have some idea then. I am using Microsoft Access driver.
    java CoolprosuP b8-670     ENTER SQLAllocEnv 
              HENV *              02E4EE40
    
    java CoolprosuP b8-670     EXIT  SQLAllocEnv  with return code 0 (SQL_SUCCESS)
              HENV *              0x02E4EE40 ( 0x02da1540)
    
    java CoolprosuP b8-670     ENTER SQLAllocConnect 
              HENV                02DA1540
              HDBC *              02E4EDA4
    
    java CoolprosuP b8-670     EXIT  SQLAllocConnect  with return code 0 (SQL_SUCCESS)
              HENV                02DA1540
              HDBC *              0x02E4EDA4 ( 0x02da15e8)
    
    java CoolprosuP b8-670     ENTER SQLDriverConnectW 
              HDBC                02DA15E8
              HWND                00000000
              WCHAR *             0x1F7B2690 [      -3] "******\ 0"
              SWORD                       -3 
              WCHAR *             0x1F7B2690 
              SWORD                        8 
              SWORD *             0x00000000
              UWORD                        0 <SQL_DRIVER_NOPROMPT>
    
    java CoolprosuP b8-670     EXIT  SQLDriverConnectW  with return code 0 (SQL_SUCCESS)
              HDBC                02DA15E8
              HWND                00000000
              WCHAR *             0x1F7B2690 [      -3] "******\ 0"
              SWORD                       -3 
              WCHAR *             0x1F7B2690 
              SWORD                        8 
              SWORD *             0x00000000
              UWORD                        0 <SQL_DRIVER_NOPROMPT>
    
    java CoolprosuP b8-670     ENTER SQLGetInfoW 
              HDBC                02DA15E8
              UWORD                        6 <SQL_DRIVER_NAME>
              PTR                 0x02DA1F40 
              SWORD                      600 
              SWORD *             0x02E4ED20
    
    java CoolprosuP b8-670     EXIT  SQLGetInfoW  with return code 0 (SQL_SUCCESS)
              HDBC                02DA15E8
              UWORD                        6 <SQL_DRIVER_NAME>
              PTR                 0x02DA1F40 [      24] "odbcjt32.dll"
              SWORD                      600 
              SWORD *             0x02E4ED20 (24)
    
    java CoolprosuP b8-670     ENTER SQLGetInfoW 
              HDBC                02DA15E8
              UWORD                        7 <SQL_DRIVER_VER>
              PTR                 0x02DA1F40 
              SWORD                      600 
              SWORD *             0x02E4ED18
    
    java CoolprosuP b8-670     EXIT  SQLGetInfoW  with return code 0 (SQL_SUCCESS)
              HDBC                02DA15E8
              UWORD                        7 <SQL_DRIVER_VER>
              PTR                 0x02DA1F40 [      20] "04.00.6019"
              SWORD                      600 
              SWORD *             0x02E4ED18 (20)
    and so on...this file is growing at a monsterous rate...Does anyone have an idea, before my hard disk crashes...