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

Summary:	DB Explorer locks Sybase tempdb
Product:	db	Reporter:	bht <bht>
Component:	Code	Assignee:	Libor Fischmeistr <lfischmeistr>
Status:	RESOLVED INCOMPLETE
Severity:	normal
Priority:	P4
Version:	7.1
Hardware:	PC
OS:	Windows Vista
Issue Type:	DEFECT	Exception Reporter:

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.