Re:

I finally met my satisfaction business company: buyto360.com , high quality products, heavy discounts, friendly service, fast delivery, and it is really long-awaited product when I open the package.

Re: Persistence API can't find DB

[EMAIL PROTECTED] wrote: Resolved - The derby.system.home directory was incorrectly defined. do you used derby.system.home in a properties object ? can you post the code snippet here. Michael [EMAIL PROTECTED] 10/07/2006 01:03 PM Please respond to Derby Discussion To:

how to make a replication between mysql and derby?

Hi thank you for reading my post how i can create a replication between mysql as master and derby as details. the situation is like this : we insert some records into some Mysql tables then at certain point in time we need to add all those record to Derby databases. any general tutorial or manual

any sample in using derby as a database in mobile phones ?

hi thank you for reading my post is there any sample or tutorial about using Derby in a j2me application on mobile phones like motorola or nokia? Thanks

Problem with sql statement , can some one help me to get count of a complex select ?

Hi Thank you for reading my post. i really tried to get count of rows that this statement return with no luck. SELECT * FROM categories WHERE categories.categoryid NOT IN ( SELECT DISTINCT categoriescategoryid FROM BANNER_categories WHERE BANNERBANNERID = 10) if we think this

Re: Spawning Data on Multiple Directories

Rodrigo Madera wrote: Hello to all, I was wondering how can I span Derby's Database on multiple disks. For example, if I were to use: - C:\Somewhere\Derby1 40 GB - D:\ANicePlace\Derby2 20 GB - F:\Looking\Good\Dir\Derby315GB Is this possible? Thanks for any input, Rodrigo hi

Is there any plan for a newer release for derby ?

I looked at the download page and latest download is from 2005 , is there any new version scheduled ? Thanks

Re: Can derby instances be clustered ?

Sent: Tuesday, April 25, 2006 6:33 PM To: Derby Discussion Subject: Re: Can derby instances be clustered ? Legolas Woodland wrote: Hi Thank you for reading my post. can derby instances be clustered together ? can some one lead me to some resources or steps to cluster two instance o

Can derby instances be clustered ?

Hi Thank you for reading my post. can derby instances be clustered together ? can some one lead me to some resources or steps to cluster two instance of derby which i run on my own computer ? Thanks

Re: how to apply transactional insert is a scenario that 3 tables are going to change?

Oystein Grovlen - Sun Norway wrote: Legolas Woodland wrote: Hi thank you for reading my post How i can apply transaction in a scenario like this : In one of my web applicatinon page , i have 3 functions that each of them update/insert data to a table I use connection pool to retrieve

how to apply transactional insert is a scenario that 3 tables are going to change?

