How do I connect to DB2 database.
When I load the free query builder, I do not see an option for the JBDC Admin.
I clicked on the File tab, I typed the driver 'com.ibm.as400.access.AS400JDBCDriver' and then the url jdbc:AS400://AS400SYS1, but I got an exception.
My jt400 jar file in on the classpath.
I'm using NT 4.0.
Thanks for any help.
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
I used the file>change/open connection to establish a db connection using the following parameters (example for mySQL only):
driver: com.mysql.jdbc.Driver
url: jdbc:mysql://<host>:3306/<db>
user: <username>
password <userpassword>
I have validated that the provided parameters are correct and have successfully used them in separate JDBC calls and from within SQLenardo.
The error I receive is:
A modal dialog window entitled "Exception" with the name of the driver (com.mysql.jdbc.Driver), an empty rectangle circumscribed by a red stopsign icon and an "OK" button. (nothing in the shell I have launched from)
Any tips or suggestions would be appreciated.
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Okay. It looks like it is working w/ Oracle & mySQL. I included the jar file in the classpath and called the class listed in the manifest file explicitly (thus I was able to ensure that the DB driver jars were included). That solved the DB connection problem. After connecting, I did not orginally notice that I needed to select the pull-down menus in the "browse" tab at the bottom of the window. Once I did that it appears to be working okay.
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
How do I connect to DB2 database.
When I load the free query builder, I do not see an option for the JBDC Admin.
I clicked on the File tab, I typed the driver 'com.ibm.as400.access.AS400JDBCDriver' and then the url jdbc:AS400://AS400SYS1, but I got an exception.
My jt400 jar file in on the classpath.
I'm using NT 4.0.
Thanks for any help.
please, try this command:
java -cp <path>/jt400.jar -jar freequerybuilder.jar
otherwise you can try SQLeonardo at http://sqleonardo.altervista.org
bye, nickyb.
I couldn't make it work with freequerybuilder, but SQLeonardo works pretty well!!
Thanks Nicky.
what's the exception?
I have the same problem with mySQL and Oracle. I launched the program as follows (example for mySQL only):
java -verbose -cp mysql-connector-java-3.1.11-bin.jar -jar freequerybuilder.jar
The UI contains two menus:
file > change/open connection
> exit
query > copy Syntax
> clear diagram
> []distinct
> []join
> preview
I used the file>change/open connection to establish a db connection using the following parameters (example for mySQL only):
driver: com.mysql.jdbc.Driver
url: jdbc:mysql://<host>:3306/<db>
user: <username>
password <userpassword>
I have validated that the provided parameters are correct and have successfully used them in separate JDBC calls and from within SQLenardo.
The error I receive is:
A modal dialog window entitled "Exception" with the name of the driver (com.mysql.jdbc.Driver), an empty rectangle circumscribed by a red stopsign icon and an "OK" button. (nothing in the shell I have launched from)
Any tips or suggestions would be appreciated.
Okay. It looks like it is working w/ Oracle & mySQL. I included the jar file in the classpath and called the class listed in the manifest file explicitly (thus I was able to ensure that the DB driver jars were included). That solved the DB connection problem. After connecting, I did not orginally notice that I needed to select the pull-down menus in the "browse" tab at the bottom of the window. Once I did that it appears to be working okay.