Re: [JBoss-user] Problem with ORACLE and JBOSS 3.2.3

2004-03-18 Thread Stephen Coy
I suspect that you do not have your Oracle installation set up properly. Did you try the same query using sqlplus? Steve Coy PS. Are you a Peruvian? I married one a few years ago... On 18/03/2004, at 2:54 PM, JAIME GOMEZ wrote: Hi people I have an application run inside of JBoss 3.2.3 , I

Re: [JBoss-user] JBoss On HPUX

2003-12-14 Thread Stephen Coy
Also, make sure that you pass: -XdoCloseWithReadPending when running any java application that uses sockets (such as JBoss or Tomcat) under HPUX, otherwise you will get weird hangs. Steve Coy On 13/12/2003, at 1:45 PM, Sasidharan, Manoj wrote: Hello All, JDK 1.3.1 We are trying to use

Re: [JBoss-user] passivation problem (statefull session bean)

2003-09-04 Thread Stephen Coy
G'Day, I think you may have fallen for one of the standard newbie problems with statefull session beans. Once an javax.ejb.EJBException has propogated through a SFSB, the container will *remove* that EJB and it can no longer be used - it is effectively dead. This behaviour is mandated by

Re: [JBoss-user] Change Log Level at Runtime?

2003-08-22 Thread Stephen Coy
We normally just edit the conf/log4j.xml file and hit the reconfigure button that you can see in the logging service display of the jmx-console. Steve Coy On Thursday, August 21, 2003, at 06:47 AM, Peter Luttrell wrote: Is there any way to change the log level for the server.log at runtime?

Re: [JBoss-user] Little question about transaction attributes

2003-08-14 Thread Stephen Coy
Hi David, You can do this, but you must invoke the method through a local reference to the bean obtained from the session/entity context that is passed to you in setSession/EntityContext of the EJB. See javax.ejb.SessionContext.getEJBLocalObject and javax.ejb.EntityContext.getEJBLocalObject.

Re: [JBoss-user] JBoss Error in generated SQL for finder (Sybase restriction)

2003-08-14 Thread Stephen Coy
You need the @jboss.relation-table (0..1) tag associated with the other account-person CMR tags. Sybase is not alone with this restriction - Oracle has it as well - 32 character identifiers. Steve Coy On Thursday, August 7, 2003, at 09:39 PM, Jonathan.O'[EMAIL PROTECTED] wrote: Well,

Re: [JBoss-user] CMP support for blobs broken using Sybase

2003-08-06 Thread Stephen Coy
Hi, The current JBoss implementation does the following mapping for JDBC access: Types.CLOB, LONGVARCHAR:use set/getCharacterStream Types.BLOB, LONGVARBINARY use set/getBinaryStream Types.BINARY, VARBINARY use set/getBytes So, you could try setting the JDBC type to

Re: [JBoss-user] CMP Mapping for user defined types

