Can Seam handle binary images from db resultset?
gonorrhea May 14, 2009 8:37 PMRegarding rendering images stored in a RDBMS table, is it possible to read and display a binary image in Seam app?
e.g.
SELECT [web_smallImage] FROM corg0dv01.[coxReports].[dbo].[temp_images_test]
result:
0xFFD8FFE000104A46494600010200006400640000FFEC00114475636B7900010004000000640000FFEE000E41646F62650064C000000001FFDB008400010101010101010101010101010101010101010101010101010101010101010101010101010101010101010202020202020202020202030303030303030303030101010101010102010102020201020203030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303FFC00011080068007803011100021101031101FFC4009D0001000006030101000000000000000000000304050708090102060B0A01010101010101000000000000000000000002010304051000010302050105040706030900000000010203040005111206070821314122130961D1521451819132922315714216171819A18233D435456536664728481101000104010205040203000000000000000111021203213141516171A11381E12204F03291B114FFDA000C03010002110311003F00FDFC5028140A05028140A05028140A05028140A05028140A05028140A05028140A05028140A05028140A05028140A05028140A05028140A05028140A05028140A05028140A050513526A4B068FB05E354EA9BC5BB4FE9CD3F6F9576BDDEEED29A856DB65BA134A7A54C9929F525A65965B492493EC1D48141A02DCFF005D37AD5AF2FF0067DA2D82635A682B74B30EC9ABB54EAFB8698B9EA2433F96FDD5160634DDC176CB7C97413190F3BF3059CAA750D2D45A44E5E02856FF005BDDDAB8C61293C66D1719B5ACA50246E5DE829601C0AD213A40928C7A0270C7BAB3296D213DFDEB3777103FA75D00927B8EE36A13F5FF00D26053291DFF00BD46EE9ECE3DEDE8EDFF00C83A8940E1EDFE1848E94CCA3A9F5A7DDF3D13B01B780F703AE751ABD98FFB8518F53599CD2A70807D6937A48F0EC2EDAA7E8CDAC75228777D16D4E34CE4E1057EB4BBDC9FBBB17B5FDDD0EABD52AFF110923B299C9C241CF5ABDF64E211B1BB5208F8F536AD3DBEC0C0A6725120E7AD7F2087FA7B21B407D86FFAC49F67EFA71270A67271579CBAFAE3F23ADAA404EC16D34842C7471ABC6B15A42C138B641988585E03A62003DD4CE58CA3E23FAD2691DD2D4CAD0DC97D236AD95BA5CE625AD31ADED3367CCDBF78BA96D08B66A776E45CB8698945FC724D716EC05255F9CA8C1199CA8BBC46F2E3C8625B0C4A8AFB3262C965B911A4C7710F3121879097197D879B529B75975B5052549252A49041C2A846A0506A5BD40ED16DDCE9AD684DC4DDBBE685DB9B6DD20B71F4A69EB389117525D459AD77B55DF53BE87DD953D9B49B812842D0DC2889425D524BB83955669D9BA6635F66CCD96C44DFD2583EC7A756D5E54F95AE7523C1C212D9458EDAB2BCD80484E5B978B363D30EDA8C67A57D978DAC639F65F4E6B4CD9B6C9DCF1D95893ED5324DB2E16E97BA7B551E5DBAE16F90E449B02546775921D8B2E149656D3ADA9216DAD0524020D235DDFC84CE3E74426E2FA6FA8628E796C6127A63FCDADA5C32E20E031D662B3E3BBC7DBEECFC7CD3E2CDE9D69C31E76EC834492521FDD4DA44E61D312336B449576F68ACF8E67D3D3EEDFC7BD536D5ABD3B13FFDD1B02F859094891BADB467020E24232EBF631C71F6D3E2BBF9056C4C8B5FA73A48079CBC78054024056EAED29C71230C0277113D4E423EB3F56FC577D3D3EE9FC3EA86EDA7D3897827FAEBE3E327EF8F2F76369FC49E831CBFCC451CA0A7BBBC9FA9F1DDF4F4FB918F9A0AF4F7A6FAD38FF5E7B01DC3AEECED48ECEDECDC34F654FC73E3ECAA594FBA45DD39E9B18292AE7DEC033DE47F3736A8603A1C48FE628FB6B309AF33ECD8B6C9F1488D13E9A72D611FDC2F60417084841DD9DA8585127001215B8C3139BB30ACC67BC985BE6CACFED77B5F716DA79ADCDBEA9B79B6DE69E6B4D42710EB2EA12B6DC439FC464388710A052A1D08208ADA4C2BE3B7B3639C33DAAD61C7E916CDBA87BCB7FD77B712D52A3DBB486ACB034BFE185316BBADC507495E117F7E5D9E23AFC54F9B11487E194E62DB4D38B53B55133134EC5DAE222B56C96ADC8A0D6DF2634F69DD45B897487A8EC76EBDC78D32CB7586CDCE322536C4D62C3686DB96C25C4F81680DE5E98A48041C7A8AAD7B2FD7333AEE9899E385636DD111745616FE0CF4312E18EC025472475C07E6A7123B6A5757CAFB7AEC7BDCDEFAEF8C1D352F54356E637A776D30E15B351BB162B4CCADC5D4B2434CC46E6B6DB6642D6A596C271512491DB5DEDFDEB74D9165D7CDB1DA2AE13FAD3B666EB6D899F463CB5A2F5AAEEAC5CAE167766B9FA83336638F4D82F3B29499287DF53AB75F25E71E09389513989EB5B76ED7744C4CCD67C931AEF8F45D6DCF5DEB59B5676E1D9AED2956E7A4AD4EDD136C8CB8F1DD69B433062945DA795446CA494825253DE547A8E5A6FB2C9ADDD1D2F8BAE8E3AA9BA12E9ABF41C0D5F6D6B40596FA357D9FF4A2FDE1D8E5FB4210CCF65532DC199013E78F9FC4E6E98B69F6D5DF7E9D975B74DDB2DC6EAFE3336C4F95DE31E5EAF77E87EFEDFD0D5BF4DBFAFF00A9BBE7B31AEED76ECBB5F13F96A99FE9773FDA39E23C1EDA5EE5EBA9AD4F4AF6934086EE28BE672DC46006D17CB4DAAD4E7945339272C46ED21C6FE9538A07A615DFFE9D33E2F9F4BE38A44A87ABF56EB4D69A4AEDA40ED6E8EB47EB7AFD1B86E5EAD2586AECC3E8B126C3FA1C671E94E25BB229B4079481862FF8B0EA6A277EA99EEA9CEEB31A44735AF75937B6EF59AF140B2A5B57438895071031E83A387127D9D6A6776A9F14C5B7C4F48987B1D33A4F71203B021CB17985638EF3921C163976272E2CAD61C507A1B5707998A5C53CE78B3AC0CA4F7F4A46ED713115BB0F76CDB752B11197B2E045D257396E4D80CB1B853245DEE101888EDCEF1A2D882FB2530E3045F20C68D3243C50EF989063C86F16B2740ACD5576FD185D6DB37D67A74F7FB269B32899C78EBD7D9F59BD39292D59AC91BA831ECD68630EA30F22DD19AECFF2D787BBD56F45E4DB191E66BBD2E9EB899F711D4FFDADA8D5F5FDDA4758FE762FFEB2CC9AE8E05063FEE06DE694D49A964DCEEF6832E629988C29E4CEB9C50B4331D01B2A6A1CC8ECA9C4A559739495948009C12900D858A1C52DA156AE4EB11137185D8CA327E513BE5BE28D2E975C4F967268A46E2A74734C253F7194C00CA15E24A02BAD3BB6AD5A5DB6078D10751EAD278B7C777DDB85E6F8D5C263BB03B4EF4EB979D729AA90F5CE739A4D52AEB265B8E296EBB254F29E714A52F32944989D7973482DBF1AC5679F37881C60E2A28848E22717C951091FFAD1B22312AC00E9FC11D3AD5E1DF84E51D153B9717F8CA551D73F891C6274A23B51582AE3B6CB4AC8C474E0DB492AD20F169B4255E14029401D80566333E0DAD1018E35F191B8AF4263891C67F955BEC4B7DA6F8DFB39E497E3625879C65BD1A1852DAEB956A415A7F7542AB1B99947546738E1C6774490E712B8D0AF9B9A8B8C9CDC6ED9E525D98D059121D0E68E579AF361D27CC7333A9CDD143138B09A72561D5CE37F199C61F65EE24F1A0C69138CD9095F1B76754D2E714A8171C4B9A354CB9232A8F8960BB81FBDDB4C64CBFCBBC5E3D718E0332D88BC50E3330CCE6BC89486B8E3B38C21E6866F03CDC7D1CD36FA3C47C2E05A7AF676D66326487178D1C5B71E4A18E24F187CD513930E366C8358900927CC568C6D29E9F49A6333C155619E30F1ADA790F1E23F1A5098CFB45C7DAE38EC91F21414DB8141D6B4828A5690A04149C41F6D275CC7342ADBDC6E32ED50D428D5C98DB808B9ACA247C9B7BD3BD2DE974A96C06FCB6B44237013A3198C941F0B48809692702120806A691555785F6D2BA42C367BC5B64C1B7F94F4653C865D724CD94A6C1B74C60AD225C97D21D534B524B9867214A18F88E3A4AEFD6A4A0F1F7BB4489B214E4791F2EAF35B5295E0C5684B2D2427C495E29CC9EA3018FD22B629DC9AF6709B425241F092083DA9EE38FD358DAB1CA571774FCB972E5BB70694E4B972A5ACAA0AF36694FB8F904A2E6DA0E42E618E518E1559268911C50B08585A6F4A490ACE948B73252920E200CD2D4481ED26B2B2D4ECAE2ED92584072F25010A2AC1BB7B4732940052959E628E6561D6B2381DE1F18AD301B92DC7BF2D2996D792F636E60928C163A1F9CE87059A4F3499ECE9AF6ECD517459348BA293C44F1F58FF0049C571C212C2C1D42AFCCF3B3616A8A3FD76DB6978612BA785A1855652E6812F8D16E9B19D88FEA1714C3B345C16916C8E0FCC867C80A07E6CE080DF7765665276A76524F1374E9FF8E3BD7FE5F1FF00DAB0A65274454714B4EA1213FAB2578127172D8D29471EE51139230FAA951D8714F4E8248BBB693882149B537991861F7319C70EA31EFA5464EB56C436DA118A4E442118E2918E4484E3DBDF85637AA762434B721A73C38A14A230231EACBA8FA71FDEA1CAB946141C1483DA01FDA01A0E3223E14FE11EEA06447C29FC23DD40C88F853F847BA81911F0A7F08F75032A7E14FD8281953F0A7EC140CA9F853F60A06447C29FC23DD40C88F853F847BA81911F0A7F08F7503223E14FE11EEA0E4240EC007EC00507340A05028140A05028140A05028140A05028140A05028140A05028140A05028140A05028140A05028140A05028140A05028140A0FFD9