Обсуждение: The use of Jive with postgresql
-----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\027\
200\240\016T\301X\002\000\001L\000\007messaget\000%Lcom/coolservlets/forum/For
umMessage;xppsr\000\024java.util.Properties9\022\320zp6>\230\002\000\001L\000\
010defaultsq\000~\000\001xr\000\023java.util.Hashtable\023\273\017%!J\344\270\
003\000\002F\000\012loadFactorI\000\011thresholdxp?@\000\000\000\000\000\010w\
010\000\000\000\013\000\000\000\000xpsq\000~\000\005?@\000\000\000\000\000\010
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\027\
200\240\016T\301X\002\000\001L\000\007messaget\000%Lcom/coolservlets/forum/For
umMessage;xppsr\000\024java.util.Properties9\022\320zp6>\230\002\000\001L\000\
010defaultsq\000~\000\001xr\000\023java.util.Hashtable\023\273\017%!J\344\270\
003\000\002F\000\012loadFactorI\000\011thresholdxp?@\000\000\000\000\000\010w\
010\000\000\000\013\000\000\000\000xpsq\000~\000\005?@\000\000\000\000\000\010
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.java
: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:131
3)
at
progress.message.jclient.QueueSession.run(progress/message/jclient/QueueSessio
n.java:
623)
at
progress.message.jclient.sl.run(progress/message/jclient/Session$SessionThread
.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-----
-----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-----
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) > >