This Bugzilla instance is a read-only archive of historic NetBeans bug reports. To report a bug in NetBeans please follow the project's instructions for reporting issues.

Bug 200098 - DB Explorer locks Sybase tempdb
Summary: DB Explorer locks Sybase tempdb
Status: RESOLVED INCOMPLETE
Alias: None
Product: db
Classification: Unclassified
Component: Code (show other bugs)
Version: 7.1
Hardware: PC Windows Vista
: P4 normal (vote)
Assignee: Libor Fischmeistr
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2011-07-13 08:18 UTC by bht
Modified: 2014-09-21 16:52 UTC (History)
0 users

See Also:
Issue Type: DEFECT
Exception Reporter:

Attachments
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
Description bht 2011-07-13 08:18:36 UTC 
When I connect using com.sybase.jdbc3.jdbc.SybDataSource, then the DB admin tells me that I am locking tempdb, causing problems. This appears to happen after I ran a couple of very quick queries, or none at all. Very embarassing.

NetBeans IDE Dev (Build 201107060600)
Comment 1 Jiri Rechtacek 2011-07-13 08:36:23 UTC 
Please, attach more details about this problem. messages.log, version of JDBC driver (a link for download it as best), steps etc. Thank you
Sybase is not on list of supported/tested DB engines, it's hard to fix such problems. Patches are welcome.
Comment 2 bht 2011-07-13 08:45:23 UTC 
Thanks Jiri for your comments. I will keep an eye on this in the long run, but I cannot promise any information yet. I am happy with priority 4 due to the fact that Sybase is not directly supported.
Comment 3 matthias42 2014-09-21 16:52:14 UTC 
Closing as incomplete. Googling for "sybase lock tempdb" turns up as the first matches problems with temporary tables. This looks like a problem inside the DBMS. Feel free to reopen if it is still reproducible.