Re: [JBoss-dev] (Moved from) [JBoss-user] Using sequences/Identity columns for PK values

[Justin Casp]

At least it's on the drawing board, that's all that matters.  I figured that 
the idea was ok but the method wouldn't be.  Any guess as to when it might 
appear?  How are you planning on implementing this feature?
Justin

 This is definitely a hack (not a pattern), but if it works for you, use
 it.  Support for auto number keys is on the todo list.

 -dain

 Justin Casp wrote:
  hey List
  I posted this problem/workaround to the jboss-user list but never got a
  response.  Maybe it got lost in the shuffle or maybe it's just a stupid
  idea. Please tell me what you think either way.
 
  My problem is dealing with PK fields that are set to auto-increment in
  the database (e.g., sequence on Postgres or indentity on MS Sql).  My
  current workaround is to use a simple BMP entity that only has an
  ejbCreate() method so I can specify my own SQL statement with the PK
  column left out.
 
  a solution might be:
 however, I think that the ability to specify a primary key field as
 'datasource-provided' in the jbosscmp-jdbc dd would be a useful feature
  in JBoss.  Is this logically sound or am I missing something here? 
  JBoss would only have to check for the presence of this tag and, if
  present, not include this column in the generated SQL insert statement.
 
  thanks for your input.
  Justin
 
 
 
 
  ---
  Sponsored by:
  ThinkGeek at http://www.ThinkGeek.com/
  ___
  Jboss-development mailing list
  [EMAIL PROTECTED]
  https://lists.sourceforge.net/lists/listinfo/jboss-development



---
This sf.net email is sponsored by: Jabber Inc.
Don't miss the IM event of the season | Special offer for OSDN members! 
JabConf 2002, Aug. 20-22, Keystone, CO http://www.jabberconf.com/osdn
___
Jboss-development mailing list
[EMAIL PROTECTED]
https://lists.sourceforge.net/lists/listinfo/jboss-development

[JBoss-dev] (Moved from) [JBoss-user] Using sequences/Identity columns for PK values

[Justin Casp]

hey List
I posted this problem/workaround to the jboss-user list but never got a 
response.  Maybe it got lost in the shuffle or maybe it's just a stupid idea.  
Please tell me what you think either way.

My problem is dealing with PK fields that are set to auto-increment in the 
database (e.g., sequence on Postgres or indentity on MS Sql).  My current 
workaround is to use a simple BMP entity that only has an ejbCreate() method 
so I can specify my own SQL statement with the PK column left out.

a solution might be:
 however, I think that the ability to specify a primary key field as
 'datasource-provided' in the jbosscmp-jdbc dd would be a useful feature in
 JBoss.  Is this logically sound or am I missing something here?  JBoss
 would only have to check for the presence of this tag and, if present, not
 include this column in the generated SQL insert statement.

thanks for your input.
Justin




---
Sponsored by:
ThinkGeek at http://www.ThinkGeek.com/
___
Jboss-development mailing list
[EMAIL PROTECTED]
https://lists.sourceforge.net/lists/listinfo/jboss-development

[JBoss-dev] new JBoss website KDE's konqueror

[Justin Casp]

Hey List,
I just wanted to say the new JBoss website looks very nice.  However, one 
thing would make it even better: if it rendered properly in konqueror 
3.0.0-2, the KDE 3.0 web browser.  The main content area is not bounded by 
the window; it extends several screen-widths to the right, forcing a lot of 
horizontal scrolling.  Briefly looking at the html, it appears to be a table 
opening/closing issue (i.e., not properly completing a table and/or a few 
td tags) near the beginning of the content section (starting around 
'!SIMPLER, CHEAPER, BETTER!').

look towards the end of the output from the following page (midway down):
http://validator.w3.org/check/?uri=http%3A//main.jboss.org/

The site renders fine in mozilla though, which is generally a bit more 
forgiving than konqueror.

Thanks for all of the hard work you fellas put into this product.  It is 
certainly appreciated.
Justin


___

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-development mailing list
[EMAIL PROTECTED]
https://lists.sourceforge.net/lists/listinfo/jboss-development

Re: [JBoss-dev] [ jboss-Bugs-562004 ] 'Error setting column value' using dependent value classes with existing db records

[Justin Casp]

hey List,

