java.sql.SQLException

Wrong data type: NUMBER in statement [CREATE TABLE Jonathan_Table (TableColumn NUMBER]


Solutions on the web8441

Solution icon of web
Wrong data type: NUMBER in statement [CREATE TABLE Jonathan_Table (TableColumn NUMBER]

Solution icon of oraclecommunity
via Oracle Community by 669885, 1 year ago
Wrong data type: in statement [create table "C$_Y0ps_load_file" ( )]

Solution icon of oraclecommunity
Wrong data type: in statement [create table "C$_0Entity" ( )]

Solution icon of oraclecommunity
via Oracle Community by user4783187, 1 year ago
Wrong data type: in statement [create table "C$_0Account" ( )]

Solution icon of oraclecommunity
via Oracle Community by Varun Kaushal, 1 year ago
Wrong data type: in statement [create table "C$_0File" ( )]

Solution icon of coderanch
via Coderanch by Sanjib Pal, 8 months ago
Wrong data type: TEXT in statement [CREATE TABLE QA_USER (id TEXT]

Solution icon of stackoverflow
via Stack Overflow by LeoLozes
, 1 year ago
Wrong data type: BLOB in statement [CREATE TABLE TSHT_SALEPLAN ( SALEPLANCODE INTEGER, VENDORCODE VARCHAR(10), HOTELCODE INTEGER, SALEPLAN BLOB]

Solution icon of atlassian
via Atlassian JIRA by Boris Berenberg [Atlassian], 1 year ago
Wrong data type: ( in statement [CREATE TABLE PUBLIC.AO_97EDAB_USERINVITATION ( EXPIRY DATETIME, ID INTEGER GENERATED BY DEFAULT AS IDENTITY (START WITH 1), NVARCHAR(]

Solution icon of sourceforge
Wrong data type: hexadecimal string with odd number of characters

Solution icon of oraclecommunity
Wrong data type: KEY in statement [Alter Table user_type_table add primary key]

Stack trace

  • java.sql.SQLException: Wrong data type: NUMBER in statement [CREATE TABLE Jonathan_Table (TableColumn NUMBER] at org.hsqldb.jdbc.Util.throwError(Unknown Source) at org.hsqldb.jdbc.jdbcPreparedStatement.executeUpdate(Unknown Source) at com.bnpp.pb.risklayer.services.dao.jdbc.JdbcPrimeRiskServerDaoUnitTest.getDataSet(JdbcPrimeRiskServerDaoUnitTest.java:57) at org.dbunit.DatabaseTestCase.setUp(DatabaseTestCase.java:154)

Write tip

You have a different solution? A short tip here would help you and many other users who saw this issue last week.

Users with the same issue

Samebug visitor profile picture
Unknown user
Once, 7 months ago
Samebug visitor profile picture
Unknown user
Once, 7 months ago
Samebug visitor profile picture
Unknown user
Once, 11 months ago
Samebug visitor profile picture
Unknown user
Once, 1 year ago
Samebug visitor profile picture
Unknown user
Once, 1 year ago
2 more bugmates