From: | Neil Kidd <neil(at)kidd(dot)org(dot)uk> |
---|---|
To: | pgsql-novice(at)postgresql(dot)org |
Subject: | JDBC tutorial code |
Date: | 2000-12-12 11:55:06 |
Message-ID: | 4.3.2.7.2.20001212114841.00a9bcb0@ms.webfactory.co.uk |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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(at)kidd(dot)org(dot)uk
----------------------------------------------------------------
From | Date | Subject | |
---|---|---|---|
Next Message | Robert B. Easter | 2000-12-12 15:20:52 | Re: ConnectDBStart() error |
Previous Message | Oliver Elphick | 2000-12-12 11:49:11 | Re: ConnectDBStart() error |