API tools faq
paste
Advertisement
Guest User

ResultSetMetaData of MariaDB datatypes

a guest
Mar 2nd, 2015
397
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 10.25 KB | None | 0 0
raw download clone embed print report
  1. [INFO ] 2015-03-02 12:27:29.979 [main] c.d.d.AppDbTest.main - Using JDBC driver org.mariadb.jdbc.Driver version 1.1.
  2.  
  3. [INFO ] 2015-03-02 12:27:30.487 [main] c.d.d.AppDbTest.main - getCatalogName sample.
  4.  
  5. [INFO ] 2015-03-02 12:27:30.487 [main] c.d.d.AppDbTest.main - getSchemaName .
  6.  
  7. [INFO ] 2015-03-02 12:27:30.487 [main] c.d.d.AppDbTest.main - getTableName datatypes.
  8.  
  9. [INFO ] 2015-03-02 12:27:30.487 [main] c.d.d.AppDbTest.main - getColumnCount 39.
  10.  
  11. [INFO ] 2015-03-02 12:27:30.488 [main] c.d.d.AppDbTest.main - getColumnName mariadb_bigint | getColumnLabel mariadb_bigint.
  12. getColumnClassName java.lang.Long.
  13. getColumnDisplaySize 20.
  14. getColumnType -5.
  15. getColumnTypeName BIGINT.
  16. getPrecision 20.
  17.  
  18. [INFO ] 2015-03-02 12:27:30.489 [main] c.d.d.AppDbTest.main - getColumnName mariadb_binary | getColumnLabel mariadb_binary.
  19. getColumnClassName [B.
  20. getColumnDisplaySize 8.
  21. getColumnType -2.
  22. getColumnTypeName BINARY.
  23. getPrecision 8.
  24.  
  25. [INFO ] 2015-03-02 12:27:30.489 [main] c.d.d.AppDbTest.main - getColumnName mariadb_bit | getColumnLabel mariadb_bit.
  26. getColumnClassName java.lang.Boolean.
  27. getColumnDisplaySize 1.
  28. getColumnType -7.
  29. getColumnTypeName BIT.
  30. getPrecision 1.
  31.  
  32. [INFO ] 2015-03-02 12:27:30.489 [main] c.d.d.AppDbTest.main - getColumnName mariadb_blob | getColumnLabel mariadb_blob.
  33. getColumnClassName [B.
  34. getColumnDisplaySize 65535.
  35. getColumnType -4.
  36. getColumnTypeName BLOB.
  37. getPrecision 65535.
  38.  
  39. [INFO ] 2015-03-02 12:27:30.489 [main] c.d.d.AppDbTest.main - getColumnName mariadb_boolean | getColumnLabel mariadb_boolean.
  40. getColumnClassName java.lang.Boolean.
  41. getColumnDisplaySize 1.
  42. getColumnType -7.
  43. getColumnTypeName TINYINT.
  44. getPrecision 1.
  45.  
  46. [INFO ] 2015-03-02 12:27:30.490 [main] c.d.d.AppDbTest.main - getColumnName mariadb_char | getColumnLabel mariadb_char.
  47. getColumnClassName java.lang.String.
  48. getColumnDisplaySize 5.
  49. getColumnType 1.
  50. getColumnTypeName CHAR.
  51. getPrecision 5.
  52.  
  53. [INFO ] 2015-03-02 12:27:30.491 [main] c.d.d.AppDbTest.main - getColumnName mariadb_date | getColumnLabel mariadb_date.
  54. getColumnClassName java.sql.Date.
  55. getColumnDisplaySize 10.
  56. getColumnType 91.
  57. getColumnTypeName DATE.
  58. getPrecision 10.
  59.  
  60. [INFO ] 2015-03-02 12:27:30.491 [main] c.d.d.AppDbTest.main - getColumnName mariadb_datetime | getColumnLabel mariadb_datetime.
  61. getColumnClassName java.sql.Timestamp.
  62. getColumnDisplaySize 19.
  63. getColumnType 93.
  64. getColumnTypeName DATETIME.
  65. getPrecision 19.
  66.  
  67. [INFO ] 2015-03-02 12:27:30.491 [main] c.d.d.AppDbTest.main - getColumnName mariadb_decimal | getColumnLabel mariadb_decimal.
  68. getColumnClassName java.math.BigDecimal.
  69. getColumnDisplaySize 11.
  70. getColumnType 3.
  71. getColumnTypeName DECIMAL.
  72. getPrecision 10.
  73.  
  74. [INFO ] 2015-03-02 12:27:30.492 [main] c.d.d.AppDbTest.main - getColumnName mariadb_double | getColumnLabel mariadb_double.
  75. getColumnClassName java.lang.Double.
  76. getColumnDisplaySize 22.
  77. getColumnType 8.
  78. getColumnTypeName DOUBLE.
  79. getPrecision 22.
  80.  
  81. [INFO ] 2015-03-02 12:27:30.493 [main] c.d.d.AppDbTest.main - getColumnName mariadb_enum | getColumnLabel mariadb_enum.
  82. getColumnClassName java.lang.String.
  83. getColumnDisplaySize 5.
  84. getColumnType 1.
  85. getColumnTypeName CHAR.
  86. getPrecision 5.
  87.  
  88. [INFO ] 2015-03-02 12:27:30.493 [main] c.d.d.AppDbTest.main - getColumnName mariadb_float | getColumnLabel mariadb_float.
  89. getColumnClassName java.lang.Float.
  90. getColumnDisplaySize 12.
  91. getColumnType 7.
  92. getColumnTypeName FLOAT.
  93. getPrecision 12.
  94.  
  95. [INFO ] 2015-03-02 12:27:30.494 [main] c.d.d.AppDbTest.main - getColumnName mariadb_geometry | getColumnLabel mariadb_geometry.
  96. getColumnClassName [B.
  97. getColumnDisplaySize 2147483647.
  98. getColumnType -2.
  99. getColumnTypeName GEOMETRY.
  100. getPrecision 2147483647.
  101.  
  102. [INFO ] 2015-03-02 12:27:30.494 [main] c.d.d.AppDbTest.main - getColumnName mariadb_geometrycollection | getColumnLabel mariadb_geometrycollection.
  103. getColumnClassName [B.
  104. getColumnDisplaySize 2147483647.
  105. getColumnType -2.
  106. getColumnTypeName GEOMETRY.
  107. getPrecision 2147483647.
  108.  
  109. [INFO ] 2015-03-02 12:27:30.495 [main] c.d.d.AppDbTest.main - getColumnName mariadb_int | getColumnLabel mariadb_int.
  110. getColumnClassName java.lang.Integer.
  111. getColumnDisplaySize 11.
  112. getColumnType 4.
  113. getColumnTypeName INT.
  114. getPrecision 11.
  115.  
  116. [INFO ] 2015-03-02 12:27:30.496 [main] c.d.d.AppDbTest.main - getColumnName mariadb_linestring | getColumnLabel mariadb_linestring.
  117. getColumnClassName [B.
  118. getColumnDisplaySize 2147483647.
  119. getColumnType -2.
  120. getColumnTypeName GEOMETRY.
  121. getPrecision 2147483647.
  122.  
  123. [INFO ] 2015-03-02 12:27:30.496 [main] c.d.d.AppDbTest.main - getColumnName mariadb_longblob | getColumnLabel mariadb_longblob.
  124. getColumnClassName [B.
  125. getColumnDisplaySize 2147483647.
  126. getColumnType -4.
  127. getColumnTypeName LONGBLOB.
  128. getPrecision 2147483647.
  129.  
  130. [INFO ] 2015-03-02 12:27:30.497 [main] c.d.d.AppDbTest.main - getColumnName mariadb_longtext | getColumnLabel mariadb_longtext.
  131. getColumnClassName java.lang.String.
  132. getColumnDisplaySize 715827882.
  133. getColumnType -1.
  134. getColumnTypeName VARCHAR.
  135. getPrecision 715827882.
  136.  
  137. [INFO ] 2015-03-02 12:27:30.498 [main] c.d.d.AppDbTest.main - getColumnName mariadb_mediumblob | getColumnLabel mariadb_mediumblob.
  138. getColumnClassName [B.
  139. getColumnDisplaySize 16777215.
  140. getColumnType -4.
  141. getColumnTypeName MEDIUMBLOB.
  142. getPrecision 16777215.
  143.  
  144. [INFO ] 2015-03-02 12:27:30.498 [main] c.d.d.AppDbTest.main - getColumnName mariadb_mediumint | getColumnLabel mariadb_mediumint.
  145. getColumnClassName java.lang.Integer.
  146. getColumnDisplaySize 9.
  147. getColumnType 4.
  148. getColumnTypeName MEDIUMINT.
  149. getPrecision 9.
  150.  
  151. [INFO ] 2015-03-02 12:27:30.499 [main] c.d.d.AppDbTest.main - getColumnName mariadb_mediumtext | getColumnLabel mariadb_mediumtext.
  152. getColumnClassName java.lang.String.
  153. getColumnDisplaySize 5592405.
  154. getColumnType -1.
  155. getColumnTypeName VARCHAR.
  156. getPrecision 5592405.
  157.  
  158. [INFO ] 2015-03-02 12:27:30.499 [main] c.d.d.AppDbTest.main - getColumnName mariadb_multilinestring | getColumnLabel mariadb_multilinestring.
  159. getColumnClassName [B.
  160. getColumnDisplaySize 2147483647.
  161. getColumnType -2.
  162. getColumnTypeName GEOMETRY.
  163. getPrecision 2147483647.
  164.  
  165. [INFO ] 2015-03-02 12:27:30.500 [main] c.d.d.AppDbTest.main - getColumnName mariadb_multipoint | getColumnLabel mariadb_multipoint.
  166. getColumnClassName [B.
  167. getColumnDisplaySize 2147483647.
  168. getColumnType -2.
  169. getColumnTypeName GEOMETRY.
  170. getPrecision 2147483647.
  171.  
  172. [INFO ] 2015-03-02 12:27:30.501 [main] c.d.d.AppDbTest.main - getColumnName mariadb_multipolygon | getColumnLabel mariadb_multipolygon.
  173. getColumnClassName [B.
  174. getColumnDisplaySize 2147483647.
  175. getColumnType -2.
  176. getColumnTypeName GEOMETRY.
  177. getPrecision 2147483647.
  178.  
  179. [INFO ] 2015-03-02 12:27:30.501 [main] c.d.d.AppDbTest.main - getColumnName mariadb_point | getColumnLabel mariadb_point.
  180. getColumnClassName [B.
  181. getColumnDisplaySize 2147483647.
  182. getColumnType -2.
  183. getColumnTypeName GEOMETRY.
  184. getPrecision 2147483647.
  185.  
  186. [INFO ] 2015-03-02 12:27:30.502 [main] c.d.d.AppDbTest.main - getColumnName mariadb_polygon | getColumnLabel mariadb_polygon.
  187. getColumnClassName [B.
  188. getColumnDisplaySize 2147483647.
  189. getColumnType -2.
  190. getColumnTypeName GEOMETRY.
  191. getPrecision 2147483647.
  192.  
  193. [INFO ] 2015-03-02 12:27:30.503 [main] c.d.d.AppDbTest.main - getColumnName mariadb_real | getColumnLabel mariadb_real.
  194. getColumnClassName java.lang.Double.
  195. getColumnDisplaySize 22.
  196. getColumnType 8.
  197. getColumnTypeName DOUBLE.
  198. getPrecision 22.
  199.  
  200. [INFO ] 2015-03-02 12:27:30.503 [main] c.d.d.AppDbTest.main - getColumnName mariadb_serial | getColumnLabel mariadb_serial.
  201. getColumnClassName java.math.BigInteger.
  202. getColumnDisplaySize 20.
  203. getColumnType -5.
  204. getColumnTypeName BIGINT UNSIGNED.
  205. getPrecision 20.
  206.  
  207. [INFO ] 2015-03-02 12:27:30.504 [main] c.d.d.AppDbTest.main - getColumnName mariadb_set | getColumnLabel mariadb_set.
  208. getColumnClassName java.lang.String.
  209. getColumnDisplaySize 14.
  210. getColumnType 1.
  211. getColumnTypeName CHAR.
  212. getPrecision 14.
  213.  
  214. [INFO ] 2015-03-02 12:27:30.504 [main] c.d.d.AppDbTest.main - getColumnName mariadb_smallint | getColumnLabel mariadb_smallint.
  215. getColumnClassName java.lang.Integer.
  216. getColumnDisplaySize 6.
  217. getColumnType 5.
  218. getColumnTypeName SMALLINT.
  219. getPrecision 6.
  220.  
  221. [INFO ] 2015-03-02 12:27:30.505 [main] c.d.d.AppDbTest.main - getColumnName mariadb_text | getColumnLabel mariadb_text.
  222. getColumnClassName java.lang.String.
  223. getColumnDisplaySize 21845.
  224. getColumnType -1.
  225. getColumnTypeName VARCHAR.
  226. getPrecision 21845.
  227.  
  228. [INFO ] 2015-03-02 12:27:30.506 [main] c.d.d.AppDbTest.main - getColumnName mariadb_time | getColumnLabel mariadb_time.
  229. getColumnClassName java.sql.Time.
  230. getColumnDisplaySize 10.
  231. getColumnType 92.
  232. getColumnTypeName TIME.
  233. getPrecision 10.
  234.  
  235. [INFO ] 2015-03-02 12:27:30.508 [main] c.d.d.AppDbTest.main - getColumnName mariadb_timestamp | getColumnLabel mariadb_timestamp.
  236. getColumnClassName java.sql.Timestamp.
  237. getColumnDisplaySize 19.
  238. getColumnType 93.
  239. getColumnTypeName TIMESTAMP.
  240. getPrecision 19.
  241.  
  242. [INFO ] 2015-03-02 12:27:30.509 [main] c.d.d.AppDbTest.main - getColumnName mariadb_tinyblob | getColumnLabel mariadb_tinyblob.
  243. getColumnClassName [B.
  244. getColumnDisplaySize 255.
  245. getColumnType -3.
  246. getColumnTypeName TINYBLOB.
  247. getPrecision 255.
  248.  
  249. [INFO ] 2015-03-02 12:27:30.509 [main] c.d.d.AppDbTest.main - getColumnName mariadb_tinyint | getColumnLabel mariadb_tinyint.
  250. getColumnClassName java.lang.Integer.
  251. getColumnDisplaySize 4.
  252. getColumnType -6.
  253. getColumnTypeName TINYINT.
  254. getPrecision 4.
  255.  
  256. [INFO ] 2015-03-02 12:27:30.509 [main] c.d.d.AppDbTest.main - getColumnName mariadb_tinytext | getColumnLabel mariadb_tinytext.
  257. getColumnClassName java.lang.String.
  258. getColumnDisplaySize 85.
  259. getColumnType -1.
  260. getColumnTypeName VARCHAR.
  261. getPrecision 85.
  262.  
  263. [INFO ] 2015-03-02 12:27:30.510 [main] c.d.d.AppDbTest.main - getColumnName mariadb_varbinary | getColumnLabel mariadb_varbinary.
  264. getColumnClassName [B.
  265. getColumnDisplaySize 16.
  266. getColumnType -3.
  267. getColumnTypeName VARBINARY.
  268. getPrecision 16.
  269.  
  270. [INFO ] 2015-03-02 12:27:30.513 [main] c.d.d.AppDbTest.main - getColumnName mariadb_varchar | getColumnLabel mariadb_varchar.
  271. getColumnClassName java.lang.String.
  272. getColumnDisplaySize 5.
  273. getColumnType 12.
  274. getColumnTypeName VARCHAR.
  275. getPrecision 5.
  276.  
  277. [INFO ] 2015-03-02 12:27:30.513 [main] c.d.d.AppDbTest.main - getColumnName mariadb_year | getColumnLabel mariadb_year.
  278. getColumnClassName java.sql.Date.
  279. getColumnDisplaySize 4.
  280. getColumnType 91.
  281. getColumnTypeName YEAR.
  282. getPrecision 4.
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!