Re: advice for client/server application

> > I was wondering about that. > Derby does support IO Streams so you could do that. > But this sort of begs the question... why store the file in the database? > > If you look at content management solutions from companies like IBM their > solutions are based on storing the file's meta data wi

Re: advice for client/server application

if the problem is to move files, you can do this with blobs? you can have a stored procedures that will save, read file on the server best regards, Slavic Ryan P Bobko wrote: > Thanks for the advice, but I'm not sure if that will help. I now realize what > makes me uneasy about my architecture

Re: advice for client/server application

java.sql.Statement public void setFetchSize(int rows) throws SQLException Gives the JDBC driver a hint as to the number of rows that should be fetched from the database when more rows are needed for this ResultSet object. If the fetch size specified is zero, the JDBC driver

Re: Developing a UI for Derby

how much non programmers look directly in derby? derby is a tool for programmers, programmers are users of derby (see their applications) users use applications no need for a derby specific gui, derby expose SQL and jdbc interface, which are standard best regards, Slavic Andrus Adamchik wrote

Re: Developing a UI for Derby

for DBA, developper, eclipse it's a lot of work to do in eclipse plug-in best regards, Slavic duminda wrote: > Hi, > > What does the community most wanted, Eclipse or Stand alone?. > > > Duminda > > > - Original Message - > *From:* Satheesh Bandaram

Re: ResultSet holdability

acquired during the unit of work are released. best regards, Slavic Dag H. Wanvik wrote: > Hi, > > Veaceslav Chicu wrote: > > : > >>if I have an exception in my procedure, first resultSet will close? >>normaly in my client application I shoud reexecute my

Re: ResultSet holdability

hello, thank you for answers I'm in embeded mode exception in procedure is created like this throw new SQLException("reason", "38002"); so if I look in my app I see sqlcode=38002 , severity=2 it close my result set best regards, Slavic Dag H. Wanvik wrote: &

ResultSet holdability

Hello, conn.setAutoComit(true); I have a unsensitive readonly result set: conn.prepareStatement(ResultSet.TYPE_SCROLL_INSENSITIVE, ResultSet.CONCUR_READ_ONLY, ResultSet.HOLD_CURSORS_OVER_COMMIT)) ... after that I execute a stored procedure: conn.prepareCall("{call procedure(?, ?, ?)}") ... if I

FK fields order

create table acc.account ( account_id integer not null, plan_id integer not null ); create table acc.trans ( plan_id integer not null, credit_id integer not null, ); alter table acc.account add constraint account_pk primary key (account_id, plan_id); alter table acc.trans add constraint trans_cred

Re: trigger

Hello, thank you for reply I want an example for: http://db.apache.org/derby/docs/10.1/devguide/cdevspecial49460.html a trigger that throws an exception (if it's not difficult an example with catch also) best regards, Slavic Dag H. Wanvik wrote: >>>>>>"Veaceslav

Re: trigger

where I can read or find examples for triggers? thank you, Slavic Veaceslav Chicu wrote: > nobody know? > > best regards, > Slavic > > Veaceslav Chicu wrote: > >>Hello, >> >>how can I do that in derby?: >>CREATE TRIGGER acc.ins_doc NO CASCADE BEF

Re: trigger

nobody know? best regards, Slavic Veaceslav Chicu wrote: > Hello, > > how can I do that in derby?: > CREATE TRIGGER acc.ins_doc NO CASCADE BEFORE INSERT ON acc.doc > REFERENCING NEW AS N > FOR EACH ROW MODE DB2SQL > WHEN( > SELECT FROM period >

trigger

Hello, how can I do that in derby?: CREATE TRIGGER acc.ins_doc NO CASCADE BEFORE INSERT ON acc.doc REFERENCING NEW AS N FOR EACH ROW MODE DB2SQL WHEN( SELECT FROM period WHERE state='O' AND N.cdate BETWEEN date_start AND date_end ) SIGNAL SQL