JDBC tutorial code

Поиск
Список
Период
Сортировка
От Neil Kidd
Тема JDBC tutorial code
Дата
Msg-id 4.3.2.7.2.20001212114841.00a9bcb0@ms.webfactory.co.uk
обсуждение исходный текст
Ответы Re: JDBC tutorial code  (Steve Waldman <swaldman@mchange.com>)
Список pgsql-novice
Hello,
I have followed the JDBC tutorial code at
http://www.postgresql.org/devel-corner/docs/programmer/jdbc-lo.htm
and keep getting an sqlException from the JDBC driver. I need to deal with
BLOBS. Text fields etc work fine.
The exception states: InputStream not supported.

The code is as follows:

import java.sql.*;
import java.io.*;

public class dbtest
{
   public static void main( String[] args )
   {
     // Load the driver
     try
     {
       // Load the driver class
       Class.forName( "org.postgresql.Driver" );

       // Define the data source for the driver
       String dbURL = "jdbc:postgresql://192.168.0.3/mynewdb";

       // Create a connection through the DriverManager
       Connection dbCon = DriverManager.getConnection( dbURL, USER , PASS );

       dbCon.setAutoCommit( false );

       File              file = new File(
"D:\\dev\\code\\dbtest\\jdbc7.0-1.2.jar" );
       FileInputStream   fis  = new FileInputStream( file );
       PreparedStatement ps   = dbCon.prepareStatement( "insert into test1
values (?,?)" );

       ps.setString( 1, file.getName() );
       ps.setBinaryStream( 2, fis, ( int )file.length() );
       ps.executeUpdate();
       ps.close();
       fis.close();
     }
     catch( ClassNotFoundException cnfe )
     {
       System.err.println( "1 " + cnfe );
     }
     catch( SQLException sqle )
     {
       System.err.println( "2 " + sqle );
       sqle.printStackTrace(System.err);
     }
     catch( FileNotFoundException fnfe )
     {
       System.err.println( "3 " + fnfe );
     }
     catch( IOException ioe )
     {
       System.err.println( "4 " + ioe );
     }
   }

Thanks in advance for any help.
Regards,
Neil
----------------------------------------------------------------
From:            Neil Kidd
Website:        http://www.kidd.org.uk
E-mail:           neil@kidd.org.uk
----------------------------------------------------------------


В списке pgsql-novice по дате отправления:

Предыдущее
От: Paul Joseph McGee
Дата:
Сообщение: gmake install error
Следующее
От: "Robert B. Easter"
Дата:
Сообщение: Re: ConnectDBStart() error