1 Reply Latest reply on Feb 11, 2014 11:18 PM by Gary Graham-Oracle

SQLDeveloper Microsoft Access 2007 db Migration to Oracle failure

user5239736 Feb 11, 2014 7:56 PM

I am trying to convert a Microsoft Access 2007 database to Oracle 10g database via SqlDeveloper Version 4.0.0.13 (32 bit)

(I already learned the hard way it has to be done with the 32 bit version due to driver incompatibility between Access 2007 and Sqldeveloper 64 bit).

I have tried it both online and offline with no success.

According to all documentation that I have read the "Available source platform" can be blank because there is not a special third party driver needed for MS Access migrations.

I have successfully created the Access connection in SQL Developer but get an error message when I get to Step 5 "Capture"

Also after pressing the OK button there are no Available Databases listed.

Below is the error for the Online attempt. Following that is the information on SqlDeveloper Version

What am I missing?

java.lang.Exception: The plugin used to capture this model is not available. Please re-install the plugin and try again before convert.

at oracle.dbtools.migration.workbench.core.ui.quickmigrate.QMWizard$ContextHelper.getMigrationPluginOnline(QMWizard.java:576)

at oracle.dbtools.migration.workbench.core.ui.quickmigrate.CapturePageMigration.initPageState(CapturePageMigration.java:305)

at oracle.dbtools.migration.workbench.core.ui.quickmigrate.CapturePageMigration.onEntry(CapturePageMigration.java:78)

at oracle.ide.wizard.FSMWizard.gotoPanel(FSMWizard.java:765)

at oracle.ide.wizard.FSMWizard.setSelectedPage(FSMWizard.java:481)

at oracle.bali.ewt.wizard.BaseWizard.selectPage(BaseWizard.java:1966)

at oracle.ide.wizard.FSMWizard.selectPage(FSMWizard.java:465)

at oracle.ide.wizard.FSMWizard.doNext(FSMWizard.java:340)

at oracle.bali.ewt.wizard.BaseWizard$Action$1.run(BaseWizard.java:4033)

at java.awt.event.InvocationEvent.dispatch(InvocationEvent.java:251)

at java.awt.EventQueue.dispatchEventImpl(EventQueue.java:733)

at java.awt.EventQueue.access$200(EventQueue.java:103)

at java.awt.EventQueue$3.run(EventQueue.java:694)

at java.awt.EventQueue$3.run(EventQueue.java:692)

at java.security.AccessController.doPrivileged(Native Method)

at java.security.ProtectionDomain$1.doIntersectionPrivilege(ProtectionDomain.java:76)

at java.awt.EventQueue.dispatchEvent(EventQueue.java:703)

at oracle.javatools.internal.ui.EventQueueWrapper._dispatchEvent(EventQueueWrapper.java:169)

at oracle.javatools.internal.ui.EventQueueWrapper.dispatchEvent(EventQueueWrapper.java:151)

at java.awt.EventDispatchThread.pumpOneEventForFilters(EventDispatchThread.java:242)

at java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:161)

at java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:154)

at java.awt.WaitDispatchSupport$2.run(WaitDispatchSupport.java:182)

at java.awt.WaitDispatchSupport$4.run(WaitDispatchSupport.java:221)

at java.security.AccessController.doPrivileged(Native Method)

at java.awt.WaitDispatchSupport.enter(WaitDispatchSupport.java:219)

at java.awt.Dialog.show(Dialog.java:1082)

at java.awt.Component.show(Component.java:1651)

at java.awt.Component.setVisible(Component.java:1603)

at java.awt.Window.setVisible(Window.java:1014)

at java.awt.Dialog.setVisible(Dialog.java:1005)

at oracle.bali.ewt.wizard.WizardDialog.runDialog(WizardDialog.java:382)

at oracle.bali.ewt.wizard.WizardDialog.runDialog(WizardDialog.java:298)

at oracle.ide.dialogs.WizardLauncher.runDialog(WizardLauncher.java:51)

at oracle.dbtools.migration.workbench.core.ui.quickmigrate.QMWizard.launch(QMWizard.java:1444)

at oracle.dbtools.migration.workbench.core.QMLauncher.launch(QMLauncher.java:40)

at oracle.dbtools.migration.workbench.core.WorkbenchController.handleEvent(WorkbenchController.java:135)

at oracle.ideimpl.controller.MetaClassController.handleEvent(MetaClassController.java:53)

at oracle.ide.controller.IdeAction$ControllerDelegatingController.handleEvent(IdeAction.java:1482)

at oracle.ide.controller.IdeAction.performAction(IdeAction.java:663)

at oracle.ide.controller.IdeAction.actionPerformedImpl(IdeAction.java:1153)

at oracle.ide.controller.IdeAction.actionPerformed(IdeAction.java:618)

at javax.swing.AbstractButton.fireActionPerformed(AbstractButton.java:2018)

at javax.swing.AbstractButton$Handler.actionPerformed(AbstractButton.java:2341)

at javax.swing.DefaultButtonModel.fireActionPerformed(DefaultButtonModel.java:402)

at javax.swing.DefaultButtonModel.setPressed(DefaultButtonModel.java:259)

at javax.swing.AbstractButton.doClick(AbstractButton.java:376)

at javax.swing.plaf.basic.BasicMenuItemUI.doClick(BasicMenuItemUI.java:833)

at javax.swing.plaf.basic.BasicMenuItemUI$Handler.mouseReleased(BasicMenuItemUI.java:877)

at java.awt.Component.processMouseEvent(Component.java:6505)

at javax.swing.JComponent.processMouseEvent(JComponent.java:3320)

at java.awt.Component.processEvent(Component.java:6270)

at java.awt.Container.processEvent(Container.java:2229)

at java.awt.Component.dispatchEventImpl(Component.java:4861)

at java.awt.Container.dispatchEventImpl(Container.java:2287)

at java.awt.Component.dispatchEvent(Component.java:4687)

at java.awt.LightweightDispatcher.retargetMouseEvent(Container.java:4832)

at java.awt.LightweightDispatcher.processMouseEvent(Container.java:4492)

at java.awt.LightweightDispatcher.dispatchEvent(Container.java:4422)

at java.awt.Container.dispatchEventImpl(Container.java:2273)

at java.awt.Window.dispatchEventImpl(Window.java:2719)

