Trying to use a blob data type to add an image to a database

I am currently trying to build a crud application to load name, address and picture data for members of an organization. I have the database set up, but when I run the application I get a null converter error for the blob data. What do I need do to get the application to work. I can send or post the application if more information is needed.

Mar 13 '13 #1

Follow Post Reply

2944

Luuk

1,044

Expert 1GB

"I am currently trying to build a crud application"
In what language are you trying to do this?

"I get a null converter error for the blob data"
can you copy a piece of the code here, plus the exact error message(s)....

Mar 16 '13 #2

wantar20

I am using java. I will get on my laptop and run the application so I can copy some code as that is where I am developing my application.

Mar 18 '13 #3

wantar20

Sorry this took so long, my laptop crashed and I needed to get it fixed. here is some code from my application.

Expand|Select|Wrap|Line Numbers

 package jpa.entities;
 
import java.io.Serializable;

import javax.persistence.Basic;

import javax.persistence.Column;

import javax.persistence.Entity;

import javax.persistence.Id;

import javax.persistence.Lob;

import javax.persistence.NamedQueries;

import javax.persistence.NamedQuery;

import javax.persistence.Table;

import javax.validation.constraints.NotNull;

import javax.validation.constraints.Size;

import javax.xml.bind.annotation.XmlRootElement;
 
/**

 *

 * @author Rmwanta

 */

@Entity

@Table(name = "directory")

@XmlRootElement

@NamedQueries({

    @NamedQuery(name = "Directory.findAll", query = "SELECT d FROM Directory d"),

    @NamedQuery(name = "Directory.findByName", query = "SELECT d FROM Directory d WHERE d.name = :name"),

    @NamedQuery(name = "Directory.findByAddress", query = "SELECT d FROM Directory d WHERE d.address = :address")})

public class Directory implements Serializable {

    private static final long serialVersionUID = 1L;

    @Id

    @Basic(optional = false)

    @NotNull

    @Size(min = 1, max = 40)

    @Column(name = "name")

    private String name;

    @Basic(optional = false)

    @NotNull

    @Size(min = 1, max = 40)

    @Column(name = "address")

    private String address;

    @Lob

    @Column(name = "picture")

    private byte[] picture;
 
    public Directory() {

    }
 
    public Directory(String name) {

        this.name = name;

    }
 
    public Directory(String name, String address) {

        this.name = name;

        this.address = address;

    }
 
    public String getName() {

        return name;

    }
 
    public void setName(String name) {

        this.name = name;

    }
 
    public String getAddress() {

        return address;

    }
 
    public void setAddress(String address) {

        this.address = address;

    }
 
    public byte[] getPicture() {

        return picture;

    }
 
    public void setPicture(byte[] picture) {

        this.picture = picture;

    }
 
   @Override

    public int hashCode() {

        int hash = 0;

        hash += (name != null ? name.hashCode() : 0);

        return hash;

    }
 
    @Override

    public boolean equals(Object object) {

        // TODO: Warning - this method won't work in the case the id fields are not set

        if (!(object instanceof Directory)) {

            return false;

        }

        Directory other = (Directory) object;

        if ((this.name == null && other.name != null) || (this.name != null && !this.name.equals(other.name))) {

            return false;

        }

        return true;

    }
 
    @Override

    public String toString() {

        return "jpa.entities.Directory[ name=" + name + " ]";

    }
 
}
 
CREATE TABLE directory (

name  VARCHAR (40)  NOT NULL,

address    VARCHAR(40) NOT NULL,

picture BLOB NOT NULL,

CONSTRAINT pk_directory PRIMARY KEY (name)

);        
 
<?xml version='1.0' encoding='UTF-8' ?>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<html xmlns="http://www.w3.org/1999/xhtml"

      xmlns:h="http://java.sun.com/jsf/html">

    <h:head>

        <title>Facelet Title</title>

        <h:outputStylesheet name="css/jsfcrud.css"/>

    </h:head>

    <h:body>

        Hello from Faith Baptist Church

        <br />

        <h:link outcome="/directory/List" value="Show All Directory Items"/>

    </h:body>
 
</html>

