db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Lily Wei (JIRA)" <j...@apache.org>
Subject [jira] Updated: (DERBY-4268) "SECURITY" is reserved as SQL keyword.
Date Tue, 16 Jun 2009 16:15:07 GMT

     [ https://issues.apache.org/jira/browse/DERBY-4268?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]

Lily Wei updated DERBY-4268:
----------------------------

    Attachment: error-stacktrace-ReplicationRun_Local.out
                error-stacktrace-ReplicationRun_Local_StateTest_part1.out

ReplictionRun_Local_StateTest_part1 looks like a similar issue as Derby-3719. This is the
Exception trace:
2) testReplication_Local_StateTest_part1(org.apache.derbyTesting.functionTests.t
ests.replicationTests.ReplicationRun_Local_StateTest_part1)junit.framework.Compa
risonFailure: Unexpected SQL state. expected:<...20> but was:<...07>
        at org.apache.derbyTesting.junit.BaseJDBCTestCase.assertSQLState(BaseJDB
CTestCase.java:762)
        at org.apache.derbyTesting.junit.BaseJDBCTestCase.assertSQLState(BaseJDB
CTestCase.java:811)
        at org.apache.derbyTesting.functionTests.tests.replicationTests.Replicat
ionRun.failOver_direct(ReplicationRun.java:1381)
        at org.apache.derbyTesting.functionTests.tests.replicationTests.Replicat
ionRun.failOver(ReplicationRun.java:1302)
        at org.apache.derbyTesting.functionTests.tests.replicationTests.Replicat
ionRun_Local_StateTest_part1.testReplication_Local_StateTest_part1(ReplicationRu
n_Local_StateTest_part1.java:160)
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
        at org.apache.derbyTesting.junit.BaseTestCase.runBare(BaseTestCase.java:
106)
        at junit.extensions.TestDecorator.basicRun(TestDecorator.java:22)
        at junit.extensions.TestSetup$1.protect(TestSetup.java:19)
        at junit.extensions.TestSetup.run(TestSetup.java:23)
Caused by: java.sql.SQLException: DERBY SQL error: SQLCODE: -1, SQLSTATE: XRE07,
 SQLERRMC: Could not perform operation because the database is not in replicatio
n master mode.
        at org.apache.derby.client.am.SQLExceptionFactory40.getSQLException(SQLE
xceptionFactory40.java:96)
        at org.apache.derby.client.am.SqlException.getSQLException(SqlException.
java:358)
        at org.apache.derby.jdbc.ClientDriver.connect(ClientDriver.java:149)
        at java.sql.DriverManager.getConnection(Unknown Source)
        at java.sql.DriverManager.getConnection(Unknown Source)
        at org.apache.derbyTesting.functionTests.tests.replicationTests.Replicat
ionRun.failOver_direct(ReplicationRun.java:1368)
        ... 28 more
Caused by: org.apache.derby.client.am.SqlException: DERBY SQL error: SQLCODE: -1
, SQLSTATE: XRE07, SQLERRMC: Could not perform operation because the database is
 not in replication master mode.
        at org.apache.derby.client.am.Connection.completeSqlca(Connection.java:2
075)
        at org.apache.derby.client.net.NetConnectionReply.parseRdbAccessFailed(N
etConnectionReply.java:540)
        at org.apache.derby.client.net.NetConnectionReply.parseAccessRdbError(Ne
tConnectionReply.java:433)
        at org.apache.derby.client.net.NetConnectionReply.parseACCRDBreply(NetCo
nnectionReply.java:297)
        at org.apache.derby.client.net.NetConnectionReply.readAccessDatabase(Net
ConnectionReply.java:121)
        at org.apache.derby.client.net.NetConnection.readSecurityCheckAndAccessR
db(NetConnection.java:835)
        at org.apache.derby.client.net.NetConnection.flowSecurityCheckAndAccessR
db(NetConnection.java:759)
        at org.apache.derby.client.net.NetConnection.flowUSRIDONLconnect(NetConn
ection.java:592)
        at org.apache.derby.client.net.NetConnection.flowConnect(NetConnection.j
ava:399)
        at org.apache.derby.client.net.NetConnection.<init>(NetConnection.java:2
19)
        at org.apache.derby.client.net.NetConnection40.<init>(NetConnection40.ja
va:77)
        at org.apache.derby.client.net.ClientJDBCObjectFactoryImpl40.newNetConne
ction(ClientJDBCObjectFactoryImpl40.java:269)
        at org.apache.derby.jdbc.ClientDriver.connect(ClientDriver.java:140)

I am not totally sure this is the same issue as 3719. However, it feel some issue are coming
from similar issue.

> "SECURITY" is reserved as SQL keyword.
> --------------------------------------
>
>                 Key: DERBY-4268
>                 URL: https://issues.apache.org/jira/browse/DERBY-4268
>             Project: Derby
>          Issue Type: Bug
>          Components: SQL
>            Reporter: Kan Ogawa
>            Assignee: Lily Wei
>            Priority: Blocker
>         Attachments: derby-4268-diff.txt, derby-4268-diff.txt, error-stacktrace-ReplicationRun_Local.out,
error-stacktrace-ReplicationRun_Local_StateTest_part1.out
>
>
> The word "SECURITY" is NOT described in SQL reserved words section of Derby Reference
Manual.
> I think that it should be able to use this word without quotes in SQL statement.

-- 
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