Imre Tokai

Hello,

Pushing http://hsqldb.org/ to limits like noted in topic title and getting
Import summary ('#'-skips / rejects / inserts): 0 / 0 / 6237026. Insertions will be lost if you don't commit. SEVERE Rolling back SQL transaction. Exception in thread "main" java.lang.OutOfMemoryError: Java heap space at java.util.Arrays.copyOfRange(Unknown Source) at java.lang.String.<init>(Unknown Source) at java.lang.AbstractStringBuilder.substring(Unknown Source) at java.lang.StringBuilder.substring(Unknown Source) at java.lang.AbstractStringBuilder.subSequence(Unknown Source) at java.lang.StringBuilder.subSequence(Unknown Source) at java.util.regex.Matcher.getSubSequence(Unknown Source) at java.util.regex.Matcher.group(Unknown Source) at org.hsqldb.cmdline.sqltool.FileRecordReader.nextRecord(Unknown Source) at org.hsqldb.cmdline.SqlFile.importDsv(Unknown Source) at org.hsqldb.cmdline.SqlFile.processSpecial(Unknown Source) at org.hsqldb.cmdline.SqlFile.scanpass(Unknown Source) at org.hsqldb.cmdline.SqlFile.execute(Unknown Source)
hsqldb-import.sql
CREATE TABLE IF NOT EXISTS temp_3gb(field1 VARCHAR(255),field2 VARCHAR(255),field3 VARCHAR(255)); * *DSV_TARGET_TABLE = temp_3gb * *DSV_COL_SPLITTER = , * *DSV_REJECT_FILE = d:/hsqldb/sample-reject.dsv * *DSV_REJECT_REPORT = d:/hsqldb/sample-reject.html \m d:/sampleFile3g.dsv commit;
.rc file
#conn_testdb_file urlid cfg_file url jdbc:hsqldb:file:d:/hsqldb/testdb;hsqldb.large_data=true;hsqldb.cache_scale=18;hsqldb.cache_file_scale=8;hsqldb.cache_rows=10000;hsqldb.nio_data_file=false username SA password

Eclipse->Run Configurations->Arguments
-Xms2G -Xmx4G -XX:-UseGCOverheadLimit

It works as expected for 1000rows large file.
Any guidelines how to configure HSQLDB for 25 000 000 rows import? Have 16GB machine here.

Regards

PS
https://sourceforge.net/projects/hsqldb/forums/forum/73673/topic/8716091

Hello,
Encapsulating config.properties file in .exe and assembling all as installer is also an option.
Any experiences? Which (non-commercial) tool would you recommend?

Regards

Hello,
Found this old thread and it might turn out useful...

So OneJar generates executable jar (involving other jars) together with image-icon from the resources, as expected

Further, does anyone know how to setup, read and update a config file for OneJar? Where to put it exactly and how to reference it? getResourceAsStream should be used, i guess, but how?
http://one-jar.sourceforge.net/index.php?page=documents&file=faq
Posted also on:
https://sourceforge.net/p/one-jar/discussion/380843/thread/0c9353a4/

Regards

P.S.
Don't want to miss-lead with below unsuccessful tries:
Properties prop = new Properties(); prop.load( new FileInputStream( pConfFilePath ) ); prop.load( RunThisClass.class.getResourceAsStream( pConfFilePath ) ); prop.load(Thread.currentThread().getContextClassLoader().getResource( pConfFilePath ).openStream()); prop.load(Util.class.getClassLoader().getResourceAsStream(pConfFilePath)); prop.load(RunThisClass.class.getResource(pConfFilePath).openStream());

Thank you for your valuable reply based on latest version of Java, Abhay!

It works, but found limitation as it seems that file extension is analyzed. So if you change extension it will display type based on extension, no matter what file's content is.
Have found Apache Tika
http://lucene.apache.org/tika/

