bhanu reddy wrote:
>
> I am Bhanu and got ur id in forums. Can you please help me in solving
> problem that I am facing with storing images?
> I am using PostgreSQL 8.0.3 and created a table like this:
>
Please send postgresql jdbc help requests to the
pgsql-jdbc@postgresql.org mailing list, not any individual directly.
http://jdbc.postgresql.org/lists.html#general
> java.sql.SQLException: ERROR: type "lo" does not exist
> at sun.jdbc.odbc.JdbcOdbc.createSQLException(JdbcOdbc.java:6958)
> at sun.jdbc.odbc.JdbcOdbc.standardError(JdbcOdbc.java:7115)
> at sun.jdbc.odbc.JdbcOdbc.SQLParamData(JdbcOdbc.java:4738)
> at
> sun.jdbc.odbc.JdbcOdbcPreparedStatement.execute(JdbcOdbcPreparedStatement.java:225)
> at
> sun.jdbc.odbc.JdbcOdbcPreparedStatement.executeUpdate(JdbcOdbcPreparedStatement.java:136)
> at com.coalition.jms.ObjectInDatabase.main(ObjectInDatabase.java:57)
>
This shows you are not using the postgresql JDBC driver at all, but
instead Sun's JDBC->ODBC bridge and the ODBC driver. Please review your
connection setup code and ensure you are setting up a JDBC connection.
http://jdbc.postgresql.org/documentation/80/index.html
Kris Jurka