Re: [JBoss-user] JBoss 3.2.3

2003-12-01 Thread Alexey Loubyansky
This is fixed in Branch_3_2 and HEAD. The bug was that, the fields with read-time-out=-1 would never be loaded. Thanks for the details. Rafal Kedziorski wrote: At 17:31 01.12.2003, Alexey Loubyansky wrote: Unfortunately, I still can't reproduce it. Could you please provide me with the DDs

Re: [JBoss-user] Weblogic to JBoss 3.2.2 Migration - Issues (Looking for some help )

2003-11-30 Thread Alexey Loubyansky
EJB deployment descriptors can be translated to JBoss-specific ones with FoeDeployer in CVS in Branch_3_2 and HEAD in module varia. It is based on XSLT. Sasidharan, Manoj wrote: Hello All, Is there any guide or article that discusses the tasks and pitfalls when migrating a J2EE application

Re: [JBoss-user] Weblogic to JBoss Migration: EJB home methods are not allowed to access CMP or CMR fields (Please help - JBoss 3.2.3RC1)

2003-11-30 Thread Alexey Loubyansky
What methods are in the home, local home, local and remote interfaces? Sasidharan, Manoj wrote: Hello All, Server: JBoss 3.2.3.RC1 JDK:1.4.0_01 OS: Windows NT 4 SP6 Here is the stack trace of the exception from the JBoss server console. The deployment goes fine. Server does not complain

Re: [JBoss-user] servlet access local interface of EJB - deployment descriptor errors!

2003-11-28 Thread Alexey Loubyansky
Maybe it's because in web.xml you use ejb-local-ref and in jboss-web.xml ejb-ref (not ejb-local-ref)? Pedro Salazar wrote: Greetings, I deployed my EJB the name ServiceInfo and the JNDI names ejb/ServiceInfo and ejb/ServiceInfoLocal, for the remote and local interfaces respectively. In my

Re: [JBoss-user] Switch off caching ...

2003-11-26 Thread Alexey Loubyansky
Is the table updated from another application? There are no UPDATEs in the log. I wanted you to try with read-only = false for the methods that have read-only = true. Rafal Kedziorski wrote: At 15:39 25.11.2003, Alexey Loubyansky wrote: Could you try with read-onlyfalse/read-only? We don't

Re: [JBoss-user] Switch off caching ...

2003-11-26 Thread Alexey Loubyansky
Rafal Kedziorski wrote: At 11:54 26.11.2003, Alexey Loubyansky wrote: Is the table updated from another application? There are no UPDATEs in the log. The table was updated from JBoss thru direct SQL. I wanted you to try with read-only = false for the methods that have read-only = true

Re: [JBoss-user] Switch off caching ...

2003-11-26 Thread Alexey Loubyansky
I would think this is absolutely fine if the bean is read-only=false and just the method is read-only=true. If caching is the requirement then commit option A should be used. What do you think, Adrian? Adrian Brock wrote: The obvious fix would be to add what is done for no transaction in the

Re: [JBoss-user] Switch off caching ...

2003-11-25 Thread Alexey Loubyansky
Why do you think so? Rafal Kedziorski wrote: hi, it's possible to switch off caching in Entity Beans? We user Commit Option C, but JBoss is caching the entities. Regards, Rafal --- This SF.net email is sponsored by: SF.net Giveback

Re: [JBoss-user] Switch off caching ...

2003-11-25 Thread Alexey Loubyansky
Are 1. and 3. peformed in the same transaction? If so, this is the expected behaviour. Rafal Kedziorski wrote: At 12:24 25.11.2003, Alexey Loubyansky wrote: Why do you think so? Cause we can see it. We have a folder table. We don't want that JBoss is caching entities from this table, cause

Re: [JBoss-user] Switch off caching ...

2003-11-25 Thread Alexey Loubyansky
Can you see that container loads data from the database while performing 3.? Other than primary key. Rafal Kedziorski wrote: At 13:50 25.11.2003, Alexey Loubyansky wrote: Are 1. and 3. peformed in the same transaction? If so, this is the expected behaviour. no. 1. is one transaction, 2

Re: [JBoss-user] Switch off caching ...

2003-11-25 Thread Alexey Loubyansky
With commit option C instances are not cached between transactions. Rafal Kedziorski wrote: At 14:28 25.11.2003, Alexey Loubyansky wrote: Can you see that container loads data from the database while performing 3.? Other than primary key. We have to check this. It's possible to switch off

Re: [JBoss-user] Switch off caching ...

2003-11-25 Thread Alexey Loubyansky
Could you try with read-onlyfalse/read-only? Rafal Kedziorski wrote: hi, At 14:28 25.11.2003, Alexey Loubyansky wrote: Can you see that container loads data from the database while performing 3.? Other than primary key. We've checked this. We call in the first transaction out business

Re: [JBoss-user] Switch off caching ...

