[JBoss-user] [Persistence CMP/JBoss] - problem with auto-increment field and CMP bean

2004-06-15 Thread nacho2004
I want to know if I can work with auto-increment with CMP beans.
I have a table with 2 fields:

id (identity)
dbPass
dbUrl
dbUser
dbDriver
dbName

and when I use a create() method 
ECollections collHome = collectionHome.create(dbPass,dbUrl,dbUser,dbDriver,dbName);

, the console display this error:

javax.ejb.CreateException: Could not create entity:java.sql.SQLException: 
[Microsoft][SQLServer 2000 Driver for JDBC][SQLServer]Cannot insert explicit value for 
identity column in table 'collections' when IDENTITY_INSERT is set to OFF.
at 
org.jboss.ejb.plugins.cmp.jdbc.JDBCAbstractCreateCommand.performInsert(JDBCAbstractCreateCommand.java:303)
at 
org.jboss.ejb.plugins.cmp.jdbc.JDBCAbstractCreateCommand.execute(JDBCAbstractCreateCommand.java:138)
at 
org.jboss.ejb.plugins.cmp.jdbc.JDBCStoreManager.createEntity(JDBCStoreManager.java:554)
at 
org.jboss.ejb.plugins.CMPPersistenceManager.createEntity(CMPPersistenceManager.java:208)
at 
org.jboss.resource.connectionmanager.CachedConnectionInterceptor.createEntity(CachedConnectionInterceptor.java:269)
at org.jboss.ejb.EntityContainer.createHome(EntityContainer.java:737)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at 
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at 
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:324)
at 
org.jboss.ejb.EntityContainer$ContainerInterceptor.invokeHome(EntityContainer.java:1043)
at 
org.jboss.ejb.plugins.AbstractInterceptor.invokeHome(AbstractInterceptor.java:88)
at 
org.jboss.ejb.plugins.EntitySynchronizationInterceptor.invokeHome(EntitySynchronizationInterceptor.java:197)
at 
org.jboss.resource.connectionmanager.CachedConnectionInterceptor.invokeHome(CachedConnectionInterceptor.java:214)
at 
org.jboss.ejb.plugins.AbstractInterceptor.invokeHome(AbstractInterceptor.java:88)
at 
org.jboss.ejb.plugins.EntityInstanceInterceptor.invokeHome(EntityInstanceInterceptor.java:89)
at 
org.jboss.ejb.plugins.EntityLockInterceptor.invokeHome(EntityLockInterceptor.java:61)
at 
org.jboss.ejb.plugins.EntityCreationInterceptor.invokeHome(EntityCreationInterceptor.java:28)
at 
org.jboss.ejb.plugins.AbstractTxInterceptor.invokeNext(AbstractTxInterceptor.java:88)
at 
org.jboss.ejb.plugins.TxInterceptorCMT.runWithTransactions(TxInterceptorCMT.java:267)
at org.jboss.ejb.plugins.TxInterceptorCMT.invokeHome(TxInterceptorCMT.java:98)
at 
org.jboss.ejb.plugins.SecurityInterceptor.invokeHome(SecurityInterceptor.java:92)
at org.jboss.ejb.plugins.LogInterceptor.invokeHome(LogInterceptor.java:120)
at 
org.jboss.ejb.plugins.ProxyFactoryFinderInterceptor.invokeHome(ProxyFactoryFinderInterceptor.java:93)
at org.jboss.ejb.EntityContainer.internalInvokeHome(EntityContainer.java:483)
at org.jboss.ejb.Container.invoke(Container.java:720)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at 
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at 
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:324)
at 
org.jboss.mx.capability.ReflectedMBeanDispatcher.invoke(ReflectedMBeanDispatcher.java:284)
at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:546)
at org.jboss.invocation.local.LocalInvoker.invoke(LocalInvoker.java:101)
at org.jboss.invocation.InvokerInterceptor.invoke(InvokerInterceptor.java:90)
at 
org.jboss.proxy.TransactionInterceptor.invoke(TransactionInterceptor.java:46)
at org.jboss.proxy.SecurityInterceptor.invoke(SecurityInterceptor.java:45)
at org.jboss.proxy.ejb.HomeInterceptor.invoke(HomeInterceptor.java:173)
at org.jboss.proxy.ClientContainer.invoke(ClientContainer.java:85)
at $Proxy236.create(Unknown Source)
at 
com.entrieva.skyline.sessionBeans.admin.SCollectionsBean.insertCollections(SCollectionsBean.java:171)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at 
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at 
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:324)
at 
org.jboss.ejb.StatelessSessionContainer$ContainerInterceptor.invoke(StatelessSessionContainer.java:683)
at 
org.jboss.resource.connectionmanager.CachedConnectionInterceptor.invoke(CachedConnectionInterceptor.java:185)
at 
org.jboss.ejb.plugins.StatelessSessionInstanceInterceptor.invoke(StatelessSessionInstanceInterceptor.java:72)
at 
org.jboss.ejb.plugins.AbstractTxInterceptor.invokeNext(AbstractTxInterceptor.java:84)
 

[JBoss-user] [Persistence CMP/JBoss] - Re: DataSource API's from JBoss