2003-07-29 Thread Stephen Coy
I'm not sure if it's possible either, but a good place to start might be to have a look at the java.sql.SQLData interfaces. Steve Coy On Tuesday, July 29, 2003, at 04:58 PM, Brian Wallis wrote: This may be just an ignorant CMP question, but... Can I define a mapping (in the jaws

Re: [JBoss-user] entityContext.getEJBLocalObject() returns local interface of another object

2003-07-14 Thread Stephen Coy
Hi, I'm looking into this myself. Are you using read-only methods by any chance? Steve Coy On Monday, July 14, 2003, at 09:11 PM, Alexey Yudichev wrote: Got 5 hits this weekend. Other fields always correspond to the context with the expected primary key. i.e.

Re: [JBoss-user] WARN: Failed to passivate - RC5

2003-04-15 Thread Stephen Coy
Just off the top of my head, I would guess that you have a org.apache.log4j.Logger instance variable in your bean, which is not serializable. Make it either static or transient. Steve Coy On Tuesday, April 15, 2003, at 07:30 PM, Marco Tedone wrote: Hi, I'm running Jboss 3.2.0RC5. I

Re: [JBoss-user] res-url and external resources.

2003-04-04 Thread Stephen Coy
We use ant to unpack the ear, perform token substitution as needed (driven by a properties file) and reassemble. Steve Coy On Friday, April 4, 2003, at 08:03 PM, Phil Cornelius wrote: I have externalized my resources by using jndi lookups, I have defined resource references in the

Re: [JBoss-user] CMR Error under load

2003-04-04 Thread Stephen Coy
and are you working on a solution? -dain On Thursday, April 3, 2003, at 04:22 AM, Stephen Coy wrote: I'll add the testcase to Branch_3_0 as well. We've never experienced this problem, but have only operated under 3.0.2, 3.0.4 and 3.0.6. Our application (over)uses lots of CMR and we use those read-only

Re: [JBoss-user] CMR Error under load

2003-04-03 Thread Stephen Coy
May wrote: My test case fails on 3.0.3 so it's not just a problem with 3.2.0. So for us that means we can't go live with either :( - unless we can find a suitable workaround. Andrew Stephen Coy wrote: At the moment, we have a regression failure from 3.0.x to 3.2.0, because it works fine

Re: [JBoss-user] CMR Error under load

2003-04-02 Thread Stephen Coy
[ jboss-Bugs-705542 ] Errorenous IllegalStateException on CMR-Collection Steve Coy On Wednesday, April 2, 2003, at 07:35 PM, Andrew May wrote: Earlier in the thread Alex wrote that I'm not alone in complaining about this. Is there an existing bug report for this problem that I should add the

Re: [JBoss-user] CMR Error under load

2003-04-02 Thread Stephen Coy
I'm currently incorporating the essence of your test case into the formal JBoss 3.2 test suite. With luck, I'll get it in this evening. And you're right btw, there's nothing wrong with your test case spec wise. Steve Coy On Wednesday, April 2, 2003, at 07:35 PM, Andrew May wrote: OK, from

Re: [JBoss-user] CMR Error under load

2003-04-02 Thread Stephen Coy
This is outside the CMP spec, so legality does not enter into it. What is more interesting is what read-only means in the context of a CMR getter that returns a Collection. My test program happily lets me update the returned collection even when the getter is marked read-only. Steve Coy On

Re: [JBoss-user] CMR Error under load

2003-04-02 Thread Stephen Coy
it in anyway. Steve Coy On Wednesday, April 2, 2003, at 08:25 PM, Stephen Coy wrote: I'm currently incorporating the essence of your test case into the formal JBoss 3.2 test suite. With luck, I'll get it in this evening. And you're right btw, there's nothing wrong with your test case spec wise

Re: [JBoss-user] CMR Error under load

2003-04-02 Thread Stephen Coy
Ah ha! It needs those read-only tags in jboss.xml in order to fail. Previously, I had explicitly specified that getChildren was read-only. It needs to be get*. My test is failing now. Steve Coy On Thursday, April 3, 2003, at 01:30 AM, Andrew May wrote: I've tried to do a bit of

Re: [JBoss-user] Where has my memory gone?

2003-03-28 Thread Stephen Coy
Are you using the OCI driver? We're experiencing similar problems at our production site, but can't reproduce it in testing. Our hardware is running HP-UX and the HP JVM. The current theory is that the version of the OCI client software we have on site is leaking memory in native code. Steve

Re: [JBoss-user] Hooking mysql to latest Jboss/Tomcat Distro? FAQ's?

2003-03-06 Thread Stephen Coy
Did you look here: http://prdownloads.sourceforge.net/jboss/QuickStart-30x.pdf ? Other documentation info is available at http://www.jboss.org/docs/ Steve Coy On Friday, March 7, 2003, at 06:09 AM, Mike wrote: Hello gang Can someone point me to the FAQ's? Im trying to find out the

Re: [JBoss-user] Deadlocks

2003-03-02 Thread Stephen Coy
G'Day Hunter, I think 3.0.4 shipped with some problems in its deadlock detection. Our application (which uses lots of CMR - the root of most deadlock issues) was running more reliably in this regard under 3.0.2+ than 3.0.4. These issues appear to have cleared up in our test environment, so we

[JBoss-user] Deploy to Oracle JVM

2003-02-23 Thread Stephen Coy
Hi, It occurred to me recently that it might be possible to deploy JBoss within the JVM that is built into Oracle 9i databases these days. Has anyone tried this? I see this as possibly significantly reducing one of the big J2EE data serialisation bottlenecks. What do you think? Note that I

Re: [JBoss-user] JMS persistence manager for Oracle8

2003-02-16 Thread Stephen Coy
On Sunday, February 16, 2003, at 06:51 PM, Rod Macpherson wrote: I believe the direct support is through Oracle specific API's. FALSE. The JDBC API works fine with the underlying driver which is obviously oracle-specific. There is no problem using LOBs except when using jboss. The same

Re: [JBoss-user] JMS persistence manager for Oracle8

2003-02-16 Thread Stephen Coy
On Monday, February 17, 2003, at 12:47 PM, Rod Macpherson wrote: The standard JDBC result set returns the blob without any vendor-specific magic aside from using the correct driver. The actual column type is an oracle blob and we use that to update the column by writing a stream supplied by

Re: [JBoss-user] JMS persistence manager for Oracle8

2003-02-16 Thread Stephen Coy
On Monday, February 17, 2003, at 02:51 PM, Rod Macpherson wrote: I still hold there is no 4K limit using JDBC calls. I have tested this in the past using straight java(x).sql.* calls and was unable to get it to work unless the oci driver was used. I suspect that weblogic is using the Oracle

Re: [JBoss-user] JMS persistence manager for Oracle8

2003-02-15 Thread Stephen Coy
Is this JBoss 2.4? Anyway, it smells like a problem with your JDBC driver - get the latest Oracle 9.2 JDBC drivers, even if you're backend is Oracle 8. For more information, see the Oracle BLOB FAQ in the JBoss FAQ forum. Steve Coy On Saturday, February 15, 2003, at 10:20 PM, Marek Lange

Re: [JBoss-user] JMS persistence manager for Oracle8

2003-02-15 Thread Stephen Coy
On Sunday, February 16, 2003, at 05:14 AM, Marek Lange wrote: It's a 9i thin driver. From the Oracle JDBC Drivers release 9.2.0 README: Direct support for LOBs in the Thin driver. The Thin driver now provides direct support for BFILEs, BLOBs, and CLOBs. But you have to read between the

Re: [JBoss-user] JMS persistence manager for Oracle8

2003-02-15 Thread Stephen Coy
Sorry, I really should not respond to questions at 2:00AM! If you have just hacked, er, modified the standard jbossmq-service.xml file, then the CREATE_MESSAGE_TABLE string will be wrong for Oracle, and this will yield the invalid column type exception that you are seeing below. There's an

Re: [JBoss-user] rudimentary cmr question

2003-01-11 Thread Stephen Coy
Just to clarify (because the word package is a bit overloaded): only entity beans declared in the same ejb-jar.xml deployment descriptor can have relationships. The entity beans can be in different packages (in the java language sense, which I think the OP was referring to), and even in

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

2003-01-10 Thread Stephen Coy
Randahl, I guess I'm the "blob" guy at the moment. I went back and looked at your earlier emails. The problem is that you are using a jdbc-type of JAVA_OBJECT. This is an incorrect use of JAVA_OBJECT. Change it to LONGVARBINARY and it should work fine. We really need to go through the current

[JBoss-user] How to use Oracle BLOB/CLOBs with JBoss

2003-01-06 Thread Stephen Coy
This question seems to keep cropping up from time to time. Maybe Dain can add the following information as an addendum or something to the CMP doco. This information applies to JBoss 3.0.4 and newer. Before attempting to store LOBs in Oracle, I've found it's useful to know a few things: 1.

Re: [JBoss-user] How to use Oracle BLOB/CLOBs with JBoss

2003-01-06 Thread Stephen Coy
Sorry, I can see that this paragraph is ambiguous at best. Try this: For large binary columns: i) raw byte arrays are applied directly to the database using PreparedStatement.setBinaryStream; ii) Other java types are first serialised into a byte array using a java.rmi.MarshalledObject

