Sybase NNTP forums - End Of Life (EOL)

The NNTP forums from Sybase - forums.sybase.com - are now closed.

All new questions should be directed to the appropriate forum at the SAP Community Network (SCN).

Individual products have links to the respective forums on SCN, or you can go to SCN and search for your product in the search box (upper right corner) to find your specific developer center.

dbisql.exe -nogui memory

2 posts in General Discussion Last posting was on 2004-10-06 12:45:29.0Z
Jamin Dunivan Posted on 2004-10-05 15:57:46.0Z
Sender: 1685.4162c30e.1804289383@sybase.com
From: Jamin Dunivan
Newsgroups: ianywhere.public.general
Subject: dbisql.exe -nogui memory
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <4162c477.16ad.1681692777@sybase.com>
MIME-Version: 1.0
Content-Type: multipart/mixed; boundary="-=_forums-2-dub4162c477"
X-Original-NNTP-Posting-Host: 10.22.241.42
X-Original-Trace: 5 Oct 2004 08:57:43 -0700, 10.22.241.42
Lines: 347
X-Original-NNTP-Posting-Host: forums-2-dub.sybase.com
X-Original-Trace: 5 Oct 2004 08:57:44 -0700, forums-2-dub.sybase.com
NNTP-Posting-Host: forums-master.sybase.com
X-Original-NNTP-Posting-Host: forums-master.sybase.com
Date: 5 Oct 2004 08:57:46 -0700
X-Trace: forums-1-dub 1096991866 10.22.108.75 (5 Oct 2004 08:57:46 -0700)
X-Original-Trace: 5 Oct 2004 08:57:46 -0700, forums-master.sybase.com
X-Authenticated-User: ngsysop
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:3704
Article PK: 7606

I keep getting an out of memory error when I use dbisql.exe
in nogui mode. I can run the statement fine in the gui
version. The statement is this: select * from
AppliedScheduleView; output to 'C:\Documents And
Settings\Jdunivan\Desktop\Wosyst1
Build\AppliedScheduleView.dbf' format foxpro;
The foxpro file is about 29MB and the memo file is about
2MB.

Any suggestions?
THanks
Jamin

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

Current thread: Database interface thread
java.lang.OutOfMemoryError
<<no stack trace available>>



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

Tue Oct 05 10:43:55 CDT 2004
ISQL version = 8.0.2, Build 3601
CommandLineOptions
ConnectionInfo: DSN=wosystclient;<JDBCDRIVER>=ianywhere.ml.jdbcodbc.IDriver
Command tail: read sql.txt
Initial SQL statement: (none)
Execute initial SQL statement: No
Use GUI: No
Quiet mode is: On
Syntax check mode is: Off

ConnectionInfo for active connection: DSN=wosystclient;UID=dba;PWD=blue22sky;<JDBCDRIVER>=ianywhere.ml.jdbcodbc.IDriver
Connection name: wosyst4srv (dba) on wosyst4srv
Last executed SQL statement: select * from AppliedScheduleView
Currently executing statements: read sql.txt;

Current parser state:
Input file: sql.txt
Current token: "foxpro", kind=126
Current token location: File: "sql.txt" on line 1, column 136


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

