Data types mapping from JDBC to MS Access databases

From: Pony (bjliu_at_21cn.com)
Date: 02/24/05

  • Next message: Robert Sundström: "Re: metadata gettables()" 
    Date: Thu, 24 Feb 2005 10:31:43 GMT

    I'm writing a application to create a database table and insert records in
    it. How can I create data field of percentage data type and also define the
    precision of a number in Java? It will be grateful if anybody can provide me
    with all the data types supported that map from MS Access to JDBC.

    Thank you!

    Pony

  • Next message: Robert Sundström: "Re: metadata gettables()"

    Relevant Pages

    • Re: Database set up help
      ... let's see...I choose the y/n data type because I am using ... User opens up form and enters Employee Information in the fields ... 2 of the 38 options in my main menu are BPCS Applications ... I set up a database with this so far: ...
      (microsoft.public.access.gettingstarted)
    • Re: runtime error with Mask edit control
      ... DateOfBirth property is a string. ... If no value is entered into the Property, the database stores a null. ... > its data type (one would assume the same as the property, ...
      (microsoft.public.vb.controls)
    • Re: Type Mismatch Error Message
      ... >> Using Text as SQL data type. ... I created a database on a SQL server manually and matched the column names ... I thought you "didn't use the database wizard?" ... >> Data type in form is No Constraints. ...
      (microsoft.public.frontpage.programming)
    • Re: Search for columns in tables that are a specific data type?
      ... It may be more info than you want, but you can use the Database Documenter ... was the AutoNumber data type; it did get migrated as an Integer, ... I know how to do this in SQL but can't seem to find ...
      (microsoft.public.access.queries)
    • RE: function doesnt return value - SOMETIMES!
      ... It seems the calling stack has some issues. ... If not, I suggest that you create a new database, and import the ... |> thing I can see is that you are declaring 3 of your numerical values as ... |> when it does work correctly that would be because this data type is ...
      (microsoft.public.access.modulesdaovba)