Let me know if you see anything that can help me.

Apr 2 '13 #4

r035198x

13,262

8TB

When do you get the error message and what is the full stacktrace that you get?

Apr 3 '13 #5

wantar20

I get the "Null Coverter Error" when trying to add a picture to the database. I will have to run the application again and look at the stack trace to see what it is.

Apr 3 '13 #6

r035198x

13,262

8TB

Check your stacktrace, the error is more likely to be coming from your JSF page than from the database.

Apr 3 '13 #7

wantar20

I am having a brain block, how do i check my stack trace?

Apr 3 '13 #8

r035198x

13,262

8TB

In the server's log.

Apr 4 '13 #9

wantar20

I think this is the stack trace from the server. I don't see anything that would be causing the problem.

INFO: Running GlassFish Version: GlassFish Server Open Source Edition 3.1.2.2 (build 5)
INFO: Registered org.glassfish.ha.store.adapter.cache.ShoalBackingS toreProxy for persistence-type = replicated in BackingStoreFactoryRegistry
INFO: Grizzly Framework 1.9.50 started in: 115ms - bound to [0.0.0.0:3700]
INFO: Grizzly Framework 1.9.50 started in: 171ms - bound to [0.0.0.0:8080]
INFO: Grizzly Framework 1.9.50 started in: 134ms - bound to [0.0.0.0:8181]
INFO: Grizzly Framework 1.9.50 started in: 124ms - bound to [0.0.0.0:4848]
INFO: Grizzly Framework 1.9.50 started in: 102ms - bound to [0.0.0.0:7676]
INFO: Created EjbThreadPoolExecutor with thread-core-pool-size 16 thread-max-pool-size 32 thread-keep-alive-seconds 60 thread-queue-capacity 2147483647 allow-core-thread-timeout false
INFO: SEC1002: Security Manager is OFF.
INFO: SEC1010: Entering Security Startup Service
INFO: SEC1143: Loading policy provider com.sun.enterprise.security.provider.PolicyWrapper .
INFO: SEC1115: Realm [admin-realm] of classtype [com.sun.enterprise.security.auth.realm.file.FileRe alm] successfully created.
INFO: SEC1115: Realm [file] of classtype [com.sun.enterprise.security.auth.realm.file.FileRe alm] successfully created.
INFO: SEC1115: Realm [certificate] of classtype [com.sun.enterprise.security.auth.realm.certificate .CertificateRealm] successfully created.
INFO: SEC1011: Security Service(s) Started Successfully
INFO: WS10010: Web service endpoint deployment events listener registered successfully.
INFO: WEB0169: Created HTTP listener [http-listener-1] on host/port [0.0.0.0:8080]
INFO: WEB0169: Created HTTP listener [http-listener-2] on host/port [0.0.0.0:8181]
INFO: WEB0169: Created HTTP listener [admin-listener] on host/port [0.0.0.0:4848]
INFO: WEB0171: Created virtual server [server]
INFO: WEB0171: Created virtual server [__asadmin]
INFO: WEB0172: Virtual server [server] loaded default web module []
WARNING: Container org.glassfish.webservices.JAXWSContainer@49e448c2 doesn't support class com.sun.xml.ws.api.server.Module
INFO: WS00019: EJB Endpoint deployed
CalculatorWSApplication listening at address at http://Newlaptop:8080/CalulatorWS/CalulatorWS
INFO: WEB0671: Loading application [CalculatorWSApplication] at [/CalculatorWSApplication]
INFO: CORE10010: Loading application CalculatorWSApplication done in 9,579 ms
INFO: WEB0671: Loading application [CalculatorWSServletClient] at [/CalculatorWSServletClient]
INFO: CORE10010: Loading application CalculatorWSServletClient done in 1,161 ms
INFO: WEB0671: Loading application [CalculatorWSJSPClient] at [/CalculatorWSJSPClient]
INFO: CORE10010: Loading application CalculatorWSJSPClient done in 508 ms
INFO: HV000001: Hibernate Validator 4.3.0.Final
INFO: EclipseLink, version: Eclipse Persistence Services - 2.3.2.v20111125-r10461
INFO: file:/C:/Users/Rmwanta/Documents/NetBeansProjects/CustomerDB/build/web/WEB-INF/classes/_CustomerDBPU login successful
WARNING: Multiple [2] JMX MBeanServer instances exist, we will use the server at index [0] : [com.sun.enterprise.v3.admin.DynamicInterceptor@79d 6ab4e].
WARNING: JMX MBeanServer in use: [com.sun.enterprise.v3.admin.DynamicInterceptor@79d 6ab4e] from index [0]
WARNING: JMX MBeanServer in use: [com.sun.jmx.mbeanserver.JmxMBeanServer@1972c74a] from index [1]
INFO: EJB5181:Portable JNDI names for EJB MicroMarketFacadeREST: [java:global/CustomerDB/MicroMarketFacadeREST!service.MicroMarketFacadeRES T, java:global/CustomerDB/MicroMarketFacadeREST]
INFO: EJB5181:Portable JNDI names for EJB CustomerFacadeREST: [java:global/CustomerDB/CustomerFacadeREST!service.CustomerFacadeREST, java:global/CustomerDB/CustomerFacadeREST]
INFO: EJB5181:Portable JNDI names for EJB DiscountCodeFacadeREST: [java:global/CustomerDB/DiscountCodeFacadeREST, java:global/CustomerDB/DiscountCodeFacadeREST!service.DiscountCodeFacadeR EST]
INFO: Registering the Jersey servlet application, named org.netbeans.rest.application.config.ApplicationCo nfig, at the servlet mapping, /webresources/*, with the Application class of the same name
INFO: WEB0671: Loading application [CustomerDB] at [/CustomerDB]
INFO: CORE10010: Loading application CustomerDB done in 7,642 ms
INFO: EclipseLink, version: Eclipse Persistence Services - 2.3.2.v20111125-r10461
INFO: file:/C:/Users/Rmwanta/Documents/NetBeansProjects/Church Directory/build/web/WEB-INF/classes/_Church_DirectoryPU login successful
WARNING: Multiple [2] JMX MBeanServer instances exist, we will use the server at index [0] : [com.sun.enterprise.v3.admin.DynamicInterceptor@79d 6ab4e].
WARNING: JMX MBeanServer in use: [com.sun.enterprise.v3.admin.DynamicInterceptor@79d 6ab4e] from index [0]
WARNING: JMX MBeanServer in use: [com.sun.jmx.mbeanserver.JmxMBeanServer@1972c74a] from index [1]
INFO: EJB5181:Portable JNDI names for EJB DirectoryFacade: [java:global/Church_Directory/DirectoryFacade, java:global/Church_Directory/DirectoryFacade!jpa.session.DirectoryFacade]
INFO: Initializing Mojarra 2.1.6 (SNAPSHOT 20111206) for context '/Church_Directory'
INFO: Monitoring jndi:/server/Church_Directory/WEB-INF/faces-config.xml for modifications
INFO: WEB0671: Loading application [Church_Directory] at [/Church_Directory]
INFO: CORE10010: Loading application Church_Directory done in 4,592 ms
INFO: GlassFish Server Open Source Edition 3.1.2.2 (5) startup time : Felix (21,590ms), startup services(25,096ms), total(46,686ms)
INFO: WEB0169: Created HTTP listener [http-listener-1] on host/port [0.0.0.0:8080]
INFO: Grizzly Framework 1.9.50 started in: 4ms - bound to [0.0.0.0:8080]
INFO: JMX005: JMXStartupService had Started JMXConnector on JMXService URL service:jmx:rmi://Newlaptop:8686/jndi/rmi://Newlaptop:8686/jmxrmi
INFO: WEB0169: Created HTTP listener [http-listener-2] on host/port [0.0.0.0:8181]
INFO: Grizzly Framework 1.9.50 started in: 3ms - bound to [0.0.0.0:8181]

Apr 5 '13 #10

r035198x

13,262

8TB

Perform the action that makes the exception occur and check the logs after that.

Apr 6 '13 #11

wantar20

I will try that an let you know.

Apr 6 '13 #12

Trying to use a blob data type to add an image to a database

Post your reply

Similar topics