DATA_CONVERSION_ERROR_1

30 views
Skip to first unread message

Ricardo Tatsch

unread,
Apr 12, 2012, 2:00:46 PM4/12/12
to h2-da...@googlegroups.com
Hello guys.

I was doing some  tests when my windows reseted. When I tried to open my bank again, I got this message.


The problem is, I cant open the database anymore. This string its suppose to be recorded in a String column but, it was recorded in a timestamp column.

Who can I fixed it?


Atenciosamente,

Ricardo Tatsch

JND

unread,
Apr 13, 2012, 10:07:34 AM4/13/12
to h2-da...@googlegroups.com
> The problem is, I cant open the database anymore 

I guess it's trying to replay the log <http://www.h2database.com/html/features.html#logging_recovery>. Maybe setting LOG=0 lets you temporarily open the database to clear the log file (rollback) or maybe the Recover Tool can recover the rest of your committed data? http://www.h2database.com/html/advanced.html#using_recover_tool

Ricardo Tatsch

unread,
Apr 13, 2012, 2:16:39 PM4/13/12
to h2-da...@googlegroups.com
Hello JND.

Thx for your answner. I tried use LOG=0 option and didnt work.

My string connection is: 

jdbc:h2:d:/jboss/jboss_central/server/default/data/h2/bancoBugado;AUTO_SERVER=TRUE;CACHE_SIZE=2048;PAGE_SIZE=2048;LOG=0

I tried the recovery tool, but the RunScript didnt work very well. That'll be my next e-mail.


Atenciosamente,

Ricardo Tatsch



On Fri, Apr 13, 2012 at 11:07 AM, JND <jndev...@gmail.com> wrote:
> The problem is, I cant open the database anymore 

I guess it's trying to replay the log <http://www.h2database.com/html/features.html#logging_recovery>. Maybe setting LOG=0 lets you temporarily open the database to clear the log file (rollback) or maybe the Recover Tool can recover the rest of your committed data? http://www.h2database.com/html/advanced.html#using_recover_tool

--
You received this message because you are subscribed to the Google Groups "H2 Database" group.
To view this discussion on the web visit https://groups.google.com/d/msg/h2-database/-/rR-Yyli0ymkJ.
To post to this group, send email to h2-da...@googlegroups.com.
To unsubscribe from this group, send email to h2-database...@googlegroups.com.
For more options, visit this group at http://groups.google.com/group/h2-database?hl=en.

Thomas Mueller

unread,
Apr 14, 2012, 1:50:40 AM4/14/12
to h2-da...@googlegroups.com
Hi,

> I got this message.
> Data conversion error converting "48A-1559787164" [22018-166] 22018/22018

Could you post the stack trace as well please?

> Maybe setting LOG=0 lets you temporarily open the database

No, it doesn't. Using LOG=0 is dangerous and does not help solve this problem.

Regards,
Thomas

Reply all
Reply to author
Forward
0 new messages