Main   Products   Offshore Outsourcing   Customers   Partners   ContactUs  
JDBC Databases
  HXTT Access v7.0
 
  Buy Now
  Support
  Download
  Document
  FAQ
  HXTT Cobol v4.0
  HXTT DBF v7.0
  HXTT Excel v6.0
  HXTT Paradox v7.0
  HXTT PDF v1.1
  HXTT Text(CSV) v7.0
  HXTT XML v3.0
Offshore Outsourcing
Free Resources
  Firewall Tunneling
  Search Indexing Robot
  Conditional Compilation
  Password Recovery for MS Access
  Password Recovery for Corel Paradox
  Checksum Tool for MD5
  Character Set Converter
  Pyramid - Poker of ZYH
   
   
   
Heng Xing Tian Tai Lab of Xi'an City (abbr, HXTT)

HXTT ACCESS
Connection Stack
Mazzaro Rudi
2018-07-18 08:49:20.0
Hy

I tried to use your JDBC jar files, but I have a problem.....In my project I use other JARs files to connect to other databases and I found that HXTT Jar conflicts with one of this...In fact if in my java app I use the

cnn = DriverManager.getConnection(urlname);

it starts but can't connect seems in a loop. If I exclude a particular JAR from my path It connects.

So is there a way to know where the problem is ?
I can give you my jar file if this can help you....

Thks
Re:Connection Stack
HXTT Support
2018-07-18 16:48:32.0
What's your particular jar name? What's your urlname?
Re:Re:Connection Stack
Rudi Mazzaro
2018-07-18 23:17:35.0
Hy

