java.sql.SQLException: Failed to parse: Stopped parse at 447970942E9
at com.hxtt.global.SQLState.SQLException(Unknown Source)
at com.hxtt.a.b.a(Unknown Source)
at com.hxtt.a.b.a(Unknown Source)
at com.hxtt.a.b.f(Unknown Source)
at com.hxtt.sql.b0.a(Unknown Source)
at com.hxtt.sql.b0.(Unknown Source)
at com.hxtt.sql.y.do(Unknown Source)
at com.hxtt.sql.y.if(Unknown Source)
at com.hxtt.sql.y.executeQuery(Unknown Source)
at Retail.executeBusinessRules(Retail.java:142)
Got the above error on this statement.
res = stmt.executeQuery(
"Select TransactionID, 'PAYMENT' as type from Checks " +
"where GlobalBatchID=" + GlobalBatchID + " order by CheckSequence " +
"union " +
"Select TransactionID, 'CORRESPONDENCE PFS' as type from Documents " +
"where GlobalBatchID=" + GlobalBatchID + " " +
"and TransactionID not in " +
"(Select TransactionID from Checks " +
"where GlobalBatchID=" + GlobalBatchID + ")");
This actually work using native sun JDBC driver. Thanks for any help you can provide.
|
That's resulted by 447970942E9 value. You can try:
stmt=con.prepareStatement(
"Select TransactionID, 'PAYMENT' as type from Checks " +
"where GlobalBatchID=? order by CheckSequence " +
"union " +
"Select TransactionID, 'CORRESPONDENCE PFS' as type from Documents " +
"where GlobalBatchID=? " +
"and TransactionID not in " +
"(Select TransactionID from Checks " +
"where GlobalBatchID=?)");
stmt.setInt(1,GlobalBatchID);
stmt.setInt(2,GlobalBatchID);
stmt.setInt(3,GlobalBatchID);
res = stmt.executeQuery();
We will provide a latest package which supports your 447970942E9 value too in 48 hours. Thanks for your patience.
|
|
Please download the latest package which has supported 447970942E9 value.
|
|
All but only three of packages are corrupted. Please repost packages.
|
|
We have reposted all packages.Please download the latest HXTT packages.
|
Select TransactionID, 'PAYMENT' as type from Checks where GlobalBatchID=524848319
UNION
Select TransactionID, 'CORRESPONDENCE PFS' as type from Documents where (GlobalBatchID=524848319
and
TransactionID not in (Select TransactionID from Checks where GlobalBatchID=524848319))
Above sql statement works in jdbc but not in our driver. I get the following error. With hxtt driver, the individual query work fine, but errored when "UNION" is used with the statement.
java.sql.SQLException: java.lang.NullPointerException
at com.hxtt.global.SQLState.SQLException(Unknown Source)
at com.hxtt.sql.a4.a(Unknown Source)
at com.hxtt.sql.x.a(Unknown Source)
at com.hxtt.sql.x.if(Unknown Source)
at com.hxtt.sql.x.executeQuery(Unknown Source)
at BankRetail.executeBusinessRules(BankRetail.java:156)
Thanks
|
Select TransactionID, 'PAYMENT' as type from Checks where GlobalBatchID=524848319
UNION
Select TransactionID, 'CORRESPONDENCE PFS' as type from Documents where (GlobalBatchID=524848319
and
TransactionID not in (Select TransactionID from Checks where GlobalBatchID=524848319))
I'm getting a different error for this statement.
java.sql.SQLException: java.lang.NullPointerException
at com.hxtt.global.SQLState.SQLException(Unknown Source)
at com.hxtt.sql.a4.a(Unknown Source)
at com.hxtt.sql.x.a(Unknown Source)
at com.hxtt.sql.x.if(Unknown Source)
at com.hxtt.sql.x.executeQuery(Unknown Source)
at Retail.executeBusinessRules(Retail.java:156)
The individual query work by themself until paired together with UNION.
|
>The individual query work by themself until paired together with UNION.
Supported subquery in UNION. Please download the latest package. Thanks for your response.
|
Main
webmaster@hxtt.com