GIVEN:
-------------------------------------
-- Ajqvue SQL Dump
--
-- Host: 127.0.0.1
-- Generated On: 2026.01.28 AD at 05:46:57 MST
-- SQL version: MariaDB 12.1.2-MariaDB-log
-- JDBC Connector: JDBC 3.5.7.
-- Database: mariadbtypes
-- ------------------------------------------
-- Table structure for table `point_types`
--
CREATE TABLE `point_types` (
`data_type_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`point_type` point DEFAULT NULL,
PRIMARY KEY (`data_type_id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4
COLLATE=utf8mb4_unicode_ci;
INSERT INTO point_types
(point_type)
VALUES
(PointFromText('POINT(10 10)')),
(PointFromText('POINT(20 20)'));
------------------------------------------------
Can anyone explain to me what is wrong with the following SQLStatement?
StringBuffer sqlStatementString = new StringBuffer();
sqlStatementString.append("SELECT AsWKT(`point_type`) FROM `point_types`
WHERE `data_type_id`='2'");
ResultSet db_resultSet =
sqlStatement.executeQuery(sqlStatementString.toString());
TableTabPanel actionPerformed() (CM) Connection Created
TableTabPanel_MariaDB viewSelectedItem()
SQLException: Unknown label 'data_type_id'. Possible value
[aswkt(`point_type`), .aswkt(`point_type`)]
SQLState: null
VendorError: 0
TableTabPanel actionPerformed() (CM) Connection Closed
It executes fine in the command line tool:
MariaDB [mariadbtypes]> SELECT AsWKT(`point_type`) FROM `point_types`
WHERE `data_type_id`='2';
+---------------------+
| AsWKT(`point_type`) |
+---------------------+
| POINT(20 20) |
+---------------------+
1 row in set (0.001 sec)
MariaDB [mariadbtypes]>
_______________________________________________
discuss mailing list -- [email protected]
To unsubscribe send an email to [email protected]
