Eclipse Community Forums
Forum Search:

Search      Help    Register    Login    Home
Home » Eclipse Projects » Test and Performance Tools Platform (TPTP) » Large Resource Support
Large Resource Support [message #121238] Wed, 23 January 2008 06:05 Go to next message
Eclipse User
Originally posted by: leo.nowhere.com

Does anybody know how this workx?

What I have done:

A)
1) Enable the MySQL-support in the Plugin-Dir
plugins\org.eclipse.hyades.resources.database_4.2.100.v20070 6132116\
2) Use mysql-connector-java-5.1.5-bin.jar

==> Brings an Invalid JDBC-Driver

B) I have downloaded CloudScape and followed the Help-Guidelines.
1) Run the setEmbeddedCP.bat
2) Restart Eclipse
3) ij ++ the SQL-File ===>

ij version 10.1
ij> IJ ERROR: Could not locate class com.ihost.cs.jdbc.CloudscapeDriver
ij> IJ ERROR: Could not locate class com.ibm.db2j.jdbc.DB2jDriver
ij> IJ ERROR: Could not locate class org.apache.derby.jdbc.ClientDriver
ij> ij> ERROR 08001: No suitable driver found for
jdbc:cloudscape:HYADES;create=
true
ij> ERROR 08001: No suitable driver found for jdbc:db2j:HYADES;create=true
ij> WARNING 01J01: Database 'HYADES' not created, connection made to existing
da
tabase instead.
ij> WARNING 01J01: Database 'HYADES' not created, connection made to existing
da
tabase instead.

I have in my path file as well \CloudScape\frameworks\embedded\bin\

4) In the Eclipse Plugin I specify the derby.jar. In the help-file it is
mentioned to link it to the CloudScape.jar Where to find this file?

5) The Button Test Connection is enabled, while the fiedls DB location,
Username, PWD are disabled. Pressing the Test-connection Button =>
Database 'HYADES' not found.

