I just tried the plugin - it works fine, but I am not able to get my DB driver class into the classpath. So when I try to create a new datasource I always get an error.
I already tried to put the driver jar (mysql) in IDEA_HOM/lib, or to put the jar into IDEA_HOME/plugins - it did not work.
What do I have to do?
Thanks in advance,
Michael
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Place it in your IDEA_HOME/lib, and adjust the idea.bat or idea.sh and add it to your CLASPATH settings in it. Be careful not to cut-and-paste the last CLASSPATH enty as it points inside your JAVA_HOME directoy....a mistake several people imcliuding myself have made.
Jim
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Hello,
I just tried the plugin - it works fine, but I am not able to get my DB driver class into the classpath. So when I try to create a new datasource I always get an error.
I already tried to put the driver jar (mysql) in IDEA_HOM/lib, or to put the jar into IDEA_HOME/plugins - it did not work.
What do I have to do?
Thanks in advance,
Michael
Place it in your IDEA_HOME/lib, and adjust the idea.bat or idea.sh and add it to your CLASPATH settings in it. Be careful not to cut-and-paste the last CLASSPATH enty as it points inside your JAVA_HOME directoy....a mistake several people imcliuding myself have made.
Jim
Thanks for the help. Of course I made the mistake that you described :-)
Now the plugin seems to be able to connect to the datasource, but it doesn't show any tables.
Here is the output:
SQLPlugin.readExternal
found dataSource = ejb
Adding datasource: ejb
net.plugin.sql.SQLPlugin.initComponent
net.plugin.sql.SQLPlugin.projectOpened
net.plugin.sql.SQLPlugin.initToolWindow
SQLPlugin.writeExternal
writing dataSource = ejb
SQLDataTree.updateTableNode
SQLDataTree.updateTableNode
SQLPlugin.writeExternal
writing dataSource = ejb
==============================
Michael
Can someone tell me how to add this jar to my classpath in the .bat or .sh startup script when all I have in my bin directory is an .exe???