Since there hasn't been any feedback on this bug yet, I would like to start 
taking a look at it myself, as it is important for the project I'm working 
on.  I would appreciate any extra developer documentation (UML diagrams would 
be super) that might be out there that would help me get up to speed quickly 
on (for starters) the JBossCMP portion of the codebase.
I looked on the developer page of the website, but noticed that the developer 
guide page ( http://main.jboss.org/developers/guide/ ) is empty.

I already have a working cvs HEAD, so I'm really just looking for codebase 
docs.
Thanks
justin

 Bugs item #562004, was opened at 2002-05-29 14:11
 You can respond by visiting:
 http://sourceforge.net/tracker/?func=detailatid=376685aid=562004group_id
=22866

 Category: JBossCMP
 Group: CVS HEAD
 Status: Open
 Resolution: None
 Priority: 5
 Submitted By: Justin Casp (jcasp)
 Assigned to: Nobody/Anonymous (nobody)
 Summary: 'Error setting column value' using dependent value classes with
 existing db records

 Initial Comment:
 I posted this problem a few weeks ago on jboss.org forums, but it's down
 right
 now so I can't reference that post.  I figured out how to create a simple
 test case that reliably reproduces the problem.

 The error message 'Error setting column value' occurs when I have an
 existing CMP bean that reads existing records from a datasource.  The bean
 uses a dependent value class, although I'm not sure if this problem is
 specific to dependent value classes or just any cmp bean with fields
 mapped
 to columns.
 If I create the record externally (e.g., using psql, the postgres command
 line tool) and only set a few of the columns to non-null values, when I
 attempt to load that bean instance with a finder, jboss throws the
 following exception on
 the server:

 12:03:56,650 ERROR [STDERR] java.lang.NullPointerException
 12:03:56,652 ERROR [STDERR] at
 sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
 12:03:56,652 ERROR [STDERR] at
 sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:3
9) 12:03:56,653 ERROR [STDERR] at
 sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImp
l.java:25) 12:03:56,653 ERROR [STDERR] at
 java.lang.reflect.Method.invoke(Method.java:324)
 12:03:56,653 ERROR [STDERR] at
 org.jboss.ejb.plugins.cmp.jdbc.JDBCTypeComplexProperty.setColumnValue(JDBCT
ypeComplexProperty.java:142) 12:03:56,654 ERROR [STDERR] at
 org.jboss.ejb.plugins.cmp.jdbc.JDBCTypeComplex.setColumnValue(JDBCTypeCompl
ex.java:158) 12:03:56,654 ERROR [STDERR] at
 org.jboss.ejb.plugins.cmp.jdbc.JDBCTypeComplex.setColumnValue(JDBCTypeCompl
ex.java:133) 12:03:56,654 ERROR [STDERR] at
 org.jboss.ejb.plugins.cmp.jdbc.bridge.JDBCAbstractCMPFieldBridge.loadArgume
ntResults(JDBCAbstractCMPFieldBridge.java:352) 12:03:56,655 ERROR [STDERR]  
   at
 org.jboss.ejb.plugins.cmp.jdbc.bridge.JDBCAbstractCMPFieldBridge.loadInstan
ceResults(JDBCAbstractCMPFieldBridge.java:304) 12:03:56,655 ERROR [STDERR]  
   at
 org.jboss.ejb.plugins.cmp.jdbc.JDBCLoadEntityCommand.execute(JDBCLoadEntity
Command.java:140) 12:03:56,655 ERROR [STDERR] at
 org.jboss.ejb.plugins.cmp.jdbc.JDBCLoadEntityCommand.execute(JDBCLoadEntity
Command.java:62) 12:03:56,655 ERROR [STDERR] at
 org.jboss.ejb.plugins.cmp.jdbc.JDBCStoreManager.loadEntity(JDBCStoreManager
.java:496) 12:03:56,656 ERROR [STDERR] at
 org.jboss.ejb.plugins.CMPPersistenceManager.loadEntity(CMPPersistenceManage
r.java:410) 12:03:56,656 ERROR [STDERR] at
 org.jboss.resource.connectionmanager.CachedConnectionInterceptor.loadEntity
(CachedConnectionInterceptor.java:314) 12:03:56,656 ERROR [STDERR] at
 org.jboss.ejb.plugins.EntitySynchronizationInterceptor.invoke(EntitySynchro
nizationInterceptor.java:310) 12:03:56,657 ERROR [STDERR] at
 org.jboss.resource.connectionmanager.CachedConnectionInterceptor.invoke(Cac
hedConnectionInterceptor.java:147) 12:03:56,657 ERROR [STDERR] at
 org.jboss.ejb.plugins.EntityInstanceInterceptor.invoke(EntityInstanceInterc
eptor.java:193) 12:03:56,657 ERROR [STDERR] at
 org.jboss.ejb.plugins.EntityLockInterceptor.invoke(EntityLockInterceptor.ja
va:107) 12:03:56,658 ERROR [STDERR] at
 org.jboss.ejb.plugins.EntityCreationInterceptor.invoke(EntityCreationInterc
eptor.java:69) 12:03:56,658 ERROR [STDERR] at
 org.jboss.ejb.plugins.AbstractTxInterceptor.invokeNext(AbstractTxIntercepto
r.java:96) 12:03:56,658 ERROR [STDERR] at
 org.jboss.ejb.plugins.TxInterceptorCMT.runWithTransactions(TxInterceptorCMT
.java:167) 12:03:56,659 ERROR [STDERR] at
 org.jboss.ejb.plugins.TxInterceptorCMT.invoke(TxInterceptorCMT.java:61)
 12:03:56,659 ERROR [STDERR] at
 org.jboss.ejb.plugins.SecurityInterceptor.invoke(SecurityInterceptor.java:1
29) 12:03:56,659 ERROR [STDERR] at
 org.jboss.ejb.plugins.LogInterceptor.invoke(LogInterceptor.java:166)
 12:03:56,659 ERROR [STDERR