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.
In the Oracle Db world the SQL Developer is best suited to use, however for simple sql queries it is sufficient (and less RAM intense) to use Netbeans SQL functionality. But there we have a great problem - How to keep the db connections in sync. In our company we regularly use about 12 db's (dev db's, cont integr. dbs, prod db's, test db's) and it is a pretty nerve wracking job in netbeans to duplicate connections, where most of the data looks the same, but only the IP or SID changes. In SQL Developer it is possible to export the connections in an xml file. Please integrate support to import those connections :) It looks sth like this: <?xml version = '1.0' encoding = 'UTF-8'?> <References xmlns="http://xmlns.oracle.com/adf/jndi"> <Reference name="MyDB" className="oracle.jdeveloper.db.adapter.DatabaseProvider" xmlns=""> <Factory className="oracle.jdeveloper.db.adapter.DatabaseProviderFactory"/> <RefAddresses> <StringRefAddr addrType="password"> <Contents>051D2CB8AC7D54B97DA0B3899DCF11ABCDB943ECF1E9F64567</Contents> </StringRefAddr> <StringRefAddr addrType="oraDriverType"> <Contents>thin</Contents> </StringRefAddr> <StringRefAddr addrType="RaptorConnectionType"> <Contents>Oracle</Contents> </StringRefAddr> <StringRefAddr addrType="sid"> <Contents>MYSID</Contents> </StringRefAddr> <StringRefAddr addrType="OracleConnectionType"> <Contents>BASIC</Contents> </StringRefAddr> <StringRefAddr addrType="ConnName"> <Contents>MyDB</Contents> </StringRefAddr> <StringRefAddr addrType="driver"> <Contents>oracle.jdbc.OracleDriver</Contents> </StringRefAddr> <StringRefAddr addrType="port"> <Contents>1521</Contents> </StringRefAddr> <StringRefAddr addrType="OS_AUTHENTICATION"> <Contents>false</Contents> </StringRefAddr> <StringRefAddr addrType="hostname"> <Contents>192.168.1.15</Contents> </StringRefAddr> <StringRefAddr addrType="SavePassword"> <Contents>true</Contents> </StringRefAddr> <StringRefAddr addrType="subtype"> <Contents>oraJDBC</Contents> </StringRefAddr> <StringRefAddr addrType="customUrl"> <Contents>jdbc:oracle:thin:@192.168.1.15:1521:MYSID</Contents> </StringRefAddr> <StringRefAddr addrType="NoPasswordConnection"> <Contents>TRUE</Contents> </StringRefAddr> <StringRefAddr addrType="KERBEROS_AUTHENTICATION"> <Contents>false</Contents> </StringRefAddr> <StringRefAddr addrType="role"> <Contents/> </StringRefAddr> <StringRefAddr addrType="user"> <Contents>dbuser</Contents> </StringRefAddr> </RefAddresses> </Reference> </References>