On 30 Jul 2004, at 14:19, bryan wrote:

I am using the following mysql driver

-rwxr-xr-x 1 Administ Aucun 321671 Jul 2 13:47 /c/bryan-website/jakarta
-tomcat-5.0.14/common/lib/mysql-connector-java-3.1.1-alpha-bin.jar


and it has worked fine for me previously .

I would carry out some checks on the struts action to verify the size
of the data.

Sure that stuff works.. Its when i attempt to save the object that has a property or type byte[] (class cast exception) and a trusty old NPE when i use my own custom type. Its really annoying, given that it works with 2.0.. Perhaps those crazy hibernate kids thought it was too easy.



Also check for the following <form enctype="multipart/form-data"

--b

On Fri, 30 Jul 2004 12:30:45 +0200, Mark Lowe <[EMAIL PROTECTED]> wrote:
Hi Bryan

Just downloaded the latest, but the action just prints a test message..

System.out.println("at least i managed to get called");

The problem isn't with form file, thats fine.. Its when I try and save
to the db

//hibernate stuff

/**
* @hibernate.property column="image" type="blob"
*/
public byte[] getImage() {
        return image;
}

public void setImage(byte[] image) {
        this.image = image;
}

Now i created a custom user type like were required with older versions
of hibernate..


/**
* @hibernate.property column="image"
type="com.sparrow.hibernate.type.Image"
*/

http://www.hibernate.org/73.html

but when i try and save now i get a null pointer exception with not
much else to go on (before it was a class cast exception). I'd have
thought that creating a custom user type was a bit old hat as 2.0 loved
it..


The only other thing i can think its down to is the jdbc driver.. Which
i'm investigating now.





On 30 Jul 2004, at 12:08, Bryan Hunt wrote:

My app is able to do it no problem, back and forth.

You can get the source code from http://jestate.revoltingdigits.com/

ie.jestate.struts.action.ImageUploadAction

My code is a  mess at the moment but that code is working.

--b


Mark Lowe wrote:

I've had the same thing happen using DBCP and C3PO, I believe its the
driver rather than the pooling. As I said we've a app thats live, and
i haven't touched it in months using DBCP.


[OT] subject change.. Have you had any joy with byte[] to blob
mapping for file uploads with hibernate 2.1.4? I created a custom
usertype, but i get a npe. 2.0 delbt with life, but things appear to
have taken a step backwards. (please dont make me go the the scary
hibernate forum :) )


On 30 Jul 2004, at 11:34, Joe Hertz wrote:

I noticed this behavior with 3.0.14.

This _really_ sounds like this entry in the Hibernate FAQ to me:

http://www.hibernate.org/117.html#A13

I wouldn't use DBCP though as Gavin King is apparently fed up with
it,
and built-in support for it is being yanked in the next major
version of
Hibernate.

-----Original Message-----
From: Marco Mistroni [mailto:[EMAIL PROTECTED]
Sent: Friday, July 30, 2004 5:08 AM
To: 'Struts Users Mailing List'
Subject: RE: OT/ Tomcat, Hibernate and MYSQL problem


Hello, If I remember correct, mysql connector 3.0.11

Regards
    marco

-----Original Message-----
From: Mark Lowe [mailto:[EMAIL PROTECTED]
Sent: 30 July 2004 09:36
To: Struts Users Mailing List
Subject: Re: OT/ Tomcat, Hibernate and MYSQL problem

Marco

What jdbc driver are you using?

They was a shady version 3 behaving like this.


On 30 Jul 2004, at 10:05, Joe Hertz wrote:

Hibernate's internal connection pooling isn't meant for production
because it does things just like that.


Suggest you use c3p0 for the pooling.

From my hibernate.cfg.xml, I only had to add this:


       <property name="c3p0.minPoolSize">5</property>
       <property name="c3p0.maxPoolSize">20</property>
       <property name="c3p0.timeout">1800</property>
       <property name="c3p0.max_statement">50</property>

HTH

-Joe


-----Original Message-----
From: Marco Mistroni [mailto:[EMAIL PROTECTED]
Sent: Friday, July 30, 2004 3:58 AM
To: 'Struts Users Mailing List'
Subject: OT/ Tomcat, Hibernate and MYSQL problem


Hello,

    First of all, I apologize for the off topic issue..
I know this is not the list, but I tried hibernate forums, and
Searched the web with no solution.. hopefully some of u

had the Same

problem and solved it..


I m experiencing problems with Hibernate in tomcat,

talking to mysql.


My situation is that I didn't define any connection pools

in tomcat,

but left it to Hibernate to handle that...

After leaving the application running for 11 hours, I got

following

exception

hi all,
i have a webapp taht uses Hibernate and MYSQL, running on top of
tomcat.

i am letting Hibernate handle the connections to mysql db, since i
have no connection pools defined in tomcat. after running the
application for nearly 9 hours, when i tried to use my app

to connect

to the database i got following exception:

Caused by: net.sf.hibernate.JDBCException: Could not

execute query at

net.sf.hibernate.impl.SessionImpl.find(SessionImpl.java:1476)
at net.sf.hibernate.impl.QueryImpl.list(QueryImpl.java:45)
at com.myapp.hibernate.HibernatePersistenceManager.query(Hibernat
ePersisten
ceManager.java:205)
... 31 more
Caused by: java.sql.SQLException: Communication link failure:
java.net.SocketException, underlying cause: Software caused

connection

abort: recv failed

** BEGIN NESTED EXCEPTION **

java.net.SocketException
MESSAGE: Software caused connection abort: recv failed

STACKTRACE:

java.net.SocketException: Software caused connection abort: recv
failed



now i have searched the web and found two possible

alternatives.. one

was to add following problems to hibernate config file.. <property
name="connection.autoReconnect">true</property>
<property name="connection.autoReconnectForPools">true</property>
<property
name="connection.is-connection-validation-required">true</
property>



but this does not work, as ihave added thos eproperties to

hibernate

properties file and i am still getting same exception


then I tried to add ?autoReconnect=true to JBDC URL, but

that didn't

work either coz I left application running for 11 hours and after
that I got same exception...


can anyone help me out?

THANX in advance and regards
    marco



l: [EMAIL PROTECTED]



------------------------------------------------------------------ --
-


To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]







------------------------------------------------------------------ --
-


To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]



------------------------------------------------------------------ --
-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]



------------------------------------------------------------------ --
-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]







------------------------------------------------------------------- --
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]



-------------------------------------------------------------------- -
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]



--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]

--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]



--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]


---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]



Reply via email to