Stack trace: org.h2.jdbc.JdbcSQLException: Hexadecimal string contains non-hex character: "-psn_0_61455" [90004-176] at org.h2.message.DbException.getJdbcSQLException(DbException.java:344) at org.h2.message.DbException.get(DbException.java:178) at org.h2.message.DbException.get(DbException.java:154) at org.h2.util.StringUtils.convertHexToBytes(StringUtils.java:963) at org.h2.engine.ConnectionInfo.hashPassword(ConnectionInfo.java:324) at org.h2.engine.ConnectionInfo.convertPasswords(ConnectionInfo.java:316) at org.h2.engine.ConnectionInfo.<init>(ConnectionInfo.java:80) at org.h2.jdbc.JdbcConnection.<init>(JdbcConnection.java:91) at org.h2.Driver.connect(Driver.java:74) at java.sql.DriverManager.getConnection(DriverManager.java:664) at java.sql.DriverManager.getConnection(DriverManager.java:247)
I use password hash, and wonder if the problem could be that the hash contains some unwanted characters. Are there any constraints in H2 with the hash, e.g. fixed string length? Best regards, Johan On Wednesday, March 1, 2017 at 12:57:48 PM UTC+1, Thomas Mueller Graf wrote: > > Hi, > > Could you post the exception stack trace please? > > Regards, > Thomas > > On Wed, Mar 1, 2017 at 11:27 AM, JohanBerg <[email protected] > <javascript:>> wrote: > >> A user with H2 in an application gets this error code: >> "org.h2.jdbc.JdbcSQLException: Hexadecimal string contains non-hex >> character: "-psn_0_57358" [90004-176]". The application is written in Java >> 8 and runs on macOS sierra (10.12.1). >> >> The error code appears directly after opening the database with the >> following argument: "jdbc:h2:file:" + database + >> ";CIPHER=XTEA;PASSWORD_HASH=TRUE;IFEXISTS=TRUE". >> >> Has anyone seen something similar? Could meta-data get corrupted and >> cause this? >> >> Best regards, >> Johan Berg >> >> -- >> You received this message because you are subscribed to the Google Groups >> "H2 Database" group. >> To unsubscribe from this group and stop receiving emails from it, send an >> email to [email protected] <javascript:>. >> To post to this group, send email to [email protected] >> <javascript:>. >> Visit this group at https://groups.google.com/group/h2-database. >> For more options, visit https://groups.google.com/d/optout. >> > > -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at https://groups.google.com/group/h2-database. For more options, visit https://groups.google.com/d/optout.
