Agador Paloi

Without code to look at , I think you are not setting your textfield size

-Agad

Hello jolly ranchers -

I am trying to compile some java programs with ant and I am getting errors without any detail .

I have tried using -v on the ant command as well as verbose="yes" on the target without much help.


this is part of the output - its too big for the entire thing:

the build file target looks like this: <target name="compile.test.pgms" > <description> STEP compile.test.pgms - compile atlas programs in the integrated source directories </description> <javac srcdir="${src}" destdir="${class}" classpathref="compile.classpath" fork="true" memoryinitialsize="256M" memorymaximumsize="1024M" executable=""C:\Program Files (x86)\Java\jdk1.7.0_17\bin\javac"" verbose="yes" listfiles="yes" compiler="javac1.7" /> </target> output : [javac] Using external javac compiler [javac] Compilation arguments: [javac] '-J-Xms256M' [javac] '-J-Xmx1024M' [javac] '-d' [javac] 'H:\NPGOP9I\Atlas\Atlasv80304\integrated_test\class\atseav8' [javac] '-classpath' [javac] 'H:\NPGOP9I\Atlas\Atlasv80304\integrated_test\class\atseav8;H:\NPGOP9i\Atlas\Atlasv80304\integrated_test\junit4.1\junit-4.1.jar;H:\NPGOP9i\Atlas\Atlasv80304\integrated_test\vendor_jars\jdev-rt.jar;H:\NPGOP9i\Atlas\Atlasv80304\integrated_test\vendor_jars\ojdbc14.jar;H:\NPGOP9i\Atlas\Atlasv80304\integrated_test\vendor_jars\mail.jar;H:\NPGOP9i\Atlas\Atlasv80304\integrated_test\vendor_jars\jaf-1.0.2\activation.jar;C:\apache-ant-1.8.4\lib\ant-launcher.jar;C:\Users\packerp\Documents\ant_buildfiles;C:\Program Files (x86)\Java\jre7\lib\ext\QTJava.zip;C:\apache-ant-1.8.4\lib\ant-antlr.jar;C:\apache-ant-1.8.4\lib\ant-apache-bcel.jar;C:\apache-ant-1.8.4\lib\ant-apache-bsf.jar;C:\apache-ant-1.8.4\lib\ant-apache-log4j.jar;C:\apache-ant-1.8.4\lib\ant-apache-oro.jar;C:\apache-ant-1.8.4\lib\ant-apache-regexp.jar;C:\apache-ant-1.8.4\lib\ant-apache-resolver.jar;C:\apache-ant-1.8.4\lib\ant-apache-xalan2.jar;C:\apache-ant-1.8.4\lib\ant-commons-logging.jar;C:\apache-ant-1.8.4\lib\ant-commons-net.jar;C:\apache-ant-1.8.4\lib\ant-jai.jar;C:\apache-ant-1.8.4\lib\ant-javamail.jar;C:\apache-ant-1.8.4\lib\ant-jdepend.jar;C:\apache-ant-1.8.4\lib\ant-jmf.jar;C:\apache-ant-1.8.4\lib\ant-jsch.jar;C:\apache-ant-1.8.4\lib\ant-junit.jar;C:\apache-ant-1.8.4\lib\ant-junit4.jar;C:\apache-ant-1.8.4\lib\ant-netrexx.jar;C:\apache-ant-1.8.4\lib\ant-swing.jar;C:\apache-ant-1.8.4\lib\ant-testutil.jar;C:\apache-ant-1.8.4\lib\ant.jar;C:\Program Files\Java\jre6\lib\tools.jar' [javac] '-sourcepath' [javac] 'H:\NPGOP9I\Atlas\Atlasv80304\integrated_test\src\atseav8' [javac] '-g:none' [javac] '-verbose' [javac] [javac] The ' characters around the executable and arguments are [javac] not part of the command. [javac] Files to be compiled: [javac] H:\NPGOP9I\Atlas\Atlasv80304\integrated_test\src\atseav8\bc4j\AESCrypto.java [javac] H:\NPGOP9I\Atlas\Atlasv80304\integrated_test\src\atseav8\bc4j\AESFileDecrypt.java [javac] H:\NPGOP9I\Atlas\Atlasv80304\integrated_test\src\atseav8\bc4j\AESFileDecryptBase64.java [javac] H:\NPGOP9I\Atlas\Atlasv80304\integrated_test\src\atseav8\bc4j\AESFileEncrypt.java about 400 lines like the following appear here [javac] H:\NPGOP9I\Atlas\Atlasv80304\integrated_test\src\atseav8\testjunit\JunitRecordStatusDatabase.java [javac] H:\NPGOP9I\Atlas\Atlasv80304\integrated_test\src\atseav8\testjunit\JunitSalmon.java [javac] H:\NPGOP9I\Atlas\Atlasv80304\integrated_test\src\atseav8\testjunit\JunitSalmonDatabase.java [javac] H:\NPGOP9I\Atlas\Atlasv80304\integrated_test\src\atseav8\testjunit\JunitSkatesHooks.java [javac] H:\NPGOP9I\Atlas\Atlasv80304\integrated_test\src\atseav8\testjunit\JunitStressHaulDB.java [javac] H:\NPGOP9I\Atlas\Atlasv80304\integrated_test\src\atseav8\testjunit\JunitTCPIPConnection.java [javac] H:\NPGOP9I\Atlas\Atlasv80304\integrated_test\src\atseav8\testjunit\JunitVessel.java [javac] H:\NPGOP9I\Atlas\Atlasv80304\integrated_test\src\atseav8\testjunit\JunitplantDataBase.java [javac] H:\NPGOP9I\Atlas\Atlasv80304\integrated_test\src\atseav8\testjunit\TestCreateHauls.java [javac] H:\NPGOP9I\Atlas\Atlasv80304\integrated_test\src\atseav8\transmit_req\TransmitReqHaul.java [javac] H:\NPGOP9I\Atlas\Atlasv80304\integrated_test\src\atseav8\transmit_req\TransmitReqOffload.java [javac] H:\NPGOP9I\Atlas\Atlasv80304\integrated_test\src\atseav8\transmit_req\TransmitReqTrip.java BUILD FAILED C:\Users\userp\Documents\ant_buildfiles\v80304_deploy_jar.xml:91: Compile failed; see the compiler error output for details. at org.apache.tools.ant.taskdefs.Javac.compile(Javac.java:1174) at org.apache.tools.ant.taskdefs.Javac.execute(Javac.java:930) at org.apache.tools.ant.UnknownElement.execute(UnknownElement.java:291) at sun.reflect.GeneratedMethodAccessor4.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) at java.lang.reflect.Method.invoke(Unknown Source) at org.apache.tools.ant.dispatch.DispatchUtils.execute(DispatchUtils.java:106) at org.apache.tools.ant.Task.perform(Task.java:348) at org.apache.tools.ant.Target.execute(Target.java:392) at org.apache.tools.ant.Target.performTasks(Target.java:413) at org.apache.tools.ant.Project.executeSortedTargets(Project.java:1399) at org.apache.tools.ant.Project.executeTarget(Project.java:1368) at org.apache.tools.ant.helper.DefaultExecutor.executeTargets(DefaultExecutor.java:41) at org.apache.tools.ant.Project.executeTargets(Project.java:1251) at org.apache.tools.ant.Main.runBuild(Main.java:811) at org.apache.tools.ant.Main.startAnt(Main.java:217) at org.apache.tools.ant.launch.Launcher.run(Launcher.java:280) at org.apache.tools.ant.launch.Launcher.main(Launcher.java:109) Total time: 1 minute 51 seconds