2004-06-11 Thread nacho2004
I want to change the CMP datasource on the fly.
Can I use CMP's in this context where I need to connect to different databases(with 
absolutely identical structure) 
for each client. Different databases mean different Datasources, hence how do I 
uniquely associate a CMP Entity Bean with a single table for a particular datasource. 
Also, we do not want a different entity bean set for each database! 

View the original post : 
http://www.jboss.org/index.html?module=bbop=viewtopicp=3838467#3838467

Reply to the post : 
http://www.jboss.org/index.html?module=bbop=postingmode=replyp=3838467


---
This SF.Net email is sponsored by the new InstallShield X.
From Windows to Linux, servers to mobile, InstallShield X is the
one installation-authoring solution that does it all. Learn more and
evaluate today! http://www.installshield.com/Dev2Dev/0504
___
JBoss-user mailing list
[EMAIL PROTECTED]
https://lists.sourceforge.net/lists/listinfo/jboss-user


[JBoss-user] [Persistence CMP/JBoss] - Re: Changing a Datasource at runtime

2004-06-10 Thread nacho2004
I read a note from Alexey Loubyansky on http://www.junlu.com/msg/36487.html but I 
can't get some other examples.
Could you give me an examples of your DataSource Factory ?
Thanks in advance!!!

View the original post : 
http://www.jboss.org/index.html?module=bbop=viewtopicp=3838320#3838320

Reply to the post : 
http://www.jboss.org/index.html?module=bbop=postingmode=replyp=3838320


---
This SF.Net email is sponsored by: GNOME Foundation
Hackers Unite!  GUADEC: The world's #1 Open Source Desktop Event.
GNOME Users and Developers European Conference, 28-30th June in Norway
http://2004/guadec.org
___
JBoss-user mailing list
[EMAIL PROTECTED]
https://lists.sourceforge.net/lists/listinfo/jboss-user


[JBoss-user] [Persistence CMP/JBoss] - DataSource API's from JBoss

2004-06-10 Thread nacho2004
Have Jboss some API's to work with datasource ? 

View the original post : 
http://www.jboss.org/index.html?module=bbop=viewtopicp=3838351#3838351

Reply to the post : 
http://www.jboss.org/index.html?module=bbop=postingmode=replyp=3838351


---
This SF.Net email is sponsored by the new InstallShield X.
From Windows to Linux, servers to mobile, InstallShield X is the
one installation-authoring solution that does it all. Learn more and
evaluate today! http://www.installshield.com/Dev2Dev/0504
___
JBoss-user mailing list
[EMAIL PROTECTED]
https://lists.sourceforge.net/lists/listinfo/jboss-user


[JBoss-user] [Persistence CMP/JBoss] - dinamic datasource in jbosscmp-jdbc.xml

2004-06-09 Thread nacho2004
hi everybody,

I have a jbosscmp-jdbc.xml file with this piece of code
jbosscmp-jdbc
   
 java:/skyline
 datasource-mappingMS SQLSERVER2000/datasource-mapping
   
.
.
/jbosscmp-jdbc

This xml is on EJBs.jar file.

And mssql-ds.xml (on jboss_home/server/default/deploy) has these lines

local-tx-datasource
jndi-nameskyline/jndi-name
connection- 
urljdbc:microsoft:sqlserver://localhost:1433;DatabaseName=skyline3/connection-url
driver-classcom.microsoft.jdbc.sqlserver.SQLServerDriver/driver-class
user-nameskyline/user-name
skyline
/local-tx-datasource

So, my client need to change dynamically the datasource for use a diferent database.
The question is : 
Can I change dynamically the java:/skyline into the EJBs.jar file to work with other 
database ?
Anybody give me some ideas to do that.
Thank in advance !!!


View the original post : 
http://www.jboss.org/index.html?module=bbop=viewtopicp=3838170#3838170

Reply to the post : 
http://www.jboss.org/index.html?module=bbop=postingmode=replyp=3838170


---
This SF.Net email is sponsored by: GNOME Foundation
Hackers Unite!  GUADEC: The world's #1 Open Source Desktop Event.
GNOME Users and Developers European Conference, 28-30th June in Norway
http://2004/guadec.org
___
JBoss-user mailing list
[EMAIL PROTECTED]
https://lists.sourceforge.net/lists/listinfo/jboss-user


[JBoss-user] [Persistence CMP/JBoss] - Re: dinamic datasource in jbosscmp-jdbc.xml

2004-06-09 Thread nacho2004
I think that is that I'm looking for.
I've 2 DB with the same tables and I need to choose one of them in every moment 
depends of the client choose

View the original post : 
http://www.jboss.org/index.html?module=bbop=viewtopicp=3838225#3838225

Reply to the post : 
http://www.jboss.org/index.html?module=bbop=postingmode=replyp=3838225


---
This SF.Net email is sponsored by: GNOME Foundation
Hackers Unite!  GUADEC: The world's #1 Open Source Desktop Event.
GNOME Users and Developers European Conference, 28-30th June in Norway
http://2004/guadec.org
___
JBoss-user mailing list
[EMAIL PROTECTED]
https://lists.sourceforge.net/lists/listinfo/jboss-user


[JBoss-user] [Persistence CMP/JBoss] - Changing a Datasource at runtime

