catherine matthews

Hi,

The ini file will set preference to do some calculation.
It will set the unit conversion to values
It should be able to change location of a mdb file i am creating in the program.

In short, it should be able to set some global variables i have defined.

Hi all,

Can anyone tell me how to create an initialization file for java. when i googled the thing i saw API to do it. [ini4j]
Can anyone tell me what are the essential things i need to know to create .ini file? I am using netbeans IDE. Is there any functions in Netbeans that helps us to create ini file?

Thanks.

I am using Jackess to copy the tables. As i copy The first tableA i have the correct amount of records. After i copy the second Table. The records in the first table gets changed. I loose 4 records. And the number of records in tableA becomes lesser. This is my method to copy the table.
I am using the same method. Changing the variable for the Connection.
Please let me know why this wierd thing is happening

private void getFile2OK() { ResultSet resultSet = null; try { Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); System.out.println("Starting DB"); String filename = file2.getAbsolutePath(); String database = "jdbc:odbc:Driver={Microsoft Access Driver (*.mdb)};DBQ="; database += filename.trim() + ";DriverID=22;READONLY=true}"; con = DriverManager.getConnection(database, "", ""); Statement st = con.createStatement(); String QueryTable = "SELECT * from " + jList2.getSelectedValue(); System.out.println(QueryTable); resultSet = st.executeQuery(QueryTable); Database.open(new File("d:/whitetrap/whitetrap.mdb")).copyTable("FormulaQ2", resultSet); } catch (SQLException e) { System.out.println("SQL Error is here at3 :" + e); } catch (Exception e) { System.out.println("Error :" + e); } finally { try { if (con != null) { con.close(); } } catch (SQLException e) { System.out.println(e); } } }
[ April 24, 2008: Message edited by: catherine matthews ]

Hi all,

i am creating a tableA with a few records in one connection.
With another connection i am inserting all the records from tableB into tableA

In short i append the tableA with tableB using the execute statement below.

st2.executeUpdate("insert into FormulaQ1Q2 select * from FormulaQ1")

The prblem is not all the records are being inserted. After appen i should have 2000records. I am only having 1923 records. Please let me know what is the problem?
[ April 23, 2008: Message edited by: catherine matthews ]

Yes, i am using a POI library. The conf file had no effect. I tried changing it to the maximum amount as possible. The problem was solved as I changed the VM Options in the Run Properties in Netbeans.

Thank you guys,

Anyway can anyone tell me why it did not work?

I have added the following in my initialization....
But the problem is the same

netbeans_default_options="-J-Xms128m -J-Xmx384m -J-XX:NewRatio=20 -J-XX:+UseConcMarkSweepGC -J-XX:+UseParNewGC -J-XX:+CMSPermGenSweepingEnabled -J-XX:+CMSClassUnloadingEnabled -J-XX:+CMSPermGenPrecleaningEnabled -J-XX ermSize=64m -J-XX:MaxPermSize=96m -J-Dswing.aatext=true"

The Jtable have around 3000 records to be exported. The size of the table can go up to 512MB. What else can i do? Is there a way to do garbage collection to release memory?

I have changed the JVM parameter in netbeans/etc/netbeans.conf
I changed MaxPermSize from 200 to 512
But i am still facing the problem. Am i changing it in the right way?

# ${HOME} will be replaced by JVM user.home system property
netbeans_default_userdir="${HOME}/.netbeans/6.0"

# Options used by NetBeans launcher by default, can be overridden by explicit
# command line switches:
netbeans_default_options="-J-client -J-Xss2m -J-Xms32m -J-XX ermSize=32m -J-XX:MaxPermSize=512m -J-Xverify:none -J-Dapple.laf.useScreenMenuBar=true"
# (Note that a default -Xmx is selected for you automatically.)

# If you specify the heap size (-Xmx) explicitely, you may also want to enable
# Concurrent Mark & Sweep garbage collector. In such case add the following
# options to the netbeans_default_options:
# -J-XX:+UseConcMarkSweepGC -J-XX:+CMSClassUnloadingEnabled -J-XX:+CMSPermGenSweepingEnabled
# (see http://wiki.netbeans.org/wiki/view/FaqGCPauses)

# Default location of JDK, can be overridden by using --jdkhome <dir>:
netbeans_jdkhome="C:\Program Files\Java\jdk1.5.0_15"

# Additional module clusters, using ${path.separator} (';' on Windows or ':' on Unix):

Hi there, i am using netbeans 6.0

when i am exporting the Jtable to my excel sheet i am encountering out of memory error in java heap space error. I tried setting the JVM heapsze manually but it was not working. Is there any method to explicitly allocate memory accoding to the size of the table? Or any other ways i could do to solve this problem? Thank You....

//actual population of target spreadsheet int currentCell = 0; for (int i=0; i<rowCount; i++) { List tableData = this.tableModel.getRow(i); // create row in spreadsheet row = sheet1.createRow((short)(i+1)); for (int j=0; j<tableData.size(); j++) { // grab the data element // populate the spreadsheet with the cell row.createCell((short)j).setCellValue(tableData.get(j).toString()); //System.out.println(columnData); currentCell++; // update the progress bar frame.current.setValue(currentCell); } } // update the status label when finished frame.generatingLabel.setText(this.fileName + " Generated"); // clean up resources wb.write(fileOut); fileOut.close(); }
[ April 21, 2008: Message edited by: catherine matthews ]

Hi everyone,

I need to export a MS Access database table to MS excel spreadsheet in my java program. I read something about JExcelAPI. Is that the only way of doing it or i have some other options? Please help. Thanks

