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

Hello Fred,
Thank you very much...


-Deep



On Tue, May 28, 2013 at 7:25 PM, Fred Toussi <[email protected]>wrote:

> 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
> _______________________________________________
> Hsqldb-user mailing list
> [email protected]
> https://lists.sourceforge.net/lists/listinfo/hsqldb-user
>

------------------------------------------------------------------------------
Introducing AppDynamics Lite, a free troubleshooting tool for Java/.NET
Get 100% visibility into your production application - at no cost.
Code-level diagnostics for performance bottlenecks with <2% overhead
Download for free and get started troubleshooting in minutes.
http://p.sf.net/sfu/appdyn_d2d_ap1

_______________________________________________
Hsqldb-user mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/hsqldb-user