Namrita Mohanty

Can someone please help on this!!!

Hi All,

Am using JavaFX to read a data a database ... I see the data when i print it on the console of the IDE but unable to get it displayed in the Table View. I have included all the code in the main class.
Please Help!!! (Let me know if anything else is needed to debug, am new to FX)

/* * To change this license header, choose License Headers in Project Properties. * To change this template file, choose Tools | Templates * and open the template in the editor. */ package sampledata; import java.awt.Font; import java.awt.Insets; import java.sql.Connection; import java.sql.DriverManager; import static java.sql.DriverManager.println; import java.sql.PreparedStatement; import java.sql.ResultSet; import java.sql.SQLException; import javafx.application.Application; import javafx.beans.property.SimpleStringProperty; import javafx.beans.value.ObservableValue; import javafx.collections.FXCollections; import javafx.collections.ObservableList; import javafx.fxml.FXMLLoader; import javafx.scene.Group; import javafx.scene.Parent; import javafx.scene.Scene; import javafx.scene.control.Label; import javafx.scene.control.TableColumn; import javafx.scene.control.TableView; import javafx.scene.control.cell.PropertyValueFactory; import javafx.scene.layout.VBox; import javafx.stage.Stage; import javafx.util.Callback; //import static sampledata.FXMLDocumentController.getConnection; /** * * @author administrator */ public class SampleData extends Application { private ObservableList<ObservableList> data; private TableView table = new TableView(); public static void main(String[] args) { launch(args); } //@Override //public void start(Stage stage) throws Exception { public void buildData(){ data = FXCollections.observableArrayList(); try{ String []divisions = {"F","D","B","W","M"}; String []contactNames = {"Dave","Namrita","Anil","Frank","Bill"}; Connection conn = getConnection(); PreparedStatement ps = conn.prepareStatement( "select acct_no, name, division, contact from test_customers " + "order by acct_no" ); ResultSet rs = ps.executeQuery(); while (rs.next()) { String acctNo = rs.getString( "acct_no" ); String name = rs.getString( "name" ); String division = rs.getString( "division" ); String contact = rs.getString( "contact" ); ObservableList<String> row = FXCollections.observableArrayList(); for(int i=1 ; i<=rs.getMetaData().getColumnCount(); i++){ row.add(rs.getString(i)); } data.add(row); System.out.println("Data "+ data ); } //rs.close(); //ps.close(); //conn.close(); table.setItems(data); } catch(Exception e){ e.printStackTrace(); System.out.println("Error on Building Data"); } //table.setEditable(true); TableColumn firstNameCol = new TableColumn("First Name"); firstNameCol.setMinWidth(200); TableColumn accNumberCol = new TableColumn("Account Number"); accNumberCol.setMinWidth(100); TableColumn contactsCol = new TableColumn("Contacts"); contactsCol.setMinWidth(100); TableColumn divisionCol = new TableColumn("Division"); divisionCol.setMinWidth(200); table.getColumns().addAll(firstNameCol, contactsCol, accNumberCol,divisionCol); System.out.println("Table Value::" + table); } @Override public void start(Stage stage) throws Exception { table = new TableView(); buildData(); Scene scene = new Scene(table); stage.setScene(scene); stage.show(); } private Connection getConnection() throws SQLException, ClassNotFoundException { String driver = "org.postgresql.Driver"; System.out.println("Connected"); String url = "jdbc:postgresql://prod:5432/wrcobb"; Class.forName( driver ); Connection conn; conn = DriverManager.getConnection( url, "wrcobb", "wrcobb" ); System.out.println("Enter DB with credentials"); conn.setAutoCommit( false ); return conn; } public static class Person { private final SimpleStringProperty firstName; private final SimpleStringProperty accNumber; private final SimpleStringProperty division; private final SimpleStringProperty lastName; private Person(String fName, String aNumber, String div, String lName) { this.firstName = new SimpleStringProperty(fName); this.accNumber = new SimpleStringProperty(aNumber); this.division = new SimpleStringProperty(div); this.lastName = new SimpleStringProperty(lName); } public String getFirstName() { return firstName.get(); } public void setFirstName(String fName) { firstName.set(fName); } public String getAccountNumber() { return accNumber.get(); } public void setAccountNumber(String aNumber) { accNumber.set(aNumber); } public String getDivision() { return division.get(); } public void setDivision(String div) { division.set(div); } public String getLastName() { return lastName.get(); } public void setLastName(String fName) { lastName.set(fName); } } }