2004-06-09 Thread nacho2004
Consider a hypothetical application that needs to be deployed on a single app server 
and has to service mulitple clients. Consider that there is a database per client. 
Thus n databases for n clients. However, all of these database have the same 
structure, and only the content varies. 

Now to the problem: 
  Can I use CMP's in this context where I need to connect to different databases(with 
absolutely identical structure) 
for each client. Different databases mean different Datasources, hence how do I 
uniquely associate a CMP Entity Bean with a single table for a particular datasource. 
Also, we do not want a different entity bean set for each database! 

View the original post : 
http://www.jboss.org/index.html?module=bbop=viewtopicp=3838245#3838245

Reply to the post : 
http://www.jboss.org/index.html?module=bbop=postingmode=replyp=3838245


---
This SF.Net email is sponsored by: GNOME Foundation
Hackers Unite!  GUADEC: The world's #1 Open Source Desktop Event.
GNOME Users and Developers European Conference, 28-30th June in Norway
http://2004/guadec.org
___
JBoss-user mailing list
[EMAIL PROTECTED]
https://lists.sourceforge.net/lists/listinfo/jboss-user


[JBoss-user] [Persistence CMP/JBoss] - jbosscmp-jdbc

2004-06-08 Thread nacho2004
well, I have a lot of beans running with :
   
 java:/skyline
 datasource-mappingMS SQLSERVER2000/datasource-mapping
   
and ...
I want to create other beans in the same jar file (EJBs.jar)
but these beans will be use a different jndi connection like
   
 java:/skylineAdmin
 datasource-mappingMS SQLSERVER2000/datasource-mapping
   
Can I do that ?



View the original post : 
http://www.jboss.org/index.html?module=bbop=viewtopicp=3838004#3838004

Reply to the post : 
http://www.jboss.org/index.html?module=bbop=postingmode=replyp=3838004


---
This SF.Net email is sponsored by: GNOME Foundation
Hackers Unite!  GUADEC: The world's #1 Open Source Desktop Event.
GNOME Users and Developers European Conference, 28-30th June in Norway
http://2004/guadec.org
___
JBoss-user mailing list
[EMAIL PROTECTED]
https://lists.sourceforge.net/lists/listinfo/jboss-user


[JBoss-user] [Persistence CMP/JBoss] - EJB-QL ordey by...

2004-05-26 Thread nacho2004
Hi everyBody !!!
well I want to know how can I do this query with ejb-ql:

SELECT * FROM documents WHERE docid =x ORDER BY docname ASC

I did try with this code but didn't running
*@ ejb.finder
 query=SELECT OBJECT(d) FROM documents d where d.docid=?1  order  by ?2 ?3


View the original post : 
http://www.jboss.org/index.html?module=bbop=viewtopicp=3836382#3836382

Reply to the post : 
http://www.jboss.org/index.html?module=bbop=postingmode=replyp=3836382



---
This SF.Net email is sponsored by: Oracle 10g
Get certified on the hottest thing ever to hit the market... Oracle 10g. 
Take an Oracle 10g class now, and we'll give you the exam FREE.
http://ads.osdn.com/?ad_id=3149alloc_id=8166op=click
___
JBoss-user mailing list
[EMAIL PROTECTED]
https://lists.sourceforge.net/lists/listinfo/jboss-user


[JBoss-user] [Persistence CMP/JBoss] - EJB-QL order by...

2004-05-26 Thread nacho2004
Hi everyBody !!!
well I want to know how can I do this query with ejb-ql:

SELECT * FROM documents WHERE docid =x ORDER BY docname ASC

I did try with this code but didn't running
*@ ejb.finder
 query=SELECT OBJECT(d) FROM documents d where d.docid=?1  order  by ?2 ?3


View the original post : 
http://www.jboss.org/index.html?module=bbop=viewtopicp=3836383#3836383

Reply to the post : 
http://www.jboss.org/index.html?module=bbop=postingmode=replyp=3836383



---
This SF.Net email is sponsored by: Oracle 10g
Get certified on the hottest thing ever to hit the market... Oracle 10g. 
Take an Oracle 10g class now, and we'll give you the exam FREE.
http://ads.osdn.com/?ad_id=3149alloc_id=8166op=click
___
JBoss-user mailing list
[EMAIL PROTECTED]
https://lists.sourceforge.net/lists/listinfo/jboss-user


[JBoss-user] [Persistence CMP/JBoss] - simplest one-to-one relationships bug

2004-05-18 Thread nacho2004
Hi all!!
I've 2 tables that contain the same primary key (docid)
and both have diferent fileds for a document
One of that has all the basic fields for a document and the other has metadata for the 
same document.
Obviously the relation is one-to-one
well, the names of the beans are : EDocuments and EDocMetaData 

This is the code for EDocuments:
/**
 * @ejb.bean name=EDocuments
 *  jndi-name=EDocumentsBean
 *  type=CMP
 *  schema=documents 
 *  cmp-version=2.x
 *  primkey-field=docid
 *
 *  @ejb.persistence 
 *   table-name=documents 
 * 
 * @ejb.finder 
 *query=SELECT OBJECT(a) FROM documents as a  
 *signature=java.util.Collection findAll()  
**/

/**
 * @ejb.interface-method
 * 
 * @ejb.relation
 *name=EDocuments-EDocMetaData  
 *role-name=EDocuments-has-one-EDocMetadata
 * 
 * @jboss.relation
 *related-pk-field=docid
 *fk-column=docid
 * 
 */

