开发者

SQL error:8152, but not over max?

开发者 https://www.devze.com 2023-03-11 15:09 出处:网络
I\'m part of a team writing an ERP using , Seam, and Jboss, and on one of my pages, I keep getting an SQL error: 8152 whenever I try to input something. SQL error:8152, for those of you who don\'t kno

I'm part of a team writing an ERP using , Seam, and Jboss, and on one of my pages, I keep getting an SQL error: 8152 whenever I try to input something. SQL error:8152, for those of you who don't know, is when you try to input a value over the maximum limit of the column.

I've double checked my entity and the database, and their maximum value limits are the same (50 nvarchars). In addition, I'm pretty su开发者_如何学JAVAre that we're not using audit tables. I then put System.out.println(""); all over the place, and found that the error was happening in between these two println(s):

            System.out.println("Flushing");
        entityManager.flush();
        System.out.println("Flushing complete");

Which is part of a method that process all changes to the table. But I'm pretty new to programming and not sure what's going on.

Any help would be appreciated, thanks in advance, Jeff.

P.s. Code on request, but I didn't post it because there is a lot of it all over the place.


I would verify the SQL that is being executed when the flush() is performed. That way you can see the length of your data and verify that it is too big as shown by the DB error.

If you are using Hibernate, you can output SQL to the console. You don't say what your DB is, but if it's SQL Server you can use the profiler to see what SQL is being executed.

0

精彩评论

暂无评论...
验证码 换一张
取 消