Re: [JBoss-user] OutOfMemoryError: unable to create new native thread

2002-12-23 Thread Stephen Coy
We had similar issues using the Oracle OCI drivers under HP-UX 11 and jdk 1.3.1.xx. Luckily, Oracle appears to have fixed it in their 9.2.0.2 driver release. Steve Coy On Tuesday, December 24, 2002, at 08:56 AM, Schnitzer, Jeff wrote: Are you using Oracle? We had the same problem.

Re: [JBoss-user] Urgent! invalid assignment JBoss 3..0.3 and Soli d with date/time/ datetime

2002-12-15 Thread Stephen Coy
number), as I'm not sure whether we can change to 3.0.4. Thanks in advance. Raymond -Original Message- From: Stephen Coy [mailto:[EMAIL PROTECTED]] Sent: Friday, December 13, 2002 01:05 To: [EMAIL PROTECTED] Subject: Re: [JBoss-user] Urgent! invalid assignment JBoss 3..0.3 and Solid

Re: [JBoss-user] Urgent! invalid assignment JBoss 3..0.3 and Solid with date/time/ datetime

2002-12-12 Thread Stephen Coy
Please try JBoss 3.0.4. This stuff got a major overhaul. Unfortunately, I was only able to test it with Oracle 9, Postresql, mySQL and Hypersonic, so please do not hesitate to get back to the list with the results. We may need to adjust the mappings in standardjbosscmp-jdbc.xml. Regards,