public abstract EDocMetaData getEDocMetaData();
/**
 * @ejb.interface-method
 * view-type=both
 */
public abstract void setEDocMetaData(EDocMetaData metaData);


and this is for EDocMetaData bean :
/**
 * @ejb.bean name=EDocMetaData
 *  jndi-name=EDocMetaDataBean
 *  type=CMP
 *  primkey-field=docid
 *  schema=docmetadata 
 *  cmp-version=2.x
 * 
 *  @ejb.persistence 
 *   table-name=docmetadata 
 * 
 * @ejb.finder 
 *query=SELECT OBJECT(a) FROM docmetadata as a  
 *signature=java.util.Collection findAll()  
 * 
 **/

/**
 * @ejb.interface-method
 * 
 * @ejb.relation
 *name=EDocuments-EDocMetaData  
 *role-name=EDocMetadata-has-one-EDocuments
 * @jboss.relation
 *related-pk-field=docid
 *fk-column=docid
*/

public abstract EDocuments getEDocuments();
public abstract void setEDocuments(EDocuments document);

This is the code for ejb-jar.xml

   !-- Relationships --
   
  ejb-relation 
 ejb-relation-nameEDocuments-EDocMetaData/ejb-relation-name

ejb-relationship-role 
  ejb-relationship-role-nameEDocuments-has-one-EDocMetadata
  /ejb-relationship-role-name
One
relationship-role-source 
   ejb-nameEDocuments/ejb-name
/relationship-role-source
cmr-field 
   cmr-field-nameEDocMetaData/cmr-field-name
/cmr-field
 /ejb-relationship-role

ejb-relationship-role 
  
ejb-relationship-role-nameEDocMetadata-has-one-EDocuments/ejb-relationship-role-name
One
relationship-role-source 
   ejb-nameEDocMetaData/ejb-name
/relationship-role-source
cmr-field 
   cmr-field-nameeocuments/cmr-field-name
/cmr-field
 /ejb-relationship-role

  /ejb-relation
   


and this is for jbosscmp-jdbc

  
ejb-relation
  ejb-relation-nameEDocuments-EDocMetaData/ejb-relation-name

  foreign-key-mapping/

  ejb-relationship-role
  
ejb-relationship-role-nameEDocuments-has-one-EDocMetadata/ejb-relationship-role-name
  key-fields
 key-field
   field-namedocid/field-name
   column-namedocid/column-name
 /key-field
  /key-fields

  /ejb-relationship-role
  ejb-relationship-role
  
ejb-relationship-role-nameEDocMetadata-has-one-EDocuments/ejb-relationship-role-name
  key-fields
 key-field
   field-namedocid/field-name
   column-namedocid/column-name
 /key-field
  /key-fields

  /ejb-relationship-role
/ejb-relation
  


Well,
Finally I'm using Lomboz for generate all deploy files and 
all the file were generated well and the deploy files were good too.
But when I want to use the client tester like this :

