Please be aware that the content in SAP SQL Anywhere Forum will be migrated to the SAP Community in June and this forum will be retired.

Hi,

I have a scenario in my solution, that when the user clicks on a save button the transaction is committed and the connection is closed.

At a given time if we try to close an unused preparedStatement (that depends on the closed connection) to release resources the application crashes without "telling" us that the connection is closed.

The resources that are linked on a connection shouldn't be released after closing the connection? Or when trying to close the preparedStatement after the connection an exception should occur?

tks,

Renato Pedrosa

asked 31 Jan '12, 07:09

Renato's gravatar image

Renato
2266614
accept rate: 0%

retagged 31 Jan '12, 09:57

PhilippeBertrand%20_SAP_'s gravatar image

PhilippeBert...
1.8k42139

1

It's awfully difficult to help you when you don't provide any details. From the above, I don't even know what programming language you're using, let alone what interface/API, what server/client version and build number, etc.

(31 Jan '12, 07:26) Glenn Paulley

Sorry.

I'm using ultraliteJ for Android version 12.0.1 build 3505.

(31 Jan '12, 07:45) Renato

Renato,

Yes, all resources owned by a Connection are released when the Connection is released. I think we have a bug that is causing your application to crash when a PreparedStatement from a released Connection is closed. We will fix that. A ULjException will be thrown if you try to close a PreparedStatement owned by a released Connection.

permanent link

answered 31 Jan '12, 10:13

Andy%20Quick's gravatar image

Andy Quick
2.2k2737
accept rate: 45%

Tks Andy!!

Do you have an estimated time to fix this issue?

(31 Jan '12, 10:21) Renato

In general I cannot commit to a time for a fix unless someone can convince me that this bug cannot be worked around.

(31 Jan '12, 13:17) Andy Quick
Your answer
toggle preview

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text](http://url.com/ "title")
  • image?![alt text](/path/img.jpg "title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported

Question tags:

×159
×79
×72
×16

question asked: 31 Jan '12, 07:09

question was seen: 2,654 times

last updated: 11 Oct '12, 12:45