Hi, i used jackcess to create a database table as below using netbeans Database db = null; try { db = Database.create(new File("new.mdb")); } catch (IOException ex) { ex.printStackTrace(); } Table newTable = null; try { newTable = new TableBuilder("NewTable").addColumn(new ColumnBuilder("a").setSQLType(Types.INTEGER).toColumn()).addColumn(new ColumnBuilder("b").setSQLType(Types.VARCHAR).toColumn()).toTable(db); } catch (SQLException ex) { ex.printStackTrace(); } catch (IOException ex) { ex.printStackTrace(); } try { newTable.addRow(1, "foo"); } catch (IOException ex) { ex.printStackTrace(); } }

But i am getting this error. what classis this? where can i get it? i tried downloading this file commons-logging-1.1.1-src.zip into libraries web page

but i still get this error message
Exception in thread "AWT-EventQueue-0" java.lang.NoClassDefFoundError: org/apache/commons/logging/LogFactory at com.healthmarketscience.jackcess.Database.<clinit>(Database.java:71)

Hi everyone, i need to create a new table(newtable), in a new database file (newdb.mdb)from an existing file (old.mdb), (oldtable). Can i do it in a single connection as below? The code below copies the table to the exixsting database file.


try { Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); System.out.println("Starting DB"); String filename = "d:/java/db4.mdb"; String database = "jdbc :o dbc :D river={Microsoft Access Driver (*.mdb)};DBQ="; database+= filename.trim() + ";DriverID=22;READONLY=true}"; con = DriverManager.getConnection(database, "",""); Statement st = con.createStatement(); st.executeUpdate( "Drop Table FormulaQ1"); st.executeUpdate( "SELECT *INTO FormulaQ1 from MDBQ1"); System.out.println("Ending DB"); }// end of try catch(SQLException e) { System.out.println("SQL Error is here at :"+e); } catch(Exception e) { System.out.println("Error :"+e); } finally { try{ if(con!=null) { con.close(); } } catch(SQLException e) { System.out.println(e); } }

[ April 04, 2008: Message edited by: catherine matthews ]
[ April 04, 2008: Message edited by: catherine matthews ]

I could not find much help on how to create dateabse connection with netbeans.

I am trying to access tables in MS Access using the netbeans. Can anyone help??

I tried to add the driver from
Runtime-database-drivers-(JDBC-ODBC-DRIVER)-Connect Using
Name : JDBC-ODBC-BRIDGE
Database URL : jdbc dbc:<DB>

the DB part i put in d:/java/db4.mdb- the path where my database file is
But i could not make a connection


When i run the code below using a command prompt There is no problem

Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); System.out.println("Starting DB"); String filename = "d:/java/db4.mdb"; String database = "jdbc :-o dbc :mrgreen: river={Microsoft Access Driver (*.mdb)};DBQ="; database+= filename.trim() + ";DriverID=22;READONLY=true}"; con = DriverManager.getConnection(database, "",""); Statement st = con.createStatement();

mdbfdt is a valid file name. it could be opened with MS access.

Hi there,
i have a database file with file extension .mdbfdt It caould be opened with
MS access. But when i try to do a connection i get an error. Is there any specific things i need to code? I cannot change the .mdbfdt file extension
What can i do to make my application read the database?


SQL Error :java.sql.SQLException: [Microsoft][ODBC Microsoft Access Driver] Could not find file '(unknown)'.

Hi, i have added the highlighted code. Is the JDBC driver you meant?
But i still get error as below

Starting DB
SQL Error :java.sql.SQLException: [Microsoft][ODBC Microsoft Access Driver] The Microsoft Jet database engine could not find the object 'White'. Make sure the object exists and that you spell its name and the path name correctly.
no of records : 0

White is my column name. I cant understand this error message

import java.awt.*; import java.util.*; import java.sql.*; import javax.swing.*; import javax.swing.event.*; public class TableDemo extends JFrame{ public TableDemo(){ Container contentpane=getContentPane(); contentpane.setLayout(new BorderLayout()); String[] colHeads={"Black","White"}; Connection con=null; Statement stmt=null; ResultSet rs=null; ArrayList values=new ArrayList(); try{ [B]Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");[/B] System.out.println("Starting DB"); String filename = "d:/java/mdbTEST.mdb"; String database = "jdbc:odbc:Driver={Microsoft Access Driver (*.mdb)};DBQ="; database+= filename.trim() + ";DriverID=22;READONLY=true}"; con = DriverManager.getConnection(database, "",""); stmt=con.createStatement(); rs=stmt.executeQuery("SELECT * FROM Formula"); ResultSetMetaData md = rs.getMetaData(); while(rs.next()){ values.add(rs.getString("Black")); values.add(rs.getString("White")); } System.out.println("size of array"+values.size()); System.out.println("Ending DB"); }catch(SQLException e){ System.out.println("SQL Error :"+e); }catch(Exception e){ System.out.println("Error :"+e); } finally{ try{ if(con!=null){ con.close(); } }catch(SQLException e) { System.out.println(e); } } int noOfRows=(values.size())/colHeads.length; int no=0; Object[][] data=new Object[noOfRows][colHeads.length]; System.out.println("no of records : "+noOfRows); for(int i=0;i<noOfRows;i++){ for(int j=0;j<colHeads.length;j++){ String s=(String)values.get(no++); System.out.println("the values" + s ); data[j][no]=s; } } JTable table=new JTable(data,colHeads); int v=ScrollPaneConstants.VERTICAL_SCROLLBAR_AS_NEEDED; int h=ScrollPaneConstants.HORIZONTAL_SCROLLBAR_AS_NEEDED; JScrollPane jsp=new JScrollPane(table,v,h); contentpane.add(jsp,BorderLayout.CENTER); setVisible(true); setSize(200,300); setTitle("Table Demo"); } public static void main(String args[]){ TableDemo t=new TableDemo(); } }