closing old connections from h2 console

[Adam McMahon]

Hi,

I am using H2 embedded in a web app with db_close_delay=-1.  The code in my 
app closes connections fine.  However, on occasion we use the h2 web 
console to manage things.  Since it is in a web browser, on occasion we 
close the browser while forgetting to hit the disconnect button (I know, 
human error... but we are used to simply closing browsers when we are done 
with them).   This leaves a few connections that seem to stick around for a 
while.  Is there a way I can run either a function or sql command to clean 
up connections that have been around for a period of time?

Another possible idea is to add an onUnload event to the console html that 
send a quick ping to servlet to close the connection.  I might just add 
this if there is not a good solution.

-Adam

-- 
You received this message because you are subscribed to the Google Groups H2 
Database group.
To view this discussion on the web visit 
https://groups.google.com/d/msg/h2-database/-/1_xsS7F2vqkJ.
To post to this group, send email to h2-database@googlegroups.com.
To unsubscribe from this group, send email to 
h2-database+unsubscr...@googlegroups.com.
For more options, visit this group at 
http://groups.google.com/group/h2-database?hl=en.

CSVWRITE - Title of CSV File to include system date?

[sc8132]

Hi,

I have a call csvwrite script for my database. How can I include the system 
date in the title of the csv file?

Here is the current working script:
CALL CSVWRITE('C:\TEMP\exportdata.csv','SELECT DATA_PUSH.* 
FROM PUBLIC.DATA_PUSH 
DATA_PUSH','fieldDelimiter= writeColumnHeader=false');

Thanks!
Sherry

-- 
You received this message because you are subscribed to the Google Groups H2 
Database group.
To view this discussion on the web visit 
https://groups.google.com/d/msg/h2-database/-/_TwbDgYz_tcJ.
To post to this group, send email to h2-database@googlegroups.com.
To unsubscribe from this group, send email to 
h2-database+unsubscr...@googlegroups.com.
For more options, visit this group at 
http://groups.google.com/group/h2-database?hl=en.

CSVWRITE - How do you sort the order of the columns?

[sc8132]

Hi,

I have a call csvwrite script for my database. How can I change script so 
that it allows me to control the sort order of the columns?
I want specific columns of my table to be in specific order (ie: Date, 
Name, Location, Phone, etc).

CALL CSVWRITE('C:\TEMP\exportdata.csv','SELECT DATA_PUSH.* FROM 
PUBLIC.DATA_PUSH 
DATA_PUSH','fieldDelimiter= writeColumnHeader=false');

Thanks!
Sherry

-- 
You received this message because you are subscribed to the Google Groups H2 
Database group.
To view this discussion on the web visit 
https://groups.google.com/d/msg/h2-database/-/WMRRLS9R1aIJ.
To post to this group, send email to h2-database@googlegroups.com.
To unsubscribe from this group, send email to 
h2-database+unsubscr...@googlegroups.com.
For more options, visit this group at 
http://groups.google.com/group/h2-database?hl=en.

Re: CSVWRITE - How do you sort the order of the columns?

[Brian]

You'll need to explicitly name and order them in your select statement.
select date,name,location,phone from data_push

On Thursday, September 27, 2012 6:28:54 AM UTC-7, sc8132 wrote:

 Hi,

 I have a call csvwrite script for my database. How can I change script so 
 that it allows me to control the sort order of the columns?
 I want specific columns of my table to be in specific order (ie: Date, 
 Name, Location, Phone, etc).

 CALL CSVWRITE('C:\TEMP\exportdata.csv','SELECT DATA_PUSH.* FROM 
 PUBLIC.DATA_PUSH 
 DATA_PUSH','fieldDelimiter= writeColumnHeader=false');

 Thanks!
 Sherry



-- 
You received this message because you are subscribed to the Google Groups H2 
Database group.
To view this discussion on the web visit 
https://groups.google.com/d/msg/h2-database/-/xVwpToST_YQJ.
To post to this group, send email to h2-database@googlegroups.com.
To unsubscribe from this group, send email to 
h2-database+unsubscr...@googlegroups.com.
For more options, visit this group at 
http://groups.google.com/group/h2-database?hl=en.

Re: CSVWRITE - Title of CSV File to include system date?

[Brian]

call csvwrite('c:/temp/fileprefix-' || current_date(),'select * from 
data_push');

On Thursday, September 27, 2012 6:30:03 AM UTC-7, sc8132 wrote:

 Hi,

 I have a call csvwrite script for my database. How can I include the 
 system date in the title of the csv file?

 Here is the current working script:
 CALL CSVWRITE('C:\TEMP\exportdata.csv','SELECT DATA_PUSH.* 
 FROM PUBLIC.DATA_PUSH 
 DATA_PUSH','fieldDelimiter= writeColumnHeader=false');

 Thanks!
 Sherry


-- 
You received this message because you are subscribed to the Google Groups H2 
Database group.
To view this discussion on the web visit 
https://groups.google.com/d/msg/h2-database/-/uFEVUkCINhYJ.
To post to this group, send email to h2-database@googlegroups.com.
To unsubscribe from this group, send email to 
h2-database+unsubscr...@googlegroups.com.
For more options, visit this group at 
http://groups.google.com/group/h2-database?hl=en.