dbTalk Databases Forums  

Problem with isql command line sql

sybase.public.sqlanywhere.general sybase.public.sqlanywhere.general


Discuss Problem with isql command line sql in the sybase.public.sqlanywhere.general forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
David Kerber
 
Posts: n/a

Default Problem with isql command line sql - 01-27-2010 , 03:39 PM






Any suggestions as to how to go about fixing this?


I'm running dbisql.exe ver 9.0.2.3886 32-bit (which is supposed to be
Win7 compatible) against a 9.0.2.3456 server, located on a different
machine, from a Win 7 x64 client.

The following set of commands works fine when run in the isql gui
(dbisqlg.exe), but when run at the command line (dbisql.exe), it fails
to put out the full data I should see.

SELECT 'SET STATE_LOCATIONS=' || list( DISTINCT siteid, ' ' ORDER BY
siteid ) AS
location FROM siteview sv JOIN info i ON i.entitykey = sv.lockey
WHERE compid='90610' AND Upper(LEFT( i.state, 2 )) = Upper( 'ny' );

output to 'm:\customer\DELTA\cmd\SetLocationsFornyRecons.cmd ' quote ''
format ascii;


The full line I'm executing:

dbisql -nogui -c "eng=Wra_Data;dbn=ssData;links=tcpip;uid=dba;pwd=s ql"
"select 'SET STATE_LOCATIONS=' || list( distinct siteid, ' ' order by
siteid ) as location from siteview sv join info i on i.entitykey =
sv.lockey where compid='%COMPANY%' and Upper(left( i.state, 2 )) = Upper
( '%STATE%' ); output to 'm:\customer\%CNAME%\cmd\SetLocationsFor%STATE%
Recons.cmd' quote '' format ascii;"


I should get (and do get when using the GUI):
SET STATE_LOCATIONS=1805 1807

But I am actually getting nothing in the output file, along with this
error in the command window:

Error! This program has encountered an internal error.
Details have been logged to isqlInternalError-10.txt



The contents of which are:

+-----------------+
Quote:
Stack Trace |
+-----------------+

Current thread: main
java.lang.NoClassDefFoundError: ianywhere/ml/jdbcodbc/ASAMessageHandler
at sybase.isql.Console.connect(Console.java:320)
at sybase.isql.Console.run(Console.java:79)
at sybase.isql.isql.main(isql.java:568)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Nativ e Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(Unknow n Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Un known
Source)
at java.lang.reflect.Method.invoke(Unknown Source)
at sybase.isql.ISQLLoader.callISQLMethod(ISQLLoader.j ava:410)
at sybase.isql.ISQLLoader.main(ISQLLoader.java:263)



+----------+
Quote:
ISQL |
+----------+

Wed Jan 27 15:27:40 EST 2010
ISQL version = 9.0.2, Build 3886
CommandLineOptions
Full command line: -locale en -nogui -c
"eng=Wra_Data;dbn=ssData;links=tcpip;uid=dba;pwd=s ql" "select 'SET
STATE_LOCATIONS=' || list( distinct siteid, ' ' order by siteid ) as
location from siteview sv join info i on i.entitykey = sv.lockey where
compid='90610' and Upper(left( i.state, 2 )) = Upper( 'ny' ); output to
'm:\customer\DELTA\cmd\SetLocationsFornyRecons.cmd ' quote '' format
ascii;"
ConnectionInfo: UID=dba;PWD=***;ENG=Wra_Data;DBN=ssData;links=tcpi p;
<JDBCDRIVER>=ianywhere.ml.jdbcodbc.IDriver
Command tail: "select 'SET STATE_LOCATIONS=' || list( distinct siteid,
' ' order by siteid ) as location from siteview sv join info i on
i.entitykey = sv.lockey where compid='90610' and Upper(left( i.state, 2
)) = Upper( 'ny' ); output to 'm:\customer\DELTA\cmd
\SetLocationsFornyRecons.cmd' quote '' format ascii;"
Initial SQL statement: (none)
Execute initial SQL statement: No
Use GUI: No
Quiet mode is: Off
Syntax check mode is: Off
Default database type: ASA

No current database connection
Currently executing statements: (none)

Current parser state:
(No current ISQL parser)
Settings:
maxRowsFetchedForUI=500
showMultipleResultSets=false
The fast launcher is not running


+---------------+
Quote:
Classpath |
+---------------+

C:\Program Files (x86)\Sybase\SQL Anywhere 9\java\isql.jar
Timestamp=2009-09-06 21:15:18.0
Length=1034601

C:\Program Files (x86)\Sybase\Shared\jConnect-5_5\classes\jconn2.jar
Timestamp=2001-08-10 13:40:52.0
Length=847267

C:\Program Files (x86)\Sybase\SQL Anywhere 9\java\jlogon.jar
Timestamp=2009-09-06 21:11:06.0
Length=202595

M:\WRA\"UNC\nellie2\dbase\WRA\jodbc.jar"
"UNC\nellie2\dbase\WRA\jodbc.jar"**** File does not exist

C:\Program Files (x86)\Sybase\Shared\java\SCEditor142.jar
Timestamp=2008-11-03 17:53:16.0
Length=346128

C:\Program Files (x86)\Sybase\Shared\java\JComponents142.jar
Timestamp=2009-09-06 21:10:56.0
Length=856343

