IDP V3: LockTimeoutException with remote PG DB

[Etienne Dysli-Metref]

On 21/10/15 07:05, Daniel Fisher wrote:
>     <?xml version="1.0" encoding="UTF-8"?>
>     <entity-mappings xmlns="http://java.sun.com/xml/ns/persistence/orm"
>                      xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
>                    
>      xsi:schemaLocation="http://java.sun.com/xml/ns/persistence/orm
>                                        
>      http://java.sun.com/xml/ns/persistence/orm_1_0.xsd" version="1.0">
>       <package>org.opensaml.storage.impl</package>
> 
>       <entity class="JPAStorageRecord" access="PROPERTY">
>         <attributes>
>           <basic name="value">
>             <column name="value" nullable="false"/>
>           </basic>
>         </attributes>
>       </entity>
>     </entity-mappings>
> 
> Drop this into WEB-INF/classes/META-INF/orm.xml and see if large object
> references continue to be generated.

OK so I tried that and I now get the actual value in the column instead
of an OID. The only problem is, if I drop the table and let Hibernate
recreate it, the type of the "value" column is set to varchar(255)
instead of text and the IdP can't work with that. So manually creating
the StorageRecords table is required.

I created https://issues.shibboleth.net/jira/browse/OSJ-135 to track this.

  Etienne

-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 836 bytes
Desc: OpenPGP digital signature
URL: <http://shibboleth.net/pipermail/users/attachments/20151021/3ae095a6/attachment-0001.sig>