[dba-issues] [Issue 67290] com.sun.star.lang.Disposed Exeption after 2nd SQL-Query in 2.0.3
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=67290 User msc changed the following: What|Old value |New value Status|VERIFIED |CLOSED --- Additional comments from [EMAIL PROTECTED] Thu Aug 24 02:20:42 -0700 2006 --- Hi, this is fixed in the current master. The current master is available at http://download.openoffice.org/680/index.html I close this issue now. Bye Marc - Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[dba-issues] [Issue 67290] com.sun.star.lang.Disposed Exeption after 2nd SQL-Query in 2.0.3
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=67290 User msc changed the following: What|Old value |New value Status|RESOLVED |VERIFIED --- Additional comments from [EMAIL PROTECTED] Tue Jul 25 03:11:30 -0700 2006 --- verified in cws dba204b You can found more information about this CWS in the EIS tool at http://eis.services.openoffice.org/EIS2/cws.ShowCWS?Path=SRC680%2Fdba204b - Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[dba-issues] [Issue 67290] com.sun.star.lang.Disposed Exeption after 2nd SQL-Query in 2.0.3
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=67290 User fs changed the following: What|Old value |New value Assigned to|fs|msc --- Additional comments from [EMAIL PROTECTED] Thu Jul 20 06:46:31 -0700 2006 --- fs-> msc: please verify in CWS dba204b - Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[dba-issues] [Issue 67290] com.sun.star.lang.Disposed Exeption after 2nd SQL-Query in 2.0.3
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=67290 --- Additional comments from [EMAIL PROTECTED] Thu Jul 13 05:59:27 -0700 2006 --- Hi all, Just for the records. The cws is dba204b and not dba2034a Bye Marc - Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[dba-issues] [Issue 67290] com.sun.star.lang.Disposed Exeption after 2nd SQL-Query in 2.0.3
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=67290 User fs changed the following: What|Old value |New value Status|STARTED |RESOLVED Resolution| |FIXED --- Additional comments from [EMAIL PROTECTED] Thu Jul 13 03:07:35 -0700 2006 --- fixed in CWS dba204a find more information about this CWS, like when it is available in the master builds, in EIS, the Environment Information System: http://eis.services.openoffice.org/EIS2/cws.ShowCWS?Path=SRC680%2Fdba204a - Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[dba-issues] [Issue 67290] com.sun.star.lang.Disposed Exeption after 2nd SQL-Query in 2.0.3
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=67290 User fs changed the following: What|Old value |New value Status|NEW |STARTED --- Additional comments from [EMAIL PROTECTED] Thu Jul 13 00:31:11 -0700 2006 --- accepting - Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[dba-issues] [Issue 67290] com.sun.star.lang.Disposed Exeption after 2nd SQL-Query in 2.0.3
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=67290 User fs changed the following: What|Old value |New value Assigned to|dbaneedsconfirm |fs Ever confirmed| |1 Status|UNCONFIRMED |NEW Keywords| |regression Target milestone|not determined|OOo 2.0.4 --- Additional comments from [EMAIL PROTECTED] Wed Jul 12 23:27:41 -0700 2006 --- confirming, grabbing, adding "regression" keyword, targeting to 2.0.4 Could reproduce this with MySQL/ODBC. A quick investigation shows that the exception is throw because internally, two instances try to dispose the old result set, and the second instance fails because the first instances already succeeded. While this code in itself is somewhat too generous and should be fixed, it was present in this form for a long time. It seems that 2.0.2 had a resource problem with not properly clearing internal objects, which was fixed with 2.0.3, which, as a side effect, introduced this issue here. - Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[dba-issues] [Issue 67290] com.sun.star.lang.Disposed Exeption after 2nd SQL-Query in 2.0.3
To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=67290
Issue #|67290
Summary|com.sun.star.lang.DisposedExeption after 2nd SQL-Query
| in 2.0.3
Component|Database access
Version|OOo 2.0.3
Platform|PC
URL|
OS/Version|Windows XP
Status|UNCONFIRMED
Status whiteboard|
Keywords|
Resolution|
Issue type|DEFECT
Priority|P3
Subcomponent|none
Assigned to|dbaneedsconfirm
Reported by|r_rethmann
--- Additional comments from [EMAIL PROTECTED] Wed Jul 12 10:12:46 -0700
2006 ---
Hi there,
I've been working with 2.0.2 for a while now and just upgraded to 2.0.3.
After upgrading my scripts don't work any longer.
I'm accessing my Sybase SQL Anywhere 8 Server through ODBC.
This simple script shows the issue:
Sub Test
Dim oStatement as Object, sQuelle as String, sUser as String, sPW as String
Dim oState as Object, oDatabaseContext as Object, oDatenquelle as Object
DimsSQL as String, oResult as Object, oDVerb as Object
sQuelle = "database"
sUser = "user"
sPW = "***"
oDatabaseContext = createUnoService("com.sun.star.sdb.DatabaseContext")
If oDatabaseContext.hasByName(sQuelle) then
oDatenquelle = oDatabaseContext.getByName(sQuelle)
oDVerb = oDatenquelle.getConnection(sUser,sPW)
oStatement = oDVerb.createStatement()
oStatement.ResultSetType = com.sun.star.sdbc.ResultSetType.SCROLL_SENSITIVE
oStatement.ResultSetConcurrency = com.sun.star.sdbc.ResultSetConcurrency.
UPDATABLE
oStatement.EscapeProcessing = True
' read data from first table
sSQL = "SELECT FIRST ID FROM Daten"
oResult = oStatement.executeQuery(sSQL)
If not isNULL(oResult) and oResult.Next() then
MsgBox("First table data: " & oResult.getInt(1), 64, "Database Test")
End If
' Result: MsgBox displays data
' read data from second table
sSQL = "SELECT FIRST ID FROM Mitarbeiter"
oResult = oStatement.executeQuery(sSQL)
' in 2.0.3 I'll get a runtime error here: Exeption - com.sun.star.lang.
DisposedExeption (no further message)
' oStatement still exists
' in 2.0.2 it works
If not isNULL(oResult) and oResult.Next() then
MsgBox("Second table data: " & oResult.getInt(1), 64, "Database Test")
End If
oStatement.close()
oDVerb.close()
Else
MsgBox("Datenquelle '" & sQuelle & "' nicht vorhanden, Programmabbruch!")
End if
End Sub
Looks like you've changed the db-handling somehow. I couldn't find any
changelog, so I asked for help in the dba.dev mailing-list.
Frank Schönheit told me to file an issue (he could reproduce the error with
MySQL over ODBC).
IDL reference says: "This exception occurs if the object behind this interface
has been disposed before and can't uphold its method specification anymore."
But oStatement still exists, so what is wrong with the new version ?
Thank you for your help, Rado
-
Please do not reply to this automatically generated notification from
Issue Tracker. Please log onto the website and enter your comments.
http://qa.openoffice.org/issue_handling/project_issues.html#notification
-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
