startNetworkServer: java.net.BindException: Cannot

assign requested address To: derby-user@db.apache.org MIME-Version: 1.0 Content-Type: multipart/alternative; boundary=0-148336698-1202612035=:41623 Message-ID: [EMAIL PROTECTED] --0-148336698-1202612035=:41623 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding:

derby databse connection in Hibernate

I try to connect derby database using Hibernate. But I got error like this. Exception in thread main org.hibernate.hql.ast.QuerySyntaxException: USERINFO is not mapped [FROM USERINFO] at org.hibernate.hql.ast.util.SessionFactoryHelper.requireClassPersister(SessionFactoryHelper.java:158)

Re: Iterating through large result set in network mode causes OutOfMemoryException

Yes, I meant the server. Sorry. But, it's my application that causes it (the server) to fail. The app? Your first posting indicated that the server ran out of memory. Also, the occasional commit is also causing a problem. I end up eventually getting this: java.sql.SQLException: The

Re: using SELECT as an SQL triggered action

somebody please help me here please!! please!! its urgent... musky wrote: i will make my aim more clearer here: i have created an AFTER insert trigger on a table called chattable which has two fields(ID INT,Message VARCHAR(255)).here is the trigger: CREATE TRIGGER insert_trigger AFTER

Re: Iterating through large result set in network mode causes OutOfMemoryException

Briggs wrote: Well, unfortunately, freeing the Blob didn't work, the app still runs out of memory. The app? Your first posting indicated that the server ran out of memory. Also, the occasional commit is also causing a problem. I end up eventually getting this: java.sql.SQLException: The

Re: Iterating through large result set in network mode causes OutOfMemoryException

Well, unfortunately, freeing the Blob didn't work, the app still runs out of memory. Also, the occasional commit is also causing a problem. I end up eventually getting this: java.sql.SQLException: The data in this BLOB or CLOB is no longer available. The BLOB/CLOB's transaction may be

Re: COUNT() optimisation

Daniel Noll wrote: I created bogus test data where jobid was always 0 and state was cycled between 0,1,2. Query: SELECT COUNT(*) FROM jobitems WHERE jobid = 0 AND state = 0 Given this particular query pattern I would say that increased times for larger tables makes sense. Since jobid is

Methods for upgrading database and application

Hi, I am currently working on converting our client/server application from an MS Access database to using Derby. We have approximately 40 sites that use our software and each one can have from 1 to 10 client computers that connect to the central database. The latest issue I have come across

Shutdown of embedded Derby server throws an SQLException?

Hi, I'm just starting to familiarize myself with the Derby Java API and I keep getting an Exception when I'm trying to shut down an embedded server using the following call: DriverManager.getConnection(jdbc:derby:;shutdown=true); Now, I was just looking at the SimpleNetworkServerSample demo