AFAICT, it is either a driver problem or there is a bind variable in the statement which is a reserved word.
Could you try with another driver?


[EMAIL PROTECTED] wrote:

Hi all,
        I have a CMP entity bean that access to oracle 9i database. When I
do the lookup it has no problem, but when I try to get some attribute (eg
getName()) it gives the following error:

org.jboss.tm.JBossTransactionRolledbackException: Load failed;
CausedByException is:
ORA-01745: invalid host/bind variable name
; CausedByException is:
Load failed; CausedByException is:
ORA-01745: invalid host/bind variable name
; nested exception is: javax.ejb.EJBException: Load failed; CausedByException is:
ORA-01745: invalid host/bind variable name
; - nested throwable: (javax.ejb.EJBException: Load failed;
CausedByException is:
ORA-01745: invalid host/bind variable name
)


I have found a "solution" to this error an it is to have less than 255
records in the table. When the returned collection has more than 255 CMP
object it breaks.

Does anyone know where should I change this configuration or what is wrong? I have looked in the conf dir but I did not found where...

Regards,
Hernán.


------------------------------------------------------- This SF.net email is sponsored by: SF.net Giveback Program. Does SourceForge.net help you be more productive? Does it help you create better code? SHARE THE LOVE, and help us help YOU! Click Here: http://sourceforge.net/donate/ _______________________________________________ JBoss-user mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/jboss-user





------------------------------------------------------- This SF.net email is sponsored by OSDN's Audience Survey. Help shape OSDN's sites and tell us what you think. Take this five minute survey and you could win a $250 Gift Certificate. http://www.wrgsurveys.com/2003/osdntech03.php?site=8 _______________________________________________ JBoss-user mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/jboss-user

Reply via email to