Results 1 to 6 of 6
  1. #1
    Join Date
    Dec 2011
    Posts
    7

    Unanswered: java.sql.SQLException: Blob not found

    Hi,
    i have a Tomcat Servlet. And if i read a text blob on a linux (windows work) i become a
    java.sql.SQLException: Blob not found
    at com.informix.util.IfxErrMsg.getSQLException(IfxErr Msg.java:413)
    at com.informix.jdbc.IfxResultSet.blobCheck(IfxResult Set.java:1741)
    at com.informix.jdbc.IfxResultSet.a(IfxResultSet.java :701)
    at com.informix.jdbc.IfxResultSet.b(IfxResultSet.java :641)
    at com.informix.jdbc.IfxResultSet.getCharacterStream( IfxResultSet.java:901)
    at com.informix.jdbc.IfxResultSet.getCharacterStream( IfxResultSet.java:932)
    at verarbeitung.ReadAndSend.readEmails(ReadAndSend.ja va:342)
    at verarbeitung.ReadAndSend.readAndSend(ReadAndSend.j ava:69)
    at main.EmailSchedulerThread****n(EmailSchedulerThrea d.java:154)
    Caused by: java.sql.SQLException: System or internal error java.security.PrivilegedActionException: java.io.IOException: Permission denied
    at com.informix.util.IfxErrMsg.getSQLException(IfxErr Msg.java:532)
    at com.informix.jdbc.IfxTmpFile.<init>(IfxTmpFile.jav a:95)
    at com.informix.jdbc.IfxSqli.executeFetchBlob(IfxSqli .java:5296)
    at com.informix.jdbc.IfxResultSet.blobCheck(IfxResult Set.java:1734)
    ... 7 more
    Caused by: java.security.PrivilegedActionException: java.io.IOException: Permission denied
    at java.security.AccessController.doPrivileged(Native Method)
    at com.informix.jdbc.IfxTmpFile.<init>(IfxTmpFile.jav a:76)
    ... 9 more
    Caused by: java.io.IOException: Permission denied
    at java.io.UnixFileSystem.createFileExclusively(Nativ e Method)
    at java.io.File.checkAndCreate(File.java:1704)
    at java.io.File.createTempFile(File.java:1792)
    at com.informix.jdbc.IfxTmpFile$1****n(IfxTmpFile.jav a:81)
    ... 11 more

    I dont know where is the temp dir to change the rights. I try to add ifxJDBCTEMP /tmp in the onconfig and ifxJDBCTEMP=/tmp in the connectionstring but it dont work. /tmp have 1777 rights as default on suse 11.4

  2. #2
    Join Date
    Sep 2011
    Location
    Pont l'Abbé, Brittany, France
    Posts
    381
    Provided Answers: 1
    Hi


    check whether the Informix server log file say anything ?

    E.

  3. #3
    Join Date
    Dec 2011
    Posts
    7
    Nothing in the informix .log file.

    On Windows are files created like IfxTmpFile_1743008061943156054. On Suse not.

  4. #4
    Join Date
    Sep 2011
    Location
    Pont l'Abbé, Brittany, France
    Posts
    381
    Provided Answers: 1
    Hi,

    although I do no see exactly the same error, did you look at this technote?

    I think you should try to set LOBCACHE and see what happens, just to check whether the problem is a permission problem on a directory.

    Don't ask me more, I am not a java specialist :-)

  5. #5
    Join Date
    Dec 2011
    Posts
    7
    "lobcache=-1" and "JDBCTEMP=/tmp" in connectionstring work.

    The ifxJDBCTEMP=/tmp was wrong.

  6. #6
    Join Date
    Jun 2012
    Posts
    4
    i also this exception after I try and run this program. It's one among the Microsoft examples. I've added the sqljdbc4.jar to the classpath in netbeans for each compile and Run, via the project properties. I conjointly tested that the category can be found by using an import statement below - no error throughout compile, therefore it should be finding the mainframe testing.
    java.sql.SQLException: No suitable driver found for jdbc:microsoft:sqlserver://localhost:1433;databaseName=HealthCareDatabase
    Error Trace in getConnection() : No suitable driver found for jdbc:microsoft:sqlserver://localhost:1433;databaseName=HealthCareDatabase
    Error: No active Connection
    at java.sql.DriverManager.getConnection(DriverManager .java:602)
    at java.sql.DriverManager.getConnection(DriverManager .java:185)
    at javaapplication1.Connect.getConnection(Connect.jav a:35)
    at javaapplication1.Connect.displayDbProperties(Conne ct.java:50)
    at javaapplication1.JavaApplication1.main(JavaApplica tion1.java:23)
    BUILD SUCCESSFUL (total time: 1 second)
    Last edited by ashee1; 06-25-12 at 04:53.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •