y I'm 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
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
nother option is to use "custom attributes" to
> specify jdbc-driver parameter (if supported by the jdbc-driver):
>
http://db.apache.org/ojb/docu/guides/repository.html#Custom+attributes-N
10329
>
>
> the example above would look like (don't know if mysql support this
> t
of the dbalias as shown below:
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
Since we are using OJB and DBCP for connection po
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
(see Platform class methods) but never implement it.
regards,
Armin
>
> Roger Janssen
> iBanx
>
> -Original Message-
> From: Armin Waibel [mailto:[EMAIL PROTECTED]
> Sent: zaterdag 3 februari 2007 3:05
> To: OJB Users List
> Subject: Re: Performance Issue on lo
Subject: Re: Performance Issue on lookup 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 l
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
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
enced this with.
Thanks
-Eric
-----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
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 comm
y . i 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
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.
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]
Sen
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 prop
.
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 initi
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 previo
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 do
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 databas
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 JBOSS.
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-conn
error, 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
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
g", e);
}
}
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
> hap
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
d
27 matches
Mail list logo