Re: USER-DEFINED CLASS FOR AUTHENTICATION

Hi Dan, Did you set derby.authentication.provider to the *full name* of a class that implements the public interface org.apache.derby.authentication.UserAuthenticator? full name which includes the various package names, etc. The user-defined authentication class that implements org.apache.derby.a

Re: setting encryptionKey attribute in jdbc url

nd(HEX_CHARS[high]); > sb.append(HEX_CHARS[low]); > } > > return sb.toString(); > } > > The results look like this > 4a63ea27b46504660cc3c6c2f22de1a35f3eabdc468cc6e64928b369c8ff1681 > Jc�'�e f -�_>��F���I(�i�� � > > Sorry to trou

Re: setting encryptionKey attribute in jdbc url

Hi George, key.getEncoded() returns a byte array that is a textual representation of the external key in Hex. Just Stringify the byte array and set it to the 'encryptedKey' JDBC connection URL attribute - that should work. Cheers, --Francois On Mon, Nov 30, 2009 at 10:45 PM, George H wrote:

Re: Database encryption

Hi George, Derby does decrypt or encrypt a database page or log record on the fly as it is loaded from disk into the buffer page cache or when flushing to the database / written to the log accordingly. As far as 'encryptionKeyLength', it is *now* documented as part of the latest Alpha documentati

Re: Need help installing

What error are you getting? posting it here would help diagnosing the problem... On Wed, Oct 7, 2009 at 12:29 PM, Addison Brickey wrote: > Hey, > I am having trouble using ij. I have installed derby following the > tutorial very closely countless number of times. Initially ij works. Then >

Re: Derby and Osgi

Hi Santiago, Yes, you can start/enable Derby's network server from a Java application by setting Derby's 'derby.drda.startNetworkServer=true' property. More info at: http://db.apache.org/derby/docs/dev/adminguide/adminguide-single.html#tadminconfig814963 http://db.apache.org/derby/docs/dev/adming

Re: multiple host/port with network client

Hi Nilesh, I'm not sure how the JDBC connection string you mentioned would have worked for you. As far as I'm aware, this is not supported by Derby - you should have gotten an ERROR 08001: No suitable driver exception. Maybe you are using a 3rd party product to achieve auto connection failover a

Re: Use Derby for an application which runs on CD?

Hi Sarah, Yes, you can have a Derby database as part of a ZIP / JAR archive and access it in read-only mode. More information below: http://db.apache.org/derby/docs/dev/devguide/devguide-single.html#cdevdeploy15325 In-Memory Derby storage is experimental in 10.5.x - Here you can read some docume

Re: Derby shutdown

Forgot to add that Yes, the documentation note should be fixed to mention that if authentication has been enabled, then you do need to authenticate in order to shutdown a Derby system. Thanks On Mon, Sep 14, 2009 at 3:52 PM, Francois Orsini wrote: > You have to set it _if_ you have defi

Re: Derby shutdown

You have to set it _if_ you have defined Derby's BUILT-IN user authentication at the System level (e.g. setting username / password in derby.properties file) versus having defined users at the database level (e.g. database-level properties) - note that both types of users are NOT exclusive, meaning

Re: Unable to create derby datasource

Hi, Is 'derby.jar' referenced as part of the CLASSPATH for Spring? If not, then it cannot find the embedded Derby driver ('org.apache.derby.jdbc.EmbeddedDriver') required to connect to an embedded Derby instance. Cheers --francois On Thu, Aug 13, 2009 at 7:23 AM, nagl wrote: > > Hi, > > I am

Re: Cant restart database because of orphaned lock ?

Hi Paul, Make sure to set the URL property 'shutdown=true' with a semi-colon ';' such as: "jdbc:*derby*:MyDbTest;*shutdown*=*true*"); If it is called correctly, then maybe check if you do not have another (orphaned) Java instance still accessing the database... Cheers --francois On Thu, Aug

Re: Monitoring Derby replication

Hi Alan, It would be great indeed. There is an enhancement JIRA (DERBY-3927) that requests similar type of functionality. Please feel free to add to it. Cheers, --francois On Wed, Aug 5, 2009 at 7:35 AM, Alan Burlison wrote: > Our site has go

Re: locking problem

