You are viewing a plain text version of this content. The canonical link for it is here.
Posted to derby-dev@db.apache.org by Ravinder Reddy <pa...@students.iiit.ac.in> on 2007/07/13 21:28:11 UTC
Using eclipse to work with derby..
hi,
1) how to get eclipse set up to not use tabs?
2) recently I have migrated to a new machine in which Fedora 7 is installed.
Some info regarding my system.
[root@localhost ~]# java -version
java version "1.5.0_11"
Java(TM) 2 Runtime Environment, Standard Edition (build 1.5.0_11-b03)
Java HotSpot(TM) Client VM (build 1.5.0_11-b03, mixed mode)
[root@localhost ~]# echo $JAVA_HOME
/opt/jdk1.5.0_11
[root@localhost ~]# echo $PATH
/usr/kerberos/sbin:/usr/kerberos/bin:/usr/lib64/ccache:/usr/local/sbin:/usr/local/bin:/sbin:/bin:/usr/sbin:/usr/bin:
/usr/X11R6/bin:.:/usr/Ant/apache-ant-1.6.5/bin:/opt/jdk1.5.0_11/bin:/opt/jdk1.5.0_11/jre/bin:
/home/WorkSpace/DerbyGsoc/bin:/usr/local/mysql/bin/:/home/WorkSpace/DerbyGsoc/java/testing/:/root/bin:.:
/usr/Ant/apache-ant-1.6.5/bin:/opt/jdk1.5.0_11/bin:/opt/jdk1.5.0_11/jre/bin:/home/WorkSpace/DerbyGsoc/bin:
/usr/local/mysql/bin/:/home/WorkSpace/DerbyGsoc/java/testing/
[root@localhost ~]# echo $CLASSPATH
.:/opt/jdk1.5.0_11/lib:/opt/jdk1.5.0_11/lib/tools.jar:/opt/jdk1.5.0_11/lib/dt.jar:/opt/jdk1.5.0_11/lib/jpda.jar:
/opt/jdk1.5.0_11/jre/lib/rt.jar:/opt/junit3.8.1/junit.jar:/home/WorkSpace/DerbyGsoc/classes:
/root/mysql-connector-java-3.0.17-ga/mysql-connector-java-3.0.17-ga-bin.jar:/home/WorkSpace/DerbyGsoc/java/testing/
[root@localhost ~]# cat ant.properties
j14lib=$jdk14_home/jre/lib
build.compiler=modern
proceed=true
sane=false
[root@localhost ~]#
I have checkedout the 10.3 source using eclipse and trying to
build derby.I am getting the following error..
plzz help me out in this
Buildfile: /home/WorkSpace/DerbyGsoc/build.xml
init:
ensuresanitystate:
setissane:
showenv:
[echo] Ant environment:
[echo] Base Directory: /home/WorkSpace/DerbyGsoc
[echo] Build output: /home/WorkSpace/DerbyGsoc/classes
[echo] Compiler: modern
[echo] Sane = false
[echo] Proceed = true
getstate:
state:
shared:
compile:
[javac] Compiling 12 source files to
/home/WorkSpace/DerbyGsoc/classes
[javac] Fatal Error: Unable to find package java.lang in classpath
or bootclasspath
[javac] Compile failed; see the compiler error output for details.
shared:
parsers:
parser:
chkparser:
genParser:
chkparser:
genParser:
parser:
chkparser:
genParser:
engine:
engine_169:
compile_reference:
[javac] Compiling 11 source files to
/home/WorkSpace/DerbyGsoc/classes
[javac] Fatal Error: Unable to find package java.lang in classpath
or bootclasspath
[javac] Compile failed; see the compiler error output for details.
[javac] Compiling 2 source files to
/home/WorkSpace/DerbyGsoc/classes
[javac] Fatal Error: Unable to find package java.lang in classpath
or bootclasspath
[javac] Compile failed; see the compiler error output for details.
compile_authentication:
[javac] Compiling 2 source files to
/home/WorkSpace/DerbyGsoc/classes
[javac] Fatal Error: Unable to find package java.lang in classpath
or bootclasspath
[javac] Compile failed; see the compiler error output for details.
authentication:
compile_io:
[javac] Compiling 4 source files to
/home/WorkSpace/DerbyGsoc/classes
[javac] Fatal Error: Unable to find package java.lang in classpath
or bootclasspath
[javac] Compile failed; see the compiler error output for details.
storage:
compile_iapi_error_jsr169:
compile_reference:
[javac] Compiling 11 source files to
/home/WorkSpace/DerbyGsoc/classes
[javac] Fatal Error: Unable to find package java.lang in classpath
or bootclasspath
[javac] Compile failed; see the compiler error output for details.
[javac] Compiling 2 source files to
/home/WorkSpace/DerbyGsoc/classes
[javac] Fatal Error: Unable to find package java.lang in classpath
or bootclasspath
[javac] Compile failed; see the compiler error output for details.
[javac] Compiling 4 source files to
/home/WorkSpace/DerbyGsoc/classes
[javac] Fatal Error: Unable to find package java.lang in classpath
or bootclasspath
[javac] Compile failed; see the compiler error output for details.
compile_util:
compile_types:
[javac] Compiling 1 source file to
/home/WorkSpace/DerbyGsoc/classes
[javac] Fatal Error: Unable to find package java.lang in classpath
or bootclasspath
[javac] Compile failed; see the compiler error output for details.
[javac] Compiling 63 source files to
/home/WorkSpace/DerbyGsoc/classes
[javac] Fatal Error: Unable to find package java.lang in classpath
or bootclasspath
[javac] Compile failed; see the compiler error output for details.
[javac] Compiling 2 source files to
/home/WorkSpace/DerbyGsoc/classes
[javac] Fatal Error: Unable to find package java.lang in classpath
or bootclasspath
[javac] Compile failed; see the compiler error output for details.
compile_iapi_services_jsr169:
[javac] Compiling 85 source files to
/home/WorkSpace/DerbyGsoc/classes
[javac] Fatal Error: Unable to find package java.lang in classpath
or bootclasspath
[javac] Compile failed; see the compiler error output for details.
compile_iapi_services_io:
[javac] Compiling 37 source files to
/home/WorkSpace/DerbyGsoc/classes
[javac] Fatal Error: Unable to find package java.lang in classpath
or bootclasspath
[javac] Compile failed; see the compiler error output for details.
compile_iapi_store_jsr169:
[javac] Compiling 77 source files to
/home/WorkSpace/DerbyGsoc/classes
[javac] Fatal Error: Unable to find package java.lang in classpath
or bootclasspath
[javac] Compile failed; see the compiler error output for details.
compile_iapi_sql_jsr169:
[javac] Compiling 109 source files to
/home/WorkSpace/DerbyGsoc/classes
[javac] Fatal Error: Unable to find package java.lang in classpath
or bootclasspath
[javac] Compile failed; see the compiler error output for details.
compile_iapi_db:
[javac] Compiling 9 source files to
/home/WorkSpace/DerbyGsoc/classes
[javac] Fatal Error: Unable to find package java.lang in classpath
or bootclasspath
[javac] Compile failed; see the compiler error output for details.
compile_iapi_jdbc_jsr169:
[javac] Compiling 12 source files to
/home/WorkSpace/DerbyGsoc/classes
[javac] Fatal Error: Unable to find package java.lang in classpath
or bootclasspath
[javac] Compile failed; see the compiler error output for details.
compile_database:
[javac] Compiling 1 source file to
/home/WorkSpace/DerbyGsoc/classes
[javac] Fatal Error: Unable to find package java.lang in classpath
or bootclasspath
[javac] Compile failed; see the compiler error output for details.
database:
compile_impl_169:
compile_impl_services_169:
[javac] Compiling 62 source files to
/home/WorkSpace/DerbyGsoc/classes
[javac] Fatal Error: Unable to find package java.lang in classpath
or bootclasspath
[javac] Compile failed; see the compiler error output for details.
compile_impl_io_169:
[javac] Compiling 11 source files to
/home/WorkSpace/DerbyGsoc/classes
[javac] Fatal Error: Unable to find package java.lang in classpath
or bootclasspath
[javac] Compile failed; see the compiler error output for details.
engine_j2se:
compile_iapi_error_jsr169:
compile_reference:
[javac] Compiling 11 source files to
/home/WorkSpace/DerbyGsoc/classes
[javac] Fatal Error: Unable to find package java.lang in classpath
or bootclasspath
[javac] Compile failed; see the compiler error output for details.
[javac] Compiling 2 source files to
/home/WorkSpace/DerbyGsoc/classes
[javac] Fatal Error: Unable to find package java.lang in classpath
or bootclasspath
[javac] Compile failed; see the compiler error output for details.
[javac] Compiling 4 source files to
/home/WorkSpace/DerbyGsoc/classes
[javac] Fatal Error: Unable to find package java.lang in classpath
or bootclasspath
[javac] Compile failed; see the compiler error output for details.
compile_util:
compile_types:
[javac] Compiling 1 source file to
/home/WorkSpace/DerbyGsoc/classes
[javac] Fatal Error: Unable to find package java.lang in classpath
or bootclasspath
[javac] Compile failed; see the compiler error output for details.
[javac] Compiling 63 source files to
/home/WorkSpace/DerbyGsoc/classes
[javac] Fatal Error: Unable to find package java.lang in classpath
or bootclasspath
[javac] Compile failed; see the compiler error output for details.
[javac] Compiling 2 source files to
/home/WorkSpace/DerbyGsoc/classes
[javac] Fatal Error: Unable to find package java.lang in classpath
or bootclasspath
[javac] Compile failed; see the compiler error output for details.
compile_iapi_services_jsr169:
[javac] Compiling 85 source files to
/home/WorkSpace/DerbyGsoc/classes
[javac] Fatal Error: Unable to find package java.lang in classpath
or bootclasspath
[javac] Compile failed; see the compiler error output for details.
compile_iapi_services_io:
[javac] Compiling 37 source files to
/home/WorkSpace/DerbyGsoc/classes
[javac] Fatal Error: Unable to find package java.lang in classpath
or bootclasspath
[javac] Compile failed; see the compiler error output for details.
compile_iapi_store_jsr169:
[javac] Compiling 77 source files to
/home/WorkSpace/DerbyGsoc/classes
[javac] Fatal Error: Unable to find package java.lang in classpath
or bootclasspath
[javac] Compile failed; see the compiler error output for details.
compile_iapi_sql_jsr169:
[javac] Compiling 109 source files to
/home/WorkSpace/DerbyGsoc/classes
[javac] Fatal Error: Unable to find package java.lang in classpath
or bootclasspath
[javac] Compile failed; see the compiler error output for details.
compile_iapi_db:
[javac] Compiling 9 source files to
/home/WorkSpace/DerbyGsoc/classes
[javac] Fatal Error: Unable to find package java.lang in classpath
or bootclasspath
[javac] Compile failed; see the compiler error output for details.
compile_iapi_jdbc_jsr169:
[javac] Compiling 12 source files to
/home/WorkSpace/DerbyGsoc/classes
[javac] Fatal Error: Unable to find package java.lang in classpath
or bootclasspath
[javac] Compile failed; see the compiler error output for details.
compile_iapi_error:
compile_iapi_services_jsr169:
[javac] Compiling 85 source files to
/home/WorkSpace/DerbyGsoc/classes
[javac] Fatal Error: Unable to find package java.lang in classpath
or bootclasspath
[javac] Compile failed; see the compiler error output for details.
compile_iapi_services_io:
[javac] Compiling 37 source files to
/home/WorkSpace/DerbyGsoc/classes
[javac] Fatal Error: Unable to find package java.lang in classpath
or bootclasspath
[javac] Compile failed; see the compiler error output for details.
compile_crypto:
compile_crypto:
[javac] Compiling 3 source files to
/home/WorkSpace/DerbyGsoc/classes
[javac] Fatal Error: Unable to find package java.lang in classpath
or bootclasspath
[javac] Compile failed; see the compiler error output for details.
compile_jdbc3:
compile:
compile_iapi_store_jsr169:
[javac] Compiling 77 source files to
/home/WorkSpace/DerbyGsoc/classes
[javac] Fatal Error: Unable to find package java.lang in classpath
or bootclasspath
[javac] Compile failed; see the compiler error output for details.
compile_iapi_store_jdk13:
[javac] Compiling 2 source files to
/home/WorkSpace/DerbyGsoc/classes
[javac] Fatal Error: Unable to find package java.lang in classpath
or bootclasspath
[javac] Compile failed; see the compiler error output for details.
compile:
compile_iapi_sql_jsr169:
[javac] Compiling 109 source files to
/home/WorkSpace/DerbyGsoc/classes
[javac] Fatal Error: Unable to find package java.lang in classpath
or bootclasspath
[javac] Compile failed; see the compiler error output for details.
compile_iapi_sql_jdbc2:
compile:
compile_iapi_jdbc:
compile_iapi_jdbc_stmt:
[javac] Compiling 1 source file to
/home/WorkSpace/DerbyGsoc/classes
[javac] Fatal Error: Unable to find package java.lang in classpath
or bootclasspath
[javac] Compile failed; see the compiler error output for details.
compile_iapi_jdbc_jsr169:
[javac] Compiling 12 source files to
/home/WorkSpace/DerbyGsoc/classes
[javac] Fatal Error: Unable to find package java.lang in classpath
or bootclasspath
[javac] Compile failed; see the compiler error output for details.
compile_iapi_jdbc_jdbc2:
[javac] Compiling 3 source files to
/home/WorkSpace/DerbyGsoc/classes
[javac] Fatal Error: Unable to find package java.lang in classpath
or bootclasspath
[javac] Compile failed; see the compiler error output for details.
compile_iapi_jdbc_jdbc3:
[javac] Compiling 3 source files to
/home/WorkSpace/DerbyGsoc/classes
[javac] Fatal Error: Unable to find package java.lang in classpath
or bootclasspath
[javac] Compile failed; see the compiler error output for details.
compile_jdbc4:
compile:
iapi:
compile_vti:
[javac] Compiling 6 source files to
/home/WorkSpace/DerbyGsoc/classes
[javac] Fatal Error: Unable to find package java.lang in classpath
or bootclasspath
[javac] Compile failed; see the compiler error output for details.
[javac] Compiling 3 source files to
/home/WorkSpace/DerbyGsoc/classes
[javac] Fatal Error: Unable to find package java.lang in classpath
or bootclasspath
[javac] Compile failed; see the compiler error output for details.
vti:
compile_impl_169:
compile_impl_services_169:
[javac] Compiling 62 source files to
/home/WorkSpace/DerbyGsoc/classes
[javac] Fatal Error: Unable to find package java.lang in classpath
or bootclasspath
[javac] Compile failed; see the compiler error output for details.
compile_impl_io_169:
[javac] Compiling 11 source files to
/home/WorkSpace/DerbyGsoc/classes
[javac] Fatal Error: Unable to find package java.lang in classpath
or bootclasspath
[javac] Compile failed; see the compiler error output for details.
compile:
compile_impl_services_169:
[javac] Compiling 62 source files to
/home/WorkSpace/DerbyGsoc/classes
[javac] Fatal Error: Unable to find package java.lang in classpath
or bootclasspath
[javac] Compile failed; see the compiler error output for details.
compile_impl_services_jdk15:
compile_impl_services:
[javac] Compiling 3 source files to
/home/WorkSpace/DerbyGsoc/classes
[javac] Fatal Error: Unable to find package java.lang in classpath
or bootclasspath
[javac] Compile failed; see the compiler error output for details.
compile_impl_io_169:
[javac] Compiling 11 source files to
/home/WorkSpace/DerbyGsoc/classes
[javac] Fatal Error: Unable to find package java.lang in classpath
or bootclasspath
[javac] Compile failed; see the compiler error output for details.
compile_impl_io:
[javac] Compiling 3 source files to
/home/WorkSpace/DerbyGsoc/classes
[javac] Fatal Error: Unable to find package java.lang in classpath
or bootclasspath
[javac] Compile failed; see the compiler error output for details.
parser:
chkparser:
genParser:
compile:
[javac] Compiling 435 source files to
/home/WorkSpace/DerbyGsoc/classes
[javac] Fatal Error: Unable to find package java.lang in classpath
or bootclasspath
[javac] Compile failed; see the compiler error output for details.
compile_impl_store:
[javac] Compiling 194 source files to
/home/WorkSpace/DerbyGsoc/classes
[javac] Fatal Error: Unable to find package java.lang in classpath
or bootclasspath
[javac] Compile failed; see the compiler error output for details.
compile_impl_store_14:
[javac] Compiling 2 source files to
/home/WorkSpace/DerbyGsoc/classes
[javac] Fatal Error: Unable to find package java.lang in classpath
or bootclasspath
[javac] Compile failed; see the compiler error output for details.
compile:
[javac] Compiling 3 source files to
/home/WorkSpace/DerbyGsoc/classes
[javac] Fatal Error: Unable to find package java.lang in classpath
or bootclasspath
[javac] Compile failed; see the compiler error output for details.
compile:
[javac] Compiling 15 source files to
/home/WorkSpace/DerbyGsoc/classes
[javac] Fatal Error: Unable to find package java.lang in classpath
or bootclasspath
[javac] Compile failed; see the compiler error output for details.
compile_impl_jdbc:
compile_jsr169:
[javac] Compiling 38 source files to
/home/WorkSpace/DerbyGsoc/classes
[javac] Fatal Error: Unable to find package java.lang in classpath
or bootclasspath
[javac] Compile failed; see the compiler error output for details.
compile_jdbc3:
[javac] Compiling 12 source files to
/home/WorkSpace/DerbyGsoc/classes
[javac] Fatal Error: Unable to find package java.lang in classpath
or bootclasspath
[javac] Compile failed; see the compiler error output for details.
compile_jdbc4:
compile:
iapi:
compile_jsr169:
[javac] Compiling 2 source files to
/home/WorkSpace/DerbyGsoc/classes
[javac] Fatal Error: Unable to find package java.lang in classpath
or bootclasspath
[javac] Compile failed; see the compiler error output for details.
compile_jdbc2:
[javac] Compiling 7 source files to
/home/WorkSpace/DerbyGsoc/classes
[javac] Fatal Error: Unable to find package java.lang in classpath
or bootclasspath
[javac] Compile failed; see the compiler error output for details.
compile_jdbc3:
[javac] Compiling 6 source files to
/home/WorkSpace/DerbyGsoc/classes
[javac] Fatal Error: Unable to find package java.lang in classpath
or bootclasspath
[javac] Compile failed; see the compiler error output for details.
compile_jdbc4:
jdbc:
checkosgijar:
compile_osgi:
osgi:
compile_catalog:
[javac] Compiling 25 source files to
/home/WorkSpace/DerbyGsoc/classes
[javac] Fatal Error: Unable to find package java.lang in classpath
or bootclasspath
[javac] Compile failed; see the compiler error output for details.
catalog:
compile_security:
[javac] Compiling 2 source files to
/home/WorkSpace/DerbyGsoc/classes
[javac] Fatal Error: Unable to find package java.lang in classpath
or bootclasspath
[javac] Compile failed; see the compiler error output for details.
security:
compile_diag:
[javac] Compiling 7 source files to
/home/WorkSpace/DerbyGsoc/classes
[javac] Fatal Error: Unable to find package java.lang in classpath
or bootclasspath
[javac] Compile failed; see the compiler error output for details.
diag:
checkJ2MEmoduleprops:
J2ME_modules_edit:
engine_169_opt:
jdbc4_modules_edit:
jdk15_modules_edit:
engine:
build:
build_base:
compile:
[javac] Compiling 16 source files to
/home/WorkSpace/DerbyGsoc/classes
[javac] Fatal Error: Unable to find package java.lang in classpath
or bootclasspath
[javac] Compile failed; see the compiler error output for details.
build:
build:
BUILD FAILED
/home/WorkSpace/DerbyGsoc/build.xml:335: The following error occurred
while executing this line:
/home/WorkSpace/DerbyGsoc/java/engine/org/apache/derby/loc/build.xml:36:
taskdef class org.apache.derbyBuild.MessageBuilder cannot be found
Total time: 16 seconds
It seems the compiler is unable to find the package java.lang..!!
Thanks in Advance.
--
******************************************************************************
Every problem that has been solved can be solved again in a better way
- Ravinder Reddy
*******************************************************************************
--
This message has been scanned for viruses and
dangerous content by MailScanner, and is
believed to be clean.
Re: reg: DatabaseMetaData.getTables()
Posted by Mamta Satoor <ms...@gmail.com>.
Hi Ravinder,
The metadata sql for getTables has changed in 10.3 and main and that is
probably why you are seeing the error. You will have to drop and recreate
any existing 10.3 and main databases to resolve the problem.
Mamta
On 8/1/07, Bryan Pendleton <bp...@amberpoint.com> wrote:
>
> > ResultSet rs1 = databaseMetaData.getTables("", null, "%", null);
> >
> > I am getting the syntax error in the last line.
> > The Error is:
> > Syntax error: Encountered "ORDER" at line 1, column 815
>
> This sounds like a build problem to me. Under the covers, the getTables()
> method invokes a system procedure to retrieve the table information
> from the system catalogs, and perhaps the syntax error is somehow coming
> from that getTables() call. Perhaps you somehow have code which doesn't
> match the proper version of the system procedure against the code stored
> in the database tables.
>
> Do you have the full stack-trace of the error?
>
> I'd suggest:
> - doing an ant clobber, then rebuilding your source tree
> - then removing and recreating all of your test databases.
>
> thanks,
>
> bryan
>
>
Re: help requires regarding get cursor..!!
Posted by Kathey Marsden <km...@sbcglobal.net>.
Ravinder Reddy Pandiri wrote:
>
> hi,
> I am getting the following error while executing the the line
> s.executeUpdate("get cursor c1 as 'select * from t2'");
Hi Ravinder,
The get cursor syntax is ij syntax. In a java program, you should use
the JDBC method Statement.setCursorName(String cursorName) to set the
name and then Statment.executeQuery() to execute the query.
Re: Creating an Open cursor..
Posted by Kathey Marsden <km...@sbcglobal.net>.
Ravinder Reddy Pandiri wrote:
>
> hi ,
>
> In one of the JUnit testcases I need to have an OpenCursor.
> what's wrong with the following code.?
>
> Statement s = createStatement(ResultSet.TYPE_FORWARD_ONLY ,
> ResultSet.CONCUR_UPDATABLE);
> assertUpdateCount(s , 0 , "create table t2(c21 int not null
> primary key)");
> assertUpdateCount(s , 1 , "insert into t2 values(21)");
> assertUpdateCount(s , 1 , "insert into t2 values(22)");
> ResultSet rs = s.executeQuery("select * from t2");
> rs.next();
> assertStatementError("X0X95" , s , "rename table t2 to fake");
>
> I am expecting the last statement to give an error as we can't
> rename a table when
> there is an open cursor on it.But the last statement is not throwing
> any exception.?
> plzz help me in this regards.
>
> Thank You in Advance.
I tried this and I think it looks like a bug. Please file a Jira
entry. Then comment out the test and put the bug number in the comments.
Kathey
Re: problems in Transaction Code..
Posted by Bryan Pendleton <bp...@amberpoint.com>.
> In one of our projects that we are working on derby ,
> we need to know the last write operation on a particular Object
It seems like you can implement this with a trigger. Would that
be acceptable?
http://db.apache.org/derby/docs/10.3/ref/rrefsqlj43125.html
thanks,
bryan
problems in Transaction Code..
Posted by Ravinder Reddy <pa...@students.iiit.ac.in>.
hi,
In one of our projects that we are working on derby ,
we need to know the last write operation on a particular
Object in a Transaction.We need to put some markers after these last write
operations so that we will detect it at run time and do some specific
action.
plzz help us in doing this and what other problems might arise and
what Other modules need to be midified.
Thank You.
******************************************************************************
Every problem that has been solved can be solved again in a better way
- Ravinder Reddy
*******************************************************************************
Re: Creating an Open cursor..
Posted by Ravinder Reddy Pandiri <pa...@students.iiit.ac.in>.
On Tue, 7 Aug 2007, Daniel John Debrunner wrote:
> Ravinder Reddy Pandiri wrote:
>
>> assertUpdateCount(s , 0 , "create table t2(c21 int not null primary
>> key)");
>> assertUpdateCount(s , 1 , "insert into t2 values(21)");
>> assertUpdateCount(s , 1 , "insert into t2 values(22)");
>
> On a separate issue I would avoid having asserts for every line of code in a
> test. Use asserts only for the actual elements that are being tested. In this
> case the create table and inserts are not really part of the test fixture,
> they are set up code.
>
> This is to allow the tests to be easy to understand and to allow someone
> looking at the code later to instantly see what the focus of the test fixture
> is. E.g. if there are three lines with assert code then it's obvious that's
> the focus of the test fixture. If those three lines are hidden within ten
> other asserts that assert any setup up or cleanup code then it becomes less
> obvious what is going on.
>
> The correct update count from an INSERT or a CREATE TABLE should only be in
> the text class & fixtures that are explicitly testing INSERT or CREATE TABLE.
>
> Dan.
Thank You Kathey and Dan.
Definately I will consider this for my next conversions.
>
>
>
>
--
******************************************************************************
Every problem that has been solved can be solved again in a better way
- Ravinder Reddy
*******************************************************************************
--
This message has been scanned for viruses and
dangerous content by MailScanner, and is
believed to be clean.
Re: Creating an Open cursor..
Posted by Daniel John Debrunner <dj...@apache.org>.
Ravinder Reddy Pandiri wrote:
> assertUpdateCount(s , 0 , "create table t2(c21 int not null primary
> key)");
> assertUpdateCount(s , 1 , "insert into t2 values(21)");
> assertUpdateCount(s , 1 , "insert into t2 values(22)");
On a separate issue I would avoid having asserts for every line of code
in a test. Use asserts only for the actual elements that are being
tested. In this case the create table and inserts are not really part of
the test fixture, they are set up code.
This is to allow the tests to be easy to understand and to allow someone
looking at the code later to instantly see what the focus of the test
fixture is. E.g. if there are three lines with assert code then it's
obvious that's the focus of the test fixture. If those three lines are
hidden within ten other asserts that assert any setup up or cleanup code
then it becomes less obvious what is going on.
The correct update count from an INSERT or a CREATE TABLE should only be
in the text class & fixtures that are explicitly testing INSERT or
CREATE TABLE.
Dan.
Creating an Open cursor..
Posted by Ravinder Reddy Pandiri <pa...@students.iiit.ac.in>.
hi ,
In one of the JUnit testcases I need to have an OpenCursor.
what's wrong with the following code.?
Statement s = createStatement(ResultSet.TYPE_FORWARD_ONLY , ResultSet.CONCUR_UPDATABLE);
assertUpdateCount(s , 0 , "create table t2(c21 int not null primary key)");
assertUpdateCount(s , 1 , "insert into t2 values(21)");
assertUpdateCount(s , 1 , "insert into t2 values(22)");
ResultSet rs = s.executeQuery("select * from t2");
rs.next();
assertStatementError("X0X95" , s , "rename table t2 to fake");
I am expecting the last statement to give an error as we can't rename a table when
there is an open cursor on it.But the last statement is not throwing any exception.?
plzz help me in this regards.
Thank You in Advance.
--
******************************************************************************
Every problem that has been solved can be solved again in a better way
- Ravinder Reddy
*******************************************************************************
--
This message has been scanned for viruses and
dangerous content by MailScanner, and is
believed to be clean.
help requires regarding get cursor..!!
Posted by Ravinder Reddy Pandiri <pa...@students.iiit.ac.in>.
hi,
I am getting the following error while executing the the
line
s.executeUpdate("get cursor c1 as 'select * from t2'");
in one of the testcases of DERBY-2968.
The Error is:
testRenameOpenCursoredTable(org.apache.derbyTesting.functionTests.tests.lang.RenameTableTest)java.sql.SQLException:
Syntax error: Encountered "get" at line 1, column 1.
at org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown Source)
at org.apache.derby.impl.jdbc.Util.generateCsSQLException(Unknown Source)
at org.apache.derby.impl.jdbc.TransactionResourceImpl.wrapInSQLException(Unknown Source)
at org.apache.derby.impl.jdbc.TransactionResourceImpl.handleException(Unknown Source)
at org.apache.derby.impl.jdbc.EmbedConnection.handleException(Unknown Source)
at org.apache.derby.impl.jdbc.ConnectionChild.handleException(Unknown Source)
at org.apache.derby.impl.jdbc.EmbedStatement.execute(Unknown Source)
at org.apache.derby.impl.jdbc.EmbedStatement.executeUpdate(Unknown Source)
at org.apache.derbyTesting.functionTests.tests.lang.RenameTableTest.testRenameOpenCursoredTable(RenameTableTest.java:66)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at org.apache.derbyTesting.junit.BaseTestCase.runBare(BaseTestCase.java:83)
Caused by: ERROR 42X01: Syntax error: Encountered "get" at line 1, column
1. at org.apache.derby.iapi.error.StandardException.newException(Unknown Source)
at org.apache.derby.impl.sql.compile.ParserImpl.parseStatement(Unknown Source)
at org.apache.derby.impl.sql.GenericStatement.prepMinion(Unknown Source)
at org.apache.derby.impl.sql.GenericStatement.prepare(Unknown Source)
at org.apache.derby.impl.sql.conn.GenericLanguageConnectionContext.prepareInternalStatement(Unknown Source)
... 19 more
Thanks in Advance.
Ravinder
--
******************************************************************************
Every problem that has been solved can be solved again in a better way
- Ravinder Reddy
*******************************************************************************
--
This message has been scanned for viruses and
dangerous content by MailScanner, and is
believed to be clean.
Re: reg: DatabaseMetaData.getTables()
Posted by Bryan Pendleton <bp...@amberpoint.com>.
> ResultSet rs1 = databaseMetaData.getTables("", null, "%", null);
>
> I am getting the syntax error in the last line.
> The Error is:
> Syntax error: Encountered "ORDER" at line 1, column 815
This sounds like a build problem to me. Under the covers, the getTables()
method invokes a system procedure to retrieve the table information
from the system catalogs, and perhaps the syntax error is somehow coming
from that getTables() call. Perhaps you somehow have code which doesn't
match the proper version of the system procedure against the code stored
in the database tables.
Do you have the full stack-trace of the error?
I'd suggest:
- doing an ant clobber, then rebuilding your source tree
- then removing and recreating all of your test databases.
thanks,
bryan
reg: DatabaseMetaData.getTables()
Posted by Ravinder Reddy Pandiri <pa...@students.iiit.ac.in>.
hi,
In one of the JUnit test cases I have the following code.
Statement s = createStatement();
DatabaseMetaData databaseMetaData;
databaseMetaData = getConnection().getMetaData();
ResultSet rs1 = databaseMetaData.getTables("", null, "%", null);
I am getting the syntax error in the last line.
The Error is:
Syntax error: Encountered "ORDER" at line 1, column 815
plzz help me in this regards.
Thank U in advance.
--
******************************************************************************
Every problem that has been solved can be solved again in a better way
- Ravinder Reddy
*******************************************************************************
--
This message has been scanned for viruses and
dangerous content by MailScanner, and is
believed to be clean.
Re: regarding unique keys in derby..
Posted by "Dag H. Wanvik" <Da...@Sun.COM>.
Ravinder Reddy Pandiri <pa...@students.iiit.ac.in> writes:
>> You are easily shocked #:)
> I think most of the database systems(oracle , db2 , mySql ,
> postgreSQL et al) allow a unique key column to contain NULL values.
> That's why I am shocked..!!!!!
Cf DERBY-2212, which will address this missing feature.
Dag
Re: regarding unique keys in derby..
Posted by Ravinder Reddy Pandiri <pa...@students.iiit.ac.in>.
On Fri, 20 Jul 2007, Kathey Marsden wrote:
> Ravinder Reddy wrote:
>>
>> hi all,
>> w.r.t DERBY-2945(convert lang/primarykey.sql to junit)
>> I have a small doubt.
>>
>> There is a test for verifying a unique key can not contain nulls.
>>
>> 1)-- verify that a unique key can not contain nulls
>> create table pos1 (c1 int not null unique, c2 int);
>> insert into pos1 (c1) values(null);
>> insert into pos1 (c1) values(null);
>> select * from pos1;
>> drop table pos1;
>> And It tests that null values are not allowed in c1.
>> Irrespective of uniqueness , c1 can't contain null values as it is
>> defined as not null.It seems that the test is wrong.
> The test seems reasonable enough, but I guess it is really testing that
> not null works #:)
> We could have a test like the one below if we don't have one already.
> ij> create table pos1 (c1 int unique, c2 int);
> ERROR 42831: 'C1' cannot be a column of a primary key or unique key
> because it can contain null values.
>>
>> 2) I am shocked to know that Derby doesn't allow a unique key column to
>> contain NULL values.can some somebody justify it.?
>>
> You are easily shocked #:)
I think most of the database systems(oracle , db2 , mySql ,
postgreSQL et al) allow a unique key column to contain NULL values.
That's why I am shocked..!!!!!
Thank You.
>
>
> Kathey
>
>
>
>
--
******************************************************************************
Every problem that has been solved can be solved again in a better way
- Ravinder Reddy
*******************************************************************************
--
This message has been scanned for viruses and
dangerous content by MailScanner, and is
believed to be clean.
Re: regarding unique keys in derby..
Posted by Kathey Marsden <km...@sbcglobal.net>.
Ravinder Reddy wrote:
>
> hi all,
> w.r.t DERBY-2945(convert lang/primarykey.sql to junit)
> I have a small doubt.
>
> There is a test for verifying a unique key can not contain nulls.
>
> 1)-- verify that a unique key can not contain nulls
> create table pos1 (c1 int not null unique, c2 int);
> insert into pos1 (c1) values(null);
> insert into pos1 (c1) values(null);
> select * from pos1;
> drop table pos1;
> And It tests that null values are not allowed in c1.
> Irrespective of uniqueness , c1 can't contain null values as it is
> defined as not null.It seems that the test is wrong.
The test seems reasonable enough, but I guess it is really testing that
not null works #:)
We could have a test like the one below if we don't have one already.
ij> create table pos1 (c1 int unique, c2 int);
ERROR 42831: 'C1' cannot be a column of a primary key or unique key
because it can contain null values.
>
> 2) I am shocked to know that Derby doesn't allow a unique key column
> to contain NULL values.can some somebody justify it.?
>
You are easily shocked #:)
Kathey
regarding unique keys in derby..
Posted by Ravinder Reddy <pa...@students.iiit.ac.in>.
hi all,
w.r.t DERBY-2945(convert lang/primarykey.sql to junit)
I have a small doubt.
There is a test for verifying a unique key can not contain nulls.
1)-- verify that a unique key can not contain nulls
create table pos1 (c1 int not null unique, c2 int);
insert into pos1 (c1) values(null);
insert into pos1 (c1) values(null);
select * from pos1;
drop table pos1;
And It tests that null values are not allowed in c1.
Irrespective of uniqueness , c1 can't contain null values as it is
defined as not null.It seems that the test is wrong.
2) I am shocked to know that Derby doesn't allow a unique key column to
contain NULL values.can some somebody justify it.?
Thank You.
--
******************************************************************************
Every problem that has been solved can be solved again in a better way
- Ravinder Reddy
*******************************************************************************
--
This message has been scanned for viruses and
dangerous content by MailScanner, and is
believed to be clean.
Re: Derby Building problems..
Posted by Ravinder Reddy <pa...@students.iiit.ac.in>.
Thank You bryan.what a silly mistake?.In my old system I have
jdk1.4 in /usr but in new system I have it in /opt.But I have been using
the old ant.properties file.I have been struggling for the last 3 days
for the simple mistake.
n e way Thank You very much.
On Wed, 18 Jul 2007, Bryan Pendleton wrote:
>> [root@localhost ~]# echo $JAVA_HOME
>> /opt/java/j2sdk1.4.2_14
>>
>> [root@localhost ~]# echo $CLASSPATH
>> .:/opt/java/j2sdk1.4.2_14/lib:/opt/java/j2sdk1.4.2_14/lib/tools.jar:
>> /opt/java/j2sdk1.4.2_14/lib/dt.jar:/opt/java/j2sdk1.4.2_14/lib/jpda.jar:
>> /opt/java/j2sdk1.4.2_14/jre/lib/rt.jar:/opt/java/j2sdk1.4.2_14/src.zip:
>> /opt/junit3.8.1/junit.jar:/home/WorkSpace/DerbyGsoc/classes:
>> /root/mysql-connector-java-3.0.17-ga/mysql-connector-java-3.0.17-ga-bin.jar
>> :/home/WorkSpace/DerbyGsoc/java/testing/
>>
>> [root@localhost ~]# cat ant.properties
>> j14lib=/usr/java/j2sdk1.4.2_14/jre/lib
>
> Perhaps the j14lib value in your ant.properties should be
>
> j14lib=/opt/java/j2sdk1.4.2_14/jre/lib
>
> thanks,
>
> bryan
>
>
>
>
--
******************************************************************************
Every problem that has been solved can be solved again in a better way
- Ravinder Reddy
*******************************************************************************
--
This message has been scanned for viruses and
dangerous content by MailScanner, and is
believed to be clean.
Re: Derby Building problems..
Posted by Bryan Pendleton <bp...@amberpoint.com>.
> [root@localhost ~]# echo $JAVA_HOME
> /opt/java/j2sdk1.4.2_14
>
> [root@localhost ~]# echo $CLASSPATH
> .:/opt/java/j2sdk1.4.2_14/lib:/opt/java/j2sdk1.4.2_14/lib/tools.jar:
> /opt/java/j2sdk1.4.2_14/lib/dt.jar:/opt/java/j2sdk1.4.2_14/lib/jpda.jar:
> /opt/java/j2sdk1.4.2_14/jre/lib/rt.jar:/opt/java/j2sdk1.4.2_14/src.zip:
> /opt/junit3.8.1/junit.jar:/home/WorkSpace/DerbyGsoc/classes:
> /root/mysql-connector-java-3.0.17-ga/mysql-connector-java-3.0.17-ga-bin.jar
> :/home/WorkSpace/DerbyGsoc/java/testing/
>
> [root@localhost ~]# cat ant.properties
> j14lib=/usr/java/j2sdk1.4.2_14/jre/lib
Perhaps the j14lib value in your ant.properties should be
j14lib=/opt/java/j2sdk1.4.2_14/jre/lib
thanks,
bryan
Derby Building problems..
Posted by Ravinder Reddy <pa...@students.iiit.ac.in>.
hi all,
while I am trying to build the derby(10.3) in Fedora 7
I am getting the following problems.please help me as my two issues
DERBY-2750 and DERBY-2945 are getting delayed for the same reason.
Some sys info.
[root@localhost ~]# echo $JAVA_HOME
/opt/java/j2sdk1.4.2_14
[root@localhost ~]# echo $CLASSPATH
.:/opt/java/j2sdk1.4.2_14/lib:/opt/java/j2sdk1.4.2_14/lib/tools.jar:
/opt/java/j2sdk1.4.2_14/lib/dt.jar:/opt/java/j2sdk1.4.2_14/lib/jpda.jar:
/opt/java/j2sdk1.4.2_14/jre/lib/rt.jar:/opt/java/j2sdk1.4.2_14/src.zip:
/opt/junit3.8.1/junit.jar:/home/WorkSpace/DerbyGsoc/classes:
/root/mysql-connector-java-3.0.17-ga/mysql-connector-java-3.0.17-ga-bin.jar
:/home/WorkSpace/DerbyGsoc/java/testing/
[root@localhost ~]# cat ant.properties
j14lib=/usr/java/j2sdk1.4.2_14/jre/lib
build.compiler=modern
proceed=false
sane=false
[root@localhost ~]#
I have followed the instructions in BUILDING.txt.
The Error is same i.e
[root@localhost DerbyGsoc]# ant
Buildfile: build.xml
init:
ensuresanitystate:
setissane:
showenv:
[echo] Ant environment:
[echo] Base Directory: /home/WorkSpace/DerbyGsoc
[echo] Build output: /home/WorkSpace/DerbyGsoc/classes
[echo] Compiler: modern
[echo] Sane = false
[echo] Proceed = false
getstate:
state:
shared:
compile:
[javac] Compiling 12 source files to /home/WorkSpace/DerbyGsoc/classes
[javac] Fatal Error: Unable to locate package java.lang in classpath
or bootclasspath
BUILD FAILED
/home/WorkSpace/DerbyGsoc/build.xml:351: The following error occurred
while executing this line:
/home/WorkSpace/DerbyGsoc/java/shared/build.xml:67: Compile failed; see
the compiler error output for details.
Total time: 2 seconds
[root@localhost DerbyGsoc]#
On Sat, 14 Jul 2007, Ravinder Reddy wrote:
> On Fri, 13 Jul 2007, Andrew McIntyre wrote:
>
>> On 7/13/07, Ravinder Reddy <pa...@students.iiit.ac.in> wrote:
>>>
>>>
>>> Thankyou kathey.
>>> On Fri, 13 Jul 2007, Kathey Marsden wrote:
>>>
>>> > Ravinder Reddy wrote:
>>> >>
>>> >> hi,
>>> >>
>>> >> 1) how to get eclipse set up to not use tabs?
>>> >>
>>> > You can go to
>>> > Window->Preferences-> Java->Formatter-> New
>>> > give a profile name and then change the
>>> > Tab Policy to spaces only.
>>> >
>>> > To reformat your source
>>> > Source -> Format
>>> >
>>> >
>>> >> 2) recently I have migrated to a new machine in which Fedora 7 is
>>> >> installed.
>>> >> Some info regarding my system.
>>> >
>>> > Perhaps the issue is this line in your ant.properties
>>> > j14lib=$jdk14_home/jre/lib
>>>
>>> The same problem even If I give the full path.??
>>
>> If you are building from inside Eclipse and get the 'Unable to find
>> package java.lang in classpath or bootclasspath' error, make sure that
>> the JRE system library has been added to your project classpath.
>> Select Properties from the Project menu, then Java Build Path. You
>> should have the JRE System Library from your JDK 1.4.2 installation
>> listed. If not, choose Add Library... and then JRE System Library and
>> click Next.... You may need to select the Alternate JRE button at this
>> point and specify the location of your JDK 1.4.2 installation at this
>> point.
> yes I have tested with JDK 1.4 and JDK 1.5 and with both.But the
> same error.
>>
>> A guide to setting up Eclipse from scratch can be found here:
>>
>> http://wiki.apache.org/db-derby/BuildingDerby
>>
> I have followed this link only.
>> That may also provide some useful tips to getting your Eclipse
>> installation set up properly.
>>
>> best regards,
>> andrew
>>
>>
> Thank You.
>
>
--
******************************************************************************
Every problem that has been solved can be solved again in a better way
- Ravinder Reddy
*******************************************************************************
--
This message has been scanned for viruses and
dangerous content by MailScanner, and is
believed to be clean.
Re: Using eclipse to work with derby..
Posted by Ravinder Reddy <pa...@students.iiit.ac.in>.
On Fri, 13 Jul 2007, Andrew McIntyre wrote:
> On 7/13/07, Ravinder Reddy <pa...@students.iiit.ac.in> wrote:
>>
>>
>> Thankyou kathey.
>> On Fri, 13 Jul 2007, Kathey Marsden wrote:
>>
>> > Ravinder Reddy wrote:
>> >>
>> >> hi,
>> >>
>> >> 1) how to get eclipse set up to not use tabs?
>> >>
>> > You can go to
>> > Window->Preferences-> Java->Formatter-> New
>> > give a profile name and then change the
>> > Tab Policy to spaces only.
>> >
>> > To reformat your source
>> > Source -> Format
>> >
>> >
>> >> 2) recently I have migrated to a new machine in which Fedora 7 is
>> >> installed.
>> >> Some info regarding my system.
>> >
>> > Perhaps the issue is this line in your ant.properties
>> > j14lib=$jdk14_home/jre/lib
>>
>> The same problem even If I give the full path.??
>
> If you are building from inside Eclipse and get the 'Unable to find
> package java.lang in classpath or bootclasspath' error, make sure that
> the JRE system library has been added to your project classpath.
> Select Properties from the Project menu, then Java Build Path. You
> should have the JRE System Library from your JDK 1.4.2 installation
> listed. If not, choose Add Library... and then JRE System Library and
> click Next.... You may need to select the Alternate JRE button at this
> point and specify the location of your JDK 1.4.2 installation at this
> point.
yes I have tested with JDK 1.4 and JDK 1.5 and with both.But the
same error.
>
> A guide to setting up Eclipse from scratch can be found here:
>
> http://wiki.apache.org/db-derby/BuildingDerby
>
I have followed this link only.
> That may also provide some useful tips to getting your Eclipse
> installation set up properly.
>
> best regards,
> andrew
>
>
Thank You.
--
******************************************************************************
Every problem that has been solved can be solved again in a better way
- Ravinder Reddy
*******************************************************************************
--
This message has been scanned for viruses and
dangerous content by MailScanner, and is
believed to be clean.
Re: Using eclipse to work with derby..
Posted by Andrew McIntyre <mc...@gmail.com>.
On 7/13/07, Ravinder Reddy <pa...@students.iiit.ac.in> wrote:
>
>
> Thankyou kathey.
> On Fri, 13 Jul 2007, Kathey Marsden wrote:
>
> > Ravinder Reddy wrote:
> >>
> >> hi,
> >>
> >> 1) how to get eclipse set up to not use tabs?
> >>
> > You can go to
> > Window->Preferences-> Java->Formatter-> New
> > give a profile name and then change the
> > Tab Policy to spaces only.
> >
> > To reformat your source
> > Source -> Format
> >
> >
> >> 2) recently I have migrated to a new machine in which Fedora 7 is
> >> installed.
> >> Some info regarding my system.
> >
> > Perhaps the issue is this line in your ant.properties
> > j14lib=$jdk14_home/jre/lib
>
> The same problem even If I give the full path.??
If you are building from inside Eclipse and get the 'Unable to find
package java.lang in classpath or bootclasspath' error, make sure that
the JRE system library has been added to your project classpath.
Select Properties from the Project menu, then Java Build Path. You
should have the JRE System Library from your JDK 1.4.2 installation
listed. If not, choose Add Library... and then JRE System Library and
click Next.... You may need to select the Alternate JRE button at this
point and specify the location of your JDK 1.4.2 installation at this
point.
A guide to setting up Eclipse from scratch can be found here:
http://wiki.apache.org/db-derby/BuildingDerby
That may also provide some useful tips to getting your Eclipse
installation set up properly.
best regards,
andrew
Re: Using eclipse to work with derby..
Posted by Ravinder Reddy <pa...@students.iiit.ac.in>.
Thankyou kathey.
On Fri, 13 Jul 2007, Kathey Marsden wrote:
> Ravinder Reddy wrote:
>>
>> hi,
>>
>> 1) how to get eclipse set up to not use tabs?
>>
> You can go to
> Window->Preferences-> Java->Formatter-> New
> give a profile name and then change the
> Tab Policy to spaces only.
>
> To reformat your source
> Source -> Format
>
>
>> 2) recently I have migrated to a new machine in which Fedora 7 is
>> installed.
>> Some info regarding my system.
>
> Perhaps the issue is this line in your ant.properties
> j14lib=$jdk14_home/jre/lib
The same problem even If I give the full path.??
>
> Try putting in the full path instead of using $jdk14_home. Also check that
> JAVA_HOME is set.
yes JAVA_HOME is set as I posted in the prev mail.
>
> Kathey
>
>
>
>
Thank You
--
******************************************************************************
Every problem that has been solved can be solved again in a better way
- Ravinder Reddy
*******************************************************************************
--
This message has been scanned for viruses and
dangerous content by MailScanner, and is
believed to be clean.
Re: Using eclipse to work with derby..
Posted by Kathey Marsden <km...@sbcglobal.net>.
Ravinder Reddy wrote:
>
> hi,
>
> 1) how to get eclipse set up to not use tabs?
>
You can go to
Window->Preferences-> Java->Formatter-> New
give a profile name and then change the
Tab Policy to spaces only.
To reformat your source
Source -> Format
> 2) recently I have migrated to a new machine in which Fedora 7 is
> installed.
> Some info regarding my system.
Perhaps the issue is this line in your ant.properties
j14lib=$jdk14_home/jre/lib
Try putting in the full path instead of using $jdk14_home. Also check
that JAVA_HOME is set.
Kathey