import java.io.File; import java.io.FileInputStream; import org.apache.tika.metadata.Metadata; import org.apache.tika.parser.AutoDetectParser; import org.apache.tika.parser.Parser; import org.apache.tika.sax.BodyContentHandler; import org.xml.sax.ContentHandler; public class Main { public static void main(String args[]) throws Exception { FileInputStream is = null; try { File f = new File("C:/Temp/mime/test.docx"); is = new FileInputStream(f); ContentHandler contenthandler = new BodyContentHandler(); Metadata metadata = new Metadata(); metadata.set(Metadata.RESOURCE_NAME_KEY, f.getName()); Parser parser = new AutoDetectParser(); // OOXMLParser parser = new OOXMLParser(); parser.parse(is, contenthandler, metadata); System.out.println("Mime: " + metadata.get(Metadata.CONTENT_TYPE)); System.out.println("Title: " + metadata.get(Metadata.TITLE)); System.out.println("Author: " + metadata.get(Metadata.AUTHOR)); System.out.println("content: " + contenthandler.toString()); } catch (Exception e) { e.printStackTrace(); } finally { if (is != null) is.close(); } } }
It works based on content, no matter what extension is.
What will examine further, is how to distinguish .csv, pipe-delimited, TAB delimited content on the most elegant way as they're all recognized as text/plain. Opening them and parsing, is an option

Regards

P.S.
Thanks for you critics Jeff, will try to do more accurate research. If you find topic low-level post solution or ignore it please. There might be others who are interested, so I'd expand it further

Sure, but that hasn't brought solution, yet
If you have any precise guideline on how to solve this in Java (except of file extension examination), share please

Regards

Hello,

How to determine the type of file?
So aim is to distinguish targeted file's type (.csv, .xls, .txt...) according to it's content

Regards

Hello,

How to create contact card in Outlook via jacob-1.17-M2-x86.dll
Have been trying combination of below commands, but no success, for now http://www.land-of-kain.de/docs/jacob/
createrecipient resolve addressentry address createcontactcard
Any idea?

Regards

Appreciate your fast response(s) a lot!


http://one-jar.sourceforge.net/index.php?page=getting-started&file=quickstart
When I walkthrough the Command-Line Approach guidelines, I get one-jar.jar that contains only META-INF folder? What am I doing wrong?
Can anybody share precise guidelines on success generation of 1 jar, please?
What if additional resources are involved (images, i18n, internal DB...)?


Regards

Thanks, experience with OneJar is welcome!

Which file to download?
http://one-jar.sourceforge.net/index.php?page=downloads&file=downloads

How to put this together? What commands to use?
myapp.jar
mycomp.mypackage.RunningClass
dependencies:
swing-layout-1.0.4.jar
myutils.jar


Regards

Hello,


How can I put couple of jars together in 1 jar file?

That would be OneJar or UberJar, if I had the source code, but i don't have it in this case

main.jar (here is the main class)
dependant_jar1.jar
dependant_jar2.jar
.
.
.


Regards

Hello,


About to resize JTable's header and when
getTableHeader().setPreferredSize( new Dimension((int) treeTable.getColumnModel().getTotalColumnWidth(), Integer.parseInt(heightP) ));
it does resize, indeed.
But there are side-effects that affects the text in whole table: different font/size...

Tried with examples I've found around but non of them work so far

Any idea?


Regards

Hello,


How to submit POST parameters and open URL in browser?

For trivial URL, i use
URI uri = new URI( handOffUrl ); Desktop.getDesktop().browse(uri);
and works properly

How to submit params as in .jsp page?
<form method="post" action="urlForPageThatNeedsInputParams"> <input type="hidden" name="name" value="somevalue" /> Card Number: <input name="cardNo" /> <br> Card Verification Number: <input name="cardCVN" /><br> <input type="submit" value="Make Payment"> </form>


Regards

Bought certificate that's good for 1 year and rented secure hosting for 1 month at DreamHost

Got from them a content of file that i saved in dreamhostcert.crt, sg like:
-----BEGIN CERTIFICATE----- MIIFYjCCBEqgAwIBAgIRAPJgViCHfGK6LfF65K6j180wDQYJKoZIhvcNAQEFBQA wcTELMAkGA1UEBhMCR0IxGzAZBgNVBAgTEkdyZWF0ZXIgTWFuY2hlc3RlcjEQMA 4GA1UEBxMHU2FsZm9yZDEaMBgGA1UEChMRQ29tb2RvIENBIExpbWl0ZWQxFzAVB gNVBAMTDlBvc2l0aXZlU1NMIENBMB4XDTEwMDgyMzAwMDAwMFoXDTExMDgyMzIz . . . SpwwWkMWVLWX/vcXcXG1jAMbc/DsKfQwVbsVq62xQ97sbYXK+95eeL80e4bCKkC U7Q3Dl0YqZ+cRY/4= -----END CERTIFICATE-----

How to setup tomcat with it now?

So far, i've used self generate mykeystore.ks file and in server.xml
<Connector port="443" protocol="org.apache.coyote.http11.Http11Protocol" SSLEnabled="true" maxThreads="150" scheme="https" secure="true" clientAuth="false" sslProtocol="TLS" keystoreFile="${catalina.base}/conf/mykeystore.ks" keystorePass="mykeystorepass" />

How to generate keystore from certificate file that i got from DreamHost? I'll need to trust other certificates in that keystore later


Regards

Hello,

Have a .jar file and there is a class (with private constructor -not able to inherit) in it, where log4j is configured from code: log.setLevel(Level.ERROR)
Not able to modify that .jar
Is there any chance to inherit (somehow) that class and to replicate method that contains log.setLevel(Level.ERROR) or to do sg else with that .jar so it will make possible to configure Log4j from log4j.xml?

How to override Log4j configuration in code with log4j.xml?


Regards

Initial issue has been solved on other forum.

New question:
Is there a way to select language from drop-down instead of links?


Regards