Re: [JBoss-user] EJB Commit Option A Cache Question

2002-12-11 Thread Stephen Coy
On Wednesday, December 11, 2002, at 08:30 PM, Sacha Labourey wrote: I think it's normal for JBoss to continue to issue queries for the pks, after which it uses the associated cache data. Why do you think that? The commit option A says that the cache is always in synch with the DB.

Re: AW: [JBoss-user] How to do simple Inheritance with EntityBeans

2002-12-11 Thread Stephen Coy
Hi, For some reason, the standard Cloudscape mapping is using a jdbc-type of LONGVARCHAR for java.lang.String data. JBoss now uses the set/getCharacterStream API's for LONGVARCHAR data, and it looks like Cloudscape does not support this. MySQL has a similar problem. Try changing the

Re: [JBoss-user] Using Apache web server - yes or no?

2002-12-10 Thread Stephen Coy
Hi, We're running straight JBoss 3.0x/Jetty in production, with squid running in web-accelerator mode in front of it. So, out static content is (mostly) delivered by the squid cache, and all dynamic requests passed through to Jetty. Steve Coy On Tuesday, December 10, 2002, at 11:10 PM, Victor

Re: [JBoss-user] EJB Commit Option A Cache Question

2002-12-09 Thread Stephen Coy
Hi, Are the queries that you are seeing just loading primary keys, or are there other columns present as well? I think it's normal for JBoss to continue to issue queries for the pks, after which it uses the associated cache data. If you are seeing other columns in the queries, then you may be

Re: [JBoss-user] parser error SOLVED = this is not funny

2002-12-08 Thread Stephen Coy
Is it possible that your deployment has a META-INF/jbosscmp-jdbc.xml file with this mapping defined in it? That "INTEGER(9)" has to be in a standardjbosscmp-jdbc.xml or a jbosscmp-jdbc.xml somewhere that JBoss can see it. Steve Coy On Monday, December 9, 2002, at 06:58 AM, SainTiss wrote:

Re: [JBoss-user] moving app from 3.0.3 to 3.0.4

2002-12-04 Thread Stephen Coy
Are you using a jdbc type of JAVA_OBJECT for any of your fields by any chance? Prior to 3.0.4, JBoss would serialise these types, when it's really the driver's domain to map them to custom database types, typically using java.sql.SQLData interfaces provided by you. If this is the case, changing

Re: [JBoss-user] CMR Performance: Weblogic7 Much Faster Then JBoss

2002-11-23 Thread Stephen Coy
This change is now in Branch_3_2. It looks a little like 3.2 has acquired some other baggage though - our benchmark for 2000 beans is a little slower than it was under 3.0.4: 23:06:47,044 INFO [STDOUT] creating 2000 Blobs... 23:07:30,811 INFO [STDOUT] Creation complete, took 43764ms.

Re: [JBoss-user] CMR Performance: Weblogic7 Much Faster Then JBoss

2002-11-22 Thread Stephen Coy
,     sacha -Message d'origine- De : [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]De la part de Stephen Coy Envoyé : jeudi, 21 novembre 2002 15:26 À : [EMAIL PROTECTED] Objet : Re: [JBoss-user] CMR Performance: Weblogic7 Much Faster Then JBoss I've made a first pass at fixing this. Some

Re: [JBoss-user] CMR Performance: Weblogic7 Much Faster Then JBoss

2002-11-22 Thread Stephen Coy
I'll try to get it done in the next day or so. On Friday, November 22, 2002, at 10:50 PM, Christian Riege wrote: hi stepehn et. al, As far as the Finders are concerned, I suspect that the issue may be in the ReadAheadCache code. yeah ReadAheadCache is currently the HotSpot. I think Dain

Re: [JBoss-user] CMR Performance: Weblogic7 Much Faster Then JBoss