Total memory: 66846720
Free memory: 65312368
System properties:
asa.location=C:\PROGRA~1\Sybase\SQLANY~1\
awt.toolkit=sun.awt.windows.WToolkit
file.encoding=Cp437
file.encoding.pkg=sun.io
file.separator=\
isql.commandShell="C:\WINNT\system32\cmd.exe /c"
isql.helpFolder=C:\PROGRA~1\Sybase\SQLANY~1\java
java.awt.fonts=
java.awt.graphicsenv=sun.awt.Win32GraphicsEnvironment
java.awt.printerjob=sun.awt.windows.WPrinterJob
java.class.path=C:\PROGRA~1\Sybase\SQLANY~1\java\isql.jar;C:\PROGRA~1\Sybase\SQLANY~1\shared\JCONNE~2\classes\jconn2.jar;C:\PROGRA~1\Sybase\SQLANY~1\java\jlogon.jar;C:\PROGRA~1\Sybase\SQLANY~1\java\jodbc.jar;C:\PROGRA~1\Sybase\SQLANY~1\shared\java\SCEDIT~1.JAR;C:\PROGRA~1\Sybase\SQLANY~1\shared\java\JCOMPO~1.JAR;C:\PROGRA~1\Sybase\SQLANY~1\shared\java\JSYBLI~1.JAR;C:\PROGRA~1\Sybase\SQLANY~1\shared\sun\JAVAHE~1\jh.jar;C:\PROGRA~1\Sybase\SQLANY~1\shared\java\HELPMA~1.JAR;C:\PROGRA~1\Sybase\SQLANY~1\java\xerces.jar;C:\PROGRA~1\Sybase\SQLANY~1\java\xml4j.jar;
java.class.version=47.0
java.ext.dirs=C:\Program Files\Sybase\SQL Anywhere 8\shared\sun\jre131\lib\ext
java.home=C:\Program Files\Sybase\SQL Anywhere 8\shared\sun\jre131
java.io.tmpdir=C:\DOCUME~1\jdunivan\LOCALS~1\Temp\
java.library.path=C:\Documents and Settings\jdunivan\Desktop\WOSYST1 Build;.;C:\WINNT\system32;C:\WINNT;C:\Program Files\Sybase\SQL Anywhere 8\shared\sun\jre131\bin;C:\Perl\bin\;C:\Program Files\NMapWin\\bin;C:\WINNT\system32;C:\WINNT;C:\WINNT\System32\Wbem;C:\PROGRA~1\IBM\CLIENT~1;C:\PROGRA~1\IBM\CLIENT~1\Shared;C:\PROGRA~1\IBM\CLIENT~1\Emulator;;C:\imnet\Epwks;C:\imnet\Epwks\Reports;C:\imnet\obbroker;C:\mssql\bin;C:\Program Files\Sybase\SQL Anywhere 8\win32;C:\Program Files\Sybase\SQL Anywhere 8\shared\win32;C:\Program Files\Sybase\SQL Anywhere 8\shared\Sybase Central 4.1
java.runtime.name=Java(TM) 2 Runtime Environment, Standard Edition
java.runtime.version=1.3.1_01
java.specification.name=Java Platform API Specification
java.specification.vendor=Sun Microsystems Inc.
java.specification.version=1.3
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.3.1_01
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.3.1_01
line.separator=

os.arch=x86
os.name=Windows 2000
os.version=5.0
path=C:\PROGRA~1\Sybase\SQLANY~1\win32;C:\PROGRA~1\Sybase\SQLANY~1\shared\sun\jre131\bin;C:\Perl\bin\;C:\PROGRA~1\NMapWin\\bin;C:\WINNT\system32;C:\WINNT;C:\WINNT\System32\Wbem;C:\PROGRA~1\IBM\CLIENT~1;C:\PROGRA~1\IBM\CLIENT~1\Shared;C:\PROGRA~1\IBM\CLIENT~1\Emulator;C:\imnet\Epwks;C:\imnet\Epwks\Reports;C:\imnet\obbroker;C:\mssql\bin;C:\PROGRA~1\Sybase\SQLANY~1\win32;C:\PROGRA~1\Sybase\SQLANY~1\shared\win32;C:\PROGRA~1\Sybase\SQLANY~1\shared\SYBASE~1.1
path.separator=;
sqlpath=
sun.boot.class.path=C:\PROGRA~1\Sybase\SQLANY~1\shared\java\JRE131~1.JAR;C:\PROGRA~1\Sybase\SQLANY~1\shared\sun\jre131\lib\rt.jar;C:\PROGRA~1\Sybase\SQLANY~1\shared\sun\jre131\lib\i18n.jar
sun.boot.library.path=C:\Program Files\Sybase\SQL Anywhere 8\shared\sun\jre131\bin
sun.cpu.endian=little
sun.cpu.isalist=pentium i486 i386
sun.io.unicode.encoding=UnicodeLittle
sybase.jsyblib.dll.location=C:\PROGRA~1\Sybase\SQLANY~1\shared\win32\
user.dir=C:\Documents and Settings\jdunivan\Desktop\WOSYST1 Build
user.home=C:\Documents and Settings\jdunivan
user.language=en
user.name=jdunivan
user.region=US
user.timezone=America/Chicago


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

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

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: 13
Specification title: JComponents Library
Specification vendor: Sybase, Inc.
Specification version: 13

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: ianywhere.ml.jdbcodbc
Implementation title: null
Implementation vendor: null
Implementation version: null
Specification title: null
Specification vendor: null
Specification version: null

