Forums

Articles
Create
cancel
Showing results for 
Search instead for 
Did you mean: 

query returns random result

Silver Salonen
Contributor
April 6, 2014

I've created a pocket-query statement for quering IP-addresses from database:

SELECT INET_NTOA(host.ip) AS ip FROM host WHERE hostname = :hostname

When I execute such query from command-line, I get a proper IP-address, but using the query from macro returns me something like "[B@78945a43". The numbers and letters in that string are always different after the first "[B@".

Any clues what is this?

1 answer

0 votes
Felix Grund (Scandio)
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
June 15, 2014

Hi Silver,

Sorry for the late reply, I somehow didn't see this question. What you get ("[B@...]") are Java identifiers which means that PocketQuery cannot translate the data returned from your database as strings.

Could you run this statement with another SQL tool and send me the result? Also, some metadata of that "host.ip" column would be useful. I'd need to figure out what kind of data PocketQuery is trying to interpret.

Regards, Felix

Suggest an answer

Log in or Sign up to answer
TAGS
atlassian, jira product discovery, jpd premium, product management, idea management, product discovery, jira premium, product planning, atlassian community, product development, roadmap planning, product prioritization, feature management

Introducing Jira Product Discovery Premium ✨

Jira Product Discovery Premium is now available! Get more visibility, control, and support to build products at scale.

Learn more
AUG Leaders

Atlassian Community Events