Re: Insert do not work in my case

The easiest way to start is to turn on query logs for your server and
see if it gets that far.

If it does - copy the query into psql and run it manually - it will tell
you if there's a problem.

If it doesn't get that far, then that's another problem altogether...

Regards,

Chris Smith

Suite 30, 45-51 Huntley St, Alexandria, NSW 2015 Australia

Ph: +61 2 9517 2505
Fx: +61 2 9517 1915

email: info(at)interspire(dot)com
web: www.interspire.com

Mickael Remond wrote:
> Hello,
>
> I am running an application on Postgresql 8.0.0 rc1. The application is
> running on JBoss 4.0.1RC2 and I am using the JDBC driver
> pg80b1.308.jdbc3.jar.
>
> My problem is that insert that are sent to the database through a
> prepared statement are not written in the database. The application is
> doing a subsequent read and fail. A simple select from psql show that
> the table is stil empty.
> The log in debug level mode 3 are showing no particular problem. I
> clearly see the prepared statement (Not complete but with question marks
> instead of variable). I then see the select but the read is failing in
> the application.
>
> I really do not see why this is happening. I suspect a configuration
> problem but does not see what I should change.
>
> The application was working properly on PostgreSQL 7.2.
>
> Do you have any clue ?
>

--
No virus found in this outgoing message.
Checked by AVG Anti-Virus.
Version: 7.0.296 / Virus Database: 265.5.4 - Release Date: 12/15/2004