Content in 2019

Page 1 out of 2 Pages

• Why does DBMaker return null when using QueryRunner or ResultSet function in JDBC?

  It’s a problem of org.apache.commons.dbutils.QueryRunner. If you have the same column name in different table, you have to use “as”
  15 views
• How to add single quotation mark in char compatible type?

  You have to add two single quotations in string. For example, if you want to add “Hello, I’m DBMaker!” in
  18 views
• Does DBMaker support Resultset.isLast() in JDBC

  DBMake doesn’t support Resultset.isLast() method in JDBC. You can use Resultset.next() to check the cursor is in last position of
  16 views
• What is minimum length of column to save AES_ENCRYPT data?

  After using AES_ENCRYPT function, the data is encrypted and enlarged. If the length of column was not enough to save
  23 views
• How much is the Key length for network encryption? How to work? (DBMR3291)

  To start network encryption, set DB_NETEC to 1 in dmconfig.ini. All data is encrypted by DES, and transmits to clients.
  21 views
• How to fix invalid view? (DBMR3289)

  If you dropped the table, then recreated the table, the view which was based on the table became invalid view.
  23 views
• How to set system file object extension name in PHP via PDO ODBC? (DBMR3280)

  Without loading file $DB = new PDO('odbc:mydb', 'sysadm', '');   $filePath = '/tmp/demo.html'; $id = 1;   $sth = $DB->prepare("update demo set f = ? where
  29 views
• How to export and import data to JSON format?

  Enter below code to create store procedure “EXPORTJSON”. This stored procedure can export table to JSON format.   dmSQL> set block delimiter
  29 views
• How to avoid shrinking database with journal full? (DBMR3233)

  Shrinking database could be rolled back, which meant your “shrink” operation required journal file, and the required size should be
  20 views
• How to get table schema via query? (DBMR3207)

  From DBMaker 5.4.3, you can get table schema via dmSQL or JDBA tool.   1. There is a table t1 in the
  22 views

• 1
  
• 2
  
• →
  
• ⇥

one category up