my program use two connection. The first to CtreeSql (http://www.faircom.com/) and use the ctreeJDBC.jar. The urlname for CtreeJDBC.jar is jdbc:ctree:6597@localhost:DbName where 6597 is the port where the service is active and DbName is the database name.
The class driver is ctree.jdbc.ctreeDriver.
As I wrote I can give you the jar file is necessary...

Hy
Re:Re:Re:Connection Stack
HXTT Support
2018-07-19 04:18:51.0
You can send us the jar file through support@hxtt.com . I guess that is looped by ctreeDriver. Maybe HXTT Access driver register first can skip that issue.
Re:Re:Re:Re:Connection Stack
Rudi Mazzaro
2018-07-19 05:13:48.0
File Sent...as wrote in the mail I renamed it as TXT due to mail security.

Thks
Re:Re:Re:Re:Connection Stack
Rudi Mazzaro
2018-07-19 05:15:20.0
Sorry...remember as I wrote that I have this problem even if the ctreeJDBC.jar file is in CLASSPATH and I don't use it in my app.
Re:Re:Re:Re:Re:Re:Connection Stack
HXTT Support
2018-07-19 06:38:13.0
Tested. No issue fro using
Class.forName("ctree.jdbc.ctreeDriver").newInstance();
Class.forName("com.hxtt.sql.access.AccessDriver").newInstance();
String url="jdbc:access:///d:/test/access/issue3/Broken_t_connector.mdb?versionNumber=JET3";
Connection con = DriverManager.getConnection(url,properties);

I noticed that there's a same \META-INF\services\java.sql.Driver file in ctreeJDBC.jar an Access_JDBC??.jar . Try to use any Zip tool(For instance, 7-zip) to remove the file in Access_JDBC??.jar , and see whether your issue disappear.
Re:Re:Re:Re:Re:Re:Re:Connection Stack
Rudi Mazzaro
2018-07-19 07:06:15.0
Hy
dont work.... this is my test procject
public static void main(String[] args) throws InstantiationException, IllegalAccessException {
String urlname = "jdbc:access:///C:/dati/pictures.mdb?versionNumber=JET3";
try {
Class.forName("com.hxtt.sql.access.AccessDriver");
} catch (ClassNotFoundException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
Connection cnn = null;
try {
System.out.println("TRY TO CONNECTED");
Date date = new Date();
System.out.println(date.toString());

cnn = DriverManager.getConnection(urlname);

Date date1 = new Date();
System.out.println("CONNECTED"+ " "+ DriverManager.getConnection(urlname).getClass().getName());
System.out.println(date1.toString());


Driver driver = DriverManager.getDriver(urlname);
DriverPropertyInfo prop[] = null;
prop = driver.getPropertyInfo (urlname , new Properties());
for (int i = 0; i < prop.length; i++) {
System.out.print ("\t" + prop[i].name);
System.out.print (" = ");
System.out.print (prop[i].value);
System.out.print (" : ");
System.out.println (prop[i].description +".");
}
} catch (SQLException ec) {
// TODO Auto-generated catch block
ec.printStackTrace();
}
try {
cnn.close();
System.out.println("DICONNECTED");
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
ON console I see 3 minutes delay to connect

TRY TO CONNECTED
Thu Jul 19 15:51:22 CEST 2018
CONNECTED com.hxtt.sql.access.r
Thu Jul 19 15:54:14 CEST 2018
host = null : Database Server..
port = null : Database Server's listening port..
serverType = null : The type of Database Server on the remote host..
user = null : User name..
password = null : Password.
charSet = null : To specify a Character Encoding Scheme other than the client default.
cryptType = null : To specify a crypt type for Table Encryption and Column Level Encryption. All new created table in this connection will become crypted table. You can use DES, TRIDES, and BLOWFISH now. Deafult:null.
cryptKey = null : To specify a crypt key. Without crypt key, CREATE TABLE won't create crypted table. Deafult:null.
storeCryptKey = null : Indicates whether crypt key is stored in crypted table. If stored, crypted table can be opened automatically in any connection without predefined crypt properites. If not stored, cryptd table can only be opened with correct key. Deafult:false.
tmpdir = null : Indicates whether set a temp directory, Default: the value of JVM's "java.io.tmpdir" property. If that value is incorrect, uing the directory of JDBC url. _memory_ means large data in memory..
delayedClose = null : Indicates the delayed seconds for close transaction. That option is used to avoid frequent close/open table operations for following sqls. You can use 0~120 seconds. Default: 2.
maxIdleTime = null : Indicates the max idle time in minute for remote connection. That option is mainly used to avoid closing automatically idle remote connection for connection pool. Embedded idle connectoin won't be closed automatically except for garbage collection. You can use 1~1440 minutes. Default: 30.
maxCacheSize = null : Indicates the max memory utilization for per table on automatic temporary index or matched result cache. You can use 16~16384 kilo bytes. Default: 4096.
lockType = null : To specify a compatible lock for other applications of Access..
lockTimeout = null : To specify Access driver's timeout in milliseconds to wait until other processes or Access applications released record lock or table lock. 0 means a default value, and <0 means no wait..
refreshInterval = null : To specify Access driver's timeout in milliseconds to wait until other processes or Access applications released record lock or table lock. 0 means a default value, and <0 means no wait..
versionNumber = null : Version Number,only used for CREATE DATABASE. Default: JET4 .
ODBCTrimBehavior = null : Indicates whether works like MS Access ODBC driver to ignore tail space character in condition expression. You can use null, true, false. Default: true.
caseInsensitive = null : Indicates whether is case insensitve for string comparison. You can use null, true, false. Default: false.
otherExtension = null : Indicates whether Access driver supports other extension beside 'mdb', 'mde', 'accdb', 'accde', and 'accdr'. Default: null .
DICONNECTED

Re:Re:Re:Re:Re:Re:Re:Re:Connection Stack
HXTT Support
2018-07-19 08:42:42.0
Recurred your issue:)

After removed \META-INF\services\java.sql.Driver file from ctreeJDBC.jar, your issue disappear.

So the conclusion is:
ctreeJDBC.jar is using static code to load it into memory, and hang wrong the common DriverManager.getConnection(urlname); .
Re:Re:Re:Re:Re:Re:Re:Re:Connection Stack
Rudi Mazzaro
2018-07-19 09:11:41.0
Hy

yes but it takes 3 minutes to connect..

"TRY TO CONNECTED
Thu Jul 19 15:51:22 CEST 2018
CONNECTED com.hxtt.sql.access.r
Thu Jul 19 15:54:14 CEST 2018 "

Hy
Re:Re:Re:Re:Re:Re:Re:Re:Connection Stack
Hxtt Support
2018-07-19 16:07:06.0
After removed \META-INF\services\java.sql.Driver file from ctreeJDBC.jar

J:\temp>d:\jdk1.8.0\bin\java -classpath ctreeJDBC.jar;Access_JDBC41.jar;. test.jdbc.access.testCtree
Picked up JAVA_TOOL_OPTIONS: -Dfile.encoding=UTF-8 -Duser.language=en -Duser.country=US
TRY TO CONNECTED
Fri Jul 20 06:59:52 GMT+08:00 2018
CONNECTED com.hxtt.sql.access.r
Fri Jul 20 06:59:53 GMT+08:00 2018
host = null : Database Server..
Re:Re:Re:Re:Re:Re:Re:Re:Connection Stack
RUdi Mazzaro
2018-07-19 23:47:23.0
Hy

yes it works....I wrong deleting files from jar.
Last two questions...

1) do you think deleting java.sql.Driver from ctreeJDBC.jar can give problems ?

2) about Access_JDBC41 prices & license, we have a desktop application works on pc connected to server or on windows terminal server (different users connect to the same server and have their own desktop on server), so what have I to buy ?
"The Single Server License" or "Enterprise License" or "100 User Application License"


Thks.
Re:Re:Re:Re:Re:Re:Re:Re:Connection Stack
HXTT Support
2018-07-20 05:06:21.0
>1) do you think deleting java.sql.Driver from ctreeJDBC.jar can give
> problems ?
I think that should be an issue in ctree.jdbc.ctreeDriver static initiation code.


>2) about Access_JDBC41 prices & license, we have a desktop application works
> on pc connected to server or on windows terminal server (different users
> connect to the same server and have their own desktop on server), so what
> have I to buy ?
> "The Single Server License" or "Enterprise License" or "100 User Application License"
If your desktop application contains HXTT JDBC package, you need "Enterprise License" or "n User Application License".


Search Key   Search by Last 50 Questions




Google
 

Email: webmaster@hxtt.com
Copyright © 2003-2018 Heng Xing Tian Tai Lab of Xi'an City. | All Rights Reserved. | Privacy | Legal | Sitemap