Buy Support
Incidents |
If you can't find your answer
in the FREE PUBLIC QDeveloper Forum, require URGENT Priority Support, or you need to send us
private or confidential information: |
Click Here
|
If you can't
login and post questions or you are having trouble viewing forum posts:
Click Here
|
Callback
Support |
If you live in USA, UK, Canada, Australia or New
Zealand, you can leave us details on your question and request us to call you back and discuss
them with you personally (charges apply). |
Click Here
|
Buy Support
Incidents |
If you can't find your answer
in the FREE PUBLIC QDeveloper Forum, require URGENT Priority Support, or you need to send us
private or confidential information: |
Click Here
|
|
Using old version of FlexODBC (v. 2.0) on JAVA... |
Author |
Message |
|
Posted : 2008-08-23 05:18:14 |
People i have a old versoin of FlexODBC (version 2.0), and now i need to use a new graphic interface on this Driver. But i having problems to do some SQL comands..
Im using the driver: sun.jdbc.odbc.JdbcOdbcDriver on JAVA, to acess the FlexOBDC, and i get the connection right.
I try to use PrepareStatement and ResultSet on JAva to execute a Query SQL language, but java returns this:
java.sql.SQLException: The result set type is not supported. at sun.jdbc.odbc.JdbcOdbcStatement.initialize(Unknown Source) at sun.jdbc.odbc.JdbcOdbcConnection.createStatement(Unknown Source) at sun.jdbc.odbc.JdbcOdbcConnection.createStatement(Unknown Source) at mbsistemas.modelo.odbc2.main(odbc2.java:18)
Im have tryed to use a new driver 4.0, and with the same code they do the QUERY... Anyone can help me?
All code I use is down here:
--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- CLASS: EQUALS CONNECTION import java.sql.Connection; import java.sql.DriverManager; import java.sql.SQLException;
public class Conexao2 { // variavel da connection private static Connection conn; private static String driver = "sun.jdbc.odbc.JdbcOdbcDriver"; private static String url = "jdbc:odbc:DataFlex Data32"; private static String user = ""; private static String password = ""; public static Connection getConnection() { try { if (conn == null) { Class.forName(driver); conn = DriverManager.getConnection(url, user, password); } } catch (ClassNotFoundException e) { e.printStackTrace(); } catch (SQLException e) { e.printStackTrace(); } return conn; } }
--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- import java.io.IOException; import java.sql.Connection; import java.sql.ResultSet; import java.sql.SQLException; import java.sql.Statement;
public class odbc2 {
/** * @param args */ public static void main(String[] args) { Connection conn = Conexao2.getConnection(); try { Statement st = conn.createStatement(); ResultSet rs = st.executeQuery("SELECT * FROM SIAM0001"); } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); } catch (IOException e) { // TODO Auto-generated catch block e.printStackTrace(); }
}
}
I thanks for all!!! |
|
|
|
Tom |
|
Group | : Administrator |
Posts | : 5510 |
Joined | : 2006-02-17 |
|
Profile |
|
Posted : 2008-08-23 07:30:14 |
To use FlexODBC v2.0 under IIS or ANY WINDOWS SERVICE like the Java ODBC Bridge product from Sun requires a Multi-CPU Unlimited users license. If you have a single user or 4 CPU license it will not work. FlexODBC v2.0 is also no longer supported. |
|
|
|
|
Posted : 2008-08-23 13:42:57 |
Sorry tom, but I need to know, IIS is Internet Information Service??? I know its not more supported, but the system that i have to UPDATE, use this Driver, and i need to use this Driver to get all the tables in Java... to do that i need to have a FlexODBC 2.0? I can't buy a new license for to use for a litle time... Don't have any FREE ou other Driver FREE who works like FlexODBC on Java?
**Sorry my English!!! |
|
|
|
Tom |
|
Group | : Administrator |
Posts | : 5510 |
Joined | : 2006-02-17 |
|
Profile |
|
Posted : 2008-08-23 21:36:19 |
|
|
|
|
Posted : 2008-08-24 01:52:35 |
But my Application is local only, no use IIS... I will get some time to read the page that you post here!!! |
|
|
|
|