2002-11-21 Thread Stephen Coy
I've made a first pass at fixing this. Some profiling revealed a case where "contains" was being called on an ArrayList containing every entity in the transaction. Currently, the fix is checked into Branch_3_0. I'll migrate it to HEAD and Branch_3_2 as soon as I find the time. In general, the

Re: [JBoss-user] Postgres users

2002-11-19 Thread Stephen Coy
On Wednesday, November 20, 2002, at 07:28 AM, LaBanca, Rick wrote: Jboss 3.0.4, fooling with the cmp flavor of jetty session persistence. I get this upon initializing: Unable to locate type name 'varbinary' in catalog I checked the mappings in the jboss cmp config, looks correct. It

Re: [JBoss-user] run JBoss 3.0.3 with MySQL

2002-11-14 Thread Stephen Coy
On Friday, November 15, 2002, at 04:47 AM, Fabiano Cruz ((Cilix Software)) wrote: What do i need to do to run JBoss 3.0.3 with MySQL ? To begin with, you need to read this http://prdownloads.sourceforge.net/jboss/JBoss.3.0QuickStart.Draft3.pdf>. Steve

Re: [JBoss-user] Feature not implemented: no details -- ??

2002-11-12 Thread Stephen Coy
On Wednesday, November 13, 2002, at 12:52 PM, John Snyder wrote: Feature not implemented I think this is coming from your JDBC driver. If my memory serves me correctly, it's a MySQL JDBC driver error. Are you trying to use CLOB's or LONGVARCHAR data mappings by any chance? JBoss 3.0.4 uses

Re: [JBoss-user] Entity Bean Performance Tuning Help

2002-11-05 Thread Stephen Coy
Hi, Have you tried your tests out on 3.0.4 yet? Some CMR performance optimisations made it into 3.0.4, because we desperately needed them for our own application. Steve Coy On Wednesday, November 6, 2002, at 06:37 AM, Luttrell, Peter wrote: Nope it's defiantly cached. The first time it

Re: [JBoss-user] JBoss 3.0.3 unit tests that store and retrieve Dates fail

2002-10-31 Thread Stephen Coy
The cmp2 unit tests have been worked over pretty well in 3.0.4. The initialisation of many of the test parameters for the java.sql.* date/times was faulty because they were not initialised properly. This was subsequently hidden in the unit tests because there were no date/time mappings for

Re: [JBoss-user] Problem with latest version of org.jboss.ejb.plugins.cmp.jdbc.JDB CUtil

2002-10-25 Thread Stephen Coy
Right. In fact, it is my belief that there should be *no* standard mappings that use the JAVA_OBJECT jdbc type. JAVA_OBJECT is intended to be mapped to custom types in the database in association with the SQLData/Input/Output interfaces. Steve Coy On Friday, October 25, 2002, at 06:44 PM,

Re: [JBoss-user] Please help me! Transaction problem

2002-10-24 Thread Stephen Coy
From where does EditStudentInfoAction get its session bean reference? Does it create a new one for each request, or does it create just one and try to re-use it for each request? The latter situation is guaranteed to cause the problem below. If that is not the cause, then show me your

Re: [JBoss-user] question about caching session beans in the web layer

2002-10-23 Thread Stephen Coy
On Thursday, October 24, 2002, at 05:16 AM, Emerson Cargnin - SICREDI Serviços wrote: I have some questions regarding to caching homes and session beans in the remote client : 1- I already cache initicalcontext and homes in businness delegate, is it secure to cache the real session object as

Re: [JBoss-user] Re: Questin with Mail Service-not solved yet and to dim

2002-10-08 Thread Stephen Coy
Hi again, Please let me reiterate: A typical smtp server will only allow you to use it to deliver mail to recipients within its domain, when the sender is sending from outside it's domain, as defined by the ip address of the sender (which you appear to be doing). Therefore, as you said, you

Re: [JBoss-user] A questin about Mail Service

2002-10-06 Thread Stephen Coy
This is an issue with the smtp server that you are using. You need to use the same smtp server that you would configure for an ordinary mail client like Outlook or Eudora. In effect, your program needs a mail account in the 163.com domain. This prevents spammers from hijacking someone's

Re: [JBoss-user] Using BLOB with oracle 8i thin driver...

