Обсуждение: What is "objsubid"?
Hi folks,
I get the following error when I try to use the getTables method. This is
with the latest stable drivers, pg73jdbc2.jar and pg73jdbc2ee.jar. This
method call was working fine with the earlier driver version, but that
version does not support the getColumnClassName() method, which I really
really need.
Please help me understand why I get this error. TIA.
ERROR: No such attribute or function 'objsubid'
java.sql.SQLException: ERROR: No such attribute or function 'objsubid'
at java.lang.Throwable.<init>(Throwable.java:96)
at java.lang.Exception.<init>(Exception.java:44)
at java.sql.SQLException.<init>(SQLException.java:84)
at org.postgresql.core.QueryExecutor.execute(QueryExecutor.java:131)
at
org.postgresql.jdbc1.AbstractJdbc1Connection.ExecSQL(AbstractJdbc1Connection.java:505)
at
org.postgresql.jdbc1.AbstractJdbc1Statement.execute(AbstractJdbc1Statement.java:320)
at
org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:48)
at
org.postgresql.jdbc1.AbstractJdbc1Statement.executeQuery(AbstractJdbc1Statement.java:153)
at
org.postgresql.jdbc1.AbstractJdbc1Statement.executeQuery(AbstractJdbc1Statement.java:141)
at
org.postgresql.jdbc1.AbstractJdbc1DatabaseMetaData.getTables(AbstractJdbc1DatabaseMetaData.java:2066)
at zerocode.dbSupport.Schema._getTableList(Schema.java:1121)
at
zerocode.dbSupport.Schema.buildFromConnectionMetaData(Schema.java:1062)
at DbSnapshot.main(DbSnapshot.java:219)
=====
------
M. A. Sridhar
m_a_sridhar@yahoo.com
__________________________________________________
Do you Yahoo!?
Yahoo! Mail Plus - Powerful. Affordable. Sign up now.
http://mailplus.yahoo.com
What version of the server are you running against? The objsubid is used to identify the table's comment in the pg_description table to supply the REMARKS column in the getTables() result set. Kris Jurka On Mon, 9 Dec 2002, M. A. Sridhar wrote: > Hi folks, > > I get the following error when I try to use the getTables method. This is > with the latest stable drivers, pg73jdbc2.jar and pg73jdbc2ee.jar. This > method call was working fine with the earlier driver version, but that > version does not support the getColumnClassName() method, which I really > really need. > > Please help me understand why I get this error. TIA. > > ERROR: No such attribute or function 'objsubid' > java.sql.SQLException: ERROR: No such attribute or function 'objsubid' > > at java.lang.Throwable.<init>(Throwable.java:96) > at java.lang.Exception.<init>(Exception.java:44) > at java.sql.SQLException.<init>(SQLException.java:84) > at org.postgresql.core.QueryExecutor.execute(QueryExecutor.java:131) > at > org.postgresql.jdbc1.AbstractJdbc1Connection.ExecSQL(AbstractJdbc1Connection.java:505) > at > org.postgresql.jdbc1.AbstractJdbc1Statement.execute(AbstractJdbc1Statement.java:320) > at > org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:48) > at > org.postgresql.jdbc1.AbstractJdbc1Statement.executeQuery(AbstractJdbc1Statement.java:153) > at > org.postgresql.jdbc1.AbstractJdbc1Statement.executeQuery(AbstractJdbc1Statement.java:141) > at > org.postgresql.jdbc1.AbstractJdbc1DatabaseMetaData.getTables(AbstractJdbc1DatabaseMetaData.java:2066) > at zerocode.dbSupport.Schema._getTableList(Schema.java:1121) > at > zerocode.dbSupport.Schema.buildFromConnectionMetaData(Schema.java:1062) > at DbSnapshot.main(DbSnapshot.java:219) > > > ===== > ------ > M. A. Sridhar > m_a_sridhar@yahoo.com > > __________________________________________________ > Do you Yahoo!? > Yahoo! Mail Plus - Powerful. Affordable. Sign up now. > http://mailplus.yahoo.com > > ---------------------------(end of broadcast)--------------------------- > TIP 3: if posting/reading through Usenet, please send an appropriate > subscribe-nomail command to majordomo@postgresql.org so that your > message can get through to the mailing list cleanly >
I'm running version 7.1.3 on a Red Hat Linux box (RH version 7.1, I think). If it matters, I'm using the IBM 1.3 JDK. --- Kris Jurka <books@ejurka.com> wrote: > > What version of the server are you running against? > > The objsubid is used to identify the table's comment in the > pg_description table to supply the REMARKS column in the getTables() > result set. > > Kris Jurka > > On Mon, 9 Dec 2002, M. A. Sridhar wrote: > > > Hi folks, > > > > I get the following error when I try to use the getTables method. This is > > with the latest stable drivers, pg73jdbc2.jar and pg73jdbc2ee.jar. This > > method call was working fine with the earlier driver version, but that > > version does not support the getColumnClassName() method, which I really > > really need. > > > > Please help me understand why I get this error. TIA. > > > > ERROR: No such attribute or function 'objsubid' > > java.sql.SQLException: ERROR: No such attribute or function 'objsubid' > > > > at java.lang.Throwable.<init>(Throwable.java:96) > > at java.lang.Exception.<init>(Exception.java:44) > > at java.sql.SQLException.<init>(SQLException.java:84) > > at > org.postgresql.core.QueryExecutor.execute(QueryExecutor.java:131) > > at > > > org.postgresql.jdbc1.AbstractJdbc1Connection.ExecSQL(AbstractJdbc1Connection.java:505) > > at > > > org.postgresql.jdbc1.AbstractJdbc1Statement.execute(AbstractJdbc1Statement.java:320) > > at > > > org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:48) > > at > > > org.postgresql.jdbc1.AbstractJdbc1Statement.executeQuery(AbstractJdbc1Statement.java:153) > > at > > > org.postgresql.jdbc1.AbstractJdbc1Statement.executeQuery(AbstractJdbc1Statement.java:141) > > at > > > org.postgresql.jdbc1.AbstractJdbc1DatabaseMetaData.getTables(AbstractJdbc1DatabaseMetaData.java:2066) > > at zerocode.dbSupport.Schema._getTableList(Schema.java:1121) > > at > > zerocode.dbSupport.Schema.buildFromConnectionMetaData(Schema.java:1062) > > at DbSnapshot.main(DbSnapshot.java:219) > > > > > > ===== > > ------ > > M. A. Sridhar > > m_a_sridhar@yahoo.com > > > > __________________________________________________ > > Do you Yahoo!? > > Yahoo! Mail Plus - Powerful. Affordable. Sign up now. > > http://mailplus.yahoo.com > > > > ---------------------------(end of broadcast)--------------------------- > > TIP 3: if posting/reading through Usenet, please send an appropriate > > subscribe-nomail command to majordomo@postgresql.org so that your > > message can get through to the mailing list cleanly > > > ===== ------ M. A. Sridhar m_a_sridhar@yahoo.com __________________________________________________ Do you Yahoo!? Yahoo! Mail Plus - Powerful. Affordable. Sign up now. http://mailplus.yahoo.com
Doing some further checking indicates that this column was added in the 7.2 series. This problem is also present in the getColumns() method. I will submit a patch for this problem, but at the same time I'm obligated to urge you to upgrade. Kris Jurka On Mon, 9 Dec 2002, M. A. Sridhar wrote: > I'm running version 7.1.3 on a Red Hat Linux box (RH version 7.1, I think). > If it matters, I'm using the IBM 1.3 JDK. > > --- Kris Jurka <books@ejurka.com> wrote: > > > > What version of the server are you running against? > > > > The objsubid is used to identify the table's comment in the > > pg_description table to supply the REMARKS column in the getTables() > > result set. > > > > Kris Jurka > > > > On Mon, 9 Dec 2002, M. A. Sridhar wrote: > > > > > Hi folks, > > > > > > I get the following error when I try to use the getTables method. This is > > > with the latest stable drivers, pg73jdbc2.jar and pg73jdbc2ee.jar. This > > > method call was working fine with the earlier driver version, but that > > > version does not support the getColumnClassName() method, which I really > > > really need. > > > > > > Please help me understand why I get this error. TIA. > > > > > > ERROR: No such attribute or function 'objsubid' > > > java.sql.SQLException: ERROR: No such attribute or function 'objsubid' > > > > > > at java.lang.Throwable.<init>(Throwable.java:96) > > > at java.lang.Exception.<init>(Exception.java:44) > > > at java.sql.SQLException.<init>(SQLException.java:84) > > > at > > org.postgresql.core.QueryExecutor.execute(QueryExecutor.java:131) > > > at > > > > > > org.postgresql.jdbc1.AbstractJdbc1Connection.ExecSQL(AbstractJdbc1Connection.java:505) > > > at > > > > > > org.postgresql.jdbc1.AbstractJdbc1Statement.execute(AbstractJdbc1Statement.java:320) > > > at > > > > > > org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:48) > > > at > > > > > > org.postgresql.jdbc1.AbstractJdbc1Statement.executeQuery(AbstractJdbc1Statement.java:153) > > > at > > > > > > org.postgresql.jdbc1.AbstractJdbc1Statement.executeQuery(AbstractJdbc1Statement.java:141) > > > at > > > > > > org.postgresql.jdbc1.AbstractJdbc1DatabaseMetaData.getTables(AbstractJdbc1DatabaseMetaData.java:2066) > > > at zerocode.dbSupport.Schema._getTableList(Schema.java:1121) > > > at > > > zerocode.dbSupport.Schema.buildFromConnectionMetaData(Schema.java:1062) > > > at DbSnapshot.main(DbSnapshot.java:219) > > > > > > > > > ===== > > > ------ > > > M. A. Sridhar > > > m_a_sridhar@yahoo.com > > > > > > __________________________________________________ > > > Do you Yahoo!? > > > Yahoo! Mail Plus - Powerful. Affordable. Sign up now. > > > http://mailplus.yahoo.com > > > > > > ---------------------------(end of broadcast)--------------------------- > > > TIP 3: if posting/reading through Usenet, please send an appropriate > > > subscribe-nomail command to majordomo@postgresql.org so that your > > > message can get through to the mailing list cleanly > > > > > > > > ===== > ------ > M. A. Sridhar > m_a_sridhar@yahoo.com > > __________________________________________________ > Do you Yahoo!? > Yahoo! Mail Plus - Powerful. Affordable. Sign up now. > http://mailplus.yahoo.com >
Hi, I have had the same problem as M. A. Sridhar, with pg 7.1.3 when trying to reverse a schema with Torque 3.0 stable. My solution: downgrade to pd-jdbc driver version 7.2, which still supports 7.1 meta data. http://jdbc.postgresql.org/download/pg72jdbc1.jar (JDK 1.1) http://jdbc.postgresql.org/download/pg72jdbc2.jar (JDK 1.2, 1.3, 1.4) To Kris Jurka: As you may be aware of, it is not always possible to upgrade a production environment at any time, like installing a new WinZip on my desktop. Normally, this must be carefully evaluated and planned. So your suggestion to upgrade may not be feasible under usual circumstances. Therefore it would be nice if existing features (i.e. pg 7.1 meta data) were not broken in subsequent driver versions. IMHO meta data is a weak point in the pd jdbc driver. I have not encountered many combinations of pg server/pg jdbc driver that worked correctly. Best regards, Remigius Stalder Descom Consulting Ltd. Gerbergasse 16 CH-4001 Basel http://www.descom-consulting.ch
A patch to fix this has been applied in CVS, but only to HEAD not the 7.3 branch for some reason. You will need to build from CVS to get this fix or wait for a new jar file to be built for you. On Wed, 18 Dec 2002, Remigius Stalder wrote: > Hi, > > I have had the same problem as M. A. Sridhar, with pg 7.1.3 when trying to > reverse a schema with Torque 3.0 stable. > > My solution: downgrade to pd-jdbc driver version 7.2, which still supports > 7.1 meta data. > > http://jdbc.postgresql.org/download/pg72jdbc1.jar (JDK 1.1) > http://jdbc.postgresql.org/download/pg72jdbc2.jar (JDK 1.2, 1.3, 1.4) > > To Kris Jurka: As you may be aware of, it is not always possible to upgrade > a production environment at any time, like installing a new WinZip on my > desktop. Normally, this must be carefully evaluated and planned. So your > suggestion to upgrade may not be feasible under usual circumstances. > Therefore it would be nice if existing features (i.e. pg 7.1 meta data) were > not broken in subsequent driver versions. IMHO meta data is a weak point in > the pd jdbc driver. I have not encountered many combinations of pg server/pg > jdbc driver that worked correctly. > > Best regards, > > Remigius Stalder > Descom Consulting Ltd. > Gerbergasse 16 > CH-4001 Basel > http://www.descom-consulting.ch > > > ---------------------------(end of broadcast)--------------------------- > TIP 5: Have you checked our extensive FAQ? > > http://www.postgresql.org/users-lounge/docs/faq.html >