Vertica 7 JDBC support

also, I can see this error in vertica.log  Poll dispatch:0x9b34bb0 [Dist] <INFO> Non-Vertica connection from 192.168.1.47:61869 rejected, closing fd 15

Hi, we are evaluating vertica to take a desition, but we are stuck with this jdbc connectivity only able to test using vsql , is there any speciall fee or support rate so we can get a response and finish to test this product

Regards

It sounds like you're hitting a timeout in a firewall or other component between your client and the database.

The keepalive feature in dbvisualizer should help you at least keep the dbviz client connected.

  http://h30499.www3.hp.com/t5/HP-Big-Data-Blog/New-Release-of-DbVisualizer-Free-for-Vertica-Now-Available-via/ba-p/6733409#.Vh7Ma7RVhHw

 --Sharon

Hi Sharon

Thank you for your answer, regarding 

"It sounds like you're hitting a timeout in a firewall or other component between your client and the database."

i initially though this too, but i installed both mysql 5.5 and standard postgres 9.3 and is working correctly , also i checked the proxy and iptables status and both are disabled, the checked the db visualizer parameter you mentiones but its seems this paramter works once the connection has been stablished, i cant connect, only ping the vertica database, i have attached the image, the problem is not reduced to db visualizer im using the same driver from the bi pentaho connection manager and throws the same error, i read somewhere that the jdbc is working in vertica 7.0 can we have a linnk to this version or to another driver.( or maybe its because im using a virtual box ubuntu 14 machine?)

Thanks in advance 

Hi ,

 Take a look at this post on vertica-forums where Jim Knicely is giving a solution to a problem similar to yours.

http://vertica-forums.com/viewtopic.php?f=20&t=252

also

http://vertica-forums.com/viewtopic.php?f=43&t=1137

- hope this will help. 

Hi Adrian

Thanks for takign time to write a response, sadly i tried all this before, before writing in this forum a tried all the existing solutions and in all the forums and blogs, if  you look closely this specific error [Vertica][VJDBC](100024) IOException while communicating with server: java.net.SocketException: Connection reset  has not  precedents in any existing forum, the more near is a broke pipe error in a post,  the both links you mentioned are assuming you are succesfully connected and then something fails after x time (2 hours,5 hours etc), this are standard jdbc problems ive seen all my life, in this case i can even connect, is there any posibility to have the vertica 7.0.x version, ive read the jdbc works ok there, my last bet is to use your vmware virtual machine and test jdbc

Regards

I have the same problem. Have You solved this problem? Thank you.

There are several possible causes.

The other end has deliberately reset the connection. It is rare, and generally incorrect, for application software to do this, but it is not unknown for commercial software.

More commonly, it is caused by writing to a connection that the other end has already closed normally. In other words an application protocol error.

It can also be caused by closing a socket when there is unread data in the socket receive buffer.

In Windows, ‘software caused connection abort’, which is not the same as ‘connection reset’, is caused by network problems sending from your end. There’s a Microsoft knowledge base article about this.

More about….Socket Programming