Home > large objects > org.postgresql.util.psqlexception error invalid large-object descriptor 0

Org.postgresql.util.psqlexception Error Invalid Large-object Descriptor 0

Contents

Red Hat Inc. All rights reserved. JBoss and Hibernate are registered trademarks and servicemarks of Red Hat, Inc.

pgsql-announce pgsql-bugs pgsql-docs pgsql-general pgsql-interfaces pgsql-jobs pgsql-novice pgsql-performance pgsql-php pgsql-sql pgsql-students Developer lists Regional lists Associations User groups Project lists Inactive lists IRC Local User Groups Featured Users International Sites Propaganda Resources Weekly News Re: Invalid large object descriptor : 0 with autocommit From: "Michael Paesold" To: "aditya Kulkarni" , Subject: Re: Invalid large object descriptor : 0 with https://forum.hibernate.org/viewtopic.php?f=1&t=958767 autocommit Date: 2004-09-18 12:50:21 Message-ID: 002701c49d7e$0f059240$d604460a@zaphod (view raw or whole thread) Thread: 2004-09-16 08:07:09 from aditya Kulkarni 2004-09-18 12:50:21 from "Michael Paesold" Lists: pgsql-general Aditya Kulkarni wrote: > I have an application that ran on Oracle, and the application, for > some reason requires https://www.postgresql.org/message-id/002701c49d7e$0f059240$d604460a@zaphod autocommit to be true. Now, when we moved this > application to postgres, we moved the blob column to LargeObjects. > > But PostgreSQL doesn't seem to be able to use Large Objects with > autoCommit = true. Is there any other way to work around this problem > ? Large objects access only works inside transactions. Workaround: use bytea datatype for blob instead of large objects http://www.postgresql.org/docs/7.4/static/datatype-binary.html Best Regards, Michael Paesold In response to Invalid large object descriptor : 0 with autocommit at 2004-09-16 08:07:09 from aditya Kulkarni pgsql-general by date Next:From: Marc G. FournierDate: 2004-09-18 13:39:03 Subject: Re: Mail delivery failed: returning message to sender Previous:From: Russell SmithDate: 2004-09-18 08:57:11 Subject: Re: Mail delivery failed: returning message to sender Privacy Policy | About PostgreSQL Copyright © 1996-2016 The PostgreSQL Global Development Group

BoardInsert Lucidchart Diagram ExportXMLWordPrintable Details Type: Bug Status: Closed Resolution: Fixed Affects Version/s: 6.1.1 http://osdir.com/ml/java-jboss-user/2006-01/msg01509.html CE GA2, 6.1.20 EE GA2 Fix Version/s: 6.1.30 EE GA3, 6.2.0 CE M2 Component/s: large objects Environments, Environments > Databases Labels: QA-F QA-R Environment: Jboss 5.1, Tomcat 6, Jboss 5.1, Nuxeo DM 5.5.0-HF6, OpenJDK 6. FreeBSD 8.3 RC2, Liferay 6.1.+ CE. PostgreSQL 9.1 Branch Version/s: 6.1.x large objects may Backported to Branch: Committed Fix Priority: 5 Description I'm Using these settings in portal-ext.properties. image.hook.impl=com.liferay.portal.image.DatabaseHook dl.store.impl=com.liferay.portlet.documentlibrary.store.DBStore changing the Logo from the portal and store the new one as blob inside the database provides these expation 17:26:30,712 ERROR [ImageProcessorImpl:269] java.io.IOException: org.postgresql.util.PSQLException: ERROR: invalid large-object descriptor: 1 java.io.IOException: org.postgresql.util.PSQLException: ERROR: invalid large-object descriptor: 1 at org.postgresql.largeobject.BlobInputStream.read(BlobInputStream.java:98) at java.io.InputStream.read(InputStream.java:170) at java.io.InputStream.read(InputStream.java:101) at com.liferay.portal.kernel.util.StreamUtil.transferByteArray(StreamUtil.java:206) at com.liferay.portal.kernel.util.StreamUtil.transfer(StreamUtil.java:162) at com.liferay.portal.kernel.util.StreamUtil.transfer(StreamUtil.java:129) at com.liferay.portal.util.FileImpl.getBytes(FileImpl.java:401) at com.liferay.portal.util.FileImpl.getBytes(FileImpl.java:387) at com.liferay.portal.util.FileImpl.getBytes(FileImpl.java:381) at com.liferay.portal.kernel.util.FileUtil.getBytes(FileUtil.java:153) at com.liferay.portlet.documentlibrary.util.ImageProcessorImpl._generateImages(ImageProcessorImpl.java:248) at com.liferay.portlet.documentlibrary.util.ImageProcessorImpl.generateImages(ImageProcessorImpl.java:85) at com.liferay.portlet.documentlibrary.util.ImageProcessorUtil.generateImages(ImageProcessorUtil.java:38) at com.liferay.portlet.documentlibrary.messaging.ImageProcessorMessageListener.doReceive(ImageProcessorMessageListener.java:36) at com.liferay.portal.kernel.messaging.BaseMessageListener.receive(BaseMessageListener.java:25) at com.liferay.portal.kernel.messaging.InvokerMessageListener.receive(InvokerMessageListener.java:63) at com.liferay.portal.kernel.messaging.SerialDestination$1.run(

