Re: HSQLDB 2.3.0 snapshot jar is available

Hello Fred,


I have used all 2.2.x version to support to_date,to_timestamp in build
function but it's not working and finally i tried this latest beta version
2.3.0 ,still those function are not supporting...

Also complex subquery are also not supporting..what might be the
problem...???

Error:
Caused by: java.sql.SQLSyntaxErrorException: unexpected token: TO_DATE :
line: 12778
	at org.hsqldb.jdbc.JDBCUtil.sqlException(Unknown Source)
	at org.hsqldb.jdbc.JDBCUtil.sqlException(Unknown Source)
	at org.hsqldb.jdbc.JDBCStatement.fetchResult(Unknown Source)
	at org.hsqldb.jdbc.JDBCStatement.execute(Unknown Source)
	at org.codehaus.mojo.sql.SqlExecMojo.execSQL(SqlExecMojo.java:1056)
	at org.codehaus.mojo.sql.SqlExecMojo.runStatements(SqlExecMojo.java:1018)
	at org.codehaus.mojo.sql.SqlExecMojo.access$200(SqlExecMojo.java:68)
	at
org.codehaus.mojo.sql.SqlExecMojo$Transaction.runTransaction(SqlExecMojo.java:1252)
	at
org.codehaus.mojo.sql.SqlExecMojo$Transaction.access$100(SqlExecMojo.java:1199)
	at org.codehaus.mojo.sql.SqlExecMojo.execute(SqlExecMojo.java:647)
	... 21 more
Caused by: org.hsqldb.HsqlException: unexpected token: TO_DATE : line: 12778
	at org.hsqldb.error.Error.parseError(Unknown Source)
	at org.hsqldb.ParserBase.unexpectedToken(Unknown Source)
	at org.hsqldb.ParserRoutine.readDefaultClause(Unknown Source)
	.....
Please any suggestion!!!



--
View this message in context: http://hsqldb.10974.n7.nabble.com/HSQLDB-2-3-0-snapshot-jar-is-available-tp1798p3890.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