C:\Program Files (x86)\Sybase\Shared\java\jsyblib142.jar
Timestamp=2008-11-03 17:52:58.0
Length=269230

C:\Program Files (x86)\Sybase\Shared\Sun\JavaHelp-1_1\jh.jar
Timestamp=2002-06-24 12:36:00.0
Length=347246

C:\Program Files (x86)\Sybase\Shared\java\HelpManager11.jar
Timestamp=2008-11-03 17:53:02.0
Length=56336

C:\Program Files (x86)\Sybase\SQL Anywhere 9\java\xerces.jar
Timestamp=2004-09-10 14:36:48.0
Length=854256

C:\Program Files (x86)\Sybase\SQL Anywhere 9\java\xml4j.jar
Timestamp=2004-09-10 14:36:48.0
Length=10645



+-------------------+
Quote:
Look and Feel |
+-------------------+

Look and Feel:
Name:Metal
Description:The Java(tm) Look and Feel
IsNative:false
IsSupported:true
ID:Metal
Class:javax.swing.plaf.metal.MetalLookAndFeel

Desktop Properties:
awt.dynamicLayoutSupported=true
awt.multiClickInterval=500
awt.wheelMousePresent=true
win.3d.backgroundColor=java.awt.Color[r=212,g=208,b=200]
win.3d.darkShadowColor=java.awt.Color[r=64,g=64,b=64]
win.3d.highlightColor=java.awt.Color[r=255,g=255,b=255]
win.3d.lightColor=java.awt.Color[r=212,g=208,b=200]
win.3d.shadowColor=java.awt.Color[r=128,g=128,b=128]
win.ansiFixed.font=java.awt.Font
[family=dialog,name=Courier,style=plain,size=13]
win.ansiFixed.font.height=13
win.ansiVar.font=java.awt.Font[family=sansserif,name=MS Sans
Serif,style=plain,size=11]
win.ansiVar.font.height=11
win.button.textColor=java.awt.Color[r=0,g=0,b=0]
win.defaultGUI.font=java.awt.Font[family=dialog,name=MS Shell
Dlg,style=plain,size=11]
win.defaultGUI.font.height=11
win.desktop.backgroundColor=java.awt.Color[r=120,g=120,b=120]
win.deviceDefault.font=java.awt.Font
[family=dialog,name=System,style=bold,size=13]
win.deviceDefault.font.height=13
win.drag.height=4
win.drag.width=4
win.frame.activeBorderColor=java.awt.Color[r=212,g=208,b=200]
win.frame.activeCaptionColor=java.awt.Color[r=10,g=36,b=106]
win.frame.activeCaptionGradientColor=java.awt.Colo r[r=166,g=202,b=240]
win.frame.backgroundColor=java.awt.Color[r=255,g=255,b=255]
win.frame.captionButtonHeight=18
win.frame.captionButtonWidth=18
win.frame.captionFont=java.awt.Font
[family=Tahoma,name=Tahoma,style=bold,size=11]
win.frame.captionFont.height=11
win.frame.captionGradientsOn=true
win.frame.captionHeight=18
win.frame.captionTextColor=java.awt.Color[r=255,g=255,b=255]
win.frame.color=java.awt.Color[r=0,g=0,b=0]
win.frame.fullWindowDragsOn=true
win.frame.inactiveBorderColor=java.awt.Color[r=212,g=208,b=200]
win.frame.inactiveCaptionColor=java.awt.Color[r=128,g=128,b=128]
win.frame.inactiveCaptionGradientColor=java.awt.Co lor[r=192,g=192,b=
192]
win.frame.inactiveCaptionTextColor=java.awt.Color[r=212,g=208,b=200]
win.frame.sizingBorderWidth=1
win.frame.smallCaptionButtonHeight=15
win.frame.smallCaptionButtonWidth=12
win.frame.smallCaptionFont=java.awt.Font
[family=Tahoma,name=Tahoma,style=bold,size=11]
win.frame.smallCaptionFont.height=11
win.frame.smallCaptionHeight=15
win.frame.textColor=java.awt.Color[r=0,g=0,b=0]
win.highContrast.on=false
win.icon.font=java.awt.Font
[family=Tahoma,name=Tahoma,style=plain,size=11]
win.icon.font.height=11
win.icon.hspacing=75
win.icon.titleWrappingOn=true
win.icon.vspacing=75
win.item.highlightColor=java.awt.Color[r=10,g=36,b=106]
win.item.highlightTextColor=java.awt.Color[r=255,g=255,b=255]
win.item.hotTrackedColor=java.awt.Color[r=0,g=0,b=128]
win.item.hotTrackingOn=true
win.mdi.backgroundColor=java.awt.Color[r=128,g=128,b=128]
win.menu.backgroundColor=java.awt.Color[r=212,g=208,b=200]
win.menu.buttonWidth=18
win.menu.font=java.awt.Font
[family=Tahoma,name=Tahoma,style=plain,size=11]
win.menu.font.height=11
win.menu.height=18
win.menu.keyboardCuesOn=false
win.menu.textColor=java.awt.Color[r=0,g=0,b=0]
win.messagebox.font=java.awt.Font
[family=Tahoma,name=Tahoma,style=plain,size=11]
win.messagebox.font.height=11
win.oemFixed.font=java.awt.Font
[family=dialog,name=Terminal,style=plain,size=12]
win.oemFixed.font.height=12
win.properties.version=2
win.scrollbar.backgroundColor=java.awt.Color[r=212,g=208,b=200]
win.scrollbar.height=16
win.scrollbar.width=16
win.sound.asterisk=WinPlaySound(SystemAsterisk)
win.sound.close=WinPlaySound(Close)
win.sound.default=WinPlaySound(.Default)
win.sound.exclamation=WinPlaySound(SystemExclamati on)
win.sound.exit=WinPlaySound(SystemExit)
win.sound.hand=WinPlaySound(SystemHand)
win.sound.maximize=WinPlaySound(Maximize)
win.sound.menuCommand=WinPlaySound(MenuCommand)
win.sound.menuPopup=WinPlaySound(MenuPopup)
win.sound.minimize=WinPlaySound(Minimize)
win.sound.open=WinPlaySound(Open)
win.sound.question=WinPlaySound(SystemQuestion)
win.sound.restoreDown=WinPlaySound(RestoreDown)
win.sound.restoreUp=WinPlaySound(RestoreUp)
win.sound.start=WinPlaySound(SystemStart)
win.status.font=java.awt.Font
[family=Tahoma,name=Tahoma,style=plain,size=11]
win.status.font.height=11
win.system.font=java.awt.Font
[family=dialog,name=System,style=bold,size=13]
win.system.font.height=13
win.systemFixed.font=java.awt.Font
[family=dialog,name=Fixedsys,style=plain,size=12]
win.systemFixed.font.height=12
win.text.fontSmoothingOn=false
win.text.grayedTextColor=java.awt.Color[r=128,g=128,b=128]
win.tooltip.backgroundColor=java.awt.Color[r=255,g=255,b=225]
win.tooltip.font=java.awt.Font
[family=Tahoma,name=Tahoma,style=plain,size=11]
win.tooltip.font.height=11
win.tooltip.textColor=java.awt.Color[r=0,g=0,b=0]
win.xpstyle.themeActive=false



