Register / Login

Help coderanch get a

new server

by contributing to the fundraiser

Alana Sparx

Ranch Hand

+ Follow

news 121 Posts 41 Threads

since Feb 14, 2006

Merit badge: grant badges

For More

Cows and Likes

Cows

Total received

In last 30 days

0

Forums and Threads

Recent posts by Alana Sparx

Websphere - sluggish response with IIS

Hi all

Not really my area of expertise, so I'll throw all sorts of info into this.

We have deployed a couple of web apps on Websphere CE. There are two servers, which recieve requests dispatched via 2 IIS servers. When you are connected to the applications, the requests zip along. However, perfromance is sluggish at times: it zips along, and then every request hangs for up to 10 minutes. All of a sudden, everything is rosy again.

I have no idea what could be causing this, the network side of life isn't really my area of expertise. Could it be down to the AJP connections? We also have a Sitemnder security layer on the IIS server, could this be to blame.

Obviously you can't tell me what the issue here is, but does anyone have any experience of a similar issue, or any areas to look into?

Much obliged

As

15 years ago

Debate - Declarations in/outside loops

Hello all

Bit of a heated debate going on here.

We have an enterprise level system potentially being used by a worldwide community of thousands.

There are some issue in the application code, but I would like to know what your ideas on this is

This to me is the correct way to do things, reusing the same memory address each time the loop iterates.

One of our experienced programmers says this is not an issue, and that this is perfectly acceptable:

Examples of this are littered throughout the code base (where the declaration and assignement are contained in the body of the loop). To me, this runs the risk of memory leaks and stressing the garbage collector, but I am willing to be corrected.

Any thoughts out there?

Non abbreviated thanks 30 seconds after last attempt (are you trying to stop people posting?)

16 years ago

Statements executing VERY slowly

Hi all

Statements we execute against the database are VERY SLOW INDEED.

The sql is generated by Hibernate.
The application server is Webshpere Community Edition.
The database is Sql Server 2005.
The database driver is the jTDS driver.

If we take the sql generated by hibernate and execute it directly against the database, the query flies along.
If we take the sql and execute it as a prepared statement through a jdbc connection, again it flies along.
When we use the service that ultimately calls the Hibernate classes, we are waiting in excess of 60 seconds for the query to complete.

Does anyone have any pointers that can help remedy this?

I've also posted a similar question here, on the Websphere Forum

16 years ago

JDBC and Relational Databases

Slow Prepared Statement Execution Through Websphere

Hi, here's hoping!

We are using Webshpere Community Edition as our application server, and Hibernate as the ORM tool. We have noticed that queries are taking an impossibly long to time to execute (over a minute to return 600 rows), and are basically blaming the Application Server for this. The Database Server is Sql Server 2005.

We have taken the sql generated by Hibernate and executed it directly against the server - the query zips along in 0.2 secs. I have created a JDBC connection and executed the statement as a prepared statement, and this also zips along. The DB driver we use is the jTDS driver.

Can anyone help explain this behaviour, or give me pointers as to possible solutions? Currently, we're thinking of shifting application server as the finger seems to be pointing in it's direction.

Many thanks
AS

16 years ago

hibernate.AssertionFailure collection [] was not processed by flush()

Hi again

Here is an interim solution for anyone else who comes across this situation.

Note that the collection I'm dealing with is immutable, if yours isn't, I'm not sure what the consequences of this would be.

We augmented the Hibernate class CollectionEntry from

to

Basically, we check for the specific collection name that was causing us grief, if the collection isn't this, Hibernate carries on as usual. If the collection is our own specific one, don't bother with the flush.

loadedPersister has a mutable flag on it, wasn't sure if checking this flag and evading postFlush() is an appropriate thing to do or not, probably a question that can best be answered by the Hibernators

16 years ago

Object Relational Mapping

hibernate.AssertionFailure collection [] was not processed by flush()

Hi Mark, tanks for the reply.

Well, it appears you have closed your Session.

I don't think that was the issue. I set the xdoclet 'lazy="false"', which ceased reporting the session being closed, but the AssertionError is still being reported

I have a couple of questions.

