| From: | tmp(at)nitwit(dot)de | 
|---|---|
| To: | pgsql-jdbc(at)postgresql(dot)org | 
| Subject: | cursor "jdbc_curs_1" does not exist | 
| Date: | 2004-06-15 15:36:26 | 
| Message-ID: | 200406151736.27450.tmp@nitwit.de | 
| Views: | Whole Thread | Raw Message | Download mbox | Resend email | 
| Thread: | |
| Lists: | pgsql-jdbc | 
Hi!
org.postgresql.util.PSQLException: ERROR: cursor "jdbc_curs_1" does not exist
Can somebody explain this exception? What I do is pretty simple: I read text 
from one table, gzip it and insert it into another table. But it seems that 
the exception is thrown at ResulSet.next() but I'm not sure. Here's the code 
anyway:
		final PreparedStatement select = f4t.prepareStatement( "SELECT urlid, html 
FROM html" );
		final PreparedStatement insert = f4t.prepareStatement( "INSERT INTO 
legacy.zhtml (id, zhtml) VALUES (?, ?)" );
f4t.setAutoCommit( false );
select.setFetchSize( FETCH_SIZE );
		int i = 0;
		for( ResultSet row = select.executeQuery(); row.next(); )
		{
			final String id = row.getString( "urlid" );
			final String html = row.getString( "html" );
			final ByteArrayOutputStream bos = new ByteArrayOutputStream();
			final DataOutputStream dos = new DataOutputStream( bos );
WritableUtils.writeCompressedString( dos, html );
			insert.setString( 1, id );
			insert.setBytes( 2, bos.toByteArray() );
			insert.execute();
System.out.print( '.' );
			if( ++i % 100 == 0 )
			{
				System.out.println();
				f4t.commit();
			}
		}
		f4t.commit();
		f4t.setAutoCommit( true );
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Kris Jurka | 2004-06-15 16:06:26 | Re: cursor "jdbc_curs_1" does not exist | 
| Previous Message | Jie Liang | 2004-06-14 23:32:57 | Prepare Statement |