+-------------+
Quote:
Java VM |
+-------------+

Total memory: 2031616
Free memory: 1005904
System properties:
asa.location=C:\PROGRA~2\Sybase\SQLANY~1\
awt.toolkit=sun.awt.windows.WToolkit
file.encoding=Cp437
file.encoding.pkg=sun.io
file.separator=\
isql.commandShell="C:\Windows\SysWOW64\cmd.exe /c"
isql.helpFolder=C:\PROGRA~2\Sybase\SQLANY~1\java
java.awt.graphicsenv=sun.awt.Win32GraphicsEnvironm ent
java.awt.printerjob=sun.awt.windows.WPrinterJob
java.class.path=C:\PROGRA~2\Sybase\SQLANY~1\java\i sql.jar;C:\PROGRA~
2\Sybase\Shared\JCONNE~1\classes\jconn2.jar;C:\PRO GRA~2\Sybase\SQLANY~1
\java\jlogon.jar;"UNC\nellie2\dbase\WRA\jodbc.jar" ;C:\PROGRA~2\Sybase
\Shared\java\SCEDIT~1.JAR;C:\PROGRA~2\Sybase\Share d\java\JCOMPO~1.JAR;C:
\PROGRA~2\Sybase\Shared\java\JSYBLI~1.JAR;C:\PROGR A~2\Sybase\Shared\Sun
\JAVAHE~1\jh.jar;C:\PROGRA~2\Sybase\Shared\java\HE LPMA~1.JAR;C:\PROGRA~2
\Sybase\SQLANY~1\java\xerces.jar;C:\PROGRA~2\Sybas e\SQLANY~1\java
\xml4j.jar;
java.class.version=48.0
java.endorsed.dirs=C:\Program Files (x86)\Sybase\Shared\sun\jre142
\lib\endorsed
java.ext.dirs=C:\Program Files (x86)\Sybase\Shared\sun\jre142\lib
\ext
java.home=C:\Program Files (x86)\Sybase\Shared\sun\jre142
java.io.tmpdir=C:\Users\davek.WRA\AppData\Local\Te mp\
java.library.path=C:\Program Files (x86)\Sybase\SQL Anywhere 9
\win32;.;C:\Windows\system32;C:\Windows;C:\Windows \system32;C:
\Windows;C:\Windows\System32\Wbem;C:\Windows\Syste m32\WindowsPowerShell
\v1.0\;c:\Program Files (x86)\ATI Technologies\ATI.ACE\Core-Static;C:
\Program Files (x86)\Common Files\Roxio Shared\DLLShared\;C:\Program
Files (x86)\Sybase\SQL Anywhere 9\win32;C:\Program Files (x86)\Sybase
\Shared\win32;C:\Program Files (x86)\Sybase\SQL Anywhere 9\drivers;C:
\Program Files (x86)\Sybase\Shared\Sybase Central 4.3\win32;C:\Program
Files\TortoiseSVN\bin;C:\Program Files (x86)\IDM Computer Solutions
\UltraEdit\
java.runtime.name=Java(TM) 2 Runtime Environment, Standard Edition
java.runtime.version=1.4.2_18-b06
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 .WindowsPreferencesFac
tory
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_18
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_18-b06

javax.accessibility.assistive_technologies=com.sun .java.accessibility.Ac
cessBridge
line.separator=

