You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@geronimo.apache.org by deepesh <de...@cognizant.com> on 2005/12/12 11:46:51 UTC
ORA-12704 error
Hi,
I have an enterprise application [.ear].
The environment as follows:
a. Oracle9i
b. Geronimo1.0M5
c. JDK 1.4.2
d. Fedora core Release 3
Previously i got an issue ''ORA-00920 SQL Exception
and then i got to know that the bug is fixed, and added the classes
OracleDBSyntaxFactory.java OracleGenerator.java
OracleEJBQLCompilerFactory.java
to tranql.jar and added the snippet
<ejb-ql-compiler-
factory>org.tranql.ejbcompiler.OracleEJBQLCompilerFactory</ejb-ql-
compiler-factory>
<db-syntax-factory>org.tranql.sql.oracle.OracleDBSyntaxFactory</db-
syntax-factory>
to openejb-jar.xml and this resolved the error
Now the error has been changed to following:
16:29:20,924 WARN [SystemExceptionInterceptor] MySecuritySession
javax.transaction.SystemException: Unable to commit container
transaction
at
org.apache.geronimo.transaction.context.InheritableTransactionContext.rollbackAndThrow(InheritableTransactionContext.java:327)
at
org.apache.geronimo.transaction.context.InheritableTransactionContext.complete(InheritableTransactionContext.java:199)
at
org.apache.geronimo.transaction.context.InheritableTransactionContext.commit(InheritableTransactionContext.java:146)
at org.openejb.transaction.ContainerPolicy$TxRequiresNew.invoke
(ContainerPolicy.java:246)
at org.openejb.transaction.TransactionContextInterceptor.invoke
(TransactionContextInterceptor.java:80)
at org.openejb.slsb.StatelessInstanceInterceptor.invoke
(StatelessInstanceInterceptor.java:98)
at org.openejb.transaction.ContainerPolicy$TxRequiresNew.invoke
(ContainerPolicy.java:234)
at org.openejb.transaction.TransactionContextInterceptor.invoke
(TransactionContextInterceptor.java:80)
at org.openejb.SystemExceptionInterceptor.invoke
(SystemExceptionInterceptor.java:82)
at org.openejb.GenericEJBContainer.invoke(GenericEJBContainer.java:238)
at org.openejb.server.ejbd.EjbRequestHandler.invoke
(EjbRequestHandler.java:297)
at
org.openejb.server.ejbd.EjbRequestHandler.doEjbObject_BUSINESS_METHOD
(EjbRequestHandler.java:325)
at org.openejb.server.ejbd.EjbRequestHandler.processRequest
(EjbRequestHandler.java:196)
at org.openejb.server.ejbd.EjbDaemon.service(EjbDaemon.java:150)
at org.openejb.server.ejbd.EjbServer.service(EjbServer.java:87)
at org.openejb.server.ejbd.EjbServer$$FastClassByCGLIB$$d379d2ff.invoke
(<generated>)
at net.sf.cglib.reflect.FastMethod.invoke(FastMethod.java:53)
at org.apache.geronimo.gbean.runtime.FastMethodInvoker.invoke
(FastMethodInvoker.java:38)
at org.apache.geronimo.gbean.runtime.GBeanOperation.invoke
(GBeanOperation.java:118)
at org.apache.geronimo.gbean.runtime.GBeanInstance.invoke
(GBeanInstance.java:760)
at org.apache.geronimo.gbean.runtime.RawInvoker.invoke
(RawInvoker.java:57)
at org.apache.geronimo.kernel.basic.RawOperationInvoker.invoke
(RawOperationInvoker.java:36)
at org.apache.geronimo.kernel.basic.ProxyMethodInterceptor.intercept
(ProxyMethodInterceptor.java:96)
at org.activeio.xnet.ServerService$$EnhancerByCGLIB$$b99e9050.service
(<generated>)
at org.activeio.xnet.ServicePool$2.run(ServicePool.java:67)
at org.activeio.xnet.ServicePool$3.run(ServicePool.java:90)
at org.apache.geronimo.pool.ThreadPool$ContextClassLoaderRunnable.run
(ThreadPool.java:138)
at EDU.oswego.cs.dl.util.concurrent.PooledExecutor$Worker.run(Unknown
Source)
at java.lang.Thread.run(Thread.java:534)
Caused by: org.tranql.ql.QueryException: Error executing statement:
UPDATE USER_INFO SET OU_ID = CASE WHEN 1 = ? THEN ? ELSE OU_ID END,
BUSINESS_PARTY_ID = CASE WHEN 1 = ? THEN ? ELSE BUSINESS_PARTY_ID END,
LOCALE_CODE = CASE WHEN 1 = ? THEN ? ELSE LOCALE_CODE END, USER_F_NAME =
CASE WHEN 1 = ? THEN ? ELSE USER_F_NAME END, USER_L_NAME = CASE WHEN 1
= ? THEN ? ELSE USER_L_NAME END, EMAIL_ID = CASE WHEN 1 = ? THEN ? ELSE
EMAIL_ID END, TELEPHONE = CASE WHEN 1 = ? THEN ? ELSE TELEPHONE END,
STREET = CASE WHEN 1 = ? THEN ? ELSE STREET END, CITY = CASE WHEN 1 = ?
THEN ? ELSE CITY END, STATE = CASE WHEN 1 = ? THEN ? ELSE STATE END,
COUNTRY = CASE WHEN 1 = ? THEN ? ELSE COUNTRY END, POSTAL_CODE = CASE
WHEN 1 = ? THEN ? ELSE POSTAL_CODE END, CREATED_BY = CASE WHEN 1 = ?
THEN ? ELSE CREATED_BY END, CREATED_DATE = CASE WHEN 1 = ? THEN ? ELSE
CREATED_DATE END, UPDATED_BY = CASE WHEN 1 = ? THEN ? ELSE UPDATED_BY
END, UPDATED_DATE = CASE WHEN 1 = ? THEN ? ELSE UPDATED_DATE END,
LOGIN_NAME = CASE WHEN 1 = ? THEN ? ELSE LOGIN_NAME END, LOGIN_PASSWORD
= CASE WHEN 1 = ? THEN ? ELSE LOGIN_PASSWORD END, ACTIVE_FLAG = CASE
WHEN 1 = ? THEN ? ELSE ACTIVE_FLAG END, USER_LOCK = CASE WHEN 1 = ?
THEN ? ELSE USER_LOCK END, PASSWORD_MODIFIED_DATE = CASE WHEN 1 = ?
THEN ? ELSE PASSWORD_MODIFIED_DATE END, USER_ADMIN_FLAG = CASE WHEN 1
= ? THEN ? ELSE USER_ADMIN_FLAG END, SECRET_QUESTION = CASE WHEN 1 = ?
THEN ? ELSE SECRET_QUESTION END, SECRET_ANSWER = CASE WHEN 1 = ? THEN ?
ELSE SECRET_ANSWER END, ONE_TIME_PASSWORD_FLAG = CASE WHEN 1 = ? THEN ?
ELSE ONE_TIME_PASSWORD_FLAG END WHERE USER_ID = ?
at org.tranql.sql.jdbc.JDBCUpdateCommand.execute
(JDBCUpdateCommand.java:69)
at org.tranql.cache.SimpleFlushStrategy.flush
(SimpleFlushStrategy.java:61)
at org.tranql.cache.SimpleFlushStrategy.flush
(SimpleFlushStrategy.java:46)
at org.tranql.cache.InTxCache.flush(InTxCache.java:85)
at
org.apache.geronimo.transaction.context.AbstractTransactionContext.flushState(AbstractTransactionContext.java:115)
at
org.apache.geronimo.transaction.context.InheritableTransactionContext.complete(InheritableTransactionContext.java:175)
... 27 more
Caused by: java.sql.SQLException: ORA-12704: character set mismatch
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134)
at oracle.jdbc.ttc7.TTIoer.processError(TTIoer.java:289)
at oracle.jdbc.ttc7.Oall7.receive(Oall7.java:573)
at oracle.jdbc.ttc7.TTC7Protocol.doOall7(TTC7Protocol.java:1891)
at oracle.jdbc.ttc7.TTC7Protocol.parseExecuteFetch
(TTC7Protocol.java:1093)
at oracle.jdbc.driver.OracleStatement.executeNonQuery
(OracleStatement.java:2047)
at oracle.jdbc.driver.OracleStatement.doExecuteOther
(OracleStatement.java:1940)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout
(OracleStatement.java:2709)
at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate
(OraclePreparedStatement.java:589)
at org.tranql.connector.jdbc.PreparedStatementHandle.executeUpdate
(PreparedStatementHandle.java:103)
at org.tranql.sql.jdbc.JDBCUpdateCommand.execute
(JDBCUpdateCommand.java:67)
... 32 more
16:29:20,927 DEBUG [EjbRequestHandler] EJB RESPONSE:
EJB_SYS_EXCEPTION:java.rmi.RemoteException: The bean encountered a non-
application exception. method; nested exception is:
javax.transaction.SystemException: Unable to commit container
transaction
16:29:21,012 DEBUG [EjbRequestHandler] setting cl=
[org.apache.geronimo.kernel.config.MultiParentClassLoader id=MyApp-ear]
for geronimo.server:EJBModule=MyApp.jar,J2EEApplication=MyApp-
ear,J2EEServer=geronimo,j2eeType=StatelessSessionBean,name=MySecuritySession
Can anyone pl help me what went wrong?
Thanks In Advance,
Deepesh
This e-mail and any files transmitted with it are for the sole use of the intended recipient(s) and may contain confidential and privileged information.
If you are not the intended recipient, please contact the sender by reply e-mail and destroy all copies of the original message.
Any unauthorized review, use, disclosure, dissemination, forwarding, printing or copying of this email or any action taken in reliance on this e-mail is strictly
prohibited and may be unlawful.
Visit us at http://www.cognizant.com
Re: javamail issue
Posted by Aaron Mulder <am...@alumni.princeton.edu>.
On 12/16/05, Arun Venugopal <Ar...@cognizant.com> wrote:
> Hi,
>
> I am sorry if i have made my question more complicated that it really is. My question was simply that why that piece of code (that i had given in my original mail) does not seem to work when used with geronimo although it works fine as a standalone java class.
The answer to that is that Geronimo does not include our JavaMail
transports on the class path for your application unless the
application depends on the JavaMail configuration I declared above.
It's possible we don't even include the interfaces unless you depend
on the JavaMail configuration, I'm not sure about that. In any case,
bottom line, you won't have the classes you need on your application's
class path without the <import> line I gave you above.
I assume that in your standalone application you added JavaMail to the
class path for the application when you ran it.
Aaron
> On Thu, 2005-12-15 at 10:44 -0800, Dain Sundstrom wrote:
> I'm not sure what you are asking. JavaMail is a specification
> published by the Java Community Process. We provide a clean room
> implementation of this specification with the Geronimo server
> starting with version 1.0. If you would like to use the
> implementation published by Sun Microsystems, that is also possible,
> but you will have to acquire that implementation from Sun (it is
> free) since licensing restrictions prevent us from shipping it with
> our server.
>
> -dain
>
> On Dec 15, 2005, at 12:11 AM, Arun Venugopal wrote:
>
> > Hi Aaaron,
> >
> > Does that mean that I cannot use the plain javamail implementation
> > in Geronimo and that I have to use the APIs provided by Geronimo
> >
> > Thanks and regards
> > Arun
> >
> > On Wed, 2005-12-14 at 14:27 -0500, Aaron Mulder wrote:
> >> If you're planning to use Geronimo's JavaMail features, you should
> >> be on a very current version (built from source or the 1.0 release
> >> candidate). Then you want to add a line like this to your Geronimo
> >> deployment plan: <import>geronimo/javamail/1.0/car</import> That
> >> way, you should be sure to get our JavaMail code on the classpath
> >> of your application. The JavaMail configuration is not started by
> >> default, though it should be started when you deploy an
> >> application that depends on it. If you want to start it by hand,
> >> you can always use java -jar bin/deployer.jar start geronimo/
> >> javamail/1.0/car Thanks, Aaron On 12/14/05, Arun Venugopal
> >> <Ar...@cognizant.com> wrote: > Hi, > > I have this piece
> >> of code that uses javamail . This code works fine when i try it as
> >> a standalone java application (ie when i put it in java file,
> >> compile it and run it). But when i put this code in an war (and
> >> call it from a servlet) and then deploy the war in geronimo, it
> >> does not work. I am pretty sure that this code is being called as
> >> any System.out.println that i give in between the code gets
> >> displayed in the console. Also i tried out the same code in JBoss
> >> and it seems to work there also. > > I have seen many discussions
> >> in the dev list regarding the JavaMail implementation. But i think
> >> all that is with regards to creating a new API for geronimo in the
> >> lines of the mail API's present in JBoss. And that since i am
> >> using plain java mail it should work irrespective of the
> >> application server. > > Can any one give me any pointers on why i
> >> am having this issue in geronimo and if i can solve it ... > > >
> >> ---------------------------------------------------------------------
> >> -------------------------------------------------- > > //
> >> substitute your mail address here > String from = "a@b.c"; >
> >> String to = "a@b.c"; > //substitute the host name or ip of your
> >> smtp server here > String host = "1.2.3.4"; > Properties props =
> >> new Properties(); > props.put("mail.smtp.host", host); > props.put
> >> ("mail.debug", "true"); > Session session = Session.getInstance
> >> (props); > try { > > Message msg = new MimeMessage(session); >
> >> msg.setFrom(new InternetAddress(from)); > InternetAddress[]
> >> address = {new InternetAddress(to)}; > msg.setRecipients
> >> (Message.RecipientType.TO, address); > msg.setSubject("Test E-Mail
> >> through Java"); > msg.setContent(msg, "text/plain"); >
> >> msg.setSentDate(new Date()); > msg.setText("Test Message"); >
> >> Transport.send(msg); > >
> >> ---------------------------------------------------------------------
> >> ---------------------------------------------------- > > > >
> >> Thanks in advance > > Regards > Arun > > > This e-mail and any
> >> files transmitted with it are for the sole use of the intended
> >> recipient(s) and may contain confidential and privileged
> >> information. > If you are not the intended recipient, please
> >> contact the sender by reply e-mail and destroy all copies of the
> >> original message. > Any unauthorized review, use, disclosure,
> >> dissemination, forwarding, printing or copying of this email or
> >> any action taken in reliance on this e-mail is strictly >
> >> prohibited and may be unlawful. > > Visit us at http://
> >> www.cognizant.com >
> > This e-mail and any files transmitted with it are for the sole use
> > of the intended recipient(s) and may contain confidential and
> > privileged information.
> > If you are not the intended recipient, please contact the sender by
> > reply e-mail and destroy all copies of the original message.
> > Any unauthorized review, use, disclosure, dissemination,
> > forwarding, printing or copying of this email or any action taken
> > in reliance on this e-mail is strictly
> > prohibited and may be unlawful.
> >
> > Visit us at http://www.cognizant.com
>
>
>
> This e-mail and any files transmitted with it are for the sole use of the intended recipient(s) and may contain confidential and privileged information.
> If you are not the intended recipient, please contact the sender by reply e-mail and destroy all copies of the original message.
> Any unauthorized review, use, disclosure, dissemination, forwarding, printing or copying of this email or any action taken in reliance on this e-mail is strictly
> prohibited and may be unlawful.
>
> Visit us at http://www.cognizant.com
>
Re: javamail issue
Posted by Arun Venugopal <Ar...@cognizant.com>.
Hi,
I am sorry if i have made my question more complicated that it really
is. My question was simply that why that piece of code (that i had given
in my original mail) does not seem to work when used with geronimo
although it works fine as a standalone java class.
Thanks and regards
Arun
On Thu, 2005-12-15 at 10:44 -0800, Dain Sundstrom wrote:
> I'm not sure what you are asking. JavaMail is a specification
> published by the Java Community Process. We provide a clean room
> implementation of this specification with the Geronimo server
> starting with version 1.0. If you would like to use the
> implementation published by Sun Microsystems, that is also possible,
> but you will have to acquire that implementation from Sun (it is
> free) since licensing restrictions prevent us from shipping it with
> our server.
>
> -dain
>
> On Dec 15, 2005, at 12:11 AM, Arun Venugopal wrote:
>
> > Hi Aaaron,
> >
> > Does that mean that I cannot use the plain javamail implementation
> > in Geronimo and that I have to use the APIs provided by Geronimo
> >
> > Thanks and regards
> > Arun
> >
> > On Wed, 2005-12-14 at 14:27 -0500, Aaron Mulder wrote:
> >> If you're planning to use Geronimo's JavaMail features, you should
> >> be on a very current version (built from source or the 1.0 release
> >> candidate). Then you want to add a line like this to your Geronimo
> >> deployment plan: <import>geronimo/javamail/1.0/car</import> That
> >> way, you should be sure to get our JavaMail code on the classpath
> >> of your application. The JavaMail configuration is not started by
> >> default, though it should be started when you deploy an
> >> application that depends on it. If you want to start it by hand,
> >> you can always use java -jar bin/deployer.jar start geronimo/
> >> javamail/1.0/car Thanks, Aaron On 12/14/05, Arun Venugopal
> >> <Ar...@cognizant.com> wrote: > Hi, > > I have this piece
> >> of code that uses javamail . This code works fine when i try it as
> >> a standalone java application (ie when i put it in java file,
> >> compile it and run it). But when i put this code in an war (and
> >> call it from a servlet) and then deploy the war in geronimo, it
> >> does not work. I am pretty sure that this code is being called as
> >> any System.out.println that i give in between the code gets
> >> displayed in the console. Also i tried out the same code in JBoss
> >> and it seems to work there also. > > I have seen many discussions
> >> in the dev list regarding the JavaMail implementation. But i think
> >> all that is with regards to creating a new API for geronimo in the
> >> lines of the mail API's present in JBoss. And that since i am
> >> using plain java mail it should work irrespective of the
> >> application server. > > Can any one give me any pointers on why i
> >> am having this issue in geronimo and if i can solve it ... > > >
> >> ---------------------------------------------------------------------
> >> -------------------------------------------------- > > //
> >> substitute your mail address here > String from = "a@b.c"; >
> >> String to = "a@b.c"; > //substitute the host name or ip of your
> >> smtp server here > String host = "1.2.3.4"; > Properties props =
> >> new Properties(); > props.put("mail.smtp.host", host); > props.put
> >> ("mail.debug", "true"); > Session session = Session.getInstance
> >> (props); > try { > > Message msg = new MimeMessage(session); >
> >> msg.setFrom(new InternetAddress(from)); > InternetAddress[]
> >> address = {new InternetAddress(to)}; > msg.setRecipients
> >> (Message.RecipientType.TO, address); > msg.setSubject("Test E-Mail
> >> through Java"); > msg.setContent(msg, "text/plain"); >
> >> msg.setSentDate(new Date()); > msg.setText("Test Message"); >
> >> Transport.send(msg); > >
> >> ---------------------------------------------------------------------
> >> ---------------------------------------------------- > > > >
> >> Thanks in advance > > Regards > Arun > > > This e-mail and any
> >> files transmitted with it are for the sole use of the intended
> >> recipient(s) and may contain confidential and privileged
> >> information. > If you are not the intended recipient, please
> >> contact the sender by reply e-mail and destroy all copies of the
> >> original message. > Any unauthorized review, use, disclosure,
> >> dissemination, forwarding, printing or copying of this email or
> >> any action taken in reliance on this e-mail is strictly >
> >> prohibited and may be unlawful. > > Visit us at http://
> >> www.cognizant.com >
> > This e-mail and any files transmitted with it are for the sole use
> > of the intended recipient(s) and may contain confidential and
> > privileged information.
> > If you are not the intended recipient, please contact the sender by
> > reply e-mail and destroy all copies of the original message.
> > Any unauthorized review, use, disclosure, dissemination,
> > forwarding, printing or copying of this email or any action taken
> > in reliance on this e-mail is strictly
> > prohibited and may be unlawful.
> >
> > Visit us at http://www.cognizant.com
>
This e-mail and any files transmitted with it are for the sole use of the intended recipient(s) and may contain confidential and privileged information.
If you are not the intended recipient, please contact the sender by reply e-mail and destroy all copies of the original message.
Any unauthorized review, use, disclosure, dissemination, forwarding, printing or copying of this email or any action taken in reliance on this e-mail is strictly
prohibited and may be unlawful.
Visit us at http://www.cognizant.com
Re: javamail issue
Posted by Dain Sundstrom <da...@iq80.com>.
I'm not sure what you are asking. JavaMail is a specification
published by the Java Community Process. We provide a clean room
implementation of this specification with the Geronimo server
starting with version 1.0. If you would like to use the
implementation published by Sun Microsystems, that is also possible,
but you will have to acquire that implementation from Sun (it is
free) since licensing restrictions prevent us from shipping it with
our server.
-dain
On Dec 15, 2005, at 12:11 AM, Arun Venugopal wrote:
> Hi Aaaron,
>
> Does that mean that I cannot use the plain javamail implementation
> in Geronimo and that I have to use the APIs provided by Geronimo
>
> Thanks and regards
> Arun
>
> On Wed, 2005-12-14 at 14:27 -0500, Aaron Mulder wrote:
>> If you're planning to use Geronimo's JavaMail features, you should
>> be on a very current version (built from source or the 1.0 release
>> candidate). Then you want to add a line like this to your Geronimo
>> deployment plan: <import>geronimo/javamail/1.0/car</import> That
>> way, you should be sure to get our JavaMail code on the classpath
>> of your application. The JavaMail configuration is not started by
>> default, though it should be started when you deploy an
>> application that depends on it. If you want to start it by hand,
>> you can always use java -jar bin/deployer.jar start geronimo/
>> javamail/1.0/car Thanks, Aaron On 12/14/05, Arun Venugopal
>> <Ar...@cognizant.com> wrote: > Hi, > > I have this piece
>> of code that uses javamail . This code works fine when i try it as
>> a standalone java application (ie when i put it in java file,
>> compile it and run it). But when i put this code in an war (and
>> call it from a servlet) and then deploy the war in geronimo, it
>> does not work. I am pretty sure that this code is being called as
>> any System.out.println that i give in between the code gets
>> displayed in the console. Also i tried out the same code in JBoss
>> and it seems to work there also. > > I have seen many discussions
>> in the dev list regarding the JavaMail implementation. But i think
>> all that is with regards to creating a new API for geronimo in the
>> lines of the mail API's present in JBoss. And that since i am
>> using plain java mail it should work irrespective of the
>> application server. > > Can any one give me any pointers on why i
>> am having this issue in geronimo and if i can solve it ... > > >
>> ---------------------------------------------------------------------
>> -------------------------------------------------- > > //
>> substitute your mail address here > String from = "a@b.c"; >
>> String to = "a@b.c"; > //substitute the host name or ip of your
>> smtp server here > String host = "1.2.3.4"; > Properties props =
>> new Properties(); > props.put("mail.smtp.host", host); > props.put
>> ("mail.debug", "true"); > Session session = Session.getInstance
>> (props); > try { > > Message msg = new MimeMessage(session); >
>> msg.setFrom(new InternetAddress(from)); > InternetAddress[]
>> address = {new InternetAddress(to)}; > msg.setRecipients
>> (Message.RecipientType.TO, address); > msg.setSubject("Test E-Mail
>> through Java"); > msg.setContent(msg, "text/plain"); >
>> msg.setSentDate(new Date()); > msg.setText("Test Message"); >
>> Transport.send(msg); > >
>> ---------------------------------------------------------------------
>> ---------------------------------------------------- > > > >
>> Thanks in advance > > Regards > Arun > > > This e-mail and any
>> files transmitted with it are for the sole use of the intended
>> recipient(s) and may contain confidential and privileged
>> information. > If you are not the intended recipient, please
>> contact the sender by reply e-mail and destroy all copies of the
>> original message. > Any unauthorized review, use, disclosure,
>> dissemination, forwarding, printing or copying of this email or
>> any action taken in reliance on this e-mail is strictly >
>> prohibited and may be unlawful. > > Visit us at http://
>> www.cognizant.com >
> This e-mail and any files transmitted with it are for the sole use
> of the intended recipient(s) and may contain confidential and
> privileged information.
> If you are not the intended recipient, please contact the sender by
> reply e-mail and destroy all copies of the original message.
> Any unauthorized review, use, disclosure, dissemination,
> forwarding, printing or copying of this email or any action taken
> in reliance on this e-mail is strictly
> prohibited and may be unlawful.
>
> Visit us at http://www.cognizant.com
Re: javamail issue
Posted by Arun Venugopal <Ar...@cognizant.com>.
Hi Aaaron,
Does that mean that I cannot use the plain javamail implementation in
Geronimo and that I have to use the APIs provided by Geronimo
Thanks and regards
Arun
On Wed, 2005-12-14 at 14:27 -0500, Aaron Mulder wrote:
> If you're planning to use Geronimo's JavaMail features, you should be
> on a very current version (built from source or the 1.0 release
> candidate). Then you want to add a line like this to your Geronimo
> deployment plan:
>
> <import>geronimo/javamail/1.0/car</import>
>
> That way, you should be sure to get our JavaMail code on the classpath
> of your application. The JavaMail configuration is not started by
> default, though it should be started when you deploy an application
> that depends on it. If you want to start it by hand, you can always
> use
>
> java -jar bin/deployer.jar start geronimo/javamail/1.0/car
>
> Thanks,
> Aaron
>
> On 12/14/05, Arun Venugopal <Ar...@cognizant.com> wrote:
> > Hi,
> >
> > I have this piece of code that uses javamail . This code works fine when i try it as a standalone java application (ie when i put it in java file, compile it and run it). But when i put this code in an war (and call it from a servlet) and then deploy the war in geronimo, it does not work. I am pretty sure that this code is being called as any System.out.println that i give in between the code gets displayed in the console. Also i tried out the same code in JBoss and it seems to work there also.
> >
> > I have seen many discussions in the dev list regarding the JavaMail implementation. But i think all that is with regards to creating a new API for geronimo in the lines of the mail API's present in JBoss. And that since i am using plain java mail it should work irrespective of the application server.
> >
> > Can any one give me any pointers on why i am having this issue in geronimo and if i can solve it ...
> >
> >
> > -----------------------------------------------------------------------------------------------------------------------
> >
> > //substitute your mail address here
> > String from = "a@b.c";
> > String to = "a@b.c";
> > //substitute the host name or ip of your smtp server here
> > String host = "1.2.3.4";
> > Properties props = new Properties();
> > props.put("mail.smtp.host", host);
> > props.put("mail.debug", "true");
> > Session session = Session.getInstance(props);
> > try {
> >
> > Message msg = new MimeMessage(session);
> > msg.setFrom(new InternetAddress(from));
> > InternetAddress[] address = {new InternetAddress(to)};
> > msg.setRecipients(Message.RecipientType.TO, address);
> > msg.setSubject("Test E-Mail through Java");
> > msg.setContent(msg, "text/plain");
> > msg.setSentDate(new Date());
> > msg.setText("Test Message");
> > Transport.send(msg);
> >
> > -------------------------------------------------------------------------------------------------------------------------
> >
> >
> >
> > Thanks in advance
> >
> > Regards
> > Arun
> >
> >
> > This e-mail and any files transmitted with it are for the sole use of the intended recipient(s) and may contain confidential and privileged information.
> > If you are not the intended recipient, please contact the sender by reply e-mail and destroy all copies of the original message.
> > Any unauthorized review, use, disclosure, dissemination, forwarding, printing or copying of this email or any action taken in reliance on this e-mail is strictly
> > prohibited and may be unlawful.
> >
> > Visit us at http://www.cognizant.com
> >
This e-mail and any files transmitted with it are for the sole use of the intended recipient(s) and may contain confidential and privileged information.
If you are not the intended recipient, please contact the sender by reply e-mail and destroy all copies of the original message.
Any unauthorized review, use, disclosure, dissemination, forwarding, printing or copying of this email or any action taken in reliance on this e-mail is strictly
prohibited and may be unlawful.
Visit us at http://www.cognizant.com
Re: javamail issue
Posted by Aaron Mulder <am...@alumni.princeton.edu>.
If you're planning to use Geronimo's JavaMail features, you should be
on a very current version (built from source or the 1.0 release
candidate). Then you want to add a line like this to your Geronimo
deployment plan:
<import>geronimo/javamail/1.0/car</import>
That way, you should be sure to get our JavaMail code on the classpath
of your application. The JavaMail configuration is not started by
default, though it should be started when you deploy an application
that depends on it. If you want to start it by hand, you can always
use
java -jar bin/deployer.jar start geronimo/javamail/1.0/car
Thanks,
Aaron
On 12/14/05, Arun Venugopal <Ar...@cognizant.com> wrote:
> Hi,
>
> I have this piece of code that uses javamail . This code works fine when i try it as a standalone java application (ie when i put it in java file, compile it and run it). But when i put this code in an war (and call it from a servlet) and then deploy the war in geronimo, it does not work. I am pretty sure that this code is being called as any System.out.println that i give in between the code gets displayed in the console. Also i tried out the same code in JBoss and it seems to work there also.
>
> I have seen many discussions in the dev list regarding the JavaMail implementation. But i think all that is with regards to creating a new API for geronimo in the lines of the mail API's present in JBoss. And that since i am using plain java mail it should work irrespective of the application server.
>
> Can any one give me any pointers on why i am having this issue in geronimo and if i can solve it ...
>
>
> -----------------------------------------------------------------------------------------------------------------------
>
> //substitute your mail address here
> String from = "a@b.c";
> String to = "a@b.c";
> //substitute the host name or ip of your smtp server here
> String host = "1.2.3.4";
> Properties props = new Properties();
> props.put("mail.smtp.host", host);
> props.put("mail.debug", "true");
> Session session = Session.getInstance(props);
> try {
>
> Message msg = new MimeMessage(session);
> msg.setFrom(new InternetAddress(from));
> InternetAddress[] address = {new InternetAddress(to)};
> msg.setRecipients(Message.RecipientType.TO, address);
> msg.setSubject("Test E-Mail through Java");
> msg.setContent(msg, "text/plain");
> msg.setSentDate(new Date());
> msg.setText("Test Message");
> Transport.send(msg);
>
> -------------------------------------------------------------------------------------------------------------------------
>
>
>
> Thanks in advance
>
> Regards
> Arun
>
>
> This e-mail and any files transmitted with it are for the sole use of the intended recipient(s) and may contain confidential and privileged information.
> If you are not the intended recipient, please contact the sender by reply e-mail and destroy all copies of the original message.
> Any unauthorized review, use, disclosure, dissemination, forwarding, printing or copying of this email or any action taken in reliance on this e-mail is strictly
> prohibited and may be unlawful.
>
> Visit us at http://www.cognizant.com
>
javamail issue
Posted by Arun Venugopal <Ar...@cognizant.com>.
Hi,
I have this piece of code that uses javamail . This code works fine
when i try it as a standalone java application (ie when i put it in java
file, compile it and run it). But when i put this code in an war (and
call it from a servlet) and then deploy the war in geronimo, it does not
work. I am pretty sure that this code is being called as any
System.out.println that i give in between the code gets displayed in the
console. Also i tried out the same code in JBoss and it seems to work
there also.
I have seen many discussions in the dev list regarding the JavaMail
implementation. But i think all that is with regards to creating a new
API for geronimo in the lines of the mail API's present in JBoss. And
that since i am using plain java mail it should work irrespective of the
application server.
Can any one give me any pointers on why i am having this issue in
geronimo and if i can solve it ...
-----------------------------------------------------------------------------------------------------------------------
//substitute your mail address here
String from = "a@b.c";
String to = "a@b.c";
//substitute the host name or ip of your smtp server here
String host = "1.2.3.4";
Properties props = new Properties();
props.put("mail.smtp.host", host);
props.put("mail.debug", "true");
Session session = Session.getInstance(props);
try {
Message msg = new MimeMessage(session);
msg.setFrom(new InternetAddress(from));
InternetAddress[] address = {new InternetAddress(to)};
msg.setRecipients(Message.RecipientType.TO, address);
msg.setSubject("Test E-Mail through Java");
msg.setContent(msg, "text/plain");
msg.setSentDate(new Date());
msg.setText("Test Message");
Transport.send(msg);
-------------------------------------------------------------------------------------------------------------------------
Thanks in advance
Regards
Arun
This e-mail and any files transmitted with it are for the sole use of the intended recipient(s) and may contain confidential and privileged information.
If you are not the intended recipient, please contact the sender by reply e-mail and destroy all copies of the original message.
Any unauthorized review, use, disclosure, dissemination, forwarding, printing or copying of this email or any action taken in reliance on this e-mail is strictly
prohibited and may be unlawful.
Visit us at http://www.cognizant.com
Re: ORA-12704 error
Posted by Akshay Panda <ax...@yahoo.com>.
Matt,
my colleague deepesh set the NLS info, but i think
didn't get posted. forwardig that...
The v$NLS_PARAMETERS records as follows:
PARAMETER VALUE
---------------------------------------------------
NLS_LANGUAGE AMERICAN
NLS_TERRITORY AMERICA
NLS_CURRENCY $
NLS_ISO_CURRENCY AMERICA
NLS_NUMERIC_CHARACTERS .,
NLS_CALENDAR GREGORIAN
NLS_DATE_FORMAT DD-MON-RR
NLS_DATE_LANGUAGE AMERICAN
NLS_CHARACTERSET WE8ISO8859P1
NLS_SORT BINARY
NLS_TIME_FORMAT HH.MI.SSXFF AM
NLS_TIMESTAMP_FORMAT DD-MON-RR HH.MI.SSXFF AM
NLS_TIME_TZ_FORMAT HH.MI.SSXFF AM TZR
NLS_TIMESTAMP_TZ_FORMAT DD-MON-RR HH.MI.SSXFF AM TZR
NLS_DUAL_CURRENCY $
NLS_NCHAR_CHARACTERSET AL16UTF16
NLS_COMP BINARY
NLS_LENGTH_SEMANTICS BYTE
NLS_NCHAR_CONV_EXCP FALSE
thanks
akshay
--- Matt Hogstrom <ma...@hogstrom.org> wrote:
> Deepesh,
>
> I Google'd the error your getting and many of the
> entries had some information
> about NLS settings. Can you provide more detail
> about your environment?
> (Lnguage settings, Locale, etc.)
>
> Matt
>
> deepesh wrote:
> > Hi,
> >
> > I have an enterprise application [.ear].
> > The environment as follows:
> >
> > a. Oracle9i
> > b. Geronimo1.0M5
> > c. JDK 1.4.2
> > d. Fedora core Release 3
> >
> > Previously i got an issue ''ORA-00920 SQL
> Exception
> >
> > and then i got to know that the bug is fixed, and
> added the classes
> > OracleDBSyntaxFactory.java OracleGenerator.java
> > OracleEJBQLCompilerFactory.java
> > to tranql.jar and added the snippet
> >
> > <ejb-ql-compiler-
> >
>
factory>org.tranql.ejbcompiler.OracleEJBQLCompilerFactory</ejb-ql-
> > compiler-factory>
> >
>
<db-syntax-factory>org.tranql.sql.oracle.OracleDBSyntaxFactory</db-
> > syntax-factory>
> >
> > to openejb-jar.xml and this resolved the error
> >
> >
> > Now the error has been changed to following:
> >
> > 16:29:20,924 WARN [SystemExceptionInterceptor]
> MySecuritySession
> > javax.transaction.SystemException: Unable to
> commit container
> > transaction
> > at
> >
>
org.apache.geronimo.transaction.context.InheritableTransactionContext.rollbackAndThrow(InheritableTransactionContext.java:327)
> > at
> >
>
org.apache.geronimo.transaction.context.InheritableTransactionContext.complete(InheritableTransactionContext.java:199)
> > at
> >
>
org.apache.geronimo.transaction.context.InheritableTransactionContext.commit(InheritableTransactionContext.java:146)
> > at
>
org.openejb.transaction.ContainerPolicy$TxRequiresNew.invoke
> > (ContainerPolicy.java:246)
> > at
>
org.openejb.transaction.TransactionContextInterceptor.invoke
> > (TransactionContextInterceptor.java:80)
> > at
> org.openejb.slsb.StatelessInstanceInterceptor.invoke
> > (StatelessInstanceInterceptor.java:98)
> > at
>
org.openejb.transaction.ContainerPolicy$TxRequiresNew.invoke
> > (ContainerPolicy.java:234)
> > at
>
org.openejb.transaction.TransactionContextInterceptor.invoke
> > (TransactionContextInterceptor.java:80)
> > at org.openejb.SystemExceptionInterceptor.invoke
> > (SystemExceptionInterceptor.java:82)
> > at
>
org.openejb.GenericEJBContainer.invoke(GenericEJBContainer.java:238)
> > at
> org.openejb.server.ejbd.EjbRequestHandler.invoke
> > (EjbRequestHandler.java:297)
> > at
> >
>
org.openejb.server.ejbd.EjbRequestHandler.doEjbObject_BUSINESS_METHOD
> > (EjbRequestHandler.java:325)
> > at
>
org.openejb.server.ejbd.EjbRequestHandler.processRequest
> > (EjbRequestHandler.java:196)
> > at
>
org.openejb.server.ejbd.EjbDaemon.service(EjbDaemon.java:150)
> > at
>
org.openejb.server.ejbd.EjbServer.service(EjbServer.java:87)
> > at
>
org.openejb.server.ejbd.EjbServer$$FastClassByCGLIB$$d379d2ff.invoke
> > (<generated>)
> > at
>
net.sf.cglib.reflect.FastMethod.invoke(FastMethod.java:53)
> > at
>
org.apache.geronimo.gbean.runtime.FastMethodInvoker.invoke
> > (FastMethodInvoker.java:38)
> > at
>
org.apache.geronimo.gbean.runtime.GBeanOperation.invoke
> > (GBeanOperation.java:118)
> > at
>
org.apache.geronimo.gbean.runtime.GBeanInstance.invoke
> > (GBeanInstance.java:760)
> > at
> org.apache.geronimo.gbean.runtime.RawInvoker.invoke
> > (RawInvoker.java:57)
> > at
>
org.apache.geronimo.kernel.basic.RawOperationInvoker.invoke
> > (RawOperationInvoker.java:36)
> > at
>
org.apache.geronimo.kernel.basic.ProxyMethodInterceptor.intercept
> > (ProxyMethodInterceptor.java:96)
> > at
>
org.activeio.xnet.ServerService$$EnhancerByCGLIB$$b99e9050.service
> > (<generated>)
> > at
>
org.activeio.xnet.ServicePool$2.run(ServicePool.java:67)
> > at
>
org.activeio.xnet.ServicePool$3.run(ServicePool.java:90)
> > at
>
org.apache.geronimo.pool.ThreadPool$ContextClassLoaderRunnable.run
> > (ThreadPool.java:138)
> > at
>
EDU.oswego.cs.dl.util.concurrent.PooledExecutor$Worker.run(Unknown
> > Source)
> > at java.lang.Thread.run(Thread.java:534)
> > Caused by: org.tranql.ql.QueryException: Error
> executing statement:
> > UPDATE USER_INFO SET OU_ID = CASE WHEN 1 = ? THEN
> ? ELSE OU_ID END,
> > BUSINESS_PARTY_ID = CASE WHEN 1 = ? THEN ? ELSE
> BUSINESS_PARTY_ID END,
> > LOCALE_CODE = CASE WHEN 1 = ? THEN ? ELSE
> LOCALE_CODE END, USER_F_NAME =
> > CASE WHEN 1 = ? THEN ? ELSE USER_F_NAME END,
> USER_L_NAME = CASE WHEN 1
> > = ? THEN ? ELSE USER_L_NAME END, EMAIL_ID = CASE
> WHEN 1 = ? THEN ? ELSE
> > EMAIL_ID END, TELEPHONE = CASE WHEN 1 = ? THEN ?
> ELSE TELEPHONE END,
> > STREET = CASE WHEN 1 = ? THEN ? ELSE STREET END,
> CITY = CASE WHEN 1 = ?
> > THEN ? ELSE CITY END, STATE = CASE WHEN 1 = ? THEN
> ? ELSE STATE END,
> > COUNTRY = CASE WHEN 1 = ? THEN ? ELSE COUNTRY END,
> POSTAL_CODE = CASE
> > WHEN 1 = ? THEN ? ELSE POSTAL_CODE END, CREATED_BY
> = CASE WHEN 1 = ?
> > THEN ? ELSE CREATED_BY END, CREATED_DATE = CASE
> WHEN 1 = ? THEN ? ELSE
> > CREATED_DATE END, UPDATED_BY = CASE WHEN 1 = ?
> THEN ? ELSE UPDATED_BY
> > END, UPDATED_DATE = CASE WHEN 1 = ? THEN ? ELSE
> UPDATED_DATE END,
> > LOGIN_NAME = CASE WHEN 1 = ? THEN ? ELSE
> LOGIN_NAME END, LOGIN_PASSWORD
> > = CASE WHEN 1 = ? THEN ? ELSE LOGIN_PASSWORD END,
> ACTIVE_FLAG = CASE
> > WHEN 1 = ? THEN ? ELSE ACTIVE_FLAG END, USER_LOCK
> = CASE WHEN 1 = ?
> > THEN ? ELSE USER_LOCK END, PASSWORD_MODIFIED_DATE
> = CASE WHEN 1 = ?
> > THEN ? ELSE PASSWORD_MODIFIED_DATE END,
> USER_ADMIN_FLAG = CASE WHEN 1
> > = ? THEN ? ELSE USER_ADMIN_FLAG END,
> SECRET_QUESTION = CASE WHEN 1 = ?
> > THEN ? ELSE SECRET_QUESTION END, SECRET_ANSWER =
> CASE WHEN 1 = ? THEN ?
> > ELSE SECRET_ANSWER END, ONE_TIME_PASSWORD_FLAG =
> CASE WHEN 1 = ? THEN ?
> > ELSE ONE_TIME_PASSWORD_FLAG END WHERE USER_ID = ?
> > at org.tranql.sql.jdbc.JDBCUpdateCommand.execute
> > (JDBCUpdateCommand.java:69)
> > at org.tranql.cache.SimpleFlushStrategy.flush
> > (SimpleFlushStrategy.java:61)
> > at org.tranql.cache.SimpleFlushStrategy.flush
> > (SimpleFlushStrategy.java:46)
> > at
> org.tranql.cache.InTxCache.flush(InTxCache.java:85)
> > at
> >
>
org.apache.geronimo.transaction.context.AbstractTransactionContext.flushState(AbstractTransactionContext.java:115)
> > at
> >
>
org.apache.geronimo.transaction.context.InheritableTransactionContext.complete(InheritableTransactionContext.java:175)
> > ... 27 more
> > Caused by: java.sql.SQLException: ORA-12704:
> character set mismatch
> >
> > at
>
oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134)
> > at
>
oracle.jdbc.ttc7.TTIoer.processError(TTIoer.java:289)
> > at oracle.jdbc.ttc7.Oall7.receive(Oall7.java:573)
> > at
>
oracle.jdbc.ttc7.TTC7Protocol.doOall7(TTC7Protocol.java:1891)
> > at
> oracle.jdbc.ttc7.TTC7Protocol.parseExecuteFetch
> > (TTC7Protocol.java:1093)
> > at
> oracle.jdbc.driver.OracleStatement.executeNonQuery
>
=== message truncated ===
__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com
Re: ORA-12704 error
Posted by Matt Hogstrom <ma...@hogstrom.org>.
Deepesh,
I Google'd the error your getting and many of the entries had some information
about NLS settings. Can you provide more detail about your environment?
(Lnguage settings, Locale, etc.)
Matt
deepesh wrote:
> Hi,
>
> I have an enterprise application [.ear].
> The environment as follows:
>
> a. Oracle9i
> b. Geronimo1.0M5
> c. JDK 1.4.2
> d. Fedora core Release 3
>
> Previously i got an issue ''ORA-00920 SQL Exception
>
> and then i got to know that the bug is fixed, and added the classes
> OracleDBSyntaxFactory.java OracleGenerator.java
> OracleEJBQLCompilerFactory.java
> to tranql.jar and added the snippet
>
> <ejb-ql-compiler-
> factory>org.tranql.ejbcompiler.OracleEJBQLCompilerFactory</ejb-ql-
> compiler-factory>
> <db-syntax-factory>org.tranql.sql.oracle.OracleDBSyntaxFactory</db-
> syntax-factory>
>
> to openejb-jar.xml and this resolved the error
>
>
> Now the error has been changed to following:
>
> 16:29:20,924 WARN [SystemExceptionInterceptor] MySecuritySession
> javax.transaction.SystemException: Unable to commit container
> transaction
> at
> org.apache.geronimo.transaction.context.InheritableTransactionContext.rollbackAndThrow(InheritableTransactionContext.java:327)
> at
> org.apache.geronimo.transaction.context.InheritableTransactionContext.complete(InheritableTransactionContext.java:199)
> at
> org.apache.geronimo.transaction.context.InheritableTransactionContext.commit(InheritableTransactionContext.java:146)
> at org.openejb.transaction.ContainerPolicy$TxRequiresNew.invoke
> (ContainerPolicy.java:246)
> at org.openejb.transaction.TransactionContextInterceptor.invoke
> (TransactionContextInterceptor.java:80)
> at org.openejb.slsb.StatelessInstanceInterceptor.invoke
> (StatelessInstanceInterceptor.java:98)
> at org.openejb.transaction.ContainerPolicy$TxRequiresNew.invoke
> (ContainerPolicy.java:234)
> at org.openejb.transaction.TransactionContextInterceptor.invoke
> (TransactionContextInterceptor.java:80)
> at org.openejb.SystemExceptionInterceptor.invoke
> (SystemExceptionInterceptor.java:82)
> at org.openejb.GenericEJBContainer.invoke(GenericEJBContainer.java:238)
> at org.openejb.server.ejbd.EjbRequestHandler.invoke
> (EjbRequestHandler.java:297)
> at
> org.openejb.server.ejbd.EjbRequestHandler.doEjbObject_BUSINESS_METHOD
> (EjbRequestHandler.java:325)
> at org.openejb.server.ejbd.EjbRequestHandler.processRequest
> (EjbRequestHandler.java:196)
> at org.openejb.server.ejbd.EjbDaemon.service(EjbDaemon.java:150)
> at org.openejb.server.ejbd.EjbServer.service(EjbServer.java:87)
> at org.openejb.server.ejbd.EjbServer$$FastClassByCGLIB$$d379d2ff.invoke
> (<generated>)
> at net.sf.cglib.reflect.FastMethod.invoke(FastMethod.java:53)
> at org.apache.geronimo.gbean.runtime.FastMethodInvoker.invoke
> (FastMethodInvoker.java:38)
> at org.apache.geronimo.gbean.runtime.GBeanOperation.invoke
> (GBeanOperation.java:118)
> at org.apache.geronimo.gbean.runtime.GBeanInstance.invoke
> (GBeanInstance.java:760)
> at org.apache.geronimo.gbean.runtime.RawInvoker.invoke
> (RawInvoker.java:57)
> at org.apache.geronimo.kernel.basic.RawOperationInvoker.invoke
> (RawOperationInvoker.java:36)
> at org.apache.geronimo.kernel.basic.ProxyMethodInterceptor.intercept
> (ProxyMethodInterceptor.java:96)
> at org.activeio.xnet.ServerService$$EnhancerByCGLIB$$b99e9050.service
> (<generated>)
> at org.activeio.xnet.ServicePool$2.run(ServicePool.java:67)
> at org.activeio.xnet.ServicePool$3.run(ServicePool.java:90)
> at org.apache.geronimo.pool.ThreadPool$ContextClassLoaderRunnable.run
> (ThreadPool.java:138)
> at EDU.oswego.cs.dl.util.concurrent.PooledExecutor$Worker.run(Unknown
> Source)
> at java.lang.Thread.run(Thread.java:534)
> Caused by: org.tranql.ql.QueryException: Error executing statement:
> UPDATE USER_INFO SET OU_ID = CASE WHEN 1 = ? THEN ? ELSE OU_ID END,
> BUSINESS_PARTY_ID = CASE WHEN 1 = ? THEN ? ELSE BUSINESS_PARTY_ID END,
> LOCALE_CODE = CASE WHEN 1 = ? THEN ? ELSE LOCALE_CODE END, USER_F_NAME =
> CASE WHEN 1 = ? THEN ? ELSE USER_F_NAME END, USER_L_NAME = CASE WHEN 1
> = ? THEN ? ELSE USER_L_NAME END, EMAIL_ID = CASE WHEN 1 = ? THEN ? ELSE
> EMAIL_ID END, TELEPHONE = CASE WHEN 1 = ? THEN ? ELSE TELEPHONE END,
> STREET = CASE WHEN 1 = ? THEN ? ELSE STREET END, CITY = CASE WHEN 1 = ?
> THEN ? ELSE CITY END, STATE = CASE WHEN 1 = ? THEN ? ELSE STATE END,
> COUNTRY = CASE WHEN 1 = ? THEN ? ELSE COUNTRY END, POSTAL_CODE = CASE
> WHEN 1 = ? THEN ? ELSE POSTAL_CODE END, CREATED_BY = CASE WHEN 1 = ?
> THEN ? ELSE CREATED_BY END, CREATED_DATE = CASE WHEN 1 = ? THEN ? ELSE
> CREATED_DATE END, UPDATED_BY = CASE WHEN 1 = ? THEN ? ELSE UPDATED_BY
> END, UPDATED_DATE = CASE WHEN 1 = ? THEN ? ELSE UPDATED_DATE END,
> LOGIN_NAME = CASE WHEN 1 = ? THEN ? ELSE LOGIN_NAME END, LOGIN_PASSWORD
> = CASE WHEN 1 = ? THEN ? ELSE LOGIN_PASSWORD END, ACTIVE_FLAG = CASE
> WHEN 1 = ? THEN ? ELSE ACTIVE_FLAG END, USER_LOCK = CASE WHEN 1 = ?
> THEN ? ELSE USER_LOCK END, PASSWORD_MODIFIED_DATE = CASE WHEN 1 = ?
> THEN ? ELSE PASSWORD_MODIFIED_DATE END, USER_ADMIN_FLAG = CASE WHEN 1
> = ? THEN ? ELSE USER_ADMIN_FLAG END, SECRET_QUESTION = CASE WHEN 1 = ?
> THEN ? ELSE SECRET_QUESTION END, SECRET_ANSWER = CASE WHEN 1 = ? THEN ?
> ELSE SECRET_ANSWER END, ONE_TIME_PASSWORD_FLAG = CASE WHEN 1 = ? THEN ?
> ELSE ONE_TIME_PASSWORD_FLAG END WHERE USER_ID = ?
> at org.tranql.sql.jdbc.JDBCUpdateCommand.execute
> (JDBCUpdateCommand.java:69)
> at org.tranql.cache.SimpleFlushStrategy.flush
> (SimpleFlushStrategy.java:61)
> at org.tranql.cache.SimpleFlushStrategy.flush
> (SimpleFlushStrategy.java:46)
> at org.tranql.cache.InTxCache.flush(InTxCache.java:85)
> at
> org.apache.geronimo.transaction.context.AbstractTransactionContext.flushState(AbstractTransactionContext.java:115)
> at
> org.apache.geronimo.transaction.context.InheritableTransactionContext.complete(InheritableTransactionContext.java:175)
> ... 27 more
> Caused by: java.sql.SQLException: ORA-12704: character set mismatch
>
> at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134)
> at oracle.jdbc.ttc7.TTIoer.processError(TTIoer.java:289)
> at oracle.jdbc.ttc7.Oall7.receive(Oall7.java:573)
> at oracle.jdbc.ttc7.TTC7Protocol.doOall7(TTC7Protocol.java:1891)
> at oracle.jdbc.ttc7.TTC7Protocol.parseExecuteFetch
> (TTC7Protocol.java:1093)
> at oracle.jdbc.driver.OracleStatement.executeNonQuery
> (OracleStatement.java:2047)
> at oracle.jdbc.driver.OracleStatement.doExecuteOther
> (OracleStatement.java:1940)
> at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout
> (OracleStatement.java:2709)
> at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate
> (OraclePreparedStatement.java:589)
> at org.tranql.connector.jdbc.PreparedStatementHandle.executeUpdate
> (PreparedStatementHandle.java:103)
> at org.tranql.sql.jdbc.JDBCUpdateCommand.execute
> (JDBCUpdateCommand.java:67)
> ... 32 more
> 16:29:20,927 DEBUG [EjbRequestHandler] EJB RESPONSE:
> EJB_SYS_EXCEPTION:java.rmi.RemoteException: The bean encountered a non-
> application exception. method; nested exception is:
> javax.transaction.SystemException: Unable to commit container
> transaction
> 16:29:21,012 DEBUG [EjbRequestHandler] setting cl=
> [org.apache.geronimo.kernel.config.MultiParentClassLoader id=MyApp-ear]
> for geronimo.server:EJBModule=MyApp.jar,J2EEApplication=MyApp-
> ear,J2EEServer=geronimo,j2eeType=StatelessSessionBean,name=MySecuritySession
>
> Can anyone pl help me what went wrong?
>
>
> Thanks In Advance,
>
> Deepesh
>
>
> This e-mail and any files transmitted with it are for the sole use of the intended recipient(s) and may contain confidential and privileged information.
> If you are not the intended recipient, please contact the sender by reply e-mail and destroy all copies of the original message.
> Any unauthorized review, use, disclosure, dissemination, forwarding, printing or copying of this email or any action taken in reliance on this e-mail is strictly
> prohibited and may be unlawful.
>
> Visit us at http://www.cognizant.com