Mailing-List: contact derby-dev-help@db.apache.org; run by ezmlm
Precedence: bulk
Reply-To: <derby-dev@db.apache.org>
Message-ID: <6703790.1202316788594.JavaMail.jira@brutus>
Date: Wed, 6 Feb 2008 08:53:08 -0800 (PST)
From: "Kathey Marsden (JIRA)" <jira@apache.org>
To: derby-dev@db.apache.org
Subject: [jira] Commented: (DERBY-2732) Loosing connection after a number of
 syntax errors while running a query
In-Reply-To: <3545798.1180567035609.JavaMail.jira@brutus>
MIME-Version: 1.0
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: 7bit


    [ https://issues.apache.org/jira/browse/DERBY-2732?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12566195#action_12566195 ] 

Kathey Marsden commented on DERBY-2732:
---------------------------------------

Manjula, are you still seeing this issue. I have not been able to reproduce.


> Loosing connection after a number of syntax errors while running a query
> ------------------------------------------------------------------------
>
>                 Key: DERBY-2732
>                 URL: https://issues.apache.org/jira/browse/DERBY-2732
>             Project: Derby
>          Issue Type: Bug
>          Components: Network Client
>    Affects Versions: 10.3.1.4
>         Environment: java version "1.5.0_02"
> Java(TM) 2 Runtime Environment, Standard Edition (build 1.5.0_02-b09)
> Java HotSpot(TM) Client VM (build 1.5.0_02-b09, mixed mode)
> sysinfo
> ---------------
> ------------------ Java Information ------------------
> Java Version:    1.5.0_02
> Java Vendor:     Sun Microsystems Inc.
> Java home:       c:\p4client\mkutty_ltmain\jdk15\jre
> Java classpath:  c:/pantry/db2jcc.jar;c:/pantry/db2jcc_license_c.jar;c:/pantry/d
> erby.jar;c:/pantry/derbyclient.jar;c:/pantry/derbyLocale_de_DW.jar;c:/pantry/der
> byLocale_es.jar;c:/pantry/derbyLocale_fr.jar;c:/pantry/derbyLocale_it.jar;c:/pan
> try/derbyLocale_ja_JP.jar;c:/pantry/derbyLocale_ko_KR.jar;c:/pantry/derbyLocale_
> pt_BR.jar;c:/pantry/derbyLocale_zh_CN.jar;c:/pantry/derbyLocale_zh_TW.jar;c:/pan
> try/derbynet.jar;c:/pantry/derbyTesting.jar;c:/pantry/derbytools.jar;c:/pantry/f
> unctionTests.jar;c:/pantry/maps.jar;c:/pantry/tours.jar;.;c:/pantry/junit.jar;c:
> /pantry/jakarta-oro-2.0.8.jar
> OS name:         Windows XP
> OS architecture: x86
> OS version:      5.1
> Java user name:  mkutty
> Java user home:  C:\Documents and Settings\Administrator
> Java user dir:   C:\pantry
> java.specification.name: Java Platform API Specification
> java.specification.version: 1.5
> --------- Derby Information --------
> JRE - JDBC: J2SE 5.0 - JDBC 3.0
> [C:\pantry\derby.jar] 10.3.0.0 alpha - (542712)
> [C:\pantry\derbytools.jar] 10.3.0.0 alpha - (542712)
> [C:\pantry\derbynet.jar] 10.3.0.0 alpha - (542712)
> [C:\pantry\derbyclient.jar] 10.3.0.0 alpha - (542712)
>            Reporter: Manjula Kutty
>
> I started the server as follows
> java org.apache.derby.drda.NetworkServerControl start -p 1527 -h 0.0.0 -noSecurityManager
> and on the client side though ij ran the following commands
> ij>connect 'jdbc:derby://mkutty-ibm-lt3:1527/ipv6db;create=true';
> --You have to give the host name. the use of local host didn't reproduce this problem
> ij>create table tab1(col1 bigint,col2 blob,col3 char, col4 char for bit data,col5 clob, col6 date, col7 decimal, col8 double, col9 double precision, col10 float, col11 integer,col12 long varchar, col13 long varchar for bit data, col14 numeric, col15 real, col16 smallint, col17 time, col18 timestamp, col19 varchar, col20 varchar(3214) for bit data);
> run the sql with syntax error for "n " number of times. I got the error in 2 and 3 and 9 try.
> Then got the following error
> ERROR 58009: A communications error has been detected: Connection reset by peer:
>  socket write error
> Then ij lost the connection. 
> Note: It may be little difficult to reproduce the problem, but I could reproduce it more than 4 times. But not always. 

-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.