Connection Stack |
Mazzaro Rudi |
2018-07-18 08:49:20 |
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 |
|
What's your particular jar name? What's your urlname?
|
Re:Re:Connection Stack |
Rudi Mazzaro |
2018-07-18 23:17:35 |
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 |
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 |
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 |
|
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 |
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 |
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 |
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 |
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 |
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 |
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 |
>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".
|
Main
webmaster@hxtt.com