File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
The moose likes JForum and the fly likes java.sql.SQLException: S1000 General error java.util.NoSuchElementException Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Products » JForum
Bookmark "java.sql.SQLException: S1000 General error java.util.NoSuchElementException" Watch "java.sql.SQLException: S1000 General error java.util.NoSuchElementException" New topic
Author

java.sql.SQLException: S1000 General error java.util.NoSuchElementException

Migrated From Jforum.net
Ranch Hand

Joined: Apr 22, 2012
Posts: 17424
Hi,

I am using hsql database as my back end. Now i go to Forums > Messages > Banning > Insert New. I put some value type(either userid,email id or ip address) in the text box provided and click on Update. The error i get is as follows:

Caused by: qlc.forums.exceptions.DatabaseException: java.sql.SQLException: S1000 General error java.util.NoSuchElementException
at org.hsqldb.jdbc.Util.throwError(Unknown Source)
at org.hsqldb.jdbc.jdbcPreparedStatement.<init>(Unknown Source)
at org.hsqldb.jdbc.jdbcConnection.prepareStatement(Unknown Source)

[originally posted on jforum.net by neelima]
Migrated From Jforum.net
Ranch Hand

Joined: Apr 22, 2012
Posts: 17424
Sorry, we don't support customized code problems (e.g. the trace log says your package is qlc.forums, not org.jforum...).

Please install a default installations and verify that this problem exists in the default code base.
[originally posted on jforum.net by monroe]
Migrated From Jforum.net
Ranch Hand

Joined: Apr 22, 2012
Posts: 17424
Thank you for the prompt reply

Kindly note that we have also tested the same with default installations and this problem does exist there also(in the default code base). When we go to Forums > Messages > Banning > Insert New (when i use hsql database as back end, works fine with mysql though) and put some value type(either userid,email id or ip address) in the text box provided and click on Update. It shows the following error on the UI :

"An error has occurred.

For detailed error information, please see the HTML source code, and contact the forum Administrator.

java.sql.SQLException: S1000 General error java.util.NoSuchElementException"




[originally posted on jforum.net by neelima]
 
It is sorta covered in the JavaRanch Style Guide.
 
subject: java.sql.SQLException: S1000 General error java.util.NoSuchElementException