any clues would be appreciated
Agad

Sorry , missed the sql + reference in your Q.

If your going to execute these queries a zillion time you may want to create a function for each in a pl sql package.

Agad

I would put the sql into a single class if this is all the sql you have. I usually put all sql into separate classes for each object type I need to persist in the database.

Agador

Sounds like you want to join table1 with table2 to get a status from table2.
Query would be
SELECT
t2.id ,
t2.status
FROM
table1 t1,
table2 t2
WHERE
t1.id = t2.id


Agad

might want to check out Apex - Application Express.


Agad

Amit -
I ran your first query and got a different result :
(TO_TIMESTAMP('7/26/201105.26.21.596788000AM','MM/DD/YYYYHH:MI:SS:FFAM')-TO_TIMESTAMP('7/26/201105.26.21.504439000AM','MM/DD/YYYYHH:MI:SS:FFAM')) ------------------------------------------------------------------------------------------------------------------------------------------------- 0 0:0:0.092349



agad

Eshwar -

Your query would look something like this:
SELECT SUM( GREATEST( 0, SALARY) ) FROM EMP



Agad

Alsoumahi -

I think you query would look something like this

SELECT t.draw, t.spool FROM t_weld t WHERE t.draw not in ( select draw as i_draw FROM t_weld where fitup is null or welding is null )

- Agad

Matt -
you can also code EXIT WHEN conition to accomplish the same thing.


Agad

I would agree with Paul . Maybe have your country code as a seperate column from your sequence.

Agad

signed on to the HR schema?

Could be duplicate wbt_id in table 1 or table 2?

Agad

Anuj -
I would read the books 'Beginning Oracle Programming' and 'Learning Oracle PL/SQL' .
You should also set up a test schema to play with and try things out.

Good luck.


Agad

Anuj -

I would write the DAO as a seperate class(es) . I useally design the DAO classes around the object classes I need in my application not so much the tables. A DAO class can instanciate or persist an instance of an object in my application.

Agad