2003-11-25 Thread Alexey Loubyansky
Yes. Rafal Kedziorski wrote: At 15:39 25.11.2003, Alexey Loubyansky wrote: Could you try with read-onlyfalse/read-only? By default is this false. --- This SF.net email is sponsored by: SF.net Giveback Program. Does SourceForge.net help you

Re: [JBoss-user] Optimistic locking and Commit Option A

2003-11-25 Thread Alexey Loubyansky
The read-only is applied to the specific bean/method as defined in the DDs. No inheritance rules. Pete Beck wrote: On Tue, 2003-11-25 at 11:26, Kevin Conner wrote: We stuck with the pessimistic locking and enabled read-only methods. The CMP engine grabs the lock for the duration of the

Re: [JBoss-user] No GROUP BY in JBoss-QL?

2003-11-25 Thread Alexey Loubyansky
Stefan Arentz wrote: I noticed that there is no GROUP BY in JBoss-QL. Is that for a reason? It would be good to have it. Looking at the source of the EJB-QL compiler, is this something that can be added by using the ORDER BY code? The two are probably roughly the same? Be sure.

Re: [JBoss-user] How fine grained are cmp commit options?

2003-11-24 Thread Alexey Loubyansky
Alwyn Schoeman wrote: Hi, At what level can you specify different cmp commit options? Container level. This is specified in jboss.xml like this: entity ejb-nameChild/ejb-name local-jndi-nameChildLocal/local-jndi-name configuration-namecustom

Re: [JBoss-user] Optimistic locking and Commit Option A

2003-11-24 Thread Alexey Loubyansky
Pete Beck wrote: Hi all, I have just been reading through the docs about using optimistic locking. According to the docs, to use optimistic locking, you must also use the instance per transaction policy. However, the docs also state that you cannot use commit option A with instance per

Re: [JBoss-user] EJB home methods are not allowed to access CMP or CMR

2003-11-24 Thread Alexey Loubyansky
Pedro Salazar wrote: On Fri, 2003-11-21 at 21:13, Alexey Loubyansky wrote: You are doing it wrong. In ejbPassivate the flag should be set to false. Please, read about activation/passivation in the spec. There is also a nice picture on this subject. Alexey, I've read the EJB spec but I only

Re: [JBoss-user] CMP2 and loadbalancing

2003-11-21 Thread Alexey Loubyansky
Alwyn Schoeman wrote: On Thu, Nov 20, 2003 at 05:33:48PM +0200, Alexey Loubyansky wrote: From what I can learn on the web it seems that a read-mostly pattern is where you have 2 copies of a bean, one read-only and the other read-write. It seems that you need to write at a specific interval

Re: [JBoss-user] EJB home methods are not allowed to access CMP or CMR

2003-11-21 Thread Alexey Loubyansky
Is bean read-only in jbosscmp-jdbc.xml? It should be. The second thing to keep in mind is that the cache also has some limitations and, probably, can't keep the whole database in memory. Pedro Salazar wrote: On Thu, 2003-11-20 at 20:02, Alexey Loubyansky wrote: Can't you calculate the value

Re: [JBoss-user] EJB home methods are not allowed to access CMP or CMR

2003-11-21 Thread Alexey Loubyansky
Pedro Salazar wrote: Yes, the bean is read-only, however I set a read timeout of 300ms. It's too low but I don't know if this works in read-only beans, does it? Yes, sure. The default value is -1, which means never timeout. And if true, when the time starts for the timeout? When the container

Re: [JBoss-user] EJB home methods are not allowed to access CMP or CMR

