Quantcast

script bug??...unexpected token: NULLS

classic Classic list List threaded Threaded
3 messages Options
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

script bug??...unexpected token: NULLS

keithaniz
This post was updated on .
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 line of script file
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
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

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

Fred Toussi-2
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
> [hidden email]
> 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
[hidden email]
https://lists.sourceforge.net/lists/listinfo/hsqldb-user
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

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

keithaniz
Hello Fred,
Thank you very much...


-Deep



On Tue, May 28, 2013 at 7:25 PM, Fred Toussi <[hidden email]> 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
> [hidden email]
> 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
[hidden email]
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
[hidden email]
https://lists.sourceforge.net/lists/listinfo/hsqldb-user
Loading...