os.arch=x86
os.name=Windows Vista
os.version=6.1
path=C:\PROGRA~2\Sybase\SQLANY~1\win32;C:\PROGRA~2 \Sybase\Shared\Sun
\jre142\bin;C:\Windows\SysWOW64;C:\Windows;C:\Wind ows\SysWOW64\wbem;C:
\Windows\SysWOW64\WINDOW~1\v1.0;C:\PROGRA~2\ATITEC ~1\ATI.ACE\CORE-S~1;C:
\PROGRA~2\COMMON~1\ROXIOS~1\DLLSHA~1;C:\PROGRA~2\S ybase\SQLANY~1
\win32;C:\PROGRA~2\Sybase\Shared\win32;C:\PROGRA~2 \Sybase\SQLANY~1
\drivers;C:\PROGRA~2\Sybase\Shared\SYBASE~1.3\win3 2;C:\PROGRA~1\TORTOI~1
\bin;C:\PROGRA~2\IDMCOM~1\ULTRAE~1
path.separator=;
sqlpath=
sun.arch.data.model=32
sun.boot.class.path=C:\Program Files (x86)\Sybase\Shared\sun\jre142
\lib\rt.jar;C:\Program Files (x86)\Sybase\Shared\sun\jre142\lib
\i18n.jar;C:\Program Files (x86)\Sybase\Shared\sun\jre142\lib
\sunrsasign.jar;C:\Program Files (x86)\Sybase\Shared\sun\jre142\lib
\jsse.jar;C:\Program Files (x86)\Sybase\Shared\sun\jre142\lib\jce.jar;C:
\Program Files (x86)\Sybase\Shared\sun\jre142\lib\charsets.jar;C:
\Program Files (x86)\Sybase\Shared\sun\jre142\classes
sun.boot.library.path=C:\Program Files (x86)\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=
sybase.jsyblib.dll.location=C:\PROGRA~2\Sybase\Sha red\win32\
user.country=US
user.dir=M:\WRA
user.home=C:\Users\davek.WRA
user.language=en
user.name=davek
user.timezone=America/New_York
user.variant=


+-------------------+
Quote:
Java Packages |
+-------------------+

Package: com.sun.java.accessibility
Implementation title: null
Implementation vendor: null
Implementation version: null
Specification title: null
Specification vendor: null
Specification version: null

Package: com.sun.java.accessibility.util
Implementation title: null
Implementation vendor: null
Implementation version: null
Specification title: null
Specification vendor: null
Specification version: null

Package: com.sybase.asa.logon
Implementation title: JDBC Connection Library
Implementation vendor: Sybase, Inc.
Implementation version: 9.0.2.3886
Specification title: JDBC Connection Library
Specification vendor: Sybase, Inc.
Specification version: 9.0.2.3886

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.util
Implementation title: Application-Independent Java Utility Library
Implementation vendor: Sybase, Inc.
Implementation version: 4.3.0.2470
Specification title: Application-Independent Java Utility Library
Specification vendor: Sybase, Inc.
Specification version: 4.3.0.2470

Package: com.sybase.util.win32
Implementation title: Application-Independent Java Utility Library
Implementation vendor: Sybase, Inc.
Implementation version: 4.3.0.2470
Specification title: Application-Independent Java Utility Library
Specification vendor: Sybase, Inc.
Specification version: 4.3.0.2470

Package: java.awt
Implementation title: Java Runtime Environment
Implementation vendor: Sun Microsystems, Inc.
Implementation version: 1.4.2_18
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_18
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_18
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_18
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_18
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_18
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_18
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_18
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_18
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_18
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_18
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_18
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_18
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_18
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_18
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_18
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_18
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_18
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_18
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_18
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_18
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_18
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_18
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_18
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_18
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_18
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_18
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_18
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_18
Specification title: Java Platform API Specification
Specification vendor: Sun Microsystems, Inc.
Specification version: 1.4

Package: javax.swing.plaf.metal
Implementation title: Java Runtime Environment
Implementation vendor: Sun Microsystems, Inc.
Implementation version: 1.4.2_18
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_18
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_18
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_18
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_18
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_18
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_18
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_18
Specification title: Java Platform API Specification
Specification vendor: Sun Microsystems, Inc.
Specification version: 1.4

Package: sun.io
Implementation title: null
Implementation vendor: null
Implementation version: null
Specification title: null
Specification vendor: null
Specification version: null

Package: sun.java2d
Implementation title: Java Runtime Environment
Implementation vendor: Sun Microsystems, Inc.
Implementation version: 1.4.2_18
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_18
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_18
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_18
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_18
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_18
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_18
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_18
Specification title: Java Platform API Specification
Specification vendor: Sun Microsystems, Inc.
Specification version: 1.4

Package: sun.nio.cs.ext
Implementation title: null
Implementation vendor: null
Implementation version: null
Specification title: null
Specification vendor: null
Specification version: null

Package: sun.reflect
Implementation title: Java Runtime Environment
Implementation vendor: Sun Microsystems, Inc.
Implementation version: 1.4.2_18
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_18
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_18
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_18
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_18
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_18
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.3886
Specification title: Interactive SQL
Specification vendor: Sybase, Inc.
Specification version: 9.0.2.3886





All the environment variables are assigned, because when I copy the
command from the command window, I get the result listed first above,
which works fine in the GUI.

Reply With Quote
  #2  
Old   
David Kerber
 
Posts: n/a

Default Re: Problem with isql command line sql - workaround found - 01-27-2010 , 04:19 PM