===> How to enable this feature???
Re: Large Resource Support [message #121376 is a reply to message #121238] Thu, 24 January 2008 16:35 Go to previous messageGo to next message
Alex Nan is currently offline Alex Nan
Messages: 29
Registered: July 2009
Junior Member
Hi Leo,

here are some easy steps to set up a Cloudscape 10.1 database in embedded
mode and enable large resource support: onWindows:
- open a command prompt and cd to your eclipse home directory
- include in the path in your cmd prompt, the path to a java 1.4.2 or 1.5
JRE and to <Cloudscape_10.1_Home>\frameworks\embedded\bin
- set in the
<Cloudscape_10.1_Home>\frameworks\embedded\bin\setEmbeddedCP.bat the
DERBY_INSTALL variable accordingly
- run the script setEmbeddedCP.bat
- run the command ij <Eclipse_HOME>ij < plugins\org.eclipse.hya
des.resources.database_<version>\scripts\CreateDatabaseAndTablesCloudscape.sql
- ignore the errors/warnings
ij> IJ ERROR: Could not locate class com.ihost.cs.jdbc.CloudscapeDriver
ij> IJ ERROR: Could not locate class com.ibm.db2j.jdbc.DB2jDriver
ij> IJ ERROR: Could not locate class org.apache.derby.jdbc.ClientDriver
ij> ij> ERROR 08001: No suitable driver
ij> ERROR 08001: No suitable driver
ij> ij> WARNING 01J01: Database 'HYADES' not created, connection made to
existin
g database instead.
- if everything works well you're gonna get a some system outs in your
command prompt:
ij(CONNECTION1)> 0 rows inserted/updated/deleted
......
- verify the Hyades db is created
- start Eclipse, and from the main menu select
Window->Preferences->Profiling and Logging->Large Resouce Support
- check the "Enable large log support" check box and select the following
jdbc driver: <Cloudscape_10.1_Home>\lib\derby.jar
- the input fields database location, user name, passoword should be grayed
out
- check the connection with the database "Test connection"
If everything works well you are done, now the logs that you import are
going to be persisted into the Cloudscape database.

Kind regards,
Alex Nan.

"LeO" <leo@nowhere.com> wrote in message
news:85062d841cdd5e5c2e200506e59d8483$1@www.eclipse.org...
> Does anybody know how this workx?
>
> What I have done:
>
> A)
> 1) Enable the MySQL-support in the Plugin-Dir
> plugins\org.eclipse.hyades.resources.database_4.2.100.v20070 6132116\
> 2) Use mysql-connector-java-5.1.5-bin.jar
> ==> Brings an Invalid JDBC-Driver
>
> B) I have downloaded CloudScape and followed the Help-Guidelines. 1) Run
> the setEmbeddedCP.bat
> 2) Restart Eclipse
> 3) ij ++ the SQL-File ===>
>
> ij version 10.1
> ij> IJ ERROR: Could not locate class com.ihost.cs.jdbc.CloudscapeDriver
> ij> IJ ERROR: Could not locate class com.ibm.db2j.jdbc.DB2jDriver
> ij> IJ ERROR: Could not locate class org.apache.derby.jdbc.ClientDriver
> ij> ij> ERROR 08001: No suitable driver found for
> jdbc:cloudscape:HYADES;create=
> true
> ij> ERROR 08001: No suitable driver found for jdbc:db2j:HYADES;create=true
> ij> WARNING 01J01: Database 'HYADES' not created, connection made to
> existing da
> tabase instead.
> ij> WARNING 01J01: Database 'HYADES' not created, connection made to
> existing da
> tabase instead.
>
> I have in my path file as well \CloudScape\frameworks\embedded\bin\
>
> 4) In the Eclipse Plugin I specify the derby.jar. In the help-file it is
> mentioned to link it to the CloudScape.jar Where to find this file?
>
> 5) The Button Test Connection is enabled, while the fiedls DB location,
> Username, PWD are disabled. Pressing the Test-connection Button =>
> Database 'HYADES' not found.
>
> ===> How to enable this feature???
>
>
>
Re: Large Resource Support [message #121384 is a reply to message #121376] Thu, 24 January 2008 16:38 Go to previous messageGo to next message
Alex Nan is currently offline Alex Nan
Messages: 29
Registered: July 2009
Junior Member
Sorry for the type, I meant to say:

run the command:
ij <
plugins\org.eclipse.hyades.resources.database_<version>\scripts\CreateDatabaseAndTablesCloudscape.sql
in your <Eclipse_HOME> command prompt.

"Alex Nan" <apnan@ca.ibm.com> wrote in message
news:fnb0bl$ddu$1@build.eclipse.org...
> Hi Leo,
>
> here are some easy steps to set up a Cloudscape 10.1 database in embedded
> mode and enable large resource support: onWindows:
> - open a command prompt and cd to your eclipse home directory
> - include in the path in your cmd prompt, the path to a java 1.4.2 or 1.5
> JRE and to <Cloudscape_10.1_Home>\frameworks\embedded\bin
> - set in the
> <Cloudscape_10.1_Home>\frameworks\embedded\bin\setEmbeddedCP.bat the
> DERBY_INSTALL variable accordingly
> - run the script setEmbeddedCP.bat
> - run the command ij <Eclipse_HOME>ij < plugins\org.eclipse.hya
> des.resources.database_<version>\scripts\CreateDatabaseAndTablesCloudscape.sql
> - ignore the errors/warnings
> ij> IJ ERROR: Could not locate class com.ihost.cs.jdbc.CloudscapeDriver
> ij> IJ ERROR: Could not locate class com.ibm.db2j.jdbc.DB2jDriver
> ij> IJ ERROR: Could not locate class org.apache.derby.jdbc.ClientDriver
> ij> ij> ERROR 08001: No suitable driver
> ij> ERROR 08001: No suitable driver
> ij> ij> WARNING 01J01: Database 'HYADES' not created, connection made to
> existin
> g database instead.
> - if everything works well you're gonna get a some system outs in your
> command prompt:
> ij(CONNECTION1)> 0 rows inserted/updated/deleted
> .....
> - verify the Hyades db is created
> - start Eclipse, and from the main menu select
> Window->Preferences->Profiling and Logging->Large Resouce Support
> - check the "Enable large log support" check box and select the following
> jdbc driver: <Cloudscape_10.1_Home>\lib\derby.jar
> - the input fields database location, user name, passoword should be
> grayed out
> - check the connection with the database "Test connection"
> If everything works well you are done, now the logs that you import are
> going to be persisted into the Cloudscape database.
>
> Kind regards,
> Alex Nan.
>
> "LeO" <leo@nowhere.com> wrote in message
> news:85062d841cdd5e5c2e200506e59d8483$1@www.eclipse.org...
>> Does anybody know how this workx?
>>
>> What I have done:
>>
>> A)
>> 1) Enable the MySQL-support in the Plugin-Dir
>> plugins\org.eclipse.hyades.resources.database_4.2.100.v20070 6132116\
>> 2) Use mysql-connector-java-5.1.5-bin.jar
>> ==> Brings an Invalid JDBC-Driver
>>
>> B) I have downloaded CloudScape and followed the Help-Guidelines. 1) Run
>> the setEmbeddedCP.bat
>> 2) Restart Eclipse
>> 3) ij ++ the SQL-File ===>
>>
>> ij version 10.1
>> ij> IJ ERROR: Could not locate class com.ihost.cs.jdbc.CloudscapeDriver
>> ij> IJ ERROR: Could not locate class com.ibm.db2j.jdbc.DB2jDriver
>> ij> IJ ERROR: Could not locate class org.apache.derby.jdbc.ClientDriver
>> ij> ij> ERROR 08001: No suitable driver found for
>> jdbc:cloudscape:HYADES;create=
>> true
>> ij> ERROR 08001: No suitable driver found for
>> jdbc:db2j:HYADES;create=true
>> ij> WARNING 01J01: Database 'HYADES' not created, connection made to
>> existing da
>> tabase instead.
>> ij> WARNING 01J01: Database 'HYADES' not created, connection made to
>> existing da
>> tabase instead.
>>
>> I have in my path file as well \CloudScape\frameworks\embedded\bin\
>>
>> 4) In the Eclipse Plugin I specify the derby.jar. In the help-file it is
>> mentioned to link it to the CloudScape.jar Where to find this file?
>>
>> 5) The Button Test Connection is enabled, while the fiedls DB location,
>> Username, PWD are disabled. Pressing the Test-connection Button =>
>> Database 'HYADES' not found.
>>
>> ===> How to enable this feature???
>>
>>
>>
>
>
Re: Large Resource Support [message #121400 is a reply to message #121376] Fri, 25 January 2008 08:40 Go to previous messageGo to next message
Eclipse User
Originally posted by: leo.nowhere.com

Alex Nan wrote:

> Hi Leo,

> - set in the
> <Cloudscape_10.1_Home>frameworksembeddedbinsetEmbeddedCP.bat the
> DERBY_INSTALL variable accordingly

I understood it that way, it should be added to the path. But if it is
like that, then even better.

> - verify the Hyades db is created

???

How to check this? The dir. Hyades is in

D:\Program Files\CloudScape\frameworks\embedded\bin\HYADES\

But does this mean, it worx? Cause I receive the Error even with this dir?
AND is it simple approach to delete the dir and this would mean the Db is
deleted as well?

Last but not least, how is the connection to the DB done? Cause in company
we have firewall and I have configured a Proxy. But this Proxy cannot be
used, due to a fault in the Profiler-settings, which ignores the usage of
Localhost. So, does the Large Resource Support ignore the Settings as
well, or how is the connection tryed to be established to the Embedded
Server-process?
Re: Large Resource Support [message #121424 is a reply to message #121400] Fri, 25 January 2008 18:16 Go to previous messageGo to next message
Alex Nan is currently offline Alex Nan
Messages: 29
Registered: July 2009
Junior Member
Yes, that's what I meant, to verify if the Hyades folder is created. It is
also possible to verify if all the tables in the database were created by
launching ij and verifying if some of the tables were created (one from the
beginning of the creation script, one from the middle and one from the end).
For ex. once in the ij command prompt run
CONNECT 'jdbc:derby:HYADES;
select * from "CBECommonBaseEvent";
and verify if the table exists.

It looks like the database is not in the right place for running in embedded
mode, it should be in
<Your_ECLIPSE_HOME>\Hyades, for ex. D:\TPTP4.5\eclipse\Hyades.
I don't think the firewall would prevent connecting to the embedded
database.
It connects using something like :
org.apache.derby.jdbc.EmbeddedDriver driverInstance;

driverInstance.connect("jdbc"derby:HYADES", properties);

Kind regards,
Alex Nan.

For Cloudscape running in embedded mode, i.e. Cloudscape and Eclipse are
running in the same JVM
"LeO" <leo@nowhere.com> wrote in message
news:fa40e994c46726c786dc92fccb2d1d48$1@www.eclipse.org...
> Alex Nan wrote:
>
>> Hi Leo,
>
>> - set in the <Cloudscape_10.1_Home>frameworksembeddedbinsetEmbeddedCP.bat
>> the DERBY_INSTALL variable accordingly
>
> I understood it that way, it should be added to the path. But if it is
> like that, then even better.
>
>> - verify the Hyades db is created
>
> ???
> How to check this? The dir. Hyades is in
> D:\Program Files\CloudScape\frameworks\embedded\bin\HYADES\
>
> But does this mean, it worx? Cause I receive the Error even with this dir?
> AND is it simple approach to delete the dir and this would mean the Db is
> deleted as well?
>
> Last but not least, how is the connection to the DB done? Cause in company
> we have firewall and I have configured a Proxy. But this Proxy cannot be
> used, due to a fault in the Profiler-settings, which ignores the usage of
> Localhost. So, does the Large Resource Support ignore the Settings as
> well, or how is the connection tryed to be established to the Embedded
> Server-process?
>
Re: Large Resource Support [message #121431 is a reply to message #121424] Sat, 26 January 2008 11:39 Go to previous messageGo to next message
Eclipse User
Originally posted by: leo.nowhere.com

> For ex. once in the ij command prompt run
> CONNECT 'jdbc:derby:HYADES;
> select * from "CBECommonBaseEvent";
> and verify if the table exists.

This worx fine.

> It looks like the database is not in the right place for running in embedded
> mode, it should be in
> <Your_ECLIPSE_HOME>Hyades, for ex. D:TPTP4.5eclipseHyades.

But now I am completely confused. I have download Cloudscape into some dir
(Program Files\Cloudscape), and there I have followed the instructions -
as well yours. But it seems to result in some mismatch in the final
Dir-Structure.

Would you mind to list in which Dir, should be what (DB, jars, and don't
know what else is required)?
If Eclipse is launched, which Dir resp. environment-variable is taken for
a search of the Derby.jar and ...?

Last but not least does Eclipse start the DB and writes data into it? i.e
possible to connect with other DB-tools and look into it? Or is it just a
single instance, where nothing else could connect to?

:)

LeO
Re: Large Resource Support [message #121531 is a reply to message #121431] Tue, 29 January 2008 12:53 Go to previous messageGo to next message
Alex Nan is currently offline Alex Nan
Messages: 29
Registered: July 2009
Junior Member
OK, so let's assume for sake of simplicity that Cloudcsape is installed
under D:\Cloudscape_10.1.
You need to create the HYADES db under D:\YourTPTPDriverHomeDir\eclipse.
Then launch eclipse, go to the Large Resource Support preferences page, i.e.
from the main Eclipse menu choose Window->Preferences->Profiling and
Logging->Large Resource Support.
Enable the function by checking "Enable large log support" and selecting the
D:\Cloudscape_10.1\lib\derby.jar from the "Browse" dialog (opened using the
button next to the "JDBC driver location" text box).
Notice that the "DB location", "User name" and "Password" text boxes are not
enabled since you've selected the embedded jdbc driver and this information
is not necessary.
Test the connection.
Apply the changes and you are all set, hopefully, to import logs into the
HYADES db.
Let me know how it works.
Kind regards,
Alex Nan.

"LeO" <leo@nowhere.com> wrote in message
news:65023f8953cae94ca2c5f882b0f72a64$1@www.eclipse.org...
>> For ex. once in the ij command prompt run
>> CONNECT 'jdbc:derby:HYADES;
>> select * from "CBECommonBaseEvent";
>> and verify if the table exists.
>
> This worx fine.
>
>> It looks like the database is not in the right place for running in
>> embedded mode, it should be in
>> <Your_ECLIPSE_HOME>Hyades, for ex. D:TPTP4.5eclipseHyades.
>
> But now I am completely confused. I have download Cloudscape into some dir
> (Program Files\Cloudscape), and there I have followed the instructions -
> as well yours. But it seems to result in some mismatch in the final
> Dir-Structure.
>
> Would you mind to list in which Dir, should be what (DB, jars, and don't
> know what else is required)?
> If Eclipse is launched, which Dir resp. environment-variable is taken for
> a search of the Derby.jar and ...?
>
> Last but not least does Eclipse start the DB and writes data into it? i.e
> possible to connect with other DB-tools and look into it? Or is it just a
> single instance, where nothing else could connect to?
>
> :)
>
> LeO
>
Re: Large Resource Support [message #121564 is a reply to message #121531] Wed, 30 January 2008 03:27 Go to previous messageGo to next message
Eclipse User
Originally posted by: leo.nowhere.com

Alex Nan wrote:

> OK, so let's assume for sake of simplicity that Cloudcsape is installed
> under D:Cloudscape_10.1.
> You need to create the HYADES db under D:YourTPTPDriverHomeDireclipse.

??? How to create it in a different Dir???

Copy from the Cloudscape-Dir to the YourTPTPDriverHomeDireclipse-Dir does
not help. Is it required to have something else in the dirs?

In my Dir I have:

2008-01-21 18:16 <DIR> features
2008-01-26 17:32 <DIR> HYADES
2008-01-21 18:17 <DIR> plugins
2008-01-21 18:17 <DIR> readme

What is additionally required for the Settings?

> Then launch eclipse, go to the Large Resource Support preferences page, i.e.
> from the main Eclipse menu choose Window->Preferences->Profiling and
> Logging->Large Resource Support.
> Enable the function by checking "Enable large log support" and selecting the
> D:Cloudscape_10.1libderby.jar from the "Browse" dialog (opened using the
> button next to the "JDBC driver location" text box).
> Notice that the "DB location", "User name" and "Password" text boxes are not
> enabled since you've selected the embedded jdbc driver and this information
> is not necessary.
> Test the connection.

Up till this step, I could follow. But as mentioned above, when copying
the Dir only I get an Error-Message that HYADES is not found...

> Apply the changes and you are all set, hopefully, to import logs into the
> HYADES db.

To import ??? Is it required to import something, after I have launched
the Profiling?

LeO
Re: Large Resource Support [message #121634 is a reply to message #121564] Thu, 31 January 2008 18:14 Go to previous messageGo to next message
Alex Nan is currently offline Alex Nan
Messages: 29
Registered: July 2009
Junior Member
I've already explained how to create the HYADES db in your
D:\YourTPTPDriverHomeDir\eclipse directory in my first reply. Delete the
HYADES folder that you apparently have in your eclipse directory and follow
again the steps from my first note.

OK, it seems that you are misunderstanding something here. The large
resource (log) support feature applies only to log file resources imported
using the TPTP Import Log wizard and not to Profiling data. Currently there
is no support for serializing profiling data into a database.
I hope this statement clarifies your question.
Kind regards,
Alex Nan.

"LeO" <leo@nowhere.com> wrote in message
news:5e7a02fefbd07acdf1dd1b34d178debb$1@www.eclipse.org...
> Alex Nan wrote:
>
>> OK, so let's assume for sake of simplicity that Cloudcsape is installed
>> under D:Cloudscape_10.1.
>> You need to create the HYADES db under D:YourTPTPDriverHomeDireclipse.
>
> ??? How to create it in a different Dir???
>
> Copy from the Cloudscape-Dir to the YourTPTPDriverHomeDireclipse-Dir does
> not help. Is it required to have something else in the dirs?
>
> In my Dir I have:
>
> 2008-01-21 18:16 <DIR> features
> 2008-01-26 17:32 <DIR> HYADES
> 2008-01-21 18:17 <DIR> plugins
> 2008-01-21 18:17 <DIR> readme
>
> What is additionally required for the Settings?
>
>> Then launch eclipse, go to the Large Resource Support preferences page,
>> i.e. from the main Eclipse menu choose Window->Preferences->Profiling and
>> Logging->Large Resource Support.
>> Enable the function by checking "Enable large log support" and selecting
>> the D:Cloudscape_10.1libderby.jar from the "Browse" dialog (opened using
>> the button next to the "JDBC driver location" text box).
>> Notice that the "DB location", "User name" and "Password" text boxes are
>> not enabled since you've selected the embedded jdbc driver and this
>> information is not necessary.
>> Test the connection.
>
> Up till this step, I could follow. But as mentioned above, when copying
> the Dir only I get an Error-Message that HYADES is not found...
>
>> Apply the changes and you are all set, hopefully, to import logs into the
>> HYADES db.
>
> To import ??? Is it required to import something, after I have launched
> the Profiling?
>
> LeO
>
Re: Large Resource Support [message #121689 is a reply to message #121634] Fri, 01 February 2008 04:08 Go to previous message
Eclipse User
Originally posted by: leo.nowhere.com

Alex Nan wrote:

> I've already explained how to create the HYADES db in your
> D:YourTPTPDriverHomeDireclipse directory in my first reply. Delete the
> HYADES folder that you apparently have in your eclipse directory and follow
> again the steps from my first note.

I have missed the fact, that it is required to launch it from the
Eclipse-Home-Dir.

> OK, it seems that you are misunderstanding something here. The large
> resource (log) support feature applies only to log file resources imported
> using the TPTP Import Log wizard and not to Profiling data. Currently there
> is no support for serializing profiling data into a database.
> I hope this statement clarifies your question.
> Kind regards,
> Alex Nan.

Uhu, this I have really missed. Cause I have thought the Profiling Data is
as well a Log, which is captured and internally processed to some results,
namely xpi. I mean, if you know about the details how it works and how it
handles the situation, the situation is clear. But from the
Preference-Page this was not clear for me. I have no idea, how to make it
more clear in the GUI. But I think, for others this might be misleading as
well.
Previous Topic:IAnalysisRule deprecated
Next Topic:General Availability (GA) and Technology Preview components moving to As-Is.
Goto Forum:
  


Current Time: Fri Apr 18 04:13:04 EDT 2014

Powered by FUDForum. Page generated in 0.01999 seconds