Subject: | |
From: | |
Reply To: | |
Date: | Mon, 26 Feb 2007 10:55:00 -0600 |
Content-Type: | text/plain |
Parts/Attachments: |
|
|
Hello to all on the 3000-L, especially you JDBC experts!
Quick question about JDBC; I got it running, and have executed SQL
statements successfully.
What methods are available using the M.P.E./JDBC driver?
For example, we have 'createStatement', 'execute(sql)', 'getResultSet'
works no problem.
Or is it better to ask what is not available?
like: .getschemata, and others that request meta data from
Image/allbase?
Are there any GUI Query tools available that know how to talk to JDBC
on M.P.E.?
One tool claims to talk to Generic JDBC drivers, but when it is pointed
to JDBC on M.P.E. it complains: ReverseEngineeringGeneric.getschemata
:No suitable driver
Connecting to source database and retrieve schemata names.
Initializing JDBC driver ...
Driver class Generic Jdbc
Opening connection ...
Connection jdbc:allbase://STUDENT/CPIDBE
The list of schema names could not be retrieved (error: 0).
ReverseEngineeringGeneric.get schemata :No suitable driver
Details:
java.sql.DriverManager.getConnection(Unknown Source)
java.sql.DriverManager.getConnection(Unknown Source)
com.mysql.grt.modules.ReverseEngineeringGeneric.establishConnection(ReverseEngineeringGeneric.java:93)
com.mysql.grt.modules.ReverseEngineeringGeneric.getSchemata(ReverseEngineeringGeneric.java:185)
sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
java.lang.reflect.Method.invoke(Unknown Source)
com.mysql.grt.Grt.callModuleFunction(Unknown Source)
Any clue?
My connection parms are as follows:
Class name: com.hp.jdbc.allbase.Jdbc
Connection string: jdbc:allbase://{hostname}/{name of the DBE}
and username password.....
--
Michael Anderson
Programmer/Analyst -- Technology Dept.
Spring Independent School District
16717 Ella Boulevard
Houston, Texas 77090-4299
office: 281.586.1105
Mobile: 832.515.3868
fax: 281.586.1187
-
* To join/leave the list, search archives, change list settings, *
* etc., please visit http://raven.utc.edu/archives/hp3000-l.html *
|
|
|