Re: Help: ResultSet..insertRow() not coping with explicit

Hi Dave,

Dave Cramer wrote:

>Jim,
>
>can you send me a test case which demonstrates this?
>
>
I have edited the JDBC test suite in my cvs working directory.
I have not done a cvs update recently so note the version number.
Additional comments follow:

---
src/interfaces/jdbc/org/postgresql/test/jdbc2/UpdateableResultTest.java.~1.7.~
2002-09-11 07:38:45.000000000 +0200
+++
src/interfaces/jdbc/org/postgresql/test/jdbc2/UpdateableResultTest.java
2003-09-24 07:19:39.000000000 +0200
@@ -66,6 +66,17 @@

rs.close();

+ rs = st.executeQuery( "select oid, * from updateable");
+
+ assertNotNull( rs );
+ rs.moveToInsertRow();
+ rs.updateInt( 1, 1 );
+ rs.updateString( 2, "jim" );
+ rs.updateString( 3, "4gotenit" );
+ rs.insertRow();
+
+ rs.close();
+
rs = st.executeQuery("select id1, id, name, name1 from
updateable, second" );
try
{

My postgres installation was not built from this source:

>On Mon, 2003-09-22 at 04:06, Jim Wright wrote:
>
>
>>I have postgresql-7.3.1-6.src.rpm under Red Hat
>>8.0 and pg73jdbc3.jar.
>>
>>
so it might conceivably work for you. Ant output:

runtest:
[junit] Testsuite: org.postgresql.test.jdbc2.Jdbc2TestSuite
[junit] Tests run: 76, Failures: 1, Errors: 5, Time elapsed: 11.217 sec

[junit] Testcase:
testUpdateable(org.postgresql.test.jdbc2.UpdateableResultTest): FAILED
[junit] ERROR: Relation "updateable" has no column "oid"
[junit] junit.framework.AssertionFailedError: ERROR: Relation
"updateable" has no column "oid"
[junit] at
org.postgresql.test.jdbc2.UpdateableResultTest.testUpdateable(UpdateableResultTest.java:143)
[junit] at sun.reflect.NativeMethodAccessorImpl.invoke0(Native
Method)
[junit] at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
[junit] at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)

[junit] Testcase:
testGetDouble(org.postgresql.test.jdbc2.CallableStmtTest): Caused an
ERROR
[junit] ERROR: language "plpgsql" does not exist
[junit] java.sql.SQLException: ERROR: language "plpgsql" does not exist
[junit] at
org.postgresql.core.QueryExecutor.executeV2(QueryExecutor.java:286)
[junit] at
org.postgresql.core.QueryExecutor.execute(QueryExecutor.java:104)
[junit] at
org.postgresql.core.QueryExecutor.execute(QueryExecutor.java:42)
[junit] at
org.postgresql.jdbc1.AbstractJdbc1Statement.execute(AbstractJdbc1Statement.java:437)
[junit] at
org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:49)
[junit] at
org.postgresql.jdbc1.AbstractJdbc1Statement.execute(AbstractJdbc1Statement.java:275)
[junit] at
org.postgresql.test.jdbc2.CallableStmtTest.setUp(CallableStmtTest.java:29)

[snip 4 irrelevant errors similar to the last]

[junit] TEST org.postgresql.test.jdbc2.Jdbc2TestSuite FAILED
[junit] Testsuite: org.postgresql.test.jdbc2.optional.OptionalTestSuite
[junit] Tests run: 34, Failures: 0, Errors: 0, Time elapsed: 8.065 sec

[junit] Testsuite: org.postgresql.test.jdbc3.Jdbc3TestSuite
[junit] Tests run: 38, Failures: 0, Errors: 0, Time elapsed: 8.997 sec

Hope that's all OK and if this is a valid test you have my permission
to include it in the suite under the same license etc.

BTW Why is an ERROR not a FAILURE?

Regards,

Jim Wright

--
Recently completed - Child Brain Injury Trust Admin System
http://cbitdemo.paneris.org/

Urgently seeking paid work
Java, Linux, XML and much more.
http://be.webz.cz/