I’ve gobbled together a basic Powershell script to query W10’s Windows Desktop Search (WDS) index. Here is the relevant bits, Until now my tests have been using single words and everything works. But when I started using two words, it falls apart with the following error, Using Explorer to query t…
Tag: exception
Socket closed inside XWM
I have an SQL exception inside a piece of code that works under and scheduled process every day. The patch of code is as follows: There should be no connection problems with this but today i have a socket closed exception in my log in: Here is my log: Any thoughts about why this could happen? First time this …
F# Query Exception, “unrecognized method call value”
Q: What does the following exception mean? I’m attempting to translate a Pervasive SQL query to an F# query using SqlDataProvider with an ODBC connection, building up slowly bit by bit. I’m getting an exception with the following query with a somewhat cryptic exception. When the printfn statement …
How to retrieve SQL Error message with Hibernate
I have developed a small application accessing a PostgreSQL database with Hibernate. When I try to delete a record involved in a foreign key with another table, a javax.persistence….
Writing plsql exception errors to DMBS_OUTPUT and FND_FILE job log
I have a MERGE/UPDATE statement. I want to add exception handling such that if the update fails for any reason, write to DBMS_output and job log. I’ve come up with something – it compiles OK, but …
Query through PreparedStatement in H2 throws exception: This method is not allowed for a prepared statement; use a regular statement instead
A simple query fails when run through a prepared statement while using JDBC 4 to access an H2 database in Java 11. When running this line: try ( ResultSet rs = pstmt.executeQuery( sql ) ; ) { …I …
SQL exception preparing query with ORMLite
I am using an ORM (ORMlite) and all my calls are going well until I get the following error. Exception in thread “main” org.h2.jdbc.JdbcSQLException: Syntax error in SQL statement ” SELECT * …