Package: java.awt
Implementation title: Java Runtime Environment
Implementation vendor: Sun Microsystems, Inc.
Implementation version: 1.3.1_01
Specification title: Java Platform API Specification
Specification vendor: Sun Microsystems, Inc.
Specification version: 1.3

Package: java.io
Implementation title: Java Runtime Environment
Implementation vendor: Sun Microsystems, Inc.
Implementation version: 1.3.1_01
Specification title: Java Platform API Specification
Specification vendor: Sun Microsystems, Inc.
Specification version: 1.3

Package: java.lang
Implementation title: Java Runtime Environment
Implementation vendor: Sun Microsystems, Inc.
Implementation version: 1.3.1_01
Specification title: Java Platform API Specification
Specification vendor: Sun Microsystems, Inc.
Specification version: 1.3

Package: java.lang.ref
Implementation title: Java Runtime Environment
Implementation vendor: Sun Microsystems, Inc.
Implementation version: 1.3.1_01
Specification title: Java Platform API Specification
Specification vendor: Sun Microsystems, Inc.
Specification version: 1.3

Package: java.lang.reflect
Implementation title: Java Runtime Environment
Implementation vendor: Sun Microsystems, Inc.
Implementation version: 1.3.1_01
Specification title: Java Platform API Specification
Specification vendor: Sun Microsystems, Inc.
Specification version: 1.3

Package: java.math
Implementation title: Java Runtime Environment
Implementation vendor: Sun Microsystems, Inc.
Implementation version: 1.3.1_01
Specification title: Java Platform API Specification
Specification vendor: Sun Microsystems, Inc.
Specification version: 1.3

Package: java.net
Implementation title: Java Runtime Environment
Implementation vendor: Sun Microsystems, Inc.
Implementation version: 1.3.1_01
Specification title: Java Platform API Specification
Specification vendor: Sun Microsystems, Inc.
Specification version: 1.3

Package: java.security
Implementation title: Java Runtime Environment
Implementation vendor: Sun Microsystems, Inc.
Implementation version: 1.3.1_01
Specification title: Java Platform API Specification
Specification vendor: Sun Microsystems, Inc.
Specification version: 1.3

Package: java.security.cert
Implementation title: Java Runtime Environment
Implementation vendor: Sun Microsystems, Inc.
Implementation version: 1.3.1_01
Specification title: Java Platform API Specification
Specification vendor: Sun Microsystems, Inc.
Specification version: 1.3

Package: java.sql
Implementation title: Java Runtime Environment
Implementation vendor: Sun Microsystems, Inc.
Implementation version: 1.3.1_01
Specification title: Java Platform API Specification
Specification vendor: Sun Microsystems, Inc.
Specification version: 1.3

Package: java.text
Implementation title: Java Runtime Environment
Implementation vendor: Sun Microsystems, Inc.
Implementation version: 1.3.1_01
Specification title: Java Platform API Specification
Specification vendor: Sun Microsystems, Inc.
Specification version: 1.3

Package: java.text.resources
Implementation title: Java Runtime Environment
Implementation vendor: Sun Microsystems, Inc.
Implementation version: 1.3.1_01
Specification title: Java Platform API Specification
Specification vendor: Sun Microsystems, Inc.
Specification version: 1.3

Package: java.util
Implementation title: Java Runtime Environment
Implementation vendor: Sun Microsystems, Inc.
Implementation version: 1.3.1_01
Specification title: Java Platform API Specification
Specification vendor: Sun Microsystems, Inc.
Specification version: 1.3

Package: java.util.jar
Implementation title: Java Runtime Environment
Implementation vendor: Sun Microsystems, Inc.
Implementation version: 1.3.1_01
Specification title: Java Platform API Specification
Specification vendor: Sun Microsystems, Inc.
Specification version: 1.3

Package: java.util.zip
Implementation title: Java Runtime Environment
Implementation vendor: Sun Microsystems, Inc.
Implementation version: 1.3.1_01
Specification title: Java Platform API Specification
Specification vendor: Sun Microsystems, Inc.
Specification version: 1.3

Package: javax.swing.event
Implementation title: Java Runtime Environment
Implementation vendor: Sun Microsystems, Inc.
Implementation version: 1.3.1_01
Specification title: Java Platform API Specification
Specification vendor: Sun Microsystems, Inc.
Specification version: 1.3

