Make your own free website on Tripod.com

InstantDB Project
About InstantDB
Project Mail Lists
Short History
Reporting Bugs
Screen Shots
3rd Party Examples
FAQs

Software
Downloads
Documentation
CVS Repositories
Roadmap
License

About Enhydra.org
Who We Are
News, Articles & Events
Getting Involved
Contact Us

Community
Demos
Contributions
Resources
Case Studies
On The Edge! -NEW-
Commercial Vendors


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: InstantDB: SQL query does not run


I changed the prp file and tried again. I fear it didn't help. Here is the output
from commsql and the prp file

Microsoft(R) Windows NT(TM)
(C) Copyright 1985-1996 Microsoft Corp.

C:\>java commsql
Enter the url for the database
jdbc:idb:c:/chev20/chev20.prp
Enhydra InstantDB - Version 3.13
The Initial Developer of the Original Code is Lutris Technologies Inc.
Portions created by Lutris are Copyright (C) 1997-2000 Lutris Technologies, Inc.

All Rights Reserved.

Connected to jdbc:idb:c:/chev20/chev20.prp
Driver   InstantDB JDBC Driver
Version  Version 3.13

Enter SQL string, or . to exit
select
stf.nme_praefix, stf.bzc, mng.wrt, mng.enh,
knz.wrt, knz.enh, stf.agg, gfh.kb1, gfh.kb2, gfh.kb3,
stf.bgk, stf.wgk, rstkmb.rst1, rstkmb.rst2, rstkmb.rst3, rstkmb.rst4,
gbd.bzc, stc.bzc, rm.bzc, fchabt.bzc, ins.bzc, arb.bzc,
brb.vrn, brb.nch, vrnt.vrn, vrnt.nch
from
stf, mng, knz, gfh, rstkmb, gbd, stc, rm, fchabt, ins, arb, brb, vrnt, eintr
where
eintr.stfn = stf.stfn and
eintr.brbn = brb.brbn and
eintr.fchabtn = fchabt.fchabtn and
eintr.gbdn = gbd.gbdn and
fchabt.insn = ins.insn and
main select
stf.nme_praefix, stf.bzc, mng.wrt, mng.enh,
knz.wrt, knz.enh, stf.agg, gfh.kb1, gfh.kb2, gfh.kb3,
stf.bgk, stf.wgk, rstkmb.rst1, rstkmb.rst2, rstkmb.rst3, rstkmb.rst4,
gbd.bzc, stc.bzc, rm.bzc, fchabt.bzc, ins.bzc, arb.bzc,
brb.vrn, brb.nch, vrnt.vrn, vrnt.nch
from
stf, mng, knz, gfh, rstkmb, gbd, stc, rm, fchabt, ins, arb, brb, vrnt, eintr
where
eintr.stfn = stf.stfn and
eintr.brbn = brb.brbn and
eintr.fchabtn = fchabt.fchabtn and
eintr.gbdn = gbd.gbdn and
fchabt.insn = ins
main java.sql.SQLException: Illegal mixture of string/numeric.
java.sql.SQLException: Illegal mixture of string/numeric.
        at db.SQLProg.execute(SQLProg.java:275)
        at jdbc.idbStatement.execute(idbStatement.java, Compiled Code)
        at commsql.main(commsql.java, Compiled Code)
Enter SQL string, or . to exit
fchabt.arbn = arb.arbn and
gbd.stcn = stc.stcn and
gbd.rmn = rm.rmn and
stf.gfhn = gfh.gfhn and
stf.mngn = mng.mngn and
stf.rstkmbn = rstkmb.rstkmbn and
stf.knzn = knz.knzn and
eintr.vrntn = vrnt.vrntn and

C:\>eintr.eintrn = 31


!---------------------------------------------------------------------
!
! BASIC PROPERTIES
!
!---------------------------------------------------------------------

!
! Path where index tables are held. Can be absolute or relative
! to the properties file. Defaults to tablePath.
!
indexPath=./indexes
!
! Path where system tables are held. Can be absolute or relative to
! the properties file. Defaults to tablePath.
!
systemPath=./system
!
! Path where database tables are held. Can be absolute or relative
! to the properties file. Defaults to "current" directory.
!
tablePath=./tables
!
! Path where results set tables are held. Can be absolute or relative
! to the properties file. Defaults to tablePath.
!
tmpPath=./tmp
!
! Non-zero means paths are relative to the properties file.
! Default is absolute paths for files.
!
relativeToProperties=1
!
! Alternative partitions can be defined so that tables can be placed
! in multiple locations. Each partition is numbered: 1, 2, 3,... Tables
! can be created on partitions using the syntax
!
!   CREATE TABLE <name> ON PARTITION <number>...
!
! The partition count has to be supplied.
!
!partitionCount=2
!
! The locations of each partition must be supplied. These are always
! absolute path names.
!
!partition1=d:/petes
!partition2=c:/temp