public class DocumentsTest  {

private com.Entrieva.Skyline.SessionBeans.SDocumentsHome getHome()
   throws NamingException {
   return (com.Entrieva.Skyline.SessionBeans.SDocumentsHome)
getContext().lookup(
com.Entrieva.Skyline.SessionBeans.SDocumentsHome.JNDI_NAME);
   }
private InitialContext getContext() throws NamingException {
Hashtable props = new Hashtable();
props.put(InitialContext.INITIAL_CONTEXT_FACTORY,
org.jnp.interfaces.NamingContextFactory);
props.put(InitialContext.PROVIDER_URL, jnp://127.0.0.1:1099);
InitialContext initialContext = new InitialContext(props);
return initialContext;
}
public void testBean() throws CreateException, RemoteException, FinderException {

try {
SDocuments myBean = getHome().create();
Collection col = myBean.getAllDocumentByCategoryId(11);
// get all documents by category
Iterator iter = col.iterator();
while (iter.hasNext()) {
EDocuments element = ((EDocuments) iter.next());
System.out.println(Abstract: + element.getShortabstract());
EDocMetaData meta = element.getEDocMetaData();}
} catch (NamingException e) {
e.printStackTrace();
}
}

public static void main(String[] args) throws RemoteException, CreateException, 
FinderException {
DocumentsTest test = new DocumentsTest();
test.testBean();
}

this 

[JBoss-user] [Persistence CMP/JBoss] - Re: simplest one-to-one relationships bug

2004-05-18 Thread nacho2004
ava.rmi.ServerException: RemoteException occurred in server thread; nested exception 
is: 
java.rmi.ServerException: RuntimeException; nested exception is: 
java.lang.ClassCastException
at sun.rmi.server.UnicastServerRef.dispatch(UnicastServerRef.java:292)
at sun.rmi.transport.Transport$1.run(Transport.java:148)
at java.security.AccessController.doPrivileged(Native Method)
at sun.rmi.transport.Transport.serviceCall(Transport.java:144)
at sun.rmi.transport.tcp.TCPTransport.handleMessages(TCPTransport.java:460)
at 
sun.rmi.transport.tcp.TCPTransport$ConnectionHandler.run(TCPTransport.java:701)
at java.lang.Thread.run(Thread.java:536)
at 
sun.rmi.transport.StreamRemoteCall.exceptionReceivedFromServer(StreamRemoteCall.java:247)
at sun.rmi.transport.StreamRemoteCall.executeCall(StreamRemoteCall.java:223)
at sun.rmi.server.UnicastRef.invoke(UnicastRef.java:133)
at org.jboss.invocation.jrmp.server.JRMPInvoker_Stub.invoke(Unknown Source)
at 
org.jboss.invocation.jrmp.interfaces.JRMPInvokerProxy.invoke(JRMPInvokerProxy.java:135)
at org.jboss.invocation.InvokerInterceptor.invoke(InvokerInterceptor.java:96)
at 
org.jboss.proxy.TransactionInterceptor.invoke(TransactionInterceptor.java:46)
at org.jboss.proxy.SecurityInterceptor.invoke(SecurityInterceptor.java:45)
at org.jboss.proxy.ejb.EntityInterceptor.invoke(EntityInterceptor.java:97)
at org.jboss.proxy.ClientContainer.invoke(ClientContainer.java:85)
at $Proxy2.getEDocMetaData(Unknown Source)
at com.neoris.Test.DocumentsTest.testBean(DocumentsTest.java:67)
at com.neoris.Test.DocumentsTest.main(DocumentsTest.java:77)
Caused by: java.rmi.ServerException: RuntimeException; nested exception is: 
java.lang.ClassCastException
at 
org.jboss.ejb.plugins.LogInterceptor.handleException(LogInterceptor.java:361)
at org.jboss.ejb.plugins.LogInterceptor.invoke(LogInterceptor.java:195)
at 
org.jboss.ejb.plugins.ProxyFactoryFinderInterceptor.invoke(ProxyFactoryFinderInterceptor.java:122)
at org.jboss.ejb.EntityContainer.internalInvoke(EntityContainer.java:489)
at org.jboss.ejb.Container.invoke(Container.java:700)
at sun.reflect.GeneratedMethodAccessor184.invoke(Unknown Source)
at 
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:324)
at 
org.jboss.mx.capability.ReflectedMBeanDispatcher.invoke(ReflectedMBeanDispatcher.java:284)
at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:546)
at org.jboss.invocation.jrmp.server.JRMPInvoker.invoke(JRMPInvoker.java:367)
at sun.reflect.GeneratedMethodAccessor136.invoke(Unknown Source)
at 
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:324)
at sun.rmi.server.UnicastServerRef.dispatch(UnicastServerRef.java:261)
at sun.rmi.transport.Transport$1.run(Transport.java:148)
at java.security.AccessController.doPrivileged(Native Method)
at sun.rmi.transport.Transport.serviceCall(Transport.java:144)
at sun.rmi.transport.tcp.TCPTransport.handleMessages(TCPTransport.java:460)
at 
sun.rmi.transport.tcp.TCPTransport$ConnectionHandler.run(TCPTransport.java:701)
at java.lang.Thread.run(Thread.java:536)
Caused by: java.lang.ClassCastException
at com.Entrieva.Skyline.EntityBeans.EDocumentsCMP$Proxy.getEDocMetaData()
at sun.reflect.GeneratedMethodAccessor209.invoke(Unknown Source)
at 
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:324)
at 
org.jboss.ejb.EntityContainer$ContainerInterceptor.invoke(EntityContainer.java:1096)
at 
org.jboss.ejb.plugins.cmp.jdbc.JDBCRelationInterceptor.invoke(JDBCRelationInterceptor.java:72)
at 
org.jboss.ejb.plugins.EntitySynchronizationInterceptor.invoke(EntitySynchronizationInterceptor.java:282)
at 
org.jboss.resource.connectionmanager.CachedConnectionInterceptor.invoke(CachedConnectionInterceptor.java:185)
at 
org.jboss.ejb.plugins.EntityReentranceInterceptor.invoke(EntityReentranceInterceptor.java:114)
at 
org.jboss.ejb.plugins.EntityInstanceInterceptor.invoke(EntityInstanceInterceptor.java:163)
at 
org.jboss.ejb.plugins.EntityLockInterceptor.invoke(EntityLockInterceptor.java:89)
at 
org.jboss.ejb.plugins.EntityCreationInterceptor.invoke(EntityCreationInterceptor.java:54)
at 
org.jboss.ejb.plugins.AbstractTxInterceptor.invokeNext(AbstractTxInterceptor.java:84)
at 
org.jboss.ejb.plugins.TxInterceptorCMT.runWithTransactions(TxInterceptorCMT.java:267)
at 

[JBoss-user] [Persistence CMP/JBoss] - Re: simplest one-to-one relationships bug

2004-05-18 Thread nacho2004
My Problem was because I didn't use a Local Interface.
Ok , I just use 
EDocMetaDataLocal meta = element.getEDocMetaData();
but when I want to use any filed for example:
System.out.println(meta.getAuthor());
this error appear:

java.lang.NullPointerException
at org.jboss.ejb.plugins.local.EntityProxy.invoke(EntityProxy.java:38)
at $Proxy4.getAuthor(Unknown Source)
at com.neoris.Test.DocumentsTest.testBean(DocumentsTest.java:60)
at com.neoris.Test.DocumentsTest.main(DocumentsTest.java:70)
Exception in thread main 

