Issue Details (XML | Word | Printable)

Key: DERBY-3221
Type: Bug Bug
Status: Resolved Resolved
Resolution: Fixed
Priority: Major Major
Assignee: Dyre Tjeldvoll
Reporter: Tim Halloran
Votes: 0
Watchers: 1
Operations

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

"java.sql.SQLException: The conglomerate (-5) requested does not exist." from Derby 10.3.1.4 embedded within Eclipse 3.3 and RAD 7.0

Created: 21/Nov/07 08:23 PM   Updated: 30/Jun/09 03:55 PM
Return to search
Component/s: JDBC
Affects Version/s: 10.3.1.4, 10.3.2.1
Fix Version/s: 10.3.3.0, 10.4.1.3

Time Tracking:
Not Specified

File Attachments:
  File Name Date Attached Attached By Size
GZip Archive conlomerate.tar.gz 2007-12-17 03:09 PM James Alan Shepherd 8 kB
File Licensed for inclusion in ASF works derby-3221.prelim.diff 2008-01-07 04:03 PM Dyre Tjeldvoll 0.5 kB
File Licensed for inclusion in ASF works derby-3221.v1.diff 2008-01-09 01:40 PM Dyre Tjeldvoll 2 kB
File Licensed for inclusion in ASF works derby-3221.v2.diff 2008-01-14 04:41 PM Dyre Tjeldvoll 5 kB
File Licensed for inclusion in ASF works derby-3221.v3.diff 2008-01-17 04:22 PM Dyre Tjeldvoll 5 kB
File Licensed for inclusion in ASF works SubShape.properties 2008-01-07 04:03 PM Dyre Tjeldvoll 3 kB
Environment: Windows Vista Ubuntu Linux on IBM's VM (RAD 7.0)
Issue Links:
Reference
 

Bug behavior facts: Regression
Resolution Date: 18/Jan/08 09:54 AM


 Description  « Hide
We are getting an SQLException when several prepared statement deletes are done upon an existing database. As far as we can tell this exception should never occur unless (evil) things like deleting the database or editing files occurs. This is using the embedded driver within a plug-in inside RAD 7.0 (and Eclipse 3.3).

I'm not sure what else to submit that might be helpful.

java.sql.SQLException: The conglomerate (-5) requested does not exist.
 at org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown Source)
 at org.apache.derby.impl.jdbc.Util.generateCsSQLException(Unknown Source)
 at org.apache.derby.impl.jdbc.TransactionResourceImpl.wrapInSQLException(Unknown Source)
 at org.apache.derby.impl.jdbc.TransactionResourceImpl.handleException(Unknown Source)
 at org.apache.derby.impl.jdbc.EmbedConnection.handleException(Unknown Source)
 at org.apache.derby.impl.jdbc.ConnectionChild.handleException(Unknown Source)
 at org.apache.derby.impl.jdbc.EmbedStatement.executeStatement(Unknown Source)
 at org.apache.derby.impl.jdbc.EmbedPreparedStatement.executeStatement(Unknown Source)
 at org.apache.derby.impl.jdbc.EmbedPreparedStatement.execute(Unknown Source)
 at sun.reflect.GeneratedMethodAccessor12.invoke(Unknown Source)
 at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
 at java.lang.reflect.Method.invoke(Unknown Source)
 at com.surelogic.sierra.jdbc.LazyPreparedStatementConnection$LazyPreparedStatement.invoke(Unknown Source)
 at $Proxy1.execute(Unknown Source)
 at com.surelogic.sierra.jdbc.finding.FindingManager.delete(Unknown Source)
 at com.surelogic.sierra.jdbc.finding.ClientFindingManager.updateLocalFindings(Unknown Source)
 at com.surelogic.sierra.jdbc.project.ClientProjectManager.synchronizeProject(Unknown Source)
 at com.surelogic.sierra.client.eclipse.jobs.SynchronizeJob.synchronize(Unknown Source)
 at com.surelogic.sierra.client.eclipse.jobs.SynchronizeJob.run(Unknown Source)
 at org.eclipse.core.internal.jobs.Worker.run(Unknown Source)
Caused by: ERROR XSAI2: The conglomerate (-5) requested does not exist.
 at org.apache.derby.iapi.error.StandardException.newException(Unknown Source)
 at org.apache.derby.impl.store.access.RAMTransaction.findExistingConglomerate(Unknown Source)
 at org.apache.derby.impl.store.access.RAMTransaction.openScan(Unknown Source)
 at org.apache.derby.impl.sql.execute.TemporaryRowHolderResultSet.getNextRowCore(Unknown Source)
 at org.apache.derby.impl.sql.execute.TemporaryRowHolderResultSet.getNextRow(Unknown Source)
 at org.apache.derby.impl.sql.execute.IndexChanger.finish(Unknown Source)
 at org.apache.derby.impl.sql.execute.IndexSetChanger.finish(Unknown Source)
 at org.apache.derby.impl.sql.execute.RowChangerImpl.finish(Unknown Source)
 at org.apache.derby.impl.sql.execute.UpdateResultSet.open(Unknown Source)
 at org.apache.derby.impl.sql.GenericPreparedStatement.execute(Unknown Source)
 ... 14 more

 All   Comments   Work Log   Change History   Subversion Commits      Sort Order: Ascending order - Click to sort in descending order
Repository Revision Date User Message
ASF #613116 Fri Jan 18 09:52:32 UTC 2008 dyre DERBY-3221: "java.sql.SQLException: The conglomerate (-5) requested does not exist." from Derby 10.3.1.4 embedded within Eclipse 3.3 and RAD 7.0
Patch file: DERBY-3221.v3.diff
Files Changed
MODIFY /db/derby/code/trunk/java/engine/org/apache/derby/impl/sql/execute/TemporaryRowHolderResultSet.java
MODIFY /db/derby/code/trunk/java/engine/org/apache/derby/impl/sql/execute/TemporaryRowHolderImpl.java

Repository Revision Date User Message
ASF #615203 Fri Jan 25 12:29:31 UTC 2008 dyre DERBY-3343: Subsequent calls to PreparedStatement cause SQLIntegrityConstraintViolationException on column that is "Generated always"

Patch file: d3343.v3.diff

Modifies the logic in ResultColumn.getOrderableVariantType() so that it behaves
correctly even when a default column is explicitly mentioned in an insert statement.
Files Changed
MODIFY /db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/lang/ResultSetsFromPreparedStatementTest.java
MODIFY /db/derby/code/trunk/java/engine/org/apache/derby/impl/sql/compile/ResultColumn.java

Repository Revision Date User Message
ASF #615273 Fri Jan 25 17:12:54 UTC 2008 dyre DERBY-3221: "java.sql.SQLException: The conglomerate (-5) requested
does not exist." from Derby 10.3.1.4 embedded within Eclipse 3.3 and
RAD 7.0

Always set RowHolder.CID to 0, when RowHolder.conglomCreated is set to
false and the conglomerate is removed, because RowHolder's clients test for
CID==0 to find out if a temporary conglomerate exists.

Merged by svn merge -r 613115:613116 https://svn.apache.org/repos/asf/db/derby/code/trunk

Simple merge with no conflicts; no additional changes were necessary.
Files Changed
MODIFY /db/derby/code/branches/10.3/java/engine/org/apache/derby/impl/sql/execute/TemporaryRowHolderResultSet.java
MODIFY /db/derby/code/branches/10.3/java/engine/org/apache/derby/impl/sql/execute/TemporaryRowHolderImpl.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