[
https://issues.apache.org/jira/browse/DERBY-2732?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Manjula Kutty updated DERBY-2732:
---------------------------------
Summary: Loosing connection after a number of syntax errors while running a
query (was: Losing connection after a number of syntax errors while running a
query)
> 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.0.0
> 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.
