I turned it up to trace and got for my method call that it's bombing on the
below. I've noted that odd relational query, it just doesn't make sense. It's
almost like the foreign-key-fields mapping is wrong. I tried taking out the
section (docs say it's auto generated), but still say results.
2002-06-07 08:30:48,349 TRACE [org.jboss.ejb.plugins.LogInterceptor] Start
method=getUserView
2002-06-07 08:30:48,350 TRACE [org.jboss.ejb.plugins.TxInterceptorCMT] Current
transaction in MI is null
2002-06-07 08:30:48,350 TRACE [org.jboss.ejb.plugins.TxInterceptorCMT]
TX_REQUIRED for getUserView
2002-06-07 08:30:48,351 TRACE [org.jboss.ejb.plugins.TxInterceptorCMT] Thread
came in with tx null
2002-06-07 08:30:48,352 TRACE [org.jboss.ejb.plugins.TxInterceptorCMT] Starting
new tx TransactionImpl:XidImpl [FormatId=257, GlobalId=zoot//7, BranchQual=]
2002-06-07 08:30:48,354 TRACE [org.jboss.ejb.plugins.EntityLockInterceptor]
Begin invoke, key=1000
2002-06-07 08:30:48,356 TRACE [org.jboss.ejb.plugins.EntityInstancePool] Get
instance org.jboss.ejb.plugins.EntityInstancePool@6b93c5#true#class
org.blandsite.music.play.PlaylistBean
2002-06-07 08:30:48,358 TRACE [org.jboss.ejb.plugins.AbstractInstanceCache]
Activated bean PlaylistBean with id = 1000
2002-06-07 08:30:48,358 TRACE
[org.jboss.ejb.plugins.LRUEnterpriseContextCachePolicy] entryAdded, entry=key:
1000, object: 43724e, entry: 57305
2002-06-07 08:30:48,359 TRACE [org.jboss.ejb.plugins.EntityInstanceInterceptor]
Begin invoke, key=1000
2002-06-07 08:30:48,359 TRACE
[org.jboss.ejb.plugins.EntitySynchronizationInterceptor] invoke called for ctx
org.jboss.ejb.EntityEnterpriseContext@43724e, tx=TransactionImpl:XidImpl
[FormatId=257, GlobalId=zoot//7, BranchQual=]
2002-06-07 08:30:48,360 TRACE
[org.jboss.ejb.plugins.cmp.jdbc.JDBCStoreManager.PlaylistBean] RESET PERSISTENCE
CONTEXT: id=1000
2002-06-07 08:30:48,360 TRACE
[org.jboss.ejb.plugins.cmp.jdbc.ReadAheadCache.PlaylistBean] load data:
entity=PlaylistBean pk=1000
2002-06-07 08:30:48,361 TRACE
[org.jboss.ejb.plugins.cmp.jdbc.ReadAheadCache.PlaylistBean] No preload data
found: entity=PlaylistBean pk=1000
2002-06-07 08:30:48,361 TRACE
[org.jboss.ejb.plugins.cmp.jdbc.JDBCLoadEntityCommand.PlaylistBean] Eager-load
for entity: readahead=[JDBCReadAheadMetaData : strategy=on-load, pageSize=255,
eagerLoadGroup=*]
2002-06-07 08:30:48,369 DEBUG
[org.jboss.ejb.plugins.cmp.jdbc.JDBCLoadEntityCommand.PlaylistBean] Executing
SQL: SELECT user_id, name, user FROM playlists WHERE (playlist_id=?)
[ This is just not right. Maybe it should be:
SELECT name, user_id from playlists where (playlist_id=?)
the UserBean should be a "parent" relationship to the PlaylistBean.]
2002-06-07 08:30:48,370 TRACE
[org.jboss.ejb.plugins.cmp.jdbc.bridge.JDBCCMP2xFieldBridge.PlaylistBean.playlistId]
Set parameter: index=1, jdbcType=INTEGER, value=1000
2002-06-07 08:30:48,377 TRACE
[org.jboss.ejb.plugins.cmp.jdbc.bridge.JDBCCMP2xFieldBridge.PlaylistBean.userId]
Get result: index=1, javaType=int, Simple, value=4
2002-06-07 08:30:48,378 TRACE
[org.jboss.ejb.plugins.cmp.jdbc.bridge.JDBCCMP2xFieldBridge.PlaylistBean.name]
Get result: index=2, javaType=java.lang.String, Simple, value=first playlist
2002-06-07 08:30:48,385 TRACE
[org.jboss.ejb.plugins.EntitySynchronizationInterceptor] loadEntity Exception,
clear tx for ctx=org.jboss.ejb.EntityEnterpriseContext@43724e,
tx=TransactionImpl:XidImpl [FormatId=257, GlobalId=zoot//7, BranchQual=]
2002-06-07 08:30:48,386 TRACE
[org.jboss.ejb.plugins.LRUEnterpriseContextCachePolicy] entryRemoved, entry=key:
null, object: null, entry: 57305
2002-06-07 08:30:48,386 TRACE [org.jboss.ejb.plugins.EntityInstanceInterceptor]
Ending invoke, exceptionThrown, ctx=org.jboss.ejb.EntityEnterpriseContext@43724e
2002-06-07 08:30:48,387 TRACE [org.jboss.ejb.plugins.EntityInstanceInterceptor]
End invoke, key=1000, ctx=org.jboss.ejb.EntityEnterpriseContext@43724e
2002-06-07 08:30:48,387 TRACE [org.jboss.ejb.plugins.EntityLockInterceptor] End
invoke, key=1000
2002-06-07 08:30:48,388 TRACE [org.jboss.ejb.plugins.TxInterceptorCMT]
TxInterceptorCMT: In finally
2002-06-07 08:30:48,404 TRACE [org.jboss.ejb.plugins.LogInterceptor] End
method=getUserView
I have looked over my ejb-jar.xml and jbosscmp-jdbc.xml a lot, not sure what I
got wrong here. You want me to post my problem as a bug?
--
-bk
Quoting Brandon Knitter <[EMAIL PROTECTED]>:
> Just noticed something.
>
> > 2002-06-06 22:05:51,823 DEBUG
> >
>
[org.jboss.ejb.plugins.cmp.jdbc.JDBCFindByPrimaryKeyQuery.PlaylistBean.findByPrimaryKey]
> > Executing SQL: SELECT playlist_id FROM playlists WHERE playlist_id=?
>
> The above is correct SQL.
>
> > 2002-06-06 22:05:52,145 DEBUG
> > [org.jboss.ejb.plugins.cmp.jdbc.JDBCLoadEntityCommand.PlaylistBean]
> Executing
> > SQL: SELECT user_id, name, user FROM playlists WHERE (playlist_id=?)
>
> This is not correct, the field "user" does not exist in playlists. How did
> it
> generate that?
>
> ejukebox=> \d playlists
> Table "playlists"
> Attribute | Type | Modifier
> -------------+-----------------------+----------
> playlist_id | integer | not null
> user_id | integer |
> name | character varying(60) |
> Indices: playlists_pkey,
> xifplaylists_users,
> xpkplaylists
>
> ejukebox=> \d users
> Table "users"
> Attribute | Type | Modifier
> ------------------+--------------------------+------------
> user_id | integer | not null
> uid | character varying(40) |
> pwd | character varying(255) |
> fn | character varying(255) |
> ln | character varying(255) |
> email | text |
> last_login | timestamp with time zone |
> total_artists | double precision |
> total_albums | double precision |
> total_titles | double precision |
> total_filesize | double precision |
> total_songlength | double precision |
> total_update | timestamp with time zone |
> bitrate | integer | default 32
> playlink | integer |
> Indices: users_pkey,
> xakusers_uid,
> xpkusers
>
> ejukebox=>
>
> I'll turn up the logs and try again...thanks!
>
>
> --
> -bk
>
>
> Quoting Dain Sundstrom <[EMAIL PROTECTED]>:
>
> > Doh, It looks like we have gone to far in reducing the excessive
> > exception reporting.
> >
> > You could try turing up the logging in the log4j.xml file. It has
> > examples and good comments.
> >
> > If you can't figure it out, post a bug report at sourceforge and I'll
> > take a look at it.
> >
> > -dain
> >
> > Brandon Knitter wrote:
> >
> > > I'm tailing server.log, the only thing showing up during my request is:
> > >
> > >
> > > 2002-06-06 22:05:51,731 DEBUG
> > > [org.jboss.resource.adapter.jdbc.local.LocalManagedConnectionFactory]
> > Using
> > > properties: {user=ejukebox, password=xxxxxxxxxx}
> > > 2002-06-06 22:05:51,823 DEBUG
> > >
> >
>
[org.jboss.ejb.plugins.cmp.jdbc.JDBCFindByPrimaryKeyQuery.PlaylistBean.findByPrimaryKey]
> > > Executing SQL: SELECT playlist_id FROM playlists WHERE playlist_id=?
> > > 2002-06-06 22:05:52,145 DEBUG
> > > [org.jboss.ejb.plugins.cmp.jdbc.JDBCLoadEntityCommand.PlaylistBean]
> > Executing
> > > SQL: SELECT user_id, name, user FROM playlists WHERE (playlist_id=?)
> > >
> > > Which looks about right for a prepared statement...any ideas? Is there
> a
> > way to
> > > turn up vebosity?
> > >
> > >
> >
> >
> >
> > _______________________________________________________________
> >
> > Don't miss the 2002 Sprint PCS Application Developer's Conference
> > August 25-28 in Las Vegas -- http://devcon.sprintpcs.com/adp/index.cfm
> >
> > _______________________________________________
> > JBoss-user mailing list
> > [EMAIL PROTECTED]
> > https://lists.sourceforge.net/lists/listinfo/jboss-user
> >
> >
>
>
>
> _______________________________________________________________
>
> Don't miss the 2002 Sprint PCS Application Developer's Conference
> August 25-28 in Las Vegas -- http://devcon.sprintpcs.com/adp/index.cfm
>
> _______________________________________________
> JBoss-user mailing list
> [EMAIL PROTECTED]
> https://lists.sourceforge.net/lists/listinfo/jboss-user
>
>
_______________________________________________________________
Don't miss the 2002 Sprint PCS Application Developer's Conference
August 25-28 in Las Vegas -- http://devcon.sprintpcs.com/adp/index.cfm
_______________________________________________
JBoss-user mailing list
[EMAIL PROTECTED]
https://lists.sourceforge.net/lists/listinfo/jboss-user