What is triggering this is that I have a copy of jodbc.jar in the
"current" directory that I'm running this command from. Apparently
dbisql's classpath is looking there first, before looking back into its
own install tree. I tested this by renaming jodbc.jar, and it worked
fine. Since I can't leave it renamed (I need jodbc.jar there for
another app), I'll just cd to another folder before calling dbisql.

Seems strange that dbisql would use the current directory as a
classpath, though...

D


In article <MPG.25ca6e604e76a364989697 (AT) forums (DOT) sybase.com>,
ns_dkerber (AT) ns_warrenrogersassociates (DOT) com says...
Quote:
Any suggestions as to how to go about fixing this?


I'm running dbisql.exe ver 9.0.2.3886 32-bit (which is supposed to be
Win7 compatible) against a 9.0.2.3456 server, located on a different
machine, from a Win 7 x64 client.

The following set of commands works fine when run in the isql gui
(dbisqlg.exe), but when run at the command line (dbisql.exe), it fails
to put out the full data I should see.

SELECT 'SET STATE_LOCATIONS=' || list( DISTINCT siteid, ' ' ORDER BY
siteid ) AS
location FROM siteview sv JOIN info i ON i.entitykey = sv.lockey
WHERE compid='90610' AND Upper(LEFT( i.state, 2 )) = Upper( 'ny' );

output to 'm:\customer\DELTA\cmd\SetLocationsFornyRecons.cmd ' quote ''
format ascii;


The full line I'm executing:

dbisql -nogui -c "eng=Wra_Data;dbn=ssData;links=tcpip;uid=dba;pwd=s ql"
"select 'SET STATE_LOCATIONS=' || list( distinct siteid, ' ' order by
siteid ) as location from siteview sv join info i on i.entitykey =
sv.lockey where compid='%COMPANY%' and Upper(left( i.state, 2 )) = Upper
( '%STATE%' ); output to 'm:\customer\%CNAME%\cmd\SetLocationsFor%STATE%
Recons.cmd' quote '' format ascii;"


I should get (and do get when using the GUI):
SET STATE_LOCATIONS=1805 1807

But I am actually getting nothing in the output file, along with this
error in the command window:

Error! This program has encountered an internal error.
Details have been logged to isqlInternalError-10.txt



The contents of which are:

+-----------------+
| Stack Trace |
+-----------------+

Current thread: main
java.lang.NoClassDefFoundError: ianywhere/ml/jdbcodbc/ASAMessageHandler
at sybase.isql.Console.connect(Console.java:320)
at sybase.isql.Console.run(Console.java:79)
at sybase.isql.isql.main(isql.java:568)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Nativ e Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(Unknow n Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Un known
Source)
at java.lang.reflect.Method.invoke(Unknown Source)
at sybase.isql.ISQLLoader.callISQLMethod(ISQLLoader.j ava:410)
at sybase.isql.ISQLLoader.main(ISQLLoader.java:263)



+----------+
| ISQL |
+----------+

Wed Jan 27 15:27:40 EST 2010
ISQL version = 9.0.2, Build 3886
CommandLineOptions
Full command line: -locale en -nogui -c
"eng=Wra_Data;dbn=ssData;links=tcpip;uid=dba;pwd=s ql" "select 'SET
STATE_LOCATIONS=' || list( distinct siteid, ' ' order by siteid ) as
location from siteview sv join info i on i.entitykey = sv.lockey where
compid='90610' and Upper(left( i.state, 2 )) = Upper( 'ny' ); output to
'm:\customer\DELTA\cmd\SetLocationsFornyRecons.cmd ' quote '' format
ascii;"
ConnectionInfo: UID=dba;PWD=***;ENG=Wra_Data;DBN=ssData;links=tcpi p;
JDBCDRIVER>=ianywhere.ml.jdbcodbc.IDriver
Command tail: "select 'SET STATE_LOCATIONS=' || list( distinct siteid,
' ' order by siteid ) as location from siteview sv join info i on
i.entitykey = sv.lockey where compid='90610' and Upper(left( i.state, 2
)) = Upper( 'ny' ); output to 'm:\customer\DELTA\cmd
\SetLocationsFornyRecons.cmd' quote '' format ascii;"
Initial SQL statement: (none)
Execute initial SQL statement: No
Use GUI: No
Quiet mode is: Off
Syntax check mode is: Off
Default database type: ASA

No current database connection
Currently executing statements: (none)

Current parser state:
(No current ISQL parser)
Settings:
maxRowsFetchedForUI=500
showMultipleResultSets=false
The fast launcher is not running


+---------------+
| Classpath |
+---------------+

C:\Program Files (x86)\Sybase\SQL Anywhere 9\java\isql.jar
Timestamp=2009-09-06 21:15:18.0
Length=1034601

C:\Program Files (x86)\Sybase\Shared\jConnect-5_5\classes\jconn2.jar
Timestamp=2001-08-10 13:40:52.0
Length=847267

C:\Program Files (x86)\Sybase\SQL Anywhere 9\java\jlogon.jar
Timestamp=2009-09-06 21:11:06.0
Length=202595

M:\WRA\"UNC\nellie2\dbase\WRA\jodbc.jar"
"UNC\nellie2\dbase\WRA\jodbc.jar"**** File does not exist

C:\Program Files (x86)\Sybase\Shared\java\SCEditor142.jar
Timestamp=2008-11-03 17:53:16.0
Length=346128

