Home > Archive > PostgreSQL JDBC > November 2005 > Re: Problem with storing Images in PostgreSQL









You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

 

Author Re: Problem with storing Images in PostgreSQL
Kris Jurka

2005-11-16, 11:24 am

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(J
dbcOdbc.java:6958)
> at sun.jdbc.odbc.JdbcOdbc. standardError(JdbcOd
bc.java:7115)
> at sun.jdbc.odbc.JdbcOdbc. SQLParamData(JdbcOdb
c.java:4738)
> at
> sun.jdbc.odbc. JdbcOdbcPreparedStat
ement. execute(JdbcOdbcPrep
aredStatement.java:225)
> at
> sun.jdbc.odbc. JdbcOdbcPreparedStat
ement. executeUpdate(JdbcOd
bcPreparedStatement.java:136)
> at com.coalition.jms.ObjectInDatabase. main(ObjectInDatabas
e.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

---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo@postgresql
.org so that your
message can get through to the mailing list cleanly

Sponsored Links





Also available: Server administration forum archive | Web Design forum archive | Software forum archive | Hardware reviews archive | Programming forum archive

Copyright 2008 droptable.com