View the original post : 
http://www.jboss.org/index.html?module=bbop=viewtopicp=3835364#3835364

Reply to the post : 
http://www.jboss.org/index.html?module=bbop=postingmode=replyp=3835364


---
This SF.Net email is sponsored by: SourceForge.net Broadband
Sign-up now for SourceForge Broadband and get the fastest
6.0/768 connection for only $19.95/mo for the first 3 months!
http://ads.osdn.com/?ad_id=2562alloc_id=6184op=click
___
JBoss-user mailing list
[EMAIL PROTECTED]
https://lists.sourceforge.net/lists/listinfo/jboss-user


[JBoss-user] [Persistence CMP/JBoss] - Re: simplest one-to-one relationships bug

2004-05-18 Thread nacho2004
somebody knows some tutorial to create one-to-one relationships ?
thanks in advance

View the original post : 
http://www.jboss.org/index.html?module=bbop=viewtopicp=3835418#3835418

Reply to the post : 
http://www.jboss.org/index.html?module=bbop=postingmode=replyp=3835418


---
This SF.Net email is sponsored by: SourceForge.net Broadband
Sign-up now for SourceForge Broadband and get the fastest
6.0/768 connection for only $19.95/mo for the first 3 months!
http://ads.osdn.com/?ad_id=2562alloc_id=6184op=click
___
JBoss-user mailing list
[EMAIL PROTECTED]
https://lists.sourceforge.net/lists/listinfo/jboss-user


[JBoss-user] [Persistence CMP/JBoss] - java.lang.ClassCastException

2004-05-17 Thread nacho2004
Hi,
I've 2 beans one-one relationships
and this piece of code

InitialContext ctx = new InitialContext();
SDocuments myBean = getHome().create();
Collection col = myBean.getAllDocumentByCategoryId(11);
Iterator iter = col.iterator();
while (iter.hasNext()) {
EDocuments element = ((EDocuments) iter.next());
System.out.println(Abstract: + element.getShortabstract());
EDocMetaData metaData = element.getDocMetaData();   
System.out.println(Rawtext: + metaData.getRawtext());
}
   } catch (NamingException e) {
e.printStackTrace();
}

in the bold line this error appear:
java.lang.ClassCastException at 
com.Entrieva.Skyline.EntityBeans.EDocumentsCMP$Proxy.getDocMetaData()


the ejb-jar relationships is :
   !-- Relationships --
   
  ejb-relation 
 ejb-relation-nameEDocuments-EDocMetaData/ejb-relation-name

 ejb-relationship-role 

ejb-relationship-role-nameEDocuments-has-one-EDocMetadata/ejb-relationship-role-name
One
relationship-role-source 
   ejb-nameEDocuments/ejb-name
/relationship-role-source
cmr-field 
   cmr-field-namedocMetaData/cmr-field-name
/cmr-field
 /ejb-relationship-role

 ejb-relationship-role 

ejb-relationship-role-nameEDocMetadata-has-one-EDocuments/ejb-relationship-role-name
One
relationship-role-source 
   ejb-nameEDocMetaData/ejb-name
/relationship-role-source
cmr-field 
   cmr-field-namedocuments/cmr-field-name
/cmr-field
 /ejb-relationship-role

  /ejb-relation
   


View the original post : 
http://www.jboss.org/index.html?module=bbop=viewtopicp=3835237#3835237

Reply to the post : 
http://www.jboss.org/index.html?module=bbop=postingmode=replyp=3835237


---
This SF.Net email is sponsored by: SourceForge.net Broadband
Sign-up now for SourceForge Broadband and get the fastest
6.0/768 connection for only $19.95/mo for the first 3 months!
http://ads.osdn.com/?ad_id=2562alloc_id=6184op=click
___
JBoss-user mailing list
[EMAIL PROTECTED]
https://lists.sourceforge.net/lists/listinfo/jboss-user


[JBoss-user] [Persistence CMP/JBoss] - Re: java.lang.ClassCastException

2004-05-17 Thread nacho2004
 
   ejb-relation
 ejb-relation-nameEDocuments-EDocMetaData/ejb-relation-name
  foreign-key-mapping/
  ejb-relationship-role
  
ejb-relationship-role-nameEDocuments-has-one-EDocMetadata/ejb-relationship-role-name
  key-fields/
  /ejb-relationship-role
  ejb-relationship-role
  
ejb-relationship-role-nameEDocMetadata-has-one-EDocuments/ejb-relationship-role-name
 key-fields
key-field
  field-namedocid/field-name
   column-namedocid/column-name
 /key-field
  /key-fields

  /ejb-relationship-role
/ejb-relation
  


View the original post : 
http://www.jboss.org/index.html?module=bbop=viewtopicp=3835248#3835248

Reply to the post : 
http://www.jboss.org/index.html?module=bbop=postingmode=replyp=3835248


---
This SF.Net email is sponsored by: SourceForge.net Broadband
Sign-up now for SourceForge Broadband and get the fastest
6.0/768 connection for only $19.95/mo for the first 3 months!
http://ads.osdn.com/?ad_id=2562alloc_id=6184op=click
___
JBoss-user mailing list
[EMAIL PROTECTED]
https://lists.sourceforge.net/lists/listinfo/jboss-user


