Yes, if I go into the database with the command line tool psql, I see there is a row in the database. but if I issue a select statement, the data is unviewable. I expected to see text (gibberish), which is making me think that the data is entering the backend encoded in some way.
--- On Fri, 9/24/10, Henrique Gomes <[email protected]> wrote: > From: Henrique Gomes <[email protected]> > Subject: Re: erattachment help > To: "Theodore Petrosky" <[email protected]> > Cc: "WebObjects-Dev Mailing List List" <[email protected]> > Date: Friday, September 24, 2010, 7:04 PM > > Can't tell whats wrong either.... > > On Sep 24, 2010, at 5:45 PM, Theodore Petrosky wrote: > > > ok. so I am still trying to get erattachment working. > I have a little test app. > > > > I can select an image (pdf, jpg) and 'upload' it. When > I click its link it will show in the ERAttachmentViewer. > > > > however if I quit and relaunch my app, the images do > not reload from the database (postgresql). > > > > i see in the eclipse logs: > > > > evaluateExpression: > <com.webobjects.jdbcadaptor.PostgresqlExpression: "SELECT > t0.attachmentDataID, t0.available, t0.configurationName, > t0.creationDate, t0.filesystemPath, t0.height, t0.id, > t0.mimeType, t0.originalFileName, t0.ownerID, t0.parentID, > t0.proxied, t0.s3Path, t0.size, t0.smallData, > t0.storageType, t0.thumbnail, t0.webPath, t0.width FROM > ERAttachment t0 WHERE ((t0.storageType = ?::varchar(10) OR > t0.storageType = ?::varchar(10) OR t0.storageType = > ?::varchar(10)) AND t0.id = ?::int4) LIMIT 1" withBindings: > 1:"db"(storageType), 2:"file"(storageType), > 3:"s3"(storageType), 4:1(id)> > > > > Sep 24 12:28:12 AttachmentTest[54058] DEBUG > NSLog - fetch canceled > > Sep 24 12:28:12 AttachmentTest[54058] DEBUG > NSLog - 1 row(s) processed > > > > > > Why the fetch canceled, I don't know. Little things I > see that shouldn't matter, 'FROM ERAttachment'. of course > postgresql will fold the name to lowercase automatically and > my table is named erattachment so this shouldn't matter. > > > > I see in the postgresql logs right after I click the > hyperlink to view the image: > > > > [unknown]LOG: execute <unnamed>: SELECT > t0.data, t0.id FROM ERAttachmentData t0 WHERE t0.id = > $1::int4 > > [unknown]DETAIL: parameters: $1 = '1' > > > > Is there data on the table ERAttachmentData? Does the log > show 1 row(s) processed? > > > > so it is trying to get the link. maybe I am saving bad > data? > > > > should I be massaging the data before trying to save > it to the backend? > > > > I do have in my properties file: > > > > er.attachment.ImageMeta.image.storageType=db > > > > > > my migrations and connection dict look like: > > > > # Migrations > > er.migration.migrateAtStartup=true > > er.migration.createTablesIfNecessary=true > > er.migration.modelNames=AttachmentTest > > > AttachmentTest.MigrationClassPrefix=com.eltek.migrations.AttachmentTestMigration > > > > # Connection Dictionary > > > dbConnectURLGLOBAL=jdbc:postgresql://localhost/attachmenttest?capitalizeTypenames=true&zeroDateTimeBehavior=convertToNull > > dbConnectUserGLOBAL=asacksadmin > > dbConnectPasswordGLOBAL=4004 > > dbConnectPluginGLOBAL=PostgresqlPlugIn > > dbConnectDriverGLOBAL=org.postgresql.Driver > > > > > > > > > > html > > > > <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML > 3.2//EN"> > > <html> > > <head> > > <title>Untitled</title> > > </head> > > <body> > > <webobject name = "TheForm"> > > <ul> > > <wo:loop list = > "$theMetaList" item = "$theMeta"> > > <li> > > > <wo:WOHyperlink action = "$selectMeta"><wo:WOString > value = "$theMeta.imageTitle" /></wo:WOHyperlink> > > </li> > > </wo:loop> > > </ul> > > <webobject name = "ImageUpload" > /> > > <webobject name = > "UploadAction" /><br/> > > <webobjects name = > "TheAttachmentViewer" /> > > </webobject> > > </body> > > </html> > > > > WOD > > > > ImageUpload : ERAttachmentUpload { > > configurationName = > "ImageMeta.image"; > > editingContext = theEC; > > attachment = > theNewMeta.image; > > } > > > > TheForm : WOForm { > > enctype = > "multipart/form-data"; > > multipleSubmit = true; > > } > > > > > > UploadAction : WOSubmitButton { > > action = uploadImage; > > value = "Upload Avatar!"; > > } > > > > TheAttachmentViewer : ERAttachmentViewer { > > attachment = > theSelectedMeta.image; > > width = 150; > > } > > > > > > main.java > > > > package com.eltek.components; > > > > import com.eltek.models.ImageMeta; > > import com.eltek.models.People; > > import com.webobjects.appserver.WOContext; > > > > import er.extensions.components.ERXComponent; > > import er.extensions.eof.ERXEC; > > > > import com.webobjects.appserver.WOActionResults; > > import com.webobjects.eocontrol.EOEditingContext; > > import com.webobjects.foundation.NSArray; > > import com.webobjects.foundation.NSLog; > > > > public class Main extends ERXComponent { > > > > public EOEditingContext theEC; > > public NSArray<ImageMeta> > theMetaList; > > public ImageMeta theMeta, > theNewMeta, _theSelectedMeta; > > > > > > public People thePerson; > > > > public Main(WOContext context) { > > super(context); > > > > theEC = > ERXEC.newEditingContext(); > > thePerson = > People.fetchPeople(theEC, null); > > > > theMetaList = > ImageMeta.fetchImageMetas(theEC, null, null); > > > > theNewMeta = > ImageMeta.createImageMeta(theEC, "the title", thePerson); > > > > > NSLog.out.appendln("******** refreshing > theMetaList.count() " + theMetaList.count()) ; > > > > } > > > > public WOActionResults > uploadImage() { > > > theEC.saveChanges(); > > theMetaList = > ImageMeta.fetchImageMetas(theEC, null, null); > > theNewMeta = > ImageMeta.createImageMeta(theEC, "the title", thePerson); > > return null; > > } > > > > public WOActionResults selectMeta() > { > > > NSLog.out.appendln("******** refreshing selectMeta() > ") ; > > > > > setTheSelectedMeta(theMeta); > > return null; > > } > > > > public ImageMeta theSelectedMeta() > { > > return > _theSelectedMeta; > > } > > > > public void > setTheSelectedMeta(ImageMeta aMeta) { > > > this._theSelectedMeta = aMeta; > > } > > } > > > > > > > > > > > > _______________________________________________ > > Do not post admin requests to the list. They will be > ignored. > > Webobjects-dev mailing list ([email protected]) > > Help/Unsubscribe/Update your Subscription: > > http://lists.apple.com/mailman/options/webobjects-dev/lists%40farol.pt > > > > This email sent to [email protected] > > _______________________________________________ Do not post admin requests to the list. They will be ignored. Webobjects-dev mailing list ([email protected]) Help/Unsubscribe/Update your Subscription: http://lists.apple.com/mailman/options/webobjects-dev/archive%40mail-archive.com This email sent to [email protected]
