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.
Created attachment 129652 [details] snapshot of what happens: no results on "choose View Data" According Help of NetBeans IDE 7.3 Beta 2, In Search Panel - Point 10) When a database is connected, you can view and modify the data contained in a table in the built-in graphical representation of the SQL Editor. To view data in a table: In the Services window, expand the node for a connected database ( ). Expand the Tables or Views node. Right-click the node of the table or view and choose View Data. When you choose View Data, an SQL query to select all the data from the table is automatically generated in the upper pane of the SQL Editor. A visual representation of the table and the data it contains is displayed in the lower pane of the SQL Editor. => Last point does't work... I am connected with jdbc:oracle:oci8:@localhost:1521:XE[billy on BILLY] user jar is ojdbc14.jar I don't know what is missing... wher can I found more explanations? with sqldevelopper, all is OK. A propos de ----------- Oracle SQL Developer 3.2.20.09 Version 3.2.20.09 Build MAIN-09.87 Copyright © 2005, 2012 Oracle. Tous droits réservés. IDE Version: 11.1.1.4.37.59.48 Product ID: oracle.sqldeveloper Product Version: 11.2.0.09.87 Version ------- Composant Version ========= ======= Oracle IDE 3.2.20.09.87 Plate-forme Java(TM) 1.6.0_35 Prise en charge de la gestion des versions 3.2.20.09.87 Propriétés ---------- Nom Valeur === ====== awt.toolkit sun.awt.windows.WToolkit class.load.environment oracle.ide.boot.IdeClassLoadEnvironment class.load.log.level CONFIG class.transfer delegate file.encoding Cp1252 file.encoding.pkg sun.io file.separator \ ice.browser.forcegc false ice.pilots.html4.ignoreNonGenericFonts true ice.pilots.html4.tileOptThreshold 0 ide.AssertTracingDisabled true ide.bootstrap.start 2044385347299 ide.build MAIN-09.87 ide.conf D:\sqldeveloper\sqldeveloper\bin\sqldeveloper.conf ide.config_pathname D:\sqldeveloper\sqldeveloper\bin\sqldeveloper.conf ide.debugbuild false ide.devbuild false ide.extension.search.path sqldeveloper/extensions:jdev/extensions:ide/extensions ide.firstrun true ide.java.minversion 1.6.0_04 ide.launcherProcessId 4520 ide.main.class oracle.ide.boot.IdeLauncher ide.patches.dir ide/lib/patches ide.pref.dir C:\Documents and Settings\Billy\Application Data\SQL Developer ide.pref.dir.base C:\Documents and Settings\Billy\Application Data ide.product oracle.sqldeveloper ide.shell.enableFileTypeAssociation D:\sqldeveloper\sqldeveloper.exe ide.splash.screen splash.gif ide.startingArg0 D:\sqldeveloper\sqldeveloper.exe ide.startingcwd D:\sqldeveloper ide.user.dir C:\Documents and Settings\Billy\Application Data\SQL Developer ide.user.dir.var IDE_USER_DIR ide.vcs.noapplications true ide.work.dir C:\Documents and Settings\Billy\Mes documents\SQL Developer ide.work.dir.base C:\Documents and Settings\Billy\Mes documents ilog.propagatesPropertyEditors false java.awt.graphicsenv sun.awt.Win32GraphicsEnvironment java.awt.printerjob sun.awt.windows.WPrinterJob java.class.path ..\..\ide\lib\ide-boot.jar java.class.version 50.0 java.endorsed.dirs D:\sqldeveloper\jdk\jre\lib\endorsed java.ext.dirs D:\sqldeveloper\jdk\jre\lib\ext;C:\WINDOWS\Sun\Java\lib\ext java.home D:\sqldeveloper\jdk\jre java.io.tmpdir C:\DOCUME~1\Billy\Local Settings\Temp\ java.library.path D:\sqldeveloper;C:\WINDOWS\Sun\Java\bin;C:\WINDOWS\system32;C:\WINDOWS;C:\Program Files\instantclient_10_2;D:\oraclexe\app\oracle\product\11.2.0\server\bin;D:\cygwin\bin;C:\Program Files\7-Zip;C:\mysql-5.0\bin;C:\Program Files\Java\jdk1.6.0_22\bin;C:\apache-ant-1.7.0\bin;C:\WINDOWS\system32;C:\WINDOWS;C:\WINDOWS\System32\Wbem;C:\Program Files\Intel\WiFi\bin\;C:\Program Files\QuickTime\QTSystem";C:\Program Files\QuickTime\QTSystem\;. java.naming.factory.initial oracle.javatools.jndi.LocalInitialContextFactory java.protocol.handler.pkgs oracle.jdevimpl.handler java.runtime.name Java(TM) SE Runtime Environment java.runtime.version 1.6.0_35-b10 java.specification.name Java Platform API Specification java.specification.vendor Sun Microsystems Inc. java.specification.version 1.6 java.util.logging.config.file logging.conf java.vendor Sun Microsystems Inc. java.vendor.url http://java.sun.com/ java.vendor.url.bug http://java.sun.com/cgi-bin/bugreport.cgi java.version 1.6.0_35 java.vm.info mixed mode java.vm.name Java HotSpot(TM) Client VM java.vm.specification.name Java Virtual Machine Specification java.vm.specification.vendor Sun Microsystems Inc. java.vm.specification.version 1.0 java.vm.vendor Sun Microsystems Inc. java.vm.version 20.10-b01 jdbc.library /D:/sqldeveloper/jdbc/lib/ojdbc6.jar line.separator \r\n log.file.name D:\sqldeveloper\sqldeveloper\extensions\oracle.datamodeler\log\datamodeler.log oracle.home D:\sqldeveloper oracle.ide.util.AddinPolicyUtils.OVERRIDE_FLAG true oracle.jdbc.mapDateToTimestamp false oracle.translated.locales de,es,fr,it,ja,ko,pt_BR,zh_CN,zh_TW oracle.xdkjava.compatibility.version 9.0.4 orai18n.library /D:/sqldeveloper/jlib/orai18n.jar os.arch x86 os.name Windows XP os.version 5.1 path.separator ; reserved_filenames con,aux,prn,lpt1,lpt2,lpt3,lpt4,lpt5,lpt6,lpt7,lpt8,lpt9,com1,com2,com3,com4,com5,com6,com7,com8,com9,conin$,conout,conout$ sqldev.debug false sun.arch.data.model 32 sun.boot.class.path D:\sqldeveloper\jdk\jre\lib\resources.jar;D:\sqldeveloper\jdk\jre\lib\rt.jar;D:\sqldeveloper\jdk\jre\lib\sunrsasign.jar;D:\sqldeveloper\jdk\jre\lib\jsse.jar;D:\sqldeveloper\jdk\jre\lib\jce.jar;D:\sqldeveloper\jdk\jre\lib\charsets.jar;D:\sqldeveloper\jdk\jre\lib\modules\jdk.boot.jar;D:\sqldeveloper\jdk\jre\classes sun.boot.library.path D:\sqldeveloper\jdk\jre\bin sun.cpu.endian little sun.cpu.isalist pentium_pro+mmx pentium_pro pentium+mmx pentium i486 i386 i86 sun.desktop windows sun.io.unicode.encoding UnicodeLittle sun.java2d.ddoffscreen false sun.jnu.encoding Cp1252 sun.management.compiler HotSpot Client Compiler sun.os.patch.level Service Pack 3 svnkit.sax.useDefault true user.country FR user.dir D:\sqldeveloper\sqldeveloper\bin user.home C:\Documents and Settings\Billy user.language fr user.name Billy user.timezone Europe/Paris user.variant windows.shell.font.languages Extensions ---------- Nom Identificateur Version Statut === ============== ======= ====== Check For Updates oracle.ide.webupdate 11.1.1.4.37.59.48 Chargé Code Editor oracle.ide.ceditor 11.1.1.4.37.59.48 Chargé Component Palette oracle.ide.palette1 11.1.1.4.37.59.48 Chargé Data Miner oracle.dmt.dataminer 11.2.1.1.09.87 Chargé Diagram Javadoc Extension oracle.diagram.javadoc 11.1.1.4.37.59.48 Chargé Diagramme miniature oracle.diagram.thumbnail 11.1.1.4.37.59.48 Chargé Diff/Merge oracle.ide.diffmerge 11.1.1.4.37.59.48 Chargé Débogueur PROBE oracle.jdeveloper.db.debug.probe 11.1.1.4.37.59.48 Chargé Explorateurs d'objets de base de données oracle.ide.db.explorer 11.1.1.4.37.59.48 Chargé Extended IDE Platform oracle.javacore 11.1.1.4.37.59.48 Chargé File Support oracle.ide.files 11.1.1.4.37.59.48 Chargé Galerie d'objets oracle.ide.gallery 11.1.1.4.37.59.48 Chargé Help System oracle.ide.help 11.1.1.4.37.59.48 Chargé Import/Export Support oracle.ide.importexport 11.1.1.4.37.59.48 Chargé Index Migrator support oracle.ideimpl.indexing-migrator 11.1.1.4.37.59.48 Chargé Interface utilisateur de la base de données oracle.ide.db 11.1.1.4.37.59.48 Chargé JDeveloper Runner oracle.jdeveloper.runner 11.1.1.4.37.59.48 Chargé Log Window oracle.ide.log 11.1.1.4.37.59.48 Chargé Mac OS X Adapter oracle.ideimpl.apple 11.1.1.4.37.59.48 Chargé Module d'extension d'inscription JViews oracle.diagram.registration 11.1.1.4.37.59.48 Chargé Navigator oracle.ide.navigator 11.1.1.4.37.59.48 Chargé Oracle IDE oracle.ide 11.1.1.4.37.59.48 Chargé Oracle SQL Developer oracle.sqldeveloper 11.2.0.09.87 Chargé Oracle SQL Developer - 3rd Party Database Browsers oracle.sqldeveloper.thirdparty.browsers 11.2.0.09.87 Chargé Oracle SQL Developer - APEX Listener Administration oracle.sqldeveloper.listener 11.2.0.09.87 Chargé Oracle SQL Developer - Change Mangement oracle.sqldeveloper.em_cm 11.2.0.09.87 Chargé Oracle SQL Developer - DBA Navigator oracle.sqldeveloper.dbanavigator 11.2.0.09.87 Chargé Oracle SQL Developer - Database Cart oracle.sqldeveloper.dbcart 11.2.0.09.87 Chargé Oracle SQL Developer - Extras oracle.sqldeveloper.extras 11.2.0.09.87 Chargé Oracle SQL Developer - File Navigator oracle.sqldeveloper.filenavigator 11.2.0.09.87 Chargé Oracle SQL Developer - Migrations Antlr3 Translator oracle.sqldeveloper.migration.translation.core_antlr3 11.2.0.09.87 Chargé Oracle SQL Developer - Migrations Application Migration oracle.sqldeveloper.migration.application 11.2.0.09.87 Chargé Oracle SQL Developer - Migrations Core oracle.sqldeveloper.migration 11.2.0.09.87 Chargé Oracle SQL Developer - Migrations DB2 oracle.sqldeveloper.migration.db2 11.2.0.09.87 Chargé Oracle SQL Developer - Migrations DB2 Translator oracle.sqldeveloper.migration.translation.db2 11.2.0.09.87 Chargé Oracle SQL Developer - Migrations Microsoft Access oracle.sqldeveloper.migration.msaccess 11.2.0.09.87 Chargé Oracle SQL Developer - Migrations Microsoft SQL Server oracle.sqldeveloper.migration.sqlserver 11.2.0.09.87 Chargé Oracle SQL Developer - Migrations MySQL oracle.sqldeveloper.migration.mysql 11.2.0.09.87 Chargé Oracle SQL Developer - Migrations Sybase Adaptive Server oracle.sqldeveloper.migration.sybase 11.2.0.09.87 Chargé Oracle SQL Developer - Migrations T-SQL Translator oracle.sqldeveloper.migration.translation.core 11.2.0.09.87 Chargé Oracle SQL Developer - Migrations Teradata oracle.sqldeveloper.migration.teradata 11.2.0.09.87 Chargé Oracle SQL Developer - Migrations Teradata SQL Translator oracle.sqldeveloper.migration.translation.teradata_translator 11.2.0.09.87 Chargé Oracle SQL Developer - Migrations Translation UI oracle.sqldeveloper.migration.translation.gui 11.2.0.09.87 Chargé Oracle SQL Developer - Object Viewer oracle.sqldeveloper.oviewer 11.2.0.09.87 Chargé Oracle SQL Developer - Real Time SQL Monitoring oracle.sqldeveloper.sqlmonitor 11.2.0.09.87 Chargé Oracle SQL Developer - Reports oracle.sqldeveloper.report 11.2.0.09.87 Chargé Oracle SQL Developer - Scheduler oracle.sqldeveloper.scheduler 11.2.0.09.87 Chargé Oracle SQL Developer - Schema Browser oracle.sqldeveloper.schemabrowser 11.2.0.09.87 Chargé Oracle SQL Developer - SearchBar oracle.sqldeveloper.searchbar 11.2.0.09.87 Chargé Oracle SQL Developer - Security oracle.sqldeveloper.security 11.2.0.09.87 Chargé Oracle SQL Developer - Snippet oracle.sqldeveloper.snippet 11.2.0.09.87 Chargé Oracle SQL Developer - Spatial oracle.sqldeveloper.spatial 11.2.0.09.87 Chargé Oracle SQL Developer - TimesTen oracle.sqldeveloper.timesten 11.2.0.09.87 Chargé Oracle SQL Developer - Tuning oracle.sqldeveloper.tuning 11.2.0.09.87 Chargé Oracle SQL Developer - Unit Test oracle.sqldeveloper.unit_test 11.2.0.09.87 Chargé Oracle SQL Developer - User Extensions Support oracle.sqldeveloper.userextensions 11.2.0.09.87 Chargé Oracle SQL Developer - Worksheet v2 oracle.sqldeveloper.worksheet 11.2.0.09.87 Chargé Oracle SQL Developer - XML Schema oracle.sqldeveloper.xmlschema 11.2.0.09.87 Chargé Oracle SQL Developer Data Modeler oracle.datamodeler 3.1.4.710 Chargé Oracle SQL Developer Data Modeler - Reports oracle.sqldeveloper.datamodeler_reports 11.2.0.09.87 Chargé Outils externes oracle.ide.externaltools 11.1.1.4.37.59.48 Chargé Peek oracle.ide.peek 11.1.1.4.37.59.48 Chargé Persistent Storage oracle.ide.persistence 11.1.1.4.37.59.48 Chargé Prise en charge de l'historique oracle.jdeveloper.history 11.1.1.4.37.59.48 Chargé Prise en charge de la gestion des versions oracle.jdeveloper.vcs 11.1.1.4.37.59.48 Chargé Prise en charge de la gestion des versions pour Subversion oracle.jdeveloper.subversion 11.1.1.4.37.59.48 Chargé Property Inspector oracle.ide.inspector 11.1.1.4.37.59.48 Chargé QuickDiff oracle.ide.quickdiff 11.1.1.4.37.59.48 Chargé Replace With oracle.ide.replace 11.1.1.4.37.59.48 Chargé Runner oracle.ide.runner 11.1.1.4.37.59.48 Chargé Structure de diagramme oracle.diagram 11.1.1.4.37.59.48 Chargé Support de connexion à la base de données oracle.jdeveloper.db.connection 11.1.1.4.37.59.48 Chargé VHV oracle.ide.vhv 11.1.1.4.37.59.48 Chargé Virtual File System oracle.ide.vfs 11.1.1.4.37.59.48 Chargé Web Browser and Proxy oracle.ide.webbrowser 11.1.1.4.37.59.48 Chargé XML Editing Framework IDE Extension oracle.ide.xmlef 11.1.1.4.37.59.48 Chargé audit oracle.ide.audit 11.1.1.4.37.59.48 Chargé chemin de classe : extension du gestionnaire de protocole oracle.jdeveloper.classpath 11.1.1.0.0 Chargé jdukshare oracle.bm.jdukshare 11.1.1.4.37.59.48 Chargé mof-xmi oracle.mof.xmi 11.1.1.4.37.59.48 Chargé oracle.ide.dependency oracle.ide.dependency 11.1.1.4.37.59.48 Chargé oracle.ide.indexing oracle.ide.indexing 11.1.1.4.37.59.48 Chargé palette2 oracle.ide.palette2 11.1.1.4.37.59.48 Chargé statut oracle.ide.status 11.1.1.4.37.59.48 Chargé
Could you please attach also your messages.log from the IDE session when cannot read results? Thanks http://wiki.netbeans.org/FaqLogMessagesFile
Created attachment 129830 [details] add the messages.log stored in D:\Program Files\NetBeans 7.3 Beta 2\nb\var\log I use the "Oracle Thin" for Oracle connexion Curiously in the Oracle Client... I find Driver file(s) is for D:\app\Billy\product\11.2.0\client_1\sqldeveloper\jdbc\lib\ojdbc5.jar the edition is 5 If I try with the Instant Client, the edition is 6 but there is no change in the behaviour.
You've attached incorrect log; requested one should be in your userdir. See http://wiki.netbeans.org/FaqLogMessagesFile and attach correct one (something like C:\Users\joe\AppData\Roaming\NetBeans\7.2\var\log\messages.log) , thanks.
I'm sorry, I cannot reproduce the bug. Both Oracle Thin and Oracle OCI (in file instantclient-basic-windows.x64-11.2.0.3.0.zip from http://www.oracle.com/technetwork/topics/winx64soft-089540.html) work fine for me. I haven't seen the bug with any other driver yet. Can you please try the same driver (11.2.0.3) for your operation system?
Important question, does the View Data action work correctly with other databases, e.g. Derby? Thank you.
Hello, I can't access the log file as described in your panel. May be there is a bug in the desinstallation process...or installation process... What I have done is: A) Installation of Netbeans 7.2 B) Installation of Netbeans 7.3 Beta C) De_Installation of Netbeans 7.2 So after I don't find the log directory installed in C:\Documents and Settings\User\.... So I don't know from what step, the problem on the log has started. I always install my netbeans software on D: Disk (on windows XP SP3). So the First thing to do is to fix my installation problem to have correct directory and file log...
What do you see if you run NB 7.3 Beta and invoke in menu Help | About? There should be item "User directory" which should be existing folder. Under user directory will be var\log\messages.log (In reply to comment #6) > Hello, > I can't access the log file as described in your panel. > > May be there is a bug in the desinstallation process...or installation > process... > > What I have done is: > > A) Installation of Netbeans 7.2 > B) Installation of Netbeans 7.3 Beta > > C) De_Installation of Netbeans 7.2 > > So after I don't find the log directory installed in C:\Documents and > Settings\User\.... > > So I don't know from what step, the problem on the log has started. > > I always install my netbeans software on D: Disk (on windows XP SP3). > > So the First thing to do is to fix my installation problem to have correct > directory and file log...
Created attachment 129869 [details] zip of the copy of log directory from C:\Documents and Settings\Billy\Application Data\NetBeans\7.3beta2\var You are right for the log file... I found it in C:\Documents and Settings\Billy\Application Data\NetBeans\7.3beta2\var directory Billy is the user Name... So I try again the operation on database at January 3, 2013 11:38:50 PM CET there is a message "INFO [org.netbeans.libs.svnclientadapter]: Javahl client adapter is not available Failed to load JavaHL Library. " what does'it mean?
Created attachment 129870 [details] Last snapshot of used drivers I use D:\app\Billy\product\11.2.0\client_1\sqldeveloper\jdbc\lib\ojdbc5.jar in Drivers node as shown in last joined snapshot Is it the right item? Do I need OCI too? My PC is a toshiba tecra M5 with 3 Go Ram (X86 Intel dual core). with XP SP3.
(In reply to comment #9) > I use D:\app\Billy\product\11.2.0\client_1\sqldeveloper\jdbc\lib\ojdbc5.jar > in Drivers node as shown in last joined snapshot. Thank you. I tested the same driver and it worked well for me. > Is it the right item? Yes. > Do I need OCI too? No, I tested OCI because in the bug description you said that your connection URL is jdbc:oracle:oci8:@localhost:1521:XE[billy on BILLY]. If you execute the statement manually ("Run SQL" button, Ctrl-Shift-E), are the data shown correctly? Other databases (Derby, MySQL) work well for you? (In reply to comment #8) > There is a message "INFO [org.netbeans.libs.svnclientadapter]: Javahl client > adapter is not available > Failed to load JavaHL Library. > what does'it mean? I don't know, but is probably not related to this bug.
(In reply to comment #10) > (In reply to comment #9) > If you execute the statement manually ("Run SQL" button, Ctrl-Shift-E), are the > data shown correctly? > > Other databases (Derby, MySQL) work well for you? I found a suspicious place in Billy's log - INFO [org.netbeans.modules.db.sql.editor.SQLEditorProviderImpl]: No SQLExecuteCookie found for org.netbeans.modules.cnd.source.HDataObject@1c0b18e[MultiFileObject@13a4600[Databases/SQLCommands/SQL Command 40.sql]] It seems as .sql extension is registered for other data loader than SQL Editor Loader, it means no SQL executor is called for handle the SQL command. Billy, could you review registration of extentions in your IDE (Tools|Options|Misc|Files)? Or temporary Deactivate C/C++ support (use Tools|Plugins) or simply do another installation of IDE and choose smaller distribution (e.g.http://bits.netbeans.org/download/trunk/nightly/latest/start.html?platform=windows&lang=en&option=javase) it try it again? Thanks > (In reply to comment #8) > > There is a message "INFO [org.netbeans.libs.svnclientadapter]: Javahl client > > adapter is not available > > Failed to load JavaHL Library. > > what does'it mean? > I don't know, but is probably not related to this bug. Right, it's not important here.
Created attachment 129918 [details] add messages.log with Mysql connexion Mysql connexion with a project written in PHP + Mysql (xampp is set )
Created attachment 129919 [details] snapshot of mysql result... I don't obtain results from a mysql connexion. In this case... My netbeans projets holds C++ projets (with cygwin links) Mysql+PHP projects... A connexion with an Oracle Base. I will try in a next step to remove links with cygwin as you suggest...
Created attachment 129920 [details] snapshot of cygwin removal I can't remove Cygwin attachment (button "remove"is not accessible) "Restore Default" only set Encoding "ISO-8859-1" unto "UTF_8" well... Must I clean all the solution and re-install completely netbeans?
You don't need to remove Cygwin at all. Please read carefully jrechtacek's comment 11 : Go to Tools | Plugins. Choose Installed tab, select C/C++, push Deactivate button. (In reply to comment #14) > Created attachment 129920 [details] > snapshot of cygwin removal > > I can't remove Cygwin attachment (button "remove"is not accessible) > "Restore Default" only set Encoding "ISO-8859-1" unto "UTF_8" > > well... > > Must I clean all the solution and re-install completely netbeans?