2003-11-21 Thread Alexey Loubyansky
You are doing it wrong. In ejbPassivate the flag should be set to false. Please, read about activation/passivation in the spec. There is also a nice picture on this subject. Pedro Salazar wrote: One more thing, when the bean is passivated only the non-transient variables are saved (probably to

Re: [JBoss-user] CMP2 and loadbalancing

2003-11-20 Thread Alexey Loubyansky
Alwyn Schoeman wrote: I'm not that familiar with CMP and JBoss yet. Would that mean commit option B for the row-locking? Yes. From what I can learn on the web it seems that a read-mostly pattern is where you have 2 copies of a bean, one read-only and the other read-write. It seems that you need

Re: [JBoss-user] EJB home methods are not allowed to access CMP or CMR

2003-11-20 Thread Alexey Loubyansky
Unfortunately, it is a spec violation. 10.5.2 Bean Providers entity bean instances view public void ejbActivate(); The container invokes this method on the instance when the container picks the instance from the pool and assigns it to a specific entity object identity. The ejbActivate() method

Re: [JBoss-user] EJB home methods are not allowed to access CMP or CMR

2003-11-20 Thread Alexey Loubyansky
Can't you calculate the value once and add a flag 'calculated' that will indicate it? Pedro Salazar wrote: Greetings, I would like to get access to some information available on my entity bean during the activate() method to prepare it and avoid doing it every call to in a interface method.

Re: [JBoss-user] CMP2 and loadbalancing

2003-11-19 Thread Alexey Loubyansky
Yes, it also would help. Thanks. Raghuram wrote: Hi, I might be wrong here, but would it not help him if he used optimistic concurrency for writes to ensure consistency of the data ? raghu -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Alexey Loubyansky

Re: [JBoss-user] TypeConvertionException with Firebird Database

2003-11-19 Thread Alexey Loubyansky
Milen Dyankov wrote: That is not a bad idea, but I wonder if it's going to work when my object is local interface of CMP Bean. Thanks Dan, I'll give it a try. Are you going to store a local interface as a BLOB? I guess, this is not supposed to work. You can obtain a Handle for EJBObject that can

Re: [JBoss-user] TypeConvertionException with Firebird Database

2003-11-19 Thread Alexey Loubyansky
It's legal. Milen Dyankov wrote: Alexey Loubyansky wrote: Milen Dyankov wrote: That is not a bad idea, but I wonder if it's going to work when my object is local interface of CMP Bean. Thanks Dan, I'll give it a try. Are you going to store a local interface as a BLOB? I guess

Re: [JBoss-user] Caching issue?

2003-11-19 Thread Alexey Loubyansky
in another tx. Phil Shrimpton wrote: On Tuesday 18 November 2003 15:57, Alexey Loubyansky wrote: Hi, Then the problem might occur when clients access *different* orders which share items. The call order.getItems() can be performed at the same time for both clients (w/o locking) as orders

Re: [JBoss-user] Weblogic to JBoss Migration - Differences in XA and Non-XA DataS ource handling (Stack Trace)

2003-11-18 Thread Alexey Loubyansky
Are you trying to set autocommit? You can not do it in a managed tx. Sasidharan, Manoj wrote: Hello Adrian, Thanks for taking some time for helping me on this issue. Here is the stack trace at the server when the problem occurs. 20:26:31,122 WARN [TxConnectionManager$LocalXAResource] Prepare

Re: [JBoss-user] Optimize storing lots of messages from MDB through CMP

2003-11-18 Thread Alexey Loubyansky
What is the actual problem? Why do you think that if only one connection is used it is not optimized? Markus Härnvi wrote: Hi! I have a MDB reading a constant stream of messages from a Queue. The MDB is storing the messages through two CMP entity bean with a CMR. The data written to the

Re: [JBoss-user] Weblogic JBoss Migration: Oracle XA and Non-XA DataSource Problem

2003-11-18 Thread Alexey Loubyansky
The first stack trace id informative. There is some unclosed connection that is supposed to be open by your application. This connection is closed by JBoss and the stacktrace is for your info. Do you deal with connections directly? The second exception looks like a bug. But I would let Adrian

Re: [JBoss-user] Hot Deploy of Session Beans Fails

2003-11-18 Thread Alexey Loubyansky
I think, redeploying everything that references the redeployed beans is only way. Rod Macpherson wrote: We use loose EJB jars during development rather than an EAR file so we can hot-deploy specific pieces. Unfortunately a session bean hot-deploy causes a class-cast exception the next time

Re: [JBoss-user] TypeConvertionException with Firebird Database

2003-11-18 Thread Alexey Loubyansky
If defaults do not work for you, you should try different types yourself. Please, let us know your findings. Thanks. Milen Dyankov wrote: Hi all, we have problem using JBoss (3.2.1) with Firebird DB (1.5.0rc7 / JayBird JDCB 1.0.1). Everything works just fine with MySQL at backend, but with

Re: [JBoss-user] Caching issue?

2003-11-18 Thread Alexey Loubyansky
Phil Shrimpton wrote: On Friday 14 November 2003 09:15, Adrian Brock wrote: Hi, JBoss 3.2.2, Commit Option A... I have a SLSB method something like... public void doSomething(){ Collection c = OrdersEJB.getItems(); loop through collection and do some calculations delete one of the

Re: [JBoss-user] CMP2 and loadbalancing

2003-11-18 Thread Alexey Loubyansky
In this case, to ensure the consistency of the data you have to lock the data in the database. It means using row-locking, i.e SELECT ... FOR UPDATE. To solve the scalability problem, you could consider a read-mostly pattern with 'Standard CMP 2.x EntityBean with cache invalidation' container.

Re: [JBoss-user] Caching issue?

2003-11-18 Thread Alexey Loubyansky
Phil Shrimpton wrote: Are the clients accessing different orders which have common items? And then one of the common items is removed? Yes, they could also be accessing the same 'order' and (with the same the same items) Then the problem might occur when clients access *different* orders

Re: [JBoss-user] Calling UUIDKeyGeneratorFactoryService from EJB

2003-11-18 Thread Alexey Loubyansky
This is from JDBCKeyGeneratorCreateCommand: try { KeyGeneratorFactory keyGeneratorFactory = (KeyGeneratorFactory) new InitialContext().lookup(factoryName); keyGenerator = keyGeneratorFactory.getKeyGenerator(); } catch (NamingException e) { throw new

Re: [JBoss-user] Commit option C BIG PROBLEM with 3.2.2 final release (to Adrian Brock)

2003-11-18 Thread Alexey Loubyansky
It is fixed in the CVS. Thanks. Boulatian, Misak wrote: Hi Adrian, Hi Adrian, Here is the trace you asked for. Search for string 'MISAK: default account=0001' that comes right after create(). This one sets default account on remote interface. The string 'MISAK: active account=0001' is

Re: [JBoss-user] Caching issue?

2003-11-18 Thread Alexey Loubyansky
row-locking would help. But it might not be the best option in your case. Phil Shrimpton wrote: On Tuesday 18 November 2003 14:58, Alexey Loubyansky wrote: Hi, Are the clients accessing different orders which have common items? And then one of the common items is removed? Yes, they could

Re: [JBoss-user] TypeConvertionException with Firebird Database

2003-11-18 Thread Alexey Loubyansky
Thanks for sharing the experience. In general, JBossCMP calls setObject() when it gave up to recognize the type (java.sql.Types). Milen Dyankov wrote: Alexey Loubyansky wrote: If defaults do not work for you, you should try different types yourself. Please, let us know your findings. Thanks

Re: [JBoss-user] Weblogic to JBoss Migration - Differences in XA and Non-XA DataS ource handling (Stack Trace)

2003-11-18 Thread Alexey Loubyansky
have two datasources - XA and Non-XA and Session bean uses both to complete its operation. Only the XA needs to be rolled-back. rgds MS -Original Message- From: Alexey Loubyansky [mailto:[EMAIL PROTECTED] Sent: Tuesday, November 18, 2003 4:50 AM To: [EMAIL PROTECTED] Subject: Re: [JBoss

Re: [JBoss-user] Default String Size

2003-11-17 Thread Alexey Loubyansky
It is cut off by the database, not JBossCMP. You should increase the size for the column. Brian McSweeney wrote: Hi all, My ejbs are cmp ones and the string parameters I use are as follows /** * @ejb.persistence * column-name=stringDescription *

Re: [JBoss-user] Default String Size

2003-11-17 Thread Alexey Loubyansky
:- ) wrote: Hi Alex, thanks for the reply. Could you tell me the best way to increase the size of a column in JBoss. I'm using the default cmp mappings to deploy and create my database, so if I want to increase the size of the file then I think I have the following options: 1) alter the

Re: [JBoss-user] Default String Size

2003-11-17 Thread Alexey Loubyansky
It depends on the database you are using. For example, you could use LONGVARCHAR, or TEXT, or, finally, CLOB. Check the docs for your database supported types. :- ) wrote: Thanks so much Alex, I actually am using standardjbosscmp-jdbc.xml, got a bit confused, sorry! Anyway, bad news is when

Re: [JBoss-user] Urgent!!! - transactions in MDB - Error: A CMR colle ction may only be used wi thin the transction in which it was created

2003-11-17 Thread Alexey Loubyansky
You have to check that: - the CMR field is accessed in an active transaction - the CMR collection is used in the transaction in which it was created. Balakrishnan, Vijay wrote: Hi, Could somebody please tell me what i need to do regarding this error. Thanks, Vijay

Re: [JBoss-user] getPrimaryKey() vs.getSymbol() where symbol is PrimaryKey

2003-11-14 Thread Alexey Loubyansky
The primary key value is cached in the proxy. When getPrimaryKey() is called the cached value is returned. Thus, avoiding the creation of the invocation object and passing to the container and all the interceptors. This means, no locking, no synchronization and other expensive operations.

Re: [JBoss-user] Spurious fields in the SQL Insert of a EJB 2.0 bean with One-to-One relations

2003-11-12 Thread Alexey Loubyansky
Percy Christian wrote: Thanks for your kind support. Here is the insert SQL INSERT INTO CONTACT (CONTACT_ID, NAME, ADDRESS, TEL1, TEL2, TEL3, GSM, FAX, EMAIL, URL, IBAN_CODE, BIC, COMMENTS, CREATION_DATE, LOCALITY_ID, Manufacturer_contact) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,

Re: [JBoss-user] Entity beans (CMP) are always calling ejbStore()

2003-11-12 Thread Alexey Loubyansky
It is called but the synchronization does not occur, right? Till the 3.2.2 it was not easy to avoid this. I'll look at it. Pedro Salazar wrote: Greetings, Why is that my entity beans are always calling the ejbStore() (I put there a print message to watch) when I'm not updating none of them? I

Re: [JBoss-user] (no subject)

2003-11-12 Thread Alexey Loubyansky
[EMAIL PROTECTED] wrote: Hi all, I have been following the thread started by Pedro Salazar. jboss.xml: jboss enterprise-beans entity ejb-nameCorrectionFile/ejb-name local-jndi-nameCorrectionFile/local-jndi-name read-onlyTrue/read-only

Re: [JBoss-user] Entity beans (CMP) are always calling ejbStore()

2003-11-12 Thread Alexey Loubyansky
It should be the same in 3.2.2 Pedro Salazar wrote: On Wed, 2003-11-12 at 12:23, Alexey Loubyansky wrote: It is called but the synchronization does not occur, right? Till the 3.2.2 it was not easy to avoid this. I'll look at it. Alexey, I tried on 3.2.1 but since you have referred that issue

Re: [JBoss-user] Entity beans (CMP) are always calling ejbStore()

2003-11-12 Thread Alexey Loubyansky
The store() is called each time when the synchronization should occur according to the spec. Pedro Salazar wrote: On Wed, 2003-11-12 at 14:07, Alexey Loubyansky wrote: It should be the same in 3.2.2 I may have understood it wrong but do you mean that entity beans CMP always call the store

Re: [JBoss-user] optimize question

2003-11-12 Thread Alexey Loubyansky
You are correct. Just read the comments from the spec Olve posted. Brian McSweeney wrote: I must say, I understood it to be the total opposite. I thought commit option A requires the least number of db lookups because it's all in the jboss cache. Please correct me if I am wrong. This means that

Re: [JBoss-user] [CMP] using db default values when inserting record with entity bean

2003-11-12 Thread Alexey Loubyansky
Marek Lange wrote: I have defined some default values in my database. They should be used when a table record is inserted and the corresponding field is missing in the ejb call. This was my understanding of doing this with ejbCreate(): If I want the default value to be used, the record is

Re: [JBoss-user] Entity beans (CMP) are always calling ejbStore()

2003-11-12 Thread Alexey Loubyansky
Pedro Salazar wrote: On Wed, 2003-11-12 at 16:30, Alexey Loubyansky wrote: The store() is called each time when the synchronization should occur according to the spec. The question is when and why the synchronization occurs? Why is that the JBOSS is requiring synchronization? Has

Re: [JBoss-user] [CMP] using db default values when inserting record with entity bean

2003-11-12 Thread Alexey Loubyansky
No, it doesn't. In fact, read-only fields are not included in neither INSERT nor UPDATE. But that does not help you, probably. Marek Lange wrote: Alexey Loubyansky schrieb: You have no other choice than initializing the fields in the ejbCreate. Not all databases allows you to skip values

Re: [JBoss-user] More CMR problems

2003-11-11 Thread Alexey Loubyansky
) at org.jboss.ejb.plugins.LogInterceptor.invokeHome(LogInterceptor.java:120) ... 21 more Can anyone explain why on earth I'm getting this error and how I can fix it??? */Alexey Loubyansky [EMAIL PROTECTED]/* wrote: Be honest ;) Did you modify the generated by Middlegen sources? Steven Nakhla wrote

Re: [JBoss-user] Read only CMR Collections?

2003-11-11 Thread Alexey Loubyansky
the spec has us all hogtied. I'll have to look into what value objects can provide me with regard to CMR collections, then. -Neal On November 10, 2003 03:03 pm, Alexey Loubyansky wrote: First, it is the spec requirement. Second, do you run Servlet container in the same VM as JBoss? If so, you could

Re: [JBoss-user] How to limit the the number of records (Objects) a select returns

2003-11-11 Thread Alexey Loubyansky
It is about declared-sql queries. This covered in for-pay docs. In jbosscmp-jdbc.xml in query element you can specify declared-sql like: query query-method method-nameejbSelectmethod-name/method-name method-params

Re: [JBoss-user] Read only CMR Collections?

2003-11-11 Thread Alexey Loubyansky
I know ;) julien viet wrote: yes it works well. What about using filters to begin/commit transactions? --- This SF.Net email sponsored by: ApacheCon 2003, 16-19 November in Las Vegas. Learn firsthand the latest developments in Apache,

Re: [JBoss-user] More CMR problems

2003-11-11 Thread Alexey Loubyansky
? I've been getting this same exception for weeks now! */Alexey Loubyansky [EMAIL PROTECTED]/* wrote: It worked for me when I used AddressLocal to establish relationships on the server side. Steven Nakhla wrote: Yep. Not that the non-modified sources worked any better. I've

Re: [JBoss-user] More CMR problems

2003-11-11 Thread Alexey Loubyansky
You should read the spec. At least relevant parts. You'll find many interesting stuff and save everyone's time. Steven Nakhla wrote: You know, in all the tutorials or books I've read, I've never seen that little tidbit of information. None of them said that only local interfaces can be used.

Re: [JBoss-user] Spurious fields in the SQL Insert of a EJB 2.0 bean with One-to-One relations

2003-11-11 Thread Alexey Loubyansky
What is the SQL query generated? Your configuration does not match the DTD. Which is !ELEMENT ejb-relationship-role (ejb-relationship-role-name, fk-constraint?, key-fields?, read-ahead?) Is it deployed w/o errors? [EMAIL PROTECTED] wrote: Dear sir I am using

Re: [JBoss-user] More CMR problems

2003-11-10 Thread Alexey Loubyansky
Be honest ;) Did you modify the generated by Middlegen sources? Steven Nakhla wrote: First, thanks to all who responded regarding my CMR problems with XDoclet/JBoss. As advised, I have used Middlegen to automatically create my entity beans from my database table. These beans represent a

Re: [JBoss-user] CMP field for key not found

2003-11-10 Thread Alexey Loubyansky
I would remove about 80% of XDoclet tags first. 1. you don't have to copy them for setters if you have them for getters. 2. remove @jboss.target-relation Pedro Salazar wrote: Greetings, I'm unable to define a relationship between 2 entity beans, service and primitive. If I comment in the

Re: [JBoss-user] Read only CMR Collections?

2003-11-10 Thread Alexey Loubyansky
First, it is the spec requirement. Second, do you run Servlet container in the same VM as JBoss? If so, you could begin/commit transaction in the web layer and no need for value objects. Neal Sanche wrote: Hi All, I've found recently that it's becoming increasingly painful to avoid the 'CMR

Re: [JBoss-user] Challenge for EJB-QL, JBossQL, or declared SQL?

2003-11-07 Thread Alexey Loubyansky
It is about GROUP BY. You can't do it with either EJB- nor JBoss-QL at the moment. Darren Hartford wrote: Hey all, I got an interesting problem that I should think some of you may have already come across in some fashion or another. I want to do a search to return a collection of objects,

Re: [JBoss-user] Commit Option Confusion

2003-11-07 Thread Alexey Loubyansky
Phil Shrimpton wrote: On Thursday 06 November 2003 22:51, Bill Burke wrote: Hi, As this app 'owns' its own database and the DB is not that quick, I though that changing from the default commit option B to A should give me some improvements, but seems to make no difference. Are you doing a lot

[JBoss-user] Re: [JBoss-dev] cmp with multiple datasource

2003-11-07 Thread Alexey Loubyansky
); } catch (Exception e) { System.out.println(...); } what is wrong in here? -Original Message- From: Alexey Loubyansky [mailto:[EMAIL PROTECTED] Sent: Martes, 04 de Noviembre de 2003 03:31 tarde To: [EMAIL PROTECTED] Subject: Re: [JBoss-dev

Re: [JBoss-user] relate 2 entities without a common key (WAS Re: [JBoss-user] relationship 1-* with foreign key)

2003-11-07 Thread Alexey Loubyansky
Unless it is many-to-many relationship you should use either @jboss.relation or @jboss.target-relation tags. Pedro Salazar wrote: Greetings, -I have 2 entities mapped from 2 database tables, ACCESS_PERMISSION and ACCESS_SCHEDULE. -the relation between them is, ACCESS_PERMISSION *has* several

Re: [JBoss-user] Unexpected JBossQL result in 3.2.2

2003-11-07 Thread Alexey Loubyansky
Stefan Arentz wrote: SELECT DISTINCT OBJECT(s) FROM Subscriptions AS s WHERE s.user = ?1 and s.lastSession is not null ORDER BY s.lastSession.createDate DESC LIMIT ?2 It returns the cartasian product of Subscription/User objects. Could you please post the SQL generated for this query?

Re: [JBoss-user] datasource checking

2003-11-05 Thread Alexey Loubyansky
Doesn't create-tabletrue/create-table remove-tabletrue/remove-table help you? Joachim (PROGS) wrote: In my applications, I know in advance that my data structure will change over time. To handle this, I would prefer that the database structure is checked and possibly updated

Re: [JBoss-user] relationship 1-* with foreign key

2003-11-04 Thread Alexey Loubyansky
Do you define relationships in jbosscmp-jdbc.xml? The table might not have a primary key but entity must have according to the spec. Do you have primkey-field defined in ejb-jar.xml? Pedro Salazar wrote: Greetings, I have a table Access_Permission that _has_ relation 1-* to Access_Schedule.

Re: [JBoss-user] relationship 1-* with foreign key

2003-11-04 Thread Alexey Loubyansky
Pedro Salazar wrote: When happens that the entity in the database has no primary key, we must generate a key for the entity bean which may not exist in database, right? But if that key has no persistence, how the container will handle it? And the cluster works fine with that (probably)? Are you

Re: [JBoss-user] cascade-delete in 3.2.2

2003-11-03 Thread Alexey Loubyansky
The same way as in 3.2.2: by increasing log level to DEBUG for category org.jboss.ejb.plugins.cmp. How could I reproduce it? Do you have a testcase? Thanks. Markus Härnvi wrote: Please, try with fresh Branch_3_2 in 24 hours. I fixed a bug that could be the cause of your problem. Thanks. I

Re: [JBoss-user] PostgreSQL and NOT NULL integer fields

2003-11-03 Thread Alexey Loubyansky
Could you please send/submit the patch to XDoclet project? Thank you! Ivens Porto wrote: Alexey Loubyansky wrote: You are trying to use uknown and 'known' primary keys at the same time. You must use either one. Just remove unknown-pk. Yes, you need to use jdbc-type/sql-type in key-field

Re: [JBoss-user] Returning single field as Collection with EJB QL

2003-10-31 Thread Alexey Loubyansky
Finder queries must return remote or local interfaces. You should use SELECT OBJECT(o) ejbSelect methods are allowed to return CMP field values. Please, check the spec for more info. Ulf Tidstrand wrote: Hi everyone, I have declared a simple EJB QL statement in xdoclet: *

Re: [JBoss-user] cascade-delete in 3.2.2

2003-10-31 Thread Alexey Loubyansky
Please, try with fresh Branch_3_2 in 24 hours. I fixed a bug that could be the cause of your problem. Thanks. Markus Härnvi wrote: Thanks Scott for the answer about SSL/Tomcat! Next one: :) I'm using cascade-delete between a few CMP beans. My test cases that works in 3.2.2RC4 now fails in

Re: [JBoss-user] Problems in ejbRemove()

2003-10-31 Thread Alexey Loubyansky
What is the JBoss version? Did this code ran fine in previous versions? Any more info? Thanks. Edgar Silva wrote: Hi Folks... I have a very strange trouble: I have one CMP EntityBean, and I execute the findByPrimaryKey, and then I call the remove() method And nothing occurs... The Record

Re: [JBoss-user] PostgreSQL and NOT NULL integer fields

2003-10-31 Thread Alexey Loubyansky
Yes, it should. It is not yet clear for me how the fk field accord to be non-null. All fk fields allow null values by default. Perhaps, it came from sql-type? Could you, please, post the declaration of the unknown pk from your DDs? Ivens Porto wrote: Alexey Loubyansky wrote: It works for me

Re: [JBoss-user] PostgreSQL and NOT NULL integer fields

2003-10-31 Thread Alexey Loubyansky
accord should be read occured ;) Alexey Loubyansky wrote: Yes, it should. It is not yet clear for me how the fk field accord to be non-null. All fk fields allow null values by default. Perhaps, it came from sql-type? Could you, please, post the declaration of the unknown pk from your DDs

Re: [JBoss-user] Problems in ejbRemove()

2003-10-31 Thread Alexey Loubyansky
Silva www.argostecnologia.com Alexey Loubyansky wrote: What is the JBoss version? Did this code ran fine in previous versions? Any more info? Thanks. Edgar Silva wrote: Hi Folks... I have a very strange trouble: I have one CMP EntityBean, and I execute the findByPrimaryKey, and then I call

Re: [JBoss-user] MORE: PostgreSQL and NOT NULL integer fields

2003-10-31 Thread Alexey Loubyansky
Probably, I could. Post your DDs, first, please. Ivens Porto wrote: Ivens Porto wrote: Alexey Loubyansky wrote: It works for me. public abstract Integer getIntegerField(); public abstract void setIntegerField(Integer value); public abstract int getIntField(); public abstract void

Re: [JBoss-user] PostgreSQL and NOT NULL integer fields

2003-10-31 Thread Alexey Loubyansky
You are trying to use uknown and 'known' primary keys at the same time. You must use either one. Just remove unknown-pk. Yes, you need to use jdbc-type/sql-type in key-field. Ivens Porto wrote: Alexey Loubyansky wrote: Yes, it should. It is not yet clear for me how the fk field accord

Re: [JBoss-user] cascade-delete in 3.2.2

2003-10-30 Thread Alexey Loubyansky
Yes, sorry. Of course, sync-on-commit-only must be false if you have foreign key contraints. Could you, please, submit a bug report with the detailed info? Thank you. Markus Härnvi wrote: Hi again! It's set to false in both environments. I tried setting it to true in 3.2.2 but that didn't help.

Re: [JBoss-user] Problem with SQL query for MySQL

2003-10-29 Thread Alexey Loubyansky
Branch_3_2 Rafal Kedziorski wrote: At 20:24 28.10.2003 +0200, Alexey Loubyansky wrote: It is fixed now. In main cvs branch? Regards, Rafal alex Rafal Kedziorski wrote: hi, I'm using MySQL 4.0.13 and 4.0.14 (4.0.16 I will test tomorrow) and JBoss 3.2.2. And I have problems with this query

Re: [JBoss-user] cascade-delete in 3.2.2

2003-10-29 Thread Alexey Loubyansky
Could you post a stacktrace, please? And some description of what was going to be cascade-deleted? Thanks. Markus Härnvi wrote: Thanks Scott for the answer about SSL/Tomcat! Next one: :) I'm using cascade-delete between a few CMP beans. My test cases that works in 3.2.2RC4 now fails in 3.2.2

Re: [JBoss-user] cascade-delete in 3.2.2

2003-10-29 Thread Alexey Loubyansky
Is sync-on-commit-only set to true in RC4? I guess, it is false in final and, hence, is the expected behaviour. Markus Härnvi wrote: Hi! Could you post a stacktrace, please? And some description of what was going to be cascade-deleted? Sure. SearchCriteria has zero or more children

Re: [JBoss-user] 3.2.2 : Incorrect SQL generation

2003-10-28 Thread Alexey Loubyansky
Phil Shrimpton wrote: On Friday 24 October 2003 10:50, Alexey Loubyansky wrote: as for me, 3.0.8 is wrong and 3.2.2 is correct. Interesting, especially as another app server (Borland's) generates the same SQL as 3.0.8 Since you use OR between the terms o.contact.surnameUpper = ?2

Re: [JBoss-user] 3.2.2 : Incorrect SQL generation

2003-10-28 Thread Alexey Loubyansky
Phil Shrimpton wrote: On Tuesday 28 October 2003 10:13, Alexey Loubyansky wrote: Let's describe the condition o.contact.surnameUpper = ?2 OR o.vehicle.registrationNumber = ?3 in English. My interpretation is select all o that have contact with surname ?2 OR have vehicle with registration

Re: [JBoss-user] Problem with SQL query for MySQL

2003-10-28 Thread Alexey Loubyansky
It is fixed now. alex Rafal Kedziorski wrote: hi, I'm using MySQL 4.0.13 and 4.0.14 (4.0.16 I will test tomorrow) and JBoss 3.2.2. And I have problems with this query (generated by JBoss): insert into user(class_id, retail_id, mandant_id, language_id, user_data_id, nickname, login_name,

Re: [JBoss-user] 3.2.2 : Incorrect SQL generation

2003-10-28 Thread Alexey Loubyansky
Phil Shrimpton wrote: On Tuesday 28 October 2003 15:16, Alexey Loubyansky wrote: Alex o.contact.surnameUpper = ?2 OR o.vehicle.registrationNumber = ?3 in English. My interpretation is select all o that have contact with surname ?2 OR have vehicle with registration number ?3 Note, o is allowed

Re: [JBoss-user] weblogic - jboss transition/translation project?

2003-10-27 Thread Alexey Loubyansky
http://jboss.org/services/bea-port.jsp WebLogic 6.1 Your feedback would be highly appreciated. alex David Ward wrote: Hi, all - Didn't there used to be a project that given weblogic-specific deployment descriptors, jboss could automagically translate it to it's own needs and use it

Re: [JBoss-user] PostgreSQL and NOT NULL integer fields

2003-10-25 Thread Alexey Loubyansky
It works for me. public abstract Integer getIntegerField(); public abstract void setIntegerField(Integer value); public abstract int getIntField(); public abstract void setIntField(int value); 12:30:34,262 DEBUG [Child] Executing SQL: CREATE TABLE CHILD(CHILD_ID BIGINT NOT NULL, name

Re: [JBoss-user] 3.2.2 : limit on columns in entity beans

2003-10-25 Thread Alexey Loubyansky
Joachim (PROGS) wrote: Is this a new limitation or was this introduced in 3.2.2? We have 64 column entity beans and AFAIK we have been inserting on them. Thx This limitation didn't exist in 3.2.1, it appeared in 3.2.2. In which RC was it introduced? RC4. It is fixed in current Branch_3_2. alex

Re: [JBoss-user] new behavior in 3.2.2 - TransactionRolledbackLocalException

2003-10-25 Thread Alexey Loubyansky
Yes, you can do it. But it would be interesting to know whether JBossCMP initialized the fields to 0 instead of NULL. alex Jason Essington wrote: On Thursday, October 23, 2003, at 05:08 AM, Alexey Loubyansky wrote: Are there CMP fields mapped to the foreign key column

Re: [JBoss-user] ClassCastException when using java.util.Set instead of java.util.Collection?

2003-10-24 Thread Alexey Loubyansky
Finders have to return Collection by the specification. alex Ivens Porto wrote: Hi, I'm using JBoss 3.2.2. I have an entity bean (CMP) with a home method that returns all instances of the bean, the method is called findAll. When using a return type of java.util.Collection in the findAll

Re: [JBoss-user] 3.2.2 : limit on columns in entity beans

2003-10-24 Thread Alexey Loubyansky
If you run out of available columns again and it will be the problem of JBossCMP (not database) then, please, submit a bug report. alex Jason Essington wrote: According to the commit notes, Alexey has raised the limit on columns to infinity in the latest cvs of the 3.2 branch. Although, I

Re: [JBoss-user] new behavior in 3.2.2 - TransactionRolledbackLocalException

2003-10-24 Thread Alexey Loubyansky
I'll look at it and let you know. alex Jason Essington wrote: I have some tables in a database that are used by some of my CMP/CMR entity beans. The foreign key columns in some of these tables don't have foreign key integrity checks enforced in the database, and rather than having null in

Re: [JBoss-user] LIMIT and OFFSET with DynamicQL on a PostgresQL Database

2003-10-24 Thread Alexey Loubyansky
At the moment, the SQL you see is executed and LIMIT/OFFSET is applied to the result of the query (ResultSet). LIMIT/OFFSET is not sent to the database. alex [EMAIL PROTECTED] wrote: Hi all, We're using DynamicQL in our JBoss-application for a complex query. That works fine. Now we want to

<    1   2   3   4   5   >