[JBoss-user] [Persistence CMP/JBoss] - Re: java.lang.ClassCastException

2004-05-17 Thread nacho2004
do you have any document to implement a one-to-one relationships
I think the @ejb.relation is good in both case (2 beans) but I can't understand why I 
can't call one bean to other by getDocidMetaData() method.
thanks in advance 


View the original post : 
http://www.jboss.org/index.html?module=bbop=viewtopicp=3835254#3835254

Reply to the post : 
http://www.jboss.org/index.html?module=bbop=postingmode=replyp=3835254


---
This SF.Net email is sponsored by: SourceForge.net Broadband
Sign-up now for SourceForge Broadband and get the fastest
6.0/768 connection for only $19.95/mo for the first 3 months!
http://ads.osdn.com/?ad_id=2562alloc_id=6184op=click
___
JBoss-user mailing list
[EMAIL PROTECTED]
https://lists.sourceforge.net/lists/listinfo/jboss-user


[JBoss-user] [Persistence CMP/JBoss] - Re: java.lang.ClassCastException

2004-05-17 Thread nacho2004
But in my case both tables contain the same amount of row
And the data model for those tables is one-to-one relationships 

View the original post : 
http://www.jboss.org/index.html?module=bbop=viewtopicp=3835258#3835258

Reply to the post : 
http://www.jboss.org/index.html?module=bbop=postingmode=replyp=3835258


---
This SF.Net email is sponsored by: SourceForge.net Broadband
Sign-up now for SourceForge Broadband and get the fastest
6.0/768 connection for only $19.95/mo for the first 3 months!
http://ads.osdn.com/?ad_id=2562alloc_id=6184op=click
___
JBoss-user mailing list
[EMAIL PROTECTED]
https://lists.sourceforge.net/lists/listinfo/jboss-user


[JBoss-user] [Persistence CMP/JBoss] - Error compiling EJB-QL statement 'SELECT OBJECT(b) FROM ...

2004-05-15 Thread nacho2004
I've 2 beans
ECatDocuments and EDocuments
I created a relationships like this

in ECatDocuments
/**
 * @ejb.interface-method
 * 
 * @ejb.relation
 *name=ECatDocuments-EDocuments  
 *role-name=ECatDocuments-has-many-EDocuments
 * @jboss.relation
 *related-pk-field=docid
 *fk-column=docid

in EDocuments
/**
 * @ejb.interface-method
 * 
 * @ejb.relation
 *name=ECatDocuments-EDocuments  
 *role-name=EDocuments-has-ECatDocuments
 *target-ejb=ECatDocuments
 *
*/
and the relationships in ejb-jar.xml is :
   
  ejb-relation 
 ejb-relation-nameECatDocuments-EDocuments/ejb-relation-name

 ejb-relationship-role 

ejb-relationship-role-nameECatDocuments-has-many-EDocuments/ejb-relationship-role-name
Many
relationship-role-source 
   ejb-nameECatDocuments/ejb-name
/relationship-role-source
cmr-field 
   cmr-field-namedocuments/cmr-field-name
/cmr-field
 /ejb-relationship-role

 ejb-relationship-role 

ejb-relationship-role-nameEDocuments-has-ECatDocuments/ejb-relationship-role-name
One
relationship-role-source 
   ejb-nameEDocuments/ejb-name
/relationship-role-source
cmr-field 
   cmr-field-namedocuments/cmr-field-name
   cmr-field-typejava.util.Collection/cmr-field-type
/cmr-field
 /ejb-relationship-role

  /ejb-relation
   

everything all right but..
when I want to create a query in ECatDocuments like this :

 * @ejb.finder 
 *query=SELECT OBJECT(b) FROM catDocumentsSchema a, IN(a.documents) b where 
a.catid=?1  
 *signature=java.util.Collection findDocsByCatid(int catId)   

this deploy error appear:
 Depends On Me: org.jboss.deployment.DeploymentException: Error compiling EJB-QL 
statement 'SELECT OBJECT(b) FROM catDocumentsSchema a, IN(a.documents) b where 
a.docid=?1'; - nested throwable: (org.jboss.ejb.plugins.cmp.ejbql.ParseException: 
Encountered a.documents at line 1, column 50.
Was expecting:
COLLECTION_VALUED_PATH ...
)]


somebody can help me??!!!
Thanks in advance



View the original post : 
http://www.jboss.org/index.html?module=bbop=viewtopicp=3835080#3835080

Reply to the post : 
http://www.jboss.org/index.html?module=bbop=postingmode=replyp=3835080


---
This SF.Net email is sponsored by: SourceForge.net Broadband
Sign-up now for SourceForge Broadband and get the fastest
6.0/768 connection for only $19.95/mo for the first 3 months!
http://ads.osdn.com/?ad_id=2562alloc_id=6184op=click
___
JBoss-user mailing list
[EMAIL PROTECTED]
https://lists.sourceforge.net/lists/listinfo/jboss-user


[JBoss-user] [Persistence CMP/JBoss] - relationship doubt

