oracle 10g ora-01460和ora-01461

yuwenli 08-01-26

使用oracle10.1.0.1的ojdbc14.jar 有这个问题,如果改使用oracle 10.2.0.1的ojdbc14.jar没有任何问题。但是部署到linux下的websphere6.0下,不管使用那个驱动都有ora-01460和ora-01461错误!!

Need help with Hibernate? Read this first:
http://www.hibernate.org/ForumMailinglists/HowToAskForHelp

Hibernate version: 3.2.0.ga

Mapping documents:
@Entity
@Table(name = "SECURITY_USERS")
@Cache(usage = CacheConcurrencyStrategy.NONSTRICT_READ_WRITE)
public class User {

Code between sessionFactory.openSession() and session.close():

Full stack trace of any exception that occurs:

Name and version of the database you are using:
oracle 10.2.0.1


The generated SQL (show_sql=true):
select r.name from SECURITY_resources c,SECURITY_roles
r,SECURITY_role_resc rc where c.id = rc.resc_id and r.id =
rc.role_id and c.res_string = ?


Debug level Hibernate log excerpt:


Problems with Session and transaction handling?