Login  Register

Re: [OFBiz] Users - Postgres 8.1

Posted by Si Chen-2 on Nov 14, 2005; 10:48pm
URL: http://ofbiz.116.s1.nabble.com/OFBiz-Users-Postgres-8-1-tp136415p136421.html

Manuel,

Do you think this can be done?
http://jira.undersunconsulting.com/browse/OFBIZ-580

(Basically, storing an image into the database using the entity engine's
GenericEntity.setBytes(...) method.)

Si

Manuel Meyer wrote:

>Hi Si,
>Tell me what you think and I'll be glad to give a hand
>
>Regards,
>Manuel
>
>-----Message d'origine-----
>De : [hidden email] [mailto:[hidden email]] De
>la part de Si Chen
>Envoyé : Friday, November 11, 2005 6:38 PM
>À : OFBiz Users / Usage Discussion
>Objet : Re: [OFBiz] Users - Postgres 8.1
>
>Hmm...  Reading that thread again, it seems that the default BLOB type
>in postgresql of OID is good enough for null data, so loading should be
>fine.  The problem we had originally experienced was one with storing
>images (shipping labels) into BLOB.
>
>I think the only way to test this is to expand the entity engine tests
>and make it try to store an image (like the OFBiz logo) into the
>database.  I got this started with
>http://jira.undersunconsulting.com/browse/OFBIZ-550
>
>Can anyone help with this?
>
>David - would you mind committing my patch when you have a chance?  I
>have access to EntityEngineTest.java but not to entitymodel_test.xml.
>
>Thanks,
>
>Si
>
>Manuel Meyer wrote:
>
>  
>
>>Hi Amigos,
>>I've done 2 things so far:
>>
>>- I've backed up a DB from a running site and loaded it on a test site with
>>version 8.1 and played around with - no errors (but no really deep and hard
>>tests also, just a quick check)
>>- I've downloaded and installed the last SVN release and did a run install
>>and played around, no errors.
>>
>>Regarding the JIRA issue, if you tell me what to test, I can do a test
>>    
>>
>using
>  
>
>>the last SVN and I'll be happy to give you the results I get.
>>
>>Best regards,
>>Manuel
>>
>>
>>-----Message d'origine-----
>>De : [hidden email] [mailto:[hidden email]]
>>    
>>
>De
>  
>
>>la part de Jacques Le Roux
>>Envoyé : Friday, November 11, 2005 10:52 AM
>>À : OFBiz Users / Usage Discussion
>>Objet : Re: [OFBiz] Users - Postgres 8.1
>>
>>Hello Si and Manue,
>>
>>I tried also 8.1 on WIndows and yes it's really quicker and I got no error
>>on
>>run-install
>>
>>Jacques
>>
>>----- Original Message -----
>>From: "Si Chen" <[hidden email]>
>>To: "OFBiz Users / Usage Discussion" <[hidden email]>
>>Sent: Friday, November 11, 2005 1:24 AM
>>Subject: Re: [OFBiz] Users - Postgres 8.1
>>
>>
>>
>>
>>    
>>
>>>Manuel,
>>>
>>>Did you have any problems with Postgresql 8.1 that are similar to the
>>>OID/BYTEA problems reported here:
>>>http://jira.undersunconsulting.com/browse/OFBIZ-334
>>>
>>>Did you encounter any problems installing seed data or quick shipping
>>>orders?
>>>
>>>Si
>>>
>>>Manuel Meyer wrote:
>>>
>>>  
>>>
>>>      
>>>
>>>>Hi All,
>>>>
>>>>Postgres 8.1 has been released, and it looks much faster under win32 than
>>>>8.0.
>>>>The Postgres team is saying that they made a big performance effort on
>>>>    
>>>>
>>>>        
>>>>
>>the
>>
>>
>>    
>>
>>>>win32 version, and I have the impression that it is clearly visible.
>>>>When you checkout an order, the checkout process is closed to
>>>>    
>>>>
>>>>        
>>>>
>>instantaneous,
>>
>>
>>    
>>
>>>>while it was taking a couple of seconds with 8.0. (same date base
>>>>    
>>>>
>>>>        
>>>>
>>restored
>>
>>
>>    
>>
>>>>under 8.1, same OFBiz version, same machine)
>>>>
>>>>Has anyone tested and share the same impression?
>>>>
>>>>Best regards,
>>>>Manuel Meyer
>>>>
>>>>
>>>>
>>>>
>>>>_______________________________________________
>>>>Users mailing list
>>>>[hidden email]
>>>>http://lists.ofbiz.org/mailman/listinfo/users
>>>>
>>>>
>>>>
>>>>    
>>>>
>>>>        
>>>>
>>>_______________________________________________
>>>Users mailing list
>>>[hidden email]
>>>http://lists.ofbiz.org/mailman/listinfo/users
>>>  
>>>
>>>      
>>>
>>_______________________________________________
>>Users mailing list
>>[hidden email]
>>http://lists.ofbiz.org/mailman/listinfo/users
>>
>>__________ NOD32 1.1283 (20051110) Information __________
>>
>>This message was checked by NOD32 antivirus system.
>>http://www.eset.com
>>
>>
>>
>>_______________________________________________
>>Users mailing list
>>[hidden email]
>>http://lists.ofbiz.org/mailman/listinfo/users
>>
>>
>>
>>    
>>
>
>_______________________________________________
>Users mailing list
>[hidden email]
>http://lists.ofbiz.org/mailman/listinfo/users
>
>__________ NOD32 1.1284 (20051111) Information __________
>
>This message was checked by NOD32 antivirus system.
>http://www.eset.com
>
>
>
>_______________________________________________
>Users mailing list
>[hidden email]
>http://lists.ofbiz.org/mailman/listinfo/users
>
>  
>
 
_______________________________________________
Users mailing list
[hidden email]
http://lists.ofbiz.org/mailman/listinfo/users