Hibernate 3.2 (db SQLBase) : insert long varchar ?

olv · **Joined:** Sun Dec 17, 2006 6:30 pm **Posts:** 9

Hello,

I have a problem inserting long varchar... with Gupta SQLBase

I have a sample that works in a java SE application :

java.io.File file = new java.io.File("longs.txt");
long fileLength = file.length();
java.io.InputStream fin = new java.io.FileInputStream(file);
java.sql.PreparedStatement pstmt = con1.prepareStatement("INSERT INTO test VALUES (1,?)");
pstmt.setAsciiStream(1, fin,(int)fileLength);
pstmt.executeUpdate();

But with Hibernate 3.2.1.GA (JBoss 4.0.4), I have tried with some configurations but it doesn't work properly...
The config which is almost good is this one :

@Type(type="serializable")
private String slv_value;

But when the insert is executed, the string inserted is not good...
For example, when I try to insert :
"<Item>
<Cir00310_id>47372</Cir00310_id>
<TraMatric>0000000001</TraMatric>
<TraFct>01</TraFct>
<PeriodStart>20066</PeriodStart>
<PeriodEnd>20069</PeriodEnd>
</Item>"
And I try to read it again, it returns :
"¬í
<Cir00310_id>47376</Cir00310_id>
<TraMatric>0000000002</TraMatric>
<TraFct>01</TraFct>
<PeriodStart>20066</PeriodStart>
<PeriodEnd>20069</PeriodEnd>
</Item></Item>"

I have tried the type "text" but it doesn't work with the JDBC Driver of SQLBase...

So, how can I "take the control" of writing long varchar in Hibernate ???
How can I be sure that Hibernate uses the setAsciiStream() of the JDBC Driver ?
A method to override ?

Thanks,

Olivier

emmanuel · **Posted:** Sun Dec 17, 2006 7:05 pm

yes, use a custom UserType

olv · **Joined:** Sun Dec 17, 2006 6:30 pm **Posts:** 9

Thanks Emmanuel !

I have created a custom UserType and it works !!!

Here is the code :

Code:

public class SQLBaseLongVarcharType implements UserType
{
    
    /** Creates a new instance of LongVarcharType */
    public SQLBaseLongVarcharType()
    {
    }
    
    public int[] sqlTypes()
    {
        return new int[] { Types.LONGVARCHAR };
    }

    public Class returnedClass()
    {
        return String.class;
    }

    public boolean equals(Object x, Object y)
        throws HibernateException
    {
        return (x == y) || (x != null && y != null && (x.equals(y)));
    }

    public Object nullSafeGet(ResultSet inResultSet, String[] names, Object o)
        throws HibernateException, SQLException
    {
        String val = (String)Hibernate.STRING.nullSafeGet(inResultSet, names[0]);
        return val;
    }

    public void nullSafeSet(PreparedStatement inPreparedStatement, Object o, int i)
        throws HibernateException, SQLException
    {
        String valStr = (String) o;
        java.io.InputStream val;
        try
        {
            val = new ByteArrayInputStream(valStr.getBytes("UTF-8"));
            inPreparedStatement.setAsciiStream(i, val, valStr.length());
        } catch (UnsupportedEncodingException ex)
        {
            ex.printStackTrace();
        }
    }

    public Object deepCopy(Object o) throws HibernateException
    {
        if (o==null) return null;
        return new String(((String) o));
    }

    public boolean isMutable()
    {
        return false;
    }

    /**
     * @see org.hibernate.usertype.UserType#assemble(java.io.Serializable, java.lang.Object)
     */
    public Object assemble(Serializable cached, Object owner)
    {
        return cached;
    }

    /**
     * @see org.hibernate.usertype.UserType#disassemble(java.lang.Object)
     */
    public Serializable disassemble(Object value)
    {
        return (Serializable) value;
    }

    /**
     * @see org.hibernate.usertype.UserType#replace(java.lang.Object, java.lang.Object, java.lang.Object)
     */
    public Object replace(Object original, Object target, Object owner)
    {
        return original;
    }

    /**
     * @see org.hibernate.usertype.UserType#hashCode(java.lang.Object)
     */
    public int hashCode(Object x)
    {
        return x.hashCode();
    }
    
}

mickeo4 · **Joined:** Mon Nov 22, 2010 5:26 am **Posts:** 9

Beginner

Joined: Mon Jan 22, 2007 12:16 pm
Posts: 21 I have just started working with Hibernate. I would like to use it with SQLBase. I realize that I need to extend Dialect to get things to work, but I am not sure what I need to have in the new dialect class I create.

The only information I can find on the web, is that creating my own dialect is 'easy'. Are there any resources available on what I need to do?

Thanks for any help.

-Mark

Top

kochcp Post subject: Posted: Mon Jan 22, 2007 1:38 pm

Expert

Joined: Fri Aug 19, 2005 1:11 pm
Posts: 628
Location: Cincinnati you can check out what the other dialect classes look like in the source

_________________
Chris

If you were at work doing this voluntarily, imagine what you'd want to see to answer a question.

Top

fizzbananafrance Post subject: Posted: Tue Jan 30, 2007 8:45 am

Beginner

Joined: Mon Jan 22, 2007 12:16 pm
Posts: 21 In the end, it was very helpful to look at other dialect classes, but the most important thing was to read/understand the Dialect.java class.

thanks for the response.

-mark