2004-05-14 Thread nacho2004
Hi everybody!
I've 2 tables : 
CatDocuments and Documents
CatDocuments has docid and catid fields
Documents has docid and docname fields
The relation between both are with the docid field
I want to get all the docs from documents where catid =x
for example
[select docname from catdocuments a inner join documents b on a.docid=b.docid where 
catid = xxx]
well,
I' been created a code like this in Documents bean 
/**
 * @ejb.interface-method
 * view-type=both
 *
 * @ejb.persistence
 * column-name = docid
 *
 * @ejb.relation
 *name=EDocuments-ECatDocuments  
 *target-ejb=ECatDocuments
 *target-multiple=no
 *role-name=EDocuments-has-ECatDocuments
 * 
 * @jboss.relation
 *related-pk-field=docid
 *fk-column=docid
 * 
*/
public abstract Collection getCatDocuments();
/**
 * @ejb.interface-method
 * view-type=both
 */
public abstract void setCatDocuments(int docid);



and in the CatDocuments bean I put the next code

/**
 * @ejb.interface-method
 * view-type=both
 *
 * @ejb.persistence
 * column-name = docid
 *
 * @ejb.relation
 *name=EDocuments-ECatDocuments  
 *target-ejb=EDocuments
 *target-multiple=yes
 *role-name=ECatDocuments-has-EDocuments
 * 
 * @jboss.relation
 *related-pk-field=docid
 *fk-column=docid
 * 
 */
public abstract Collection getDocuments();
/**
 * @ejb.interface-method
 * view-type=both
 */
public abstract void setDocuments(int docid);   


so, the question is 
1) if the code above is right and
2) why I want to deploy the code that error appear 

org.jboss.deployment.DeploymentException: No ejb-relationship-role-name element found



View the original post : 
http://www.jboss.org/index.html?module=bbop=viewtopicp=3835016#3835016

Reply to the post : 
http://www.jboss.org/index.html?module=bbop=postingmode=replyp=3835016


---
This SF.Net email is sponsored by: SourceForge.net Broadband
Sign-up now for SourceForge Broadband and get the fastest
6.0/768 connection for only $19.95/mo for the first 3 months!
http://ads.osdn.com/?ad_id=2562alloc_id=6184op=click
___
JBoss-user mailing list
[EMAIL PROTECTED]
https://lists.sourceforge.net/lists/listinfo/jboss-user


[JBoss-user] [Persistence CMP/JBoss] - How to create relationships with XDoclet

2004-05-14 Thread nacho2004
Anybody knows a tutorial , document anything that talk about how to create 
relationships with XDoclet.
thanks in advance.

View the original post : 
http://www.jboss.org/index.html?module=bbop=viewtopicp=3834975#3834975

Reply to the post : 
http://www.jboss.org/index.html?module=bbop=postingmode=replyp=3834975


---
This SF.Net email is sponsored by: SourceForge.net Broadband
Sign-up now for SourceForge Broadband and get the fastest
6.0/768 connection for only $19.95/mo for the first 3 months!
http://ads.osdn.com/?ad_id=2562alloc_id=6184op=click
___
JBoss-user mailing list
[EMAIL PROTECTED]
https://lists.sourceforge.net/lists/listinfo/jboss-user


[JBoss-user] [Persistence CMP/JBoss] - EJB-QL query

2004-05-13 Thread nacho2004
somebody knows how I can do this query with EJB-QL

Select A.catid FROM catparents A
where
(A.parentid IN (SELECT B.parentid from dbo.catparents B WHERE
   (B.catid = 4) AND (B.depth = 0))
AND (A.depth = 0) AND (A.catid  4))

thanks in advance

View the original post : 
http://www.jboss.org/index.html?module=bbop=viewtopicp=3834805#3834805

Reply to the post : 
http://www.jboss.org/index.html?module=bbop=postingmode=replyp=3834805


---
This SF.Net email is sponsored by: SourceForge.net Broadband
Sign-up now for SourceForge Broadband and get the fastest
6.0/768 connection for only $19.95/mo for the first 3 months!
http://ads.osdn.com/?ad_id=2562alloc_id=6184op=click
___
JBoss-user mailing list
[EMAIL PROTECTED]
https://lists.sourceforge.net/lists/listinfo/jboss-user


[JBoss-user] [Persistence CMP/JBoss] - Problem with Integer fields on @ejb.finder result

2004-05-11 Thread nacho2004
I've been doing a CMP with 3 integer fields.
So, when I create an use this finder:
 * @ejb.finder 
 *  query=SELECT OBJECT(c) FROM catparents c where c.parentId=?1  
 *  signature=java.util.Collection findByChild(java.lang.Integer catId) 

the result give me the collection of the same row.
I mean the count result in the query of MSSQL is 13 but the result of collection 
objects is 13 but with the same data.
somebody knows this problem ?
thank a lot!!

View the original post : 
http://www.jboss.org/index.html?module=bbop=viewtopicp=3834524#3834524

Reply to the post : 
http://www.jboss.org/index.html?module=bbop=postingmode=replyp=3834524


---
This SF.Net email is sponsored by Sleepycat Software
Learn developer strategies Cisco, Motorola, Ericsson  Lucent use to 
deliver higher performing products faster, at low TCO.
http://www.sleepycat.com/telcomwpreg.php?From=osdnemail3
___
JBoss-user mailing list
[EMAIL PROTECTED]
https://lists.sourceforge.net/lists/listinfo/jboss-user