12:33 p.m.
Hi
Is there anyone that knows how to get the booking sample to fully work with the MS SQL
Server. I've changed the booking-ds.xml to:
<?xml version="1.0" encoding="UTF-8"?>
<local-tx-datasource>
<jndi-name>bookingDatasource</jndi-name>
<connection-url>jdbc:jtds:sqlserver://localhost:1433;DatabaseName=booking;SelectMethod=cursor;user=sa;password=xx</connection-url>
<driver-class>net.sourceforge.jtds.jdbc.Driver</driver-class>
</local-tx-datasource>
when I press the final "confirm"-button which fires the
"hotelBooking.confirm" the transaction hungs. My Jboss server.log looks like
this:
2007-01-02 18:55:17,843 DEBUG [org.jboss.seam.core.Events] Processing
event:bookingConfirmed
2007-01-02 18:55:17,843 DEBUG [org.jboss.seam.contexts.Contexts] found in session context:
bookingList
2007-01-02 18:55:17,859 DEBUG
[org.jboss.ejb3.entity.ExtendedPersistenceContextPropagationInterceptor] ++++
LongLivedSessionPropagationInterceptor
2007-01-02 18:55:17,859 DEBUG [org.jboss.seam.Component] trying to inject with
hierarchical context search: user
2007-01-02 18:55:17,859 DEBUG [org.jboss.seam.contexts.Contexts] found in session context:
user
2007-01-02 18:55:17,859 DEBUG [org.jboss.seam.Component] selected row: null
2007-01-02 18:55:17,859 DEBUG [org.hibernate.impl.SessionImpl] opened session at
timestamp: 4783147081150464
2007-01-02 18:55:17,859 DEBUG [org.hibernate.ejb.AbstractEntityManagerImpl] Looking for a
JTA transaction to join
2007-01-02 18:55:17,859 DEBUG [org.hibernate.jdbc.JDBCContext] successfully registered
Synchronization
2007-01-02 18:55:17,859 DEBUG [org.hibernate.ejb.AbstractEntityManagerImpl] Looking for a
JTA transaction to join
2007-01-02 18:55:17,859 DEBUG [org.hibernate.ejb.AbstractEntityManagerImpl] Transaction
already joined
2007-01-02 18:55:17,859 DEBUG [org.hibernate.jdbc.AbstractBatcher] about to open
PreparedStatement (open PreparedStatements: 0, globally: 0)
2007-01-02 18:55:17,859 DEBUG [org.hibernate.jdbc.ConnectionManager] opening JDBC
connection
2007-01-02 18:55:17,859 DEBUG [org.hibernate.SQL] select booking0_.id as id0_,
booking0_.user_username as user10_0_, booking0_.checkinDate as checkinD2_0_,
booking0_.checkoutDate as checkout3_0_, booking0_.hotel_id as hotel11_0_,
booking0_.creditCard as creditCard0_, booking0_.smoking as smoking0_, booking0_.beds as
beds0_, booking0_.creditCardName as creditCa7_0_, booking0_.creditCardExpiryMonth as
creditCa8_0_, booking0_.creditCardExpiryYear as creditCa9_0_ from Booking booking0_ where
booking0_.user_username=? order by booking0_.checkinDate
2007-01-02 18:55:17,859 INFO [STDOUT] Hibernate: select booking0_.id as id0_,
booking0_.user_username as user10_0_, booking0_.checkinDate as checkinD2_0_,
booking0_.checkoutDate as checkout3_0_, booking0_.hotel_id as hotel11_0_,
booking0_.creditCard as creditCard0_, booking0_.smoking as smoking0_, booking0_.beds as
beds0_, booking0_.creditCardName as creditCa7_0_, booking0_.creditCardExpiryMonth as
creditCa8_0_, booking0_.creditCardExpiryYear as creditCa9_0_ from Booking booking0_ where
booking0_.user_username=? order by booking0_.checkinDate
2007-01-02 18:55:17,859 DEBUG [org.hibernate.loader.hql.QueryLoader] bindNamedParameters()
stefan -> username [1]
2007-01-02 19:00:17,828 WARN [org.jboss.tm.TransactionImpl] Transaction
TransactionImpl:XidImpl[FormatId=257, GlobalId=se10offws0009/37, BranchQual=, localId=37]
timed out. status=STATUS_ACTIVE
2007-01-02 19:00:17,859 WARN [org.jboss.tm.TransactionImpl] Transaction
TransactionImpl:XidImpl[FormatId=257, GlobalId=se10offws0009/38, BranchQual=, localId=38]
timed out. status=STATUS_ACTIVE
end server.log extract
I compared this with the corresponding log when I used the default database engine: HSQL
which looks like this:
2007-01-03 18:49:18,906 DEBUG [org.jboss.seam.core.Events] Processing
event:bookingConfirmed
2007-01-03 18:49:18,906 DEBUG [org.jboss.seam.contexts.Contexts] found in session context:
bookingList
2007-01-03 18:49:18,906 DEBUG
[org.jboss.ejb3.entity.ExtendedPersistenceContextPropagationInterceptor] ++++
LongLivedSessionPropagationInterceptor
2007-01-03 18:49:18,906 DEBUG [org.jboss.seam.Component] trying to inject with
hierarchical context search: user
2007-01-03 18:49:18,906 DEBUG [org.jboss.seam.contexts.Contexts] found in session context:
user
2007-01-03 18:49:18,906 DEBUG [org.jboss.seam.Component] selected row: null
2007-01-03 18:49:18,906 DEBUG [org.hibernate.impl.SessionImpl] opened session at
timestamp: 4783499505278976
2007-01-03 18:49:18,906 DEBUG [org.hibernate.ejb.AbstractEntityManagerImpl] Looking for a
JTA transaction to join
2007-01-03 18:49:18,906 DEBUG [org.hibernate.jdbc.JDBCContext] successfully registered
Synchronization
2007-01-03 18:49:18,906 DEBUG [org.hibernate.ejb.AbstractEntityManagerImpl] Looking for a
JTA transaction to join
2007-01-03 18:49:18,906 DEBUG [org.hibernate.ejb.AbstractEntityManagerImpl] Transaction
already joined
2007-01-03 18:49:18,906 DEBUG [org.hibernate.jdbc.AbstractBatcher] about to open
PreparedStatement (open PreparedStatements: 0, globally: 0)
2007-01-03 18:49:18,906 DEBUG [org.hibernate.jdbc.ConnectionManager] opening JDBC
connection
2007-01-03 18:49:18,906 DEBUG [org.hibernate.SQL] select booking0_.id as id0_,
booking0_.user_username as user10_0_, booking0_.checkinDate as checkinD2_0_,
booking0_.checkoutDate as checkout3_0_, booking0_.hotel_id as hotel11_0_,
booking0_.creditCard as creditCard0_, booking0_.smoking as smoking0_, booking0_.beds as
beds0_, booking0_.creditCardName as creditCa7_0_, booking0_.creditCardExpiryMonth as
creditCa8_0_, booking0_.creditCardExpiryYear as creditCa9_0_ from Booking booking0_ where
booking0_.user_username=? order by booking0_.checkinDate
2007-01-03 18:49:18,906 INFO [STDOUT] Hibernate: select booking0_.id as id0_,
booking0_.user_username as user10_0_, booking0_.checkinDate as checkinD2_0_,
booking0_.checkoutDate as checkout3_0_, booking0_.hotel_id as hotel11_0_,
booking0_.creditCard as creditCard0_, booking0_.smoking as smoking0_, booking0_.beds as
beds0_, booking0_.creditCardName as creditCa7_0_, booking0_.creditCardExpiryMonth as
creditCa8_0_, booking0_.creditCardExpiryYear as creditCa9_0_ from Booking booking0_ where
booking0_.user_username=? order by booking0_.checkinDate
2007-01-03 18:49:18,906 DEBUG [org.hibernate.loader.hql.QueryLoader] bindNamedParameters()
stefan -> username [1]
2007-01-03 18:49:18,906 DEBUG [org.hibernate.jdbc.AbstractBatcher] about to open ResultSet
(open ResultSets: 0, globally: 0)
2007-01-03 18:49:18,906 DEBUG [org.hibernate.loader.Loader] result row:
EntityKey[org.jboss.seam.example.booking.Booking#1]
It seems that the "...AbstractBatcher" could never open the booking ResultSet
for some reason when I'm using the MS SQL Server.
I'm currently running JBoss SEAM 1.1 GA with JBoss Server 4.0.5 GA
I've also tried the Jboss SEAM 1.0.1 GA with JBoss 4.0.4 EJB3-RC8 with the same
problem as result.
Please, someone help me!!
/kaolle
View the original post :
http://www.jboss.com/index.html?module=bb&op=viewtopic&p=3997656#...
Reply to the post :
http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&a...