Re: script bug??...unexpected token: NULLS

You are using an earlier version of HSQLDB to open the database that is
created with a more recent version.

You can just delete that line from the script.

Fred

On Tue, May 28, 2013, at 12:08, risaldeep wrote:
> Hello Fred,
> 
> i am using hsqldb to create embedded database and it execute
> successfully..
> but while fetching data it shows error as:
> org.hsqldb.HsqlException: error in script file line: 13 unexpected token:
> NULLS
> 
> *databasexxx.script *
> 
> SET DATABASE UNIQUE NAME HSQLDB3EEAC2775F
> SET DATABASE GC 0
> SET DATABASE DEFAULT RESULT MEMORY ROWS 0
> SET DATABASE EVENT LOG LEVEL 0
> SET DATABASE SQL NAMES FALSE
> SET DATABASE SQL REFERENCES FALSE
> SET DATABASE SQL SIZE TRUE
> SET DATABASE SQL TYPES FALSE
> SET DATABASE SQL TDC DELETE TRUE
> SET DATABASE SQL TDC UPDATE TRUE
> SET DATABASE SQL TRANSLATE TTI TYPES TRUE
> SET DATABASE SQL CONCAT NULLS TRUE
> /SET DATABASE SQL NULLS FIRST TRUE/ 13th position of script
> SET DATABASE SQL UNIQUE NULLS TRUE
> SET DATABASE SQL CONVERT TRUNCATE TRUE
> SET DATABASE SQL AVG SCALE 0
> SET DATABASE SQL DOUBLE NAN TRUE
> SET DATABASE SQL LONGVAR IS LOB FALSE
> SET DATABASE TRANSACTION CONTROL LOCKS
> SET DATABASE DEFAULT ISOLATION LEVEL READ COMMITTED
> 
> 
> plzzz any suggestion!!
> 
> Deep
> 
> 
> 
> --
> View this message in context:
> http://hsqldb.10974.n7.nabble.com/script-bug-unexpected-token-NULLS-tp3900.html
> Sent from the HSQLDB - User mailing list archive at Nabble.com.
> 
> ------------------------------------------------------------------------------
> Try New Relic Now & We'll Send You this Cool Shirt
> New Relic is the only SaaS-based application performance monitoring
> service 
> that delivers powerful full stack analytics. Optimize and monitor your
> browser, app, & servers with just a few lines of code. Try New Relic
> and get this awesome Nerd Life shirt!
> http://p.sf.net/sfu/newrelic_d2d_may
> _______________________________________________
> Hsqldb-user mailing list
> [email protected]
> https://lists.sourceforge.net/lists/listinfo/hsqldb-user

------------------------------------------------------------------------------
Try New Relic Now & We'll Send You this Cool Shirt
New Relic is the only SaaS-based application performance monitoring service 
that delivers powerful full stack analytics. Optimize and monitor your
browser, app, & servers with just a few lines of code. Try New Relic
and get this awesome Nerd Life shirt! http://p.sf.net/sfu/newrelic_d2d_may