Guy,
I am not using EJB for now, long story... but I will get this team there.
What I am using JBoss for right now is the connection pooling and in the
next release maybe JMS, JavaMail, and Connectors to SAP.
I have spent the last 3 hours looking at the problem and it is like a ghost.
After turning Jboss off and on for sometime I finally see the changes that
were made to the database via SQLPlus. What puzzles me is that I can query
the db but not update to it with the updates immediately committed to the
db. The JBoss console tells me that it has a new connection object,
preparedstatement works get the return code of 1 and JBoss releases the
connection to the pool. The int return code from the preparedstatement (a
java thing) I trust.
Does JBoss cache the information in memory? I remember a thread on that but
a long time ago.
Is it possible that future JBoss releases can incorporate a SQL debugger
that will allow developers to check what the db is doing, like if and when
it commits? For now I am pointing my framework to use Struts dataSource
feature.
Thanks,
Southin
-----Original Message-----
From: Guy Rouillier [mailto:[EMAIL PROTECTED]]
Sent: Friday, April 06, 2001 2:23 PM
To: [EMAIL PROTECTED]
Subject: Re: [JBoss-user] Oracle 8i
Sounds like your change is being made but not committed. What type of EJB
is this? Are you managing your own transaction? Are you turning autocommit
off?
----- Original Message -----
From: "Simphoukham, Southin" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, April 06, 2001 12:32 PM
Subject: [JBoss-user] Oracle 8i
> Hi,
>
> Has anyone run into problems on making an update to an Oracle table?
>
> I have run into such a problem. I have created a preparedStatement and
> called the preparedStatement.excuteUpdate. The update returns a value of
1
> (which is good). I turn around and check to make sure it works in
SQLPlus.
> Wrong. I turn on the loggingenable option in the Mbean in the jcml.
> Everything looks good though the logging doesn't tell me if it actually
> excuted and committed the changes to Oracle. I know I can definitely
> retrieve using Jboss's connection pool saving ummm.
> oh yes I also copy the sql and pasted in SQLPlus and excuted it. That
> worked.
>
> Thanks,
>
> Southin Simphoukham
>
>
>
> _______________________________________________
> JBoss-user mailing list
> [EMAIL PROTECTED]
> http://lists.sourceforge.net/lists/listinfo/jboss-user
>
_______________________________________________
JBoss-user mailing list
[EMAIL PROTECTED]
http://lists.sourceforge.net/lists/listinfo/jboss-user
_______________________________________________
JBoss-user mailing list
[EMAIL PROTECTED]
http://lists.sourceforge.net/lists/listinfo/jboss-user