1. Why are you using xdoclet. You are using Hibernate 3.2

Only because we were previously using version 3.0.?.ga, and upgrading to 3.2.5 was in response to the error above ie no time to refactor the xdoclets (Hibernate site suggested it was an error fixed in 3.2.1 Further investigations suggest it is still a problem, as yet unresolved as reported here)

I don't think the xdoclets would affect the application in this way. The error above, for the project I'm working on, is a bit of a showstopper, so I'm in a bit of a 'brown trouser' situation at the moment.

Any other ideas?

16 years ago

Object Relational Mapping

hibernate.AssertionFailure collection [] was not processed by flush()

Hi all

I've been getting the above error no matter what I try and do to solve it.

THe collection in question is

I've removed the xdoclet tag from the collection heading.
I've overridden the compateTo method to check for
I've used the latest version of hibernate (3.2.5.ga) and still I get the same exception thrown!

PolicyStatusRestriction does not contain any sets. Both PolicyStatus and PolicyStatusRestriction are immutable.

Any ideas? THe full stacktrace follows:

2007-09-12 11:11:36,218 ERROR vice.transfer.TransferEligibilityMembers - Failed while processing top two
com.common.exception.TransferException: A service error has occurred
at com.service.transfer.TransferEntity.updateOds(TransferEntity.java:332)
at com.service.transfer.TransferEntity.processTopTwo(TransferEntity.java:192)
at com.service.transfer.TransferEntity.execute(TransferEntity.java:108)
at com.service.transfer.TransferEntity$$FastClassByCGLIB$$58d0e5cc.invoke(<generated> :wink:
at net.sf.cglib.proxy.MethodProxy.invoke(MethodProxy.java:149)
at org.springframework.aop.framework.Cglib2AopProxy$CglibMethodInvocation.invokeJoinpoint(Cglib2AopProxy.java:685)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:148)
at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:96)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:170)
at org.springframework.aop.framework.Cglib2AopProxy$DynamicAdvisedInterceptor.intercept(Cglib2AopProxy.java:623)
at com.service.transfer.TransferEligibilityMembers$$EnhancerByCGLIB$$b1525510.execute(<generated> :wink:
at com.service.transfer.TransferManagerImpl.processEntity(TransferManagerImpl.java:208)
at com.service.transfer.TransferManagerImpl.transferDataFromEcToOds(TransferManagerImpl.java:196)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:64)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:615)
at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:287)
at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:181)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:148)
at org.springframework.remoting.support.RemoteInvocationTraceInterceptor.invoke(RemoteInvocationTraceInterceptor.java:68)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:170)
at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:176)
at $Proxy188.transferDataFromEcToOds(Unknown Source)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:64)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:615)
at org.springframework.remoting.support.RemoteInvocation.invoke(RemoteInvocation.java:179)
at org.springframework.remoting.support.DefaultRemoteInvocationExecutor.invoke(DefaultRemoteInvocationExecutor.java:33)
at org.springframework.remoting.support.RemoteInvocationBasedExporter.invoke(RemoteInvocationBasedExporter.java:76)
at org.springframework.remoting.support.RemoteInvocationBasedExporter.invokeAndCreateResult(RemoteInvocationBasedExporter.java:112)
at org.springframework.remoting.httpinvoker.HttpInvokerServiceExporter.handleRequest(HttpInvokerServiceExporter.java:82)
at org.springframework.web.servlet.mvc.SimpleControllerHandlerAdapter.handle(SimpleControllerHandlerAdapter.java:44)
at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:723)
at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:663)
at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:394)
at org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:358)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:615)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:688)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:178)
at org.apache.geronimo.tomcat.valve.DefaultSubjectValve.invoke(DefaultSubjectValve.java:56)
at org.apache.geronimo.tomcat.GeronimoStandardContext$SystemMethodValve.invoke(GeronimoStandardContext.java:342)
at org.apache.geronimo.tomcat.valve.GeronimoBeforeAfterValve.invoke(GeronimoBeforeAfterValve.java:31)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:107)
at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:541)
at org.apache.catalina.authenticator.SingleSignOn.invoke(SingleSignOn.java:392)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:869)
at org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:667)
at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:527)
at org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:80)
at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:869)
at java.lang.Thread.run(Thread.java:799)
Caused by:
org.hibernate.AssertionFailure: collection [com.model.ods.PolicyStatus.restrictedToRoles] was not processed by flush()
at org.hibernate.engine.CollectionEntry.postFlush(CollectionEntry.java:205)
at org.hibernate.event.def.AbstractFlushingEventListener.postFlush(AbstractFlushingEventListener.java:333)
at org.hibernate.event.def.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:28)
at org.hibernate.impl.SessionImpl.flush(SessionImpl.java:1000)
at org.hibernate.impl.SessionImpl.managedFlush(SessionImpl.java:338)
at org.hibernate.transaction.JDBCTransaction.commit(JDBCTransaction.java:106)
at org.springframework.orm.hibernate3.HibernateTransactionManager.doCommit(HibernateTransactionManager.java:584)
at org.springframework.transaction.support.AbstractPlatformTransactionManager.processCommit(AbstractPlatformTransactionManager.java:500)
at org.springframework.transaction.support.AbstractPlatformTransactionManager.commit(AbstractPlatformTransactionManager.java:473)
at org.springframework.transaction.interceptor.TransactionAspectSupport.doCommitTransactionAfterReturning(TransactionAspectSupport.java:267)
at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:106)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:170)
at com.service.impl.AuditLogMethodInterceptor.invoke(AuditLogMethodInterceptor.java:52)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:170)
at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:176)
at $Proxy172.raiseInteraction(Unknown Source)
at com.service.transfer.TransferEligibilityMembers.raiseEcInteraction(TransferEligibilityMembers.java:464)
at com.service.transfer.TransferEligibilityMembers.updateTerminationReasonAndStatus(TransferEligibilityMembers.java:372)
at com.service.transfer.TransferEligibilityMembers.updateMemberEligibility(TransferEligibilityMembers.java:339)
at com.service.transfer.TransferEligibilityMembers.updateOdsObject(TransferEligibilityMembers.java:731)
at com.service.transfer.TransferEligibilityMembers.updateOdsObject(TransferEligibilityMembers.java:64)
at com.service.transfer.TransferEntity.updateOds(TransferEntity.java:322)
... 58 more
2007-09-12 11:11:36,281 ERROR m.hibernate3.HibernateTransactionManager - TransactionSynchronization.afterCompletion threw exception
org.hibernate.SessionException: Session is closed!
at org.hibernate.impl.AbstractSessionImpl.errorIfClosed(AbstractSessionImpl.java:49)
at org.hibernate.impl.SessionImpl.reconnect(SessionImpl.java:379)
at org.springframework.orm.hibernate3.SessionFactoryUtils$SpringSessionSynchronization.afterCompletion(SessionFactoryUtils.java:981)
at org.springframework.transaction.support.AbstractPlatformTransactionManager.invokeAfterCompletion(AbstractPlatformTransactionManager.java:729)
at org.springframework.transaction.support.AbstractPlatformTransactionManager.triggerAfterCompletion(AbstractPlatformTransactionManager.java:701)
at org.springframework.transaction.support.AbstractPlatformTransactionManager.processCommit(AbstractPlatformTransactionManager.java:538)
at org.springframework.transaction.support.AbstractPlatformTransactionManager.commit(AbstractPlatformTransactionManager.java:473)
at org.springframework.transaction.interceptor.TransactionAspectSupport.doCommitTransactionAfterReturning(TransactionAspectSupport.java:267)
at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:106)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:170)
at org.springframework.aop.framework.Cglib2AopProxy$DynamicAdvisedInterceptor.intercept(Cglib2AopProxy.java:623)
at com.service.transfer.TransferEligibilityMembers$$EnhancerByCGLIB$$b1525510.execute(<generated> :wink:
at com.service.transfer.TransferManagerImpl.processEntity(TransferManagerImpl.java:208)
at com.service.transfer.TransferManagerImpl.transferDataFromEcToOds(TransferManagerImpl.java:196)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:64)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:615)
at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:287)
at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:181)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:148)
at org.springframework.remoting.support.RemoteInvocationTraceInterceptor.invoke(RemoteInvocationTraceInterceptor.java:68)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:170)
at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:176)
at $Proxy188.transferDataFromEcToOds(Unknown Source)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:64)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:615)
at org.springframework.remoting.support.RemoteInvocation.invoke(RemoteInvocation.java:179)
at org.springframework.remoting.support.DefaultRemoteInvocationExecutor.invoke(DefaultRemoteInvocationExecutor.java:33)
at org.springframework.remoting.support.RemoteInvocationBasedExporter.invoke(RemoteInvocationBasedExporter.java:76)
at org.springframework.remoting.support.RemoteInvocationBasedExporter.invokeAndCreateResult(RemoteInvocationBasedExporter.java:112)
at org.springframework.remoting.httpinvoker.HttpInvokerServiceExporter.handleRequest(HttpInvokerServiceExporter.java:82)
at org.springframework.web.servlet.mvc.SimpleControllerHandlerAdapter.handle(SimpleControllerHandlerAdapter.java:44)
at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:723)
at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:663)
at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:394)
at org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:358)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:615)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:688)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:178)
at org.apache.geronimo.tomcat.valve.DefaultSubjectValve.invoke(DefaultSubjectValve.java:56)
at org.apache.geronimo.tomcat.GeronimoStandardContext$SystemMethodValve.invoke(GeronimoStandardContext.java:342)
at org.apache.geronimo.tomcat.valve.GeronimoBeforeAfterValve.invoke(GeronimoBeforeAfterValve.java:31)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:107)
at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:541)
at org.apache.catalina.authenticator.SingleSignOn.invoke(SingleSignOn.java:392)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:869)
at org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:667)
at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:527)
at org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:80)
at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:869)
at java.lang.Thread.run(Thread.java:799)

16 years ago

Object Relational Mapping

Hibernate and a Table called [group] - problem

Hi Shailesh

Oh, it's much more serious than that. It would help if the test database I was using had a [group] table in the first place!

Sometimes my own stupidity amazes even me!

Many thanks

17 years ago

Object Relational Mapping

Hibernate and a Table called [group] - problem

Hi all

I need to model a table called group which, being an SQL keyword is giving me some problems.

My Group.hbm.xml file is defined as:

When I try and query the database, the following sql is produced

which falls over with the exception message

If I run the sql against the database, it works fine!!

I've tried replacing the [] with backticks (``), the same eception is thrown.

There is also the problem that the query returns everything despite being given a QBE object with the composite keys filled in, but one thing at a time, eh?

17 years ago

Object Relational Mapping

Many-to-one mapping issue

Hi all

I'm writing a hibernate mapper for an existing database, and only need to use a handful of objects from this db.

When I run my test, I keep getting the following error:
Foreign key (FK5E0F67F881B2AA8:group [group_code]))
must have same number of columns as the
referenced primary key (group [ec_env,group_code])

The group.hbm.xml lookslike

The group model object & xdoclet tags looks like:

public class Group extends BillingObject implements Serializable{
protected final Log LOG = LogFactory.getLog(this.getClass());
private Boolean webBill;
private String groupNumber;
private String enviromentCode;
private Set<Bill> bills = new LinkedHashSet<Bill>();
private Set<CcRecipient> recipients = new LinkedHashSet<CcRecipient>();
/**
* @hibernate.set
* table="ccrecipient"
* lazy="true"
* inverse="true"
* cascade="all"
* @hibernate.key
* column="groupCode"
* @hibernate.many-to-many
* column="groupCode"
* class="com.model.billing.CcRecipient"
*/
public Set<CcRecipient> getCcRecipient() { return this.recipients; }
public void setCcRecipient(Set<CcRecipient> recipients) { LOG.warn("adding recipients to Billing database is disabled"); }
public void addCcRecipient(CcRecipient recipient) {
LOG.warn("adding new recipient to Billing database is disabled");
}
/**
* @hibernate.set
* lazy="true"
* inverse="true"
* cascade="all"
* @hibernate.key
* column="groupCode"
* @hibernate.one-to-many
* class="com.model.billing.Bill"
*/
public Set<Bill> getBills() { return this.bills; }
public void setBills(Set<Bill> bills) { LOG.warn("adding bills to Billing database is disabled"); }
public void addBill(Bill bill) {
LOG.warn("adding new bill to Billing database is disabled");
}
/**
* @hibernate.composite-id
*/
public String getEnviromentCode() {return enviromentCode;}
public void setEnviromentCode(String enviromentCode) { this.enviromentCode = enviromentCode;}
/**
* @hibernate.composite-id
*/
public String getGroupNumber() {return groupNumber;}
public void setGroupNumber(String groupNumber) {this.groupNumber = groupNumber;}

The composite key of group is a foreign key of two other db objects that I haven't modelled, could this be the issue?

17 years ago

Object Relational Mapping

parameter not set!

I am missing something here in

infoCriteria.add(in(PROP_GROUP, groups));

where is the "in" method? Is that a method you have implemented, or something that is coming from a static import? And if you implemented it what does it look like.

Yes, it was a static import from the Restrictions class.

I could have implemented it myself, but it would have been awful....

17 years ago

Object Relational Mapping

parameter not set!

Sorted it myself.

I'd tell you, but owing to your reticence, you don't deserve to know.

17 years ago

Object Relational Mapping

parameter not set!

Hibernate is driving me crazy.

Model class (informationDisplay.java):

daoHibernate class

if I comment out the line infoCriteria.add(in(PROP_GROUP, groups));, everything works as expected. Leaving it in throws it all over the place:
1) sql error stating parameter #2 has not been set - eh?
2) the id of the Group object contained in the group set looks like it is being used to search the id of Information_Display - it should be set to the GROUP_ID of GROUP_INFORMATION_DISPLAY. I thought Hibernate took care of this.