!---------------------------------------------------------------------
!
! TUNING PROPERTIES
!
!---------------------------------------------------------------------

!
! The amount of each column to cache, expressed either as an absolute
! number of rows or as a percentage figure. Defaults to 256 or 10 respectively.
!
cacheAmount=512
!
! CACHE_ROWS Must be one of CACHE_ROWS or CACHE_PERCENT. Determines whether
! to cache columns in tables based on an absolute number of rows, or the
! percentage number of rows in the table.
!
cacheCondition=CACHE_ROWS
!
! The percentage cache hit improvement required in order to move the
! cache to a new location in a column.
!
! (Currently not implemented).
!
cacheResetPercent=10
!
! Non-zero means that database changes do not get written to the
! database immediately. See tuning.html.
!
fastUpdate=0
!
! Percentage of free space in an index that must be present before
! the index reorganises itself. High values means frequent index
! reorganisation. Low values means slow index inserts.
!
indexLoad=5
!
! The number of cache misses to include in calculations of the next
! base for the cache.
!
! (Currently not implemented).
!
missesInCacheStats=100
!
! Non-zero means that results sets get instantiated on disk. By default
! InstantDB holds results sets emtirely in memory (apart from Binary
! columns). For large resulst sets this can be a problem. This property
! forces all results sets to be held on disk.
!
resultsOnDisk=0
!
! Similar to cacheCondition but applies only to disk based
! results sets. Default is CACHE_ROWS.
!
resultsSetCache=CACHE_ROWS
!
! Similar to cacheAmount but applies only to disk based
! results sets. Default is 100.
!
resultsSetCacheAmount=100
!
! Number of rows to read into the disk look ahead buffer.
! Recommended to be set somewhere around 128 to 256.
! Default is 20.
!
rowCacheSize=128
!
! By default, InstantDB only does a cursory search for deleted rows during
! UPDATE statements. Setting searchDeletes=1 causes more detailed searches
! for deleted rows. This slows down UPDATE executions, but reults in more
! compact tables.  Default is 0.
!
searchDeletes=0
!
! The interval, in milliseconds, between checks for statement execution
! timeouts. Default is 5000.
!
!timerCheck=5000

!---------------------------------------------------------------------
!
! LOGGING AND DEBUGGING PROPERTIES
!
!---------------------------------------------------------------------

!
! Non-zero means include SQL statements in the export file.
!
exportSQL=0
!
! Non-zero means trace output also directed to console.
! Defaults to 0.
!
traceConsole=1
!
! Relative or absolute path where exporting and tracing goes.
!
traceFile=./trace.log
!
! Bitmap of various items that can be traced. See debug.html.
! Defaults to 0.
!
traceLevel=2

!---------------------------------------------------------------------
!
! TRANSACTION AND RECOVERY PROPERTIES
!
!---------------------------------------------------------------------

!
! 0 means do not perform recovery on startup.
! 1 means perform automatic recovery
! 2 (default) means prompt the user using standard in
!
recoveryPolicy=2
!
! Sets the level of transaction journalling. See trans.html.
! Defaults to 1.
!
! 0 - No journalling takes place.
! 1 - Normal journalling (default).
! 2 - Full journalling.
!
transLevel=1
!
! When doing an import, defines the number of rows imported
! before the transaction is committed. Recommended value 8192.
! defaults to 100.
!
transImports=100

!---------------------------------------------------------------------
!
! DATE, TIME AND CURRENCY PROPERTIES
!
!---------------------------------------------------------------------

!
! Number of digits after decimal point in currency outputs. Defaults to 2.
!
currencyDecimal=2
!
! Currency symbol used in currency outputs. Defaults to $.
!
currencySymbol=$
!
! Default format for date columns. Defaults to "yyyy-mm-dd".
!
dateFormat="yyyy-mm-dd"
!
! If set, then all two digit dates less than its value are interpreted
! as 21st century dates.
!
!milleniumBoundary=50
!
! Set to 1 causes the date string "now" to store a full timestamp.
! Default is to store only the date for fields with now hour in the
! format string.
!
nowMeansTime=0

!---------------------------------------------------------------------
!
! STRING HANDLING PROPERTIES
!
!---------------------------------------------------------------------

!
! If set to 1 then String hashes use the JDK Object.hashCode() function.
! By default, uses InstantDB's String hashing.
!
altStringHashing=0
!
! Set to 1 to cause LIKE clauses to always perform case insensitive
! comparisons.
!
likeIgnoreCase=0
!
! Same as SET LITERAL STRICT_ON. Prevents string literals being interpreted
! as column names or numbers. Default is 0.
!
strictLiterals=1
!
! Set this value to 1 (one) if you would like PreparedStatement.setString()
! to ignore "\" (backslash) characters when proceesing string constants.
! When set, InstantDB will not attempt to interpret \ as the start of an
! escape sequence. Default is 0.
!
!prepareIgnoresEscapes=1

