Issue Details (XML | Word | Printable)

Key: DERBY-2653
Type: Improvement Improvement
Status: Resolved Resolved
Resolution: Fixed
Priority: Minor Minor
Assignee: Kathey Marsden
Reporter: A B
Votes: 0
Watchers: 0
Operations

If you were logged in you would be able to see more operations.
Derby

Expose existing auto-generated key functionality through more JDBC APIs in Derby Client.

Created: 15/May/07 05:34 PM   Updated: 22/Feb/08 07:25 PM
Return to search
Component/s: JDBC
Affects Version/s: 10.3.2.1, 10.4.1.3
Fix Version/s: 10.3.3.0, 10.4.1.3

Time Tracking:
Issue & Sub-Tasks
Issue Only
Not Specified

File Attachments:
  File Name Date Attached Attached By Size
HTML File Licensed for inclusion in ASF works crefjavstateautogen.html 2008-02-20 04:09 PM Kathey Marsden 6 kB
Text File Licensed for inclusion in ASF works derby-2653_columnIndexes_diff.txt 2008-02-19 11:55 PM Kathey Marsden 38 kB
Text File Licensed for inclusion in ASF works derby-2653_columnNames2_diff.txt 2008-02-19 01:55 PM Kathey Marsden 18 kB
Text File Licensed for inclusion in ASF works derby-2653_columnNames_diff.txt 2008-02-19 01:43 AM Kathey Marsden 15 kB
Text File Licensed for inclusion in ASF works derby-2653_columnNames_diff.txt 2008-02-18 11:42 PM Kathey Marsden 14 kB
Text File Licensed for inclusion in ASF works derby-2653_doc_diff.txt 2008-02-20 04:09 PM Kathey Marsden 2 kB
Text File derby-2653_proto_diff.txt 2008-02-16 01:19 AM Kathey Marsden 5 kB
Environment: Runnning with Derby Client.
Issue Links:
Duplicate
 
Incorporates
 
Reference
 

Issue & fix info: Patch Available
Resolution Date: 21/Feb/08 06:38 PM

Sub-Tasks:   All   Open   
No sub-tasks match this view.

 Description  « Hide
See DERBY-2631 for details. Desired functionality is the same as for DERBY-2631, except that this issue is specifically for Derby Client (DERBY-2631 only addressed embedded mode).

 All   Comments   Work Log   Change History   Subversion Commits      Sort Order: Ascending order - Click to sort in descending order
Repository Revision Date User Message
ASF #629171 Tue Feb 19 17:40:40 UTC 2008 kmarsden DERBY-2653 (partial)Expose existing auto-generated key functionality through more JDBC APIs in Derby Client.

Enables API's that take columnNames.

Connection.prepareStatement(String sql, String[] columnNames);
Statement.execute(String sql, String[] columNames);
Statement.executeUpdate(String sql, String[] columnNames);

To get generated keys, user must specify an array of one column name, which
should be the identity column. Client actually ignores the contents at this
time.
Files Changed
MODIFY /db/derby/code/trunk/java/client/org/apache/derby/client/am/Connection.java
MODIFY /db/derby/code/trunk/java/client/org/apache/derby/client/am/Statement.java
MODIFY /db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/jdbcapi/AutoGenJDBC30Test.java
MODIFY /db/derby/code/trunk/java/shared/org/apache/derby/shared/common/reference/SQLState.java
MODIFY /db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/jdbcapi/StatementJdbc30Test.java
MODIFY /db/derby/code/trunk/java/build/org/apache/derbyBuild/splitmessages.java
MODIFY /db/derby/code/trunk/java/engine/org/apache/derby/loc/messages.xml
MODIFY /db/derby/code/trunk/java/client/org/apache/derby/client/am/PreparedStatement.java

Repository Revision Date User Message
ASF #629566 Wed Feb 20 18:35:26 UTC 2008 kmarsden DERBY-2653 Expose existing auto-generated key functionality through more JDBC APIs in Derby Client.

Add client support for columnIndex API's:

  Connection.prepareStatement(String sql, int[] columnIndexes);
  Statement.execute(String sql, int[] columIndexes);
  Statement.executeUpdate(String sql, int[] columnIndexes);
Files Changed
MODIFY /db/derby/code/trunk/java/client/org/apache/derby/client/am/Connection.java
MODIFY /db/derby/code/trunk/java/client/org/apache/derby/client/am/Statement.java
MODIFY /db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/jdbcapi/AutoGenJDBC30Test.java
MODIFY /db/derby/code/trunk/java/client/org/apache/derby/client/am/PreparedStatement40.java
MODIFY /db/derby/code/trunk/java/client/org/apache/derby/client/net/ClientJDBCObjectFactoryImpl40.java
MODIFY /db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/jdbcapi/StatementJdbc30Test.java
MODIFY /db/derby/code/trunk/java/client/org/apache/derby/client/am/DatabaseMetaData.java
MODIFY /db/derby/code/trunk/java/client/org/apache/derby/client/am/Statement40.java
MODIFY /db/derby/code/trunk/java/client/org/apache/derby/client/net/NetPreparedStatement.java
MODIFY /db/derby/code/trunk/java/client/org/apache/derby/client/net/NetConnection.java
MODIFY /db/derby/code/trunk/java/client/org/apache/derby/client/am/CallableStatement.java
MODIFY /db/derby/code/trunk/java/client/org/apache/derby/client/net/NetStatement.java
MODIFY /db/derby/code/trunk/java/client/org/apache/derby/client/am/ClientJDBCObjectFactory.java
MODIFY /db/derby/code/trunk/java/client/org/apache/derby/client/am/PreparedStatement.java
MODIFY /db/derby/code/trunk/java/client/org/apache/derby/client/net/ClientJDBCObjectFactoryImpl.java