2002-10-05 Thread Stephen Coy
Blobs will work properly in 3.0.4. I believe that ByteArrayBlob was an attempt to get around the Oracle issues. However, you will not be able to store data bigger than 4-5k with the Oracle thin drivers. It just does not work. I think you can use the Oracle LONG types to store more data with the

Re: [JBoss-user] Performance issue while adding to a EJB 2.0 relation - JBoss version: 3.0.2

2002-09-29 Thread Stephen Coy
I don't think you are missing anything. Please see [ jboss-Patches-608221 ] Unidirectional CMR performance patch. This patch works for us, but Dain says he has found a better way to fix it which is in Branch_3_2 as of Friday or thereabouts. No need to dig deeper, I've been down there

[JBoss-user] Datasource security problems migrating to JBoss 3.2

2002-09-27 Thread Stephen Coy
Hi, I just checked out Branch_3_2 today to check out our application on it. There seems to have been a raft of changes to the JCA stuff amongst other things. Anyway, independent of whether or not I use -service.xml or -ds.xml files to set up my datasources, I get the exceptions

Re: [JBoss-user] Stateful Session Bean problem (newbie?)

2002-09-27 Thread Stephen Coy
How do you know that you are getting the same instance of the SFSB on the second call? Is the second call on the same JSP and responding to the same HTTP request? If not, how are you caching the instance reference between requests? Half a second seems like a long time to be processing the

Re: [JBoss-user] RE: Io exception: Stream closed while using CLOB

2002-09-26 Thread Stephen Coy
Saroj, This simply does not work if you are using the Oracle thin JDBC drivers. There is no work around. You need to install Oracle client software on your JBoss machine and use the oci drivers. Previously, you mentioned that you are using Linux. If that is the case, then maybe you need

Re: [JBoss-user] NestedSQLException: Interrupted while requesting permit!

2002-08-16 Thread Stephen Coy
This is a known JBoss/Jetty bug that has been fixed in some CVS branches. I believe that it will be in 3.0.2 due around the 24th or so, from my reading of the jboss-dev list. Steve Coy On Friday, August 16, 2002, at 07:09 PM, Mathias Bogaert wrote: Hi, I'm running some unit tests on my

Re: [JBoss-user] 3.0.1 client InitialContext

2002-08-13 Thread Stephen Coy
We use the following to run standalone junit tests without problems: java.naming.factory.initial=org.jnp.interfaces.NamingContextFactory java.naming.factory.url.pkgs=org.jboss.naming:org.jnp.interfaces java.naming.provider.url=localhost I imagine you just need to change 'localhost' to

Re: [JBoss-user] (no subject)

2002-08-11 Thread Stephen Coy
I've seen this a few times using Oracle as well. It's only appeared in the last couple of weeks or so in Branch_3_0. On Sunday, August 11, 2002, at 07:16 AM, David Jencks wrote: I know about this problem but haven't figured out how to find out what is interrupting the thread trying to

Re: [JBoss-user] Dynamic QL error

2002-08-11 Thread Stephen Coy
You also need a corresponding query element in ejb-jar.xml, with an empty ejb-ql element. On Monday, August 12, 2002, at 02:06 PM, Danilo Luiz Rheinheimer wrote: Hello, I need to use DynamicQL on my application without success. I have the documentation of JBoss CMP 2.0 and I am

Re: [JBoss-user] JBossQL problem

2002-07-30 Thread Stephen Coy
, 2002 8:07 PM Subject: Re: [JBoss-user] JBossQL problem That is super lame. Just another reason Oracle sucks. Can one of you post a feature request for this and I'll add support for order-must-be-in-select for 4.0. -dain Stephen Coy wrote: I know exactly what is happening here. Some

Re: [JBoss-user] CLOB Support in JBOSS 3 with ORACLE 9i

2002-07-29 Thread Stephen Coy
We are using BLOBS with Oracle 9i and JBoss 3.0 with no trouble at all. The only caveat is that you *must* use the JDBC OCI driver. The regular JDBC Thin driver will fail once the LOB exceeds 4k-5k in size. More information can be found at:

Re: [JBoss-user] CLOB Support in JBOSS 3 with ORACLE 9i

2002-07-29 Thread Stephen Coy
On Tuesday, July 30, 2002, at 03:33 AM, Fábio Silva wrote: You can try the new Thin JDBC Oracle Drivers (9.0.2) that *they say* that solves these problems. I haven't tested them though. I have tested them and they do not work in a portable manner. ie. They *do* support LOBs, but only by

