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
|
Список | 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 по дате отправления: