Singelton question.
Hello all, how do you propose to work with OJB? I am using ODMG api. I have some persistent broker manager. In constructor of this object I get odmg facade instance - odmgFacade = OJB.getInstance(); in each DB related methods I open db db.open(dataBaseDefName, Database.OPEN_READ_WRITE); open and commit transaction. ? I am not sure, should I close db if I use manageable connection pool and work with db via Datasource. Should broker manager to be singleton? or I have to create new instance of this classes for each client? (I don't tell about clustering, I mean that I use only one JavaVM) thank you very much. -- Best regards, Alexander mailto:[EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
RE : Insert Sqlown Queries
Some more information : I have used : QueryBySQL But there a prepare statement also. I would like to send a request without a prepare statement. Is it possible ? -Message d'origine- De : Emmanuel Dupont [mailto:[EMAIL PROTECTED] Envoyé : lundi 23 juin 2003 11:34 À : OJB Users List Objet : Insert Sqlown Queries All, Is it possible to create my own SQL Insert and Update SQL queries. I want to do that because I have some trouble with Clob type with Db2 and some MSSQLServer drivers. So I would like to be able to execute an insert, update query without any Prepare-statement. Is it possible ??? Thank you. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
illegal multi-threaded access detected
Hi, We are working on a web application which is built on OJB0.9.5. Particularly we are using ODMG for transaction maintainance and PB API for database operations. When we are performing load test on our application we are getting this error. Has anyone faced this problem earlier or anyone has any idea about this? [6/20/03 12:33:26:326 CDT] 1a0495 Proxy D close: illegal multi-threaded access detected [Ljava.lang.Object;@6321f2 [6/20/03 12:33:26:326 CDT] 1a0495 Proxy D Mark proxy closed [6/20/03 12:33:26:326 CDT] 1a0495 Proxy close [6/20/03 12:33:26:327 CDT] 1a0495 CachedStateme close [6/20/03 12:33:26:327 CDT] 1a0495 CachedStateme close [6/20/03 12:33:26:327 CDT] 1a0495 StatementProx close [6/20/03 12:33:26:327 CDT] 1a0495 ConnectO translateException [6/20/03 12:33:26:327 CDT] 1a0495 PortabilityLa translateException Error Code = 0 SQL State = null com.ibm.ejs.cm.exception.IllegalConnectionUseException: Error: Connection is being used in a way th at violates the architecture at com.ibm.ejs.cm.proxy.Proxy.close(Proxy.java:197) at com.ibm.ejs.cm.proxy.StatementProxy.close(StatementProxy.java:92) at com.ibm.ejs.cm.proxy.Proxy.close(Proxy.java:104) at com.ibm.ejs.cm.proxy.ConnectionProxy.close(ConnectionProxy.java:807) at com.ibm.ejs.cm.proxy.ConnectionProxy.connectionDestroyed(ConnectionProxy.java:103) at com.ibm.ejs.cm.pool.ConnectO.fireConnectionDestroyed(ConnectO.java:2678) at com.ibm.ejs.cm.pool.ConnectO.destroy(ConnectO.java:1507) at com.ibm.ejs.cm.pool.ConnectionPool.destroyConnection(ConnectionPool.java:1124) at com.ibm.ejs.cm.pool.ConnectO.translateException(ConnectO.java:2024) at com.ibm.ejs.cm.proxy.Proxy.translateException(Proxy.java:355) at com.ibm.ejs.cm.proxy.StatementProxy.executeQueryCommon(StatementProxy.java:318) at com.ibm.ejs.cm.proxy.PreparedStatementProxy.executeQuery(PreparedStatementProxy.java:53) at org.apache.ojb.broker.accesslayer.JdbcAccess.executeQuery(Unknown Source) at org.apache.ojb.broker.accesslayer.RsIterator.init(Unknown Source) at org.apache.ojb.broker.singlevm.PersistenceBrokerImpl.getIteratorFromQuery(Unknown Source) at org.apache.ojb.broker.singlevm.PersistenceBrokerImpl.getCollectionByQuery(Unknown Source) at org.apache.ojb.broker.singlevm.PersistenceBrokerImpl.getCollectionByQuery(Unknown Source) at org.apache.ojb.broker.singlevm.PersistenceBrokerImpl.getCollectionByQuery(Unknown Source) at org.apache.ojb.broker.singlevm.PersistenceBrokerImpl.getCollectionByQuery(Unknown Source) at com.tgt.hr.exm.business.dao.OJBMeritSessionCheckOutDAO.clearMeritSessionCheckedOutLockedBy(OJBMeritSessionCheckOutDAO.jav a:275) at com.tgt.hr.exm.business.process.MeritPlanningProcess.unlockMeritRecordsLockedBy(MeritPlanningProcess.java:1097) at com.tgt.hr.exm.ui.action.LogoffAction.doNoramlLogOff(LogoffAction.java:306) at com.tgt.hr.exm.ui.action.LogoffAction.emPerform(LogoffAction.java:177) at com.tgt.hr.exm.ui.action.AbstractEMAction.perform(AbstractEMAction.java:124) at org.apache.struts.action.ActionServlet.processActionPerform(ActionServlet.java:1787) at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1586) at org.apache.struts.action.ActionServlet.doGet(ActionServlet.java:492) at javax.servlet.http.HttpServlet.service(HttpServlet.java:740) at javax.servlet.http.HttpServlet.service(HttpServlet.java:853) at com.ibm.servlet.engine.webapp.StrictServletInstance.doService(ServletManager.java:827) at com.ibm.servlet.engine.webapp.StrictLifecycleServlet._service(StrictLifecycleServlet.java:167) at com.ibm.servlet.engine.webapp.IdleServletState.service(StrictLifecycleServlet.java:297) at com.ibm.servlet.engine.webapp.StrictLifecycleServlet.service(StrictLifecycleServlet.java:110) at com.ibm.servlet.engine.webapp.ServletInstance.service(ServletManager.java:472) at com.ibm.servlet.engine.webapp.ValidServletReferenceState.dispatch(ServletManager.java:1012) at com.ibm.servlet.engine.webapp.ServletInstanceReference.dispatch(ServletManager.java:913) at com.ibm.servlet.engine.webapp.WebAppRequestDispatcher.handleWebAppDispatch(WebAppRequestDispatcher.java:721) at com.ibm.servlet.engine.webapp.WebAppRequestDispatcher.dispatch(WebAppRequestDispatcher.java:374) at com.ibm.servlet.engine.webapp.WebAppRequestDispatcher.forward(WebAppRequestDispatcher.java:118) at com.ibm.servlet.engine.srt.WebAppInvoker.doForward(WebAppInvoker.java:134) at com.ibm.servlet.engine.srt.WebAppInvoker.handleInvocationHook(WebAppInvoker.java:239) at
Newbie: JBoss + MySQL
Hello,
I have some big newbie problems. Maybe anybody can help! I'm trying to use
the OJB ODMG API with a MySQL Database and JBoss (3.0.6). I have followed
the steps necessary for deploying OJB on JBoss. That means I created the
ojb.sar folder in the deploy folder an included the necessary files. My
repository_database.xml file contains the following entry:
jdbc-connection-descriptor
jcd-alias=default
default-connection=true
platform=MySQL
jdbc-level=2.0
jndi-datasource-name=java:DefaultDS
driver=org.gjt.mm.mysql.Driver
protocol=jdbc
subprotocol=mysql
dbalias=//localhost:3306/Monitoring
username=monitor
password=password
eager-release=true
batch-mode=false
useAutoCommit=0
ignoreAutoCommitExceptions=false
connection-pool
maxActive=21
validationQuery= /
sequence-manager
className=org.apache.ojb.broker.util.sequence.SequenceManagerHighLowImpl
attribute attribute-name=grabSize attribute-value=20/
attribute attribute-name=autoNaming attribute-value=true/
attribute attribute-name=globalSequenceId
attribute-value=false/
attribute attribute-name=globalSequenceStart
attribute-value=1/
/sequence-manager
/jdbc-connection-descriptor
The ODMG Factory gets started:
[PBFactory] Starting
[PBFactory] PBFactory: org.apache.ojb.jboss.PBFactory /
DefaultDomain:service=PBAPI,name=ojb/PBAPI
[PBFactory] Lookup PBFactory via 'java:/ojb/PBAPI'
[PBFactory] Started
[ODMGFactory] Starting
[STDOUT] ** OJB-ODMG MBean integration
[STDOUT] ** ODMGFactory: org.apache.ojb.jboss.ODMGFactory /
DefaultDomain:service=ODMG,name=ojb/defaultODMG
[STDOUT] ** Use ODMGFactory via lookup:
[STDOUT] ** ODMGFactory factory = (ODMGFactory)
ctx.lookup(java:/ojb/defaultODMG)
[STDOUT] ** Implementation odmg = factory.getInstance();
[ODMGFactory] Started
The Datasource is also bound:
[DefaultDS] Bound connection factory for resource adapter 'JBoss
LocalTransaction JDBC Wrapper' to JNDI name 'java:/DefaultDS'
I have written a web application, that I deploy on JBoss. It contains a
Servlet which is loaded on start up with the following init() methode (just
to test the connection):
***init-Methode*
***
Context context = null;
try
{
context = new InitialContext();
}
catch (NamingException e)
{
logger.error(THIS_CLASS + Could not instantiate InitialContext, e);
throw new OJBRuntimeException(Could not instantiate InitialContext, e);
}
ODMGFactory factory = null;
try
{
factory = (ODMGFactory) context.lookup(java:/ojb/defaultODMG);
}
catch (NamingException e)
{
logger.error(THIS_CLASS + ctx.lookup(java:/ojb/defaultODMG) failed, e);
throw new OJBRuntimeException(Could not lookup ODMG factory instance,
e);
}
Implementation odmg = factory.getInstance();
logger.info(THIS_CLASS + Found odmg factory: + factory + and get
Implementation instance: + odmg);
Database db = odmg.newDatabase();
try
{
db.open(default, Database.OPEN_READ_WRITE);
}
catch (ODMGException e)
{
logger.error(THIS_CLASS + Database open failed, e);
throw new OJBRuntimeException(Unable to open database using ODMG api,
e);
}
***init-Methode
END
But when starting my JBoss this Servlet-init() methode never seems to get
reached. Instead I get the following errors:
[STDOUT] [org.apache.ojb.broker.core.NamingLocator] INFO:
[STDOUT] Init NamingLocator
[STDOUT] [org.apache.ojb.broker.core.NamingLocator] INFO:
[STDOUT] Properties for creating the initial context: null
[STDOUT] [org.apache.ojb.odmg.JTATxManager] ERROR:
[STDOUT] Cannot get the external transaction from the external TM
[jbossweb] Stopped
WebApplicationContext[/monitoring,jar:file:/home/wink05/jboss-3.0.6/server/d
efault/tmp/deploy/server/default/deploy/dev-monitoring.war/38.dev-monitoring
.war!/]
.
...
So what am I doing wrong??
Thanks in advance, Julia.
-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
RE: java.net.MalformedURLException: no protocol: repository.dtd
In the CVS source, the doctype declaration is somewhat different (and this works though I don't know whether the used XML parser is Xerces or Crimson): !DOCTYPE descriptor-repository PUBLIC -//Apache Software Foundation//DTD OJB Repository//EN repository.dtd [ !ENTITY database SYSTEM repository_database.xml !ENTITY internal SYSTEM repository_internal.xml !ENTITY junit SYSTEM repository_junit.xml !ENTITY user SYSTEM repository_user.xml !ENTITY ejb SYSTEM repository_ejb.xml !ENTITY jdo SYSTEM repository_jdo.xml ] The important part here seems to be that the doctype is specified as public with a public identifier as opposed to system like in your repository.xml. Tom - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
abort transaction causes TransactionNotInProgressException
Hello,
pleas look at this code:
Transaction tx = getActiveTransaction();
if(tx.isOpen()) {
tx.abort();
}
this causes :
[org.apache.ojb.odmg.TransactionImpl] INFO: Abort transaction was called
on tx [EMAIL PROTECTED], associated PB was
[EMAIL PROTECTED]
2003-06-23 13:47:58,031 WARN - Unhandled Exception thrown: class
org.odmg.TransactionNotInProgressException
what am I doing wrong?
joerg
-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
RE: RC3 Test Failures with MySQL
Unfortunately as far as I know, at this point they are known test case failures under MySQL. You can check out the complete thread at http://article.gmane.org/gmane.comp.jakarta.ojb.user/6878. Eric -Original Message- From: Quoc Pham Sent: Sunday, June 22, 2003 10:08 AM To: [EMAIL PROTECTED] Subject: RC3 Test Failures with MySQL I ran into the same problems and fixed some of them by: - Manually changing @DATABASE_DEFAULT@ to ojb in the files: objcore-schema.xml and objtest-schema.xml. - Manually changing the attribute required to true for REF_FK, REFA_FK, REFB_FK for the table REF_REPOSITORY_FK in the objtest-schema.xml: table name=REF_REPOSITORY_FK column name=REP_ID required=true primaryKey=true type=INTEGER/ column name=REF_FK required=true type=INTEGER primaryKey=true/ column name=REFA_FK required=true type=INTEGER primaryKey=true/ column name=REFB_FK required=true type=INTEGER primaryKey=true/ column name=NAME type=VARCHAR size=100/ /table These files are locate in the src/schema directories. However I still got a lot of errors in the JUnit tests: junit-no-compile-no-prepare: [junit] Running org.apache.ojb.broker.AllTests [junit] Tests run: 209, Failures: 20, Errors: 150, Time elapsed: 18.276 sec [junit] TEST org.apache.ojb.broker.AllTests FAILED [junit] Running org.apache.ojb.odmg.AllTests [junit] [BOOT] INFO: OJB.properties: file:/D:/java/ojb/db-ojb-1.0.rc3/target/test/ojb/OJB.properties [junit] Tests run: 156, Failures: 13, Errors: 63, Time elapsed: 3.085 sec [junit] TEST org.apache.ojb.odmg.AllTests FAILED [junit] Running org.apache.ojb.soda.AllTests [junit] [BOOT] INFO: OJB.properties: file:/D:/java/ojb/db-ojb-1.0.rc3/target/test/ojb/OJB.properties [junit] Tests run: 3, Failures: 3, Errors: 0, Time elapsed: 1.633 sec [junit] TEST org.apache.ojb.soda.AllTests FAILED [junit] Running org.apache.ojb.otm.AllTests [junit] Tests run: 1, Failures: 0, Errors: 1, Time elapsed: 2.193 sec [junit] TEST org.apache.ojb.otm.AllTests FAILED I can't figure out how to respond to your posting in the mailing so if you can please post this reply. Thanks. DISCLAIMER: The information contained in this e-mail is, unless otherwise indicated, confidential and is intended solely for the use of the named addressee. Access, copying or re-use of the e-mail or any information contained therein by any other person is not authorized. If you are not the intended recipient please notify us immediately by returning the e-mail to the originator.
RE: abort transaction causes TransactionNotInProgressException
Are you certain that tx.begin() was called and not followed by a
tx.commit()?
-Original Message-
From: Joerg Lensing [mailto:[EMAIL PROTECTED]
Sent: Monday, June 23, 2003 7:54 AM
To: OJB Users List
Subject: abort transaction causes TransactionNotInProgressException
Hello,
pleas look at this code:
Transaction tx = getActiveTransaction();
if(tx.isOpen()) {
tx.abort();
}
this causes :
[org.apache.ojb.odmg.TransactionImpl] INFO: Abort transaction was called
on tx [EMAIL PROTECTED], associated PB was
[EMAIL PROTECTED]
2003-06-23 13:47:58,031 WARN - Unhandled Exception thrown: class
org.odmg.TransactionNotInProgressException
what am I doing wrong?
joerg
-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
DISCLAIMER: The information contained in this e-mail is, unless otherwise
indicated, confidential and is intended solely for the use of the named
addressee. Access, copying or re-use of the e-mail or any information
contained therein by any other person is not authorized. If you are not the
intended recipient please notify us immediately by returning the e-mail to
the originator.
Re: abort transaction causes TransactionNotInProgressException
Eric Northam schrieb: Are you certain that tx.begin() was called and not followed by a tx.commit()? if the javadocs are right, then this cannot be true: javadoc: transaction.isOpen(): A transaction is open if a call has been made to |begin|, but a subsequent call to either |commit| or |abort| has *not* been made. joerg - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Prepare-Tutorials -- Echo Not Implimented
Hey All Running current CVS: I get a problem creating tutorials. It appears that this creates the base table. Any thoughts? Output from bin/build.bat prepare-tutorials: ... project-sql-classpath: [echo] +--+ [echo] | | [echo] | Generating SQL for OJB Testsuite! | [echo] | enJoy! | [echo] | | [echo] +--+ [torque-sql] Using contextProperties file: E:\Work\db-ojb\build.properties [torque-sql] Using classpath [torque-sql] Generating to file E:\Work\db-ojb\target\src\sql\report.ojbtest.sql.generation [torque-sql] Resolver: used database.dtd from org.apache.torque.engine.database.transform package [torque-sql] Resolver: used database.dtd from org.apache.torque.engine.database.transform package project-create-db-classpath: [echo] [echo] driver=org.hsqldb.jdbcDriver [echo] url=jdbc:hsqldb:target/test/OJB [echo] userid=sa [echo] password= [echo] [torque-create-db] Using classpath [torque-create-db] Generating to file E:\Work\db-ojb\target\src\sql\create-db.sql [torque-create-db] Resolver: used database.dtd from org.apache.torque.engine.database.transform package [torque-create-db] Resolver: used database.dtd from org.apache.torque.engine.database.transform package [sql] Executing file: E:\Work\db-ojb\target\src\sql\create-db.sql [sql] Failed to execute: ECHO Not implemented [sql] java.sql.SQLException: Unexpected token: ECHO in statement [ECHO Not implemented] [sql] 0 of 1 SQL statements executed successfully ... Jim Shingler
AW: Newbie: JBoss + MySQL
Hello again, I'm answering myself .. can anybody help me please? As I mentioned I have JBoss 3.0.6 and I try to open the database (no metter if with or without the preconfigured and running Datasource). But I get this confusing errors (see stack trace below). I'm trying to open the Database in Servlet that is in a war-Archive and not in an EJB environment! Is that the reason why I'm getting the errors with the transaction? And as I mentioned I have followed the steps on how to deploy OJB on JBoss. I didn't follow the instructions on how to deploy in an servlet environment because I wanted to able to use my already configured Datasources. Please help a newbie!! Julia. [STDOUT] [org.apache.ojb.broker.core.NamingLocator] INFO: [STDOUT] Init NamingLocator [STDOUT] [org.apache.ojb.broker.core.NamingLocator] INFO: [STDOUT] Properties for creating the initial context: null [STDOUT] [org.apache.ojb.odmg.JTATxManager] ERROR: [STDOUT] Cannot get the external transaction from the external TM [jbossweb] Stopped WebApplicationContext[/monitoring,jar:file:/home/wink05/jboss-3.0.6/server/d efault/tmp/deploy/server/default/deploy/dev-monitoring.war/38.dev-monitoring .war!/] 14:55:03,263 INFO [jbossweb] Deregister jboss.web:Jetty=0,JBossWebApplicationContext=3,context=/monitoring 14:55:03,267 INFO [jbossweb] Successfully undeployed file:/home/wink05/jboss-3.0.6/server/default/tmp/deploy/server/default/deplo y/dev-monitoring.war/38.dev-monitoring.war 14:55:08,927 ERROR [MainDeployer] could not start deployment: file:/home/wink05/jboss-3.0.6/server/default/deploy/dev-monitoring.war org.jboss.deployment.DeploymentException: No external transaction found; - nested throwable: (org.odmg.TransactionNotInProgressException: No external transaction found) at org.jboss.jetty.Jetty.deploy(Jetty.java:390) at org.jboss.jetty.JettyService.performDeploy(JettyService.java:249) at org.jboss.web.AbstractWebContainer.start(AbstractWebContainer.java:300) at org.jboss.deployment.MainDeployer.start(MainDeployer.java:814) at org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:627) at org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:591) at sun.reflect.GeneratedMethodAccessor9.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl .java:25) at java.lang.reflect.Method.invoke(Method.java:324) at org.jboss.mx.capability.ReflectedMBeanDispatcher.invoke(ReflectedMBeanDispat cher.java:284) at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:517) at org.jboss.util.jmx.MBeanProxy.invoke(MBeanProxy.java:174) at $Proxy3.deploy(Unknown Source) at org.jboss.deployment.scanner.URLDeploymentScanner.deploy(URLDeploymentScanne r.java:435) at org.jboss.deployment.scanner.URLDeploymentScanner.scanDirectory(URLDeploymen tScanner.java:656) at org.jboss.deployment.scanner.URLDeploymentScanner.scan(URLDeploymentScanner. java:507) at org.jboss.deployment.scanner.AbstractDeploymentScanner.startService(Abstract DeploymentScanner.java:261) at org.jboss.system.ServiceMBeanSupport.start(ServiceMBeanSupport.java:165) at sun.reflect.GeneratedMethodAccessor4.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl .java:25) at java.lang.reflect.Method.invoke(Method.java:324) at org.jboss.mx.capability.ReflectedMBeanDispatcher.invoke(ReflectedMBeanDispat cher.java:284) at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:517) at org.jboss.system.ServiceController$ServiceProxy.invoke(ServiceController.jav a:1003) at $Proxy0.start(Unknown Source) at org.jboss.system.ServiceController.start(ServiceController.java:413) at sun.reflect.GeneratedMethodAccessor3.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl .java:25) at java.lang.reflect.Method.invoke(Method.java:324) at org.jboss.mx.capability.ReflectedMBeanDispatcher.invoke(ReflectedMBeanDispat cher.java:284) at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:517) at org.jboss.util.jmx.MBeanProxy.invoke(MBeanProxy.java:174) at $Proxy2.start(Unknown Source) at org.jboss.deployment.SARDeployer.start(SARDeployer.java:230) at org.jboss.deployment.MainDeployer.start(MainDeployer.java:814) at org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:627) at org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:591) at org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:575) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39 ) at
Re: Prepare-Tutorials -- Echo Not Implimented
[sql] Failed to execute: ECHO Not implemented forget about only means that hsql does not support 'echo' command regards, Armin - Original Message - From: Jim Shingler [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, June 23, 2003 3:07 PM Subject: Prepare-Tutorials -- Echo Not Implimented Hey All Running current CVS: I get a problem creating tutorials. It appears that this creates the base table. Any thoughts? Output from bin/build.bat prepare-tutorials: ... project-sql-classpath: [echo] +--+ [echo] | | [echo] | Generating SQL for OJB Testsuite! | [echo] | enJoy! | [echo] | | [echo] +--+ [torque-sql] Using contextProperties file: E:\Work\db-ojb\build.properties [torque-sql] Using classpath [torque-sql] Generating to file E:\Work\db-ojb\target\src\sql\report.ojbtest.sql.generation [torque-sql] Resolver: used database.dtd from org.apache.torque.engine.database.transform package [torque-sql] Resolver: used database.dtd from org.apache.torque.engine.database.transform package project-create-db-classpath: [echo] [echo] driver=org.hsqldb.jdbcDriver [echo] url=jdbc:hsqldb:target/test/OJB [echo] userid=sa [echo] password= [echo] [torque-create-db] Using classpath [torque-create-db] Generating to file E:\Work\db-ojb\target\src\sql\create-db.sql [torque-create-db] Resolver: used database.dtd from org.apache.torque.engine.database.transform package [torque-create-db] Resolver: used database.dtd from org.apache.torque.engine.database.transform package [sql] Executing file: E:\Work\db-ojb\target\src\sql\create-db.sql [sql] Failed to execute: ECHO Not implemented [sql] java.sql.SQLException: Unexpected token: ECHO in statement [ECHO Not implemented] [sql] 0 of 1 SQL statements executed successfully ... Jim Shingler - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
RE: abort transaction causes TransactionNotInProgressException
I just tried this using ODMG with RC3 and it worked fine if I just create a new transaction and call tx.isOpen, it returns false. I jumped the gun a little because I thought I had the same issue before but never got around to troubleshooting it. Eric -Original Message- From: Eric Northam [mailto:[EMAIL PROTECTED] Sent: Monday, June 23, 2003 9:05 AM To: 'OJB Users List' Subject: RE: abort transaction causes TransactionNotInProgressException Actually just make sure tx.begin() is actually called. -Original Message- From: Eric Northam [mailto:[EMAIL PROTECTED] Sent: Monday, June 23, 2003 9:03 AM To: 'OJB Users List' Subject: RE: abort transaction causes TransactionNotInProgressException I know, but I wouldn't rule it out as a bug. Just double check to make sure. -Original Message- From: Joerg Lensing [mailto:[EMAIL PROTECTED] Sent: Monday, June 23, 2003 8:53 AM To: OJB Users List Subject: Re: abort transaction causes TransactionNotInProgressException Eric Northam schrieb: Are you certain that tx.begin() was called and not followed by a tx.commit()? if the javadocs are right, then this cannot be true: javadoc: transaction.isOpen(): A transaction is open if a call has been made to |begin|, but a subsequent call to either |commit| or |abort| has *not* been made. joerg - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] DISCLAIMER: The information contained in this e-mail is, unless otherwise indicated, confidential and is intended solely for the use of the named addressee. Access, copying or re-use of the e-mail or any information contained therein by any other person is not authorized. If you are not the intended recipient please notify us immediately by returning the e-mail to the originator. DISCLAIMER: The information contained in this e-mail is, unless otherwise indicated, confidential and is intended solely for the use of the named addressee. Access, copying or re-use of the e-mail or any information contained therein by any other person is not authorized. If you are not the intended recipient please notify us immediately by returning the e-mail to the originator. DISCLAIMER: The information contained in this e-mail is, unless otherwise indicated, confidential and is intended solely for the use of the named addressee. Access, copying or re-use of the e-mail or any information contained therein by any other person is not authorized. If you are not the intended recipient please notify us immediately by returning the e-mail to the originator.
RE: java.net.MalformedURLException: no protocol: repository.dtd
Hi Tom, It still gives me the same problem. Any other solution for this.. Pls let me know Thanks --- Thomas Dudziak [EMAIL PROTECTED] wrote: In the CVS source, the doctype declaration is somewhat different (and this works though I don't know whether the used XML parser is Xerces or Crimson): !DOCTYPE descriptor-repository PUBLIC -//Apache Software Foundation//DTD OJB Repository//EN repository.dtd [ !ENTITY database SYSTEM repository_database.xml !ENTITY internal SYSTEM repository_internal.xml !ENTITY junit SYSTEM repository_junit.xml !ENTITY user SYSTEM repository_user.xml !ENTITY ejb SYSTEM repository_ejb.xml !ENTITY jdo SYSTEM repository_jdo.xml ] The important part here seems to be that the doctype is specified as public with a public identifier as opposed to system like in your repository.xml. Tom - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] __ Do you Yahoo!? SBC Yahoo! DSL - Now only $29.95 per month! http://sbc.yahoo.com - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
RE: java.net.MalformedURLException: no protocol: repository.dtd
Hi Tom, It still gives me the same problem. Any other solution for this.. Pls let me know Thanks --- Thomas Dudziak [EMAIL PROTECTED] wrote: In the CVS source, the doctype declaration is somewhat different (and this works though I don't know whether the used XML parser is Xerces or Crimson): !DOCTYPE descriptor-repository PUBLIC -//Apache Software Foundation//DTD OJB Repository//EN repository.dtd [ !ENTITY database SYSTEM repository_database.xml !ENTITY internal SYSTEM repository_internal.xml !ENTITY junit SYSTEM repository_junit.xml !ENTITY user SYSTEM repository_user.xml !ENTITY ejb SYSTEM repository_ejb.xml !ENTITY jdo SYSTEM repository_jdo.xml ] The important part here seems to be that the doctype is specified as public with a public identifier as opposed to system like in your repository.xml. Tom - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] __ Do you Yahoo!? SBC Yahoo! DSL - Now only $29.95 per month! http://sbc.yahoo.com - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
RE: java.net.MalformedURLException: no protocol: repository.dtd
Hi, Is the repository in a path with a space in ? This has caused problems in the past with XML parsers. Cheers, Charles. -Original Message- From: anuradha devi [mailto:[EMAIL PROTECTED] Sent: 23 June 2003 15:04 To: OJB Users List Subject: RE: java.net.MalformedURLException: no protocol: repository.dtd Hi Tom, It still gives me the same problem. Any other solution for this.. Pls let me know Thanks --- Thomas Dudziak [EMAIL PROTECTED] wrote: In the CVS source, the doctype declaration is somewhat different (and this works though I don't know whether the used XML parser is Xerces or Crimson): !DOCTYPE descriptor-repository PUBLIC -//Apache Software Foundation//DTD OJB Repository//EN repository.dtd [ !ENTITY database SYSTEM repository_database.xml !ENTITY internal SYSTEM repository_internal.xml !ENTITY junit SYSTEM repository_junit.xml !ENTITY user SYSTEM repository_user.xml !ENTITY ejb SYSTEM repository_ejb.xml !ENTITY jdo SYSTEM repository_jdo.xml ] The important part here seems to be that the doctype is specified as public with a public identifier as opposed to system like in your repository.xml. Tom - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] __ Do you Yahoo!? SBC Yahoo! DSL - Now only $29.95 per month! http://sbc.yahoo.com - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] This email and any attachments are strictly confidential and are intended solely for the addressee. If you are not the intended recipient you must not disclose, forward, copy or take any action in reliance on this message or its attachments. If you have received this email in error please notify the sender as soon as possible and delete it from your computer systems. Any views or opinions presented are solely those of the author and do not necessarily reflect those of HPD Software Limited or its affiliates. At present the integrity of email across the internet cannot be guaranteed and messages sent via this medium are potentially at risk. All liability is excluded to the extent permitted by law for any claims arising as a re- sult of the use of this medium to transmit information by or to HPD Software Limited or its affiliates. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
RE: java.net.MalformedURLException: no protocol: repository.dtd
Not sure this will help, ... In the past, I have received this exception when I was using a old version of Xerces with a package that was expecting a new version. Thoughts? Jim Shingler -Original Message- From: anuradha devi [mailto:[EMAIL PROTECTED] Sent: Monday, June 23, 2003 10:04 AM To: OJB Users List Subject: RE: java.net.MalformedURLException: no protocol: repository.dtd Hi Tom, It still gives me the same problem. Any other solution for this.. Pls let me know Thanks --- Thomas Dudziak [EMAIL PROTECTED] wrote: In the CVS source, the doctype declaration is somewhat different (and this works though I don't know whether the used XML parser is Xerces or Crimson): !DOCTYPE descriptor-repository PUBLIC -//Apache Software Foundation//DTD OJB Repository//EN repository.dtd [ !ENTITY database SYSTEM repository_database.xml !ENTITY internal SYSTEM repository_internal.xml !ENTITY junit SYSTEM repository_junit.xml !ENTITY user SYSTEM repository_user.xml !ENTITY ejb SYSTEM repository_ejb.xml !ENTITY jdo SYSTEM repository_jdo.xml ] The important part here seems to be that the doctype is specified as public with a public identifier as opposed to system like in your repository.xml. Tom - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] __ Do you Yahoo!? SBC Yahoo! DSL - Now only $29.95 per month! http://sbc.yahoo.com - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Automatic Mapping Tool
Hello, I have my application already running and I want to change the persistence to the OJB ODMG API. I have some classes (Value Objects) that I want to persist. I have a ServerVO which holds some generic attributes and an attribute of the type ModulesVO. This ModulesVO contains a List of ModuleVO (be aware of the s) that contain some generic attributes. That's all. Now what I would like to have is a tool that automatically generates the repository_user.xml for me out of my classes. Is there a tool available? Because in the documentation I found only instructions how to manually create this file. I heard that James Holmes is working on a OJB Console but as I see he is not finished with this. Thanks, Julia. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: abort transaction causes TransactionNotInProgressException
Hi Joerg, I made some tests but can not reproduce your problem. Maybe it's a synchronization problem of concurrent threads? A test case reproduce your problem will be helpful. to release the locks. No changes were made since calling checkpoint()---) I checked this in a test, but all works fine snip tx.begin(); // store some objects storeObjects(tx, getNewODMGZoos(3, name)); tx.checkpoint(); tx.commit(); /snip regards, Armin - Original Message - From: Joerg Lensing [EMAIL PROTECTED] To: OJB Users List [EMAIL PROTECTED] Sent: Monday, June 23, 2003 5:20 PM Subject: Re: abort transaction causes TransactionNotInProgressException Armin Waibel schrieb: Hi Joerg, could you post more stack trace? OJB version? standalone? regards, Armin hi armin, ojb-version is rc3. Now I tried to use commit() instead of abort(---should result in the same state because I use it to release the locks. No changes were made since calling checkpoint()---) . But sometimes objectEnvelopeTable in TransactionImpl.doAbort() is null (- NullpointerException) java.lang.NullPointerException at org.apache.ojb.odmg.TransactionImpl.doClose(TransactionImpl.java:398) at org.apache.ojb.odmg.TransactionImpl.commit(TransactionImpl.java:568) at de.softcon.webcontrol.integration.data.ojb.OjbDAOTransactionHandler.comm itTransaction(OjbDAOTransactionHandler.java:54) TransactionImpl.doAbort joerg - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: OJB not to cache its queries
you can use the refresh attribute set to true in your repository.xml. Christophe - Original Message - From: Srikanth Gubba [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, June 23, 2003 8:29 PM Subject: OJB not to cache its queries Hi all, do u know how to configure ojb not to cache its queries? any help appreciated. Thanks in adv, srikanth - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] --- Ce message Envoi est certifié sans virus connu. Protégé par l'antivirus AVG Deluxe. Version: 6.0.488 / Base de données virus: 287 - Date: 05/06/2003 - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
RE: java.net.MalformedURLException: no protocol: repository.dtd
Just a thought. Doesn't the newest version of Xerces only support a URL in the doctype. Basically this means that you can't use relative paths when referencing dtds (or included repository files). I found this when I upgraded to Tomcat 4.1. I just went and grabbed my old version of Xerces to get it to work. snippet DOS filenames are not legal URIs as required by the XML 1.0 specification. Therefore, it was an error for the parser to accept DOS filenames. This bug is now fixed. DOS filenames can be converted to legal URLs, however. For example, the DOS filename c:\xerces\data\personal.xml would become file:///c:/xerces/data/personal.xml, which is a legal URL. /snippet Hope this helps, Graham -Original Message- From: Jim Shingler [mailto:[EMAIL PROTECTED] Sent: Monday, June 23, 2003 11:18 AM To: 'OJB Users List' Subject: RE: java.net.MalformedURLException: no protocol: repository.dtd Not sure this will help, ... In the past, I have received this exception when I was using a old version of Xerces with a package that was expecting a new version. Thoughts? Jim Shingler -Original Message- From: anuradha devi [mailto:[EMAIL PROTECTED] Sent: Monday, June 23, 2003 10:04 AM To: OJB Users List Subject: RE: java.net.MalformedURLException: no protocol: repository.dtd Hi Tom, It still gives me the same problem. Any other solution for this.. Pls let me know Thanks --- Thomas Dudziak [EMAIL PROTECTED] wrote: In the CVS source, the doctype declaration is somewhat different (and this works though I don't know whether the used XML parser is Xerces or Crimson): !DOCTYPE descriptor-repository PUBLIC -//Apache Software Foundation//DTD OJB Repository//EN repository.dtd [ !ENTITY database SYSTEM repository_database.xml !ENTITY internal SYSTEM repository_internal.xml !ENTITY junit SYSTEM repository_junit.xml !ENTITY user SYSTEM repository_user.xml !ENTITY ejb SYSTEM repository_ejb.xml !ENTITY jdo SYSTEM repository_jdo.xml ] The important part here seems to be that the doctype is specified as public with a public identifier as opposed to system like in your repository.xml. Tom - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] __ Do you Yahoo!? SBC Yahoo! DSL - Now only $29.95 per month! http://sbc.yahoo.com - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
RE: OJB not to cache its queries
hi christophe, so, should i use class-descriptor class=org.apache.struts.util.MessageResource table=application_resources refresh=true in my repository.xml? Thanks, srikanth. -Original Message- From: Christophe Marcourt [mailto:[EMAIL PROTECTED] Sent: Monday, June 23, 2003 3:07 PM To: OJB Users List Subject: Re: OJB not to cache its queries you can use the refresh attribute set to true in your repository.xml. Christophe - Original Message - From: Srikanth Gubba [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, June 23, 2003 8:29 PM Subject: OJB not to cache its queries Hi all, do u know how to configure ojb not to cache its queries? any help appreciated. Thanks in adv, srikanth - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] --- Ce message Envoi est certifié sans virus connu. Protégé par l'antivirus AVG Deluxe. Version: 6.0.488 / Base de données virus: 287 - Date: 05/06/2003 - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: OJB not to cache its queries
yes - Original Message - From: Srikanth Gubba [EMAIL PROTECTED] To: 'OJB Users List' [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Monday, June 23, 2003 9:38 PM Subject: RE: OJB not to cache its queries hi christophe, so, should i use class-descriptor class=org.apache.struts.util.MessageResource table=application_resources refresh=true in my repository.xml? Thanks, srikanth. -Original Message- From: Christophe Marcourt [mailto:[EMAIL PROTECTED] Sent: Monday, June 23, 2003 3:07 PM To: OJB Users List Subject: Re: OJB not to cache its queries you can use the refresh attribute set to true in your repository.xml. Christophe - Original Message - From: Srikanth Gubba [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, June 23, 2003 8:29 PM Subject: OJB not to cache its queries Hi all, do u know how to configure ojb not to cache its queries? any help appreciated. Thanks in adv, srikanth - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] --- Ce message Envoi est certifié sans virus connu. Protégé par l'antivirus AVG Deluxe. Version: 6.0.488 / Base de données virus: 287 - Date: 05/06/2003 - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: Problems with OJB in a servlet container
Daniel, THANKS! Works like a charm. Ciao MarkS Daniel Wroblewski wrote: I had a similar problem with OJB in Resin. By setting some system properties, overriding the default XML parsers loaded by resin, I got it to work. You can set system properties in a number of ways, I choose to do it in the resin configuration file, resin.conf. Try adding the following before the http-server-node: system-property javax.xml.transform.TransformerFactory= org.apache.xalan.processor.TransformerFactoryImpl/ system-property javax.xml.parsers.DocumentBuilderFactory= org.apache.xerces.jaxp.DocumentBuilderFactoryImpl/ system-property javax.xml.parsers.SAXParserFactory= org.apache.xerces.jaxp.SAXParserFactoryImpl/ /Daniel From: Charles Anthony [mailto:[EMAIL PROTECTED] Sent: den 20 juni 2003 12:13 To: 'OJB Users List' Hi Mark, There's some kind of bizarre synchronicity going on here I was just trying my OJB Webapp in Resin for the first time (minutes ago), and I got exactly the same problem. It runs fine in Tomcat, and we've had it going in Websphere too. I've got a hunch that it may have something to do with a XML parser/classpath issue, but I could be speaking complete rubbish. So, I don't think you've missed anything obvious. I can't offer anything more concrete than that, I'm afraid, and as my knowledge of Resin is rather less than nothing, I'm not sure I can spend alot of time investigating it right now. Has anyone else using OJB + Resin got any hints for us ? Cheers, Charles. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: 20 June 2003 11:00 To: OJB Users List Subject: Problems with OJB in a servlet container Hi, I'm new to the world of JDO and OJB, so please bear with me if this is stupid/straightforward. I want to use OJB in a servlet container. I wrote a small (standalone) test application to do all the configuration and such. That one works. I now tried to move everything into a servlet WAR: - the OJB.properties and repository*.xml files in WEB-INF/classes - all libraries in WEB-INF/lib - the code from the standalone app (just creating and retrieving an object) into a java bean that I call from a servlet But I get a java.lang.ExceptionInInitializerError at org.apache.ojb.broker.core.PersistenceBrokerFactoryDefaultImpl. buildDefaultKey(Unknown Source) at org.apache.ojb.broker.core.PersistenceBrokerFactoryDefaultImpl. init(Unknown Source) ... Is there anything obvious that I'm missing (should any libraries or config files be in the servlet containers lib dir)? What is the best way to debug this? Thanks MarkS P.S: I'm using Resin. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] This email and any attachments are strictly confidential and are intended solely for the addressee. If you are not the intended recipient you must not disclose, forward, copy or take any action in reliance on this message or its attachments. If you have received this email in error please notify the sender as soon as possible and delete it from your computer systems. Any views or opinions presented are solely those of the author and do not necessarily reflect those of HPD Software Limited or its affiliates. At present the integrity of email across the internet cannot be guaranteed and messages sent via this medium are potentially at risk. All liability is excluded to the extent permitted by law for any claims arising as a re- sult of the use of this medium to transmit information by or to HPD Software Limited or its affiliates. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
oracle BLOB 4K
Has there been any update/fix for this issue of with storing BLOBs 4K in Oracle(8.1.7), thin driver? I am having this problem now.-Conall Hi Alan, This is a known issue with Oracle's JDBC Driver. Oracle's handling of BLOB does simply not work the way OJB expects the driver to do. Sometime ago Michael Mogly contributed a patch that provides proper Oracle BLOB handling. Unfortunately this patch involves changes to a lot of classes, so that I did not manage to integrate it into the main codebase yet. cheers, Thomas -Ursprüngliche Nachricht- Von: Olmanson, Alan [mailto:[EMAIL PROTECTED] Gesendet: Montag, 13. Januar 2003 21:17 An: OJB Users List (E-mail) Betreff: Oracle and BLOB 4K Hello, We are having some problems with OJB 0.9.8, Oracle 9i and BLOB fields which are greater than 4K, when we insert a new object. The statement execution hangs for a long time and when it comes back we get this error: java.sql.SQLException: Io exception: End of TNS data channel at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:180) at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:222) at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:335) at oracle.jdbc.driver.OracleStatement.executeNonQuery(OracleState ment.java:1860 ) at oracle.jdbc.driver.OracleStatement.doExecuteOther(OracleStatem ent.java:1771) at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(Oracle Statement.java :2361) at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(Oracl ePreparedState ment.java:422) at org.apache.ojb.broker.accesslayer.JdbcAccess.executeInsert(Jdb cAccess.java:1 95) In the database the field is a BLOB and in the repository it is marked as a BLOB, in our object the attribute in a byte[]. Is this known issue? Is there a way to get this to work? Alan - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
RE: oracle BLOB 4K
Hi Conall, I have been hoping to rework my fix for this to fit better with Ojb's existing design and framework. However, I am currently committed to projects at work and am not likely to have much time for Ojb until August. If someone wants to step in before then with a patch that takes care of read/insert/update (as opposed to just read, as has been already submitted), I would be more than happy to share the expertise I have with Oracle's drivers to facilitate this. Michael -Original Message- From: Conall O'Raghallaigh [mailto:[EMAIL PROTECTED] Sent: Monday, June 23, 2003 3:57 PM To: OJB Users List Subject: oracle BLOB 4K Has there been any update/fix for this issue of with storing BLOBs 4K in Oracle(8.1.7), thin driver? I am having this problem now.-Conall Hi Alan, This is a known issue with Oracle's JDBC Driver. Oracle's handling of BLOB does simply not work the way OJB expects the driver to do. Sometime ago Michael Mogly contributed a patch that provides proper Oracle BLOB handling. Unfortunately this patch involves changes to a lot of classes, so that I did not manage to integrate it into the main codebase yet. cheers, Thomas -Ursprüngliche Nachricht- Von: Olmanson, Alan [mailto:[EMAIL PROTECTED] Gesendet: Montag, 13. Januar 2003 21:17 An: OJB Users List (E-mail) Betreff: Oracle and BLOB 4K Hello, We are having some problems with OJB 0.9.8, Oracle 9i and BLOB fields which are greater than 4K, when we insert a new object. The statement execution hangs for a long time and when it comes back we get this error: java.sql.SQLException: Io exception: End of TNS data channel at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:180) at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:222) at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:335) at oracle.jdbc.driver.OracleStatement.executeNonQuery(OracleState ment.java:1860 ) at oracle.jdbc.driver.OracleStatement.doExecuteOther(OracleStatem ent.java:1771) at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(Oracle Statement.java :2361) at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(Oracl ePreparedState ment.java:422) at org.apache.ojb.broker.accesslayer.JdbcAccess.executeInsert(Jdb cAccess.java:1 95) In the database the field is a BLOB and in the repository it is marked as a BLOB, in our object the attribute in a byte[]. Is this known issue? Is there a way to get this to work? Alan - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: extents and mapping inheritence
Hi Scott, Weaver, Scott wrote: Is there anyway I can remove the mapping for B entirely. It implements the interface AB and extends A. That should be good enough for OJB. However, when I try this, I get class B is not persistence capable. The reason I want to do this is B is a special case that may or may not be used and we would prefer to keep it out of the OJB mappings and rely entirely on dealing with AB and/or A. If you are using B instances you *must* provide a class-descriptor for B. OJB prints out the message you see when you try to call persistence operations on aclass that is not defined in the repository. Scott, I have one question regarding Jetspeed. I heared that there have been discussions to use OJB within Jetspeed. Are you working on this? Or do you anything about this topic? cheers, Thomas *===* * Scott T Weaver * * Jakarta Jetspeed Portal Project * * [EMAIL PROTECTED] * *===* -Original Message- From: Weaver, Scott [mailto:[EMAIL PROTECTED] Sent: Monday, June 23, 2003 3:21 PM To: 'OJB Users List' Subject: RE: extents and mapping inheritence Thanks Jakob. I Guess I'll have to use ENTITY references instead. Do you have any other work-arounds I might try? Thanks again, *===* * Scott T Weaver* * Jakarta Jetspeed Portal Project * * [EMAIL PROTECTED] * *===* -Original Message- From: Jakob Braeuchi [mailto:[EMAIL PROTECTED] Sent: Monday, June 23, 2003 3:03 PM To: OJB Users List Subject: Re: extents and mapping inheritence hi scott, ojb does not support inheritence of field- and relationship-descriptors. but there are some discussions going on regarding this feature. hth jakob Weaver, Scott wrote: Is there anyway to have a class-descriptor inherit the mappings of a previously defined class-descriptor? Example: AB is an interface. A implements AB and B extends A. class-descriptor class=AB extent-class class-ref=A / extent-class class-ref=B / /class-descriptor class-descriptor class=A table=AB field-descriptor name=idcolumn=ID jdbc-type=INTEGER primarykey=true autoincrement=true / field-descriptor name=name column=NAME jdbc-type=VARCHAR/ /class-descriptor The question: How can define the class-descriptor for B without having to copy the identical mappings from A? I tried using the extends attribute of class-descriptor on hunch that's what it was for, however, no dice. There has got to be a simple way to accomplish this, however, I have yet to find it. Using 1.0rc3. Thanks, *===* * Scott T Weaver * * Jakarta Jetspeed Portal Project * * [EMAIL PROTECTED] * *===* - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
