-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
I tried using db2db, an open source JDBC data migration tool with Derby.
http://db2db.sourceforge.net/
(note the name stands for 'db to db', nothing to do with IBM's DB2)
db2db claims it can migrate tables from one database to another using
JDBC and
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Wes Johnson wrote:
Sure, it's below. Definitely not the greatest code in the world, but it
is the exact same code that I'm using to test HSQL.
Thanks!!!
A few notes on the test code.
1) Derby's ( Cloudscape's) connection will be in
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Zahra Zahid wrote:
Hi all,
This is the connection im using in my build.properties filesthe
database gets made but when some specific objects are 2 be loaded an
exception is thrown:
database=derby
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
robert stephens wrote:
I understand that the org.apache.derby.jdbc.EmbeddedDriver does not
support simultaneous connections to a Cloudscape database
Just to be clear, the embedded driver does support multiple simultaneous
connections from within
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Steven Buschman wrote:
Shreyas,
Thanks for the info. I'm new to this - I searched Derby's project and
couldn't find this as an open issue - am I missing something?
Another place to look for potential future features in Derby is the
to-do list.
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
I'm having trouble to set up a Derby service in ISQL viewer, has someone
already done that and could explain me how to do it?
thanks
Wellington Bengtson
I've been running iSQL-Viewer 2.1.8 with the proposed release for Derby
successfully.
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Kathey Marsden wrote:
Attached is the updated patch for Network Server XAMGR Level 7 support.
I think I am ready to call a vote on whether it is OK to check this in.
As soon as I can check it in, I will be able to coordinate the changes
to the
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Gaurav Anand wrote:
[DISCLAIMER - I (Dan) work for IBM and have been involved with
Cloudscape since its inception, most of the time as its architect]
Can any body help?
I am skeptical in using Derby because of its relationship with IBM
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Barnet Wagman wrote:
So perhaps I'm doing something
wrong. I've pretty much tried everything relevant in Tuning Derby and
I've tried varying all possibly relevant Derby properties. (I set
properties progarmmatically using the 'Properties info'
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Johny English wrote:
Hi folks,
I'm currently evaluating derby as alternative db for
my app, however I found in the docs that no
BIT/BOOL/BOOLEAN data type in derby. Am I missing it
out ? this is strange because in most database there
must be a
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
The constraint may be a good idea, but also getBoolean() will return
true for any non-zero value, not just 1.
Dan.
todd runstein wrote:
Also, be sure to add a check constraint to limit
entries to 0 or 1.
--- Kathey Marsden [EMAIL PROTECTED]
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Ken Yee wrote:
Anyone try this successfully?
There's a long thread on the Hibernate forum on how
someone tried it and got it to sorta work, but the
Hibernate authors are convinced Derby's SQL support is
too broken for it to work...
Could you
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Suavi Ali Demir wrote:
To clarify: You shoul NOT close the connection that
you get from the URL jdbc:default:connection. This is
not a new connection. This is the connection that your
stored proc or function is running in the context of.
It was
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Suavi Ali Demir wrote:
In the context of a stored procedure that is executing
though a sql statement that was executed using an
existing connection why would any database not be able
to return a reference to the current connection?
default
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Rajesh Kartha wrote:
Hello,
There may be other ways, but here is one - using functions, hope this
A simpler function, using the natural mapping of TIMESTAMP to
java.sql.Timestamp. Rajesh's function may have issues with timezone,
where the value
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Jean T. Anderson wrote:
Thanks for the info. Unless anybody has better suggestions, I'll add two
categories as shown below:
Web Application Framework
- Cocoon
- J2EE
- RIFE
You probably want to move J2EE to the Web Application Server section
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Samuel Andrew McIntyre wrote:
On Feb 3, 2005, at 12:29 AM, Andrew Kachalo wrote:
I use MacOS 9.1 with MacOS Runtime for Java 2.2.3 and CodeWarrior 7.1
Any version of MRJ is equivalent to a JDK 1.1.8 JVM, which is not
supported by any version
Jeremiah Jahn wrote:
Thoughts on this one? This follows the examples given in the replies exactly.
if (currentIteration %2 == 0){
insertPreparedStatement.setTimestamp(5,new Timestamp(new
Date().getTime()));
}
else {
insertPreparedStatement.setNull(5,Types.TIMESTAMP);
Jean T. Anderson wrote:
Bob Gibson wrote a developerWorks article that shows how to connect to
derby from jython:
http://www.ibm.com/developerworks/db2/library/techarticle/dm-0502gibson/
Jython's zxJDBC package provides functionality similar to the DESCRIBE
requested on this list for ij.
Jonathan Eric Miller wrote:
Thanks. I did notice that it loads the Derby driver by default. So, I
can get it to work with Derby and one other database driver using
ij.properties. But, I want to add a third database driver. I guess it's
more of an issue with the ij.properties file rather than
Eddie Murphy wrote:
Hi Bernd,
Thanks for the 1 liner but can you please elaborate on the features that
Derby has and Hsql and one$db don't. Have you tried all three..? If I
am not wrong then even one$db can work in server and embedded.
Here's my view on hsqldb
fabio_patricio wrote:
Hi,
I have a field decimal(10,2) where I insert 32,78, but when I go
to look at in the table the inserted value was 32,77, alguem which
the problem?
This is a bug Derby-123 and is fixed in the development trunk.
http://issues.apache.org/jira/browse/DERBY-123
The older version of the Derby web site always looked at little messed
up when I used Konqueror 3.1.4 on Suse 9.0 linux to view it. Typically
the tab of the left was formatted badly.
With the upgrade of the derby site it's become unusable under Konqueror,
any external link seems to be
Andrew Shuttlewood wrote:
Firstly, is it possible to authenticate server connections differently
from embedded connections? I wish embedded connections to have
substantially more rights than the network connections, and be able to
deny access to databases and restrict to read-only rights to
David Van Couvering wrote:
Ah, I see.
This of course begs the question of how hard it would be to put it back
in again if Derby users wanted it back in...
Some previous discussion
http://mail-archives.eu.apache.org/mod_mbox/db-derby-dev/200411.mbox/[EMAIL
PROTECTED]
Is one of the
Jean T. Anderson wrote:
The manuals originally contributed to Apache were comprised of html
source files that were replaced recently by files in the DITA XML format.
Document corrections have been applied only to the DITA XML files, which
means the old manuals are no longer up to date. To
Jean T. Anderson wrote:
As an alternative, I could add a link on
http://incubator.apache.org/derby/manuals/index.html that says Click
here for the old 10.0 manuals. On a new page I could provide navigable
links to the old 10.0 manuals and make it as clear as best I can that
issues must not
Paul Byford wrote:
hi,
i intend to deploy derby in embedded form as part of an application. to
protect the data i would like to use the disk encryption feature.
the issue i have is that for my application to have access to the
encrypted database data I must also deploy the bootPassword
Simon wrote:
Bad - One thing that concerned me greatly was the ambiguity around
whether the driver was going to be released - yes, amazing, but true -
originally the whole DB was redistributable as open source but not the
driver to access it!
To be fair the main (embedded) JDBC driver to
Chris wrote:
Hi,
i think i've found a bug in derby. i'm following the guidelines from
the website and posting it here before reporting it just to make sure it
*is* a bug!
I'm running a set of ~5 queries on one table, using inserts and
updates, and i want to be able to roll them
Suresh Thalamati wrote:
Shutdown in derby throws
exception, you may want to check
the error codes to make sure the system is being properly shutdown.
ij connect 'jdbc:derby:wombat;shutdown=true';
ERROR 08006: Database 'wombat' shutdown.
ij connect 'jdbc:derby:;shutdown=true';
ERROR
Paul J. Lucas wrote:
Also, if it's not too much trouble, I'm new to using JDBC so I'm
wondering how SQLWarnings are caught. They're derived from
SQLException, but does that mean that SQLWarnings are thrown and
must be caught using a try/catch block? Or are warnings caught
Mamta Satoor wrote:
Hi Paul,
Following is what Derby's Reference Guide says about IDENTITY_VAL_LOCAL
IDENTITY_VAL_LOCAL
Derby supports the IDENTITY_VAL_LOCAL function.
[...]
So I think the answer to Paul's question is not answered by that
documentation.
Does it mean the most recent
Mamta Satoor wrote:
The SELECT IDENTITY_VAL_LOCAL() FROM mytable1 will return the value that
got into generated for _any_ table with identity column using single row
insert with values clause in the current transaction.
Except it doesn't behave like that, with respect to the *current
Stephan Bardubitzki wrote:
Hi,
I'm using Cloudscape 10 for a while and switched now to derby. The jdbc
driver for both a currently not supporting update able ResultSets.
Version 10_1 beta made some progress in this case, but inserting rows is
still not supported.
I'm wondering whether
Daniel Noll wrote:
5. The two hosts might not even be on the same network segment, and
thus would be unable to intercommunicate at all.
If that's the case then even NFS won't work, right?
It seems like this problem wouldn't exist at all if Derby didn't try to
lock the
John English wrote:
My application needs to use a temporary table, but they don't seem to
work with the embedded version. When I insert or update rows the commands
appear to work, but when I look at the table there is sometimes some of
the data there and somerimes (more often) not.
I tried
Mamta Satoor wrote:
I think this might be a bug in Derby where VALUES IDENTITY_VAL_LOCAL();
returns null even after single row insert with values clause into table
with identity column. A Jira entry would be good to keep track of this.
Already there.
Boris Hoffmann wrote:
Hi there,
has anybody tried to get around with derby using ewe jvm? --
http://www.ewesoft.com/
My Problem is that i'm unable to start the derby-db because of this
exception:
heir site is a little vague about what exactly the EWE VM is. E.g. this
sentence would worry
simmi iyer wrote:
Derby docs show that in 10.0 connection pooling is
supported only in embedded Derby driver.
Support for connection pooling in client server setup
is there in 10.1
But not much info is there in the docs. Like how to
set minimum or maximum connections to be opened in
simmi iyer wrote:
Using network client driver to connect to network
server.
Using java threads to run parallel selects. RAM used
goes up and after some time Network server throws Out
of Memory error.
Obviously the cursors at database end are not getting
closed when ResultSet is closed
David Van Couvering wrote:
Hi, all. I am getting a bit of an RFP from an internal user and was
wondering if you could help answer Y/N/Partial on the following features
for Derby. I have put in only those items I couldn't find with a fairly
close search through the ref manual.
- Character
Rick Hillegas wrote:
Hi Mag,
Thanks for bringing up this issue. It certainly deserves an enhancement
request. I'll log one later on today.
Going forward integrating Lucene (http://lucene.apache.org/) with Derby
would be the logical choice for text indexing. I once hacked up
something
.
Original Message
Subject: UPDATED [RESULT] [VOTE] Graduate Derby as sub-project of Apache DB
Date: Tue, 26 Jul 2005 11:14:07 -0700
From: Daniel John Debrunner [EMAIL PROTECTED]
Reply-To: general@incubator.apache.org
To: general@incubator.apache.org
References: [EMAIL PROTECTED]
[EMAIL
Xavier Vigouroux wrote:
Hi,
We use a derby server in an High Availability context. Thus, we need to
test if derby server is in a good shape or not. The result of this
repetitive question will imply a fail-over or not.
we thought about two solutions:
1/ create an agent to
Michael J. Segel wrote:
On Thursday 25 August 2005 09:25, Daniel John Debrunner wrote:
Michael J. Segel wrote:
On Wednesday 24 August 2005 21:50, Jean T. Anderson wrote:
*WARNING*
This post may require the readers donning flame retardant clothing. ;-)
It seems to me that Susan and Michael
Michael J. Segel wrote:
[SNIP]
This may be a dumb question...
Maybe its hindsight, but why isn't the Server Framework either a subclass or
an extension to the embedded driver? Someone had posted that the Network
Driver utilized the embedded driver... (Or is that bathtub gin affecting
[EMAIL PROTECTED] wrote:
Wei Jiang [EMAIL PROTECTED] writes:
java.sql javadoc says:
Note: A Statement object is automatically closed when it is garbage collected.
When a Statement object is closed, its current ResultSet object, if one
exists,
is also closed.
I do not close ResultSet.
Kathey Marsden wrote:
Hello Derby Users !
I want to encourage you all to vote for the bugs in Derby that you would
like to see fixed.
We are hoping to have a bug fix release, 10.1.2, in late October. Your
vote might affect which bugs developers decide to fix for this release
or the
Trevor Armstrong wrote:
Hi,
I'm trying to get Derby working on my Windows Mobile 2003 Pocket PC. First
of all I'm trying to get that simple sample program that comes with Derby
running on it. Unfortunetly this program doesn't make it very far before
crashing at the line that loads the
Andreas Fredriksson wrote:
Hey list,
we've re-targeted our system to Derby and now we're seeing some class
loading-related deadlocks.
To give some background, our system loads code from the database and
other various sources (through our own set of class loaders). This has
worked fine
Andreas Fredriksson wrote:
Replying to myself here because I got curious of wheter a testcase would
reproduce the problem, so I wrote one.
Wow, very cool!
Maybe next step would be you fixing the bug! ;-)
Thanks,
Dan.
Andreas Fredriksson wrote:
On Wed, 2005-09-14 at 08:51 +0200, Andreas Fredriksson wrote:
I think the only fix is to rewrite the class definition code in Derby to
avoid taking a lock on the helper objects, but I don't know the source
code well enough to write a proper fix.
Maybe I should
Suavi Ali Demir wrote:
After a shutdown=true, you should be able to connect to the same
database again after doing a DriverManager.registerDriver(
Class.forName(driverName).newInstance() )
No, that's not the correct way to start Derby or any other JDBC driver.
JDBC drivers are required to
Andreas Fredriksson wrote:
On Wed, 2005-09-14 at 09:18 -0700, Daniel John Debrunner wrote:
As another general example, if I ever see code like this I know the
coder maybe unclear on synchronization.
public synchronized int getCount()
{
return count;
}
The synchronization here doesn't
Rajesh Kartha wrote:
Here is one example to connect to a Derby database in Windows:
Connection conn=DriverManager.getConnection(jdbc:derby:c:\\temp\\my new
dir\\a temp\\b temp\\spdb);
(The above also shows directories with spaces)
Any forward slashes in the database name portion of the
firstname lastname wrote:
Good example but, how do insert a row to this table from JDBC ? Using
ij, it's
just a matter of using the DEFAULT parameter, however, the JDBC
preparedstatement
class has no setDefault() method.
The DEFAULT keyword is part of SQL, not ij. These SQL statements
Suavi Ali Demir wrote:
Actually, it sounds like the problem of finding top 1000 rows out of
166333 rows is different than sorting 166333 rows and maybe it could be
optimized. There is no need to sort all 166333 but the information that
we are only looking 1000 rows would have to be passed
Daniel John Debrunner wrote:
Andreas Fredriksson wrote:
On Thu, 2005-09-15 at 09:59 +0200, Knut Anders Hatlen wrote:
Your patch is against Derby 10.1.1.0, but I see that the development
sources have changed since that version. Some of the changes are
similar to those you proposed. Could
I agree with Øystein, given that the standard JDBC api for the maximum
rows is Statement.setMaxRows then Derby should be able to take advantage
of that regardless of when it is set.
This doesn't imply that a plan gets reprepared, though that could be a
solution, it could be implemented as a plan
James A Craig/O/VCU wrote:
Thank you for the fast response. I was looking to set it up so that it
was a single database with table 1 on node 1, table 2 on node 2, etc.
But if I'm reading what you said correctly, this isn't possible. I was
reading a book that dealt with doing this and I wanted
Michael Vinca wrote:
Hello,
I wasn't sure if this was going to work or not. There was nothing in the
documentation to suggest it would, I was just hopeful. I tried searching
the archives for createFrom but only got one hit, so I hope this is
not a repeat question.
I am attempting to create
[EMAIL PROTECTED] wrote:
Deepa,
If you define a function using 'CREATE FUNCTION ...' and call it using
CALL {function} statement, you get the same error as above. To call a
function in Derby, either VALUES or SELECT has to be used.
e.g: VALUES JPOX_ASCII('a');
I use
SELECT 1 FROM
Jean T. Anderson wrote:
Jean T. Anderson wrote:
...
Erik's function worked for me when I changed this:
public final class Function
to this:
public class Function
sorry, I realized my reply could have used the complete example. I think
the problem may have been a CLASSPATH
[EMAIL PROTECTED] wrote:
Hi,
I was able to fix the problem, and of course it was on my side. Due to
several tries to make arguments match to datypes and the java method
arguments, I forgot to modify the code that was calling JPOX_ASCII('a'),
and instead it was generating JPOX_ASCII('a',10)
Manyi Lu - Sun Norway wrote:
Hi all,
I know that Derby has support for JSR-169 which is JDBC API for CDC.
Anyone knows whether Derby has passed the TCK tests for JSR-169?
Are there any TCK tests for JSR-169?
If so is there a link for them?
Thanks,
Dan.
Lance J. Andersen wrote:
Apache would have to apply for a scholarship for the TCK see
http://jcp.org/aboutJava/communityprocess/final/jsr169/index.html
To quote that page:
The TCK will be available to Qualified Not-for-Profits and Qualified
Individuals for no charge as per Section F.III of
Michael J. Segel wrote:
Uhm silly question. 1 ... start an embeddedServer.
That would imply that only one connection is allowed.
No, Derby's embedded engine is fully multi-user, multi-threaded,
multi-connection. It's the engine used by the network server.
Dan.
Hiram Chirino wrote:
Hi Guys,
Any ideas why http://issues.apache.org/jira/browse/DERBY-621 is
happening to me?
Looks like the same as DERBY-217 which is meant to be fixed in 10.1.1.0
including test cases.
http://issues.apache.org/jira/browse/DERBY-217
Can you confirm you are testing with
James Pannozzi wrote:
I started using Derby, so far very very impressive,
I never used all Java database before.
Here is a question on import CSV file.
I try to import 90,000 line CSV file (see Subject,
this message) and get some exception, for example if
too many commas in a line, I
Daniel Skiles wrote:
Hello All,
I’m getting a I'm working on trying to embed Cloudscape into an app and
every time I try to run the next() method on a result set I getting the
following error:
ERROR 38000: The exception 'java.lang.StackOverflowError' was thrown
while evaluating an
Daniel Skiles wrote:
Dan,
Thanks for the tip. The strange thing about this is that it seems to
work fine if I use a different database, such as MS SQL Server or
Oracle. While I wouldn't be surprised if it was my code causing the
exception, the fact that it only happens with Derby makes me
Dan Scott wrote:
Hmm, anybody want to step up to the task of sending in corrections for
this Open Source Database Feature Comparison Matrix:
http://www.devx.com/dbzone/Article/29480?trk=DXRSS_LATEST
The authors of the matrix (creators of DaffodilDB) compared Cloudscape
5.1 against
David W. Van Couvering wrote:
Thanks for catching this Dan and proposing a way to address it. I'll
take a look when I get a chance and see what I can add. Perhaps we can
manage this via a Wiki page or a JIRA item?
I think the checkmark for the ODBC driver should have a footnote saying
I've added a page to the Derby Wiki with various projects and products
that are using Derby. These are all ones I've found through google
searches, please feel free to add to the page.
http://wiki.apache.org/db-derby/UsesOfDerby
Dan.
Raji Sridar wrote:
Hi Michael,
Your opinion was very encouraging - I also built a prototype based on Derby.
I am happy to say, that our management has almost decided on Derby,
subject to legal approval for the licensing aspects.
We plan to use Derby as an embedded RDBMS in our Network
Rick Hillegas wrote:
I recommend that you make your class implement java.io.Externalizable.
That way you can write your own deserialization logic to handle version
upgrades of your class. Don't rely on java.io.Serializable; it doesn't
handle versioning and isn't appropriate for persisting
Daniel Tripp wrote:
Hello all. I have run into some behaviour that looks like a memory
leak. I don't know if it's a bug or if I'm just missing something, but
it's causing my application to crash so I would greatly appreciate any
ideas.
Scenario: Using derby 10.1.1.0 in an embedded setup,
Michael J. Segel wrote:
The liberal Apache license is a license to rape IP.
(Maybe that's a harsh statement. )
Essentially you're saying that any work you have done on an Apache product is
done gratis and that you have no future rights to protect the IP.
Under the Apache License, as a
Michael J. Segel wrote:
If you want to use Derby as a basis for your own development, thats fine.
However, you now have the cost of synchronizing your code stream with the
official Derby code stream, if you want to protect your IP.
The other approach to this issue is to work *with* the
Michael J. Segel wrote:
On Thursday 27 October 2005 11:01, Rick Hillegas wrote:
Thanks, Michael. You are correct, Derby, like DB2, finesses this issue
by not allowing nullable columns in unique constraints. I have closed
this bug.
Cheers,
-Rick
NP,
But Dan's reply is an interesting
Michael J. Segel wrote:
On Thursday 27 October 2005 12:22, Daniel John Debrunner wrote:
Michael J. Segel wrote:
I guess you could say that this is a good thing if you're looking at
using Derby vs MySQL. Which is why MySQL can be released under multiple
licensing types. GPL affords certain
Daniel John Debrunner wrote:
Obviously you are talking about something else, but I'm not sure what.
The ASL v2 allows distribution under a different licence, I thought the
GPL did not (clause 2b).
To follow up with the facts, from the FSF itself:
http://www.gnu.org/licenses/gpl-faq.html
Michael J. Segel wrote:
On Thursday 27 October 2005 13:44, Daniel John Debrunner wrote:
But Dan's reply is an interesting one.
What Sybase did was create a Schrodinger's Cat.
(See http://whatis.techtarget.com/definition/0,,sid9_gci341236,00.html
for a definition... ;-)
This is actually
Michael J. Segel wrote:
On Thursday 27 October 2005 15:19, Daniel John Debrunner wrote:
Sigh.
Dan, you really need to pay more attention to what was written.
With respect to GPL I never talked about end users.
Just those who license their code under GPL.
GPL does allow a company
Craig L Russell wrote:
NoPutResultSet implements ResultSet. What you're describing would
happen if you used a JDBC 3.0 ResultSet with a version of Derby that
didn't support the JDBC 3.0 methods. But I don't know how that could
happen.
While NoPutResultSet does implement ResultSet, it's
Lars Clausen wrote:
The 10.1 docs state that the java.sql.Clob.getCharacterStream() method
is UNSUPPORTED [sic], however it works nicely when I try to use it. Is
the documentation out of date, or are there some special cases I should
know about where is it indeed unsupported?
My guess is
Rick Hillegas wrote:
Dan's workaround is very useful and Øyvind's suggestion is interesting
also. It's worth pointing out that the need for these workarounds should
decrease after we fix bug 533 (the re-enabling of the natonal character
datatypes). I hope to get to that bug in 10.2. The
Edson Carlos Ericksson Richter wrote:
Probably, the most important are that using large tables with order by
SOME_FUNCTION(some_col) could not be optimized unless you could index
as create index IDX_SOMETHING on MY_TABLE (SOME_FUNCTION(some_col))
too... Could Derby create and use indexes
Knut Anders Hatlen wrote:
Legolas Woodland [EMAIL PROTECTED] writes:
Hi
Does derby support inserting unicode data into its char variant fields ?
for example inserting Arabic ?
in sqlServer there is Ntext and nchar ,nvarchar ... to support unicode data.
in mysql there are charset and collat +
Paul Byford wrote:
hi,
I would appreciate if anyone can help with the following issue. I am
attempting to run the derby network server with a security manager
policy. when i run without a policy everything works fine. it starts, i
can connect to databases, retrieve data etc. However when i
[EMAIL PROTECTED] wrote:
Note A: You may want to create and use more than one connection to
increase performance if you have many simultaneous requests.
I would not recommend a single connection for any simultaneous requests.
Note B: If you're running with autocommit OFF, you should
[EMAIL PROTECTED] wrote:
Daniel John Debrunner wrote:
[EMAIL PROTECTED] wrote:
Note B: If you're running with autocommit OFF, you should definately not
use the same connection object in multiple simultaneous requests (either
use synchronization or create multiple connections
Dag H. Wanvik wrote:
Hi,
Daniel == Daniel John Debrunner [EMAIL PROTECTED] wrote:
Daniel
Daniel I think there was a long discussion on this about six months ago, lead
Daniel by Phil Wilder. He was trying to clarify autocommit mode and held
cursor
Daniel behaviour in the JDBC spec
[EMAIL PROTECTED] wrote:
Daniel John Debrunner wrote:
In addition I guess you showRow() does a next() and then
the rs.gerXXX()? I think if you called t2.executeQuery() between a
next() and the rs.getXXX() calls on the other thread, I think you will
see problems.
I tried
Lance J. Andersen wrote:
Note that executing a statement on *another* statement object in the
same connection no longer closes a result set,
This has never been the intent in JDBC since its inception,
Well, it sure had a funny way of showing it was not the intent :-)
JDBC 1
New JDBC
Lance J. Andersen wrote:
The JDBC 3 spec intermixed when a ResultSet was closed with auto-commit
semantics and these both are seperate scenarios. These should have been
seperated.
Yep.
The verbage in JDBC 3 WRT to having another Statement executed on the
same connection was not explict
I don't think I've seen this on the list, but ApacheCon US 2005 is
coming up and there are several Derby presentations and a Derby
tutorial. The tutorial has a 50% scholarship available.
http://www.apachecon.com/
Dec 10th-14, San Diego, CA.
T02: Apache Derby: Hands On Tutorial
Jean Anderson
Michael McCutcheon wrote:
Hello All,
I'm going to be using Derby (in embedded mode) in Tomcat for my web
app. I am building everything from scratch.
I'm trying to decide on if I want to put 'everything' in stored
procedures or just code stuff in the application. (i.e. no SQL in the
Mike Matrigali wrote:
As Dan has said more details are necessary. I have never
seen any issues on the engine side with storing and retrieving
unicode characters. The only issues I have seen is using the
proper jdbc interfaces correctly to insert and retrieve the
data.
The store system
1 - 100 of 254 matches
Mail list logo