Craig, It has to Value.setPreparedStatementValue method and accepting a Blob. It tried to insert using the prepared statement using a simple string instead of inserting the Blob and then updating it using the InputStream. I have not looked at the Village 1.5.3 code to see if this has changed. I have attached a junit test case if you care to reproduce and isolate this behaviour.
I also seem to remember different behaviour of the Blob prepared insert depending upon if the jdk1.2 or jdk1.1 version of db2java.zip was used. -----Original Message----- From: Setera, Craig [mailto:[EMAIL PROTECTED]] Sent: Tuesday, April 23, 2002 2:31 PM To: 'Jetspeed Developers List' Subject: RE: Village source code? Mike, I appreciate your response. Unfortunately the version of village you sent me is downlevel with respect to the current CVS level (1.5.2 instead of 1.5.3). I tried it anyway and it blew up on me. Can you tell me what you had to change to get it to work with DB2? Do you know how to get ahold of a copy of the 1.5.3 sources to make the change? Thanks, Craig -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Tuesday, April 23, 2002 4:23 PM To: [EMAIL PROTECTED] Subject: RE: Village source code? Craig, We had the same problem (on DB2). There was a bug with the BLOB datatype also. Here is the patched code. Mike Thompson -----Original Message----- From: Setera, Craig [mailto:[EMAIL PROTECTED]] Sent: Tuesday, April 23, 2002 11:21 AM To: '[EMAIL PROTECTED]' Subject: Village source code? Hi. I'm trying to host Jetspeed (CVS version from a week or so again) on top of a DB2 UDB on NT database. After a lot of fighting, I've managed to get the tables created and the initial data installed. I've also been able to log in using this data. So, I've made some progress. Now, I'm trying to get "create new account" going and I'm getting errors from the database. It doesn't appear to like either the data being sent or the way that it is being sent. My theory is that it is the byte array in the objectdata column that is causing problems, but the database isn't talking. I'd like to be able to debug all the way into the village code, but I don't have the source. www.working-dogs.com doesn't seem to be accessible (at least for me). Is this source available somewhere else? Is it available at all? I don't know much at all about Village. What is the license on the code? Thanks for any help you can give me. Craig Craig Setera Sun Certified Java Programmer/Developer/Web Component Developer Senior Software Architect, Kingland Systems Corporation [EMAIL PROTECTED] (507) 536-3605 -- To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]> For additional commands, e-mail: <mailto:[EMAIL PROTECTED]> -- To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]> For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>
VillageTest.java
Description: Binary data
-- To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]> For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>