Member Login

Username
Password
Forget Password
New Sign Up
Search Forum

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

Forum : Using old version of FlexODBC (v. 2.0) on JAVA...Search Forum

Forum Home > FlexODBC - ODBC Driver for DataFlex Embedded DBMS > FlexODBC SQL Support Forum

 New Topic 
 
 Post Reply 
[1]  
 Using old version of FlexODBC (v. 2.0) on JAVA... 
 Author   Message 
  dcbasso 
  
 Group: Members 
 Posts: 3 
 Joined: 2008-08-23 
 Profile
 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!!! 

  Top 
  Tom 
  6c3c1_sdk-qodbc.gif
 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. 

  Top 
  dcbasso 
  
 Group: Members 
 Posts: 3 
 Joined: 2008-08-23 
 Profile
 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!!! 

  Top 
  Tom 
  6c3c1_sdk-qodbc.gif
 Group: Administrator 
 Posts: 5510 
 Joined: 2006-02-17 
 Profile
 Posted : 2008-08-23 21:36:19

Yes, IIS is the Internet Information Service. I can't help in regards to FlexODBC v2.0.

See also: How do I use FlexODBC over the Internet? 

 

  Top 
  dcbasso 
  
 Group: Members 
 Posts: 3 
 Joined: 2008-08-23 
 Profile
 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!!! 

  Top 
 New Topic 
 
 Post Reply 
[1]  

Jump to