Closed. This question needs details or clarity. It is not currently accepting answers. Want to improve this question? Add details and clarify the problem by editing this post. Closed 11 months ago. The community reviewed whether to reopen this question 3 months ago and left it closed: Original close reason(s)…
Tag: hsqldb
Is there way to set default as null for SQL parameter?
I have a code that creates sql parameters using MapSqlParameterSource. Here is my code: Basically, if account type is spoofer, I have to have user id instead of account id. However, I don’t like that I have to set account_id and user_id to null when I instantiate parameters. Is there way to set account_…
Java common JDBC SQL Query strategy for Unit Test using HSQLDB and runtime using MySQL
I am developing Java Vert.x 3 application. I use HSQLDB for testing with in-memory DB and MySQL 8.0.20 for runtime. When the vertx verticle is deployed, it initializes the db and tables. Since this is a common code and there are differing SQL syntax between HSQLDB and MySQL and more ridiculously, the HSQLDB c…
Encrypted (base64) password not storing in database hsql
I’m trying to simply store an base64 encripted password in database from an input in Java Web App. I’m using hsqldb for this and my password column type is varbinary(255). But when I try to store it in database I just get the error below. I even tried to change the type of the password column to B…