Repository Revision Date User Message
ASF #629580 Wed Feb 20 19:21:08 UTC 2008 kmarsden DERBY-2653 (doc) Expose existing auto-generated key functionality through more JDBC APIs in Derby Client.

Document API's available for client and call out limitations of error checking.
Files Changed
MODIFY /db/derby/docs/trunk/src/ref/crefjavstateautogen.dita

Repository Revision Date User Message
ASF #629847 Thu Feb 21 16:12:11 UTC 2008 kmarsden DERBY-2653 (partial) Add autogenerated keys API's for columnNames
port revision 629171 from trunk
Files Changed
MODIFY /db/derby/code/branches/10.3/java/testing/org/apache/derbyTesting/functionTests/tests/jdbcapi/AutoGenJDBC30Test.java
MODIFY /db/derby/code/branches/10.3/java/client/org/apache/derby/client/am/Statement.java
MODIFY /db/derby/code/branches/10.3/java/client/org/apache/derby/client/am/Connection.java
MODIFY /db/derby/code/branches/10.3/java/shared/org/apache/derby/shared/common/reference/SQLState.java
MODIFY /db/derby/code/branches/10.3/java/build/org/apache/derbyBuild/splitmessages.java
MODIFY /db/derby/code/branches/10.3/java/engine/org/apache/derby/loc/messages.xml
MODIFY /db/derby/code/branches/10.3/java/client/org/apache/derby/client/am/PreparedStatement.java

Repository Revision Date User Message
ASF #629903 Thu Feb 21 18:24:16 UTC 2008 kmarsden DERBY-2653 Expose existing auto-generated key functionality through more JDBC APIs in Derby Client.
dd client support for columnIndex API's:

  Connection.prepareStatement(String sql, int[] columnIndexes);
  Statement.execute(String sql, int[] columIndexes);
  Statement.executeUpdate(String sql, int[] columnIndexes);

port from trunk revision 629566
Files Changed
MODIFY /db/derby/code/branches/10.3/java/client/org/apache/derby/client/net/ClientJDBCObjectFactoryImpl.java
MODIFY /db/derby/code/branches/10.3/java/testing/org/apache/derbyTesting/functionTests/tests/jdbcapi/AutoGenJDBC30Test.java
MODIFY /db/derby/code/branches/10.3/java/client/org/apache/derby/client/am/Statement.java
MODIFY /db/derby/code/branches/10.3/java/client/org/apache/derby/client/am/Connection.java
MODIFY /db/derby/code/branches/10.3/java/client/org/apache/derby/client/am/PreparedStatement40.java
MODIFY /db/derby/code/branches/10.3/java/client/org/apache/derby/client/net/ClientJDBCObjectFactoryImpl40.java
MODIFY /db/derby/code/branches/10.3/java/client/org/apache/derby/client/am/Statement40.java
MODIFY /db/derby/code/branches/10.3/java/client/org/apache/derby/client/am/DatabaseMetaData.java
MODIFY /db/derby/code/branches/10.3/java/client/org/apache/derby/client/net/NetPreparedStatement.java
MODIFY /db/derby/code/branches/10.3/java/client/org/apache/derby/client/am/CallableStatement.java
MODIFY /db/derby/code/branches/10.3/java/client/org/apache/derby/client/net/NetStatement.java
MODIFY /db/derby/code/branches/10.3/java/client/org/apache/derby/client/net/NetConnection.java
MODIFY /db/derby/code/branches/10.3/java/client/org/apache/derby/client/am/ClientJDBCObjectFactory.java
MODIFY /db/derby/code/branches/10.3/java/client/org/apache/derby/client/am/PreparedStatement.java

Repository Revision Date User Message
ASF #629909 Thu Feb 21 18:37:49 UTC 2008 kmarsden DERBY-2653 (doc) Expose existing auto-generated key functionality through more JDBC APIs in Derby Client.

port revision 629580 from trunk.
Files Changed
MODIFY /db/derby/docs/branches/10.3/src/ref/crefjavstateautogen.dita

Repository Revision Date User Message
ASF #639328 Thu Mar 20 15:53:41 UTC 2008 kmarsden remove not implemented exception tests for autogenerated keys apis for columnNames and columnIndexes. These interfaces have been added for 10.4 in DERBY-2653
Files Changed
MODIFY /db/derby/code/branches/10.3.2.1_test/java/testing/org/apache/derbyTesting/functionTests/tests/jdbcapi/AutoGenJDBC30Test.java


Powered by a free Atlassian JIRA open source license for Apache Software Foundation. Try JIRA - bug tracking software for your team.
Atlassian JIRA the Professional Issue Tracker. (Enterprise Edition, Version: 3.13.2-#335) - Bug/feature request - Atlassian news - Contact Administrators