Hi Robert, Your application is not setting some particular transaction isolation level _explicitly_ by any chance? http://db.apache.org/derby/docs/dev/devguide/cdevconcepts15366.html The default *value for derby.locks.waitTimeout* property is 60 seconds. http://db.apache.org/derby/docs/dev/devgu

Re: Using Derby with Microsoft Clustering Service

Err, You are right, Knut - I stand corrected. Forgot about this property - Thanks for catching it. On Tue, Jun 23, 2009 at 1:39 AM, Knut Anders Hatlen wrote: > Francois Orsini writes: > > > When you create a database with Derby, you can specify an absolute > database > >

Re: Using Derby with Microsoft Clustering Service

When you create a database with Derby, you can specify an absolute database location path as part of the JDBC connection URL; so you can place a database on a particular drive, whether it is a shared one or not. What you cannot do is place the database transaction journal log file on a separate dr

Re: Getting Started with Java DB

Hi David, I would recommend this tutorial if you are using Netbeans. http://www.netbeans.org/kb/docs/ide/java-db.html I think you maybe be missing the toursdb demo directory as I don't recall it being bundled with the appserver. What you could do is download a more recent version (10.5.1.1) of

Re: DB in temporary directory

Hi Kilian, You might want to use an in-memory DB if you don't need to preserve it across new instances... Derby's In-Memory instrumental feature has been added in 10.5.1 which is now available. To specify an in-memory DB, just add the 'memory' subprotocol before the database name, such as: conne

Re: Embedded Derby w/Hibernate

Hi Nicola, Here is an example of hibernate configuration file that operates in embedded more: http://indiwiz.com/2009/01/05/unit-testing-hibernate-code-with-derby/ Are you setting the Hibernate 'hbm2ddl.auto' config property at all? Once your schema is created and if you had 'hbm2ddl.auto=create

Re: Embedded Derby w/Hibernate

Actually you can have Hibernate take care of the DDL via the 'hibernate.hbm2ddl.auto=create-drop' property. You'll find more infor here: http://indiwiz.com/2009/01/05/unit-testing-hibernate-code-with-derby/ Cheers On Thu, May 21, 2009 at 5:46 PM, Donald McLean wrote: > Did you create the table

Re: Problems create SQL Function

Dacia, You don't need to include the source .java file(s) as part of the JAR archive, only the .class ones. Just FYI --francois On Tue, May 19, 2009 at 6:09 AM, dacia wrote: > > Got it ! :-p > > Create your java class in your favorit text editor. > Compile it (I do not know if this is really

Re: Good, thin, ORM layer

Hi, You can have a look at this distributed Java ORM client framework ( holchoko.org) that is making use of JPA + Derby: http://www.codespot.net/sessions/jazoon/2008.html You might find this interesting and it might suit your needs although it will very likely not satisfy your requirement in ter

Re: Derby on Tomcat server keeps setting itself to read only

How are you accessing Derby from the terminal? You mentioned that you are using IJ but are you opening an embedded connection to Derby or a client-server one? If one instance (a separate JVM process such as Tomcat) has already booted Derby, this last one will only be accessible in client-server mo

Re: Derby Stored Procedure Help!

To add on Rick's comments: Sivagururaja, In your code, you are loading Derby's "embedded" driver but your connection URL is to connect to a remote (server) Derby instance... If you want to connect to a remote Derby instance, you would have to load Derby's network client driver: "org.apache.derby.

Re: 10.4.2.1 release schedule

Hi Maxime, You can find daily development builds (JARs) from branches & trunk with tests results at: http://dbtg.thresher.com/derby/test/ IMPORTANT: The daily Jars are NOT suitable for production use. You should really wait for an official Derby release for that purpose. Cheers --francois On S

Re: COPY command

Hi Walter, You can also import data from a text file with comma-separated fields using Derby's SYSCS_UTIL.SYSCS_IMPORT_DATA() built-in procedure... CREATE TABLE TAB1 (c1 VARCHAR(30), c2 INT) CALL SYSCS_UTIL.SYSCS_IMPORT_DATA (NULL, 'TAB1', null, null, 'myfile.del',null, null, null, 0) With myfil

Re: Installation Problem With Apache Derby

Hi Amee, I believe Rick already answered on your previous and similar email. See http://www.nabble.com/Installation-problem-with-Apache-Derby-td22247294.html You may have missed it. Are you trying to build Derby? If you just want to install Derby (without building it from the source files), you

