Reputation: 333
I have a problem.
Well, I have an VB6 app that connects to an oracle database. Normally it uses just one session to connect to the database, but after running an update query on a table, it opens another one, on wich it runs just one query : SELECT VALUE
FROM SYS.NLS_DATABASE_PARAMETERS
WHERE PARAMETER = 'NLS_NCHAR_CHARACTERSET'
The update query is :
UPDATE SYS_PASS set LAST_LOG = SYSDATE where ID = 'xxxx'
Any idee why this is happening, or how could i get rid of this extra session ?
Upvotes: 1
Views: 703
Reputation: 873
If you want know what for your database do select then ask about select (describe how you detected extra select etc), not about app, while people will not understand what problem do you have.
Your second query executes on the opened connection itself and not on any other connection.
You might be seeing other connection because of connection pooling. You can verify that by setting Pooling = false
in the connection string.
Upvotes: 0
Reputation: 14902
This extra SQL statement must be generated either by
Upvotes: 1