Re: [JBoss-user] JBossQL problem

2002-07-29 Thread Stephen Coy
I know exactly what is happening here. Some databases, Oracle for one, insist that columns in an ORDER BY clause also appear in the SELECT clause. JBossQL generates queries like: SELECT pk FROM MyEntity WHERE [predicate] ORDER BY someOtherColumn Oracle, for instance, insists upon: SELECT

Re: [JBoss-user] JBossQL problem

2002-07-29 Thread Stephen Coy
for 4.0. -dain Stephen Coy wrote: I know exactly what is happening here. Some databases, Oracle for one, insist that columns in an ORDER BY clause also appear in the SELECT clause. JBossQL generates queries like: SELECT pk FROM MyEntity WHERE [predicate] ORDER BY someOtherColumn Oracle

Re: [JBoss-user] Logging from within EJBs

2002-07-07 Thread Stephen Coy
He *is* using log4j. Your suggestion below is a deprecated interface. I suspect that he is not looking in the right place for the debug messages. Debug messages only appear in the log/server.log file, not on the console. This works for us btw. On Monday, July 8, 2002, at 11:34 AM, Guy

Re: [JBoss-user] CMR bug fixed?

2002-06-25 Thread Stephen Coy
I believe that what you are looking for is a topological sort. This what I used for a PERT charting program I developed many years ago, You will get a bazillion hits on Google if you're looking for details. On Wednesday, June 26, 2002, at 04:09 AM, Dain Sundstrom wrote: I could use some

Re: Re[2]: [JBoss-user] CMR bug fixed?

2002-06-22 Thread Stephen Coy
I'm not Dain, but i think I can help you. I don't recommend checking out the cvs HEAD version of JBoss unless you are interested in helping to debug it. The HEAD version is the current development tree for JBoss 3.1. Therefore, you probably want to check out the Branch_3_0 cvs branch. ie.

[JBoss-user] jaws_3_0.dtd

2002-06-15 Thread Stephen Coy
Hi, Is it reasonable to assume that this particular dtd is only required for the deployment of EJB 1.1 compatible beans in JBoss 3.0? Thanks ___ Don't miss the 2002 Sprint PCS Application Developer's Conference August 25-28 in Las

Re: [JBoss-user] CreateException from ejbPostCreate method?

2002-06-12 Thread Stephen Coy
CreateException is mandatory on ejbCreate and optional on ejbPostCreate: 10.6.4 ejbCreateMETHOD methods ... The throws clause must define the javax.ejb.CreateException. The throws clause may define arbitrary application specific exceptions. and 10.6.5 ejbPostCreateMETHOD methods ... The

Re: [JBoss-user] Multiple datasources and a single bean...

2002-06-06 Thread Stephen Coy
You need to do something like: Add the following to your ejb-jar.xml for both beans: session ... transaction-typeBean/transaction-type resource-ref res-ref-namejdbc/UsageDS /res-ref-name res-typejavax.sql.DataSource/res-type

Re: [JBoss-user] JBoss 3.0 RC3 MDB Question

2002-05-31 Thread Stephen Coy
I'm successfully using an MDB that contains the following in ejb-jar.xml: message-driven ... ejb-local-ref ejb-ref-nameejb/Agreement/ejb-ref-name ejb-ref-typeEntity/ejb-ref-type local-

Re: [JBoss-user] JBoss 3.0 RC3 MDB Question

2002-05-31 Thread Stephen Coy
The lines marked below have to match: On Friday, May 31, 2002, at 07:15 PM, Chris Chen wrote: Hi, Well, I got it to work one way, but not the other way.. Here's the error: 02:10:42,957 ERROR [XmlFileLoader] failed to load jboss.xml. There could be a syntax error.

Re: [JBoss-user] Security and Message Driven Beans