!---------------------------------------------------------------------
!
! MISCELLANEOUS PROPERTIES
!
!---------------------------------------------------------------------

!
! Allows selected InstantDB keywords to be un-reserved.
! e.g. ignoreKeywords=url,quote would allow the keywords
! url and quote to be used as table or column names.
!
! This faciliy is provided for compatatbility reasons only.
! It's use is not recommended AND IS NOT SUPPORTED.
!
!ignoreKeywords
!
! Non-zero means database is opened in read only mode.
!
readOnly=0




Peter Hearty schrieb:

> Thomas
>
> The "Illegal mixture of string/numeric" can sometimes be caused by the
> problem described here:
>
> http://instantdb.enhydra.org/software/documentation/types.html#StringLiteral
> s
>
> Regards
>
> Peter Hearty
> Lutris Technologies UK Ltd.
> -----Original Message-----
> From: Thomas Vatter <thomas.vatter@blinx.de>
> To: instantDB@enhydra.org <instantDB@enhydra.org>
> Date: 01 July 2000 10:23
> Subject: Re: InstantDB: SQL query does not run
>
> >yes, i have got it. I have copied the sql string via clipboard to the
> commsql
> >prompt. (first tested ok against informix). Here is the output from
> commsql:
> >
> >Microsoft(R) Windows NT(TM)
> >(C) Copyright 1985-1996 Microsoft Corp.
> >
> >C:\>java commsql
> >Enter the url for the database
> >jdbc:idb:c:/chev20/chev20.prp
> >Enhydra InstantDB - Version 3.13
> >The Initial Developer of the Original Code is Lutris Technologies Inc.
> >Portions created by Lutris are Copyright (C) 1997-2000 Lutris Technologies,
> Inc.
> >
> >All Rights Reserved.
> >
> >Connected to jdbc:idb:c:/chev20/chev20.prp
> >Driver   InstantDB JDBC Driver
> >Version  Version 3.13
> >
> >Enter SQL string, or . to exit
> >select
> >stf.nme_praefix, stf.bzc, mng.wrt, mng.enh,
> >knz.wrt, knz.enh, stf.agg, gfh.kb1, gfh.kb2, gfh.kb3,
> >stf.bgk, stf.wgk, rstkmb.rst1, rstkmb.rst2, rstkmb.rst3, rstkmb.rst4,
> >gbd.bzc, stc.bzc, rm.bzc, fchabt.bzc, ins.bzc, arb.bzc,
> >brb.vrn, brb.nch, vrnt.vrn, vrnt.nch
> >from
> >stf, mng, knz, gfh, rstkmb, gbd, stc, rm, fchabt, ins, arb, brb, vrnt,
> eintr
> >where
> >eintr.stfn = stf.stfn and
> >eintr.brbn = brb.brbn and
> >eintr.fchabtn = fchabt.fchabtn and
> >eintr.gbdn = gbd.gbdn and
> >fchabt.insn = ins.insn and
> >main select
> >stf.nme_praefix, stf.bzc, mng.wrt, mng.enh,
> >knz.wrt, knz.enh, stf.agg, gfh.kb1, gfh.kb2, gfh.kb3,
> >stf.bgk, stf.wgk, rstkmb.rst1, rstkmb.rst2, rstkmb.rst3, rstkmb.rst4,
> >gbd.bzc, stc.bzc, rm.bzc, fchabt.bzc, ins.bzc, arb.bzc,
> >brb.vrn, brb.nch, vrnt.vrn, vrnt.nch
> >from
> >stf, mng, knz, gfh, rstkmb, gbd, stc, rm, fchabt, ins, arb, brb, vrnt,
> eintr
> >where
> >eintr.stfn = stf.stfn and
> >eintr.brbn = brb.brbn and
> >eintr.fchabtn = fchabt.fchabtn and
> >eintr.gbdn = gbd.gbdn and
> >fchabt.insn = ins
> >main java.sql.SQLException: Illegal mixture of string/numeric.
> >java.sql.SQLException: Illegal mixture of string/numeric.
> >        at db.SQLProg.execute(SQLProg.java:275)
> >        at jdbc.idbStatement.execute(idbStatement.java, Compiled Code)
> >        at commsql.main(commsql.java, Compiled Code)
> >Enter SQL string, or . to exit
> >fchabt.arbn = arb.arbn and
> >gbd.stcn = stc.stcn and
> >gbd.rmn = rm.rmn and
> >stf.gfhn = gfh.gfhn and
> >stf.mngn = mng.mngn and
> >stf.rstkmbn = rstkmb.rstkmbn and
> >stf.knzn = knz.knzn and
> >eintr.vrntn = vrnt.vrntn and
> >
> >C:\>eintr.eintrn = 31
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >Alok Daipuria schrieb:
> >
> >> you have to include idb.jar, idbf.jar, idbexmpl.jar in CLASSPATH. They
> >> are  in InstantDB/classes directory.
> >>   After that, run "java commsql"
> >> It'll ask for the url of the database.
> >> enter the url as :
> >>   jdbc:idb:/home/tech/alok/myapp/appdb.prp (or whatever is the path to
> >> you application.prp file)
> >>     Then you can run queries just as you run in ISQL or sqlplus.
> >>
> >> -alok
> >>
> >> Thomas Vatter wrote:
> >> >
> >> > i tried to, but did not find some description about commsql. when i
> >> > enter "java comsql" there is an sqlexception "no suitable driver".
> >> >
> >> > Alok Daipuria schrieb:
> >> >
> >> > > did you try running the query in commsql.
> >> > >
> >> > > -alok
> >> > > alok@yack.com
> >> > >
> >> > > Thomas Vatter wrote:
> >> > >
> >> > >> I have an sql select statement that does not run. No results are
> >> > >> returned, further exection of the program is stopped. After
> >> > >> "executeQuery()" , instantdb shows the query statement, and shows
> >> > >> no exceptions. Here is the query
> >> > >>
> >> > >> Select
> >> > >>
> >> > >>      eintr.eintrn, stf.nme_praefix, stf.bzc, mng.wrt,
> >> > >>      mng.enh, knz.wrt, knz.enh, stf.agg, gfh.kb1,
> >> > >>      gfh.kb2, gfh.kb3, rstkmb.rst1, rstkmb.rst2, rstkmb.rst3,
> >> > >>      rstkmb.rst4, stf.bgk, stf.wgk,
> >> > >>      gbd.bzc, stc.bzc, rm.bzc, fchabt.bzc, ins.bzc, arb.bzc,
> >> > >>      brb.vrn, brb.nch, eintr.doe, vrnt.vrn, vrnt.nch
> >> > >>
> >> > >> from
> >> > >>
> >> > >>      eintr, stf, mng, knz, gfh, rstkmb, gbd, stc, rm, fchabt,
> >> > >>      ins, arb, brb, vrnt
> >> > >>
> >> > >> where
> >> > >>
> >> > >>      dor is null and doa is null and unme <> "zxy" and
> >> > >>      eintr.stfn = stf.stfn and
> >> > >>      eintr.brbn = brb.brbn and
> >> > >>      eintr.fchabtn = fchabt.fchabtn and
> >> > >>      eintr.gbdn = gbd.gbdn and
> >> > >>      fchabt.insn = ins.insn and
> >> > >>      fchabt.arbn = arb.arbn and
> >> > >>      gbd.stcn = stc.stcn and
> >> > >>      gbd.rmn = rm.rmn and
> >> > >>      stf.gfhn = gfh.gfhn and
> >> > >>      stf.mngn = mng.mngn and
> >> > >>      stf.rstkmbn = rstkmb.rstkmbn and
> >> > >>      stf.knzn = knz.knzn
> >> > >>
> >> > >> order by
> >> > >>
> >> > >>      stf.bzc, stf.nme_praefix, stf.agg asc, mng.wrt desc,
> >> > >>      gfh.kb1, gfh.kb2, gfh.kb3, rstkmb.rst1, rstkmb.rst2,
> >> > >>      rstkmb.rst3, rstkmb.rst4, stf.bgk, stf.wgk
> >> > >>
> >> > >
> >> > >
> >> -------------------------------------------------------------------------
> ----
> >> To unsubscribe from this mailing list, send email to
> majordomo@enhydra.org
> >> with the text "unsubscribe instantdb" in the body of the email.
> >> If you have other questions regarding this mailing list, send email to
> >> the list admin at owner-instantdb@enhydra.org.
> >
> >---------------------------------------------------------------------------
> --
> >To unsubscribe from this mailing list, send email to majordomo@enhydra.org
> >with the text "unsubscribe instantdb" in the body of the email.
> >If you have other questions regarding this mailing list, send email to
> >the list admin at owner-instantdb@enhydra.org.
>
> -----------------------------------------------------------------------------
> To unsubscribe from this mailing list, send email to majordomo@enhydra.org
> with the text "unsubscribe instantdb" in the body of the email.
> If you have other questions regarding this mailing list, send email to
> the list admin at owner-instantdb@enhydra.org.

-----------------------------------------------------------------------------
To unsubscribe from this mailing list, send email to majordomo@enhydra.org
with the text "unsubscribe instantdb" in the body of the email.
If you have other questions regarding this mailing list, send email to
the list admin at owner-instantdb@enhydra.org.