Hi Rod,
I've been trying to reproduce your problem, but it works for me.
(3.2.2RC5)
You have a transaction that creates some cmp instances
and does some things with relations and an update.
This commits ok, and as you say, you can see the results externally.
You then invoke getLocations() outside a transaction,
which asks for a db connection - is this the query that is failing to
see the data?
I don't see how it can fail, it is using the same
underlying db connection in both processes.
What does the getLocations() code look like?
Do you have any special db configuration, you mentioned
stored procedures in a previous post?
Can you try the following:
System.out.println("Connection warnings:");
SQLWarning w = connection.getWarnings();
while (w != null)
{
System.out.println(w);
w = w.getNextWarning();
}
And the same for the statement/result set.
Also, can you try a simpler test:
Write a session bean with two methods (one Required, one NotSupported)
The first method inserts a record, the second tries to read it.
Invoke the methods in that order.
Does the second method see the data?
If it does, rewrite it to perform the same sql as your real
application and try it again.
Regards,
Adrian
On Thu, 2003-10-02 at 18:21, Rod Macpherson wrote:
> I did not realize my post of the TRACE was rejected because it was too
> long. I attached the log.
>
> This log "snippet" is from a single add operation of a table called
> REGION. There is also a preceding insert to a journal table called TX.
> The code that executes is humming right along in production on 3.0.7
> without a hitch. To paraphrase the problem, an update or an insert
> through an EJB is not showing up in susequent JDBC queries long after
> the commit has successfully complete. The entity beans themselves do
> reflect changes or additions. The data is visible in the database
> immediately using an external tool to view it. Restart JBoss and it
> shows up. Happens with insert-before-ejb-post-create or without it.
> Problem is manifest on Oracle or SQL Server but only in 3.2.2 flavored
> JBoss.
>
>
>
> -----Original Message-----
> From: Bill Burke [mailto:[EMAIL PROTECTED]
> Sent: Tuesday, September 30, 2003 10:51 PM
> To: [EMAIL PROTECTED]
> Subject: Re: [JBoss-user] EJB inserts do not show up in subsequent
> queries:
>
>
> So what's the behavior here? You do inserts within a transaction and
> commit, but you DO NOT see the inserts in DB? Or you do not see them
> within JBoss?
>
> Rod Macpherson wrote:
> > More information:
> >
> > Updates have the same problem: update an entity bean and resulting
> > update does NOT show up in subsequent JDBC query. Now, if we view the
> > updated value through an entity bean then it shows up, no problemo.
> > The guilty party seems to be JDBC but yet it's not the driver because
> > a) it's the same driver we use in 3.0.7, b) it happens on SQL Server
> > or Oracle 9i.
> >
> > Is there anything else we can do to help narrow this down for you
> > guys?
> >
> > Thanks,
> >
> > Rod
> >
> > -----Original Message-----
> > From: Rod Macpherson
> > Sent: Tuesday, September 30, 2003 5:37 PM
> > To: [EMAIL PROTECTED]
> > Subject: RE: [JBoss-user] EJB inserts do not show up in subsequent
> > queries:
> >
> >
> > New Info: the SQL is the same except that we get this message on 3.0.7
>
> > but NOT on 3.2.2:
> >
> > 13:33:20,468 DEBUG [Region] Rows affected = 1
> >
> > There is no "Rows affected" message on 3.2.2 but then the logging has
> > changed so who knows if it's significant. We definitely had debugging
> > on for SQL in both cases. I tried taking out the new
> > insert-after-ejb-post-create container configuration but the result
> > was the same: inserts on 3.2.2 RC4 do not show up until you restart
> > JBoss.
> >
> > Rod
> >
> > -----Original Message-----
> > From: Alexey Loubyansky [mailto:[EMAIL PROTECTED]
> > Sent: Tuesday, September 30, 2003 9:43 AM
> > To: [EMAIL PROTECTED]
> > Subject: Re: [JBoss-user] EJB inserts do not show up in subsequent
> > queries:
> >
> >
> > Can you see the SQL executed? Any differences?
> > What does "we must bounce JBoss..." mean?
> >
> > Thanks,
> > alex
> >
> > Rod Macpherson wrote:
> >
> >
> >>3.2.2 RC4 is NFG:
> >>
> >>Ran the same EAR against the same database on 3.0.7 without incident.
> >>On 3.2.2 RC4 we must bounce JBoss to see inserted records.
> >>
> >>
> >>-----Original Message-----
> >>From: Rod Macpherson
> >>Sent: Tuesday, September 30, 2003 5:13 AM
> >>To: [EMAIL PROTECTED]
> >>Subject: RE: [JBoss-user] EJB inserts do not show up in subsequent
> >>queries
> >>
> >>
> >>TX commits (we can see the data with, say, toad or enterprise manager)
> >
> >
> >>and subsequent session bean call initiated query does not show the
> >>data. The insert is initiated with an HTTP request and the view is
> >>initiated in a separate HTTP request so the TX either succeeded or
> >>silently failed but we can see the data outside of JBoss.
> >>
> >>This is our first use of 3.2.2 and we are using the x-ds.xml examples
> >>as the basis of our sqlserver and oracle ds configurations. Point
> >>being this is not a sudden breakage but rather a new migration from
> >>3.0. so it could be pilot error on our part. Drivers are the same,
> >>code is the same, database is the same, new JBoss 3.2.2 RC4. Also
> >>tried local build RC4 source with jetty as the web container: same
> >>problem.
> >>
> >>This morning I will personally verify that we ran the same app against
> >
> >
> >>JBoss 3.0 without incident. AFAIK that test was done and everything
> >>was fine in 3.0. Maybe there is something obvious in the oracle-ds.xml
> >
> >
> >>and mssql-ds.xml we did not do?
> >>
> >><?xml version="1.0" encoding="UTF-8"?>
> >>
> >><datasources>
> >> <local-tx-datasource>
> >> <jndi-name>OracleDSX</jndi-name>
> >> <connection-url>jdbc:oracle:thin:@foo:1521:bar</connection-url>
> >> <driver-class>oracle.jdbc.driver.OracleDriver</driver-class>
> >> <user-name>austin</user-name>
> >> <password>shaggadelic</password>
> >>
> >><exception-sorter-class-name>org.jboss.resource.adapter.jdbc.vendor.Or
> >>ac
> >>leExceptionSorter</exception-sorter-class-name>
> >> </local-tx-datasource>
> >></datasources>
> >>
> >>
> >>-----Original Message-----
> >>From: Bill Burke [mailto:[EMAIL PROTECTED]
> >>Sent: Monday, September 29, 2003 5:00 PM
> >>To: [EMAIL PROTECTED]
> >>Subject: Re: [JBoss-user] EJB inserts do not show up in subsequent
> >>queries
> >>
> >>
> >>version? Same tx? Did tx commit?
> >>
> >>Bill
> >>
> >>Rod Macpherson wrote:
> >>
> >>
> >>
> >>>New records created using entity beans are not showing up in
> >>>subsequent queries. Problem is manifest using both SQL Server and
> >>>Oracle in 3.2.2
> >>
> >>
> >>>RCX - no problem on 3.0.X.
> >>
> >>
> >
> >
> >
> >
> > -------------------------------------------------------
> > This sf.net email is sponsored by:ThinkGeek
> > Welcome to geek heaven.
> > http://thinkgeek.com/sf
> > _______________________________________________
> > JBoss-user mailing list
> > [EMAIL PROTECTED]
> > https://lists.sourceforge.net/lists/listinfo/jboss-user
> >
> >
> > -------------------------------------------------------
> > This sf.net email is sponsored by:ThinkGeek
> > Welcome to geek heaven.
> > http://thinkgeek.com/sf
> > _______________________________________________
> > JBoss-user mailing list
> > [EMAIL PROTECTED]
> > https://lists.sourceforge.net/lists/listinfo/jboss-user
> >
> >
> > -------------------------------------------------------
> > This sf.net email is sponsored by:ThinkGeek
> > Welcome to geek heaven.
> > http://thinkgeek.com/sf
> > _______________________________________________
> > JBoss-user mailing list
> > [EMAIL PROTECTED]
> > https://lists.sourceforge.net/lists/listinfo/jboss-user
> >
> >
--
xxxxxxxxxxxxxxxxxxxxxxxx
Adrian Brock
Director of Support
Back Office
JBoss Group, LLC
xxxxxxxxxxxxxxxxxxxxxxxx
-------------------------------------------------------
This sf.net email is sponsored by:ThinkGeek
Welcome to geek heaven.
http://thinkgeek.com/sf
_______________________________________________
JBoss-user mailing list
[EMAIL PROTECTED]
https://lists.sourceforge.net/lists/listinfo/jboss-user
