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 vehicl

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

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 (dynamicall

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? If not that is

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] 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 : Incorrect SQL generation

2003-10-24 Thread Alexey Loubyansky
Hello Phil, as for me, 3.0.8 is wrong and 3.2.2 is correct. Since you use OR between the terms > o.contact.surnameUpper = ?2 OR o.vehicle.registrationNumber = ?3 I think, the join should be done per the term, i.e. this way: (contact.SURNAME_UPPER = ? AND o.CONTACT_ID=contact.ID) OR (vehicle.RE

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 u

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 the

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 doub

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

2003-10-23 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 meth

Re: [JBoss-user] FK Columns cant have NOT NULL constraints

2003-10-23 Thread Alexey Loubyansky
3.2.2RC3 http://sourceforge.net/tracker/?func=detail&aid=784322&group_id=22866&atid=381174 alex Denzil Fillis wrote: Hi All Is the following statement regarding Foreign keys in JBoss valid? If it is in which version of JBoss will it be fixed? "JBoss 3.0.x's CMP engine has this problem that FK

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

2003-10-23 Thread Alexey Loubyansky
Are there CMP fields mapped to the foreign key column? If not that is expected behaviour. 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 enfor

Re: [JBoss-user] 3.2.2 : Null primary key on create

2003-10-22 Thread Alexey Loubyansky
Hello Jason, I just fixed it. Please, try it in 24 hours. Thanks. alex Jason Essington wrote: On Tuesday, October 21, 2003, at 10:03 PM, Bill Burke wrote: It may work fine if you use the default load group. I am not defining any load groups for this entity. Rod Macpherson wrote: Is this a

Re: [JBoss-user] 3.2.2 : Null primary key on create

2003-10-21 Thread Alexey Loubyansky
The latest 3.2.2? How could I reproduce it? Thanks, alex Phil Shrimpton wrote: Hi, I have an application that works fine on 3.0.8 and 3.2.1, but on 3.2.2 I get the following error with one of my entity beans, any ideas? 2003-10-20 14:34:36,972 ERROR [org.jboss.ejb.plugins.LogInterceptor] Trans

Re: [JBoss-user] m:n bidirectional relationships

2003-10-20 Thread Alexey Loubyansky
To enable DEBUG for CMP add the following to the conf/log4j.xml alex [EMAIL PROTECTED] wrote: Hi, I'm trying to get m:n bidirectional relationships to work, and I'm a bit stuck so far. I've 2 EJB beans: Role and Subject linked together by table actor. (Actor does not have an associa

Re: [JBoss-user] ejbSelectGeneric returns wrong results

2003-10-20 Thread Alexey Loubyansky
Looks like a bug. alex Panagiotis Korros wrote: I have a home method in my cmp entity bean public Page ejbHomeGetUsers( int offset, int limit) throws FinderException { long userCount = ((Long) ejbSelectGeneric("SELECT COUNT( o.id ) FROM User o ",

Re: [JBoss-user] 3.0.x -> 3.2.x : Couldn't create entity command

2003-10-17 Thread Alexey Loubyansky
How do you specify what entity-command to use? Do you use standardjbosscmp-jdbc.xml file from 3.0.x with 3.2.2? alex Phil Shrimpton wrote: On Friday 17 October 2003 10:31, Alexey Loubyansky wrote: Hi, What are the DDs for the failing beans? Any bits in particular, as they total about

Re: [JBoss-user] 3.0.x -> 3.2.x : Couldn't create entity command

2003-10-17 Thread Alexey Loubyansky
What are the DDs for the failing beans? alex Phil Shrimpton wrote: Hi, I have an existing system that works fin on JBoss 3.0.x, and am in the process of moving it to the 3.2.x version. The system consists of about 40 EJB's (mainly entity), and all but three of them deploy fine, with the erro

Re: [JBoss-user] How to check commit option ?

2003-10-16 Thread Alexey Loubyansky
AFAIK, it is not logged anywhere. But you could play with optiond-refresh-rate. alex Ramrakhiani, Vikas wrote: Does jboss logs commit option some where? I have changed the default commit option to D in standardjboss.xml file, but I am not sure if it has come into effect. Is there a way to chec

Re: [JBoss-user] ear & jndi & different databases.

2003-10-15 Thread Alexey Loubyansky
Where/How/Do you specify what datasource is used for each entity? alex Stefan Groschupf wrote: Hi, Please please help me!!! Since 3 days I try non stop to get 2 instances of the same project running in one jboss. I scan all web pages, forums, documentations about that and I’m sure the soluti

Re: [JBoss-user] JBossCMP and cascade-delete errors

2003-10-15 Thread Alexey Loubyansky
Yes, it should. Feel free to submit a bug report. Thanks. alex Panagiotis Korros wrote: I have 2 EJBs FolderTypeEJB And FolderEJB FolderEJB has a 1-many parent-child relationship with itself (cascade-delete is on for this relationship) FolderEJB has a 1-many relationship with FolderTypeEJB (casca

Re: [JBoss-user] SQLException from 3.2.2 branch when trying to remove an entity.

2003-10-10 Thread Alexey Loubyansky
Jason Essington wrote: On Thursday, October 9, 2003, at 01:03 PM, Alexey Loubyansky wrote: Jason Essington wrote: I don't see anything immediately obvious about what I am doing different here than with my other entities. All of the others seem happy enough (not pitching exceptions). The

Re: [JBoss-user] SQLException from 3.2.2 branch when trying to remove an entity.

2003-10-09 Thread Alexey Loubyansky
me. -jason On Thursday, October 9, 2003, at 11:26 AM, Alexey Loubyansky wrote: Could you, please, provide detailed instructions how to reproduce it? Thanks. alex Jason Essington wrote: Alex That didn't seem to fix it. I don't know if this matters, but I am using the "Inst

Re: [JBoss-user] SQLException from 3.2.2 branch when trying to remove an entity.

2003-10-09 Thread Alexey Loubyansky
ber 8, 2003, at 12:13 PM, Alexey Loubyansky wrote: It was a bug that is fixed now. Could you, please, check it out in 24h? Thanks much! alex Jason Essington wrote: I am using a build from cvs as of this (10/7) morning. It claims to be RC5 the exact code that fails is record.remove(); from th

Re: [JBoss-user] SQLException from 3.2.2 branch when trying to remove an entity.

2003-10-08 Thread Alexey Loubyansky
there is more information I could supply you with, please let me know. These entities had been working perfectly in 3.2.1 and the code for them has not changed. -jason On Tuesday, October 7, 2003, at 01:22 PM, Alexey Loubyansky wrote: What JBoss version exactly are you using? 3.2.2RC5? Coul

Re: [JBoss-user] SQLException from 3.2.2 branch when trying to remove an entity.

2003-10-07 Thread Alexey Loubyansky
What JBoss version exactly are you using? 3.2.2RC5? Could you post the exact code that fails? Thanks, alex Jason Essington wrote: I have some code that worked just fine in 3.2.1 but now it is having trouble in the 3.2.2 branch of JBoss. I am getting an SQLException when I try to remove an ent

Re: [JBoss-user] using CMP and defining the datasource at runtime

2003-10-05 Thread Alexey Loubyansky
If the databases (products) and schemas are the same. Then we could add support for it. Scott M Stark wrote: Ok, but the typical usecase people ask about is some failover scenario or dev vs prod database selection where the type mappings are the same.

Re: [JBoss-user] using CMP and defining the datasource at runtime

2003-10-05 Thread Alexey Loubyansky
I don't think it is impossible. Each specific datasource has its own type mappings and SQL functions/templates. At the moment, these are read and assigned to entity and field bridges at deployment time. And there is no way to change them at run time. You could make a hack assigning a new datasou

Re: [JBoss-user] using CMP and defining the datasource at runtime

2003-10-05 Thread Alexey Loubyansky
No. The datasource is used at deployment time to initialize mapping types, row locking syntax, autoincrementation, etc. alex Ionel GARDAIS wrote: Hi, is it possible to use a CMP bean but to override the datasource from the xml files but a user defined datasource, known at runtime ? = -

Re: [JBoss-user] The future of JBossDO?

2003-10-03 Thread Alexey Loubyansky
J.Mann wrote: [ Apologies if this appears as a duplicate - the copy I sent yesterday seems to be lost in the depths of Sourceforge. ] Hello folks, I have been using JBossDO to provide persistence in a web application I am currently working on. I recently read about the union of JBoss and the

Re: [JBoss-user] Building JBoss from CVS with JBossDO

2003-10-02 Thread Alexey Loubyansky
Perhaps, so. It is instantiation of PersistenceManagerFactoryImpl. I'll look at it. Thanks. Adrian Brock wrote: Hi Jon, Has the db pool been started? I assume it has since you can lookup the data source in jndi. Question for Alex: Shouldn't this be in startService()? You can't guarantee other

Re: [JBoss-user] EJB inserts do not show up in subsequent queries:

2003-10-02 Thread Alexey Loubyansky
in both cases. I tried taking out the new insert-after-ejb-post-create container configuration but the result was the same: inserts on 3.2.2 RC4 do not show up until you restart JBoss. Rod -Original Message- From: Alexey Loubyansky [mailto:[EMAIL PROTECTED] Sent: Tuesday, September

Re: [JBoss-user] Building JBoss from CVS with JBossDO

2003-10-01 Thread Alexey Loubyansky
java:/HiLoIDGeneratorFactory And JNDIView can be found at http://localhost:8080/jmx-console J.Mann wrote: See what with JNDIView? Cheers, Jon Mann On Wed, Oct 01, 2003 at 09:11:33PM +0300, Alexey Loubyansky wrote: So, you can't see it with the JNDIView? alex J.Mann wrote: I dep

Re: [JBoss-user] Building JBoss from CVS with JBossDO

2003-10-01 Thread Alexey Loubyansky
wable: (javax.naming.NameNotFoundException: HiLoIDGeneratorFactory not bound)) Thanks, Jon Mann On Wed, Oct 01, 2003 at 07:23:53PM +0300, Alexey Loubyansky wrote: In jboss-head\persistence\src\etc\examples\idgen\ you will find to files. One of them is hilo-idgen-service.xml. Try to deploy it before your application. Please

Re: [JBoss-user] Building JBoss from CVS with JBossDO

2003-10-01 Thread Alexey Loubyansky
In jboss-head\persistence\src\etc\examples\idgen\ you will find to files. One of them is hilo-idgen-service.xml. Try to deploy it before your application. Please, let me know how whether it solved the problem ;) Thanks, alex J.Mann wrote: Hello folks! I am trying to build JBoss from CVS, wit

Re: [JBoss-user] findByHighestValue

2003-10-01 Thread Alexey Loubyansky
You need to use JBossQL instead of EJBQL. alex Milen Dyankov wrote: Matthew Hixson wrote: On Tuesday, September 30, 2003, at 12:30 AM, Milen Dyankov wrote: Matthew Hixson wrote: Could you do something like this for findLastDelivery: select ddate from foo where bar=?1 order by ddate desc limi

Re: [JBoss-user] EJB inserts do not show up in subsequent queries:

2003-10-01 Thread Alexey Loubyansky
27;s significant. We definitely had debugging on for SQL in both cases. I tried taking out the new insert-after-ejb-post-create container configuration but the result was the same: inserts on 3.2.2 RC4 do not show up until you restart JBoss. Rod -Original Message- From: Alexey Loubyansky [mai

Re: [JBoss-user] EJB inserts do not show up in subsequent queries:

2003-09-30 Thread Alexey Loubyansky
Can you see the SQL executed? Any differences? What does "we must bounce JBoss..." mean? Thanks, alex Rod Macpherson wrote: 3.2.2 RC4 is NFG: Ran the same EAR against the same database on 3.0.7 without incident. On 3.2.2 RC4 we must bounce JBoss to see inserted records. -Original Message---

[JBoss-user] JBossQL: MAX, MIN, SUM, AVG

2003-09-30 Thread Alexey Loubyansky
These are available in current CVS Branch_3_2. Examples: SELECT MAX(a.intField) FROM A AS a SELECT MIN(a.intField) FROM A AS a SELECT SUM(a.intField) FROM A AS a SELECT AVG(a.intField) FROM A AS a Change note is here: https://sourceforge.net/tracker/?func=detail&aid=815115&group_id=22866&atid=38117

Re: [JBoss-user] EJB mass deletion

2003-09-30 Thread Alexey Loubyansky
You have to use commit option B or C in this case at the moment. alex Richard Hosking wrote: Hello all, we need to delete about 20K+ records in one go according to an int field. This is currently rather slow. The following adaptation of real code is called from within a session bean:- Co

Re: [JBoss-user] cmr question

2003-09-30 Thread Alexey Loubyansky
If you are going to use foreign key on entityA, then entityB can have many entityA (and you need to use @jboss.relation). If you really want entityA to have many entityB (according to CMR get/set), foreign key should be on the entityB side. alex Ed Storm wrote: Sorry if this question seems a b

Re: [JBoss-user] Packaging an ear that contains war and sar

2003-09-29 Thread Alexey Loubyansky
You could put EAR and WAR into the SAR. alex [EMAIL PROTECTED] wrote: Hi all, i have to create an enterprise archive that is composed of one .war file and one .sar file. i have written the application.xml and the jboss-app.xml, but the problem that i have is the servlet in the war, when

Re: [JBoss-user] findByHighestValue

2003-09-29 Thread Alexey Loubyansky
Unfortunately, it is not supported by JBossQL at the moment. I'll look into adding them. alex Milen Dyankov wrote: Hi all, Is there a way to find CMP by highest/lowest value of given field? Say something like: findLastDelivery(); // ... where ddate = SELECT max (ddate) ... findBiggestOrder()

Re: [JBoss-user] Postgres + JBoss 3.2.1 + CMP

2003-09-06 Thread Alexey Loubyansky
ad do something like this: INSERT INTO v_partners (name, description, partner_type_id) VALUES ('dfadf', 'adfasdf', null); Thanks, -M@ On Saturday, September 6, 2003, at 02:13 AM, Alexey Loubyansky wrote: /** * * @jboss:entity-command name="postgresql-fetc

Re: [JBoss-user] foreign key problem

2003-09-06 Thread Alexey Loubyansky
We follow SQL'92. Look once again as the way that is ok. alex Damian Minkov wrote: Having problem one-to-many relationship. Have two EJBs I'm defining the relationship from the bean where is the 'many', and it points to the primery key of the other. I had the following eception org.jboss.deploy

Re: [JBoss-user] Postgres + JBoss 3.2.1 + CMP

2003-09-06 Thread Alexey Loubyansky
/** * * @jboss:entity-command name="postgresql-fetch-seq" */ public abstract class ChildCMPBean implements EntityBean { /** * @ejb.pk-field * @jboss.persistence auto-increment="true" */ public abstract Integer getId(); Check that 3.2.1 has postgresql-fetch-seq command in st

Re: [JBoss-user] Fail to add null value in not null attribute

2003-09-05 Thread Alexey Loubyansky
You should use auto-increment with postgresql-fetch-seq entity-command and use JBoss-3.2. alex Matthew Hixson wrote: It seems that JBoss is trying to execute some invalid SQL. It is trying to do an insert into my partners table and passing 'null' for the primary key. This is causing the P

Re: [JBoss-user] Q. on locking EB

2003-09-05 Thread Alexey Loubyansky
Muraly R wrote: HI Gurus, I was reading the 'locking' section in the doc and a short question on that? If a EB is already locked by a transaction(the EB is not specified as 'read-only'), and If a call is made to 'read-only' method of that EB, will the method be processed? If the call is

Re: [JBoss-user] EJB Inserts 'n Updates with Computed Values

2003-09-05 Thread Alexey Loubyansky
No. Rod Macpherson wrote: When a row is inserted does the EJB read that row back to pick up values that were computed by the database - trigger generated for example? --- This sf.net email is sponsored by:ThinkGeek Welcome to geek heaven. http://

Re: [JBoss-user] CMP One-to-Many Problems [PostgreSQL]

2003-09-03 Thread Alexey Loubyansky
Yes. Foreign key field[s] mapped CMP field[s], like in your case, are supported only since 3.2. alex Edgar Silva wrote: Hi Alex... I am using 3.0.4. Have some problem in this version? Regards Edgar - Original Message - From: "Alexey Loubyansky" <[EMAIL PROTECTED]

Re: [JBoss-user] CMP One-to-Many Problems [PostgreSQL]

2003-09-03 Thread Alexey Loubyansky
what JBoss version are you using? alex Edgar Silva wrote: Hi folks... I have a relationship definied this way: [Users] 0 -- 0..n [ Calls] I am using ValueObjects to transfer Data, but When I will create the child data (Calls), I get this StackTrace: 18:43:54,495 ERROR [Chamados]

Re: [JBoss-user] sync-on-commit-only and cascade-delete

2003-09-02 Thread Alexey Loubyansky
packaged within the same JAR, which is deployed in an EAR as part of a much larger application. Because I'm running my own instance of the application there shouldn't be any concurrent access to the beans when I'm attempting these deletes. -Andrew Alexey Loubyansky wrote: Are the

Re: [JBoss-user] error deploying the application

2003-09-02 Thread Alexey Loubyansky
you also have remote. alex Amit Ashok wrote: Hi All , I am new to Jboss . My application is currently running on Iplanet . I have ejb-jar.xml that is as per J2ee Ppecs . When I try to deploy the application it reports an error "15:04:56,610 ERROR [MainDeployer] could not create deployment:

Re: [JBoss-user] Jbossdo query execute exception

2003-09-01 Thread Alexey Loubyansky
Compilation is missed. > jdoQuery = pm.newQuery(User.class, filter); > > System.out.println("jdoQuery = " + jdoQuery); > jdoQuery.compile(); > Collection users = (Collection)jdoQuery.execute(); Perhaps, it should be done automatically. alex Anthony Cheung wr

Re: [JBoss-user] CMP- Hypersonic problems

2003-09-01 Thread Alexey Loubyansky
Is the "autonumber" the only problem? How does it work? alex Subramanian Ananthram wrote: Hi, We are using Hypersonic database with JBOSS 3.0.0, tomcat 4.0.3 with CMP. If JBOSS is terminated abnormally, then we have observed that some of the tables in the database is corrupted. For eg: we are us

Re: [JBoss-user] CVS Rollback - Why?

2003-09-01 Thread Alexey Loubyansky
Stephen Davidson wrote: I hope that this rollback is not just to remove contributions from developers that JBoss Group LLC is apparently pissed off at, as it would indicate continued extreme childness on their part. No, it is not. HEAD occurred to be messed up. Because, in many parts it was use

Re: [JBoss-user] sync-on-commit-only and cascade-delete

2003-09-01 Thread Alexey Loubyansky
Are there other beans involved in the tx? Something, causes synchronization. If all the CMP2 beans have sync-on-commit-only=true, then it shouldn't happen. alex Andrew May wrote: Alex, Thanks for your reply - my answers in-lined: -Andrew Alexey Loubyansky wrote: Hello, Andrew

Re: [JBoss-user] jbossdo deployment question

2003-08-30 Thread Alexey Loubyansky
Correct. Anthony Cheung wrote: Hi, It seems to be the case that jdo deployment only works if only *.class and *.jdo files are in the jar. Is this correct? I tried to have ejbs within the same package and the jdos doesn't get deploy. thanks --

Re: [JBoss-user] sync-on-commit-only and cascade-delete

2003-08-30 Thread Alexey Loubyansky
Hello, Andrew. my comments in-lined. Andrew May wrote: I'm having a problem trying to user sync-on-commit-only and cascade-delete with JBoss 3.2.1 (Sun JDK1.4.2, Solaris). We've got a number of related entities like this: LOGIN---IDENTITY | | LOGINPROPERTIES

Re: [JBoss-user] [3.2.2RC2] Using the UUID or HiLoID generator

2003-08-28 Thread Alexey Loubyansky
--Original Message----- From: Alexey Loubyansky [mailto:[EMAIL PROTECTED] Sent: Thursday, August 28, 2003 2:06 PM To: [EMAIL PROTECTED] Subject: Re: [JBoss-user] [3.2.2RC2] Using the UUID or HiLoID generator Done. IDGenerator... are from 4.0 as well as HiLo. alex Barlow, Dustin wrote: Is it possib

Re: [JBoss-user] [3.2.2RC2] Using the UUID or HiLoID generator

2003-08-28 Thread Alexey Loubyansky
ia the JMX interface (the actual method is getKeyGenerator() btw). I would still need the two interfaces above in the jboss-client.jar to call it. Not sure which approach is the preferred (ie JNDI lookup versus JMX lookup). Dustin -Original Message- From: Alexey Loubyansky [mailto:[EMAIL P

Re: [JBoss-user] Problem deploying Entity Beans with relationshipsin JBoss 3.2.2 - Please Help

2003-08-28 Thread Alexey Loubyansky
You need to specify key-fields on the other side (with multiplicity one). alex Sasidharan, Manoj wrote: Hello All, I am trying to deploy a jar file that contains some entity beans with relationships. It fails to deploy giving the following error: Can somebody help me resolve this also. Thanks

Re: [JBoss-user] JNDI Name

2003-08-28 Thread Alexey Loubyansky
otely? -Original Message- From: Alexey Loubyansky [mailto:[EMAIL PROTECTED] Sent: Wednesday, August 27, 2003 4:37 AM To: [EMAIL PROTECTED] Subject: Re: [JBoss-user] JNDI Name Everything under 'java:/' is not remotely accessible. alex Rod Macpherson wrote: JBoss is binding my datas

Re: [JBoss-user] Postgres character fields and JBoss-QL

2003-08-27 Thread Alexey Loubyansky
char is a numeric type. 11.2.7.1 Literals An exact numeric literal is a numeric value without a decimal point, such as 57, -957, +62. Exact numeric literals support numbers in the range of Java long. Exact numeric literals use the Java integer literal syntax. alex Matthew Hixson wrote: I have

Re: [JBoss-user] syntax of LIMIT

2003-08-27 Thread Alexey Loubyansky
Looks like it requires a parameter. alex Matthew Hixson wrote: Can LIMIT be followed directly by a hard coded number or does it have to be a parameter? I have a method that needs to return only the top 10 items from the database after doing a sort. This won't change, so there's no need to p

Re: [JBoss-user] JNDI Name

2003-08-27 Thread Alexey Loubyansky
Everything under 'java:/' is not remotely accessible. alex Rod Macpherson wrote: JBoss is binding my datasource just fine and my webapp works but trying to connect from a stand-alone client outside of the server fails: 14:25:52,704 INFO [FoobarDS] Bound connection factory for resource adapt

Re: [JBoss-user] Deadlock following rollout to 3.2.2 (RC2 or RC3)

2003-08-27 Thread Alexey Loubyansky
You should provide relevant source code snippets. Plus you use EJB-based implementatoin of sequnces, right? What are the tx attributes for relevant methods? alex Stephane Nicoll wrote: Hi, Our application runs 'fine' on JBoss 3.2.1 using intensively JMS and Entity beans in CMP mode. I tried to

Re: [JBoss-user] mapping EJB-QL functions to SQL functions

2003-08-26 Thread Alexey Loubyansky
, August 26, 2003, at 10:41 AM, Alexey Loubyansky wrote: No, there is no how-to. You need to delve in the source. Specifically org.jboss.ejb.plugins.cmp.ejbql.* org.jboss.ejb.plugins.cmp.jdbc.JDBCEJBQLCompiler You also need to have some experience with jjtree. alex Matthew Hixson wrote: On Tuesday

Re: [JBoss-user] mapping EJB-QL functions to SQL functions

2003-08-26 Thread Alexey Loubyansky
No, there is no how-to. You need to delve in the source. Specifically org.jboss.ejb.plugins.cmp.ejbql.* org.jboss.ejb.plugins.cmp.jdbc.JDBCEJBQLCompiler You also need to have some experience with jjtree. alex Matthew Hixson wrote: On Tuesday, August 26, 2003, at 03:42 AM, Alexey Loubyansky

Re: [JBoss-user] Can't find connection left open

2003-08-26 Thread Alexey Loubyansky
It seems to be ok. One nuance, though. You are reusing variables stmt and rs for two PreparedStatement and ResultSet instances. > stmt = conn.prepareStatement( > SQL_FIND_PRODUCTS_COUNT_BY_CATEGORY, ResultSet.TYPE_SCROLL_INSENSITIVE, > ResultSet.CONCUR_READ_ONLY ); and then >

Re: [JBoss-user] No hair left, help is needed on $Proxy23.NoSuchMethodError

2003-08-26 Thread Alexey Loubyansky
loaded? If so I could probably embed that piece of code and do a System.out.println of the directory/jar from which it is loaded. Regards, Cor. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Alexey Loubyansky Sent: Tuesday, August 26, 2003 14:38 To: [EMAIL

Re: [JBoss-user] No hair left, help is needed on $Proxy23.NoSuchMethodError

2003-08-26 Thread Alexey Loubyansky
Could it be that there is some other version of the class in the classpath that does not have this method? alex Cor Hofman wrote: Hi all, No response yet, so let me toss in a suggestion. Could it be that this is a classloader issue? Regards, Cor. -Original Message- From: [EMAIL PR

Re: [JBoss-user] mapping EJB-QL functions to SQL functions

2003-08-26 Thread Alexey Loubyansky
No, that's not enough, unfortunately. You have to introduce ASTNow (the class that represents now() function) to QL compiler. alex Matthew Hixson wrote: I am trying to use now() from within an EJB-QL query. JBoss tells me this when trying to deploy my jar file: nested throwable: (org.jboss.

Re: [JBoss-user] comparing against the current time

2003-08-26 Thread Alexey Loubyansky
Yes, it will work. alex Matthew Hixson wrote: I've been looking for several hours now how to go about making use of now() from a JBoss-QL query. Seems to me that I cannot. So, if that is the case, what is the general way of comparing a date in the database against the current time? Do I ne

Re: [JBoss-user] How to get EJB's LocalHome from MBean?

2003-08-26 Thread Alexey Loubyansky
The name under which the bean is bound in JNDI. Example: Context initial = new InitialContext(); MyBeanLocalHome objref = (MyBeanLocalHome)initial.lookup("MyBean"); alex Steven Harris wrote: What is this "global" JNDI name? Could you give me an example? -Original Messa

Re: [JBoss-user] How to get EJB's LocalHome from MBean?

2003-08-23 Thread Alexey Loubyansky
Milen Dyankov wrote: Hi, can you please explain how can one call Session or Entity Bean from an MBen? I was under the impression that because the EJB and the MBean are deployed in the same JBoss instance (does this means same VM?) Yes. The code below is ok except you should use bean's (global

Re: [JBoss-user] EJB Garbage Collection

2003-08-23 Thread Alexey Loubyansky
Check the the container-configuration in standardjboss.xml for stateful session bean container. max-bean-age - the maximum period of inactivity in seconds a bean can have before it will be passivated by the overager process. max-bean-life - the maximum period of inactivity in seconds a bean can

Re: [JBoss-user] [3.2.2RC2] Using the UUID or HiLoID generator

2003-08-22 Thread Alexey Loubyansky
all cases including across multiple clustered JBoss instances? Dustin -Original Message- From: Alexey Loubyansky To: [EMAIL PROTECTED] Sent: 8/20/2003 1:02 PM Subject: Re: [JBoss-user] [3.2.2RC2] Using the UUID or HiLoID generator Hello Dustin, you can use generators in your applications

Re: [JBoss-user] No ejb-relationship-role-name element found

2003-08-22 Thread Alexey Loubyansky
You should provide a non-empty name. >* @ejb.relation >* name="1 File has 1 ContentType" >* role-name="File has 1 ContentType" >* target-ejb="ContentType" *target-role-name="NON_EMPTY_NAME" alex Matthew Hixson wrote: When deploying my entity beans I receive t

Re: [JBoss-user] [3.2.2RC2] Using the UUID or HiLoID generator

2003-08-21 Thread Alexey Loubyansky
Hello Dustin, you can use generators in your applications. For example: InitialContext ic = new InitialContext(); // get generator factory from JNDI IDGeneratorFactory keyGeneratorFactory = (IDGeneratorFactory)ic.lookup(idFactoryName); // get generator instance (perhaps, should be made a // @j

Re: 2nd try: Re: [JBoss-user] ejbStore(): Again!!!

2003-08-20 Thread Alexey Loubyansky
Can you try a simple test openning a database connection and writting something to the db? I would guess something is wrong on the database's side. alex Muraly R wrote: Hi Gurus, Any leads I can take from you regarding this issue. The error logs is after the ejbStore() stays in p

Re: [JBoss-user] Unique CMR fields

2003-08-19 Thread Alexey Loubyansky
If you mean mapping foreign key fields to primary key fields, yes, it is possible. Just specify the same column names for foreign and primary keys. If you want UNIQUE, you have to do it yourself, JBoss does not generate it. alex Milen Dyankov wrote: Hi all, this could be more EJB than JBoss rel

Re: [JBoss-user] error in running application that uses JDO - cannotlocate persistencemanagerfactory

2003-08-18 Thread Alexey Loubyansky
will work with webapp :-) and i m willing to help if needed.. thanx and regards marco -Original Message- From: ext Alexey Loubyansky [mailto:[EMAIL PROTECTED] Sent: 18 August, 2003 17:00 To: [EMAIL PROTECTED] Subject: Re: [JBoss-user] error in running application that uses JDO -

Re: [JBoss-user] error in running application that uses JDO - cannotlocate persistencemanagerfactory

2003-08-18 Thread Alexey Loubyansky
work? i need it 'desperately'. i m willing 2 wait if u can give me a timeline of when it will work with webapp :-) and i m willing to help if needed.. thanx and regards marco -Original Message- From: ext Alexey Loubyansky [mailto:[EMAIL PROTECTED] Sent: 18 August

Re: [JBoss-user] CMP2 JDBCCMP2xFieldBridge Storing Non-Dirty Fields

2003-08-18 Thread Alexey Loubyansky
08-18 10:37:24,093 117639 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCStoreEntityCommand.PayeeCheck] (RMI TCP Connection(1)-169.254.25.129:) Rows affected = 1 --- Alexey Loubyansky <[EMAIL PROTECTED]> wrote: I don't know when 3.2.2RC3 is going to be released. There should be nightly build

Re: [JBoss-user] ejbStore(): Again!!!

2003-08-18 Thread Alexey Loubyansky
Are there more some info available other than "I have a problem in ejbStore"? is it BMP? does it occur for one client (one thread)? what is the tx isolation level in the db? any stacktrace? alex Muraly R wrote: Hi Gurus, One of the main problems I am facing now is transactions getting stuc

Re: [JBoss-user] error in running application that uses JDO - cannotlocate persistencemanagerfactory

2003-08-18 Thread Alexey Loubyansky
Unfortunately, it is a limitation of JDODeployer. At the moment, you can't place JDO jar packages into the lib directories of the WAR. The JAR in the WAR will be added to the classpath but won't be deployed by the JDODeployer. Actually, it behaves like EJBDeployer. alex [EMAIL PROTECTED] wrote:

Re: [JBoss-user] CMP2 JDBCCMP2xFieldBridge Storing Non-Dirty Fields

2003-08-18 Thread Alexey Loubyansky
It is fixed in 3.2.2RC3 in CVS. alex Nicholas wrote: JBoss 3.2.2RC2 Win32 JDK 1.4.2 I have an entity bean which is being updated with a coarse grained method that passes a value object which was previosuly retrieved. In this test case, only one field was updated, yet the store command stores eve

Re: [JBoss-user] Deployment Problem: Creating fk-constraints beforecreating tables...???

2003-08-18 Thread Alexey Loubyansky
Could you try it with 3.2.2 (better from CVS) and if it fails, please, submit a bug report. Thank you, alex Stefan Schubert wrote: On Thu, 14 Aug 2003 19:52:55 +0300, Alexey Loubyansky <[EMAIL PROTECTED]> wrote: Hello Stefan, it should not happen. First, a table is created. Then, f

Re: [JBoss-user] [NEWBIE] Running more than one Jboss instance

2003-08-14 Thread Alexey Loubyansky
Hello Marco, it is covered in BindingService.pdf on sourceforge.net. alex Sunday, August 10, 2003, 11:17:36 AM, Marco Tedone wrote: > Could please someone help me with this issue or tell me where could I find how to do > it on a free guide? > Thank you for your help, > Marco >> Hi, I would

Re: [JBoss-user] CMR create fails for many side

2003-08-14 Thread Alexey Loubyansky
Hello Matthew, you defined two primary keys for each entity: one is unknown and the other one is "known". You can't do it. Get rid of one of them. To let the "known" key be generated just mark it as auto-increment. Note, entity-command declaration is needed in both cases. alex Monday, August 11,

Re: AW:Re: [JBoss-user] different class loader behaviour (oracle jdbc ) in jb3.2.x-jetty a nd jb3.2.2RC-tomcat ?

2003-08-14 Thread Alexey Loubyansky
in it: no J2EE stuff, > simple servlets connecting to orcale via jdbc > need anything else? > cheers > lothar > -Ursprüngliche Nachricht- > Von: Alexey Loubyansky [mailto:[EMAIL PROTECTED] > Gesendet: Wednesday, August 13, 2003 12:58 PM > An: Egger Lothar > Betreff: Re:

Re[2]: [JBoss-user] and

2003-08-14 Thread Alexey Loubyansky
Both should work. alex Wednesday, August 13, 2003, 1:17:29 PM, Muraly R wrote: > Hi Alex, > Thnaks for the detailed clarification. > One more small doubt: > While specifying the for methods, in the docs its given as > 'true'(small 't') , where as while giving for entity beans

Re: [JBoss-user] CMP / auto-increment/ key gen / various dbs

2003-08-14 Thread Alexey Loubyansky
Hello Justin, I guess, you need to upgrade to jboss-3.2.2 to use 'keygen' package. Key generation in 3.2.1 is also supported. The relevant classes are server/default/lib/jboss.jar. Could you check whether the classes are in jboss.jar? If they are not and they are defined in standardjbosscmp-jdbc.

Re: [JBoss-user] ejbCreate() followed by ejbStore() locks, EntityBean!!!

2003-08-14 Thread Alexey Loubyansky
Hello Muraly, I am sorry, I would like to help you, but I can't understand what you are writting about. Could you rewrite it with EJB terms or post a testcase reproducing the problem? Also, please, let us know what JBoss version and database you are using. alex Thursday, August 14, 2003, 9:36:11

Re: [JBoss-user] different class loader behaviour (oracle jdbc) in jb3.2.x-jetty a nd jb3.2.2RC-tomcat ?

2003-08-14 Thread Alexey Loubyansky
Hello Egger, the answer is in packaging. How is it done? alex Wednesday, August 13, 2003, 1:33:30 PM, Egger Lothar wrote: > hello all > after testing Jboss 3.2.2RC-tomcat with some ear's e.g > using different versions of oracle-jdbc one ear uses (classes12.jar) > and one ear (ojdbc14.jar), i g

Re[2]: [JBoss-user] What wrong in my EJB-QL

2003-08-14 Thread Alexey Loubyansky
Hello Tom, I missed the original email. What is the problem? It looks ok. alex Thursday, August 14, 2003, 12:01:04 AM, Tom Coleman wrote: >> >> Can any one tell me whats wrong with the following EJB-QL >> >> >> >>findUser >> >>

Re: [JBoss-user] NoSuchMethodError from an EJB

2003-08-14 Thread Alexey Loubyansky
Hello Sheldon, make sure the commons-httpclient.jar deployed is uptodate. HttpMethod class is found but has no the method. alex Tuesday, August 12, 2003, 3:21:56 PM, Sheldon Hearn wrote: > I'm using jboss-3.2.1_tomcat-4.1.24 and can't get one of my EJBs to > "see" a class from commons-httpclien

Re: [JBoss-user] and

2003-08-14 Thread Alexey Loubyansky
Hello Muraly, of course you can/should use both tags at the same time. Entity beans must be accessed in a transactional context. If instance is locked, then only one tx (holding the lock) has access to the instance. If instance is not locked then many transactions can access the instance at the sa

<    1   2   3   4   5   >