Thread: urgent: autocommit & pg 7.4.1
Guys, I know that this question has been answered dozen of times, but I have less than 2 hours to solve this issue. We upgraded our server to a new machine. A java program is accessing the database with autocommit set to true on JDBC Statements. I thought that we would need only to upgrade the jdbc drivers to a recent version, but we're having only read access to the data. No writes at all... Am I missing something? Do I need to put a commit() after writes? Any prompt help is appreciated. Thanks again. marcus.
What do the postgres logs say? Dave On Thu, 2004-02-19 at 21:32, Marcus Andree S. Magalhaes wrote: > Guys, > > I know that this question has been answered dozen of times, but I have > less than 2 hours to solve this issue. > > We upgraded our server to a new machine. A java program is accessing > the database with autocommit set to true on JDBC Statements. > > I thought that we would need only to upgrade the jdbc drivers to > a recent version, but we're having only read access to the data. > No writes at all... > > Am I missing something? Do I need to put a commit() after writes? > > Any prompt help is appreciated. > > Thanks again. > > marcus. > > > > > ---------------------------(end of broadcast)--------------------------- > TIP 3: 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 > -- Dave Cramer 519 939 0336 ICQ # 14675561 ---------------------------(end of broadcast)--------------------------- TIP 8: explain analyze is your friend
Got a mail from Oliver that helped. The data were being written, but with id's starting from 0. No sequence had their values set when restoring a pg_dump file. My query was filtering with 'order by id desc'. Now the problem is how to make sure that pg_dump will put all the values correctly on all sequences... Sorry for the rush.... > What do the postgres logs say? > > Dave > On Thu, 2004-02-19 at 21:32, Marcus Andree S. Magalhaes wrote: >> Guys, >> >> I know that this question has been answered dozen of times, but I have >> less than 2 hours to solve this issue. >> >> We upgraded our server to a new machine. A java program is accessing >> the database with autocommit set to true on JDBC Statements. >> >> I thought that we would need only to upgrade the jdbc drivers to a >> recent version, but we're having only read access to the data. No >> writes at all... >> >> Am I missing something? Do I need to put a commit() after writes? >> >> Any prompt help is appreciated. >> >> Thanks again. >> >> marcus. >> >> >> >> >> ---------------------------(end of >> broadcast)--------------------------- TIP 3: 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 >> > -- > Dave Cramer > 519 939 0336 > ICQ # 14675561 > > > ---------------------------(end of broadcast)--------------------------- > TIP 8: explain analyze is your friend
What do the postgres logs say? Dave On Thu, 2004-02-19 at 21:32, Marcus Andree S. Magalhaes wrote: > Guys, > > I know that this question has been answered dozen of times, but I have > less than 2 hours to solve this issue. > > We upgraded our server to a new machine. A java program is accessing > the database with autocommit set to true on JDBC Statements. > > I thought that we would need only to upgrade the jdbc drivers to > a recent version, but we're having only read access to the data. > No writes at all... > > Am I missing something? Do I need to put a commit() after writes? > > Any prompt help is appreciated. > > Thanks again. > > marcus. > > > > > ---------------------------(end of broadcast)--------------------------- > TIP 3: 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 > -- Dave Cramer 519 939 0336 ICQ # 14675561 ---------------------------(end of broadcast)--------------------------- TIP 8: explain analyze is your friend