at java.awt.Component.dispatchEvent(Component.java:4687)

at java.awt.EventQueue.dispatchEventImpl(EventQueue.java:735)

at java.awt.EventQueue.access$200(EventQueue.java:103)

at java.awt.EventQueue$3.run(EventQueue.java:694)

at java.awt.EventQueue$3.run(EventQueue.java:692)

at java.security.AccessController.doPrivileged(Native Method)

at java.security.ProtectionDomain$1.doIntersectionPrivilege(ProtectionDomain.java:76)

at java.security.ProtectionDomain$1.doIntersectionPrivilege(ProtectionDomain.java:87)

at java.awt.EventQueue$4.run(EventQueue.java:708)

at java.awt.EventQueue$4.run(EventQueue.java:706)

at java.security.AccessController.doPrivileged(Native Method)

at java.security.ProtectionDomain$1.doIntersectionPrivilege(ProtectionDomain.java:76)

at java.awt.EventQueue.dispatchEvent(EventQueue.java:705)

at oracle.javatools.internal.ui.EventQueueWrapper._dispatchEvent(EventQueueWrapper.java:169)

at oracle.javatools.internal.ui.EventQueueWrapper.dispatchEvent(EventQueueWrapper.java:151)

at java.awt.EventDispatchThread.pumpOneEventForFilters(EventDispatchThread.java:242)

at java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:161)

at java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:150)

at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:146)

at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:138)