Re: Derby and third party products

mentions no > problem. As I wrote as reply to Dag's posting, I can update data with > ij. I tested it already with the latest OpenOffice version. Still the > same. Wired. > > Thank you, > Walter > > On Mon, 23 Feb 2009 11:30:58 -0800 > Francois Orsini wrote

Re: Derby and third party products

I set no specific permissions. Actually, everything is realised > by hibernate. I never made big modifications in OpenOffice. And when I > login with APP I'm still not able to modify data. > > Thank you for your help! > Walter > > > On Sun, 22 Feb 2009 13:57:02 -0800

Re: Derby and third party products

#x27;t set up any users for the db. I connect to it without > username and password. That is strange. > > Thank you, > Stephan > > On Fri, 20 Feb 2009 20:38:38 -0800 > Francois Orsini wrote: > > > Hi Walter, > > > > How did you set-up these permissions?

Re: Derby and third party products

erver. > > > > The issue is now, that my servlet has read-write permission and > > openoffice read-only permission. But it would be great if openoffice > > would be able to alternate content of the db too. > > > > Is that possible? Hope I could expresse

Re: Derby and third party products

is one issue left. How do I enable > openoffice to alternate the database too and not only my tomcat > servlet? I guess I have to set up multiple concurrency levels, but > where to specify those? > > Any help is much appreciated! > > Thank you, > Walter > > > On Mon, 1

Re: Derby and third party products

Hi Walter, You need to enable the Derby's instance running in TomCat to act as a server and allow remote connections. See http://db.apache.org/derby/docs/10.4/adminguide/tadminconfig814963.html(for turning on server mode) You would then be able to connect from an OpenOffice client using Derby's n

Re: How to Run Derby As a Windows Service

Hi Kevin, You can also look at this Derby WIKI page on how to set-up Derby to start as a window service with pointers to 3 alternatives (including srvany): http://wiki.apache.org/db-derby/DerbyWindowsService There is also additional information in the JIRA below on how to use tomcat5.exe as a 4th

Re: Using derby to parse an SQL statement

Dan had posted some interesting suggestion here as well: http://www.nabble.com/Use-SQL-parsing-to7595059.html#a7638751 On Wed, Nov 12, 2008 at 8:11 AM, Kristian Waagan <[EMAIL PROTECTED]>wrote: > Christian Riedel wrote: > >> Hi Rick, >> >> first of all thanks for your answer ... now the relations

Re: Derby and OpenOffice

Hi Walter, Which version of OpenOffice and Derby are you using? Which type of data are you trying to edit if I may ask. I just tried with OO 2.3 and Derby 10.4.2 and had no problem editing data within OpenOffice Base. I used OO Base query wizard. I used the ToursDB database which ships with Derby

Re: missing locale files?

The Rails track sounds like a very good one indeed, Scott. On Sun, Sep 28, 2008 at 5:02 PM, Scott Derrick <[EMAIL PROTECTED]> wrote: > Francois, > > The applet works even with the server complaining about missing locale > files. I think it has to do with Rail's. > > The complaints are being gene

Re: missing locale files?

Hi Scott, Did you ever find what was causing this? Is your applet working still despite the messages appearing in the web server log? Is the server complaining about other files besides modules.properties? --francois On Tue, Sep 16, 2008 at 1:01 PM, ScottDerrick <[EMAIL PROTECTED]> wrote: > >

Re: missing locale files?

Hi Scott, Can you run the original (non modified) DerbyTax demo just fine with the same browser client you are using for your prototype and verify it is working? http://developers.sun.com/javadb/demo/index.html Which derby.jar (version) are you using with your own run and which Java plug-in in th

Re: Transaction Storage

