|
Re: jdbc emc problem [message #1767645 is a reply to message #1767359] |
Sat, 08 July 2017 09:26 |
|
Hi Gianluigi,
Thank you for reporting this. Is there any chance you could share a compressed dump of your larger database so that we can reproduce this and investigate?
Cheers,
Dimitris
|
|
|
|
Re: jdbc emc problem [message #1767719 is a reply to message #1767682] |
Mon, 10 July 2017 10:05 |
|
Hi Gianluigi,
It'd help a lot if you could send me a compressed SQL dump I can import in my MySQL server instead of a copy of your MySQL directory (I'm sure I can somehow import the data from what you've shared but I haven't figured out how so far).
Cheers,
Dimitris
|
|
|
|
Re: jdbc emc problem [message #1767731 is a reply to message #1767727] |
Mon, 10 July 2017 12:07 |
|
Hi Gianluigi,
Thanks for doing this. Running the following code on my setup with the default JVM heap setting throws an OutOfMemory error. However, after increasing the heap size to 1024MB (added -Xmx1024m in the VM arguments of my run configuration), the program terminates without errors.
public static void main(String[] args) throws Exception {
MySqlModel model = new MySqlModel();
model.setServer("localhost");
model.setDatabase("openhab");
model.setUsername("root");
model.setPassword("root");
model.setPort(3306);
model.setName("MySQL");
model.setStreamResults(true);
model.load();
EtlModule module = new EtlModule();
module.parse("rule R1 transform s : MySQL!Item1 to t : Sequence { System.out.println('Rule MySql: ' + s.Time + ' ' + s.Value); }");
module.getContext().getModelRepository().addModel(model);
module.execute();
}
Could you please let me know if this works for you?
Cheers,
Dimitris
|
|
|
|
|
|
|
Re: jdbc emc problem [message #1767762 is a reply to message #1767759] |
Mon, 10 July 2017 19:20 |
|
Hi Gianluigi,
The -Xmx1024m argument needs to go in the "VM arguments" text box of the "Arguments" tab of the Run Configuration of your Java application (within Eclipse) as opposed to the startup properties of Eclipse.
Cheers,
Dimitris
|
|
|
|
Re: jdbc emc problem [message #1767885 is a reply to message #1767880] |
Tue, 11 July 2017 22:36 |
|
Hi Gianluigi,
With 'MySQL!item16' I'm getting a type not found exception - which is the expected behaviour. When I change to 'MySQL!Item16' this works fine on my machine. I'm running out of ideas so how about arranging a screen-sharing session e.g. over Skype to investigate this on your setup? If this would be of interest, please send me an email [1] and we'll sort out something.
Cheers,
Dimitris
[1] https://www-users.cs.york.ac.uk/~dkolovos/contact/
|
|
|
Powered by
FUDForum. Page generated in 0.04101 seconds