Re: The use of Jive with postgresql - Mailing list pgsql-jdbc

Ned,

This is due to a functionality change in the 7.2 drivers from 7.1.  In
7.2 the drivers support 'bytea' as the standard binary datatype for
postgresql.  In 7.1 and earlier the standard binary datatype was assumed
to be 'oid' and further assumed that 'oid' meant LargeObject.

The 1.2.4 Jive tables store binary data (column filterObject in table
JiveFilter).  It is interesting to note that in Jive 2 they no longer
are storing any binary data.

There are two ways to deal with this:

Change the datatype of the JiveFilter.filterObject column to be bytea
instead of oid.  (however if you already have a populated database that
probably isn't an option).

or

Have the driver revert back to the old behavior.  The 7.2 driver has a
compatibility mode that allows you to switch the behavior back to what
it was in the 7.1 release.  By passing the parameter 'compatible=7.1' to
your connection you should get the old behavior.  This can be done by
adding '?compatible=7.1' onto the end of the JDBC connection URL (i.e.
jdbc:postgresql://localhost:5432/mydb?compatible=7.1 )

thanks,
--Barry



Ned Wolpert wrote:

> -----BEGIN PGP SIGNED MESSAGE-----
> Hash: SHA1
>
> The driver this fails under is the 7.2b1 driver, not the one released with
> 7.1.3.  CVS-wise, it worked until sometime in May/June.  I was mistaken about
> it not working with the 7.1.x dirver.
>
>
> On 02-Nov-2001 Ned Wolpert wrote:
>
>>-----BEGIN PGP SIGNED MESSAGE-----
>>Hash: SHA1
>>
>>Folks-
>>
>>  (Hopefullly) quick question; There is a forum product out there called
>>'Jive', which stores information into postgresql.  However, there is a
>>problem in the driver where the parsing fails in certain cases. I'm trying
>>to
>>debug what the problem is.  (This is seen in 7.1.x and beta1 versions of
>>the
>>driver.)
>>
>>Here is the stack trace.  It can't parse a specific entry for the prepared
>>statement properly... can anyone find the culpret?  (For those who might
>>use
>>Jive, its with version 1.2.4, their free one.)
>>
>>Thanks!
>>
>>java.sql.SQLException: ERROR:  oidin: error in
>>"\254\355\000\005sr\000(com.coolservlets.forum.filter.FilterHtmla\210$\374OZ
>>)\
>>351\002\000\002L\000\020propDescriptionst\000\026Ljava/util/Properties;L\000
>>\0
>>05propsq\000~\000\001xr\000)com.coolservlets.forum.ForumMessageFilter\020\02
>>7\
>>200\240\016T\301X\002\000\001L\000\007messaget\000%Lcom/coolservlets/forum/F
>>or
>>umMessage;xppsr\000\024java.util.Properties9\022\320zp6>\230\002\000\001L\00
>>0\
>>010defaultsq\000~\000\001xr\000\023java.util.Hashtable\023\273\017%!J\344\27
>>0\
>>003\000\002F\000\012loadFactorI\000\011thresholdxp?@\000\000\000\000\000\010
>>w\
>>010\000\000\000\013\000\000\000\000xpsq\000~\000\005?@\000\000\000\000\000\0
>>10
>>w\010\000\000\000\013\000\000\000\000xp":
>>can't parse
>>"\254\355\000\005sr\000(com.coolservlets.forum.filter.FilterHtmla\210$\374OZ
>>)\
>>351\002\000\002L\000\020propDescriptionst\000\026Ljava/util/Properties;L\000
>>\0
>>05propsq\000~\000\001xr\000)com.coolservlets.forum.ForumMessageFilter\020\02
>>7\
>>200\240\016T\301X\002\000\001L\000\007messaget\000%Lcom/coolservlets/forum/F
>>or
>>umMessage;xppsr\000\024java.util.Properties9\022\320zp6>\230\002\000\001L\00
>>0\
>>010defaultsq\000~\000\001xr\000\023java.util.Hashtable\023\273\017%!J\344\27
>>0\
>>003\000\002F\000\012loadFactorI\000\011thresholdxp?@\000\000\000\000\000\010
>>w\
>>010\000\000\000\013\000\000\000\000xpsq\000~\000\005?@\000\000\000\000\000\0
>>10
>>w\010\000\000\000\013\000\000\000\000xp"
>>        at org.postgresql.core.QueryExecutor.execute(Unknown Source)
>>        at org.postgresql.Connection.ExecSQL(Unknown Source)
>>        at org.postgresql.jdbc2.Statement.execute(Unknown Source)
>>        at org.postgresql.jdbc2.PreparedStatement.execute(Unknown Source)
>>        at
>>com.coolservlets.forum.database.DbForum.saveFiltersToDb(DbForum.java:1092)
>>        at com.coolservlets.forum.database.DbForum.<init>(DbForum.java:162)
>>        at
>>com.coolservlets.forum.database.DbForumFactory.createForum(DbForumFactory.ja
>>va
>>:131)
>>        at
>>com.coolservlets.forum.ForumFactoryProxy.createForum(ForumFactoryProxy.java:
>>85
>>)
>>        at
>>org.mv5.delivery.runtime.CreateForumHandler.handleMessage(CreateForumHandler
>>.j
>>ava:48)
>>        at
>>org.mv5.delivery.runtime.MessageServer.onMessage(MessageServer.java:70)
>>        at
>>progress.message.jclient.Session.ew_(progress/message/jclient/Session.java:1
>>31
>>3)
>>        at
>>progress.message.jclient.QueueSession.run(progress/message/jclient/QueueSess
>>io
>>n.java:
>>623)
>>        at
>>progress.message.jclient.sl.run(progress/message/jclient/Session$SessionThre
>>ad
>>.java:1
>>240)
>>
>>
>>
>>Virtually,
>>Ned Wolpert <ned.wolpert@knowledgenet.com>
>>
>>D08C2F45:  28E7 56CB 58AC C622 5A51  3C42 8B2B 2739 D08C 2F45
>>-----BEGIN PGP SIGNATURE-----
>>Version: GnuPG v1.0.6 (GNU/Linux)
>>Comment: For info see http://www.gnupg.org
>>
>>iD8DBQE74vruiysnOdCML0URAqRMAJ0TG2VgRCn63q+rGbqpyuznUGefKwCeIXTu
>>unwWStt+DVE1brHKs6ixow0=
>>=1PPk
>>-----END PGP SIGNATURE-----
>>
>>---------------------------(end of broadcast)---------------------------
>>TIP 5: Have you checked our extensive FAQ?
>>
>>http://www.postgresql.org/users-lounge/docs/faq.html
>>
>
>
> Virtually,
> Ned Wolpert <ned.wolpert@knowledgenet.com>
>
> D08C2F45:  28E7 56CB 58AC C622 5A51  3C42 8B2B 2739 D08C 2F45
> -----BEGIN PGP SIGNATURE-----
> Version: GnuPG v1.0.6 (GNU/Linux)
> Comment: For info see http://www.gnupg.org
>
> iD8DBQE74wvQiysnOdCML0URAlthAJ9GZ3EDRiAo0PW9xxMSt57Ver5pKQCfWjvC
> 9T/gfnW3rC0TDKVqHNc/pgw=
> =DqF1
> -----END PGP SIGNATURE-----
>
> ---------------------------(end of broadcast)---------------------------
> TIP 2: you can get off all lists at once with the unregister command
>     (send "unregister YourEmailAddressHere" to majordomo@postgresql.org)
>
>