Hi Raymond, Have you increased the size of the Java heap (-Xmx JVM flag) for the process running Derby or are you running with the default value of 64MB (usually set on most platforms)? Otherwise you could try with a greater initial and maximum heap size such as: Java -Xms128m -Xmx128m (for an in

Re: Shutdown cleanly embedded derby when tomcat shutdown ?

Hello Albert, Have you tried *DriverManager.getConnection("jdbc:derby:;shutdown=true");* instead to shutdown the whole embedded Derby instance? Cheers On Thu, Jun 26, 2008 at 2:21 AM, Albert Kam <[EMAIL PROTECTED]> wrote: > Hello Derby .. > > Derby version : 10.4.1.3 > Tomcat version : 5.5.25 >

Re: org.apache.derby.client.am.SqlException: A lock

Hi Shaoyong, You can also look at the link below to find out how to debug some locking situations: http://wiki.apache.org/db-derby/LockDebugging Cheers, --francois On Wed, Apr 30, 2008 at 2:43 PM, Rick Hillegas <[EMAIL PROTECTED]> wrote: > Hi Shaoyong, > > For tips on how to avoid deadlocks, p

Re: ERROR 08000: Connection closed by unknown interrupt

On Fri, Mar 14, 2008 at 3:09 PM, Kathey Marsden <[EMAIL PROTECTED]> wrote: > Oystein Grovlen wrote: > > > > This means that the thread accessing the database have been > > interrupted. Do you have code that may interrupt running threads? > > > > In this particular case it happened while the threa

Re: Derby get-together at Java One

This sounds great, Rick. FYI, there is also the CommunityOne event (May 5) a day before JavaOne...I'll be giving a talk there about Derby. I believe ComunityOne registration is free if some of you are going to be around at that time: http://developers.sun.com/events/communityone/ Plenty of places

Re: Using derby as a chat server

On Wed, Feb 13, 2008 at 7:18 AM, Kurt Huwig <[EMAIL PROTECTED]> wrote: > Forget about Derby for chat and have a look at JMS. This is a good > implementation: > > http://joram.objectweb.org/ You can't compare Derby with JORAM. In a particular application such as a chat server, Derby would be used

Re: Using derby as a chat server

Hi Musky, Jean-Francois Arcand (Grizzly / Comet project lead) and myself have demo'ed a chat server application with Derby at ApacheCon US and JavaPolis. We are working on a more generic framework that we intend to make available as part of some open source project (sub-project of Grizzly very li

Re: SYSCS_UTIL.SYSCS_INPLACE_COMPRESS_TABLE and reindexing

I believe a full table scan updates the internal row count for that table but will not cause index cardinality (additional info) to be updated for each index on that table... http://db.apache.org/derby/docs/10.3/tuning/ctunstats848901.html http://db.apache.org/derby/docs/dev/tuning/tuning-single.h

Re: Derby v SQLite

David, Gears is a client side framework for web applications. If you have a Java application (be it client standalone, web or server) and you want to embed a database system and be able to port it across platforms, Derby makes a lot of sense (being 100% Java); It has a strong and active developmen

Re: crate and drop databases.

Hi Paulo, You'll find the information you need in the developers' guide, See 'Creating, Dropping, and Backing Up Databases' section: http://db.apache.org/derby/manuals/develop/develop13.html#HDRSII-DEVELOP-42173 Cheers, --francois On 10/26/07, Paulo Jesus <[EMAIL PROTECTED]> wrote: > > I have t

Re: Storing Java classes in a Derby DB

"Loading classes from a database" http://db.apache.org/derby/docs/dev/devguide/devguide-single.html#cdevdeploy30736 On 10/24/07, Daniel Jue <[EMAIL PROTECTED]> wrote: > > > But Derby already support class loading from a database, can't you use > that > > ? > Thanks Mikael! I didn't know that part

Re: DDL in Trigger Procedure

Sure. You can also add some context as well. On 8/21/07, Javier Fonseca V. <[EMAIL PROTECTED]> wrote: > > Francois, do you think that I should ask to the Derby-Dev mail list? > > On 8/21/07, Francois Orsini <[EMAIL PROTECTED]> wrote: > > > > Thanks f

Re: Password encryption in 10.3 by default?

That's correct. By the way, you can also configure the Derby server to only accept connections issued with a particular securityMechanism. See 'derby.drda.securityMechanism' network server property in http://db.apache.org/derby/docs/dev/adminguide/adminguide-single.html#tadminconfigsettingnetwrokse

Re: DDL in Trigger Procedure

// SQL data. } --francois On 8/20/07, Daniel John Debrunner <[EMAIL PROTECTED]> wrote: > > Francois Orsini wrote: > > Javier, > > > > I guess and I may be wrong that the main reason for not allowing DDL > > operation in a trigger is due to the fac

Re: DDL in Trigger Procedure

s that until someone determines a way to > > create a "plug n play" architecture of features, it becomes more important > > to decide if Derby is going to be a "full fledged" database, or a > > lightweight embedded database. > > > > > > > &g

Re: DDL in Trigger Procedure

Javier, DDL statements are not allowed in triggers, directly or via a procedure called from a trigger. I checked the codeline. --francois On 8/19/07, Javier Fonseca V. <[EMAIL PROTECTED]> wrote: > > Hello. I'm trying to do a trigger that fires after an INSERT INTO a > table. > > This trigger w

Re: Any problems to run derby in USB drive ?

Cool - let us know how it develops and how your application pans out at the end - This sounds quite interesting Ivan. On 7/11/07, Ivan Ooi <[EMAIL PROTECTED]> wrote: wow! Thanks guys! you guys did a lot of test on this as well. Look like I need to make sure user shut down the database properly

Re: Any problems to run derby in USB drive ?

Ivan, If you decide to run your application from an USB drive, try to make sure it is *unmount'ed* (on Unix) or software-safely removed on Windows properly, to ensure all data has been flushed to the USB drive. I have seen file checksum/corruption issues occasionally where removing a drive right

Re: Basic query on deploying embedded Derby

Hi David, Ragarding read-only databases accessible inside a ZIP/JAR file: http://db.apache.org/derby/docs/dev/devguide/devguide-single.html#cdevdeploy11201 Have you followed the instructions in the section from the URL above? Yes, you could have everything (derby.jar + your application logic cl

Re: User/password encryption and deployment

Yes, you might want to use STRONG_PASSWORD_SUBSTITUTE_SECURITY (8) since it does not actually send some encrypted password but a substitute based on Hashing and computation with values (seeds) exchanged with the client and the server. It works for Sun and IBM JRE's. Using SSL is duoable in 10.3 bu

Re: Users authentication - design problem

n, I plan to create a server side application (to keep track of many patients measurements in the hospital) and then I will probably use JavaCards (I would like to thank Mr Francois Orsini for pointing it out). Regards, Stanley

Re: Users authentication - design problem

On 5/31/07, Luan O'Carroll <[EMAIL PROTECTED]> wrote: I'm doing something similar with a business application. There's nothing stopping the user "accidentally" deleting the data on the local machine either. If the password is held in the software then it is insecure and can be easily cracked.

Re: Password Authentication Failure

Dan, The error you posted is not an authentication failure one but It would be great to get more info - The default schema is 'APP' when no user name (or 'APP') is passed to connect to Derby. Are you trying to access some tables which have not been created yet - That would cause this error to be

Re: Embedded thread taking 100% cpu

On 5/18/07, Adam Bovill <[EMAIL PROTECTED]> wrote: Well, I cannot attest to forever, but they have been running at 100% for the last 8 hours. It happens after repeating these steps for 2-4 hours. Is there a way to trace all of the actual commands that are sent to the db? I can also provide m

Re: can't delete table

er mode. If lock is the cause of the problem, how can I release the lock? Francois Orsini wrote: > > How are you accessing Netbeans from Netbeans? in Embedded or Client-Server > mode? You might want to check derby.log file to see if there is any > stacktrace(s) relevant to this error..

Re: maxrows - what does it really mean?

t we did in jConnect for example. When this limit actually occurs could depend on how the backend applies it and the type of query (for example if you have a sort specified)... Francois Orsini wrote: I thought it would not as it is bound to the resultset (client-side) versus actual proces

Re: can't delete table

How are you accessing Netbeans from Netbeans? in Embedded or Client-Server mode? You might want to check derby.log file to see if there is any stacktrace(s) relevant to this error...Also, are you by any chance accessing the same database from some other Derby instance? there should be a lock file

Re: maxrows - what does it really mean?

7, Lance J. Andersen <[EMAIL PROTECTED]> wrote: yes, most databases have a way to do that, my point was that the syntax below is not portable... so the driver via setmaxrows() should address that. Francois Orsini wrote: Right but most if not all RDBMS support a form of LIMIT. It may be non standar

Re: maxrows - what does it really mean?

You can add MS SQL-Server and Sybase, as well as some more RDBMS. This is a feature that is required a lot by IDE's, since they need to manipulate data and metadata a lot more than other types of client applications... On 5/14/07, Bernt M. Johnsen <[EMAIL PROTECTED]> wrote: Lance J

Re: maxrows - what does it really mean?

Right but most if not all RDBMS support a form of LIMIT. It may be non standard but support is there. On 5/14/07, Lance J. Andersen <[EMAIL PROTECTED]> wrote: Also, there are not a lot of DBs that support that syntax... :-( David Van Couvering wrote: > Thanks for the tip, Bernt, but I must hum

Re: Executing command from a file via JDBC

You mean like feeding some script(s) to IJ connected to a Derby instance: http://db.apache.org/derby/docs/dev/tools/tools-single.html#ttoolsij98878 Not sure if that's what you're asking for On 5/10/07, Raymond Kroeker <[EMAIL PROTECTED]> wrote: I was wondering if anyone knows of a way I ca

Re: SQuirrel SQl Client not connect my derby database

Has Derby been started in server mode? if not then you might want to connect to an embedded Derby instance running in the same space as SQuirreL. You would then need to use a different URL for that such as: jdbc:derby:sample Hope this helps On 5/4/07, mfa <[EMAIL PROTECTED]> wrote: sir i ins

Re: query execution plan..

http://db.apache.org/derby/docs/dev/tuning/tuning-single.html#ctundepth37648 http://db.apache.org/derby/docs/dev/tuning/tuning-single.html#ttundepth33391 Sounds like Army did look at some of the plans you posted...please keep asking any more info you need as this all gets recorded and will be use

Re: IJ ERROR: Unable to establish connection

Les, I take it you used a connection URL such as: Such as in IJ: D:> java org.apache.derby.tools.ij ij> connect 'jdbc:derby://localhost:1527/TheDBName'; ij> There should be some ij.ksh/bat files available as part of the application server too...loading the appropriate classes to connect to a

Re: give me derby gui link (how i add new table in derby

I would recommend using SQuirreL as a GUI interaction tool for Derby - more info here: http://db.apache.org/derby/integrate/SQuirreL_Derby.html On 5/2/07, Bryan Pendleton <[EMAIL PROTECTED]> wrote: > sir how i add new table in derby database > and please send me derby gui software or link You

Re: Derby in JEE appserver

Jim, Taking the Tomcat example, you would need to change the driver class name to point to the Derby Network Client One: driverClassName="org.apache.derby.jdbc.ClientDriver" and the JDBC connection URL to" url="jdbc:derby://localhost:1527/JPetStoreDB" (if derby server runs on same host and defau

Re: Security in Derby

Hi Laura, Actually, it is pretty good as a start but I think we need to document more connection URL attributes - At least for the ones we have not provided any examples yet. Thanks, --francois On 2/20/07, Laura Stewart <[EMAIL PROTECTED]> wrote: On 2/20/07, Francois Orsini &

Re: Security in Derby

To add on Andrew's excellent info: You can also configure the Derby network server to only accept connections with secure authentication, by setting the derby.drda.securityMechanismserver property. http://db.apache.org/derby/docs/dev/adminguide/adminguide-single.html#tadminconfigsettingnetwrokse

Re: persistence, derby and Database instance

If Derby is running embedded or in client / server mode, you can access the engine instance with the proper JDBC driver. Note that you could also perform an Online Backup as Derby 10.2.x does support this capability: http://db.apache.org/derby/docs/dev/adminguide/cadminhubbkup01.html So it all de

Re: keeping the table ordered

On 2/6/07, Nurullah Akkaya <[EMAIL PROTECTED]> wrote: for who ever searches these archives creating a composite index that includes all the columns i query solved the problem. i can read 2.7million records in 11 seconds another query that selects around 800k records dropped to about 4 secs.

Re: log size

It is not documented but if you want a bit more (internal & technical) details: http://db.apache.org/derby/javadoc/engine/org/apache/derby/impl/store/raw/log/LogToFile.html http://www.nabble.com/Can-anyone-give-me-some-suggestions--t232047.html On 2/5/07, Olav Sandstå <[EMAIL PROTECTED]> wrote:

Re: does derby provide SQL access management (grant and revoke permission)

On 2/1/07, legolas wood <[EMAIL PROTECTED]> wrote: Manjula G Kutty wrote: legolas wood wrote: Hi Thank you for reading my post. Does derby support permission management for users ? for example can i define some users and then grant them some permission? Thanks Yes , The latest Release 10.2

Re: Some design related questions about using derby embedded mode.

On 1/22/07, Daniel John Debrunner <[EMAIL PROTECTED]> wrote: > - However, you will bypass some > of the JDBC layer(s) as the stored procedure will run inside the > database spectrum in theory, with direct access to data, not requiring > the use of JDBC for that JDBC is the api used to access d

Re: Some design related questions about using derby embedded mode.

Hi Legolas, Hope you find some of the answers below: 1) We need highest performance, Should we use stored procedure? Writing and running stored procedures in Java allows you obviously to run Java logic within the same JVM as the Derby DB core engine - If your application runs Derby embedded, yo

Re: Derby row locking semantic

Correct - That is actually how Sybase ASE behaves (non-MVCC model). On 1/18/07, Øystein Grøvlen <[EMAIL PROTECTED]> wrote: I think most database systems that do not have multiversion concurrency will behave as describe. When a scan encounters a exclusively locked row, it will generally not

Re: Testing Derby

You'll find some interesting information in the thread below: http://www.nabble.com/Running-Derby-as-a-Service-t279837.html#a785986On 9/15/06, Macias De La Rosa Jesús Gerardo <[EMAIL PROTECTED]> wrote: Hallo,   I'm using and testing Apache Derby und I'm missing a Service under Wind

Re: Retreive colummn name of a table from java

On 9/15/06, Lance J. Andersen <[EMAIL PROTECTED]> wrote: Francois Orsini wrote: All the Derby database system tables reside in the 'SYS' schema whereas the default "user" schema is named 'APP'. When you log in to derby, the default schema where the ob

Re: Retreive colummn name of a table from java

ns information (http://db.apache.org/derby/docs/dev/tools/rtoolsijcomrefdescribe.html). If you want to try out the 10.2 beta version of Derby - You can find it here: http://wiki.apache.org/db-derby/TenTwoSnapshot Le vendredi 15 septembre 2006 à 00:08 -0700, Francois Orsini a écrit :> All the Der

Re: Retreive colummn name of a table from java

against any particular schema, hence it picked it up.On 9/15/06, yves pielusenet < [EMAIL PROTECTED]> wrote:Thank you Francois :)It works with that schema. but what is the difference between APP and SYS ?And the result is the same as my statement. Is my own wrong ?Le jeudi 14 septembre 2006 à 23:

Re: Retreive colummn name of a table from java

- 0 lignes sélectionnéesLe jeudi 14 septembre 2006 à 15:37 -0700, Francois Orsini a écrit :> Have you tried the following below?>> ij> select columnnumber, columnname, columndatatype >from sys.systables t, sys.syscolumns, sys.sysschemas s>where tableid=referenceid an

Re: Top 1 - Limit 1

On 9/14/06, Marl Atkins <[EMAIL PROTECTED]> wrote: This would only work if the ID field is an Identity.As it happens, it IS so this should work for me too.THREE answers to my problem. That's one of the nice aspects of  Open Source You get Open Assistance :) or Open Support however you want to call

Re: Retreive colummn name of a table from java

Yes, It all depends how you created the table - have you tried running the query by specifying you table name in uppercase such as: j> select columnnumber, columnname, columndatatype    from sys.systables t, sys.syscolumns, sys.sysschemas s    where tableid=referenceid and t.schemaid=s.schemaid   

Re: Retreive colummn name of a table from java

ll for me :)do you see something wrong ?Le jeudi 14 septembre 2006 à 15:16 -0700, Francois Orsini a écrit : > Yes,>> It all depends how you created the table - have you tried running the> query by specifying you table name in uppercase such as:> j> select columnnumber, columnna

Re: Connection problems

Hi Marl, Could you please post the exception you're getting when attempting to connect to the database. This would help to diagnose a bit more definitely. You should be able to open concurrent derby connections - Are you running Derby embedded or in a client-server topology? Am assuming it is emb

Re: derby security

and make sure to re-boot the database or derby instance for the 'derby.connection.requireAuthentication' property to be taken into account...It is a static property.On 8/29/06, Fernanda Pizzorno <[EMAIL PROTECTED]> wrote: To enable user authentication in Derby you must set the/derby.connection.requ