release that contain the fix and compile it. If you browse the forum or the sources under cvs you will probably find it. I plan to do this also. hope this helps. View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=3916987#3916987 Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=3916987 ------------------------------------------------------- This SF.net email is sponsored by: Splunk Inc. Do you grep through log files for problems? Stop! Download the new AJAX search engine that makes searching your log files as easy as surfing the web. DOWNLOAD SPLUNK! http://ads.osdn.com/?ad_id=7637&alloc_id=16865&op=click Thread at a glance: Previous Message by Date: [JBoss Portal] - Re: Portal 2.2 - virtual portal / theme / layout / context r Thank you. Portal 2.2 is a major release compare to 2.0 - although it claims to be minor. Deployment package is really a great feature: it allows me to release separately core sw package, virtual portal and client package(theme+layout), facilitating a deployement policy for maintainance release of each. I had really difficulties to deploy my application the first time - first I got crazy because of the if-exists "keep" attribute that I copied from the example (errors became persistent) and second I mispelled the "-object.xml" file by adding an "s" to object. I wasted hours. I suggest more traces in parsing all these descriptors. Thanks again. View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=3916985#3916985 Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=3916985 ------------------------------------------------------- This SF.net email is sponsored by: Splunk Inc. Do you grep through log files for problems? Stop! Download the new AJAX se

 

Related content

org.postgresql.util.psqlexception error invalid large-object descriptor

Org postgresql util psqlexception Error Invalid Large-object Descriptor p here for a quick overview of relatedl the site Help Center Detailed answers to large objects may not be used in auto-commit mode postgres any questions you might have Meta Discuss the workings and org hibernate exception genericjdbcexception large objects may not be used in auto-commit mode policies of this site About Us Learn more about Stack Overflow the company Business Learn more sql error sqlstate p about hiring developers or posting ads with us Stack Overflow Questions Jobs Documentation Tags Users Badges Ask Question x Dismiss Join the Stack Overflow

psqlexception error invalid large-object descriptor 0

Psqlexception Error Invalid Large-object Descriptor table id toc tbody tr td div id toctitle Contents div ul li a href Org hibernate exception genericjdbcexception Large Objects May Not Be Used In Auto-commit Mode a li ul td tr tbody table p Red Hat Inc All rights reserved JBoss and Hibernate are registered trademarks and servicemarks of Red Hat Inc p p here for a quick overview of the site Help Center Detailed answers to any relatedl questions you might have Meta Discuss the workings and policies of this site About Us Learn more about Stack Overflow the company Business Learn