Hi,Does Derby offer enumeration type like ENUM and SET? If not, what's the best way to restrict a column to certain pre-defined value?Thank you.
> --- Daniel John Debrunner <[EMAIL PROTECTED]> wrote:
>
>> 2) Some J2EE app servers will wrap the database's DataSource
>>implementation in their own, meaning the cases will fail.
Sorry I mistyped, I mean "the casts will fail".
Dan.
--- Daniel John Debrunner <[EMAIL PROTECTED]> wrote:
> [EMAIL PROTECTED] wrote:
>
> > Hi Deepa,
> >
> > Thanks a lot for your help. That worked like a charm.
> >
> > So I have now changed my code to this:
> >
> >((EmbeddedDataSource)ds).setShutdownDatabase("shutdown");
> >((Embedde
[EMAIL PROTECTED] wrote:
> Hi Deepa,
>
> Thanks a lot for your help. That worked like a charm.
>
> So I have now changed my code to this:
>
>((EmbeddedDataSource)ds).setShutdownDatabase("shutdown");
>((EmbeddedDataSource)ds).getConnection();
Just a couple of warnings with this code
Whoops, sorry about that last reply .. .sticky fingers. I was too hasty on my
previous(previous) response.
Although the below appears to work it does not. The reason being in my Tomcat
server.xml I am trying
to use the Apache DBCP Basic Data source.
factory
org.apache.common
- Original Message
From: [EMAIL PROTECTED]
To: Derby Discussion
Sent: Thursday, September 7, 2006 2:56:02 PM
Subject: Re: Using Apache DBCP and Tomcat with Derby - database shutdown?
Hi Deepa,
Thanks a lot for your help. That worked like a charm.
So I have now changed my code to th
Hi Deepa,
Thanks a lot for your help. That worked like a charm.
So I have now changed my code to this:
((EmbeddedDataSource)ds).setShutdownDatabase("shutdown");
((EmbeddedDataSource)ds).getConnection();
Thanks,
Susan
- Original Message
From: Deepa Remesh <[EMAIL PROTECTED]
The server wasn't running - I thought the class library I'm using checked,
but it doesn't.
Thanks,
Michael
This message made from 100% recycled bits.
[EMAIL PROTECTED]
This message, including attachments, is confidential and may be
privileged. If you are not an intended recipient, please notif
Michael Segel wrote:
> Outch. Missed the first part of Derby's statement.
>
> Ok.
>
> Doesn't make sense though.
> His insert is a batch insert?
No, a single INSERT with a VALUES clause that has multiple rows (I think
he said around 1700).
> Imagine if you had a table where you were insertin
Outch. Missed the first part of Derby's statement.
Ok.
Doesn't make sense though.
His insert is a batch insert?
Imagine if you had a table where you were inserting a record that was larger
than 64KB. (Not including blobs) Are you saying that Derby would have failed
prior to your fix?
Within th
Bryan Pendleton wrote:
>> java.lang.ClassFormatError: Invalid method Code length 69936 in class
>
>
> There is a hard limit in the JDK class-file format of 64K
Just to be clear, one of the limits in the Java class file format is 64k
bytes of byte code instructions per-method. A large String co
[EMAIL PROTECTED] wrote:
> But his issue isn't with Derby.
>
> He'd have the same problem with any Java app and a JDBC connection.
> We know this because Leslie wrote that if he inserted just a subset of his
> data, it would work. ;-)
Nope, the error Leslie reported is for a class generated by D
But his issue isn't with Derby.
He'd have the same problem with any Java app and a JDBC connection.
We know this because Leslie wrote that if he inserted just a subset of his
data, it would work. ;-)
But hey! What do I know? (I've never worked in support. ;-)
> -Original Message-
> From:
[EMAIL PROTECTED] wrote:
Can anyone tell me why this happens or point me to error codes - I
searched the Derby error codes I could find in the reference but couldn't
find this one.
Internal Exception: org.apache.derby.client.am.DisconnectException:
java.security.PrivilegedActionException : E
> -Original Message-
> From: Leslie Software [mailto:[EMAIL PROTECTED]
> Sent: Thursday, September 07, 2006 12:07 PM
> To: Derby Discussion
> Subject: Re: ClassFormatError while performing a SQL insert
>
> Iteresting. I though that was a strange error to be getting when running
> SQL.
Leslie Software wrote:
> Interesting. I though that was a strange error to be getting when
running SQL. Does that mean that Derby is generating Java code from the
SQL to do the actual work?
>
Yes, you are correct. Derby generates a Java class file for most SQL
statements, the exceptions being DD
Can anyone tell me why this happens or point me to error codes - I
searched the Derby error codes I could find in the reference but couldn't
find this one.
Internal Exception: org.apache.derby.client.am.DisconnectException:
java.security.PrivilegedActionException : Error opening socket to serve
Iteresting. I though that was a strange error to be getting when running SQL.
Does that mean that Derby is generating Java code from the SQL to do the actual
work?
Ian
- Original Message
From: Bryan Pendleton <[EMAIL PROTECTED]>
> java.lang.ClassFormatError: Invalid method Code len
On 9/7/06, Susan L. Cline <[EMAIL PROTECTED]> wrote:
[snip]
But this does not seem correct because I'm obtaining the connections to Derby
via the datasource
and a pool, and here I am shutting the database down using the DriverManager
class. Is this okay?
I can't find anything in the DBCP doc
Hi,
This is not strictly a Derby question, but I'm hoping someone else has used
Apache DBCP
with Tomcat and Derby.
According to the Tomcat 5.0 docs:
The default data source support in Tomcat is based on the DBCP connection pool
from the Jakarta
Commons subproject.
and here is some sample co
Thanks. I'll either break it up into smaller chunks or use the prepared
statement approch.
To beta test the 10.2 can I replace my current jars and just use a copy of an
old database as a test or do I need to start with a new one. I would like to
give it a try.
It sounds like I would be bette
Shubh.Roy wrote:
> Hi ,
> I have to implement the WAL(Write Ahead logging ) techniques in java.Can you
> send me please the code.
Hi, Shubh,
The Derby downloads page explains where to find the source code:
http://db.apache.org/derby/derby_downloads.html#Derby+source+code
There has been some dis
Hi ,
I have to implement the WAL(Write Ahead logging ) techniques in java.Can you
send me please the code.
Thanks & Regards
Shubh Chandra Roy
R Systems
Mob:+ 919818413355
Leslie Software wrote:
[snip ClassFormatError with long SQL]
> Is this a known issue? Is my SQL too long?
Some of this is DERBY-766/DERBY-176 that have been fixed in 10.2, now in
beta and available for testing:
http://wiki.apache.org/db-derby/TenTwoRelease
Note that beta jars not suitable
java.lang.ClassFormatError: Invalid method Code length 69936 in class
There is a hard limit in the JDK class-file format of 64K, and there are
some known issues in Derby which can cause the generated code to exceed
these limits.
Tremendous improvements have been made in this area over recent mo
I received a ClassFormatError today while trying execute some insert SQL. The SQL is quite long and abridged versions succeed. I have not examined my data closely yet but I will. Here is the full story:In my database loading code I am working on updating a table (named ruling). To do that the c
26 matches
Mail list logo
