Antwort: RE: OJB on WAS 5.1
Hi Max, what DB are you using? Do you use the connection pooling from the WAS datasource and JTA from Websphere? Lasse ___ Lasse Lambrecht Allianz Lebensversicherungs-AG IS-LF1 K6, Produktdatenbank +49 711 663 5412 # 1021-5412 Vesely, Max [IT] [EMAIL PROTECTED] Vesely, Max [IT] [EMAIL PROTECTED] 01/03/05 16:21 Bitte antworten an OJB Users List ojb-user@db.apache.org An OJB Users List ojb-user@db.apache.org Kopie Thema RE: OJB on WAS 5.1 Lasse, I've been using OJB with Websphere 5.1 for quite some time now. It seems to be working fine. Max. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Tuesday, March 01, 2005 4:46 AM To: OJB Users List Subject: OJB on WAS 5.1 Hi, is anybody using OJB together with WAS 5.1 yet? We're moving our application from WAS 4 to 5.1right now and I found the posting below in the OJB mail archive. But it seems not to be implemented and I was wondering whether it's working anyway. Regards Lasse --- RE: WebSphere Transaction Manager Matthias Roth Sun, 24 Aug 2003 21:34:01 + Hi, The problem is: In WAS5 the class JTSXA has been moved to another package (not com.ibm.EJCS.jts.jta but com.ibm.EJS.jts.jta) and its method getTransactionManager is renamed to instance. So the WebSphereTransactionManagerFactory should be changed! regard Matthias Roth -Original Message- From: Gary [mailto:[EMAIL PROTECTED] Sent: Freitag, 22. August 2003 20:27 To: OJB Users List Subject: WebSphere Transaction Manager I need to access the transaction services of WebSphere v5.0. I see that the WebSphereTransactionManagerFactory tries to instantiate com.ibm.ejcs.jts.jta.JTSXA. I do not see where this class lives in WebSphere. Has anyone successfully accessed v5.0 JTA support via OJB? Thanks, Gary ___ Lasse Lambrecht Allianz Lebensversicherungs-AG IS-LF1 K6, Produktdatenbank +49 711 663 5412 # 1021-5412 - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
RE: Antwort: RE: OJB on WAS 5.1
Lasse, I'm using OJB with MS SQL Server and DB2. I'm using WAS defined data sources for OJB queries. I don't use JTA directly. All of my OJB queries run behind session facades that use declarative transaction management. Max. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Wednesday, March 02, 2005 4:10 AM To: OJB Users List Subject: Antwort: RE: OJB on WAS 5.1 Hi Max, what DB are you using? Do you use the connection pooling from the WAS datasource and JTA from Websphere? Lasse ___ Lasse Lambrecht Allianz Lebensversicherungs-AG IS-LF1 K6, Produktdatenbank +49 711 663 5412 # 1021-5412 Inactive hide details for Vesely, Max [IT] ' src=cid:[EMAIL PROTECTED] width=16Vesely, Max [IT] [EMAIL PROTECTED] Vesely, Max [IT] [EMAIL PROTECTED] 01/03/05 16:21 Bitte antworten an OJB Users List ojb-user@db.apache.org An OJB Users List ojb-user@db.apache.org Kopie Thema RE: OJB on WAS 5.1 Lasse, I've been using OJB with Websphere 5.1 for quite some time now. It seems to be working fine. Max. -Original Message- From: [EMAIL PROTECTED] [ mailto:[EMAIL PROTECTED] Sent: Tuesday, March 01, 2005 4:46 AM To: OJB Users List Subject: OJB on WAS 5.1 Hi, is anybody using OJB together with WAS 5.1 yet? We're moving our application from WAS 4 to 5.1right now and I found the posting below in the OJB mail archive. But it seems not to be implemented and I was wondering whether it's working anyway. Regards Lasse --- RE: WebSphere Transaction Manager Matthias Roth Sun, 24 Aug 2003 21:34:01 + Hi, The problem is: In WAS5 the class JTSXA has been moved to another package (not com.ibm.EJCS.jts.jta but com.ibm.EJS.jts.jta) and its method getTransactionManager is renamed to instance. So the WebSphereTransactionManagerFactory should be changed! regard Matthias Roth -Original Message- From: Gary [mailto:[EMAIL PROTECTED] Sent: Freitag, 22. August 2003 20:27 To: OJB Users List Subject: WebSphere Transaction Manager I need to access the transaction services of WebSphere v5.0. I see that the WebSphereTransactionManagerFactory tries to instantiate com.ibm.ejcs.jts.jta.JTSXA. I do not see where this class lives in WebSphere. Has anyone successfully accessed v5.0 JTA support via OJB? Thanks, Gary ___ Lasse Lambrecht Allianz Lebensversicherungs-AG IS-LF1 K6, Produktdatenbank +49 711 663 5412 # 1021-5412 - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Oracle9i Blob Field Access
I am having some strange issues with retrieving a blob field. I am using an Oracle9i DB with the oci8(not thin) JDBC driver. I am also at OJB 1.0.1. There are two parts to this problem. 1) When I go to access my object containing a blob field using getObjectByIdentity(), it fails the first time, but succeeds on subsequent calls. If I restart the server - again it fails the first time - and success afterwards. 2) When I go to search for any of these objects containing this blob field, it fails every time. The failure exception is as follows: org.apache.ojb.broker.PersistenceBrokerSQLException: java.sql.SQLException: ORA-00932: inconsistent datatypes: expected - got BLOB at java.lang.Throwable.init(Throwable.java) at org.apache.commons.lang.exception.NestableRuntimeException.init(NestableRuntimeException.java:111) at org.apache.ojb.broker.OJBRuntimeException.init(OJBRuntimeException.java:40) at org.apache.ojb.broker.PersistenceBrokerException.init(PersistenceBrokerException.java:69) at org.apache.ojb.broker.PersistenceBrokerSQLException.init(PersistenceBrokerSQLException.java:37) at org.apache.ojb.broker.accesslayer.JdbcAccessImpl.executeQuery(JdbcAccessImpl.java:318) at org.apache.ojb.broker.accesslayer.RsQueryObject.performQuery(RsQueryObject.java:74) at org.apache.ojb.broker.accesslayer.RsIterator.init(RsIterator.java:183) at org.apache.ojb.broker.core.RsIteratorFactoryImpl.createRsIterator(RsIteratorFactoryImpl.java:58) at org.apache.ojb.broker.core.PersistenceBrokerImpl.getRsIteratorFromQuery(PersistenceBrokerImpl.java:1808) at org.apache.ojb.broker.core.PersistenceBrokerImpl.getIteratorFromQuery(PersistenceBrokerImpl.java:1333) at org.apache.ojb.broker.core.PersistenceBrokerImpl.getIteratorByQuery(PersistenceBrokerImpl.java:1320) at org.apache.ojb.broker.core.DelegatingPersistenceBroker.getIteratorByQuery(DelegatingPersistenceBroker.java:322) at org.apache.ojb.broker.core.DelegatingPersistenceBroker.getIteratorByQuery(DelegatingPersistenceBroker.java:322) Repository field descriptor: field-descriptor name=exportFile column=EXP_FILE jdbc-type=BLOB / Class definition: protected byte[] exportFile; I have changed this blob field to a CLOB field and it was successfully storing and retrieving up to 10 Meg of data...but alas I cannot use CLOB as the data I am wishing to store is binary information! If someone could point me in the right direction, I would be immensely grateful! Thanks much, Paul - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Mapping question
Hi, I have an object User who has 2 addresses, one for home and one for work. User is mapped to a table user (no problem here). Both home and work address are mapped to a table address. This table has a composite primary key: login and type - login from table user as a foreign key - type is a string (or enum) home and work I have tried the following without success: in User description: reference-descriptor name=homeAddress class-ref=Address auto-update=true auto-delete=true attribute attribute-name=type attribute-value=home/ foreignkey field-ref=login / /reference-descriptor and in Address description: field-descriptor name=login column=login primarykey=true / field-descriptor name=type column=type primarykey=true / Is it possible to make it run anyhow? Regards, Georg - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]