at java.awt.EventDispatchThread.run(EventDispatchThread.java:91

About

-----

Oracle SQL Developer 4.0.0.13

Version 4.0.0.13

Build MAIN-13.80

IDE Version: 12.1.3.0.41.131202.1730

Product ID: oracle.sqldeveloper

Product Version: 12.2.0.13.80

Version

-------

Component Version

========= =======

Oracle IDE 4.0.0.13.80

Java(TM) Platform 1.7.0_51

Properties

----------

Name Value

==== =====

file.encoding.pkg sun.io

org.osgi.framework.executionenvironment OSGi/Minimum-1.0,OSGi/Minimum-1.1,OSGi/Minimum-1.2,JRE-1.1,J2SE-1.2,J2SE-1.3,J2SE-1.4,J2SE-1.5,JavaSE-1.6,JavaSE-1.7

ide.firstrun true

osgi.framework file:/C:/Users/hmyuser/Applications/sqldeveloper/netbeans/platform/modules/ext/org.eclipse.osgi_3.8.0.v20120529-1548.jar

java.home C:\Program Files (x86)\Java\jdk1.7.0_51\jre

ide.pref.dir C:\Users\hmyuser\AppData\Roaming\SQL Developer

oracle.xdkjava.compatibility.version 9.0.4

org.osgi.framework.bootdelegation *

ide.launcherProcessId 7100

ide.work.dir.base C:\Users\hmyuser\Documents

java.endorsed.dirs C:\Program Files (x86)\Java\jdk1.7.0_51\jre\lib\endorsed

ide.startingcwd C:\Users\hmyuser\Applications\sqldeveloper

osgi.bundlestore C:\Users\hmyuser\AppData\Roaming\SQL Developer\system4.0.0.13.80\system_cache\var\cache\netigso\org.eclipse.osgi\bundles

sun.java2d.noddraw true

ide.product oracle.sqldeveloper

sun.os.patch.level Service Pack 1

java.vendor.url http://java.oracle.com/

java.version 1.7.0_51

ide.build MAIN-13.80

oracle.ide.launcher.startup.time 1392147825375

oracle.jdbc.Trace true

ide.java.maxversion 1.8

osgi.os win32

osgi.compatibility.bootdelegation false

org.eclipse.equinox.simpleconfigurator.configUrl file:bundles.info

felix.log.level 4

org.osgi.framework.uuid d09b0dd2-5493-0013-1e5e-8726055048a6

org.openide.major.version IDE/1

java.vendor.url.bug http://bugreport.sun.com/bugreport/

netbeans.buildnumber 201310301439

oracle.jrf.home C:\Users\hmyuser\Applications\sqldeveloper

ide.user.dir C:\Users\hmyuser\AppData\Roaming\SQL Developer

user.name me.myuser

org.osgi.framework.version 1.7.0

sun.io.unicode.encoding UnicodeLittle

org.osgi.framework.system.packages javax.accessibility,javax.activation,javax.activity,javax.annotation,javax.annotation.processing,javax.crypto,javax.crypto.interfaces,javax.crypto.spec,javax.imageio,javax.imageio.event,javax.imageio.metadata,javax.imageio.plugins.bmp,javax.imageio.plugins.jpeg,javax.imageio.spi,javax.imageio.stream,javax.jws,javax.jws.soap,javax.lang.model,javax.lang.model.element,javax.lang.model.type,javax.lang.model.util,javax.management,javax.management.event,javax.management.loading,javax.management.modelmbean,javax.management.monitor,javax.management.namespace,javax.management.openmbean,javax.management.relation,javax.management.remote,javax.management.remote.rmi,javax.management.timer,javax.naming,javax.naming.directory,javax.naming.event,javax.naming.ldap,javax.naming.spi,javax.net,javax.net.ssl,javax.print,javax.print.attribute,javax.print.attribute.standard,javax.print.event,javax.rmi,javax.rmi.CORBA,javax.rmi.ssl,javax.script,javax.security.auth,javax.security.auth.callback,javax.security.auth.kerberos,javax.security.auth.login,javax.security.auth.spi,javax.security.auth.x500,javax.security.cert,javax.security.sasl,javax.sound.midi,javax.sound.midi.spi,javax.sound.sampled,javax.sound.sampled.spi,javax.sql,javax.sql.rowset,javax.sql.rowset.serial,javax.sql.rowset.spi,javax.swing,javax.swing.border,javax.swing.colorchooser,javax.swing.event,javax.swing.filechooser,javax.swing.plaf,javax.swing.plaf.basic,javax.swing.plaf.metal,javax.swing.plaf.multi,javax.swing.plaf.nimbus,javax.swing.plaf.synth,javax.swing.table,javax.swing.text,javax.swing.text.html,javax.swing.text.html.parser,javax.swing.text.rtf,javax.swing.tree,javax.swing.undo,javax.tools,javax.transaction,javax.transaction.xa,javax.xml,javax.xml.bind,javax.xml.bind.annotation,javax.xml.bind.annotation.adapters,javax.xml.bind.attachment,javax.xml.bind.helpers,javax.xml.bind.util,javax.xml.crypto,javax.xml.crypto.dom,javax.xml.crypto.dsig,javax.xml.crypto.dsig.dom,javax.xml.crypto.dsig.keyinfo,javax.xml.crypto.dsig.spec,javax.xml.datatype,javax.xml.namespace,javax.xml.parsers,javax.xml.soap,javax.xml.stream,javax.xml.stream.events,javax.xml.stream.util,javax.xml.transform,javax.xml.transform.dom,javax.xml.transform.sax,javax.xml.transform.stax,javax.xml.transform.stream,javax.xml.validation,javax.xml.ws,javax.xml.ws.handler,javax.xml.ws.handler.soap,javax.xml.ws.http,javax.xml.ws.soap,javax.xml.ws.spi,javax.xml.ws.spi.http,javax.xml.ws.wsaddressing,javax.xml.xpath,org.ietf.jgss,org.omg.CORBA,org.omg.CORBA_2_3,org.omg.CORBA_2_3.portable,org.omg.CORBA.DynAnyPackage,org.omg.CORBA.ORBPackage,org.omg.CORBA.portable,org.omg.CORBA.TypeCodePackage,org.omg.CosNaming,org.omg.CosNaming.NamingContextExtPackage,org.omg.CosNaming.NamingContextPackage,org.omg.Dynamic,org.omg.DynamicAny,org.omg.DynamicAny.DynAnyFactoryPackage,org.omg.DynamicAny.DynAnyPackage,org.omg.IOP,org.omg.IOP.CodecFactoryPackage,org.omg.IOP.CodecPackage,org.omg.Messaging,org.omg.PortableInterceptor,org.omg.PortableInterceptor.ORBInitInfoPackage,org.omg.PortableServer,org.omg.PortableServer.CurrentPackage,org.omg.PortableServer.POAManagerPackage,org.omg.PortableServer.POAPackage,org.omg.PortableServer.portable,org.omg.PortableServer.ServantLocatorPackage,org.omg.SendingContext,org.omg.stub.java.rmi,org.w3c.dom,org.w3c.dom.bootstrap,org.w3c.dom.css,org.w3c.dom.events,org.w3c.dom.html,org.w3c.dom.ls,org.w3c.dom.ranges,org.w3c.dom.stylesheets,org.w3c.dom.traversal,org.w3c.dom.views,org.w3c.dom.xpath,org.xml.sax,org.xml.sax.ext,org.xml.sax.helpers

ide.bundle.search.path C:\Users\hmyuser\Applications\sqldeveloper\dropins

sun.jnu.encoding Cp1252

java.runtime.name Java(TM) SE Runtime Environment

ide.work.dir C:\Users\hmyuser\Documents\SQL Developer

oracle.ide.osgi.boot.api.OJStartupHook oracle.dbtools.raptor.startup.HomeSupport

ide.conf C:\Users\hmyuser\Applications\sqldeveloper\sqldeveloper\bin\sqldeveloper.conf

jdk.home C:\Program Files (x86)\Java\jdk1.7.0_51\jre\..

private.jdev.load.remote.schemas false

osgi.instance.area.default file:/C:/Users/hmyuser/AppData/Roaming/SQL Developer/system4.0.0.13.80/system_cache/

ide.bootstrap.start 24426763663938

netbeans.dirs C:\Users\hmyuser\Applications\sqldeveloper\netbeans\fcpbridge;C:\Users\hmyuser\Applications\sqldeveloper\netbeans\ide;C:\Users\hmyuser\Applications\sqldeveloper;C:\Users\hmyuser\Applications\sqldeveloper\dropins

java.specification.name Java Platform API Specification

sun.awt.datatransfer.timeout 1000

org.osgi.supports.framework.fragment true

osgi.framework.useSystemProperties true

oracle.translated.locales de,es,fr,it,ja,ko,pt_BR,zh_CN,zh_TW

user.timezone

nb.native.filechooser false

org.osgi.framework.system.capabilities osgi.ee; osgi.ee="OSGi/Minimum"; version:List<Version>="1.0, 1.1, 1.2",osgi.ee; osgi.ee="JRE"; version:List<Version>="1.0, 1.1",osgi.ee; osgi.ee="JavaSE"; version:List<Version>="1.0, 1.1, 1.2, 1.3, 1.4, 1.5, 1.6, 1.7"

osgi.nl en_US

org.openide.specification.version 6.2

user.script

path.separator ;

java.naming.factory.initial oracle.javatools.jndi.LocalInitialContextFactory

osgi.framework.activeThreadType normal

file.encoding Cp1252

osgi.arch x86

ice.browser.forcegc false

sun.java.command oracle.ide.osgi.boot.OracleIdeLauncher

tool.user.conf C:\Users\hmyuser\AppData\Roaming\sqldeveloper\1.0.0.0.0\sqldeveloper.conf

org.osgi.supports.framework.requirebundle true

oracle.jdbc.mapDateToTimestamp false

osgi.classloader.type parallel

osgi.bundles.defaultStartLevel 1

osgi.bundles file:/Users/hmyuser/Applications/sqldeveloper/ide/ide/lib/oracle.ide.osgi.jar@3:start

java.io.tmpdir C:\Users\hmyuser\AppData\Local\Temp\

org.osgi.framework.os.name Windows7

ice.pilots.html4.tileOptThreshold 0

user.language en

javax.xml.stream.XMLInputFactory com.ctc.wstx.stax.WstxInputFactory

line.separator \r\n

sqldev.debug false

ice.pilots.html4.ignoreNonGenericFonts true

eclipse.parsers.setTCCL false

org.osgi.framework.processor x86

oracle.ide.extension.HooksProcessingMode LAZY

java.vm.info mixed mode

osgi.manifest.cache C:\Users\hmyuser\AppData\Roaming\SQL Developer\system4.0.0.13.80\system_cache\var\cache\netigso\org.eclipse.osgi\manifests

sun.desktop windows

java.vm.specification.name Java Virtual Machine Specification

javax.xml.stream.util.XMLEventAllocator oracle.ideimpl.xml.stream.XMLEventAllocatorImpl

netbeans.dynamic.classpath C:\Users\hmyuser\Applications\sqldeveloper\netbeans\platform\core\core.jar;C:\Users\hmyuser\Applications\sqldeveloper\netbeans\platform\core\org-openide-filesystems.jar;C:\Users\hmyuser\Applications\sqldeveloper\netbeans\platform\core\locale\core_de.jar;C:\Users\hmyuser\Applications\sqldeveloper\netbeans\platform\core\locale\core_es.jar;C:\Users\hmyuser\Applications\sqldeveloper\netbeans\platform\core\locale\core_fr.jar;C:\Users\hmyuser\Applications\sqldeveloper\netbeans\platform\core\locale\core_it.jar;C:\Users\hmyuser\Applications\sqldeveloper\netbeans\platform\core\locale\core_ja.jar;C:\Users\hmyuser\Applications\sqldeveloper\netbeans\platform\core\locale\core_ko.jar;C:\Users\hmyuser\Applications\sqldeveloper\netbeans\platform\core\locale\core_pt_BR.jar;C:\Users\hmyuser\Applications\sqldeveloper\netbeans\platform\core\locale\core_zh_CN.jar;C:\Users\hmyuser\Applications\sqldeveloper\netbeans\platform\core\locale\core_zh_TW.jar;C:\Users\hmyuser\Applications\sqldeveloper\netbeans\platform\core\locale\org-openide-filesystems_de.jar;C:\Users\hmyuser\Applications\sqldeveloper\netbeans\platform\core\locale\org-openide-filesystems_es.jar;C:\Users\hmyuser\Applications\sqldeveloper\netbeans\platform\core\locale\org-openide-filesystems_fr.jar;C:\Users\hmyuser\Applications\sqldeveloper\netbeans\platform\core\locale\org-openide-filesystems_it.jar;C:\Users\hmyuser\Applications\sqldeveloper\netbeans\platform\core\locale\org-openide-filesystems_ja.jar;C:\Users\hmyuser\Applications\sqldeveloper\netbeans\platform\core\locale\org-openide-filesystems_ko.jar;C:\Users\hmyuser\Applications\sqldeveloper\netbeans\platform\core\locale\org-openide-filesystems_pt_BR.jar;C:\Users\hmyuser\Applications\sqldeveloper\netbeans\platform\core\locale\org-openide-filesystems_zh_CN.jar;C:\Users\hmyuser\Applications\sqldeveloper\netbeans\platform\core\locale\org-openide-filesystems_zh_TW.jar;C:\Users\hmyuser\Applications\sqldeveloper\netbeans\fcpbridge\core\org-netbeans-core-dynamicconfig.jar;C:\Users\hmyuser\Applications\sqldeveloper\netbeans\fcpbridge\core\locale\core_jdev.jar

jdbc.library C:\Users\hmyuser\Applications\sqldeveloper\jdbc\lib\ojdbc6.jar

excluded.modules org.eclipse.osgi

ide.boot.class.path C:\Users\hmyuser\Applications\sqldeveloper\ide\macros/../../ide/lib/javax-ide.jar,file:../../ide/lib/javatools.jar,file:../../modules/oracle.javatools_12.1.3/javatools-nodeps.jar,file:../../modules/oracle.javatools_12.1.3/javatools-jndi-local.jar,file:../../ide/extensions/oracle.ide.jar,file:../../ide/lib/idert.jar,file:../../modules/oracle.javatools_12.1.3/oicons.jar,file:../../ide/lib/uic.jar,file:../../ide/lib/audit-boot.jar,file:../../ide/lib/indexing-migrator-boot.jar,file:../../jlib/jewt4.jar,file:../../modules/oracle.bali.share_12.1.3/share.jar,file:../../jlib/help4.jar,file:../../jlib/inspect4.jar,file:../../modules/oracle.xdk_12.1.2/xmlparserv2.jar

osgi.configuration.area file:/C:/Users/hmyuser/AppData/Roaming/SQL Developer/system4.0.0.13.80/system_cache/var/cache/netigso/

sun.java2d.ddoffscreen false

java.awt.printerjob sun.awt.windows.WPrinterJob

ide.cluster.dirs /Users/hmyuser/Applications/sqldeveloper/netbeans/fcpbridge/:/Users/hmyuser/Applications/sqldeveloper/netbeans/ide/:/Users/hmyuser/Applications/sqldeveloper/netbeans/../

oracle.jdbc.useFetchSizeWithLongColumn true

netbeans.home C:\Users\hmyuser\Applications\sqldeveloper\netbeans\platform

org.osgi.framework.storage file:/C:/Users/hmyuser/AppData/Roaming/SQL Developer/system4.0.0.13.80/system_cache/var/cache/netigso

ide.shell.enableFileTypeAssociation C:\Users\hmyuser\Applications\sqldeveloper\sqldeveloper.exe

osgi.ws win32

javax.xml.transform.TransformerFactory oracle.ide.xml.switchable.SwitchableTransformerFactory

org.osgi.supports.framework.extension true

oracle.jdbc.autoCommitSpecCompliant false

gosh.args --nointeractive

osgi.parentClassloader app

org.osgi.framework.language en

os.name Windows 7

eclipse.home.location file:/C:/Users/hmyuser/Applications/sqldeveloper/

java.specification.vendor Oracle Corporation

java.vm.name Java HotSpot(TM) Client VM

org.openide.version deprecated

ide.AssertTracingDisabled true

sun.awt.enableExtraMouseButtons true

java.library.path C:\Users\hmyuser\Applications\sqldeveloper;C:\Windows\Sun\Java\bin;C:\Windows\system32;C:\Windows;C:\oraclexe\app\oracle\product\11.2.0\server\bin;;C:\Windows\system32;C:\Windows;C:\Windows\System32\Wbem;C:\Windows\System32\WindowsPowerShell\v1.0\;C:\Program Files (x86)\Intel\OpenCL SDK\2.0\bin\x86;C:\Program Files (x86)\Intel\OpenCL SDK\2.0\bin\x64;C:\Program Files\ActivIdentity\ActivClient\;C:\Program Files (x86)\ActivIdentity\ActivClient\;C:\Program Files (x86)\Tumbleweed\Desktop Validator\;C:\Program Files\Intel\WiFi\bin\;C:\Program Files\Common Files\Intel\WirelessCommon\;C:\Users\hmyuser\Applications\instantclient-basic-windows.x64-11.2.0.3.0\instantclient_11_2;C:\oraclexe\ODAC;;.

ide.cfu.class.path C:\Users\hmyuser\Applications\sqldeveloper\ide\macros/../../modules/oracle.bali.share_12.1.3/share.jar,file:../../jlib/jewt4.jar,file:../../modules/oracle.xdk_12.1.2/xmlparserv2.jar,file:../../ide/lib/javatools.jar,file:../../modules/oracle.javatools_12.1.3/javatools-nodeps.jar,file:../../ide/lib/idert.jar,file:../../ide/extensions/oracle.ide.jar,file:../../ide/extensions/oracle.ide.webupdate.jar

java.class.version 51.0

user.conf C:\Users\hmyuser\AppData\Roaming\sqldeveloper\1.0.0.0.0\product.conf

ide.extension.search.path sqldeveloper/extensions:jdev/extensions:ide/extensions

ide.config_pathname C:\Users\hmyuser\Applications\sqldeveloper\sqldeveloper\bin\sqldeveloper.conf

oracle.ide.reportEDTViolations.exceptionsfile /Users/hmyuser/Applications/sqldeveloper/ide/bin/swing-thread-violations.conf

ide.system.dir C:\Users\hmyuser\AppData\Roaming\SQL Developer\system4.0.0.13.80\

java.util.logging.config.file logging.conf

osgi.instance.area file:/C:/Users/hmyuser/AppData/Roaming/SQL Developer/system4.0.0.13.80/system_cache/

osgi.install.area file:/C:/Users/hmyuser/Applications/sqldeveloper/

sun.boot.library.path C:\Program Files (x86)\Java\jdk1.7.0_51\jre\bin

sun.management.compiler HotSpot Client Compiler

netbeans.logger.console true

java.awt.graphicsenv sun.awt.Win32GraphicsEnvironment

user.variant

ide.pref.dir.base C:\Users\hmyuser\AppData\Roaming

ide.splash.screen splash.gif

InstanceDataObject.current.file

ide.update.usage.servers http://www.oracle.com/webfolder/technetwork/sqldeveloper/usage.xml

osgi.user.area file:/C:/Users/hmyuser/AppData/Roaming/SQL Developer/system4.0.0.13.80/system_cache/

ide.debugbuild false

java.vm.specification.version 1.7

osgi.noShutdown true

awt.toolkit sun.awt.windows.WToolkit

orai18n.library.dir C:\Users\hmyuser\Applications\sqldeveloper\jlib

xdb.library C:\Users\hmyuser\Applications\sqldeveloper\rdbms\jlib\xdb6.jar

sun.cpu.isalist pentium_pro+mmx pentium_pro pentium+mmx pentium i486 i386 i86

ide.java.minversion 1.7

java.ext.dirs C:\Program Files (x86)\Java\jdk1.7.0_51\jre\lib\ext;C:\Windows\Sun\Java\lib\ext

os.version 6.1

osgi.framework.version 3.8.0.v20120529-1548

user.home C:\Users\hmyuser

org.xml.sax.driver oracle.xml.parser.v2.SAXParser

ide.mw.relative.home .

java.vm.vendor Oracle Corporation

javax.xml.parsers.DocumentBuilderFactory oracle.xml.jaxp.JXDocumentBuilderFactory

ide.user.dir.var IDE_USER_DIR

osgi.hook.configurators.include org.netbeans.modules.netbinox.NetbinoxHooks

ide.startingArg0 C:\Users\hmyuser\Applications\sqldeveloper\sqldeveloper.exe

user.dir C:\Users\hmyuser\Applications\sqldeveloper\sqldeveloper\bin

org.osgi.framework.os.version 6.1.0

ide.RectangularSplashScreen true

osgi.user.area.default file:/C:/Users/hmyuser/AppData/Roaming/SQL Developer/system4.0.0.13.80/system_cache/

sun.cpu.endian little

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$

osgi.support.multipleHosts true

ORACLE_HOME C:\Users\hmyuser\Applications

java.vm.version 24.51-b03

oracle.home C:\Users\hmyuser\Applications\sqldeveloper

java.class.path C:\Users\hmyuser\Applications\sqldeveloper\ide\lib\ide-boot.jar;C:\Users\hmyuser\Applications\sqldeveloper\netbeans\platform\lib\boot.jar;C:\Users\hmyuser\Applications\sqldeveloper\netbeans\platform\lib\org-openide-util.jar;C:\Users\hmyuser\Applications\sqldeveloper\netbeans\platform\lib\org-openide-util-lookup.jar;C:\Users\hmyuser\Applications\sqldeveloper\netbeans\platform\lib\org-openide-modules.jar;C:\Users\hmyuser\Applications\sqldeveloper\ide\lib\fcpboot.jar;C:\Users\hmyuser\Applications\sqldeveloper\ide\lib\xml-factory.jar;C:\Users\hmyuser\Applications\sqldeveloper\ide\lib\woodstox-core-asl-4.2.0.jar;C:\Users\hmyuser\Applications\sqldeveloper\ide\lib\stax2-api-3.1.1.jar;C:\Users\hmyuser\Applications\sqldeveloper\sqldeveloper\lib\oracle.sqldeveloper.homesupport.jar

oracle.fcp.home C:\Users\hmyuser\Applications\sqldeveloper

javax.xml.parsers.SAXParserFactory oracle.xml.jaxp.JXSAXParserFactory

os.arch x86

oracle.ide.reportEDTViolations bug

ide.devbuild false

netbeans.user C:\Users\hmyuser\AppData\Roaming\SQL Developer\system4.0.0.13.80\system_cache

windows.shell.font.languages

org.osgi.framework.vendor Eclipse

ide.diagnostics.dir C:\Users\hmyuser\AppData\Roaming\SQL Developer\system4.0.0.13.80\.diagnostics\

java.vm.specification.vendor Oracle Corporation

file.separator \

java.runtime.version 1.7.0_51-b13

sun.boot.class.path /Users/hmyuser/Applications/sqldeveloper/rdbms/jlib/ojdi.jar;C:\Program Files (x86)\Java\jdk1.7.0_51\jre\lib\resources.jar;C:\Program Files (x86)\Java\jdk1.7.0_51\jre\lib\rt.jar;C:\Program Files (x86)\Java\jdk1.7.0_51\jre\lib\sunrsasign.jar;C:\Program Files (x86)\Java\jdk1.7.0_51\jre\lib\jsse.jar;C:\Program Files (x86)\Java\jdk1.7.0_51\jre\lib\jce.jar;C:\Program Files (x86)\Java\jdk1.7.0_51\jre\lib\charsets.jar;C:\Program Files (x86)\Java\jdk1.7.0_51\jre\lib\jfr.jar;C:\Program Files (x86)\Java\jdk1.7.0_51\jre\classes;C:\Program Files (x86)\Java\jdk1.7.0_51\lib\tools.jar;C:\Program Files (x86)\Java\jdk1.7.0_51\lib\dt.jar

user.country US

osgi.configuration.cascaded false

oracle.ide.startup.features sqldeveloper

osgi.logfile C:\Users\hmyuser\AppData\Roaming\SQL Developer\system4.0.0.13.80\system_cache\var\cache\netigso\1392147826168.log

sqldeveloper.oci.available false

jdeveloper.system_http_proxy DIRECT

osgi.framework.properties C:\Users\hmyuser\AppData\Roaming\SQL Developer\system4.0.0.13.80\system_cache

java.vendor Oracle Corporation

oracle.ide.util.AddinPolicyUtils.OVERRIDE_FLAG true

osgi.bundlefile.limit 500

ide.feedback-server ide.us.oracle.com

oracle.ide.classload.layer osgi

osgi.locking none

java.specification.version 1.7

oracle.product.home C:\Users\hmyuser\Applications\sqldeveloper

sun.arch.data.model 32

java.memory.heap.init 134217728

java.memory.heap.max 810942464

java.memory.heap.used 60561024

java.memory.nonheap.init 12746752

java.memory.nonheap.max 301989888

java.memory.nonheap.used 50718368

Extensions

----------

Name Identifier Version Status Registration Time Initialization Time Total Time

==== ========== ======= ====== ================= =================== ==========

Integrated Development Environment (IDE) Platform Core oracle.ide 12.1.3.0.41.131202.1730 Fully Loaded 66ms 181ms 247ms

Peek oracle.ideimpl.peek 12.1.3.0.41.131202.1730 Fully Loaded 2ms 27ms 29ms

Code Editor oracle.ide.ceditor 12.1.3.0.41.131202.1730 Fully Loaded 9ms 37ms 46ms

Persistent Storage oracle.ide.persistence 12.1.3.0.41.131202.1730 Fully Loaded 0ms 2ms 2ms

File Change Monitor oracle.ide.file 12.1.3.0.41.131202.1730 Fully Loaded 0ms 3ms 3ms

Web Browser and Proxy oracle.ide.webbrowser 12.1.3.0.41.131202.1730 Fully Loaded 0ms 9ms 9ms

Indexing Service oracle.ide.indexing 12.1.3.0.41.131202.1730 Fully Loaded 0ms 1ms 1ms

Property Inspector oracle.ide.inspector 12.1.3.0.41.131202.1730 Fully Loaded 4ms 8ms 12ms

Markers oracle.ide.markers 12.1.3.0.41.131202.1730 Fully Loaded 0ms 0ms 0ms

Audit Core Framework oracle.ide.audit 12.1.3.0.41.131202.1730 Fully Loaded 1ms 5ms 6ms

Status and Background Audit oracle.ide.status 12.1.3.0.41.131202.1730 Fully Loaded 1ms 2ms 3ms

IDE macros oracle.ide.macros 12.1.3.0.41.131202.1730 Fully Loaded 0ms 0ms 0ms

Libraries oracle.ide.library 12.1.3.0.41.131202.1730 Fully Loaded 14ms 8ms 22ms

Virtual File System oracle.ide.vfs 12.1.3.0.41.131202.1730 Fully Loaded 0ms 1ms 1ms

Navigator oracle.ide.navigator 12.1.3.0.41.131202.1730 Fully Loaded 1ms 4ms 5ms

Runner oracle.ide.runner 12.1.3.0.41.131202.1730 Fully Loaded 2ms 3ms 5ms

External Tools oracle.ide.externaltools 12.1.3.0.41.131202.1730 Fully Loaded 1ms 1ms 2ms

File Support oracle.ide.files 12.1.3.0.41.131202.1730 Fully Loaded 0ms 0ms 0ms

Palette 2 oracle.ide.palette2 12.1.3.0.41.131202.1730 Fully Loaded 2ms 0ms 2ms

Insight oracle.ide.insight 12.1.3.0.41.131202.1730 Fully Loaded 2ms 2ms 4ms

Object Gallery oracle.ide.gallery 12.1.3.0.41.131202.1730 Fully Loaded 6ms 2ms 8ms

Import/Export Support oracle.ide.importexport 12.1.3.0.41.131202.1730 Fully Loaded 1ms 0ms 1ms

Technology oracle.jdeveloper.technology 12.1.3.0.41.131202.1730 Fully Loaded 5ms 1ms 6ms

Extended IDE Platform oracle.jdeveloper.common 12.1.3.0.41.131202.1730 Fully Loaded 7ms 12ms 19ms

JDeveloper Runner Core oracle.jdeveloper.runner.core 12.1.3.0.41.131202.1730 Fully Loaded 0ms 12ms 12ms

JavaCore oracle.jdeveloper.java.core 12.1.3.0.41.131202.1730 Fully Loaded 6ms 15ms 21ms

JDeveloper Runner oracle.jdeveloper.runner 12.1.3.0.41.131202.1730 Fully Loaded 4ms 72ms 76ms

Code Editor Save Actions oracle.ide.ceditor-saveactions 12.1.3.0.41.131202.1730 Fully Loaded 1ms 1ms 2ms

Oracle Deployment Core Module oracle.deploy.core 12.1.3.0.41.131202.1730 Fully Loaded 1ms 9ms 10ms

Make and Rebuild oracle.jdeveloper.build 12.1.3.0.41.131202.1730 Fully Loaded 32ms 4ms 36ms

PL/SQL Probe Debugger oracle.jdeveloper.db.debug.probe 12.1.3.0.41.131202.1730 Fully Loaded 0ms 0ms 0ms

Database UI oracle.ide.db 12.1.3.0.41.131202.1730 Fully Loaded 11ms 124ms 135ms

Database Connections oracle.jdeveloper.db.connection 12.1.3.0.41.131202.1730 Fully Loaded 2ms 13ms 15ms

Database Object Explorers oracle.ide.db.explorer 12.1.3.0.41.131202.1730 Fully Loaded 0ms 8ms 8ms

Compare API oracle.ide.compareapi 12.1.3.0.41.131202.1730 Fully Loaded 1ms 0ms 1ms

Help System oracle.ide.help 12.1.3.0.41.131202.1730 Fully Loaded 5ms 3ms 8ms

Local History oracle.ide.localhistory 12.1.3.0.41.131202.1730 Fully Loaded 0ms 79ms 79ms

History Support oracle.jdeveloper.history 12.1.3.0.41.131202.1730 Fully Loaded 4ms 13ms 17ms

Check For Updates oracle.ide.webupdate 12.1.3.0.41.131202.1730 Fully Loaded 1ms 1ms 2ms

Core Database Development oracle.sqldeveloper 12.2.0.13.80 Fully Loaded 20ms 422ms 442ms

SQL Worksheet oracle.sqldeveloper.worksheet 12.2.0.13.80 Fully Loaded 6ms 16ms 22ms

Database Reports oracle.sqldeveloper.report 12.2.0.13.80 Fully Loaded 2ms 8ms 10ms

Oracle SQL Developer - DBA Navigator oracle.sqldeveloper.dbanavigator 12.2.0.13.80 Fully Loaded 2ms 81ms 83ms

Oracle SQL Developer - Scheduler oracle.sqldeveloper.scheduler 12.2.0.13.80 Fully Loaded 0ms 98ms 98ms

Oracle SQL Developer - Migrations T-SQL Translator oracle.sqldeveloper.migration.translation.core 12.2.0.13.80 Fully Loaded 0ms 0ms 0ms

Oracle SQL Developer - Extras oracle.sqldeveloper.extras 12.2.0.13.80 Fully Loaded 1ms 38ms 39ms

Third Party Database Development oracle.sqldeveloper.thirdparty.browsers 12.2.0.13.80 Fully Loaded 0ms 6ms 6ms

Oracle SQL Developer - Migrations Core oracle.sqldeveloper.migration 12.2.0.13.80 Fully Loaded 5ms 68ms 73ms

Oracle SQL Developer - Migrations Microsoft SQL Server oracle.sqldeveloper.migration.sqlserver 12.2.0.13.80 Triggers Loaded 0ms 0ms 0ms

Oracle SQL Developer - Migrations Sybase Adaptive Server oracle.sqldeveloper.migration.sybase 12.2.0.13.80 Triggers Loaded 0ms 0ms 0ms

Oracle SQL Developer - File Navigator oracle.sqldeveloper.filenavigator 12.2.0.13.80 Triggers Loaded 3ms 0ms 3ms

Database Snippets oracle.sqldeveloper.snippet 12.2.0.13.80 Fully Loaded 0ms 5ms 5ms

Oracle SQL Developer - Spatial oracle.sqldeveloper.spatial 12.2.0.13.80 Triggers Loaded 2ms 0ms 2ms

Oracle SQL Developer - Real Time SQL Monitoring oracle.sqldeveloper.sqlmonitor 12.2.0.13.80 Triggers Loaded 2ms 0ms 2ms

Code Editor Find oracle.ide.ceditor-find 12.1.3.0.41.131202.1730 Fully Loaded 1ms 0ms 1ms

JViews Registration Addin oracle.diagram.registration 12.1.3.0.41.131202.1730 Triggers Loaded 0ms 0ms 0ms

BM Share oracle.bm.jdukshare 12.1.3.0.41.131202.1730 Triggers Loaded 0ms 0ms 0ms

MOF XMI oracle.mof.xmi 12.1.3.0.41.131202.1730 Triggers Loaded 0ms 0ms 0ms

IDE Thumbnail oracle.ide.thumbnail 12.1.3.0.41.131202.1730 Triggers Loaded 0ms 0ms 0ms

Diagram Framework oracle.diagram 12.1.3.0.41.131202.1730 Triggers Loaded 1ms 0ms 1ms

Protocol Handler Classpath oracle.jdeveloper.classpath 12.1.3.0.41.131202.1730 Fully Loaded 0ms 0ms 0ms

Oracle SQL Developer - Migrations PostgreSQL oracle.sqldeveloper.migration.postgresql 12.2.0.13.80 Triggers Loaded 0ms 0ms 0ms

Dependency Tracking oracle.ide.dependency 12.1.3.0.41.131202.1730 Fully Loaded 0ms 0ms 0ms

Print System oracle.ide.print 12.1.3.0.41.131202.1730 Triggers Loaded 1ms 0ms 1ms

Versioning Support oracle.ide.vcscore 12.1.3.0.41.131202.1730 Triggers Loaded 1ms 0ms 1ms

Database XML Schema oracle.sqldeveloper.xmlschema 12.2.0.13.80 Triggers Loaded 0ms 0ms 0ms

Database UI Extras oracle.jdeveloper.db.extras 12.1.3.0.41.131202.1730 Triggers Loaded 0ms 0ms 0ms

Patch Support oracle.jdeveloper.patch 12.1.3.0.41.131202.1730 Triggers Loaded 2ms 0ms 2ms

Replace With oracle.ide.replace 12.1.3.0.41.131202.1730 Triggers Loaded 1ms 0ms 1ms

VHV oracle.ide.vhv 12.1.3.0.41.131202.1730 Triggers Loaded 0ms 0ms 0ms

QuickDiff oracle.ide.quickdiff 12.1.3.0.41.131202.1730 Triggers Loaded 0ms 0ms 0ms

Versioning Support oracle.jdeveloper.vcs 12.1.3.0.41.131202.1730 Triggers Loaded 1ms 0ms 1ms

Versioning Support for Subversion oracle.jdeveloper.subversion 12.1.3.0.41.131202.1730 Triggers Loaded 4ms 0ms 4ms

Code Style oracle.jdeveloper.style 12.1.3.0.41.131202.1730 Fully Loaded 2ms 6ms 8ms

Oracle SQL Developer - Migrations Application Migration oracle.sqldeveloper.migration.application 12.2.0.13.80 Triggers Loaded 1ms 0ms 1ms

Usage Tracking oracle.ide.usages-tracking 12.1.3.0.41.131202.1730 Fully Loaded 0ms 1ms 1ms

Bookmarks oracle.ide.bookmarks 12.1.3.0.41.131202.1730 Fully Loaded 3ms 3ms 6ms

Code Editor Bookmarks oracle.ide.ceditor-bookmarks 12.1.3.0.41.131202.1730 Fully Loaded 0ms 4ms 4ms

TimesTen Integration oracle.ide.db.timesten 12.1.3.0.41.131202.1730 Fully Loaded 0ms 0ms 0ms

Oracle SQL Developer - Migrations MySQL oracle.sqldeveloper.migration.mysql 12.2.0.13.80 Fully Loaded 0ms 41ms 41ms

Code Editor Tint oracle.ide.ceditor-tint 12.1.3.0.41.131202.1730 Fully Loaded 1ms 0ms 1ms

ToDo Tasks Markers oracle.jdeveloper.markers.todo 12.1.3.0.41.131202.1730 Fully Loaded 1ms 0ms 1ms

XML Editing Framework oracle.ide.xmlef 12.1.3.0.41.131202.1730 Fully Loaded 7ms 41ms 48ms

Oracle SQL Developer - Migrations Teradata oracle.sqldeveloper.migration.teradata 12.2.0.13.80 Triggers Loaded 0ms 0ms 0ms

Oracle SQL Developer - Change Mangement oracle.sqldeveloper.em_cm 12.2.0.13.80 Triggers Loaded 1ms 0ms 1ms

Oracle SQL Developer - Migrations DB2 oracle.sqldeveloper.migration.db2 12.2.0.13.80 Fully Loaded 0ms 9ms 9ms

Oracle SQL Developer - Migrations MySQL SQL Translator oracle.sqldeveloper.migration.translation.mysql_translator 12.2.0.13.80 Triggers Loaded 0ms 0ms 0ms

Oracle SQL Developer - Unit Test oracle.sqldeveloper.unit_test 12.2.0.13.80 Triggers Loaded 2ms 0ms 2ms

Data Miner oracle.dmt.dataminer 12.2.0.13.80 Triggers Loaded 7ms 0ms 7ms

(Name Unavailable) oracle.sqldeveloper.tuning 12.2.0.13.80 Triggers Loaded 1ms 0ms 1ms

Oracle SQL Developer - Migrations DB2 Translator oracle.sqldeveloper.migration.translation.db2 12.2.0.13.80 Triggers Loaded 0ms 0ms 0ms

Oracle SQL Developer - Migrations Microsoft Access oracle.sqldeveloper.migration.msaccess 12.2.0.13.80 Triggers Loaded 0ms 0ms 0ms

Oracle SQL Developer - Migrations Translation UI oracle.sqldeveloper.migration.translation.gui 12.2.0.13.80 Triggers Loaded 1ms 0ms 1ms

Component Palette oracle.ide.palette1 12.1.3.0.41.131202.1730 Fully Loaded 77ms 0ms 77ms

Oracle SQL Developer Data Modeler - Reports oracle.sqldeveloper.datamodeler_reports 12.2.0.13.80 Fully Loaded 0ms 0ms 0ms

Oracle SQL Developer - TimesTen oracle.sqldeveloper.timesten 12.2.0.13.80 Fully Loaded 1ms 44ms 45ms

Oracle SQL Developer - Security oracle.sqldeveloper.security 12.2.0.13.80 Triggers Loaded 0ms 0ms 0ms

Log Window oracle.ide.log 12.1.3.0.41.131202.1730 Fully Loaded 1ms 0ms 1ms

Help Oracle Start Page oracle.ide.helpstartpage 12.1.3.0.41.131202.1730 Fully Loaded 2ms 0ms 2ms

Oracle SQL Developer - RESTful Services Administration oracle.sqldeveloper.rest 12.2.0.13.80 Triggers Loaded 2ms 0ms 2ms

Mac OS X Adapter oracle.ideimpl.apple 12.1.3.0.41.131202.1730 Fully Loaded 0ms 0ms 0ms

Oracle SQL Developer - Schema Browser oracle.sqldeveloper.schemabrowser 12.2.0.13.80 Triggers Loaded 1ms 0ms 1ms

Versioning Support for Git oracle.jdeveloper.git 12.1.3.0.41.131202.1730 Triggers Loaded 4ms 0ms 4ms

Oracle SQL Developer - Migrations Teradata SQL Translator oracle.sqldeveloper.migration.translation.teradata 12.2.0.13.80 Triggers Loaded 0ms 0ms 0ms

Oracle SQL Developer - APEX Listener Administration oracle.sqldeveloper.listener 12.2.0.13.80 Triggers Loaded 2ms 0ms 2ms

Oracle SQL Developer Data Modeler oracle.datamodeler 4.0.0.833 Triggers Loaded 19ms 0ms 19ms

OLAP oracle.olap 12.2.0.13.80 Fully Loaded 7ms 324ms 331ms

Searchbar oracle.ide.searchbar 12.1.3.0.41.131202.1730 Fully Loaded 1ms 0ms 1ms

Oracle SQL Developer - Database Cart oracle.sqldeveloper.dbcart 12.2.0.13.80 Triggers Loaded 0ms 0ms 0ms

)

1. Re: SQLDeveloper Microsoft Access 2007 db Migration to Oracle failure

Gary Graham-Oracle Feb 11, 2014 11:18 PM (in response to user5239736)

Please read the reply on the following recently updated discussion: Migrating MS Access to Oracle 11gR2
It seems that SQL Developer 3.2 with JDK 1.6 may be your best alternative for now.

The bugs logged in this area during the SQL Developer 4.0 development cycle are generally marked as "Closed, not feasible to fix" and at least two have comments to the effect that:

odbc-jdbc has been removed from JDK7

We are in talks with Java team to source alternatives

Unsure if any progress has been made with respect to sourcing an alternative.

Regards,
Gary
SQL Developer Team

P.S.: Not sure if the following is the latest word on this or out-of-date: JDBC-ODBC Bridge

Message was edited by: Gary Graham
Like Show 0 Likes(0)

Actions