Re: [JBoss-user] Re: Compound PK using CMR/CMP

2003-04-04 Thread Alex Loubyansky
he ORC5 tag in CVS...ORC4 is the latest I see for 3.2? BR> -Billy BR> From: Alex Loubyansky <[EMAIL PROTECTED]> BR> To: Billy Rutledge <[EMAIL PROTECTED]> BR> Subject: Re: [JBoss-user] Compound PK using CMR/CMP BR> >Could you please try JBoss-3.2.0RC5 from CVS? BR>

Re: [JBoss-user] CMR keeps using java:/DefaultDS?

2003-04-04 Thread Alex Loubyansky
Hello Billy, it should be fixed in current CVS version for all branches. alex Friday, April 04, 2003, 10:56:39 PM, you wrote: BR> Hi All, BR> I have an Entity EJB deployed to JBoss-3.0.6 that has a single CMR BR> field. In my jbosscmp-jdbc.xml file, I have the datasource and BR> datasource-

Re: [JBoss-user] Compound PK using CMR/CMP

2003-04-04 Thread Alex Loubyansky
Could you please try JBoss-3.2.0RC5 from CVS? It should work. You can check a testcase in org.jboss.test.cmp2.fkmapping package. alex Friday, April 04, 2003, 8:38:58 PM, you wrote: BR> Hi All, BR> I have created an Entity EJB that maps to a table with a compound PK BR> (both columns are NOT NUL

Re: [JBoss-user] Problem in cmr get procedure (jboss3.2.0RC3)

2003-04-04 Thread Alex Loubyansky
Could you, please, try JBoss-3.2.0RC5 from cvs? There were a lot of changes in the code since 3.2.0RC3 Thanks, alex Friday, April 04, 2003, 4:46:34 PM, you wrote: CM> Hi all, CM> I am using jboss3.2.0RC3, jdk1.3.1_06, database Hypersonic. CM> My application description CM> -BeanA and BeanB ha

[JBoss-user] Re: [JBoss-dev] Compound PK using CMR/CMP

2003-04-03 Thread Alex Loubyansky
Please, post to jboss-user. Provide more info on mapping of entities and relationships, tables in the database and exception. Could you try your app in JBoss-3.2? alex Friday, April 04, 2003, 4:23:18 AM, you wrote: BR> Hi, BR> I have created an Entity EJB that maps to a table with a compound

Re: [JBoss-user] Optimized CMP loading

2003-04-03 Thread Alex Loubyansky
Thursday, April 03, 2003, 3:35:05 PM, you wrote: SM> Hi, SM> Is it possible to preload all the entities returned from a finder? Yes, with read-ahead. SM> I have a finder method that returns many rows (around 100) and the read-ahead strategy does not help at all. Does not help or does no

Re: [JBoss-user] How to build Tomcat Module

2003-04-02 Thread Alex Loubyansky
AFAIK, catalina is for Tomcat-4.0.x. So, tomcat41 is for you. You don't need to look at build.xml file. In tomcat41, there should be a readme file with instructions. Just follow them and there shouldn't be problems. alex Wednesday, April 02, 2003, 5:49:24 PM, you wrote: SM> Hi, SM> I am try

[JBoss-user] Re: [JBoss-dev] Anybody ever had problem with CMR when using PostgreSQL ?

2003-04-01 Thread Alex Loubyansky
Please, post to jboss-user. Maybe the problem is in case-sensitivity? Make sure CMP and foreign key fields have the same name and use the same case. alex Wednesday, April 02, 2003, 7:56:41 AM, David Wang wrote: DW> I have 2 CMP entity beans that have one to many relationship. The "Many" DW> sid

[JBoss-user] Re: [JBoss-dev] Using postgreSQL 7.3.2 with JBoss 3.0.6

2003-04-01 Thread Alex Loubyansky
David, you are on the wrong list. I am forwarding you to jboss-user. 1. Set debug to true http://jakarta.apache.org/log4j/"; debug="true"> 2. remove Threshold for CONSOLE 3. set DEBUG for org.jboss.ejb.plugins.cmp alex Wednesday, April 02, 2003, 5:45:38 AM, David Wang

Re: [JBoss-user] Between dates problem in Dynamic QL ???

2003-04-01 Thread Alex Loubyansky
You have to pass dates as a parameter to the query. Instead of real dates put in the query ?1, ?2, ... And then ejbSelectMethod(jbossQl.toString(), args), where args contains instances of Date. alex Tuesday, April 01, 2003, 2:17:15 PM, Brijesh Sood wrote: BS> Hi All , I have to create dynamicq

Re: [JBoss-user] relationship between beans from differents providers

2003-04-01 Thread Alex Loubyansky
Relationships are allowed between entities declared in the same ejb-jar.xml. You can put third party beans somewhere in the class path and create your ejb-jar.xml that will define thirdparty beans, your beans and relationships between them. alex Tuesday, April 01, 2003, 4:32:54 PM, Ionel Gardais

Re: [JBoss-user] CMR question: r-table-mapping, with existing tables

2003-04-01 Thread Alex Loubyansky
Hello Bill, Tuesday, April 01, 2003, 2:18:37 AM, Bill Curtis wrote: BC> hello... BC> I have an existing table, A, which has a 1..* relationship with itself. BC> This relationship makes us of an existing mapping table, B. BC> I have inherited these tables, and unfortunately cannot alter them.

Re: [JBoss-user] additional fields in a CMR relation table

2003-04-01 Thread Alex Loubyansky
Tuesday, April 01, 2003, 3:00:13 PM, Ionel Gardais wrote: IG> Hi, IG> is it possible to access additional fields in a CMR relation table ? IG> example : a Book table filled with Book entries, a Person tagle filled IG> with people infos and a CMR relation table that stores who loans what. IG> D

Re[2]: [JBoss-user] CMR Error under load

2003-04-01 Thread Alex Loubyansky
ject: Re: [JBoss-user] CMR Error under load >> > >> > >> > >> >>I don't see a RC5 release on sourceforge, so I assume this means I have SM> to >> > >> > build it from >> > >> >>CVS. I'll give that a go, b

Re: [JBoss-user] Exposing timestamp-column field for Optimistic lock

2003-03-31 Thread Alex Loubyansky
Using optimistic locking with timestamp_column_strategy means an entity will be added a timestamp column that will be used for optimistic locking. It can't be accessed by application. (Indeed, it should be possible to mention it in a QL statement) If you want a CMP timestamp field to be used in op

Re[2]: [JBoss-user] CMR Error under load

2003-03-31 Thread Alex Loubyansky
escribed, but the fix should bin in 3.2 rc4. >> >> Until someone can create a test case that reproduces the new bug, I >> don't think there is much we can do. >> >> -dain >> >> On Friday, March 28, 2003, at 10:01 AM, Alex Loubyansky wrote: >> >&

Re[2]: [JBoss-user] CMR uses the default datasource in stead of the one specifically specified for the CMP 2.0 EJB entity beans concerned

2003-03-31 Thread Alex Loubyansky
Just ported the fix to JBoss_3_0. You need to check out the source from CVS and build it yourself. For 3.0 version: cvs -z3 -d:pserver:[EMAIL PROTECTED]:/cvsroot/jboss co -r Branch_3_0 jboss-3.0 alex Monday, March 31, 2003, 3:02:15 PM, Jboss Percy wrote: JP> I use the normal download (with Tomc

Re: [JBoss-user] CMR uses the default datasource in stead of the one specifically specified for the CMP 2.0 EJB entity beans concerned

2003-03-31 Thread Alex Loubyansky
What JBoss version are you using? This was fixed in Branch_3_2 recently. alex Monday, March 31, 2003, 2:05:25 PM, Jboss Percy wrote: JP> I am new to JBoss and to MySql (although the problem has not JP> specifically to do with MySql). JP> I am trying to port a rather large application from Borlan

Re[2]: [JBoss-user] CMR Error under load

2003-03-28 Thread Alex Loubyansky
Hello Andrew, you are not alone complaining about this. But nobody could produce a testcase that fail at least eventually. I am trying to reproduce it but can't for the moment. I have a Parent and 1000 of related Child entities. I have 100 concurrent threads finding parent by primary key, gettin

Re: [JBoss-user] One to Many CMR question.

2003-03-25 Thread Alex Loubyansky
No, not at the moment. Foreign key fields should represent primary key fields. Probably, we'll address secondary keys in JBoss-4. alex Tuesday, March 25, 2003, 7:55:31 PM, you wrote: NS> Okay, I'm just trying to find a simple piece of information. Can a one NS> to many CMR be created that refer

Re[6]: [JBoss-user] CMR with FK in the database

2003-03-24 Thread Alex Loubyansky
entity SM> com.sybase.jdbc2.jdbc.SybSQLException: Column name MV_MDS_ID appears more SM> than o SM> nce in the result column list. SM> Because the CMP fileds and CMR fields do overlap - See JDBCEntityBridge line SM> 151 SM> Thanks!!! SM> Simone SM> - Original Message -

Re[6]: [JBoss-user] CMR with FK in the database

2003-03-24 Thread Alex Loubyansky
Cxd> Mobile: +353 86 824 0736 JOCxd> Alex Loubyansky <[EMAIL PROTECTED]> JOCxd> Sent by: [EMAIL PROTECTED] JOCxd> 24.03.2003 15:52 JOCxd> Please respond to jboss-user JOCxd> To: Simone Milani <[EMAIL PROTECTED]> JOCxd> cc: JOCxd>

Re[6]: [JBoss-user] CMR with FK in the database

2003-03-24 Thread Alex Loubyansky
ID appears more SM> than o SM> nce in the result column list. SM> Because the CMP fileds and CMR fields do overlap - See JDBCEntityBridge line SM> 151 SM> Thanks!!! SM> Simone SM> - Original Message - SM> From: "Alex Loubyansky" <[EMAIL

Re: [JBoss-user] Stack Overflow Exception in CMR

2003-03-24 Thread Alex Loubyansky
This should be fixed now. Could you try current CVS version for Branch_3_2? Thank you, alex Monday, March 24, 2003, 1:43:06 AM, Michael Nowotny wrote: MN> Hello! MN> I'm getting a StackOverflowException while population a CMR Entity Bean. What's special about the relation is that it uses prima

Re[4]: [JBoss-user] CMR with FK in the database

2003-03-24 Thread Alex Loubyansky
ginal Message - SM> From: "Alex Loubyansky" <[EMAIL PROTECTED]> SM> To: "Jonathan.O'[EMAIL PROTECTED]" <[EMAIL PROTECTED]> SM> Sent: Monday, March 24, 2003 12:06 PM SM> Subject: Re[2]: [JBoss-user] CMR with FK in the database >> JBoss-3.2 no

Re[2]: [JBoss-user] CMR with FK in the database

2003-03-24 Thread Alex Loubyansky
JBoss-3.2 now supports NON-NULL foreig keys if foreign key fields are mapped to NON NULL CMP fields. alex Monday, March 24, 2003, 1:50:17 PM, Jonathan O'Connor wrote: JOCxd> Simone, JOCxd> Look for previous messages about INSERT after ejbPostCreate. JOCxd> If you use oracle you can also mark the

Re: [JBoss-user] CMR Problems

2003-03-24 Thread Alex Loubyansky
Hello Christofer, I guess, you are using CMR setter to establish relationship. In case of FK fields are mapped to primary key columns you can't use CMR setters, as it involves changing primary key value that is not allowed. Perhaps, I might not throw this exception if new value does not change pri

Re: [JBoss-user] Stack Overflow Exception in CMR

2003-03-23 Thread Alex Loubyansky
Hello Michael, it's a bug. I'll fix it today ASAP. alex Monday, March 24, 2003, 1:43:06 AM, you wrote: MN> Hello! MN> I'm getting a StackOverflowException while population a CMR Entity Bean. What's special about the relation is that it uses primary key fields as part of the relation (no for

Re: [JBoss-user] Optimistic Locking error

2003-03-21 Thread Alex Loubyansky
Please, submit a bug report and include all this info. Thank you, alex Thursday, March 20, 2003, 5:20:34 PM, Simone Milani wrote: SM> Hi, SM> I am using 3.2.0 RC3 and have a an entity bean with a one to many relation with another entity bean. Both uses Optimistic Locking with modified sta

Re: [JBoss-user] Optimistic locking Strategy

2003-03-20 Thread Alex Loubyansky
How will this differ or what benefits will it have comparing to timestamp version column strategy already implemented? alex Thursday, March 20, 2003, 1:31:33 PM, Simone Milani wrote: SM> Hi, SM> The sybase database includes a type called TIMESTAMP which is effectively a VARBINARY(8) and i

Re: [JBoss-user] Table creation error

2003-03-17 Thread Alex Loubyansky
Richard, could you provide more info about the entity? How can I reproduce it? Thanks, alex Monday, March 17, 2003, 10:14:47 PM, you wrote: RS> Jboss is creating a malformed SQL statement in creating a table. It RS> sticks an extra invalid parenthesis in "NUMB_TYPE NUMBER(3)) NOT NULL" RS> How

Re[4]: [JBoss-user] CMP Entity Bean Insert/Commit after ejbPostCreate()

2003-03-14 Thread Alex Loubyansky
NULL if at least one column that is not a primary key one contains NULL value. It could be still hard to grasp. If you have a real problem then describe it and we'll follow a real example. alex CB> Thanks, CB> Chad CB> Alex Loubyansky <[EMAIL PROTECTED]> wrote:DS> 3.2

Re: AW: Re[2]: [JBoss-user] CMP Entity Bean Insert/Commit after ejbPo stCreate()

2003-03-14 Thread Alex Loubyansky
oice. alex MWB> Anyway, thanks for all the info and explanations. MWB> Bernie MWB> -Ursprüngliche Nachricht- MWB> Von: Alex Loubyansky [mailto:[EMAIL PROTECTED] MWB> Gesendet: Donnerstag, 13. März 2003 20:28 MWB> An: Dain Sundstrom MWB> Betreff: Re[2]: [JBoss-user] CMP E

Re[2]: [JBoss-user] CMP Entity Bean Insert/Commit after ejbPostCreate()

2003-03-13 Thread Alex Loubyansky
DS> 3.2 supports not null foreign keys, but you will have to ask Alexey how DS> to set it up. Just map foreign key fields to primary key columns. This case is not trivial and we had hot debates on this topic with Dain and Jeremy. If foreign key fields mapped to primary key fields is what you need

Re: [JBoss-user] CMP fields that are mapped to columns that also participate in a CMR

2003-03-10 Thread Alex Loubyansky
JBoss supports FK fields mapped PK columns since version 3.2. alex Saturday, March 08, 2003, 10:16:17 PM, you wrote: JD> Hi All, JD> The following extract came from Middlegen FAQ at: JD> http://boss.bekk.no/boss/middlegen/faq.html JD> "It's also important to realise that different EJB contain

Re: [JBoss-user] 1 to N relationship in Jboss 3.2.0 RC3

2003-03-07 Thread Alex Loubyansky
Just configure the key fields on the one side, i.e. mDSKeyMatrix-has-mDSMatrixs. alex Friday, March 07, 2003, 11:01:22 AM, Simone Milani wrote: SM> Hi, SM> I have a problem with the relationship on the jbosscmp-jdbc.xml generated by the current cvs version of Xdoclet: SM> org.jboss.deployment

Re: [JBoss-user] narrowing results in finders

2003-03-06 Thread Alex Loubyansky
Thursday, March 06, 2003, 12:20:54 PM, Ionel Gardais wrote: IG> Hi, IG> Is it possible to automatically narrow the results of a finder ? IG> i.e : finder findByName(String name) on PersonBean is likely to return a single result each time so the signature can be com.test.interface.PersonneLocal

Re: [JBoss-user] CMP auto increment Postgres

2003-03-05 Thread Alex Loubyansky
default, pk-sql, key-generator, with jdk1.4 get-generated-keys. alex Wednesday, March 05, 2003, 9:47:44 PM, Dennis Gesker wrote: DRG> In JBoss 3.2RC3 I see alot of entity commands that appear to be database specific. Which of these can be used with Postgres? DRG> Thanks DRG> Dennis DRG>

[JBoss-user] HiLo key generator

2003-03-05 Thread Alex Loubyansky
I just added HiLo key generator to HEAD. Now, using entity-command configuration, it's possible to create entities with either "known" or unknown primary keys using UUID or HiLo key generators. Key generator is deployed with *-service.xml. Here is an excerpt from hilo-service.xml: j

Re[2]: [JBoss-user] RC2 possible bug in m:n relationships

2003-03-04 Thread Alex Loubyansky
. JV> jordi JV> - Original Message - JV> From: "Alex Loubyansky" <[EMAIL PROTECTED]> JV> To: "Jordi Valldaura" <[EMAIL PROTECTED]> JV> Sent: Tuesday, March 04, 2003 3:09 PM JV> Subject: Re: [JBoss-user] RC2 possible bug in m:n relationships

Re: [JBoss-user] RC2 possible bug in m:n relationships

2003-03-04 Thread Alex Loubyansky
It should work. Could you provide a test case? alex Tuesday, March 04, 2003, 2:12:30 PM, Jordi Valldaura wrote: JV> Hello, JV> I've been working with 3.0.6 and yesterday I decided to change to 3.2rc2. JV> But JV> one of my bean relationship stopped working, I have another m:n relationship JV> a

Re[2]: [JBoss-user] Creating a SQL sequence

2003-03-03 Thread Alex Loubyansky
or Oracle too. You can look at JDBCAbstractVendorCreateCommand.java and, say, JDBCHsqldbCreateCommand.java for example. It's quite simple. alex DW> thx. DW> Mensaje citado por Alex Loubyansky <[EMAIL PROTECTED]>: >> Not in 3.0 branch. You need to upgrade to 3.2. >&g

Re: [JBoss-user] Re: Deadlocks

2003-03-03 Thread Alex Loubyansky
This means the entity will be read-only, i.e. write operations are not allowed. But it is still locked in transactions. AFAIK, you can use method-level read-only flag to avoid locking. Check the dtd for jboss.xml for details how to set it up. alex Monday, March 03, 2003, 8:14:11 PM, Jon Swinth wr

Re: [JBoss-user] Creating a SQL sequence

2003-03-03 Thread Alex Loubyansky
quot;Real programmers don't write in BASIC. Actually, no SJ> programmers write in BASIC after reaching puberty." -- Best regards, Alex Loubyansky --- This sf.net email is sponsored by:ThinkGeek Welcome to geek heaven. http://thi

Re: [JBoss-user] Very confused about transactions!!

2003-03-03 Thread Alex Loubyansky
If I remember correctly, you can mark the method as read-only to void bean lokcking while invocation. This is setup in jboss.xml Check the dtd for details. alex Monday, March 03, 2003, 5:14:13 PM, Brian McSweeney wrote: BM> Hi guys, BM> I reckon I'm going to come across as a dope here, but anyw

Re: [JBoss-user] mysql auto-increment

2003-02-26 Thread Alex Loubyansky
Rene, the driver you are using doesn't have method java.sql.ResultSet PreparedStatement.getGeneratedKeys(). You need to upgrade the driver. alex Thursday, February 27, 2003, 4:55:18 AM, Rene Palad wrote: RP> Hi, RP> I'm following the recent discussion about PK RP> generation in 3.2 specificall

Re: [JBoss-user] info about

2003-02-24 Thread Alex Loubyansky
This is used only for factory or database generated primary keys. Unfortunately, it's not yet documented, so, ask specific questions here. Also, you could check jbosscmp-jdbc_3_0.dtd and standardjbosscmp-jdbc.xml for structure and sample configurations. alex Monday, February 24, 2003, 1:26:05 PM,

Re: [JBoss-user] CMP Auto-Generated Fields

2003-02-22 Thread Alex Loubyansky
Please, try to search the archive before asking. I answered this question many times and last one was just yesterday. Specifically for MySQL, in jbosscmp-jdbc.xml in the entity element: id knownid INTEGER INTEGER(11)

Re[2]: [JBoss-user] ManagedConnections Available!

2003-02-21 Thread Alex Loubyansky
DJ> I have no idea what that is. Doesn't the mysql example config file DJ> indicate the recommended driver? DJ> david DJ> On 2003.02.21 14:03 nfs_ nfs wrote: >> >> Hi david jencks, >> >> Can i use MySQLTM Connector/J ? with mysql and JBoss. Yes, that's it. alex -

Re[2]: [JBoss-user] Auto PK Generation? (JBoss3.2RC3, xdoclet 1.2b3)

2003-02-21 Thread Alex Loubyansky
i have no .. descriptors in jbosscmp-jdbc.xml and MG> no getId()/setId(..) in my bean. MG> my ejbCreate() looks like MG> public java.lang.Object ejbCreate() throws CreateException { MG> return null; MG> } MG> i have no ejbFindByPrimaryKey defined... MG> greetings MG> ma

Re: [JBoss-user] ManagedConnections Available!

2003-02-20 Thread Alex Loubyansky
This means there are no more available connections in the pool. Make sure you properly handle them, i.e. closing them correctly. Also more info about what you are doing would give more response. alex Friday, February 21, 2003, 7:17:40 AM, nfs_ nfs wrote: nn> Hi all, nn> Anyone knows why this erro

Re: [JBoss-user] jetty filter question

2003-02-19 Thread Alex Loubyansky
Frank, the problem is that, the order of elements in web.xml should match the order of elements declaration in web-app_2_3.dtd or web-app_2_2.dtd (depends on the spec version you use). Here is the snippet: I would like to run a filter on every jsp with 3.0.6. I thought if I FM> put the followin

Re: [JBoss-user] Auto PK Generation? (JBoss3.2RC3, xdoclet 1.2b3)

2003-02-19 Thread Alex Loubyansky
Markus, first of all, check Unknown primary key paragraph in the spec if you didn't yet. In a short: - no cmp accessors for the unknown pk field; - ejbCreate declares java.lang.Object as a return type - ejbFindByPrimaryKey takes java.lang.Object as a parameter - in ejb-jar.xml java.lang.Object - n

Re[3]: [JBoss-user] connector deployment

2003-02-13 Thread Alex Loubyansky
As I understand, it asks for at the beginning of the file. alex Thursday, February 13, 2003, 1:07:01 PM, you wrote: GK> Hi GK> I tried deploying my sample connector, and it got GK> deployed successfully. But it was not bonded to the GK> JNDI name. GK> To provide this I have tried preparing a

Re[2]: [JBoss-user] Open WAR directory undeploy fails

2003-02-12 Thread Alex Loubyansky
Thursday, February 13, 2003, 12:08:45 AM, you wrote: FH> It may be due to this JVM bug fixed in 1.3.1_07 FH> 4523757 FH> The javac compiler explicitly closes ZipFile objects allowing those resource FH> to be reclaimed. FH> from http://java.sun.com/j2se/1.3/ReleaseNotes.html Sorry, how is javac re

Re: [JBoss-user] Re: [Xdoclet-user] XDoclet, JBoss 3 and use-soft-locking

2003-02-12 Thread Alex Loubyansky
Wednesday, February 12, 2003, 4:02:41 PM, you wrote: DW> Brian, DW> Look at the "Deprecated and Removed" section on this page: DW> http://xdoclet.sourceforge.net/development/design.html . Yes, DW> @use-soft-locking is going to go away (at least in XDoclet 2.0). DW> Now that I think of it, was

Re: [JBoss-user] Transaction attributes

2003-02-11 Thread Alex Loubyansky
Required. alex Tuesday, February 11, 2003, 3:32:33 PM, you wrote: JH> In ejb-jar.xml one can (and should) define the applications JH> transaction policy. This is typically done in two levels, per bean JH> and per finder methods, is it? JH> Anyway, what happens if you _don't_ give any specifics?

[JBoss-user] Transactions in XPetstore

2003-02-03 Thread Alex Loubyansky
Transaction configurations in XPetstore-2.2 aren't spec 2.0 compliant. CMP beans can have only Required, RequiresNew or Mandatory tx attrs, while in XPetstore we can meet Supports and even NotSupported (Account.getUserId()). I didn't run the XPetstore on 3.0 but I ran it on JBoss-3.2RC2 and HEAD.

Re: [JBoss-user] Unable to delete jar with jboss-3.2.ORC1

2003-01-28 Thread Alex Loubyansky
This is fixed in JBoss-3.2.0RC2 alex Tuesday, January 28, 2003, 5:40:29 PM, you wrote: BM> Hi guys, BM> I'm unable to delete my jars from server/default/deploy when running this latest version of JBoss. BM> Not sure why, it wasn't a problem in the previous versions. BM> Ideas? BM> Also, it s

Re[2]: [JBoss-user] Getting Distinct to Use UCASE() or UPPER() in JBossQL or DeclaredSQL??

2003-01-28 Thread Alex Loubyansky
it in the plan if it's not there yet. alex HH> Basically I want the distinct operation to not be case sensitive. I have a HH> list of strings... Some upper case, some lower case and I want them all to HH> sort alpha, without regard to case. HH> Thanks in advance, HH> Hunter &

Re: [JBoss-user] Getting Distinct to Use UCASE() or UPPER() in JBossQL or DeclaredSQL??

2003-01-28 Thread Alex Loubyansky
Hunter, you can't use functions in the SELECT, they are allowed only in the WHERE clause. alex Tuesday, January 28, 2003, 7:47:06 PM, you wrote: HH> I am trying to get the following query to the DB: HH> SELECT DISTINCT UPPER(vendor) FROM sample_request_line_item WHERE vendor IS HH> NOT NULL OR

Re: [JBoss-user] Problem with JBoss and ejbql

2003-01-27 Thread Alex Loubyansky
sorry for stupid question, but didn't you accidently add '(' when formatted for readability? you can also remove brackets around IS NULL expression. alex Monday, January 27, 2003, 12:48:06 PM, you wrote: JH> Is anyone able to tell me what is wrong with the following ejbql JH> expression (format

Re[2]: [JBoss-user] Re: From WebLogic to JBoss

2003-01-25 Thread Alex Loubyansky
Joey, could you try it and tell what problems you met with WL7.0 apps and what you would like to improve? It shouldn't take much time I think. Thanks, alex Friday, January 24, 2003, 5:54:50 PM, you wrote: JG> --- Rob Moore <[EMAIL PROTECTED]> wrote: >> See http://www.jboss.org/services/bea-port

Re: [JBoss-user] Hot deploy in 3.2.0rc1

2003-01-23 Thread Alex Loubyansky
This is fixed in CVS. alex Thursday, January 23, 2003, 10:09:25 AM, you wrote: RH> Hi, RH> in older versions, I was just able to delete a .ear in deploy/ RH> and it got undeployed. Or I could overwrite it with a new one RH> which got hot deployed. RH> In RC1, this is no longer possible, as Win2

Re[2]: [JBoss-user] Can two separate client threads make simultaneous calls?

2003-01-23 Thread Alex Loubyansky
Beau, could you, please, provide simple/not-simple testcase at least for one of the cases? Thanks, alex Wednesday, January 22, 2003, 10:47:57 PM, you wrote: BC> Complete stack traces are attached. Sorry I didn't give them last time. BC> You may well be right about why these deadlocks not occu

Re: [JBoss-user] Can two separate client threads make simultaneous calls?

2003-01-22 Thread Alex Loubyansky
what is the problem? what locking policy are you using? alex Wednesday, January 22, 2003, 8:43:05 PM, you wrote: BC> I have a Swing app which is essentially single-threaded, accessing the BC> server in the usual way through a session facade. I'd like to do some BC> background loading of certa

Re: [JBoss-user] Compound Foreign Keys

2003-01-22 Thread Alex Loubyansky
- compound foreign keys are supported by all JBoss versions; - foreign key fields mapped to primary key fields are supported only since JBoss-3.2; - foreign key fields mapped to non-primary key CMP fields are not supported at all. It's not documented yet. Ask your questions here, but, please, try

Re: [JBoss-user] EJB2.0 JBoss 3.0.4 NullPointerException on invocation of abstract getter

2003-01-21 Thread Alex Loubyansky
Raymond, could you provide more info about the bean and the way you are trying to load it? alex Tuesday, January 21, 2003, 2:29:32 PM, you wrote: BR> Hi all, BR> I have an entity bean that retreives data from the following table: BR> CREATE TABLE testnullvalues.DomainClass ( BR> id

Re: [JBoss-user] NotSerializableException Thrown by RelationSet in jboss-3.0.4_tom cat-4.1.12

2003-01-20 Thread Alex Loubyansky
Matthew, you are trying to access local interfaces/relationships remotely. This is not allowed by the spec and implementation. alex Monday, January 20, 2003, 10:17:03 PM, you wrote: HM> Hi-- HM> I'm trying to configure jboss 3.0.4 w/tomcat4.1.12 for CMR for two tables in HM> our Oracle DB. I

Re[2]: [JBoss-user] Calling an EJB from another EJB

2003-01-20 Thread Alex Loubyansky
Anthony, did you write it by mistake? You need an ejb-ref or ejb-local-ref in order to access EJBs in java:comp/env context. alex Monday, January 20, 2003, 5:01:12 PM, you wrote: >> Why it is not possible to call an EJB from another EJB using >> lookup("java:comp/env/ejb/EJBsName") ? AG> It is

Re: [JBoss-user] cmp.jdbc.RelationSet not serialized?

2003-01-20 Thread Alex Loubyansky
Klaas, relationships can be established only with local interfaces and, thus, accessed only localy, in the same VM. That's by the spec. alex Monday, January 20, 2003, 3:47:30 PM, you wrote: KvdP> Hi All, KvdP> I have successfully deployed some entitybeans on my jboss 3.0.4 server. I'm KvdP> u

Re: [JBoss-user] may I expose CMR foreign key as a cmp-field?

2003-01-20 Thread Alex Loubyansky
Monday, January 20, 2003, 2:02:11 PM, you wrote: JF> Am i right when i say that the 32rc1 release only allows a fk to be apart of a pk but not allowing a cmr foreign key to also be a JF> cmp field? yes JF> Jboss4.0? not currently implemented but planned alex --

Re: [JBoss-user] best practice - selecting a finder based on search criteria VO

2003-01-17 Thread Alex Loubyansky
There is a dynamic-ql for this. In the bean: public abstract Collection ejbSelectMyDynamicQuery(String ejbQl,Object[] args) throws FinderException; Where ejbQl is EJBQL/JBossQL query, args - array of parameters. In jbosscmp-jdbc.xml: ejbSelectMyDynamicQuery

Re[2]: [JBoss-user] MySQL Datasource configuration problem

2003-01-15 Thread Alex Loubyansky
PK> Thanks Alex, but I'm trying to access the datasource from within JBoss PK> (CMP)... Sorry, being in inattentive. You need java:/mySQLDS. alex >> -Original Message- >> From: [EMAIL PROTECTED] >> [mailto:[EMAIL PROTECTED]]On Behalf Of Alex >> Loubya

Re: [JBoss-user] MySQL Datasource configuration problem

2003-01-15 Thread Alex Loubyansky
The datasources can't be accessed outside the VM JBoss is running in. alex Thursday, January 16, 2003, 2:22:26 AM, you wrote: PK> Hi there, PK> I'm unable to get a MySql datasource configured and know that it's probably a dumb configration PK> error on my part, but I've spent a day trying to f

RE: [JBoss-user] jboss 3.0.5 ejbql compiler problems?

2003-01-15 Thread Alex Loubyansky
I am sorry, looks like, forgot to port the fix into JBoss-3.0. This is currently fixed in CVS. Sorry, alex -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Alexey Yudichev Sent: Wednesday, January 15, 2003 10:32 AM To: [EMAIL PROTECTED] Subject: [JBoss-use

Re[2]: [JBoss-user] JBoss 3.2.0RC1 available

2003-01-15 Thread Alex Loubyansky
Wednesday, January 15, 2003, 12:24:14 PM, you wrote: JViR> I have a bean A with multiple primari key (id, language) JViR> I have another bean B who has cf_id JViR> Can I now make a relationship from B to A using cf_id??? Yes, if cf_id is a primary key column in B. alex JViR> I've seen some JVi

Re[2]: [JBoss-user] JBoss 3.0.4: 1-N CMP relation - how to modify?

2003-01-14 Thread Alex Loubyansky
This is fixed in CVS in JBoss-3.0, JBoss-3.2 and HEAD. Thanks, alex Tuesday, January 14, 2003, 1:52:18 PM, you wrote: PH> On Mon, Jan 13, 2003 at 03:30:55PM +0200, Alex Loubyansky wrote: PH> (About setting up relations in a 1-N relation on the N-side) >> both cases should wor

Re[2]: [JBoss-user] JBoss 3.0.4: 1-N CMP relation - how to modify?

2003-01-14 Thread Alex Loubyansky
f the same bug. Thank you, alex Tuesday, January 14, 2003, 1:52:18 PM, you wrote: PH> On Mon, Jan 13, 2003 at 03:30:55PM +0200, Alex Loubyansky wrote: PH> (About setting up relations in a 1-N relation on the N-side) >> both cases should work. Could you provide a testcase for the pr

Re[2]: [JBoss-user] CMP2 in JBoss3: accessing second level relations using ejb-ql

2003-01-13 Thread Alex Loubyansky
wrote: JC> Alex Loubyansky wrote: >>Hello Jim, >> >>I don't remember the right bean/field names but something like this, >>assuming you pass in organization's id >> >>SELECT OBJECT(gun) FROM Organization AS org, IN(org.gangsters) AS gang, >IN(ga

Re: [JBoss-user] JBoss 3.0.4: 1-N CMP relation - how to modify?

2003-01-13 Thread Alex Loubyansky
Hello Panu, both cases should work. Could you provide a testcase for the problem? I can't reproduce it. alex Monday, January 13, 2003, 2:50:06 PM, you wrote: PH> Hi all! PH> Can't you modify a N-1 CMP relation by assigning the 1-end PH> to the single value field on the N-end? At least it PH> s

Re: [JBoss-user] CMP2 in JBoss3: accessing second level relations using ejb-ql

2003-01-12 Thread Alex Loubyansky
Hello Jim, I don't remember the right bean/field names but something like this, assuming you pass in organization's id SELECT OBJECT(gun) FROM Organization AS org, IN(org.gangsters) AS gang, IN(gang.guns) AS gun WHERE org.id=?1 As the result you'll get all guns used in the organization. alex

Re: [JBoss-user] rudimentary cmr question

2003-01-11 Thread Alex Loubyansky
Hello John, only entity beans in the same package can have relationships. alex Saturday, January 11, 2003, 10:52:49 AM, you wrote: JF> Hi, JF> Is it possible to define a cmr field that references a bean in another JF> java package? How about in another jar? JF> What are the basic rules for pa

Re[2]: [JBoss-user] maybe just dreaming - Entity Bean change reflect

2003-01-10 Thread Alex Loubyansky
SL> - if you redeploy your bean and use the create-table feature of CMP, JBoss SL> will re-create the table (but not update it => you loose your data). No, JBoss won't recreate the table if remove-table wasn't set to true. The table will remain the same. Thus, if entity's structure/definition cha

Re[2]: [JBoss-user] CMP on 3.0.4 with BLOB fields - has anyone seen it working?

2003-01-10 Thread Alex Loubyansky
Randahl, do not, please, post it to the development list. The testsuit deals with byte[] instead of java.lang.Object, though. But, nevertheless, try different mappings first. Try also BLOB instead of JAVA_OBJECT. alex Friday, January 10, 2003, 1:18:46 PM, you wrote: RFI> That sure is a construc

Re: [JBoss-user] CMP on 3.0.4 with BLOB fields - has anyone seen it working?

2003-01-10 Thread Alex Loubyansky
Hello Randahl, there are BLOB tests in the testsuit that pass successfully. So, I think your problem is a mapping. Have you tried different mapping? alex Friday, January 10, 2003, 11:34:19 AM, you wrote: RFI> I am wondering if anyone has got an EJB working on 3.0.4 with a property RFI> which is

Re[2]: [JBoss-user] cmp composite field problems

2003-01-08 Thread Alex Loubyansky
sing xdoclet-1.2-b2. also, reading SR> through the pay docs, they show an example (listing 3-7) that does not use SR> the . instead, they only override the column name SR> within the . SR> is it required to have the element? can it be SR> generated from xdoclet? SR> Ryan S

Re: [JBoss-user] cmp composite field problems

2003-01-07 Thread Alex Loubyansky
audit_process_code SR> SR> SR> audit.dateCreated SR> audit_insert_dtm SR> SR> SR>

Re[2]: [JBoss-user] FK fields mapped to PK fields support ported to JBoss-3.2

2003-01-07 Thread Alex Loubyansky
Original Message- >> From: [EMAIL PROTECTED] >> [mailto:[EMAIL PROTECTED]]On Behalf Of Alex >> Loubyansky >> Sent: 24. desember 2002 20:28 >> To: JBoss-User >> Subject: [JBoss-user] FK fields mapped to PK fields support ported to >> JBoss-3.2 >> >

Re[2]: [JBoss-user] Optimistic locking ported to JBoss-3.2

2003-01-06 Thread Alex Loubyansky
Hello Muntean, Monday, January 06, 2003, 4:43:25 PM, you wrote: MH> Does it make any sense using commit-option A with "Instance Per MH> Transaction" container (a.k.a optimistic lock policy)? A small note: Instance Per Transaction doesn't mean an optimistic locking policy will be used. The default

Re: [JBoss-user] CMP2 - Field To Persist In Updates But Not Inserts

2003-01-06 Thread Alex Loubyansky
Hello Nicholas, could you be more specific? do you mean the field should be updated by the db? alex Monday, January 06, 2003, 2:18:50 PM, you wrote: N> How can I define a CMP2 field to only persist in N> UPDATEs and not the initial INSERT ? N> Thanks. N> //Nicholas N> = N> Nicholas White

Re: [JBoss-user] Problem Insert Data To Database

2003-01-06 Thread Alex Loubyansky
Hello Phuwarin, 'GROUP' is a reserved word. You shouldn't use it for column/table names. alex Monday, January 06, 2003, 12:40:27 PM, you wrote: PSsc> I'm encounter problem with unable to insert data to database with this PSsc> error message. PSsc> 17:15:42,373 ERROR [Test1EJB] Could not creat

Re[2]: [JBoss-user] Re: Using CMR with PK-Field as FK

2003-01-02 Thread Alex Loubyansky
Hello Jonathan, Tuesday, December 31, 2002, 4:01:53 PM, you wrote: JOCxd> Alex, JOCxd> Let me repeat what I think happens during entity bean creation: JOCxd> In ejbCreate we set all primary key fields. JOCxd> In ejbPostCreate we can set up any CMR fields. Yes JOCxd> Any CMR fields set in ejbCrea

[JBoss-user] Re: Using CMR with PK-Field as FK

2002-12-31 Thread Alex Loubyansky
Hello Frank, see my answer below. Tuesday, December 31, 2002, 2:06:52 PM, you wrote: LF> I have two beans Feature and FeatureOption with CMR. LF> JBoss-HEAD created the tables correct, using the new feature to have the LF> same field as FK to parent and part of PK: LF> create table feature

Re[4]: [JBoss-user] Question about CMP/CMR

2002-12-30 Thread Alex Loubyansky
Monday, December 30, 2002, 3:50:11 PM, you wrote: PK> Are there any plans to support it? Yes. alex PK> It would solve many problems (especially performance and lock problems PK> in my application) PK> -Original Message- PK> From: Alex Loubyansky [mailto:[EMAIL PROTEC

Re[2]: [JBoss-user] Question about CMP/CMR

2002-12-30 Thread Alex Loubyansky
mary key, like in LF> Bean3 (febdr), the foreign key field must not be CMP-Field in the bean. LF> It's automatically added because of CMR. LF> As said, I would like jboss to recognize that the field already exists LF> also in case of Bean3 and use this field for CMR. LF> Fr

Re: [JBoss-user] Question about CMP/CMR

2002-12-29 Thread Alex Loubyansky
ment. LF> The field festa_serial is mentioned twice here. LF> I would like JBoss to recognize that the CMR-Field is already there as a LF> CMP-Field in both cases. LF> So my question: Is this a Bug, a FeatureRequest or a must be which will LF> not be changed ? -- Best regards, Al

Re[5]: [JBoss-user] Optimistic locking ported to JBoss-3.2

2002-12-26 Thread Alex Loubyansky
Thursday, December 26, 2002, 10:34:54 PM, you wrote: DH> Using the Version Strategy as an example, if you have one app DH> server talking to one database (equiv to commit-option B), will DH> this make mostly-read transactions better or not make that much of a DH> difference? Actually, this is what

Re[6]: [JBoss-user] Optimistic locking ported to JBoss-3.2

2002-12-26 Thread Alex Loubyansky
DJ> Just to make sure I understand: I think this relies on the database DJ> transaction isolation level to be read committed or weaker? Yes, currently, to be consistent, the tx level should be read committed. I am thinking about the case of read uncommitted. Suppose, one tx modified entity. Ano

Re[4]: [JBoss-user] Optimistic locking ported to JBoss-3.2

2002-12-26 Thread Alex Loubyansky
DJ> I don't understand how this works yet. I'd really appreciate a detailed DJ> explanation of what happens when 2 threads/transactions simultaneously DJ> access one entity. I'd like to know what state the jboss "entity values" DJ> are in and what state the database is in at all points of such an

  1   2   3   4   5   >