Hi thank you for reading my post How i can apply transaction in a scenario like this : In one of my web applicatinon page , i have 3 functions that each of them update/insert data to a table I use connection pool to retrieve a connection in each of those functions (i can use one connection

How to find master record primary key to use it in inserting details records

Hi Thank you for reading my post I have two tables which are related to eachother using a column (master details) my problem is that master table primary key is auto increment so when i insert a recoed to it i can not determine the primary key value so i do not know the key , Now my problem is

Re: Java DB now available

Congratulation for a new product release. What is benefits of Sun DB over Derby ? does sun adds some values to its own distribution ? if yes , then what are those enhancement / new features. Thanks David W. Van Couvering wrote: Good news for Apache Derby - another Big Company has gotten

Where i can find sql-99 and sql-2003 standard ?

Hi Thank you for reading my post. where i can find sql-99 and sql-2003 standards ? author has use them in his paper. http://wiki.apache.org/db-derby/SQLvsDerbyFeatures thanks

Re: Where i can find sql-99 and sql-2003 standard ?

Bernt M. Johnsen wrote: Legolas Woodland wrote (2006-03-04 13:38:00

Re: Using/Adressing a row number in a SELECT query

vote on its jira entry or create a jira entry for it. However, the datas persisted in my DERBY database concern logging. It means that i would have to get thousands of records. On 2/17/06, Legolas Woodland [EMAIL PROTECTED] wrote: Sylvain RICHET wrote: Hi everyone

Re: Using/Adressing a row number in a SELECT query

ra entry i will vote for it. Thanks On 2/17/06, Legolas Woodland [EMAIL PROTECTED] wrote: Sylvain RICHET wrote: Thanks Legolas, ... but limiting the fetch size by JDBC API supported methods (setFetchSize) implies that i have already loaded ALL records from database, no ?

Re: Using/Adressing a row number in a SELECT query

Sylvain RICHET wrote: Thanks Legolas, for your explanations. You are welcome. it was my first time that i could help a member in mailing list so far i just request for help in past days. now i am happy ;-) On 2/17/06, Legolas Woodland [EMAIL PROTECTED] wrote: Sylvain RICHET wrote

Is there any graphical tools , able to construct derby query plans ?

Hi Thanks for reading my post I searched the web site and did not find any helpful entry , so i post here. Is there any tools capable to show Derby query plan in a graphical mode , something like What another member posts ? (that was for DB2) I should optimize my queries (Im not an expert and

Re: Can some one compare Ingres 2006 and Derby ?

: Legolas Woodland wrote (2006-02-14 01:21:39): Hi Thank you

how to insert some custom value in anidentity field

Hi Thank you for reading my post. I have a table with one identity column , so Derby will generate a value for this column in evry insert. what should i do if i need to make some record with customized ID ? for example i want my admin user to have id=1 ? how i should insert it ? Thank you

Re: Deby create LOCK on my table and do not release it , what is my mistake ?

Hi Thank you for such complete post. I have the problem yet and i could not solve it until now. It will be good is some one with more experience look at this problem and provide some tips to solve this problem. Thank you Klas U. wrote: Dear all, I've got a similar Problem with Derby locks

Re: Developing a UI for Derby

Raj Saini wrote: On 1/27/06, duminda [EMAIL PROTECTED] wrote: Hi, What does the community most wanted, Eclipse or Stand alone?. Developing on Eclipse will have many advantage. 1. Eclipse already have Derby support in WTP project. You can reuse lot of code from

How i can Dump a derby database into an sql file ?

Hi Thank you for reading my post. how i can dump a derby database into a sql file for later use? I mean i dump a database into sql file and give it with my application to users , they can import it into thier database and make all structure and date.

Re: How i can Dump a derby database into an sql file ?

Jean T. Anderson wrote: Legolas Woodland wrote: Hi Thank you for reading my post. how i can dump a derby database into a sql file for later use? I mean i dump a database into sql file and give it with my application to users , they can import it into thier database and make all structure

How i can have a timeStamp wich point to 30 days ago

Hi Thank you for reading my post how i can create a timestamp which point to 30 days ago ? i mean a java.sql.Timestamp which point to 30 days ago , from current date.

Deby create LOCK on my table and do not release it , what is my mistake ?

Hi Thank you for reading my post. I have an update statement which i execute over a table in my database. now when i execute the update statement from my application (even after i exit the method that update the table) i can not use select statement over the same table. here is my update

When we run derby , in console window it show some connection numbers , what are them ?

Hi Thank you for reading my post. I defined a datasource and connection pooling in my web application. maximum size of pool is 32 , after some times that i deploy-undeploy the application in development environment , derby console windows show which after starting shows connection numbers ,

Re: What is wrong with this sql script , im sure that it is ok , but derby return error.

ystein Grvlen wrote: "LW" == Legolas Woodland [EMAIL PROTECTED] writes: LW Hi LW Thank you for reading my post. LW can some one please check and see what is wrong with th

Re: How to select a random record.

and a generated random number. Syntax for creating procedures: http://db.apache.org/derby/docs/10.1/ref/rrefcreateprocedurestatement.html Example: http://www-128.ibm.com/developerworks/db2/library/techarticle/dm-0408anderson/#cs_sp Hope the above helps. -Rajesh On 12/25/05, Legolas

can you help me to solve a query problem which 3 tables are engaged in it?

Thank you for reading my post I have 3 tables like the above images a web sites , a category and a relation between them. I defined a relation between web sites and categories in table website_categories so if a web site incoperate in a category then its id with category id will be there I

What is diffrence(es) between derby.system.home and DERBY_INSTALL ?

Hi Thank you for reading my post. i find that we have two variable for derby directories , one which we use during installation and one which is good for Tuning now i want to ask what their differences and /or similarities

Re: What is diffrence(es) between derby.system.home and DERBY_INSTALL ?

Bryan Pendleton wrote: [EMAIL PROTECTED] wrote: 2 3. I have not used derby.properties file but I would assume this file would be in the folder specified by derby.system.home. In my example it would the derbydata folder. The network server does nothing other than delegate

How i can execute a file containing some sql script with ij ?

Hi Thank you for reading my post. how i can execute an sql file againts a derby database using ij? right now Im using DB-VA , from visual paradigm , which is a free tool . but i think it brings th above problem that i post. thank you.

Re: Where does Derby create Databases ? is there any default home like mysql ?

Jean T. Anderson wrote: Legolas Woodland wrote: Hi Thank you for reading my post. Where derby create each database directory ? By default a database gets created in the directory where the application was started. This link shows how to specify the full path to the database, how to set

Re: How to select a random record.

for this SELECT TOP 1 someColumn FROM someTable ORDER BY NEWID() this sql will return a random record. i need something like this , if it is possible. Thank you again. -Rajesh On 12/25/05, Legolas Woodland [EMAIL PROTECTED] wrote: Hi Thank you for reading my post. I have a Product table

How to select top n record

Hi Thank you for reading my post. how i can select top n record of a table ? i tried Select Top 10 from Leg //not works select *from leg limit 10 //not works is there any syntax in derby sql for selecting top n , or an offset of a table ?

Where does Derby create Databases ? is there any default home like mysql ?

Hi Thank you for reading my post. Where derby create each database directory ? It looks that there is no standard data directory (like mysql ) I tried to build database with Netbeans Database manager , it placed database somewhere in netbeans home i tried to build using IBM derby workbench ,

How to select a random record.

Hi Thank you for reading my post. I have a Product table and a category table. some of products exists in more than one category. I should select a random product from product table (a record) and it should be from some certain categories. Now the question is : What is best solution to select

Re: I need advice for Table schema Design.

[EMAIL PROTECTED] wrote: Legolas Woodland wrote: Hi Thank you for reading my post. I need your advice for a design/query problem. Scenario : Imagine that i should design a system which should be able log and process view / hit over banners. So , in some portion of time there is a high rate

A design question about logging hi volume of clicks into file or DB...

Hi Thank you for reading my post. I have a big design question : i should log about 200,00 - 1.5M click that i receive for our web based (banner management) a day and then process them to find unique clicks , each banner clicks , each advertiser clicks and save them into databases to

Re: Does any one has experience with both derby and Mysql ? performance comparesion

Please can some on share his/her knowledge about this item. It will help me so much to complete my job. On 11/17/05, Legolas Woodland [EMAIL PROTECTED] wrote: Hi Thank you for reading my post. does any one has don a ttest to compare both Mysql and derby , in regard to Tra/second or insert

Does any one has experience with both derby and Mysql ? performance comparesion

Hi Thank you for reading my post. does any one has don a ttest to compare both Mysql and derby , in regard to Tra/second or insert/select statement execution time ? I had chance to use mysql 5 or Derby for a 20-30 tra/second application . now which one is better to user , and perform better for

Is it possible to restrict access to derby from Localhost ?

Hi thank you for reading my post is it possible to restrict accessing to derby network server and allow just local user to connect to it ? i need this feature to give the host admin insurace that no one will blow his server by using my database server. i think mysql has this future which does not

Derby and Hibernate , where i can find derby Dialect for hibernate

Hi Thank you for reading my post. where can i find derby dialect which allows me to use Derby with hibernate ? i could not find it in http://www.hibernate.org/hib_docs/v3/reference/en/html_single/#configuration-optional-dialects Thank you

any manual or howto to convert mysql database structure to derby

Hi Thank you for reading my post. I am looking for a how-to or manual which help me to convert a Mysql database structure to derby one. do you know any? Thank you so much

Re: how to use schema names , it allways return error for me.

? On 11/6/05, Myrna van Lunteren [EMAIL PROTECTED] wrote: On 11/5/05, Legolas Woodland [EMAIL PROTECTED] wrote: hi Thank you for reading my post. i tried to execute following statement but it return the exception that the table does not exists , i tried several cobination of and ' around

Re: how to use schema names , it allways return error for me.

do not know how i can have something like 2 as an String variable to pass it to sql Statement or preparedStatement. can some one help me about it ? On 11/6/05, Michael Segel [EMAIL PROTECTED] wrote: On Saturday 05 November 2005 17:04, Legolas Woodland wrote: hi Thank you for reading my post. i

Re: I need some advice to choose database for an upcomming job

. can you explain more pleas ? (to Oyvind Bakksjo) Thank you On 10/31/05, [EMAIL PROTECTED] [EMAIL PROTECTED] wrote: Jean T. Anderson wrote: Legolas Woodland wrote: Thank you for references I read the article of embeding Derby into Tomcat but in my case i have no full accessto server to stop

how to use schema names , it allways return error for me.

hi Thank you for reading my post. i tried to execute following statement but it return the exception that the table does not exists , i tried several cobination of and ' around the schema and table name with no luck. INSERT INTO APP.table2( data, data2 ) VALUES ( ?, ? ) This statement return

I need some advice to choose database for an upcomming job

HiThank you for reading my postI should design and implement an application which is going to run on tomcat 5.5 and Database can be one of derby ,sqlServer , Mysql.Problem is that this application should be able to have about 15 -20Transaction in 1 second .They have no extra power servers , just

Re: I need some advice to choose database for an upcomming job

(into lib folder) and use it as embeded DB server ? Thank you. On 10/29/05, Jean T. Anderson [EMAIL PROTECTED] wrote: Legolas Woodland wrote: Hi Thank you for reading my post I should design and implement an application which is going to run on tomcat 5.5 and Database can beone of derby ,sqlServer