Thanks,
alex
Rod Macpherson wrote:
We do see inserts and updates in the DB using SQL*Plus for example. We
also see inserts and updates if we fetch an entity bean to view the new
or updated record. The problem behavior is that JDBC database queries
(using connections from the same datasource we use for our entity beans)
do not reflect inserts or updates. Same problem behavior on Oracle as we
have on SQL Server. Same issue whether we use insert-after-ejb-create or
not. Problem does NOT appear using the same EAR and same DB running on
3.0.7 or earlier.
Examined the SQL output as requested and it looks the same on 3.0.7 as
it does on 3.2.2. The only difference, and this may just reflect a
change in the logging configuration, is that we get a "Rows affected =
1" message on 3.0.7 after an EJB create/update. That message does not
appear in 3.2.2. Nothing is broken, there are no exceptions being thrown
or anything like that, it's just that we cannot see changes using JDBC
queries without a server bounce.
I hope that's clear. Lemme know if there is anything else we can do to
clarify. I had one of our guys test this and then walked through it
myself and checked that the only difference was indeed the version of
JBoss we were running.
Rod
-----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
------------------------------------------------------- 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