When I run the project I do not see any table view thing coming up.

If any one has a sample program to read a database please share as well. Would be of a great help n reference.
Thanks,
Namrita

HI, I new to JavaFX and was trying to read my database data into a Table view (GUI). Please help me!!!

package studentinfo; import java.sql.Connection; import java.sql.DatabaseMetaData; import java.sql.DriverManager; import java.sql.ResultSet; import java.sql.SQLException; import java.sql.Statement; import java.util.LinkedList; import java.util.List; import javafx.collections.FXCollections; import javafx.collections.ObservableList; public class StudentInfo { static String JDBC_DRIVER = "org.postgresql.Driver"; //static String DB_URL = "jdbc:h2:file:C:/WAKILI/WAKILIdb"; // Database credentials static final String USER = "wrcobb"; static final String PASS = "wrcobb"; public static Connection conn = null; public List<KIWIDataModel> getAllstudentInfo() throws SQLException { Statement st = null; ResultSet rs; String driver = "org.postgresql.Driver"; List ll = new LinkedList(); String dbName = "wrcobb"; String urlString = System.getProperty( "db.url", "jdbc:postgresql://localhost:5432/" + dbName + "?user=wrcobb&password=wrcobb" ); conn = DriverManager.getConnection( urlString ); DatabaseMetaData dmd = conn.getMetaData(); try { Class.forName(driver); //conn = DriverManager.getConnection(DB_URL, USER, PASS); conn = DriverManager.getConnection(urlString); st = conn.createStatement(); String recordQuery = ("SELECT id, KIWI FROM KIWI"); rs = st.executeQuery(recordQuery); while (rs.next()) { int Key = rs.getInt(1); ObservableList row = FXCollections.observableArrayList(); for (int i = 1; i <= rs.getMetaData().getColumnCount(); i++) { row.add(rs.getString(i)); System.out.println(row); } KIWIDataModel roww = new KIWIDataModel(); roww.setFirstName(Key); ll.add(row); } } catch (ClassNotFoundException | SQLException ex) { // CATCH SOMETHING } return ll; } }

*******************************
CONTROLLER CLASS:
/* * To change this license header, choose License Headers in Project Properties. * To change this template file, choose Tools | Templates * and open the template in the editor. */ package easyjavafx; import java.awt.EventQueue; import java.net.URL; import java.sql.Connection; import java.sql.DatabaseMetaData; import java.sql.DriverManager; import java.sql.ResultSet; import java.util.ResourceBundle; import javafx.event.ActionEvent; import javafx.fxml.FXML; import javafx.fxml.Initializable; import javafx.scene.control.Label; /** * * @author administrator */ public class FXMLDocumentController implements Initializable { @FXML private Label label; @FXML private void handleEnterButtonAction(ActionEvent event) { System.out.println("You clicked Enter!"); label.setText("Welcome"); try { String driver = "org.postgresql.Driver"; Class.forName( driver ); String dbName = "wrcobb"; String urlString = System.getProperty( "db.url", "jdbc:postgresql://localhost:5432/" + dbName + "?user=wrcobb&password=wrcobb" ); Connection conn = DriverManager.getConnection( urlString ); DatabaseMetaData dmd = conn.getMetaData(); ResultSet trs = dmd.getTables( null, null, "%", new String[]{"TABLE"} ); int tableCount = 0; while (trs.next()) { String tableName = trs.getString( "TABLE_NAME" ); String typeName = trs.getString( "TABLE_TYPE" ); System.out.printf( "Found %s, type: %s\n", tableName, typeName ); tableCount++; } trs.close(); label.setText( String.format( "There are %d tables", tableCount ) ); } catch( Exception ex ) { label.setText( ex.toString() ); } } @FXML private void handleExitButtonAction(ActionEvent event) { System.out.println("You clicked Exit!"); label.setText("Thank You!"); EventQueue.invokeLater( new Runnable() { public void run() { try { Thread.sleep( 1000 ); System.exit( 0 ); } catch( Exception ex ) { ex.printStackTrace(); } } }); } @Override public void initialize(URL url, ResourceBundle rb) { // TODO } }

*******************************

FXML:
<?xml version="1.0" encoding="UTF-8"?> <?import java.lang.*?> <?import java.util.*?> <?import javafx.scene.*?> <?import javafx.scene.control.*?> <?import javafx.scene.layout.*?> <AnchorPane id="AnchorPane" prefHeight="200" prefWidth="320" xmlns:fx="http://javafx.com/fxml" fx:controller="studentinfo.FXMLDocumentController"> <children> <Button layoutX="126" layoutY="90" text="Click Me!" onAction="#handleButtonAction" fx:id="button" /> <Label layoutX="126" layoutY="120" minHeight="16" minWidth="69" fx:id="label" /> </children> </AnchorPane>

*******************************

package studentinfo; import javafx.beans.property.SimpleIntegerProperty; public class KIWIDataModel { public SimpleIntegerProperty firstName; public int getFirstName() { return firstName.get(); } public void setFirstName(int fName) { firstName.set(fName); } }

While it saves data into the Database the correct Thai format is getting saved....

For Eg:

Table: PostalCodes has three columns [Postalcode(numeric english),
District(Thai letters),
City(Thai letters)]

Only when we search for a Postalcode i.e a numeric value it displays the Thai letters of its correcponding District and City in "?". Like if its 3 letters in thai that should come it displays "???" for the District and for City of 7 letters in Thai its 7 Q marks that is getting displayed.

Any ideas?

Cheers!
Namrita

Oops!!! Just to make a small correction.... For other Tables also it isnt working... Thai data from database when tried to display it on the screen shows "?" Question marks....

Sorry... Please help?

Hello,

My Database has some data in Thai Language. While displaying it in the UI I see only "?" instead of the Thai letters.

This is happening for only one table in the database. Other tables are working fine. I mean it returns and displays the proper Thai name if stored.

Could anyone help?

Thanks,
Namrita

When I looked into the Database scripts that was run, there it was defined as:
"SMOKERSTATUSCODE" NOT NULL

I did change it to NULL and it is working now.... Earlier I had checked only with the Table details wherein it said in Column Properties that NULL is allowed but still it wasnt allowing inserting NULL as the scripts were run with "NOT NULL" [I suppose]

So many days I was not encountering this similar problem with the fix provided. But again I did run into this with another attribute:

"ORA-01400: cannot insert NULL into ("KUNALB"."NBCUSTOMER"."SMOKERSTATUSCODE")"

In the mapping file I have set its "not-null" value as "false" still am facing this.

Suggestions please...

"2010-10-14 10:55:14,750 WARN [http-8080-1] org.hibernate.util.JDBCExceptionReporter:357 - SQL Error: 1, SQLState: 23000
2010-10-14 10:55:14,750 ERROR [http-8080-1] org.hibernate.util.JDBCExceptionReporter:454 - ORA-00001: unique constraint (KUNALB.SYS_C0071113) violated

2010-10-14 10:55:14,750 WARN [http-8080-1] org.hibernate.util.JDBCExceptionReporter:357 - SQL Error: 1, SQLState: 23000
2010-10-14 10:55:14,750 ERROR [http-8080-1] org.hibernate.util.JDBCExceptionReporter:454 - ORA-00001: unique constraint (KUNALB.SYS_C0071113) violated

2010-10-14 10:55:14,750 ERROR [http-8080-1] org.hibernate.event.def.AbstractFlushingEventListener:532 - Could not synchronize database state with session
org.hibernate.exception.ConstraintViolationException: Could not execute JDBC batch update
at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:94)"

The above error is thrown though I do not have the record that am trying to save in the Database.

Any suggestions?

Thanks. It did solve my problem.

Regards,
Namrita

I found out the mapping file :

<property name="otheridnumber" type="java.lang.String">
<column name="OTHERIDNUMBER" length="50" />
</property>

it doesn't say if it can be "null" or not like it says for some of the fields [though not all]

<many-to-one name="nbgender" class="com.hib.reverse.Nbgender" fetch="select">
<column name="GENDERCODE" precision="22" scale="0" not-null="true" />
</many-to-one>

Thanks,
Namrita

Even if i make the otherIDNumber work by hardcoding the value I get the below error:

org.springframework.dao.InvalidDataAccessApiUsageException: object references an unsaved transient instance - save the transient instance before flushing: com.ing.workstation.resource.appcapture.dto.NationalityCodes; nested exception is org.hibernate.TransientObjectException: object references an unsaved transient instance - save the transient instance before flushing: com.ing.workstation.resource.appcapture.dto.NationalityCodes

Could you please suggest. Anyone??

Thanks,
Namrita

Hello SanathanaKrishanan,

Could you please specify about which mapping file should I be checking out for the database column properties. I am not aware of it.

Thanks,
Namrita