SoftTree Technologies SoftTree Technologies
Technical Support Forums
RegisterSearchFAQMemberlistUsergroupsLog in
Errors using note ++. When I execute a SQL comes just a mes

 
Reply to topic    SoftTree Technologies Forum Index » SQL Assistant View previous topic
View next topic
Errors using note ++. When I execute a SQL comes just a mes
Author Message
jnp@alka.dk



Joined: 01 Oct 2012
Posts: 5
Country: Denmark

Post Errors using note ++. When I execute a SQL comes just a mes Reply with quote
Hi
Errors using note + +. When I execute a SQL comes just a message that the system is run and I must wait. Unfortunately stays there. The answer from the SQL occurs when closing this message.

I press ctr + shift + F9. Is there a way to Avoid this error?
I'm using the latest SQL Assistants with the big license and I use Note + + version: v6.1.8


Best Regards
Janus Pedersen
Mon Oct 01, 2012 4:07 am View user's profile Send private message
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 6485

Post Reply with quote
Hi,

Did you mean the Notepad++ editor?
Your issue description doesn't sound like an error, you are execution a query and it's not coming back, right? The query is being executed by your database server, not SQL Assistant.

1. What type and version of the database are you using?
2. How are you connecting to the database (ODBC, ADO, native interface, etc....) ?
3. What kind of a SQL query are you executing?
4. Do you see the same behavior for certain queries or for all types of queries?
Mon Oct 01, 2012 9:37 am View user's profile Send private message
jnp@alka.dk



Joined: 01 Oct 2012
Posts: 5
Country: Denmark

Post I think there error is in the Java program. Reply with quote
Hi
>Did you mean the Notepad++ editor?
Yes.
I hope you can help me. I use SQL Ass in toad and it work fine, but in the Note++ it is not working. I have to close the message befor the result will be shown.

1. What type and version of the database are you using?
Oracle versoin 11g

2. How are you connecting to the database (ODBC, ADO, native interface, etc....) ?
I use OCI from Toad or Oracle

3. What kind of a SQL query are you executing?
All. But just to write somthing
SELECT
v.post_area,
v.street,
v.kommunekode,
v.vejkode,
v.husnrfra,
v.husnrtil,
v.ligeulige,
v.fork_vejnavn,
v.behandlet,
v.userid,
v."TIMESTAMP",
v.record_version
FROM
vejnavn v
4. Do you see the same behavior for certain queries or for all types of queries?
I see this for all.






Mon Oct 01, 2012 10:01 am View user's profile Send private message
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 6485

Post Reply with quote
Thank you. I now clearly understand the issue.
I have tried the same with Notepad++ 6.1.2 and with Notepad++ 6.1.8 and I can not reproduce it. On my test system I get both tabs at the same time.

Do you get the same result when you use SQL Assistant's right-click menu to execute the query? Please try right-click menu in the editor, and separately right-click menu for SQL Assistant's system-tray icon.

Does it happen when you execute something very simple, like SELECT * FROM dual; ?
Mon Oct 01, 2012 10:33 am View user's profile Send private message
jnp@alka.dk



Joined: 01 Oct 2012
Posts: 5
Country: Denmark

Post Reply with quote
Hi
I don`t get this error from SELECT * FROM dual. I found out that my data connection is slow and the error is that SQL A wait for all the data to return.

I use the oci to cennect to Oracle. Is there a faster or better way to connect to a Oracle database?

I have the same error when I use the SQL Assistant's system-tray icon.

Thanks for all the help so far.

I am new in the Oracle world.
Mon Oct 01, 2012 4:33 pm View user's profile Send private message
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 6485

Post Reply with quote
Please try running


Code:
SELECT
   v.post_area,
   v.street,
   v.kommunekode,
   v.vejkode,
   v.husnrfra,
   v.husnrtil,
   v.ligeulige,
   v.fork_vejnavn,
   v.behandlet,
   v.userid,
   v."TIMESTAMP",
   v.record_version
FROM
   vejnavn v
WHERE
   ROWNUM < 1000


Is that query coming back fast?
How many records are in vejnavn table?
Mon Oct 01, 2012 5:02 pm View user's profile Send private message
jnp@alka.dk



Joined: 01 Oct 2012
Posts: 5
Country: Denmark

Post Reply with quote
Hi
Thanks this works. So ROWNUM is like top in a ms sql.
>Is that query coming back fast?
This come back fast.

>How many records are in vejnavn table?
It is all the roads in DK. I think it is 100 M or more.

This solve my problem.
Mon Oct 01, 2012 5:07 pm View user's profile Send private message
jnp@alka.dk



Joined: 01 Oct 2012
Posts: 5
Country: Denmark

Post Reply with quote
Executing selected queries... Please wait or close this tab to cancel execution.
999 rows fetched.
The command(s) completed successfully (1.80 s).

Is this normal for a Oracle DB?

It is slow for a ms SQL db.
Mon Oct 01, 2012 5:12 pm View user's profile Send private message
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 6485

Post Reply with quote
Now it all makes sense. Returning 999 records is fast and you see your result. Yes rownum <= 1000 in Oracle does the same as TOP 1000 in SQL Server. rownum < 1000 returns first 999 rows.

Retrieving 100M rows leads to a very very large result set that must be first read from the server disks, buffered, locked, sent across the network wires, formatted on the client for display, cached, etc.... The processing in this case should take a long time.

If you need just the data, but not to display all 100M records, you can use SQL Assistant's script table data feature which outputs the data to files as it is retrieved from server and that processing should be a bit faster. Still getting 100M out of the database server is a slow process by definition, it doesn't matter which database server you use, Oracle, SQL Server or anything else.

Hope that helps.
Mon Oct 01, 2012 5:22 pm View user's profile Send private message
Display posts from previous:    
Reply to topic    SoftTree Technologies Forum Index » SQL Assistant All times are GMT - 4 Hours
Page 1 of 1

 
Jump to: 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


 

 

Powered by phpBB © 2001, 2005 phpBB Group
Design by Freestyle XL / Flowers Online.