Can anyone help. I've been battering my head against this wall all afternoon, in which time I could have JDBC'd half the bloody universe!!!

17 years ago

Object Relational Mapping

IDE for Sql Server

Any recommendations?

Query Analyser I have found to be a primitive piece of rubbish.

I've tried Squirrel-Sql, and although it supports nifty functions (like code complete, returning metadata and rowcounts) it has the annoying habit of endlessly writing to its heapdump logfile until I kill the process if it encounters errors / sql statements that generate large result sets. These errors can be as simple as the connection to the DB no longer existing. Latterly I tried an outer join on two table with 1 million+ rows apiece. THis should be manageable, yes?

Help!

17 years ago

JDBC and Relational Databases

Websphere 6 / RAD: what versions to use?

Hi

We are possibly upgrading to Websphere 6.1 from WS 5.1.1.10, and I need some advice.

Our production and UAT / Staging environments will at some point require vertical and horizontal scaling for redundancy and failover. From my brief look , it would appear that we'll need WebSphere� Application Server Network Deployment V6.1

Our other test environments are Sys and Dev. A fully scaled Application Server environment seems here to be overkill, as at this point we're testing the business logic, so some other (less expensive!) Websphere option would seem to make sense. As there is potential for a number of projects to be on the go simultaneously, we'll need numerous instances of the Application Server each containing different instances of the middleware (which would ultimatley be merged at UAT prior to release). Would this point us to licences for IBM� WebSphere� Application Server, V6.1 as a less heavyweight version of the networked edition? Is it too simplistic to think of using the Community Edition for development? And if we use the Community Edition, we can run it inside Eclipse, avoiding the purchase of WS6.1 version of WSAD.

Having the full Network Deployment option across all environments seems like overkill to me, and would also be prohibitivly expensive. Our hardware is set out as follows:

Prod: 2 Servers, Dual 3.8GHz processor(HS20), 4Gb Ram, 40Gb Disk
UAT: Virtual Server x2, LS41 Quad AMD Opteron,
SYS: Virtual Server, HS20 Dual Processor, 2Gb Ram, 40Gb Disk
DEV: Virtual Server, HS20 Dual Processor, 2Gb Ram, 40Gb Disk

Any recommendations gratefully received!

17 years ago