On Tue, Jun 29, 2010 at 02:47:07PM +0200, Jan Pazdziora wrote:
>
> Hello,
>
> when I try to access the /rhn/Login.do page of my PostgreSQL-backended
> Spacewalk, I get the following traceback:
>
> 2010-06-29 11:16:41,052 [TP-Processor3] ERROR
> org.hibernate.util.JDBCExceptionReporter - Bad value for type long : <?xml
> version="1.0" encoding="UTF-8"?>\012 ... </rhn-cert>
> 2010-06-29 11:16:41,056 [TP-Processor3] WARN
> org.apache.struts.action.RequestProcessor - Unhandled Exception thrown: class
> com.redhat.rhn.common.hibernate.HibernateRuntimeException
> 2010-06-29 11:16:41,074 [TP-Processor3] ERROR
> com.redhat.rhn.frontend.servlets.SessionFilter - Error during transaction.
> Rolling back
> javax.servlet.ServletException:
> com.redhat.rhn.common.hibernate.HibernateRuntimeException: Executing query
> SatelliteCertificate.lookupNewestCertificate with params null failed
> at
> org.apache.struts.action.RequestProcessor.processException(RequestProcessor.java:535)
[...]
> Caused by: org.postgresql.util.PSQLException: Bad value for type long : <?xml
> version="1.0" encoding="UTF-8"?>\012 ... /rhn-cert>
> at
> org.postgresql.jdbc2.AbstractJdbc2ResultSet.toLong(AbstractJdbc2ResultSet.java:2796)
> at
> org.postgresql.jdbc2.AbstractJdbc2ResultSet.getLong(AbstractJdbc2ResultSet.java:2019)
> at
> org.postgresql.jdbc3g.Jdbc3gResultSet.getBlob(Jdbc3gResultSet.java:52)
> at
> org.postgresql.jdbc2.AbstractJdbc2ResultSet.getBlob(AbstractJdbc2ResultSet.java:335)
FYI, setting the certBlob to lazy
diff --git
a/java/code/src/com/redhat/rhn/domain/satellite/SatelliteCertificate.hbm.xml
b/java/code/src/com/redhat/rhn/domain/satellite/SatelliteCertificate.hbm.
index 4363d48..1989496 100644
--- a/java/code/src/com/redhat/rhn/domain/satellite/SatelliteCertificate.hbm.xml
+++ b/java/code/src/com/redhat/rhn/domain/satellite/SatelliteCertificate.hbm.xml
@@ -9,7 +9,7 @@ PUBLIC "-//Hibernate/Hibernate Mapping DTD 3.0//EN"
<meta attribute="scope-set">protected</meta>
</id>
<property name="label" column="LABEL" not-null="true" type="string"
length="64" />
- <property name="certBlob" column="CERT" not-null="true" type="blob" />
+ <property name="certBlob" column="CERT" not-null="true" type="blob"
lazy="true" />
<property name="issued" column="ISSUED" type="timestamp"
insert="false" update="false"/>
<property name="expires" column="EXPIRES" type="timestamp"
insert="false" update="false"/>
<property name="created" column="CREATED" not-null="true"
type="timestamp" insert="false" update="false"/>
did not help.
--
Jan Pazdziora
Principal Software Engineer, Satellite Engineering, Red Hat
_______________________________________________
Spacewalk-devel mailing list
Spacewalk-devel@redhat.com
https://www.redhat.com/mailman/listinfo/spacewalk-devel