C:\Program Files (x86)\Sybase\Shared\java\JComponents142.jar
Timestamp=2009-09-06 21:10:56.0
Length=856343

C:\Program Files (x86)\Sybase\Shared\java\jsyblib142.jar
Timestamp=2008-11-03 17:52:58.0
Length=269230

C:\Program Files (x86)\Sybase\Shared\Sun\JavaHelp-1_1\jh.jar
Timestamp=2002-06-24 12:36:00.0
Length=347246

C:\Program Files (x86)\Sybase\Shared\java\HelpManager11.jar
Timestamp=2008-11-03 17:53:02.0
Length=56336

C:\Program Files (x86)\Sybase\SQL Anywhere 9\java\xerces.jar
Timestamp=2004-09-10 14:36:48.0
Length=854256

C:\Program Files (x86)\Sybase\SQL Anywhere 9\java\xml4j.jar
Timestamp=2004-09-10 14:36:48.0
Length=10645



+-------------------+
| Look and Feel |
+-------------------+

Look and Feel:
Name:Metal
Description:The Java(tm) Look and Feel
IsNative:false
IsSupported:true
ID:Metal
Class:javax.swing.plaf.metal.MetalLookAndFeel

Desktop Properties:
awt.dynamicLayoutSupported=true
awt.multiClickInterval=500
awt.wheelMousePresent=true
win.3d.backgroundColor=java.awt.Color[r=212,g=208,b=200]
win.3d.darkShadowColor=java.awt.Color[r=64,g=64,b=64]
win.3d.highlightColor=java.awt.Color[r=255,g=255,b=255]
win.3d.lightColor=java.awt.Color[r=212,g=208,b=200]
win.3d.shadowColor=java.awt.Color[r=128,g=128,b=128]
win.ansiFixed.font=java.awt.Font
[family=dialog,name=Courier,style=plain,size=13]
win.ansiFixed.font.height=13
win.ansiVar.font=java.awt.Font[family=sansserif,name=MS Sans
Serif,style=plain,size=11]
win.ansiVar.font.height=11
win.button.textColor=java.awt.Color[r=0,g=0,b=0]
win.defaultGUI.font=java.awt.Font[family=dialog,name=MS Shell
Dlg,style=plain,size=11]
win.defaultGUI.font.height=11
win.desktop.backgroundColor=java.awt.Color[r=120,g=120,b=120]
win.deviceDefault.font=java.awt.Font
[family=dialog,name=System,style=bold,size=13]
win.deviceDefault.font.height=13
win.drag.height=4
win.drag.width=4
win.frame.activeBorderColor=java.awt.Color[r=212,g=208,b=200]
win.frame.activeCaptionColor=java.awt.Color[r=10,g=36,b=106]
win.frame.activeCaptionGradientColor=java.awt.Colo r[r=166,g=202,b=240]
win.frame.backgroundColor=java.awt.Color[r=255,g=255,b=255]
win.frame.captionButtonHeight=18
win.frame.captionButtonWidth=18
win.frame.captionFont=java.awt.Font
[family=Tahoma,name=Tahoma,style=bold,size=11]
win.frame.captionFont.height=11
win.frame.captionGradientsOn=true
win.frame.captionHeight=18
win.frame.captionTextColor=java.awt.Color[r=255,g=255,b=255]
win.frame.color=java.awt.Color[r=0,g=0,b=0]
win.frame.fullWindowDragsOn=true
win.frame.inactiveBorderColor=java.awt.Color[r=212,g=208,b=200]
win.frame.inactiveCaptionColor=java.awt.Color[r=128,g=128,b=128]
win.frame.inactiveCaptionGradientColor=java.awt.Co lor[r=192,g=192,b=
192]
win.frame.inactiveCaptionTextColor=java.awt.Color[r=212,g=208,b=200]
win.frame.sizingBorderWidth=1
win.frame.smallCaptionButtonHeight=15
win.frame.smallCaptionButtonWidth=12
win.frame.smallCaptionFont=java.awt.Font
[family=Tahoma,name=Tahoma,style=bold,size=11]
win.frame.smallCaptionFont.height=11
win.frame.smallCaptionHeight=15
win.frame.textColor=java.awt.Color[r=0,g=0,b=0]
win.highContrast.on=false
win.icon.font=java.awt.Font
[family=Tahoma,name=Tahoma,style=plain,size=11]
win.icon.font.height=11
win.icon.hspacing=75
win.icon.titleWrappingOn=true
win.icon.vspacing=75
win.item.highlightColor=java.awt.Color[r=10,g=36,b=106]
win.item.highlightTextColor=java.awt.Color[r=255,g=255,b=255]
win.item.hotTrackedColor=java.awt.Color[r=0,g=0,b=128]
win.item.hotTrackingOn=true
win.mdi.backgroundColor=java.awt.Color[r=128,g=128,b=128]
win.menu.backgroundColor=java.awt.Color[r=212,g=208,b=200]
win.menu.buttonWidth=18
win.menu.font=java.awt.Font
[family=Tahoma,name=Tahoma,style=plain,size=11]
win.menu.font.height=11
win.menu.height=18
win.menu.keyboardCuesOn=false
win.menu.textColor=java.awt.Color[r=0,g=0,b=0]
win.messagebox.font=java.awt.Font
[family=Tahoma,name=Tahoma,style=plain,size=11]
win.messagebox.font.height=11
win.oemFixed.font=java.awt.Font
[family=dialog,name=Terminal,style=plain,size=12]
win.oemFixed.font.height=12
win.properties.version=2
win.scrollbar.backgroundColor=java.awt.Color[r=212,g=208,b=200]
win.scrollbar.height=16
win.scrollbar.width=16
win.sound.asterisk=WinPlaySound(SystemAsterisk)
win.sound.close=WinPlaySound(Close)
win.sound.default=WinPlaySound(.Default)
win.sound.exclamation=WinPlaySound(SystemExclamati on)
win.sound.exit=WinPlaySound(SystemExit)
win.sound.hand=WinPlaySound(SystemHand)
win.sound.maximize=WinPlaySound(Maximize)
win.sound.menuCommand=WinPlaySound(MenuCommand)
win.sound.menuPopup=WinPlaySound(MenuPopup)
win.sound.minimize=WinPlaySound(Minimize)
win.sound.open=WinPlaySound(Open)
win.sound.question=WinPlaySound(SystemQuestion)
win.sound.restoreDown=WinPlaySound(RestoreDown)
win.sound.restoreUp=WinPlaySound(RestoreUp)
win.sound.start=WinPlaySound(SystemStart)
win.status.font=java.awt.Font
[family=Tahoma,name=Tahoma,style=plain,size=11]
win.status.font.height=11
win.system.font=java.awt.Font
[family=dialog,name=System,style=bold,size=13]
win.system.font.height=13
win.systemFixed.font=java.awt.Font
[family=dialog,name=Fixedsys,style=plain,size=12]
win.systemFixed.font.height=12
win.text.fontSmoothingOn=false
win.text.grayedTextColor=java.awt.Color[r=128,g=128,b=128]
win.tooltip.backgroundColor=java.awt.Color[r=255,g=255,b=225]
win.tooltip.font=java.awt.Font
[family=Tahoma,name=Tahoma,style=plain,size=11]
win.tooltip.font.height=11
win.tooltip.textColor=java.awt.Color[r=0,g=0,b=0]
win.xpstyle.themeActive=false



