Can I hide a part of the text by a "More..." link?
Re: ERROR: The backend has broken the connection -- AND: FATAL:
Hello Guest
  
  • Login
• Register…
• Start blog
  • Who, Where, When
• What can I do?
• What to Read?
  • Polls
• Avatars
• Interests
  • Cities and Countries
• Random blog
• Users search
  • Search
• Games
• Tests
• QAIX
  • Сообщества
• Talxy Chat
• Horoscope
• Online
 
Зарегистрируйся!

QAIX > PostgreSQL database development > Re: ERROR: The backend has broken the connection -- AND: FATAL: 30 January 2006 21:08:50

  Recent blog posts: 
  They have birthday today: 
  Forums:   
  Discuss: 
  Recent forum topics: 
  Recent forum comments:
  Moderators:

Re: ERROR: The backend has broken the connection -- AND: FATAL:

Oliver Jowett 30 January 2006 21:08:50
 Antonio Rodriguez Anaya wrote:> The class gets connect with > postgrsql by jdbc (pg73jdbc3.jar) without problems.

This version of the driver is essentially unmaintained, I suggest you
upgrade to a more recent build (later driver versions should still
operate correctly against a 7.3 server).

-O

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

Add comment
Antonio Rodriguez Anaya 24 January 2006 14:11:16 permanent link ]
 Hi,

Sorry, I don't have time to reply the message.

Thanks for the advice. I've changed the jdbc file for the newest.
However I have errors in the same point but the message has changed.

The java error is:

FATAL: Socket command type unknown

And the error message in postgrsql server is:

FATAL: unsupported frontend protocol
FATAL: Socket command type unknown


I don't know why postgresql does'nt support frontend protocol, and I
don't know how to change that protocol.

Thanks in advanced,

Toni.

El 19/01/2006, a las 23:06, Oliver Jowett escribiГі:
Antonio Rodriguez Anaya wrote:>> The class gets connect with postgrsql by jdbc (pg73jdbc3.jar) without >> problems.>
This version of the driver is essentially unmaintained, I suggest you > upgrade to a more recent build (later driver versions should still > operate correctly against a 7.3 server).>
-O>
-------------------­--------(end of > broadcast)---------­------------------> TIP 1: if posting/reading through Usenet, please send an appropriate> subscribe-nomail command to majordomo@postgresq­l.org so that your> message can get through to the mailing list cleanly>


-------------------­--------(end of broadcast)---------­------------------
TIP 5: don't forget to increase your free space map settings

Add comment
Andres Olarte 24 January 2006 16:49:15 permanent link ]
 What backend version are you using? I seems you are using a very old version
of the backend (server) and the driver is trying to comunicate in a newer
protocol. Theres a way to change the protocol, using the connection string,
but I think it will be better to update the server to the newest version.

On 1/24/06, Antonio Rodriguez Anaya <arodriguez@dia.une­d.es> wrote:>
Hi,>
Sorry, I don't have time to reply the message.>
Thanks for the advice. I've changed the jdbc file for the newest.> However I have errors in the same point but the message has changed.>
The java error is:>
FATAL: Socket command type unknown>
And the error message in postgrsql server is:>
FATAL: unsupported frontend protocol> FATAL: Socket command type unknown>
I don't know why postgresql does'nt support frontend protocol, and I> don't know how to change that protocol.>
Thanks in advanced,>
Toni.>
El 19/01/2006, a las 23:06, Oliver Jowett escribiу:>
Antonio Rodriguez Anaya wrote:> >> The class gets connect with postgrsql by jdbc (pg73jdbc3.jar) without> >> problems.> >
This version of the driver is essentially unmaintained, I suggest you> > upgrade to a more recent build (later driver versions should still> > operate correctly against a 7.3 server).> >
-O> >
-------------------­--------(end of> > broadcast)---------­------------------> > TIP 1: if posting/reading through Usenet, please send an appropriate> > subscribe-nomail command to majordomo@postgresq­l.org so that your> > message can get through to the mailing list cleanly> >
-------------------­--------(end of broadcast)---------­------------------> TIP 5: don't forget to increase your free space map settings>
Add comment
Oliver Jowett 25 January 2006 03:40:49 permanent link ]
 Andres Olarte wrote:> What backend version are you using? I seems you are using a very old > version of the backend (server) and the driver is trying to comunicate > in a newer protocol. Theres a way to change the protocol, using the > connection string, but I think it will be better to update the server to > the newest version.

The driver automatically falls back to the older v2 protocol when
necessary. It tries the v3 protocol initially, which is what produces
the "unsupported frontend protocol" error on the server side, and then
falls back to v2 when that fails.

Antonio, can you try to reproduce this with debug logging enabled (add
"?loglevel=2" to the end of your JDBC URL), and send me the resulting
debug output to me off-list?

-O

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

Add comment
Antonio Rodriguez Anaya 30 January 2006 21:08:50 permanent link ]
 Hi,

I have followed the recommendations and I have installed in other
computer the newest versiГіn and I have added "?loglevel=2" to the end
on my JDBC URL. The results are:

JDBC: 8.2; Postgresql: 8.2

Java error:

18:36:11.202 (1) simple execute,
handler=org.postgre­sql.jdbc2.AbstractJd­bc2Statement$Stateme­ntResultHandl
er@2c3327, maxRows=0, fetchSize=0, flags=17
18:36:11.204 (1) FE=> Parse(stmt=null,que­ry="SELECT
insert_op_hour('[samap-opening-plan-23431-act-23432]', 'opening_hours',
2, 2)
Add comment
 

Add new comment

As:
Login:  Password:  
 
 
  
 
Пожалуйста, относитесь к собеседникам уважительно, не используйте нецензурные слова, не злоупотребляйте заглавными буквами, не публикуйте рекламу и объявления о купле/продаже, а также материалы нарушающие сетевой этикет или УК РФ.


QAIX > PostgreSQL database development > Re: ERROR: The backend has broken the connection -- AND: FATAL: 30 January 2006 21:08:50

see also:
SV: how to find the last insert id ?
Proposed 'Author' link-type
пройди тесты:
see also:
Hello PPL!!!!!!!!!!!!!!!!!!!!!!!!!
hello
Тест: Do you really know yourself?i...

  Copyright © 2001—2008 QAIX
Idea: Miсhael Monashev
Помощь и задать вопросы можно в сообществе support.qaix.com.
Сообщения об ошибках оставляем в сообществе bugs.qaix.com.
Предложения и комментарии пишем в сообществе suggest.qaix.com.
Информация для родителей.
Write us at:
If you would like to report an abuse of our service, such as a spam message, please .