I'm not a sybase person... more of a sqlserver, mysql, oracle, postgres dba. Ive got a set of files from a friends (non-dba) Sybase 9 system that I'd like to import/restore locally: gfi.db gfi.log gfi_ndx1.db gfi_ndx2.db gfi_trn1.db gfi_trn2.db syscon.db Question: I've installed Sybase SQL Anywhere 10 with the 'demo10' database and now apparently have a running database server (although trial version) and a sample database to which i can connect. I'd like to import/restore the database files I've received into my server to analyze the db schema/tables/etc and do some analysis. I've tried this with the "Restore Database" wizard but get the following error:
It seems to be looking for a db.1 file that doesn't exist?? Any advise? Thanks in advance! |
SQL Anywhere files ending with .db and .log are the actual database and transaction log files, respectively. Think of these as image copies rather than backups; hence there is no backup to be "restored" so using the Restore Database wizard will be unhelpful. First, make copies of everything you have. Put them in a different directory. From the naming convention of the files, I might guess that you have a couple of databases that have additional dbspaces (roughly what DB2 calls tablespaces). Try starting the SQL Anywhere server with the database file called gfi.db, as follows:
and that database may start; or it might not, and the console window will say that the database needs recovery and it has to apply the transaction log and cannot find it. If all the files are in the same directory, this shouldn't happen unless a hard-coded directory name was used in configuring the database files. That can be a seperate question. |
UGH... so i uninstalled 10, managed to find 9.0.2 online and installed it. Started the db up using the same command you suggested... but when I fire up 'interactive sql' it crashes and gives me the following: +-----------------+ | Stack Trace | +-----------------+ Current thread: AWT-EventQueue-0 java.lang.NullPointerException at javax.swing.border.EmptyBorder.<init>(Unknown Source) at com.sun.java.swing.plaf.windows.WindowsTableHeaderUI$XPDefaultRenderer.getTableCellRendererComponent(Unknown Source) at com.sybase.util.SybWindowsTableHeaderUI$XPRendererFix.getTableCellRendererComponent(SybWindowsTableHeaderUI.java) at com.sybase.asa.logon.BrowseDSNDialog.setInitialColumnWidths(BrowseDSNDialog.java:360) at com.sybase.asa.logon.BrowseDSNDialog.fillTable(BrowseDSNDialog.java:331) at com.sybase.asa.logon.BrowseDSNDialog.createUI(BrowseDSNDialog.java:102) at com.sybase.asa.logon.BrowseDSNDialog.create(BrowseDSNDialog.java:67) at com.sybase.asa.logon.ASADatabaseSource.handleBrowseDSN(asadatabasesource.java:1909) at com.sybase.asa.logon.ASADatabaseSource.actionPerformed(asadatabasesource.java:1819) at javax.swing.AbstractButton.fireActionPerformed(Unknown Source) at javax.swing.AbstractButton$ForwardActionEvents.actionPerformed(Unknown Source) at javax.swing.DefaultButtonModel.fireActionPerformed(Unknown Source) at javax.swing.DefaultButtonModel.setPressed(Unknown Source) at javax.swing.plaf.basic.BasicButtonListener.mouseReleased(Unknown Source) at java.awt.Component.processMouseEvent(Unknown Source) at java.awt.Component.processEvent(Unknown Source) at java.awt.Container.processEvent(Unknown Source) at java.awt.Component.dispatchEventImpl(Unknown Source) at java.awt.Container.dispatchEventImpl(Unknown Source) at java.awt.Component.dispatchEvent(Unknown Source) at java.awt.LightweightDispatcher.retargetMouseEvent(Unknown Source) at java.awt.LightweightDispatcher.processMouseEvent(Unknown Source) at java.awt.LightweightDispatcher.dispatchEvent(Unknown Source) at java.awt.Container.dispatchEventImpl(Unknown Source) at java.awt.Window.dispatchEventImpl(Unknown Source) at java.awt.Component.dispatchEvent(Unknown Source) at java.awt.EventQueue.dispatchEvent(Unknown Source) at java.awt.EventDispatchThread.pumpOneEventForHierarchy(Unknown Source) at java.awt.EventDispatchThread.pumpEventsForHierarchy(Unknown Source) at java.awt.EventDispatchThread.pumpEventsForHierarchy(Unknown Source) at java.awt.Dialog$1.run(Unknown Source) at java.awt.Dialog.show(Unknown Source) at java.awt.Component.show(Unknown Source) at java.awt.Component.setVisible(Unknown Source) at com.sybase.asa.logon.LogonDialogFactory.create(LogonDialogFactory.java:131) at com.sybase.asa.logon.LogonDialogFactory$1.run(LogonDialogFactory.java:141) at java.awt.event.InvocationEvent.dispatch(Unknown Source) at java.awt.EventQueue.dispatchEvent(Unknown Source) at java.awt.EventDispatchThread.pumpOneEventForHierarchy(Unknown Source) at java.awt.EventDispatchThread.pumpEventsForHierarchy(Unknown Source) at java.awt.EventDispatchThread.pumpEvents(Unknown Source) at java.awt.EventDispatchThread.pumpEvents(Unknown Source) at java.awt.EventDispatchThread.run(Unknown Source) +----------+ | ISQL | +----------+ Mon Feb 27 21:16:47 GMT 2012 ISQL version = 9.0.2, Build 2451 CommandLineOptions Full command line: -locale en ConnectionInfo: <jdbcdriver>=ianywhere.ml.jdbcodbc.IDriver Command tail: (none) Initial SQL statement: (none) Execute initial SQL statement: No Use GUI: Yes Quiet mode is: Off Syntax check mode is: Off Default database type: ASA No current database connection Currently executing statements: (none) Exception caught while getting parser state java.lang.NullPointerException at sybase.isql.ISQLExceptionHandlerClient.printApplicationInformation(ISQLExceptionHandlerClient.java:105) at com.sybase.util.ExceptionHandler.gatherInformation(ExceptionHandler.java) at com.sybase.util.ExceptionHandler.handle(ExceptionHandler.java) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) at java.lang.reflect.Method.invoke(Unknown Source) at java.awt.EventDispatchThread.handleException(Unknown Source) at java.awt.EventDispatchThread.processException(Unknown Source) at java.awt.EventDispatchThread.pumpOneEventForHierarchy(Unknown Source) at java.awt.EventDispatchThread.pumpEventsForHierarchy(Unknown Source) at java.awt.EventDispatchThread.pumpEventsForHierarchy(Unknown Source) at java.awt.Dialog$1.run(Unknown Source) at java.awt.Dialog.show(Unknown Source) at java.awt.Component.show(Unknown Source) at java.awt.Component.setVisible(Unknown Source) at com.sybase.asa.logon.LogonDialogFactory.create(LogonDialogFactory.java:131) at com.sybase.asa.logon.LogonDialogFactory$1.run(LogonDialogFactory.java:141) at java.awt.event.InvocationEvent.dispatch(Unknown Source) at java.awt.EventQueue.dispatchEvent(Unknown Source) at java.awt.EventDispatchThread.pumpOneEventForHierarchy(Unknown Source) at java.awt.EventDispatchThread.pumpEventsForHierarchy(Unknown Source) at java.awt.EventDispatchThread.pumpEvents(Unknown Source) at java.awt.EventDispatchThread.pumpEvents(Unknown Source) at java.awt.EventDispatchThread.run(Unknown Source) +---------------+ | Classpath | +---------------+ C:Program FilesSybaseSQL Anywhere 9javaisql.jar Timestamp=2004-10-20 01:54:54.0 Length=986359 C:Program FilesSybaseSharedjConnect-5_5classesjconn2.jar Timestamp=2001-08-10 17:40:52.0 Length=847267 C:Program FilesSybaseSQL Anywhere 9javajlogon.jar Timestamp=2004-10-20 01:51:20.0 Length=175027 C:Program FilesSybaseSQL Anywhere 9javajodbc.jar Timestamp=2004-10-19 22:45:20.0 Length=167269 C:Program FilesSybaseSharedjavaSCEditor142.jar Timestamp=2004-10-13 19:58:36.0 Length=344763 C:Program FilesSybaseSharedjavaJComponents142.jar Timestamp=2004-10-20 01:51:46.0 Length=820465 C:Program FilesSybaseSharedjavajsyblib142.jar Timestamp=2004-10-13 19:55:20.0 Length=264627 C:Program FilesSybaseSharedSunJavaHelp-1_1jh.jar Timestamp=2002-06-24 16:36:00.0 Length=347246 C:Program FilesSybaseSharedjavaHelpManager11.jar Timestamp=2004-10-13 19:56:12.0 Length=56457 C:Program FilesSybaseSQL Anywhere 9javaxerces.jar Timestamp=2004-09-10 18:36:48.0 Length=854256 C:Program FilesSybaseSQL Anywhere 9javaxml4j.jar Timestamp=2004-09-10 18:36:48.0 Length=10645 +-------------+ | Java VM | +-------------+ Total memory: 9465856 Free memory: 206896 System properties: asa.location=C:\PROGRA~1\Sybase\SQLANY~1\ awt.toolkit=sun.awt.windows.WToolkit file.encoding=Cp1252 file.encoding.pkg=sun.io file.separator=\ isql.commandShell="C:\Windows\system32\cmd.exe /c" isql.helpFolder=C:\PROGRA~1\Sybase\SQLANY~1\java java.awt.graphicsenv=sun.awt.Win32GraphicsEnvironment java.awt.printerjob=sun.awt.windows.WPrinterJob java.class.path=C:\PROGRA~1\Sybase\SQLANY~1\win32\..\java\isql.jar;C:\PROGRA~1\Sybase\Shared\JCONNE~1\classes\jconn2.jar;C:\PROGRA~1\Sybase\SQLANY~1\win32\..\java\jlogon.jar;C:\PROGRA~1\Sybase\SQLANY~1\win32\..\java\jodbc.jar;C:\PROGRA~1\Sybase\Shared\java\SCEDIT~1.JAR;C:\PROGRA~1\Sybase\Shared\java\JCOMPO~1.JAR;C:\PROGRA~1\Sybase\Shared\java\JSYBLI~1.JAR;C:\PROGRA~1\Sybase\Shared\sun\JAVAHE~1\jh.jar;C:\PROGRA~1\Sybase\Shared\java\HELPMA~1.JAR;C:\PROGRA~1\Sybase\SQLANY~1\win32\..\java\xerces.jar;C:\PROGRA~1\Sybase\SQLANY~1\win32\..\java\xml4j.jar; java.class.version=48.0 java.endorsed.dirs=C:\Program Files\Sybase\Shared\sun\jre142\lib\endorsed java.ext.dirs=C:\Program Files\Sybase\Shared\sun\jre142\lib\ext java.home=C:\Program Files\Sybase\Shared\sun\jre142 java.io.tmpdir=C:\Users\FITZGE~1.COU\AppData\Local\Temp\ java.library.path=C:\Program Files\Sybase\SQL Anywhere 9\win32;.;C:\Windows\system32;C:\Windows;C:\Windows\system32;C:\Windows;C:\Windows\System32\Wbem;C:\Windows\System32\WindowsPowerShell\v1.0\;c:\Program Files\Microsoft SQL Server\100\Tools\Binn\;c:\Program Files\Microsoft SQL Server\100\DTS\Binn\;C:\Program Files\IDM Computer Solutions\UltraEdit-32;C:\Program Files\GeoRover\License Manager;C:\Program Files\Sybase\SQL Anywhere 9\win32;C:\Program Files\Sybase\Shared\win32;C:\Program Files\Sybase\SQL Anywhere 9\drivers;C:\Program Files\Sybase\Shared\Sybase Central 4.3\win32;C:\Program Files\Nmap java.runtime.name=Java(TM) 2 Runtime Environment, Standard Edition java.runtime.version=1.4.2_02-b03 java.specification.name=Java Platform API Specification java.specification.vendor=Sun Microsystems Inc. java.specification.version=1.4 java.util.prefs.PreferencesFactory=java.util.prefs.WindowsPreferencesFactory 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.4.2_02 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=1.4.2_02-b03 line.separator= os.arch=x86 os.name=Windows NT (unknown) os.version=6.1 path=C:\PROGRA~1\Sybase\SQLANY~1\win32;C:\PROGRA~1\Sybase\Shared\sun\jre142\bin;C:\Windows\system32;C:\Windows;C:\Windows\System32\Wbem;C:\Windows\System32\WINDOW~1\v1.0\;c:\PROGRA~1\MICROS~1\100\Tools\Binn\;c:\PROGRA~1\MICROS~1\100\DTS\Binn\;C:\PROGRA~1\IDMCOM~1\ULTRAE~1;C:\PROGRA~1\GeoRover\LICENS~2;C:\PROGRA~1\Sybase\SQLANY~1\win32;C:\PROGRA~1\Sybase\Shared\win32;C:\PROGRA~1\Sybase\SQLANY~1\drivers;C:\PROGRA~1\Sybase\Shared\SYBASE~1.3\win32;C:\PROGRA~1\Nmap path.separator=; sqlpath= sun.arch.data.model=32 sun.awt.exception.handler=com.sybase.util.ExceptionHandler sun.boot.class.path=C:\Program Files\Sybase\Shared\sun\jre142\lib\rt.jar;C:\Program Files\Sybase\Shared\sun\jre142\lib\i18n.jar;C:\Program Files\Sybase\Shared\sun\jre142\lib\sunrsasign.jar;C:\Program Files\Sybase\Shared\sun\jre142\lib\jsse.jar;C:\Program Files\Sybase\Shared\sun\jre142\lib\jce.jar;C:\Program Files\Sybase\Shared\sun\jre142\lib\charsets.jar;C:\Program Files\Sybase\Shared\sun\jre142\classes sun.boot.library.path=C:\Program Files\Sybase\Shared\sun\jre142\bin sun.cpu.endian=little sun.cpu.isalist=pentium i486 i386 sun.io.unicode.encoding=UnicodeLittle sun.java2d.d3d=false sun.java2d.fontpath= sun.java2d.noddraw=true sun.os.patch.level=Service Pack 1 sybase.jsyblib.dll.location=C:\PROGRA~1\Sybase\Shared\win32\ user.country=US user.dir=C:\Windows\system32 user.home=C:\Users\fitzgeraldb.COUNTY user.language=en user.name=FITZGERALDB user.timezone=GMT user.variant= +-------------------+ | Java Packages | +-------------------+ Package: com.sun.java.swing Implementation title: Java Runtime Environment Implementation vendor: Sun Microsystems, Inc. Implementation version: 1.4.2_02 Specification title: Java Platform API Specification Specification vendor: Sun Microsystems, Inc. Specification version: 1.4 Package: com.sun.java.swing.plaf.windows Implementation title: Java Runtime Environment Implementation vendor: Sun Microsystems, Inc. Implementation version: 1.4.2_02 Specification title: Java Platform API Specification Specification vendor: Sun Microsystems, Inc. Specification version: 1.4 Package: com.sun.java.swing.plaf.windows.resources Implementation title: Java Runtime Environment Implementation vendor: Sun Microsystems, Inc. Implementation version: 1.4.2_02 Specification title: Java Platform API Specification Specification vendor: Sun Microsystems, Inc. Specification version: 1.4 Package: com.sun.swing.internal.plaf.basic.resources Implementation title: Java Runtime Environment Implementation vendor: Sun Microsystems, Inc. Implementation version: 1.4.2_02 Specification title: Java Platform API Specification Specification vendor: Sun Microsystems, Inc. Specification version: 1.4 Package: com.sybase.asa.QueryEditor Implementation title: JComponents Library Implementation vendor: Sybase, Inc. Implementation version: 142 Specification title: JComponents Library Specification vendor: Sybase, Inc. Specification version: 142 Package: com.sybase.asa.common Implementation title: JComponents Library Implementation vendor: Sybase, Inc. Implementation version: 142 Specification title: JComponents Library Specification vendor: Sybase, Inc. Specification version: 142 Package: com.sybase.asa.logon Implementation title: JDBC Connection Library Implementation vendor: Sybase, Inc. Implementation version: 9.0.2 Specification title: JDBC Connection Library Specification vendor: Sybase, Inc. Specification version: 9.0.2 Package: com.sybase.ase.logon Implementation title: JDBC Connection Library Implementation vendor: Sybase, Inc. Implementation version: 9.0.2 Specification title: JDBC Connection Library Specification vendor: Sybase, Inc. Specification version: 9.0.2 Package: com.sybase.central.editor Implementation title: Sybase Central Editor Implementation vendor: Sybase, Inc. Implementation version: 4.3.0.2197 Specification title: Sybase Central Editor Specification vendor: Sybase, Inc. Specification version: 4.3.0.2197 Package: com.sybase.customization Implementation title: Application-Independent Java Utility Library Implementation vendor: Sybase, Inc. Implementation version: null Specification title: Application-Independent Java Utility Library Specification vendor: Sybase, Inc. Specification version: null Package: com.sybase.helpManager Implementation title: HelpManager classes Implementation vendor: Sybase, Inc. Implementation version: 11 Specification title: HelpManager classes Specification vendor: Sybase, Inc. Specification version: 11 Package: com.sybase.jdbcx Implementation title: "com.sybase.jdbcx" Implementation vendor: "Sybase, Inc." Implementation version: "Build (25051)" Specification title: "jConnect for JDBC 2.0" Specification vendor: "Sybase, Inc." Specification version: "5.5" Package: com.sybase.resultSetTable Implementation title: JComponents Library Implementation vendor: Sybase, Inc. Implementation version: 142 Specification title: JComponents Library Specification vendor: Sybase, Inc. Specification version: 142 Package: com.sybase.util Implementation title: Application-Independent Java Utility Library Implementation vendor: Sybase, Inc. Implementation version: null Specification title: Application-Independent Java Utility Library Specification vendor: Sybase, Inc. Specification version: null Package: com.sybase.util.win32 Implementation title: Application-Independent Java Utility Library Implementation vendor: Sybase, Inc. Implementation version: null Specification title: Application-Independent Java Utility Library Specification vendor: Sybase, Inc. Specification version: null Package: ianywhere.ml.jdbcodbc Implementation title: null Implementation vendor: null Implementation version: null Specification title: null Specification vendor: null Specification version: null Package: java.applet Implementation title: Java Runtime Environment Implementation vendor: Sun Microsystems, Inc. Implementation version: 1.4.2_02 Specification title: Java Platform API Specification Specification vendor: Sun Microsystems, Inc. Specification version: 1.4 Package: java.awt Implementation title: Java Runtime Environment Implementation vendor: Sun Microsystems, Inc. Implementation version: 1.4.2_02 Specification title: Java Platform API Specification Specification vendor: Sun Microsystems, Inc. Specification version: 1.4 Package: java.awt.color Implementation title: Java Runtime Environment Implementation vendor: Sun Microsystems, Inc. Implementation version: 1.4.2_02 Specification title: Java Platform API Specification Specification vendor: Sun Microsystems, Inc. Specification version: 1.4 Package: java.awt.datatransfer Implementation title: Java Runtime Environment Implementation vendor: Sun Microsystems, Inc. Implementation version: 1.4.2_02 Specification title: Java Platform API Specification Specification vendor: Sun Microsystems, Inc. Specification version: 1.4 Package: java.awt.dnd Implementation title: Java Runtime Environment Implementation vendor: Sun Microsystems, Inc. Implementation version: 1.4.2_02 Specification title: Java Platform API Specification Specification vendor: Sun Microsystems, Inc. Specification version: 1.4 Package: java.awt.dnd.peer Implementation title: Java Runtime Environment Implementation vendor: Sun Microsystems, Inc. Implementation version: 1.4.2_02 Specification title: Java Platform API Specification Specification vendor: Sun Microsystems, Inc. Specification version: 1.4 Package: java.awt.event Implementation title: Java Runtime Environment Implementation vendor: Sun Microsystems, Inc. Implementation version: 1.4.2_02 Specification title: Java Platform API Specification Specification vendor: Sun Microsystems, Inc. Specification version: 1.4 Package: java.awt.font Implementation title: Java Runtime Environment Implementation vendor: Sun Microsystems, Inc. Implementation version: 1.4.2_02 Specification title: Java Platform API Specification Specification vendor: Sun Microsystems, Inc. Specification version: 1.4 Package: java.awt.geom Implementation title: Java Runtime Environment Implementation vendor: Sun Microsystems, Inc. Implementation version: 1.4.2_02 Specification title: Java Platform API Specification Specification vendor: Sun Microsystems, Inc. Specification version: 1.4 Package: java.awt.im Implementation title: Java Runtime Environment Implementation vendor: Sun Microsystems, Inc. Implementation version: 1.4.2_02 Specification title: Java Platform API Specification Specification vendor: Sun Microsystems, Inc. Specification version: 1.4 Package: java.awt.im.spi Implementation title: Java Runtime Environment Implementation vendor: Sun Microsystems, Inc. Implementation version: 1.4.2_02 Specification title: Java Platform API Specification Specification vendor: Sun Microsystems, Inc. Specification version: 1.4 Package: java.awt.image Implementation title: Java Runtime Environment Implementation vendor: Sun Microsystems, Inc. Implementation version: 1.4.2_02 Specification title: Java Platform API Specification Specification vendor: Sun Microsystems, Inc. Specification version: 1.4 Package: java.awt.peer Implementation title: Java Runtime Environment Implementation vendor: Sun Microsystems, Inc. Implementation version: 1.4.2_02 Specification title: Java Platform API Specification Specification vendor: Sun Microsystems, Inc. Specification version: 1.4 Package: java.awt.print Implementation title: Java Runtime Environment Implementation vendor: Sun Microsystems, Inc. Implementation version: 1.4.2_02 Specification title: Java Platform API Specification Specification vendor: Sun Microsystems, Inc. Specification version: 1.4 Package: java.beans Implementation title: Java Runtime Environment Implementation vendor: Sun Microsystems, Inc. Implementation version: 1.4.2_02 Specification title: Java Platform API Specification Specification vendor: Sun Microsystems, Inc. Specification version: 1.4 Package: java.io Implementation title: Java Runtime Environment Implementation vendor: Sun Microsystems, Inc. Implementation version: 1.4.2_02 Specification title: Java Platform API Specification Specification vendor: Sun Microsystems, Inc. Specification version: 1.4 Package: java.lang Implementation title: Java Runtime Environment Implementation vendor: Sun Microsystems, Inc. Implementation version: 1.4.2_02 Specification title: Java Platform API Specification Specification vendor: Sun Microsystems, Inc. Specification version: 1.4 Package: java.lang.ref Implementation title: Java Runtime Environment Implementation vendor: Sun Microsystems, Inc. Implementation version: 1.4.2_02 Specification title: Java Platform API Specification Specification vendor: Sun Microsystems, Inc. Specification version: 1.4 Package: java.lang.reflect Implementation title: Java Runtime Environment Implementation vendor: Sun Microsystems, Inc. Implementation version: 1.4.2_02 Specification title: Java Platform API Specification Specification vendor: Sun Microsystems, Inc. Specification version: 1.4 Package: java.net Implementation title: Java Runtime Environment Implementation vendor: Sun Microsystems, Inc. Implementation version: 1.4.2_02 Specification title: Java Platform API Specification Specification vendor: Sun Microsystems, Inc. Specification version: 1.4 Package: java.nio Implementation title: Java Runtime Environment Implementation vendor: Sun Microsystems, Inc. Implementation version: 1.4.2_02 Specification title: Java Platform API Specification Specification vendor: Sun Microsystems, Inc. Specification version: 1.4 Package: java.nio.charset Implementation title: Java Runtime Environment Implementation vendor: Sun Microsystems, Inc. Implementation version: 1.4.2_02 Specification title: Java Platform API Specification Specification vendor: Sun Microsystems, Inc. Specification version: 1.4 Package: java.nio.charset.spi Implementation title: Java Runtime Environment Implementation vendor: Sun Microsystems, Inc. Implementation version: 1.4.2_02 Specification title: Java Platform API Specification Specification vendor: Sun Microsystems, Inc. Specification version: 1.4 Package: java.rmi Implementation title: Java Runtime Environment Implementation vendor: Sun Microsystems, Inc. Implementation version: 1.4.2_02 Specification title: Java Platform API Specification Specification vendor: Sun Microsystems, Inc. Specification version: 1.4 Package: java.security Implementation title: Java Runtime Environment Implementation vendor: Sun Microsystems, Inc. Implementation version: 1.4.2_02 Specification title: Java Platform API Specification Specification vendor: Sun Microsystems, Inc. Specification version: 1.4 Package: java.security.cert Implementation title: Java Runtime Environment Implementation vendor: Sun Microsystems, Inc. Implementation version: 1.4.2_02 Specification title: Java Platform API Specification Specification vendor: Sun Microsystems, Inc. Specification version: 1.4 Package: java.sql Implementation title: Java Runtime Environment Implementation vendor: Sun Microsystems, Inc. Implementation version: 1.4.2_02 Specification title: Java Platform API Specification Specification vendor: Sun Microsystems, Inc. Specification version: 1.4 Package: java.text Implementation title: Java Runtime Environment Implementation vendor: Sun Microsystems, Inc. Implementation version: 1.4.2_02 Specification title: Java Platform API Specification Specification vendor: Sun Microsystems, Inc. Specification version: 1.4 Package: java.util Implementation title: Java Runtime Environment Implementation vendor: Sun Microsystems, Inc. Implementation version: 1.4.2_02 Specification title: Java Platform API Specification Specification vendor: Sun Microsystems, Inc. Specification version: 1.4 Package: java.util.jar Implementation title: Java Runtime Environment Implementation vendor: Sun Microsystems, Inc. Implementation version: 1.4.2_02 Specification title: Java Platform API Specification Specification vendor: Sun Microsystems, Inc. Specification version: 1.4 Package: java.util.regex Implementation title: Java Runtime Environment Implementation vendor: Sun Microsystems, Inc. Implementation version: 1.4.2_02 Specification title: Java Platform API Specification Specification vendor: Sun Microsystems, Inc. Specification version: 1.4 Package: java.util.zip Implementation title: Java Runtime Environment Implementation vendor: Sun Microsystems, Inc. Implementation version: 1.4.2_02 Specification title: Java Platform API Specification Specification vendor: Sun Microsystems, Inc. Specification version: 1.4 Package: javax.accessibility Implementation title: Java Runtime Environment Implementation vendor: Sun Microsystems, Inc. Implementation version: 1.4.2_02 Specification title: Java Platform API Specification Specification vendor: Sun Microsystems, Inc. Specification version: 1.4 Package: javax.swing Implementation title: Java Runtime Environment Implementation vendor: Sun Microsystems, Inc. Implementation version: 1.4.2_02 Specification title: Java Platform API Specification Specification vendor: Sun Microsystems, Inc. Specification version: 1.4 Package: javax.swing.border Implementation title: Java Runtime Environment Implementation vendor: Sun Microsystems, Inc. Implementation version: 1.4.2_02 Specification title: Java Platform API Specification Specification vendor: Sun Microsystems, Inc. Specification version: 1.4 Package: javax.swing.event Implementation title: Java Runtime Environment Implementation vendor: Sun Microsystems, Inc. Implementation version: 1.4.2_02 Specification title: Java Platform API Specification Specification vendor: Sun Microsystems, Inc. Specification version: 1.4 Package: javax.swing.plaf Implementation title: Java Runtime Environment Implementation vendor: Sun Microsystems, Inc. Implementation version: 1.4.2_02 Specification title: Java Platform API Specification Specification vendor: Sun Microsystems, Inc. Specification version: 1.4 Package: javax.swing.plaf.basic Implementation title: Java Runtime Environment Implementation vendor: Sun Microsystems, Inc. Implementation version: 1.4.2_02 Specification title: Java Platform API Specification Specification vendor: Sun Microsystems, Inc. Specification version: 1.4 Package: javax.swing.table Implementation title: Java Runtime Environment Implementation vendor: Sun Microsystems, Inc. Implementation version: 1.4.2_02 Specification title: Java Platform API Specification Specification vendor: Sun Microsystems, Inc. Specification version: 1.4 Package: javax.swing.text Implementation title: Java Runtime Environment Implementation vendor: Sun Microsystems, Inc. Implementation version: 1.4.2_02 Specification title: Java Platform API Specification Specification vendor: Sun Microsystems, Inc. Specification version: 1.4 Package: javax.swing.text.html Implementation title: Java Runtime Environment Implementation vendor: Sun Microsystems, Inc. Implementation version: 1.4.2_02 Specification title: Java Platform API Specification Specification vendor: Sun Microsystems, Inc. Specification version: 1.4 Package: javax.swing.tree Implementation title: Java Runtime Environment Implementation vendor: Sun Microsystems, Inc. Implementation version: 1.4.2_02 Specification title: Java Platform API Specification Specification vendor: Sun Microsystems, Inc. Specification version: 1.4 Package: javax.swing.undo Implementation title: Java Runtime Environment Implementation vendor: Sun Microsystems, Inc. Implementation version: 1.4.2_02 Specification title: Java Platform API Specification Specification vendor: Sun Microsystems, Inc. Specification version: 1.4 Package: sun.awt Implementation title: Java Runtime Environment Implementation vendor: Sun Microsystems, Inc. Implementation version: 1.4.2_02 Specification title: Java Platform API Specification Specification vendor: Sun Microsystems, Inc. Specification version: 1.4 Package: sun.awt.color Implementation title: Java Runtime Environment Implementation vendor: Sun Microsystems, Inc. Implementation version: 1.4.2_02 Specification title: Java Platform API Specification Specification vendor: Sun Microsystems, Inc. Specification version: 1.4 Package: sun.awt.datatransfer Implementation title: Java Runtime Environment Implementation vendor: Sun Microsystems, Inc. Implementation version: 1.4.2_02 Specification title: Java Platform API Specification Specification vendor: Sun Microsystems, Inc. Specification version: 1.4 Package: sun.awt.dnd Implementation title: Java Runtime Environment Implementation vendor: Sun Microsystems, Inc. Implementation version: 1.4.2_02 Specification title: Java Platform API Specification Specification vendor: Sun Microsystems, Inc. Specification version: 1.4 Package: sun.awt.font Implementation title: Java Runtime Environment Implementation vendor: Sun Microsystems, Inc. Implementation version: 1.4.2_02 Specification title: Java Platform API Specification Specification vendor: Sun Microsystems, Inc. Specification version: 1.4 Package: sun.awt.im Implementation title: Java Runtime Environment Implementation vendor: Sun Microsystems, Inc. Implementation version: 1.4.2_02 Specification title: Java Platform API Specification Specification vendor: Sun Microsystems, Inc. Specification version: 1.4 Package: sun.awt.image Implementation title: Java Runtime Environment Implementation vendor: Sun Microsystems, Inc. Implementation version: 1.4.2_02 Specification title: Java Platform API Specification Specification vendor: Sun Microsystems, Inc. Specification version: 1.4 Package: sun.awt.resources Implementation title: Java Runtime Environment Implementation vendor: Sun Microsystems, Inc. Implementation version: 1.4.2_02 Specification title: Java Platform API Specification Specification vendor: Sun Microsystems, Inc. Specification version: 1.4 Package: sun.awt.shell Implementation title: Java Runtime Environment Implementation vendor: Sun Microsystems, Inc. Implementation version: 1.4.2_02 Specification title: Java Platform API Specification Specification vendor: Sun Microsystems, Inc. Specification version: 1.4 Package: sun.awt.windows Implementation title: Java Runtime Environment Implementation vendor: Sun Microsystems, Inc. Implementation version: 1.4.2_02 Specification title: Java Platform API Specification Specification vendor: Sun Microsystems, Inc. Specification version: 1.4 Package: sun.io Implementation title: Java Runtime Environment Implementation vendor: Sun Microsystems, Inc. Implementation version: 1.4.2_02 Specification title: Java Platform API Specification Specification vendor: Sun Microsystems, Inc. Specification version: 1.4 Package: sun.java2d Implementation title: Java Runtime Environment Implementation vendor: Sun Microsystems, Inc. Implementation version: 1.4.2_02 Specification title: Java Platform API Specification Specification vendor: Sun Microsystems, Inc. Specification version: 1.4 Package: sun.java2d.loops Implementation title: Java Runtime Environment Implementation vendor: Sun Microsystems, Inc. Implementation version: 1.4.2_02 Specification title: Java Platform API Specification Specification vendor: Sun Microsystems, Inc. Specification version: 1.4 Package: sun.java2d.pipe Implementation title: Java Runtime Environment Implementation vendor: Sun Microsystems, Inc. Implementation version: 1.4.2_02 Specification title: Java Platform API Specification Specification vendor: Sun Microsystems, Inc. Specification version: 1.4 Package: sun.misc Implementation title: Java Runtime Environment Implementation vendor: Sun Microsystems, Inc. Implementation version: 1.4.2_02 Specification title: Java Platform API Specification Specification vendor: Sun Microsystems, Inc. Specification version: 1.4 Package: sun.net Implementation title: Java Runtime Environment Implementation vendor: Sun Microsystems, Inc. Implementation version: 1.4.2_02 Specification title: Java Platform API Specification Specification vendor: Sun Microsystems, Inc. Specification version: 1.4 Package: sun.net.spi.nameservice Implementation title: Java Runtime Environment Implementation vendor: Sun Microsystems, Inc. Implementation version: 1.4.2_02 Specification title: Java Platform API Specification Specification vendor: Sun Microsystems, Inc. Specification version: 1.4 Package: sun.net.www Implementation title: Java Runtime Environment Implementation vendor: Sun Microsystems, Inc. Implementation version: 1.4.2_02 Specification title: Java Platform API Specification Specification vendor: Sun Microsystems, Inc. Specification version: 1.4 Package: sun.net.www.protocol.file Implementation title: Java Runtime Environment Implementation vendor: Sun Microsystems, Inc. Implementation version: 1.4.2_02 Specification title: Java Platform API Specification Specification vendor: Sun Microsystems, Inc. Specification version: 1.4 Package: sun.net.www.protocol.jar Implementation title: Java Runtime Environment Implementation vendor: Sun Microsystems, Inc. Implementation version: 1.4.2_02 Specification title: Java Platform API Specification Specification vendor: Sun Microsystems, Inc. Specification version: 1.4 Package: sun.nio.cs Implementation title: Java Runtime Environment Implementation vendor: Sun Microsystems, Inc. Implementation version: 1.4.2_02 Specification title: Java Platform API Specification Specification vendor: Sun Microsystems, Inc. Specification version: 1.4 Package: sun.reflect Implementation title: Java Runtime Environment Implementation vendor: Sun Microsystems, Inc. Implementation version: 1.4.2_02 Specification title: Java Platform API Specification Specification vendor: Sun Microsystems, Inc. Specification version: 1.4 Package: sun.security.action Implementation title: Java Runtime Environment Implementation vendor: Sun Microsystems, Inc. Implementation version: 1.4.2_02 Specification title: Java Platform API Specification Specification vendor: Sun Microsystems, Inc. Specification version: 1.4 Package: sun.security.provider Implementation title: Java Runtime Environment Implementation vendor: Sun Microsystems, Inc. Implementation version: 1.4.2_02 Specification title: Java Platform API Specification Specification vendor: Sun Microsystems, Inc. Specification version: 1.4 Package: sun.security.util Implementation title: Java Runtime Environment Implementation vendor: Sun Microsystems, Inc. Implementation version: 1.4.2_02 Specification title: Java Platform API Specification Specification vendor: Sun Microsystems, Inc. Specification version: 1.4 Package: sun.text Implementation title: Java Runtime Environment Implementation vendor: Sun Microsystems, Inc. Implementation version: 1.4.2_02 Specification title: Java Platform API Specification Specification vendor: Sun Microsystems, Inc. Specification version: 1.4 Package: sun.text.resources Implementation title: Java Runtime Environment Implementation vendor: Sun Microsystems, Inc. Implementation version: 1.4.2_02 Specification title: Java Platform API Specification Specification vendor: Sun Microsystems, Inc. Specification version: 1.4 Package: sun.util.calendar Implementation title: Java Runtime Environment Implementation vendor: Sun Microsystems, Inc. Implementation version: 1.4.2_02 Specification title: Java Platform API Specification Specification vendor: Sun Microsystems, Inc. Specification version: 1.4 Package: sybase.isql Implementation title: Interactive SQL Implementation vendor: Sybase, Inc. Implementation version: 9.0.2 Specification title: Interactive SQL Specification vendor: Sybase, Inc. Specification version: 9.0.2 |
Googling this error I find it seems to be a problem with sybase 9 and Windows 7. You may try the dbisqlc tool, which allows also interactive queries but doesn't use a Java VM: "%ASANY9%\win32\dbisqlc"
(27 Feb '12, 16:23)
Volker Barth
|
Just to clarify: In contrast to other DMBSs like MS SQL or Sybase ASE, SQL Anywhere does not have the notion of a "master database", so you don't need to "attach" a database to any kind of master database. You can simply run any number of SQL Anywhere databases on the same database engine.
Another note: The v10 database engine can't start v9 databases except for rebuilding them for v10, since the database file format has changed for v10 and above -cf. this doc page. - So once you have found out which files belong to which database (see @Glenn's answer), you might need to rebuild these databases or find a v9 engine to load them...
Thanks for your suggestion.... I tried the dbsrv10.exe gfi.db and it pops up a window saying that
"... was created by a different version of the software... you must rebuild this database in order to use it with SQL Anywhere 10."
So I guess my choices are to uninstall 10 and try to find a demo of 9 somewhere, or figure out a way to rebuild them into a 10 compatible format... I guess I'll start googling :)
That's exactly what is supposed to happen, see my comment.
I hope the docs give you enough clues what to do (in case you don't go the v9 way, which would be much less work in case you get a copy, apparently...)