Skip to Main Content

Java HotSpot Virtual Machine

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!

JAVA NATIVE ACESS

843829Sep 9 2010 — edited Sep 9 2010
HI,
I have a big problem with Java Native Access when call a function in dll file.

First, I have files xxx.dll,xxx.h (written by my partner) and document for functions.
Second, I am using JNA (java native access) to call the functions.
But, it has some functions that function's result is pass over memory of window.
In document description, it has tow constant: WM_USER = 0x0400, WM_USER_ENV = (WM_USER + 0)
I have just learn, so i don't know about that.

So, my problem is " i don't know how to get result of function that passed over to memory window )

This is my header file: “MFSIOCTL.h”
-----------------------------------------------------------------------------------------------------------------------------------------------
// Command

#define CMD_VERSION 'V'
#define CMD_SENSOR 'S'
#define CMD_FLICKER 'L'
#define CMD_GETSTATUS 'A'

#define DEST_1 '1' //front door / Card Reader Flicker Lamp
#define DEST_2 '2' //UPPER FRAME IN POSITION(CDM) / Printer Lamp
#define DEST_3 '3' //Receipt Exit Sensor / Cheque Lamp
#define DEST_4 '4' //Cheque Door Sensor / A4 or Cash Lamp
#define DEST_5 '5' //Bill Hopper Sensor - 2006/06/20 added

#define DEST_ALL '0' //Get all Status

//switch status or FLicker Lamp on/off
#define OPEN '0' //Flicker Off
#define CLOSE '1' //Flicker On

//added at 2004/09/17
#define WM_MFS_IO_OFFSET (WM_USER+0x900)
#define WM_MFS_IO_CHG_EVT (WM_MFS_IO_OFFSET + 0)


extern "C" __declspec(dllexport) BOOL __stdcall MFSIO_Open(HWND hWnd,BYTE comport);
extern "C" __declspec(dllexport) BOOL __stdcall MFSIO_Close(void);
extern "C" __declspec(dllexport) BOOL __stdcall MFSIO_GetVersion(LPSTR lpFWVer,LPSTR lpDLLVer);
extern "C" __declspec(dllexport) BOOL __stdcall MFSIO_LED(BYTE LEDNum,BYTE OnOff);
extern "C" __declspec(dllexport) BYTE __stdcall MFSIO_GetStatus(void);
-----------------------------------------------------------------------------------------------------------------------------------------------
And this is window message define:
--- Definition of Window Message
: Message is defined in “MFSIOCTL.h” as bellows.
#define WM_MFS_IO_OFFSET (WM_USER+0x900)
#define WM_MFS_IO_CHG_EVT (WM_MFSS_IO_OFFSET + 0)
MESSAGE WPARAM(Indicator ofDoor or Media) LPARAM(Status of Door or Media)
WM_MFSS_IO_CHG_EVT DEST_1 or OPEN or CLOSE
DEST_2 or
DEST_3 or
DEST_4



Refer to “MFSIOCTL.h”
-----------------------------------------------------------------------------------------------------------------------------------------------
In functions, i don't know that they relative with parameters as "WM_MSF_IO_OFFSET, WM_MFS_IO_CHG_EVT'' and parameters use for what?
How to get value of window message?

Please help me. Thank you.

Edited by: QuocTan on Sep 8, 2010 9:31 PM

Edited by: QuocTan on Sep 8, 2010 9:34 PM

Comments

Frank Kulash

Hi,

It's not clear what you want.  It would help if you posted a little sample data (CREATE TABLE and INSERT statements) and the exact results you want from that sample data.

If you want to SUM, or do any kind of aggregate function, on multiple columns, here's one way:

WITH    pivot_data    AS

(

    SELECT  job, sal, comm, deptno

    FROM    scott.emp

)

SELECT    *

FROM      pivot_data

PIVOT     (    SUM (sal)      AS sal

          ,    SUM (comm)     AS comm

          ,    AVG (sal)      AS avgsal

          FOR  job  IN ( 'ANALYST'    AS analyst

                       , 'CLERK'      AS clerk

                       , 'MANAGER'    AS mannager

                       , 'PRESIDENT'  AS president

                       , 'SALESMAN'   AS salesman

                       )

          )

ORDER BY  deptno

;

See the Forum FAQ:

odie_63
Answer

TexasApexDeveloper wrote:

I haven't found any documentation showing how to have multiple columns summed in a pivot query yet.

Not even THE official documentation?

http://docs.oracle.com/cd/E11882_01/server.112/e25554/analysis.htm#DWHSG8731

Marked as Answer by TexasApexDeveloper · Sep 27 2020
TexasApexDeveloper

My bad, I should have done further research.. That looks spot on!!

Thank you,

Tony Miller
LuvMuffin Software
Ruckersville, VA

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

Post Details

Locked on Oct 7 2010
Added on Sep 9 2010
1 comment
225 views