------- Forwarded message ------- From: debejarry gilles <[EMAIL PROTECTED]>
It seems my blob field is null, when i try to insert new data.
I use dbforms1.1.4pr1.jar
here is log file
DEBUG [Thread-5] (Controller.java:149) - session timeout: 1800
INFO [Thread-5] (MultipartRequest.java:108) - maxpostsize=8000000
INFO [Thread-5] (MultipartRequest.java:116) - partname=invtable
INFO [Thread-5] (MultipartRequest.java:116) - partname=invname_17
INFO [Thread-5] (MultipartRequest.java:116) - partname=autoupdate_17
INFO [Thread-5] (MultipartRequest.java:116) - partname=fu_17
INFO [Thread-5] (MultipartRequest.java:116) - partname=fue_17
INFO [Thread-5] (MultipartRequest.java:116) - partname=source
INFO [Thread-5] (MultipartRequest.java:116) - partname=customEvent
INFO [Thread-5] (MultipartRequest.java:116) - partname=firstpos_17
INFO [Thread-5] (MultipartRequest.java:116) - partname=lastpos_17
INFO [Thread-5] (MultipartRequest.java:116) - partname=dataac_goto_17_29_fu
INFO [Thread-5] (MultipartRequest.java:116) - partname=dataac_goto_17_29_single
Row
INFO [Thread-5] (MultipartRequest.java:116) - [EMAIL PROTECTED]
INFO [Thread-5] (MultipartRequest.java:116) - [EMAIL PROTECTED]
INFO [Thread-5] (MultipartRequest.java:116) - partname=f_17_insroot_1
INFO [Thread-5] (MultipartRequest.java:116) - partname=of_17_insroot_1
INFO [Thread-5] (MultipartRequest.java:116) - partname=f_17_insroot_2
INFO [Finalizer] (DataSourceJDBC.java:94) - finalize called
INFO [Finalizer] (DataSourceJDBC.java:94) - finalize called
INFO [Thread-5] (MultipartRequest.java:151) - buffered and now added as f_17_in
sroot_2 the following fileHolder:image2.jpg
INFO [Thread-5] (MultipartRequest.java:175) - loop end
INFO [Thread-5] (MultipartRequest.java:116) - partname=f_17_insroot_3
INFO [Thread-5] (MultipartRequest.java:151) - buffered and now added as f_17_in
sroot_3 the following fileHolder:AFaire.txt
INFO [Thread-5] (MultipartRequest.java:175) - loop end
INFO [Thread-5] (MultipartRequest.java:116) - partname=dataac_insert_17_root_30
_fu
INFO [Thread-5] (MultipartRequest.java:116) - partname=dataac_insert_17_root_30
_fue
INFO [Thread-5] (MultipartRequest.java:116) - partname=ac_insert_17_root_30
INFO [Thread-5] (MultipartRequest.java:116) - [EMAIL PROTECTED]
INFO [Thread-5] (EventEngine.java:338) - ::getImageButtonAction - action = [ac_
insert_17_root_30]
INFO [Thread-5] (DbFormsEventTypeStrategy.java:77) - ::getEventGroup - using [D
atabaseEventTypeStrategy] strategy
INFO [Thread-5] (EventEngine.java:195) - ::generatePrimaryEvent - generating a
database event
INFO [Thread-5] (DbFormsEventTypeStrategy.java:103) - ::getEventType - using [D
atabaseEventTypeStrategy] strategy
INFO [Thread-5] (DbFormsEventTypeStrategy.java:113) - ::getEventType - returned
the event type [insert] from [ac_insert_17_root_30]
INFO [Thread-5] (EventFactory.java:283) - ::getEventIdFromDestinationTable - ev
entId = [insert]
INFO [Thread-5] (DatabaseEventFactoryImpl.java:94) - ::createEvent - got event
[event: id = insert; type = insert; className = org.dbforms.event.datalist.Inser
tEvent] from action [ac_insert_17_root_30]
INFO [Thread-5] (EventEngine.java:381) - setting follow up to:/admistrateur_doc
produit_single.jsp
INFO [Thread-5] (EventEngine.java:401) - setting follow up on Error to:/admistr
ateur_docproduit_new.jsp
INFO [Thread-5] (Table.java:662) - INSERT INTO docproduit (photo,produit_id,doc
produit) VALUES (?,?,?)
DEBUG [Thread-5] (DataSourceJDBC.java:531) - Retrieved curField:photo type:7
INFO [Thread-5] (DataSourceJDBC.java:574) - field=photo col=1 value=null type=7
DEBUG [Thread-5] (SqlUtil.java:232) - fillPreparedStatement( ps, 1, null, 7)...
DEBUG [Thread-5] (DataSourceJDBC.java:531) - Retrieved curField:produit_id type:
1
INFO [Thread-5] (DataSourceJDBC.java:574) - field=produit_id col=2 value=1 type
=1
DEBUG [Thread-5] (SqlUtil.java:232) - fillPreparedStatement( ps, 2, 1, 1)...
DEBUG [Thread-5] (DataSourceJDBC.java:531) - Retrieved curField:docproduit type:
7
INFO [Thread-5] (DataSourceJDBC.java:574) - field=docproduit col=3 value=null t
ype=7
DEBUG [Thread-5] (SqlUtil.java:232) - fillPreparedStatement( ps, 3, null, 7)...
ERROR [Thread-5] (DataSource.java:474) -
ERROR [Thread-5] (DataSource.java:474) -
ERROR [Thread-5] (DataSource.java:474) -
DEBUG [Thread-5] (SqlUtil.java:423) - About to close connection - com.mysql.jdbc
[EMAIL PROTECTED]
DEBUG [Thread-5] (SqlUtil.java:425) - Connection closed
INFO [Thread-5] (DbFormTag.java:1019) - servlet path = /admistrateur_docproduit
_single.jsp
INFO [Thread-5] (DbFormTag.java:1020) - servlet getPathInfo = null
INFO [Thread-5] (DbFormTag.java:1022) - servlet getContextPath = /esf
DEBUG [Thread-5] (DbFormTag.java:1023) - pos1
DEBUG [Thread-5] (DbFormTag.java:1028) - pos2
DEBUG [Thread-5] (DbFormTag.java:1040) - pos4
DEBUG [Thread-5] (DbFormTag.java:1045) - pos5
DEBUG [Thread-5] (DbFormTag.java:1055) - pos7
INFO [Thread-5] (DbFormTag.java:1066) - resetting values of tag
DEBUG [Thread-5] (DbFormTag.java:1072) - first steps finished
DEBUG [Thread-5] (DbFilterTag.java:251) - setting current filter: -1
DEBUG [Thread-5] (DbFormTag.java:1214) - filter to apply :
INFO [Thread-5] (DbFormTag.java:1673) - !comparing page /esf/admistrateur_docpr
oduit_single.jsp TO /esf/admistrateur_docproduit_new.jsp
DEBUG [Thread-5] (DbFormTag.java:1680) - orderBy=null
DEBUG [Thread-5] (DbFormTag.java:1681) - localRequest=null
INFO [Thread-5] (DbFormTag.java:1232) - using OverrulingOrder (dbform tag attri
bute)
DEBUG [Thread-5] (Table.java:2449) - initFilterFieldValues: aKeyValPair = id<>0
DEBUG [Thread-5] (Table.java:2512) - Filter field=id
DEBUG [Thread-5] (Table.java:2527) - Filter value=0
DEBUG [Thread-5] (Table.java:2533) - and fv is = field [id] has value, oldvalue
[0, null]
INFO [Thread-5] (DbFormTag.java:1308) - firstposition 2:10:image2.jpg-1:1:1-3:1
0:AFaire.txt
INFO [Thread-5] (DbFormTag.java:1309) - lastPosition 0:1:1-1:1:1-2:0:-3:0:
INFO [Thread-5] (DbFormTag.java:1464) - ÃÂÃÂÃÂ NAV/I ÃÂÃÂÃÂ
INFO [Thread-5] (DbFormTag.java:1467) - about to process nav event:org.dbforms.
event.datalist.GotoEvent
INFO [Thread-5] (GotoEvent.java:207) - ==> GotoEvent.processEvent
INFO [Thread-5] (Table.java:858) - ::getSelectQuery - [SELECT id, produit_id, p
hoto, docproduit FROM docproduit WHERE ( ( ( id <> ? ) ) ) ORDER BY id,
produit_id]
DEBUG [Thread-5] (Table.java:920) - ###getDoSelectResultSet pos1
DEBUG [Thread-5] (Table.java:926) - ###getDoSelectResultSet pos2
INFO [Thread-5] (Table.java:2379) - setting col 1 with name id to value 0 of ty
pe 1 operator 6
DEBUG [Thread-5] (SqlUtil.java:232) - fillPreparedStatement( ps, 1, 0, 1)...
DEBUG [Thread-5] (Table.java:932) - ###getDoSelectResultSet pos3
DEBUG [Thread-5] (SqlUtil.java:423) - About to close connection - com.mysql.jdbc
[EMAIL PROTECTED]
DEBUG [Thread-5] (SqlUtil.java:425) - Connection closed
INFO [Thread-5] (EmbeddedData.java:295) - generating Embeddeddata name_produit_
id
INFO [Thread-5] (QueryData.java:97) - about to execute user defined query:selec
t distinct id,produit from produit order by produit ASC
DEBUG [Thread-5] (SqlUtil.java:423) - About to close connection - com.mysql.jdbc
[EMAIL PROTECTED]
DEBUG [Thread-5] (SqlUtil.java:425) - Connection closed
INFO [Thread-5] (DbFooterTag.java:56) - we are talking about=docproduit
INFO [Thread-5] (DbFooterTag.java:57) - pcount=4
INFO [Thread-5] (DbFooterTag.java:58) - pcurrent=1
INFO [Thread-5] (EmbeddedData.java:333) - Embeddeddata name_produit_id already
generated
INFO [Thread-5] (DbFooterTag.java:56) - we are talking about=docproduit
INFO [Thread-5] (DbFooterTag.java:57) - pcount=4
INFO [Thread-5] (DbFooterTag.java:58) - pcurrent=2
INFO [Thread-5] (EmbeddedData.java:333) - Embeddeddata name_produit_id already
generated
INFO [Thread-5] (DbFooterTag.java:56) - we are talking about=docproduit
INFO [Thread-5] (DbFooterTag.java:57) - pcount=4
INFO [Thread-5] (DbFooterTag.java:58) - pcurrent=3
INFO [Thread-5] (EmbeddedData.java:333) - Embeddeddata name_produit_id already
generated
INFO [Thread-5] (DbFooterTag.java:56) - we are talking about=docproduit
INFO [Thread-5] (DbFooterTag.java:57) - pcount=4
INFO [Thread-5] (DbFooterTag.java:58) - pcurrent=4
INFO [Thread-5] (DbFooterTag.java:67) - setting footerreached to true
DEBUG [Thread-5] (DbFormTag.java:1599) - pageContext.getOut()=org.apache.jasper.
[EMAIL PROTECTED]
DEBUG [Thread-5] (DbFormTag.java:1600) - childElementOutput=<input type="hidden"
name="[EMAIL PROTECTED]" value="0%3A1%3A1-1%3A1%3A1"/><input type="hidden" name="k_17
[EMAIL PROTECTED]" value="0%3A1%3A2-1%3A1%3A1"/><input type="hidden" name="[EMAIL PROTECTED]" va
lue="0%3A1%3A3-1%3A1%3A1"/><input type="hidden" name="[EMAIL PROTECTED]" value="0%3A1%
3A5-1%3A1%3A1"/>
INFO [Thread-5] (DbFormTag.java:1645) - end reached of docproduit
INFO [Thread-5] (DbFormTag.java:2325) - doFinally called
----- Original Message ----- From: Shawn Date: Sun, 08 Feb 2004 10:20:33 +0900 To: debejarry gilles ,[EMAIL PROTECTED] Subject: Re: [dbforms] BLOB PROBLEM
> I get this message when i try to open blob field.
>
> java.io.EOFException
> at
> java.io.ObjectInputStream$PeekInputStream.readFully(ObjectInputStream.java:2165)
> at
> java.io.ObjectInputStream$BlockDataInputStream.readShort(ObjectInputStream.java:2634)
> at java.io.ObjectInputStream.readStreamHeader(ObjectInputStream.java:734)
> at java.io.ObjectInputStream.(ObjectInputStream.java:253)
> at org.dbforms.servlets.FileServlet.readDbFieldBlob(FileServlet.java:224)
> Any Idea ?
What version of dbforms?
Are you using log4j logging? If so, what does it show?
If not using log4j, output usually goes to catalina.out (tomcat_home/logs). Does it show anything there that could help the problem get pinned down?
-- Shawn
Happily using M2, Opera's revolutionary e-mail client: http://www.opera.com/m2/
------------------------------------------------------- The SF.Net email is sponsored by EclipseCon 2004 Premiere Conference on Open Tools Development and Integration See the breadth of Eclipse activity. February 3-5 in Anaheim, CA. http://www.eclipsecon.org/osdn _______________________________________________ DbForms Mailing List
http://www.wap-force.net/dbforms
-- Shawn
Happily using M2, Opera's revolutionary e-mail client: http://www.opera.com/m2/
------------------------------------------------------- The SF.Net email is sponsored by EclipseCon 2004 Premiere Conference on Open Tools Development and Integration See the breadth of Eclipse activity. February 3-5 in Anaheim, CA. http://www.eclipsecon.org/osdn _______________________________________________ DbForms Mailing List
http://www.wap-force.net/dbforms