+-------------+
| Java VM |
+-------------+

Total memory: 2031616
Free memory: 1005904
System properties:
asa.location=C:\PROGRA~2\Sybase\SQLANY~1\
awt.toolkit=sun.awt.windows.WToolkit
file.encoding=Cp437
file.encoding.pkg=sun.io
file.separator=\
isql.commandShell="C:\Windows\SysWOW64\cmd.exe /c"
isql.helpFolder=C:\PROGRA~2\Sybase\SQLANY~1\java
java.awt.graphicsenv=sun.awt.Win32GraphicsEnvironm ent
java.awt.printerjob=sun.awt.windows.WPrinterJob
java.class.path=C:\PROGRA~2\Sybase\SQLANY~1\java\i sql.jar;C:\PROGRA~
2\Sybase\Shared\JCONNE~1\classes\jconn2.jar;C:\PRO GRA~2\Sybase\SQLANY~1
\java\jlogon.jar;"UNC\nellie2\dbase\WRA\jodbc.jar" ;C:\PROGRA~2\Sybase
\Shared\java\SCEDIT~1.JAR;C:\PROGRA~2\Sybase\Share d\java\JCOMPO~1.JAR;C:
\PROGRA~2\Sybase\Shared\java\JSYBLI~1.JAR;C:\PROGR A~2\Sybase\Shared\Sun
\JAVAHE~1\jh.jar;C:\PROGRA~2\Sybase\Shared\java\HE LPMA~1.JAR;C:\PROGRA~2
\Sybase\SQLANY~1\java\xerces.jar;C:\PROGRA~2\Sybas e\SQLANY~1\java
\xml4j.jar;
java.class.version=48.0
java.endorsed.dirs=C:\Program Files (x86)\Sybase\Shared\sun\jre142
\lib\endorsed
java.ext.dirs=C:\Program Files (x86)\Sybase\Shared\sun\jre142\lib
\ext
java.home=C:\Program Files (x86)\Sybase\Shared\sun\jre142
java.io.tmpdir=C:\Users\davek.WRA\AppData\Local\Te mp\
java.library.path=C:\Program Files (x86)\Sybase\SQL Anywhere 9
\win32;.;C:\Windows\system32;C:\Windows;C:\Windows \system32;C:
\Windows;C:\Windows\System32\Wbem;C:\Windows\Syste m32\WindowsPowerShell
\v1.0\;c:\Program Files (x86)\ATI Technologies\ATI.ACE\Core-Static;C:
\Program Files (x86)\Common Files\Roxio Shared\DLLShared\;C:\Program
Files (x86)\Sybase\SQL Anywhere 9\win32;C:\Program Files (x86)\Sybase
\Shared\win32;C:\Program Files (x86)\Sybase\SQL Anywhere 9\drivers;C:
\Program Files (x86)\Sybase\Shared\Sybase Central 4.3\win32;C:\Program
Files\TortoiseSVN\bin;C:\Program Files (x86)\IDM Computer Solutions
\UltraEdit\
java.runtime.name=Java(TM) 2 Runtime Environment, Standard Edition
java.runtime.version=1.4.2_18-b06
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 .WindowsPreferencesFac
tory
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_18
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_18-b06

javax.accessibility.assistive_technologies=com.sun .java.accessibility.Ac
cessBridge
line.separator=

