working with just one database.
I don't think we're talking about the same problem, anyway try telling
something more about your problem, sure you will be helped.
greetings
Alessandro
On 2/27/07, Ferrer, Eric [EMAIL PROTECTED] wrote:
Alessandro,
Did you code around your stall or did you fix
Alessandro,
Did you code around your stall or did you fix the issue causing the
stall. Sometimes I swear I notice connectivity issues between 3 of the
external database I talk to. Sometimes the problem self fixes as
connectivity improves but other times we have a dead process that is
waiting on
Is it possible to hint to OJB on persisted calls to use the WITH (NO
LOCK) attributes on tables?
When ever we are in a multiple transaction and selecting data from large
tables we sometimes slow things down and for performance reasons
sometimes have to create views.
Thanks
-Eric
if mysql support this
too)
attribute attribute-name=jdbc.zeroDateTimeBehavior
attribute-value=convertToNull/
regards, Armin
I hope this helps.
Luis
-Original Message- From: Ferrer, Eric
[mailto:[EMAIL PROTECTED] Sent: Monday, February 12,
2007
4:02 PM To: OJB
Since we are using OJB and DBCP for connection pooling, with the
introduction of JDBC 4.0 a lot of drivers have additional parameters
that we can set for performance tuning. What are the options for
setting this in OJB's repository_database.xml or other properties file?
Thanks
-Eric
?zeroDateTimeBehavior=convertToNull
username=xx
password=y
I hope this helps.
Luis
-Original Message-
From: Ferrer, Eric [mailto:[EMAIL PROTECTED]
Sent: Monday, February 12, 2007 4:02 PM
To: OJB Users List
Subject:Driver Specific Parameters
on a table
Hi Eric,
Ferrer, Eric wrote:
Thanks for the reply, Can the OJB developers reply with their thoughts
on this.
I would have figured the load by persistence object calls we make and
we do them when we only want 1 record a lot would do the same job as
the SQL select statement
this feature. Right now, I have to expose the
datamodel within my application code, bypassing our domain model and OJB
as OR mapper, and that really hurts.
Greetings,
Roger Janssen
iBanx
-Original Message-
From: Ferrer, Eric [mailto:[EMAIL PROTECTED]
Sent: vrijdag 2 februari 2007 3:54
To: OJB
I am experience an issue with an OJB query using a persistable object.
Basically its taking 7 minutes to return on the call getObjectByQuery.
When I run the query
-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional
-Original Message-
From: Ferrer, Eric [mailto:[EMAIL PROTECTED]
Sent: Thursday, February 01, 2007 4:52 PM
To: OJB Users List
Subject: Performance Issue on lookup on a table
I am experience an issue with an OJB query using a persistable object.
Basically its taking 7 minutes to return on the call
Just to add it appears to work when passing a straight SQL query versus
using the persistable method.
-Eric
-Original Message-
From: Ferrer, Eric [mailto:[EMAIL PROTECTED]
Sent: Thursday, February 01, 2007 4:57 PM
To: OJB Users List
Subject: RE: Performance Issue on lookup on a table
Marwane,
Growing the pool is not a good thing always. Say you have 300 Oracle
licenses, depending on the license, that may include connection pooled
objects under the same user account.
So there is a section in your code that may not have a finally block so
the connection does not get closed.
will profile the
connections,
but it will be gretful if you can give me more detail about using DBCP
and
evictionThreads with example configuration (ojb.prperties,
repository.xml)
and how to profile the connections with wich tools ?
thx
On 11/8/06, Ferrer, Eric [EMAIL PROTECTED] wrote:
Marwane
One thing to consider.
Take a look at the database and find out how many licenses you have.
When I was an OJB/DBCP noob I had set the maxActive higher than the
number of available connections in the database.
- Eric
-Original Message-
From: Dennis Bekkering [mailto:[EMAIL PROTECTED]
21, 2006 1:30 PM
To: OJB Users List
Subject: Re: OJB-DBCP initial connection pool setting support
Hi Eric,
Ferrer, Eric wrote:
Hi,
DBCP supports an initialSize property for initializing connections on
startup, does OJB support this parameter?
A DBCP property 'initialSize
.
Thanks
-Eric
-Original Message-
From: Armin Waibel [mailto:[EMAIL PROTECTED]
Sent: Thursday, September 21, 2006 1:30 PM
To: OJB Users List
Subject: Re: OJB-DBCP initial connection pool setting support
Hi Eric,
Ferrer, Eric wrote:
Hi,
DBCP supports an initialSize property
Hi,
DBCP supports an initialSize property for initializing connections on
startup, does OJB support this parameter?
Thanks
-Eric
Disclaimer:
This email may contain confidential and privileged material for the sole use of
the intended recipient(s) and only for those purposes
I have this process that collects data from an external resource and
then loads the data into several database tables.
It appears that under heavy load, I am unable to access data from those
tables unless they are views with NOLOCK defined.
I am using SQL Server 2005 database where the help
I am not running 1.0.4, heck I just inherit this code I am working with
now, and they had renamed the jar file to just say ojb.jar but I know
its not 1.0.4 (file data on jar is early March 2005). Everything seems
stable so far, been running our junit tasks and building against our
Oracle
I currently have OJB configured to run on Tomcat using apache's
connection pooling. We are going to be switching environments to use
JBOSS as our application server.
JBOSS appears to be really focused on integrating with Hibernate and I
had some concerns of forth coming issues with OJB and
I wanted to know if when OJB generates the sql to get back requested
data, how does OJB handle the locking of records?
,
Ferrer, Eric wrote:
There is no Oracle error in the stack track or in the spy.log.
seems this is caused by oracle 10g driver
Caused by: java.sql.SQLException: Attempt to set Escape Processing after
SQL is already processed
Please try to use Oracle9i platform settings in your
jdbc-connection
, something like
ORA-.
jakob
Ferrer, Eric schrieb:
Here it is Jakob,
DEBUG - OJB: TableAlias(): using hints ?
false,null,,swav,123,2005-12-09
14:42:51.649
DEBUG - OJB: SQL:SELECT
A0.MODIFY_DTIME,A0.PARAMETER_NAME,A0.SYSTEM_ID,A0.DATA_TAG,A0.MODIFY_USE
R,A0.CREATE_DTIME,A0.CREATE_USER,A0
);
}
}
have you tried stmt.setEscapeProcessing(true) on a prepared statement
without using ojb ?
jakob
Ferrer, Eric schrieb:
We recently started getting a weird error with OJB and we are trying
to
find out if its an Oracle specific issue or an OJB issue that would
happen cross databases
exception ?
jakob
Ferrer, Eric schrieb:
Hi Jakob,
OJB is the persistence layer used throughout the project. I can
create
a test connecting to Oracle directly and see what happens. I am
currently creating a SQL Server instance and seeing if I get similar
results from OJB.
Could
We recently started getting a weird error with OJB and we are trying to
find out if its an Oracle specific issue or an OJB issue that would
happen cross databases.
We get from our logs
OJB: Create new DBCP connection
pool:[EMAIL PROTECTED]
jcd-alias=SECURITY
default-connection=false
26 matches
Mail list logo
