Skip to Main Content
Forums

Java Card

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How to upload a signed CAP file into a SSD with DAP

Ranjini HKApr 2 2015 — edited Apr 2 2015

Good day.

Hi All, I want to upload the signed cap file into the SSD with DAP. But my upload is failed. I Also want to know the Installing method.

Below are the steps i followed to create SSD with DAP and cap siging.

cm> /card

cm> auth

cm> ls

..

Card Manager AID   :  A000000151000000

Card Manager state :  OP_READY

    Load File  :      LOADED (--------) A0000001515350(Security Domain)

     Module    :                        A000000151535041

cm> install -b -s -i A000000151535041 A0000001515350 A000000151535041

cm> /select A000000151535041

cm> set-key 255/1/DES-ECB/404142434445464748494a4b4c4d4e4f 255/2/DES-ECB/404142434445464748494a4b4c4d4e4f 255/3/DES-ECB/404142434445464748494a4b4c4d4e4f

cm> auth

cm> set-key 1/1/DES-ECB/505152535455565758595a5b5c5d5e5f 1/2/DES-ECB/505152535455565758595a5b5c5d5e5f 1/3/DES-ECB/505152535455565758595a5b5c5d5e5f

cm> put-keyset 1

// input of RSA public key in the Security Domain

cm> put-pub-key --tokenpin 123456 115 "F:\my_pkcs12.p12"

cm> /card

cm> auth

cm> ls

Card Manager AID   :  A000000151000000

Card Manager state :  OP_READY

    Sec. Domain:PERSONALIZED (SV------) A000000151535041    

    Load File  :      LOADED (--------) A0000001515350 

     Module    :                        A000000151535041

After personalizing the SSD, Signed the cap file for DAP geneation

cm> /cap-sign --tokenpin "123456" "E:\test.cap" A000000151535041 "F:\my_pkcs12.p12"

After signing the cap , i tried to upload the cap file :

cm> upload -s A000000151535041   "E:\test.cap"

ERROR : 0x6985 (conditions not satisfied)

So please help me in resolving this issue, & let me know where m going wrong.Please let me know the steps to UPLOAD & INSTALL the applet into the SSD.

Comments

Karthick2003

First step can you describe TABLE1 and TABLE2?

2611484

I already edit the question

Karthick2003 
Describe means like this

SQL> desc emp
 Name                                      Null?    Type
 ----------------------------------------- -------- ----------------------------
 EMPNO                                     NOT NULL NUMBER
 ENAME                                              VARCHAR2(6)
 JOB                                                VARCHAR2(9)
 MGR                                                NUMBER
 HIREDATE                                           DATE
 SAL                                                NUMBER
 COM                                                NUMBER
 DEPTNO                                             NUMBER

SQL> desc dept
 Name                                      Null?    Type
 ----------------------------------------- -------- ----------------------------
 DEPTNO                                    NOT NULL NUMBER
 DNAME                                              VARCHAR2(10)
 LOC                                                VARCHAR2(8)

SQL>
2611484

I posted the desc of table

Karthick2003

>  and c.status like 'ANSWERED%'

I dont see STATUS column in Table2

2611484

sorry i accidentally erase, now there's a status table

Karthick2003

Ok got it, Change this

select 'Data'
       ||','||to_char(d.dtime_day,'MM/dd/yyyy')
       ||','||sg1_cnt

To

select 'Data'
       ||','||dtime_day 


       ||','||sg1_cnt

dtime_day is already converted in the inner query.

2611484

i changed it already but i got zero results only, which is not right. each item have large total of result

Karthick2003

> i changed it already

Should I use my crystal ball to find it out?

> but i got zero results only, which is not right. each item have large total of result

Without your data i cant do much.

Moazzam 
select 'Data'


||','||to_char(d.dtime_day,'MM/dd/yyyy')


||','||sg1_cnt


||','||sg2_cnt


||','||sg3_cnt


||','||sg4_cnt


||','||sg5_cnt


||','||sg6_cnt


||','||sg7_cnt


||','||sg8_cnt


||','||sg9_cnt


||','||sg10_cnt

In the above select statement, which tables contains the columns (sg1_cnt, sg2_cnt, sg3_cnt.....etc), I think by removing these columns from SELECT shall fix the issue.

Karthick2003

Those come from the PIVOT. That is fine.

2611484

i change the sql script, but i got still zero results

Karthick2003 
33795304-702b-48ff-b4ba-e896b1db94db wrote:




i change the sql script, but i got still zero results

That means some of your conditions are failing. As said already without knowing what's in the table cant help. Just check you join and where conditions.

padders

Just to be clear, are you asking us to tell you why a query we haven't seen returns no rows based on data we haven't seen?

1 person found this helpful
2611484

I just posted some data of each table coumn

2611484

I already edited my post - sql sript and added more info about table columns

1 - 16
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Apr 30 2015
Added on Apr 2 2015
#applet, #java-card
0 comments
1,211 views