os.arch=x86
os.name=Windows Vista
os.version=6.1
path=C:\PROGRA~2\Sybase\SQLANY~1\win32;C:\PROGRA~2 \Sybase\Shared\Sun
\jre142\bin;C:\Windows\SysWOW64;C:\Windows;C:\Wind ows\SysWOW64\wbem;C:
\Windows\SysWOW64\WINDOW~1\v1.0;C:\PROGRA~2\ATITEC ~1\ATI.ACE\CORE-S~1;C:
\PROGRA~2\COMMON~1\ROXIOS~1\DLLSHA~1;C:\PROGRA~2\S ybase\SQLANY~1
\win32;C:\PROGRA~2\Sybase\Shared\win32;C:\PROGRA~2 \Sybase\SQLANY~1
\drivers;C:\PROGRA~2\Sybase\Shared\SYBASE~1.3\win3 2;C:\PROGRA~1\TORTOI~1
\bin;C:\PROGRA~2\IDMCOM~1\ULTRAE~1
path.separator=;
sqlpath=
sun.arch.data.model=32
sun.boot.class.path=C:\Program Files (x86)\Sybase\Shared\sun\jre142
\lib\rt.jar;C:\Program Files (x86)\Sybase\Shared\sun\jre142\lib
\i18n.jar;C:\Program Files (x86)\Sybase\Shared\sun\jre142\lib
\sunrsasign.jar;C:\Program Files (x86)\Sybase\Shared\sun\jre142\lib
\jsse.jar;C:\Program Files (x86)\Sybase\Shared\sun\jre142\lib\jce.jar;C:
\Program Files (x86)\Sybase\Shared\sun\jre142\lib\charsets.jar;C:
\Program Files (x86)\Sybase\Shared\sun\jre142\classes
sun.boot.library.path=C:\Program Files (x86)\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=
sybase.jsyblib.dll.location=C:\PROGRA~2\Sybase\Sha red\win32\
user.country=US
user.dir=M:\WRA
user.home=C:\Users\davek.WRA
user.language=en
user.name=davek
user.timezone=America/New_York
user.variant=


+-------------------+
| Java Packages |
+-------------------+

Package: com.sun.java.accessibility
Implementation title: null
Implementation vendor: null
Implementation version: null
Specification title: null
Specification vendor: null
Specification version: null

Package: com.sun.java.accessibility.util
Implementation title: null
Implementation vendor: null
Implementation version: null
Specification title: null
Specification vendor: null
Specification version: null

Package: com.sybase.asa.logon
Implementation title: JDBC Connection Library
Implementation vendor: Sybase, Inc.
Implementation version: 9.0.2.3886
Specification title: JDBC Connection Library
Specification vendor: Sybase, Inc.
Specification version: 9.0.2.3886

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.util
Implementation title: Application-Independent Java Utility Library
Implementation vendor: Sybase, Inc.
Implementation version: 4.3.0.2470
Specification title: Application-Independent Java Utility Library
Specification vendor: Sybase, Inc.
Specification version: 4.3.0.2470

Package: com.sybase.util.win32
Implementation title: Application-Independent Java Utility Library
Implementation vendor: Sybase, Inc.
Implementation version: 4.3.0.2470
Specification title: Application-Independent Java Utility Library
Specification vendor: Sybase, Inc.
Specification version: 4.3.0.2470

Package: java.awt
Implementation title: Java Runtime Environment
Implementation vendor: Sun Microsystems, Inc.
Implementation version: 1.4.2_18
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_18
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_18
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_18
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_18
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_18
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_18
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_18
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_18
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_18
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_18
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_18
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_18
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_18
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_18
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_18
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_18
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_18
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_18
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_18
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_18
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_18
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_18
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_18
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_18
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_18
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_18
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_18
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_18
Specification title: Java Platform API Specification
Specification vendor: Sun Microsystems, Inc.
Specification version: 1.4

Package: javax.swing.plaf.metal
Implementation title: Java Runtime Environment
Implementation vendor: Sun Microsystems, Inc.
Implementation version: 1.4.2_18
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_18
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_18
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_18
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_18
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_18
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_18
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_18
Specification title: Java Platform API Specification
Specification vendor: Sun Microsystems, Inc.
Specification version: 1.4

Package: sun.io
Implementation title: null
Implementation vendor: null
Implementation version: null
Specification title: null
Specification vendor: null
Specification version: null

Package: sun.java2d
Implementation title: Java Runtime Environment
Implementation vendor: Sun Microsystems, Inc.
Implementation version: 1.4.2_18
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_18
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_18
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_18
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_18
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_18
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_18
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_18
Specification title: Java Platform API Specification
Specification vendor: Sun Microsystems, Inc.
Specification version: 1.4

Package: sun.nio.cs.ext
Implementation title: null
Implementation vendor: null
Implementation version: null
Specification title: null
Specification vendor: null
Specification version: null

Package: sun.reflect
Implementation title: Java Runtime Environment
Implementation vendor: Sun Microsystems, Inc.
Implementation version: 1.4.2_18
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_18
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_18
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_18
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_18
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_18
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.3886
Specification title: Interactive SQL
Specification vendor: Sybase, Inc.
Specification version: 9.0.2.3886





All the environment variables are assigned, because when I copy the
command from the command window, I get the result listed first above,
which works fine in the GUI.

Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.