db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Manjula Kutty (JIRA)" <j...@apache.org>
Subject [jira] Created: (DERBY-2732) Losing connection after a number of syntax errors while running a query
Date Wed, 30 May 2007 23:17:15 GMT
Losing 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.


Mime
View raw message