How do I access the MAS db via Java? 1

[pattyc]

I'm running the MAS 200 4.10.1.1 client. I want to write a Java app to query the MAS database directly via ODBC (I don't want to use VI or MS Query to write to an Excel spreadsheet, for instance). How do I do this?

 

[pattyc]

I got the query working, but it's taking 5-10 minutes! Is there any way to speed things up?

Connection conn = null;
try { Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
}
catch(java.lang.ClassNotFoundException e) {
System.err.println("Didn't find the class"); System.err.println("ClassNotFoundException: );
System.err.println(e.getMessage());
}
try {
conn = DriverManager.getConnection("jdbcdbc:SOTAMAS90_ABC");
ResultSet results = null;
try {
...
Statement st = conn.createStatement();
results = st.executeQuery("SELECT * FROM AP_13InvHistoryDetail");
.....

 

[pattyc]

Actually it seems to be the connection that's really taking the time.

 

[lburgoyne]

Patty,

I am also experiencing long connection times.
Did you ever get this resolved?

 

[pattyc]

Actually I ended up not connecting to the db.

DB connection and access will be slow. A possible solution is to have a secondary, faster db, but then you'll have to deal with the issue of keeping that second db in sync with the first. You could use the secondary db to just hold the more highly accessed data.

 

[BigLouie]

I don't want to use VI or MS Query to write to an Excel spreadsheet, for instance"

Using Vi to export data is not a good idea. Extremly slow. However MS Query pulling data into Excel is fast and easy and is widely used. Pulling into Access with SQL Specific Pass Through Queries is another fast and simple method.