Package: sun.io
Implementation title: Java Runtime Environment
Implementation vendor: Sun Microsystems, Inc.
Implementation version: 1.3.1_01
Specification title: Java Platform API Specification
Specification vendor: Sun Microsystems, Inc.
Specification version: 1.3

Package: sun.misc
Implementation title: Java Runtime Environment
Implementation vendor: Sun Microsystems, Inc.
Implementation version: 1.3.1_01
Specification title: Java Platform API Specification
Specification vendor: Sun Microsystems, Inc.
Specification version: 1.3

Package: sun.net.www
Implementation title: Java Runtime Environment
Implementation vendor: Sun Microsystems, Inc.
Implementation version: 1.3.1_01
Specification title: Java Platform API Specification
Specification vendor: Sun Microsystems, Inc.
Specification version: 1.3

Package: sun.net.www.protocol.file
Implementation title: Java Runtime Environment
Implementation vendor: Sun Microsystems, Inc.
Implementation version: 1.3.1_01
Specification title: Java Platform API Specification
Specification vendor: Sun Microsystems, Inc.
Specification version: 1.3

Package: sun.net.www.protocol.jar
Implementation title: Java Runtime Environment
Implementation vendor: Sun Microsystems, Inc.
Implementation version: 1.3.1_01
Specification title: Java Platform API Specification
Specification vendor: Sun Microsystems, Inc.
Specification version: 1.3

Package: sun.security.action
Implementation title: Java Runtime Environment
Implementation vendor: Sun Microsystems, Inc.
Implementation version: 1.3.1_01
Specification title: Java Platform API Specification
Specification vendor: Sun Microsystems, Inc.
Specification version: 1.3

Package: sun.security.provider
Implementation title: Java Runtime Environment
Implementation vendor: Sun Microsystems, Inc.
Implementation version: 1.3.1_01
Specification title: Java Platform API Specification
Specification vendor: Sun Microsystems, Inc.
Specification version: 1.3

Package: sun.security.util
Implementation title: Java Runtime Environment
Implementation vendor: Sun Microsystems, Inc.
Implementation version: 1.3.1_01
Specification title: Java Platform API Specification
Specification vendor: Sun Microsystems, Inc.
Specification version: 1.3

Package: sybase.isql
Implementation title: Interactive SQL
Implementation vendor: Sybase, Inc.
Implementation version: 8.0.1
Specification title: Interactive SQL
Specification vendor: Sybase, Inc.
Specification version: 8.0.1


David Fishburn Posted on 2004-10-06 12:45:29.0Z
Newsgroups: ianywhere.public.general
Subject: Re: dbisql.exe -nogui memory
From: David Fishburn <fishburn_spam_off@ianywhere.com>
References: <4162c477.16ad.1681692777@sybase.com>
Organization: iAnywhere Solutions
Message-ID: <Xns957A59009CDB9fishburnsybasecom@10.22.241.106>
User-Agent: Xnews/06.08.25
NNTP-Posting-Host: vpn-concord-040.sybase.com
X-Original-NNTP-Posting-Host: vpn-concord-040.sybase.com
Date: 6 Oct 2004 05:45:29 -0700
X-Trace: forums-1-dub 1097066729 158.159.8.40 (6 Oct 2004 05:45:29 -0700)
X-Original-Trace: 6 Oct 2004 05:45:29 -0700, vpn-concord-040.sybase.com
Lines: 30
X-Authenticated-User: techsupp
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:3708
Article PK: 7608

Jamin Dunivan wrote in news:4162c477.16ad.1681692777@sybase.com of
ianywhere.public.general:

JD> Tue Oct 05 10:43:55 CDT 2004
JD> ISQL version = 8.0.2, Build 3601

You might want to try with the 8.0.2 current EBF to see if the problem
has already been resolved.

--
David Fishburn
Certified ASA Developer Version 8
iAnywhere Solutions - Sybase
Professional Services
Please only post to the newsgroup
Please ALWAYS include version and MORE importantly BUILD number with
EACH post (dbeng9 -v).

EBFs and Maintenance Releases
http://downloads.sybase.com/swx/sdmain.stm

Developer Community / Whitepapers
http://www.ianywhere.com/developer

CaseXpress - to report bugs
http://casexpress.sybase.com

CodeXchange - Free samples
http://ianywhere.codexchange.sybase.com/servlets/ProjectDocumentList