Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Hebrew support #91

Closed
orrgal1 opened this issue Jun 16, 2014 · 1 comment
Closed

Hebrew support #91

orrgal1 opened this issue Jun 16, 2014 · 1 comment

Comments

@orrgal1
Copy link

orrgal1 commented Jun 16, 2014

getting this exception:

java.sql.SQLException: Value '�6650��2013-01-31 15:00:00�0���.�היי חבר'ה אני מחפשת טרמפ קבוע לימי חמישי באזור 14:30-17:00 מבש לכיוון צומת כנות. מי שנוסע לכיוון אשדוד/יבנה/רחובות- טוב לי! אם אתם נוסעים/ מכירים כאלו שנוסעים.. ספרו לי על זה!
���0�0�2012-10-29 12:13:12�2012-10-29 12:13:12�-1����1633�2�1342�0��0��Active�1633 739064022����2012-10-29 12:13:12��Sivan�Arber�he�0�1342�2012-10-29 12:13:12�2014-06-12 11:55:59;מרכז רפואי סורוקה, באר שבע, ישראל�כנות�IL�31.25820�34.79935�31.80822�34.75508�50.5317��0.455056�0.554165�0.553868�30.704�32.3621�34.3�35.2544�2�0000-00-00 00:00:00�0000-00-00 00:00:00��1633���1�5
2013-04-27' can not be represented as java.sql.Timestamp
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1073)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:987)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:982)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:927)
at com.mysql.jdbc.ResultSetRow.getTimestampFast(ResultSetRow.java:1033)
at com.mysql.jdbc.BufferRow.getTimestampFast(BufferRow.java:576)
at com.mysql.jdbc.ResultSetImpl.getTimestampInternal(ResultSetImpl.java:6748)
at com.mysql.jdbc.ResultSetImpl.getTimestamp(ResultSetImpl.java:6067)
at com.mysql.jdbc.ResultSetImpl.getObject(ResultSetImpl.java:5023)

looks like its trying to push an entire row into 1 date field. maybe some character in the data is messing it up?

i have this in my config:
config.addDataSourceProperty("characterEncoding","utf8");
config.addDataSourceProperty("useUnicode","true");
config.addDataSourceProperty("encoding","UTF-8");

please help... tnx

@orrgal1
Copy link
Author

orrgal1 commented Jun 17, 2014

ok turns out the exception was very unclear. the real issue is with dates in mysql db that are stored as 0000-00-00 00:00:00. nothing to do with hikari.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
Development

No branches or pull requests

2 participants