2002-05-30 Thread Stephen Coy
test setup for an example. Scott Stark Chief Technology Officer JBoss Group, LLC - Original Message - From: Stephen Coy [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, May 29, 2002 7:44 PM Subject: Re: [JBoss-user] Security

Re: [JBoss-user] Security and Message Driven Beans

2002-05-30 Thread Stephen Coy
Sorry, it's too early in the morning for me, Clearly RunAsMDB.onMessage() does get invoked. It's barfing while invoking home.findByPrimaryKey(arg). On Friday, May 31, 2002, at 10:31 AM, Stephen Coy wrote: This test (testMDBRunAs) does not work. Method RunAsMDB.onMessage() is never

[JBoss-user] Security and Message Driven Beans

2002-05-29 Thread Stephen Coy
Hi, I am using JBoss 3.0RC3. I've got a stateful session bean which is associated with a Principal that has been authenticated in our application's security domain. When I try to send a message to a queue based MDB, I get the following exception: 18:14:00,821 INFO [AgreementFacadeBean]

Re: [JBoss-user] Security and Message Driven Beans

2002-05-29 Thread Stephen Coy
container configuration in standardjboss.xml. The latter will be the default in the final 3.0 release. Scott Stark Chief Technology Officer JBoss Group, LLC - Original Message - From: Stephen Coy [EMAIL PROTECTED] To: jboss-user [EMAIL

[JBoss-user] ERROR [org.jboss.ejb.plugins.AbstractInstanceCache] Activation failure

2002-05-28 Thread Stephen Coy
Hi, When I run the test suite on reasonably recent CVS checkout of Branch_3_0 (builds an RC4) I see a few instances of stateful session bean activation failures like the log extract shown below. As far as I can tell, this bean was never passivated, yet for some reason JBoss is trying to

Re: [JBoss-user] Datasource Problems with RC3

2002-05-22 Thread Stephen Coy
Are you sure that it is RC3? I got this problem with CVS Branch_3_0_0, but it went away when I reverted to JBoss_3_0_0_RC3. Have raised bug report 559441 for it. On Thursday, May 23, 2002, at 11:03 AM, Hunter Hillegas wrote: I updated to RC3 and I got my datasources to deploy without any

Re: [JBoss-user] FW: [JBoss-dev] [ jboss-Bugs-559441 ] Local DB Connections broken

2002-05-22 Thread Stephen Coy
The relevant source file LocalManagedConnectionFactory.java has both David Jencks and Jason Dillon's footprints on it in the last couple of days. I guess we'll have to wait for one of them to respond. On Thursday, May 23, 2002, at 11:39 AM, Hunter Hillegas wrote: Is this bug legit? This

Re: [JBoss-user] SSL From Session Bean

2002-05-19 Thread Stephen Coy
One obvious question: Should ...protocal be ...protocol instead? On Saturday, May 18, 2002, at 09:36 AM, Jon Swinth wrote: System.setProperty(java.protocal.handler.pkgs,com.sun.net.ssl.internal. www.protocal); ___ Hundreds of

Re: [JBoss-user] Fwd: Bug when converting EJB QL boolean comparisons from true and false to 1 and 0

2002-05-13 Thread Stephen Coy
, t0_bean.an_Int, t0_bean.a_Long, t0_bean.a_Double, t0_bean.a_String FROM CMP2ENTITY t0_bean WHERE t0_bean.a_Boolean = true So what is wrong with that where clause? Are there any Oracle DBAs out there that can shed some light on to why this query is rejected. -dain Stephen Coy wrote: Reposted

Re: [JBoss-user] Fwd: Bug when converting EJB QL boolean comparisons from true and false to 1 and 0

2002-05-13 Thread Stephen Coy
Sorry Dain, I was trying to point out that not all SQL implementations support the use of literal true and false values. Therefore, we need to get them mapped to 1 and 0 respectively in this situation. On Tuesday, May 14, 2002, at 02:53 PM, Dain Sundstrom wrote: This is like pulling

Re: [JBoss-user] Stupid User? JCA Problem with Oracle Database (JBoss V3.0RC1)

2002-04-15 Thread Stephen Coy
You need to set up a security policy in conf/login-config.xml: application-policy name = HRXDBRealm authentication login-module code = org.jboss.resource.security.ConfiguredIdentityLoginModule flag = required module-option name =

Re: [JBoss-user] Multiple JBOSS 3.0 developers and clustering

2002-02-28 Thread Stephen Coy
than a few seconds, longer than I was prepared to wait, which was a few minutes. At this time, all other deployments and shutdown are blocked. Two of our machines were running the posted beta, and one is running a build from cvs HEAD, as of earlier today. Regards, Stephen Coy

[JBoss-user] Multiple JBOSS 3.0 developers and clustering

2002-02-27 Thread Stephen Coy
Hi, We have found that if you have multiple developers on the same network trying to run the 3.0 beta or later at the same time, the default configuration causes them to try and cluster with each other (I think). Anyway, removing the cluster-service.xml file from the deploy directory