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.
I am trying to connect to Sybase ASE 12.5.4 version database from NetBeans 6.1 version. It connects successfully but no tables or view or procedures are displayed under the connection. When i run this command 'sp_help person_risk_status' in the sql editor Executed successfully in 0 s, 1 rows affected. Line 1, column 1 Execution finished after 0 s, 0 error(s) occurred. 'person_risk_status' table does exist under the database which i have connected. When i try to run a simple query 'select * from person_risk_status' from the SQL Editor i get the following error "Error code 208, SQL state 42000: person_risk_status not found. Specify owner.objectname or use sp_help to check whether the object exists (sp_help may produce lots of output). Line 1, column 1" I am connecting using Sybase jdbc jars(jconn2.jar & jconn2d.jar). I am able to connect from weblogic server using connection pool successfully but fails to connect using Glassfish V2. My netbeans version : Product Version: NetBeans IDE 6.1 (Build 200804211638) Java: 1.6.0_06; Java HotSpot(TM) Client VM 10.0-b22 System: Windows XP version 5.1 running on x86; Cp1252; en_US (nb) Userdir: C:\Documents and Settings\rxc23\.netbeans\6.1
Created attachment 66620 [details] Sybase Netbeans Error
This usually is because (a) the database driver does not correctly support database metadata or (b) you have selected the wrong schema when you connected. Can you please make sure the schema is correct, and also that you have the lastest driver for Sybase?
but when i run sp_help <tablename> command in the SQL Editor it gets executed. Even the connection is establishing successfully. The drivers(jars) which i am using to connect are working fine since long time & have applications running them in production.
I am netbeans hardcore fan..basically my client recommend using Eclipse but i do most of my development using NetBeans. But i did not have problems connecting in using Eclipse Database Explorer in Eclipse IDE.
I understand that sp_help works. I am sure you are connected. But in order for tables to show up in the Database Explorer, you have to be using a driver that supports the JDBC metadata API, and you need to be connected to the right schema. Given that this works fine for you in Eclipse, I suspect it has to do with picking the right schema. I don't know how Eclipse works, but they may not need you to pick a schema in this way. Disconnect from Sybase, then reconnect. In the connection dialog, click on Advanced. Then choose "Get Schemas" and then see what schemas are listed in the drop-down box. Make sure you have picked the correct schema.
While creating the connection, i selected the right scheme from the schemas. But anyway i will try deleting & recreating the connection once again. Will Give a try. Long Live Netbeans...
Waiting for more input from the reporter, so marking as incomplete.
Its fixed. I recreated the connection & it works well now with old drivers only. I have also selected the right scheme. Anyway thnx..
could you please list the version of the old driver you used in case another user encounters the same problem
v
Move visualsqleditor subcomponents below visualweb