Main   Products   Offshore Outsourcing   Customers   Partners   ContactUs  
JDBC Databases
  HXTT Access v7.0
  HXTT Cobol v4.0
  HXTT DBF v7.0
  HXTT Excel v6.0
 
  Buy Now
  Support
  Download
  Document
  FAQ
  HXTT Paradox v7.0
  HXTT PDF v1.1
  HXTT Text(CSV) v7.0
  HXTT Word v1.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 Excel
Cannot drop database from memory
S.P.L Srikanth
2013-01-04 07:11:40.0
Hi,
We recently have purchased Excel_Core_JDBC20.jar, HXTT_Common_JDBC20.jar In order to upload 2010 Excel file in JDK 1.2.
Code:
JDBC URL = jdbc:excel:///_memory_/?versionNumber=XLSX
DRIVER CLASS = com.hxtt.sql.excel.ExcelDriver
Properties properties=new Properties();
properties.setProperty("tmpdir","_memory_");
properties.setProperty("delayedClose","-1");
properties.setProperty("firstRowHasNames","false");

I can able to create in memory database, but when I am trying to drop the database, I am getting the following error. Please take a look

Error:
[1/3/13 15:41:36:190 EST] 5251f7ee WebGroup X Servlet Error: Failed to drop database ARPServices754.xls.: java.sql.SQLException: Failed to drop database ARPServices754.xls.
at com.hxtt.global.SQLState.SQLException(Unknown Source)(Inlined Compiled Code)
at com.hxtt.sql.excel.ah.a(Unknown Source)(Compiled Code)
at com.hxtt.sql.ee.a(Unknown Source)
at com.hxtt.sql.ee.a(Unknown Source)
at com.hxtt.sql.ee.a(Unknown Source)
at com.hxtt.sql.a4.a(Unknown Source)
at com.hxtt.sql.a4.a(Unknown Source)
at com.hxtt.sql.a4.execute(Unknown Source)
Re:Cannot drop database from memory
HXTT Support
2013-01-04 20:12:23.0
2013-01-05 v4.1.099 fixed a bug for XLSX format, which can't detect date type when there's no numFmts element.

>I can able to create in memory database, but when I am trying to drop the database, I am getting the following error. Please take a look
Failed to recur that issue. The below code is my test code:

package test.jdbc.excel;


import java.sql.*;
import java.util.Properties;

public class testMemoryDrop {
public static void main(String argv[]) {
try {
Class.forName("com.hxtt.sql.excel.ExcelDriver").newInstance();

String url = "jdbc:excel:///_memory_/?versionNumber=XLSX";

Properties properties=new Properties();
properties.setProperty("tmpdir","_memory_");
properties.setProperty("delayedClose","-1");
properties.setProperty("firstRowHasNames","false");

Connection con = DriverManager.getConnection(url, properties );

Statement stmt = con.createStatement();

String sql = "create database if not exists test ?";
PreparedStatement pstmt = con.prepareStatement(sql);

java.io.FileInputStream in=new java.io.FileInputStream("/test/excel/TARPIDNTANKSSFTP1.xlsx");

pstmt.setObject(1, in); // Load a file from jsp and get the input stream.
// pstmt.setObject(1, mappingBean.getFileContentStream()); // Load a file from jsp and get the input stream.


pstmt.executeUpdate();
pstmt.close();

sql = "Select * from test.TARPIDNTANKSSFTP";
stmt = con.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE, ResultSet.CONCUR_READ_ONLY);
ResultSet rs = stmt.executeQuery(sql);


ResultSetMetaData resultSetMetaData = rs.getMetaData();
int iNumCols = resultSetMetaData.getColumnCount();
for (int i = 1; i <= iNumCols; i++) {
System.out.println(resultSetMetaData.getColumnLabel(i)
+ " " +
resultSetMetaData.getColumnTypeName(i));
}

Object colval;
while (rs.next()) {
for (int i = 1; i <= iNumCols; i++) {
colval = rs.getObject(i);
// System.out.print(colval + " " + "/t");
System.out.print(colval + " " + "\t");
}
System.out.println();
}

rs.close();

sql="drop database test";

System.out.println(sql+":"+stmt.executeUpdate(sql));


stmt.close();



con.close();
}
catch (Exception e) {
System.out.println(e.getMessage());
e.printStackTrace();
}
}
}
Re:Re:Cannot drop database from memory
S.P.L Srikanth
2013-01-09 08:28:50.0
It is working fine through web application. But, You can reproduce the issue when you try through portal.
Re:Re:Re:Cannot drop database from memory
HXTT Support
2013-01-09 18:06:55.0
>But, You can reproduce the issue when you try through portal.
If possible, please email us your test sample.
Re:Re:Re:Re:Cannot drop database from memory
S.P.
2013-01-09 18:59:50.0
There is no code modification for portal. The above given code is same for both web and portal.
Re:Re:Re:Re:Re:Cannot drop database from memory
S.P.L Srikanth
2013-01-12 10:08:28.0
The Issue is still reproducible through portal. Please try to sort this issue as this is critical fix
Re:Re:Re:Re:Re:Re:Cannot drop database from memory
S.P.L Srikanth
2013-01-12 13:32:33.0
Hi,
Below is my code used to load the file and read te content. The code is working fine in my local(web application). I am getting 2 errors when I communicate through portal (Portal application is deployed in seperate server which communicates with my application)
Issue 1: Cannot read the table Name
Issue 2: Cannot drop the database
private String convertExcelToBean(MappingBean mappingBean, boolean is2010Excel) throws Exception {
String errorMessage = null;
PreparedStatement pstmt = null;
Statement stmt = null;
ResultSet rs = null;
Connection con = null;
String databaseName = "Database"+getRandomNumber();
try {
Class.forName("com.hxtt.sql.excel.ExcelDriver").newInstance();
String url=null;
Properties properties=new Properties();
properties.setProperty("tmpdir","_memory_");//Enabled it if you have not disk access right.
properties.setProperty("delayedClose","-1");//Release database at once.
properties.setProperty("firstRowHasNames","false");//no header rows.
if(is2010Excel) {
url="jdbc:excel:///_memory_/?versionNumber=XLSX";
} else {
url="jdbc:excel:///_memory_/";
}
con = DriverManager.getConnection(url,properties);
stmt = con.createStatement();
DatabaseMetaData databaseMetadata = con.getMetaData();
rs = databaseMetadata.getCatalogs();
List list = new ArrayList();
while (rs.next()) {
String listofDatabases=rs.getString("TABLE_CAT");
list.add(listofDatabases);
}
boolean databaseExists = true;
while(databaseExists) {
if(list.contains(databaseName)) {
databaseName = "Database"+getRandomNumber();
} else {
databaseExists = false;
}
}
String sql = "create database if not exists "+databaseName+" ?";
pstmt = con.prepareStatement(sql);
pstmt.setObject(1,mappingBean.getFileContentStream()); // Load a file from jsp and get the input stream.
pstmt.executeUpdate();
pstmt.close();
mappingBean.getFileContentStream().close();
//sql = "Select * from "+databaseName+".Sheet1";
//sql = "SELECT * FROM INFORMATION_SCHEMA.TABLES ";
//stmt=con.createStatement();
//rs = stmt.executeQuery(sql);
// rs.beforeFirst();
if(is2010Excel) {
rs = con.getMetaData().getTables(databaseName+".xlsx", null, "%", null);
} else {
rs = con.getMetaData().getTables(databaseName+".xls", null, "%", null);
}
System.out.println("1");
String tableName = "";
while(rs.next()) {
System.out.println("2");
tableName = rs.getString("TABLE_NAME");
System.out.println("3");
System.out.println("Table Name "+tableName);
}
if(StringUtils.isEmpty(tableName)) {
closeMemoryDB(con, databaseName);
return FileUploadConstants.PC_INTERNAL_ERROR;
}
sql = "Select * from "+databaseName+"."+tableName;
stmt=con.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE, ResultSet.CONCUR_READ_ONLY);
rs = stmt.executeQuery(sql);
} catch( SQLException sqle ) {
log.error("SQL Exception due to "+sqle.getMessage());
System.out.println("SQL Exception due to "+sqle.getMessage());
errorMessage = FileUploadConstants.PC_INTERNAL_ERROR;
} catch (Exception e) {
log.error("Exception due to "+e.getMessage());
System.out.println("Exception due to "+e.getMessage());
errorMessage = FileUploadConstants.PC_FILE_INVALID_FORMAT;
} finally {
if(null != rs) {
rs.close();
}
if(null != pstmt) {
pstmt.close();
}
if(null != stmt) {
stmt.close();
}
}
closeMemoryDB(con, databaseName);
return errorMessage;
}
private void closeMemoryDB(Connection con, String databaseName) throws SQLException {
Statement stmt = null;
try {
System.out.println("4");
String sql = "drop database "+databaseName;
stmt = con.createStatement();
int i = stmt.executeUpdate(sql);
System.out.println("Database dropped "+i);
} catch(SQLException ex) {
System.out.println("Cannot drop database due to "+ex.getMessage());
} finally {
if(null != stmt) {
stmt.close();
}
if(null != con) {
con.close();
}
}
}

Please consider this as high priority and provide me the solution.
Re:Re:Re:Re:Re:Re:Cannot drop database from memory
S.P.L Srikanth
2013-01-12 13:41:46.0
Is it like DB admin only can perform Metadata and dropping the database from memory actions? Do the user who logged into portal needs access/something?
Re:Re:Re:Re:Re:Re:Re:Re:Cannot drop database from memory
HXTT Support
2013-01-12 17:44:56.0
According to our test, it works normal. So that I need to know one thing, whether your portal doesn't allow any file i/o on disk? If soo, then we have know that issue reason, because sometimes HXTT Excel will use temporary file. We will release a version which won't use temporary disk file, if that's your issue.


package test.jdbc.excel;

import java.sql.*;
import java.util.*;

public class testMemoryDrop2 {
private int getRandomNumber(){
return (int)(System.currentTimeMillis()&0x7FFFFFFF);
}
private String convertExcelToBean(MappingBean mappingBean, boolean is2010Excel) throws Exception {
String errorMessage = null;
PreparedStatement pstmt = null;
Statement stmt = null;
ResultSet rs = null;
Connection con = null;
String databaseName = "Database" + getRandomNumber();
try {
Class.forName("com.hxtt.sql.excel.ExcelDriver").newInstance();
String url = null;
Properties properties = new Properties();
properties.setProperty("tmpdir", "_memory_");//Enabled it if you have not disk access right.
properties.setProperty("delayedClose", "-1");//Release database at once.
properties.setProperty("firstRowHasNames", "false");//no header rows.
if (is2010Excel) {
url = "jdbc:excel:///_memory_/?versionNumber=XLSX";
} else {
url = "jdbc:excel:///_memory_/";
}
con = DriverManager.getConnection(url, properties);
stmt = con.createStatement();
DatabaseMetaData databaseMetadata = con.getMetaData();
rs = databaseMetadata.getCatalogs();
List list = new ArrayList();
while (rs.next()) {
String listofDatabases = rs.getString("TABLE_CAT");
list.add(listofDatabases);
}
boolean databaseExists = true;
while (databaseExists) {
if (list.contains(databaseName)) {
databaseName = "Database" + getRandomNumber();
} else {
databaseExists = false;
}
}
String sql = "create database if not exists " + databaseName + " ?";
pstmt = con.prepareStatement(sql);
pstmt.setObject(1, mappingBean.getFileContentStream()); // Load a file from jsp and get the input stream.
pstmt.executeUpdate();
pstmt.close();
mappingBean.getFileContentStream().close();
//sql = "Select * from "+databaseName+".Sheet1";
//sql = "SELECT * FROM INFORMATION_SCHEMA.TABLES ";
//stmt=con.createStatement();
//rs = stmt.executeQuery(sql);
// rs.beforeFirst();
if (is2010Excel) {
rs = con.getMetaData().getTables(databaseName + ".xlsx", null, "%", null);
} else {
rs = con.getMetaData().getTables(databaseName + ".xls", null, "%", null);
}
System.out.println("1");
String tableName = "";
while (rs.next()) {
System.out.println("2");
tableName = rs.getString("TABLE_NAME");
System.out.println("3");
System.out.println("Table Name " + tableName);
}
if (tableName==null || tableName.length()==0) {
// if (StringUtils.isEmpty(tableName)) {
closeMemoryDB(con, databaseName);
return "Ineternal Error";//FileUploadConstants.PC_INTERNAL_ERROR;
}
sql = "Select * from " + databaseName + "." + tableName;
stmt = con.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE, ResultSet.CONCUR_READ_ONLY);
rs = stmt.executeQuery(sql);
} catch (SQLException sqle) {
sqle.printStackTrace();
//log.error("SQL Exception due to " + sqle.getMessage());
System.out.println("SQL Exception due to " + sqle.getMessage());
errorMessage = "Internal Error";//FileUploadConstants.PC_INTERNAL_ERROR;
} catch (Exception e) {
e.printStackTrace();
//log.error("Exception due to " + e.getMessage());
System.out.println("Exception due to " + e.getMessage());
errorMessage = "Invalid Format";//FileUploadConstants.PC_FILE_INVALID_FORMAT;
} finally {
if (null != rs) {
rs.close();
}
if (null != pstmt) {
pstmt.close();
}
if (null != stmt) {
stmt.close();
}
}
closeMemoryDB(con, databaseName);
return errorMessage;
}

private void closeMemoryDB(Connection con, String databaseName) throws SQLException {
Statement stmt = null;
try {
System.out.println("4");
String sql = "drop database " + databaseName;
stmt = con.createStatement();
int i = stmt.executeUpdate(sql);
System.out.println("Database dropped " + i);
} catch (SQLException ex) {
System.out.println("Cannot drop database due to " + ex.getMessage());
} finally {
if (null != stmt) {
stmt.close();
}
if (null != con) {
con.close();
}
}
}

public static void main(String argv[]) {
try {
MappingBean mb=new MappingBean("/test/excel/TARPIDNTANKSSFTP1.xlsx");

testMemoryDrop2 tmd=new testMemoryDrop2();
tmd.convertExcelToBean(mb, true);

} catch (Exception e) {
System.out.println(e.getMessage());
e.printStackTrace();
}
}
}

class MappingBean{
java.io.InputStream in;
MappingBean(String fileName)throws java.io.IOException{
in = new java.io.FileInputStream(fileName);
}

java.io.InputStream getFileContentStream(){
return in;
}

}
Re:Re:Re:Re:Re:Re:Re:Re:Cannot drop database from memory
S.P.L Srikanth
2013-01-12 21:12:05.0
The main intention of creating and using database in memory is we do not want to create any type of files in our servers(even temporary). Even We do not have access to create any files in our production servers. So, Please provide an option such that, the database will be created in memory and dropped.

And one more thing, We are expecting maximum 10 users uploading excel files of 50K records. If we are using in memory database, Please confirm whether the uploads will not crash the JVM/ results OutOfMemoryException.
Re:Re:Re:Re:Re:Re:Re:Re:Cannot drop database from memory
S.P.L Srikanth
2013-01-12 21:21:27.0
If you are providing jar files, Please make sure You provide the fix in Excel_Core_JDBC20.jar, HXTT_Common_JDBC20.jar files
Re:Re:Re:Re:Re:Re:Re:Re:Cannot drop database from memory
HXTT Support
2013-01-13 06:09:10.0
Please download the latest package. But doesn't make sure whether your issue is resulted by using temporary file disk io.
The following code can help to dig out your issue.

catch( SQLException sqle )
{
do
{
System.out.println(sqle.getMessage());
System.out.println("Error Code:"+sqle.getErrorCode());
System.out.println("SQL State:"+sqle.getSQLState());
sqle.printStackTrace();
}while((sqle=sqle.getNextException())!=null);
}


>We are expecting maximum 10 users uploading excel files of 50K records. If we are using in memory database, Please confirm whether the uploads will not crash
> the JVM/ results OutOfMemoryException.
You should use a large memory if your XLSX file has 1,048,576 rows.

Re:Re:Re:Re:Re:Re:Re:Re:Cannot drop database from memory
S.P.L Srikanth
2013-01-15 08:06:38.0
Hi,
I tried to upload a file today. But, I am getting same issue again.
1. I am not getting any table names when I use
rs = con.getMetaData().getTables(databaseName+".xlsx", null, "%", null);
2. Getting exception while dropping database.
Cannot drop database due to Failed to drop database test401.xlsx
Failed to drop database test401.xlsx
Error Code:249856
SQL State:3D000

Please take a look and fix this issue ASAP.

Again, Everything working fine through web application. The problem persists when I try through portal.
Re:Re:Re:Re:Re:Re:Re:Re:Cannot drop database from memory
HXTT Support
2013-01-15 16:43:42.0
>String databaseName = "Database"+getRandomNumber();
>Failed to drop database test401.xlsx
Whether you should use Database401, not test401?

>rs = con.getMetaData().getTables(databaseName+".xlsx", null, "%", null);
You can use

rs = databaseMetadata.getCatalogs();
while (rs.next()) {
String listofDatabases = rs.getString("TABLE_CAT");
System.out.println(listofDatabases);
}

to see whether there's your xlsx file before you wish to drop it.

>Again, Everything working fine through web application. The problem persists when
> I try through portal.
HXTT Excel is platform-independent pure Java driver, so that you should tell us what's the difference between you web application server, and portal server.
Re:Re:Re:Re:Re:Re:Re:Re:Cannot drop database from memory
S.P.L Srikanth
2013-01-16 07:21:53.0
I am getting the error
Failed to drop database Database401.xlsx (I have modified the name, the actual database name will be my project name)
Re:Re:Re:Re:Re:Re:Re:Re:Cannot drop database from memory
HXTT Support
2013-01-16 07:23:40.0
You can use


rs = databaseMetadata.getCatalogs();

while (rs.next()) {

String listofDatabases = rs.getString("TABLE_CAT");

System.out.println(listofDatabases);

}


to see whether there's your xlsx file before you wish to drop it.
Re:Re:Re:Re:Re:Re:Re:Re:Cannot drop database from memory
S.P.L Srikanth
2013-01-16 08:07:13.0
ok For dropping I can use the above and drop accordingly.
But, I cannot get the table name for below code.
1. I am not getting any table names when I use
rs = con.getMetaData().getTables(databaseName+".xlsx", null, "%", null);
Please solve this
Re:Re:Re:Re:Re:Re:Re:Re:Cannot drop database from memory
HXTT Support
2013-01-16 16:15:41.0
>ok For dropping I can use the above and drop accordingly.
You can drop normally?

>1. I am not getting any table names when I use
>rs = con.getMetaData().getTables(databaseName+".xlsx", null, "%", null);
It happens on your portal server, but succeeded on your web application server? You can output that failed xlsx file into a file, then email us to check it.
Re:Re:Re:Re:Re:Re:Re:Re:Cannot drop database from memory
S.P.L Srikanth
2013-01-17 19:54:46.0
When I try to directly access the table using below code
sql = "Select * from "+databaseName+".BLAh";
stmt=con.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE, ResultSet.CONCUR_READ_ONLY);
rs = stmt.executeQuery(sql);
I am getting below error


Exception:
[1/17/13 22:39:06:867 EST] 7f5efffe SystemOut U java.util.zip.ZipException: invalid block type
at java.util.zip.InflaterInputStream.read(InflaterInputStream.java(Compiled Code))
at java.util.zip.ZipInputStream.read(ZipInputStream.java:154)
at com.hxtt.concurrent.w.a(Unknown Source)
at com.hxtt.concurrent.w.a(Unknown Source)
at com.hxtt.concurrent.t.a(Unknown Source)
at com.hxtt.concurrent.t.a(Unknown Source)
at com.hxtt.concurrent.s.e(Unknown Source)
at com.hxtt.concurrent.c.d(Unknown Source)(Compiled Code)
at com.hxtt.concurrent.s.(Unknown Source)
at com.hxtt.concurrent.aa.a(Unknown Source)
at com.hxtt.concurrent.ax.a(Unknown Source)(Compiled Code)
at com.hxtt.concurrent.s.new(Unknown Source)(Inlined Compiled Code)
at com.hxtt.sql.excel.a6.(Unknown Source)(Compiled Code)
at com.hxtt.sql.excel.bk.int(Unknown Source)(Inlined Compiled Code)
at com.hxtt.sql.excel.bk.new(Unknown Source)(Compiled Code)
at com.hxtt.sql.excel.bk.(Unknown Source)
at com.hxtt.sql.excel.c4.a(Unknown Source)
at com.hxtt.concurrent.ax.a(Unknown Source)(Compiled Code)
at com.hxtt.sql.excel.bk.do(Unknown Source)(Compiled Code)
at com.hxtt.sql.excel.c2.a(Unknown Source)
at com.hxtt.concurrent.ax.a(Unknown Source)(Compiled Code)
at com.hxtt.sql.excel.bq.a(Unknown Source)
at com.hxtt.sql.excel.ah.a(Unknown Source)
at com.hxtt.sql.ee.if(Unknown Source)
at com.hxtt.sql.w.a(Unknown Source)(Compiled Code)
at com.hxtt.sql.w.a(Unknown Source)(Compiled Code)
at com.hxtt.sql.dv.a(Unknown Source)
at com.hxtt.sql.ee.a(Unknown Source)
at com.hxtt.sql.a4.a(Unknown Source)
at com.hxtt.sql.a4.a(Unknown Source)
at com.hxtt.sql.a4.executeQuery(Unknown Source)
at com.comerica.forms.types.FileUploadController.convertExcelToBean(FileUploadController.java(Compiled Code))
at com.comerica.forms.types.FileUploadController.readAndValidateFile(FileUploadController.java(Compiled Code))
at com.comerica.forms.types.FileUploadController.uploadFile(FileUploadController.java(Compiled Code))
at com.comerica.forms.types.FormLoaderServlet.doPost(FormLoaderServlet.java(Compiled Code))
at javax.servlet.http.HttpServlet.service(HttpServlet.java:760)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
at com.ibm.servlet.engine.webapp.StrictServletInstance.doService(ServletManager.java:827)
at com.ibm.servlet.engine.webapp.StrictLifecycleServlet._service(StrictLifecycleServlet.java:167)
at com.ibm.servlet.engine.webapp.IdleServletState.service(StrictLifecycleServlet.java:297)
at com.ibm.servlet.engine.webapp.StrictLifecycleServlet.service(StrictLifecycleServlet.java:110)
at com.ibm.servlet.engine.webapp.ServletInstance.service(ServletManager.java:472)
at com.ibm.servlet.engine.webapp.ValidServletReferenceState.dispatch(ServletManager.java:1012)
at com.ibm.servlet.engine.webapp.ServletInstanceReference.dispatch(ServletManager.java:913)
at com.ibm.servlet.engine.webapp.WebAppRequestDispatcher.handleWebAppDispatch(WebAppRequestDispatcher.java:721)
at com.ibm.servlet.engine.webapp.WebAppRequestDispatcher.dispatch(WebAppRequestDispatcher.java:374)
at com.ibm.servlet.engine.webapp.WebAppRequestDispatcher.forward(WebAppRequestDispatcher.java:118)
at com.ibm.servlet.engine.srt.WebAppInvoker.doForward(WebAppInvoker.java:134)
at com.ibm.servlet.engine.srt.WebAppInvoker.handleInvocationHook(WebAppInvoker.java:239)
at com.ibm.servlet.engine.invocation.CachedInvocation.handleInvocation(CachedInvocation.java:67)
at com.ibm.servlet.engine.invocation.CacheableInvocationContext.invoke(CacheableInvocationContext.java:106)
at com.ibm.servlet.engine.srp.ServletRequestProcessor.dispatchByURI(ServletRequestProcessor.java:154)
at com.ibm.servlet.engine.oselistener.OSEListenerDispatcher.service(OSEListener.java:317)
at com.ibm.servlet.engine.http11.HttpConnection.handleRequest(HttpConnection.java:60)
at com.ibm.ws.http.HttpConnection.readAndHandleRequest(HttpConnection.java(Compiled Code))
at com.ibm.ws.http.HttpConnection.run(HttpConnection.java(Compiled Code))
at com.ibm.ws.util.CachedThread.run(ThreadPool.java:144)

[1/17/13 22:39:06:867 EST] 7f5efffe SystemOut U Error Code:393216
[1/17/13 22:39:06:867 EST] 7f5efffe SystemOut U SQL State:60000
[1/17/13 22:39:06:880 EST] 7f5efffe SystemOut U Cannot drop database due to Failed to drop database ARPServices833.xlsx.
[1/17/13 22:39:06:880 EST] 7f5efffe SystemOut U Failed to drop database ARPServices833.xlsx.
[1/17/13 22:39:06:880 EST] 7f5efffe SystemOut U Error Code:249856
[1/17/13 22:39:06:880 EST] 7f5efffe SystemOut U SQL State:3D000

Since the Database is failed, I cross checked whether the table has been created in memory by using below code, I can able to see ARPServices833.xlsx in (TABLE_CAT)

DatabaseMetaData databaseMetadata = con.getMetaData();
rs = databaseMetadata.getCatalogs();
List list = new ArrayList();
while (rs.next()) {
String listofDatabases = rs.getString("TABLE_CAT");
System.out.println("Database Available "+listofDatabases);
}
This is high priority issue, Our UAT stopped due to this un expected issue. Please solve this ASAP
Re:Re:Re:Re:Re:Re:Re:Re:Cannot drop database from memory
S.P.L Srikanth
2013-01-17 21:05:52.0
FYI.. Here are the header information I captured to compare between uploading through portal and through Web App

Note: As I told earlier, It is working fine in web app, but getting the above error through portal.

Portal:

[1/17/13 22:05:23:734 EST] 7f602d3d SystemOut U Header Data: image/gif, image/jpeg, image/pjpeg, image/pjpeg, application/x-shockwave-flash, application/x-ms-application, application/x-ms-xbap, application/vnd.ms-xpsdocument, application/xaml+xml, application/vnd.ms-excel, application/vnd.ms-powerpoint, application/msword, */*
[1/17/13 22:05:23:735 EST] 7f602d3d SystemOut U Header Data: en-us
[1/17/13 22:05:23:735 EST] 7f602d3d SystemOut U Header Data: no-cache
[1/17/13 22:05:23:735 EST] 7f602d3d SystemOut U Header Data: 20307
[1/17/13 22:05:23:735 EST] 7f602d3d SystemOut U Header Data: multipart/form-data; boundary=---------------------------7dd1cc1a4708f8
[1/17/13 22:05:23:735 EST] 7f602d3d SystemOut U Header Data: rapportVerification=YJLWHL567gRJPUMj0yenPvEnINqoi0KbH4OXrLAzFuA%3D;JSESSIONID=00004XMAUNQGZIAYPV43YAT2UUY:ulnmn9ts;demoCookie=ContentAuthCheck;, $Version=0; JSESSIONID=00004XMAUNQGZIAYPV43YAT2UUY:ulnmn9ts; $Path=/
[1/17/13 22:05:23:735 EST] 7f602d3d SystemOut U Header Data: XXXXX:XXXXX
[1/17/13 22:05:23:735 EST] 7f602d3d SystemOut U Header Data: MARPCT02ADMIN
[1/17/13 22:05:23:735 EST] 7f602d3d SystemOut U Header Data: https://XXXXXXXXXXX.com/cmat/portal/mybusinessconnect/!ut/p/kcxml/04_Sj9SPykssy0xPLMnMz0vM0Y_QjzKLN4g3NjcFSYGZQBaakCNCxNcjPzcVKB5pDhSw9AzUD9EP0vfWD9AvyA2NKDdOdwQAylIO2Q!!/delta/base64xml/L0lDVE83b0pKN3VhQ1NZS0NsRUtDbEVLQ2xFQSEvWUtVSUFBSUlJSUlJSU1NSUlJTUlJQ0NJS0dLR09NRUFFQUtCSkJKT0JGTkZOT0ZBLzRCMWljb25RVndHeE9VVG9LNzlZUTdEbjY1QTJITU53anNPVWJrQSEvN18wXzlJUS8zMS91cmwvJTBmb3JtcyUwYXBwJTBBUlBGb3JtTG9hZGVyP2Zvcm1uYW1lPUFSUFNlcnZpY2VzL3JlZnJlc2g!
[1/17/13 22:05:23:735 EST] 7f602d3d SystemOut U Header Data: Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 5.1; Trident/4.0; .NET CLR 1.1.4322; .NET CLR 2.0.50727; .NET CLR 3.0.4506.2152; .NET CLR 3.5.30729; .NET4.0C; .NET4.0E; InfoPath.3)
[1/17/13 22:05:23:735 EST] 7f602d3d SystemOut U Header Data: HTTP/1.1 miptlpxa01:443
[1/17/13 22:05:23:735 EST] 7f602d3d SystemOut U Header Data: html
[1/17/13 22:05:23:735 EST] 7f602d3d SystemOut U Header Data: FW0;181344249;238580;2;181344249;238580;2
[1/17/13 22:05:23:735 EST] 7f602d3d SystemOut U Header Data: 100-Continue

Web Application:

[1/17/13 22:07:41:745 EST] 7f5dad3d SystemOut U Header Data: image/gif, image/jpeg, image/pjpeg, image/pjpeg, application/x-shockwave-flash, application/x-ms-application, application/x-ms-xbap, application/vnd.ms-xpsdocument, application/xaml+xml, application/vnd.ms-excel, application/vnd.ms-powerpoint, application/msword, */*
[1/17/13 22:07:41:745 EST] 7f5dad3d SystemOut U Header Data: gzip, deflate
[1/17/13 22:07:41:745 EST] 7f5dad3d SystemOut U Header Data: en-us
[1/17/13 22:07:41:745 EST] 7f5dad3d SystemOut U Header Data: no-cache
[1/17/13 22:07:41:745 EST] 7f5dad3d SystemOut U Header Data: Keep-Alive
[1/17/13 22:07:41:745 EST] 7f5dad3d SystemOut U Header Data: 15467
[1/17/13 22:07:41:745 EST] 7f5dad3d SystemOut U Header Data: multipart/form-data; boundary=---------------------------7dd3982c91688
[1/17/13 22:07:41:745 EST] 7f5dad3d SystemOut U Header Data: JSESSIONID=0000IIS1EDNFJCKYI0OG30E1GSY:ulnmn9ts
[1/17/13 22:07:41:745 EST] 7f5dad3d SystemOut U Header Data: XXXXX:XXXXX
[1/17/13 22:07:41:745 EST] 7f5dad3d SystemOut U Header Data: http://XXXXXX:XXXXX/forms/app/ARPFormLoader?formname=ARPServices
[1/17/13 22:07:41:745 EST] 7f5dad3d SystemOut U Header Data: Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 5.1; Trident/4.0; .NET CLR 1.1.4322; .NET CLR 2.0.50727; .NET CLR 3.0.4506.2152; .NET CLR 3.5.30729; .NET4.0C; .NET4.0E; InfoPath.3)
[1/17/13 22:07:41:745 EST] 7f5dad3d SystemOut U Header Data: v1.2
[1/17/13 22:07:41:745 EST] 7f5dad3d SystemOut U Header Data: 100-Continue


Re:Re:Re:Re:Re:Re:Re:Re:Cannot drop database from memory
S.P.L Srikanth
2013-01-21 05:15:14.0
Hi,
Any updates on this issue? I want this fix ASAP. Please try to solve or give any idea for work around
Re:Re:Re:Re:Re:Re:Re:Re:Cannot drop database from memory
HXTT Support
2013-01-22 04:23:11.0
Sorry for missed to see your reply in 2013-01-17.

>Exception:[1/17/13 22:39:06:867 EST] 7f5efffe SystemOut U >java.util.zip.ZipException: invalid block type
>at java.util.zip.InflaterInputStream.read(InflaterInputStream.java(Compiled
> Code))

>Since the Database is failed, I cross checked whether the table has been created
> in memory by using below code, I can able to see ARPServices833.xlsx in
> (TABLE_CAT)
Because HXTT Excel need to create that file in memory first, then parse it. It throw that issue because it failed to unzip that file. XLSX file is in ZIP format.

Your webapplication output:
[1/17/13 22:07:41:745 EST] 7f5dad3d SystemOut U Header Data: gzip, deflate

Your Portal output:
[1/17/13 22:05:23:735 EST] 7f602d3d SystemOut U Header Data: html

So two of your output application is different. Your portal application is wrongly using html format for binary file(zip format in fact), so that it will change or compress your binary data as text data free, for instance, merge space character, \r\n, and so on. So that your zip file have been conrrupted. You should modify or assign the code for file format information.



Search Key   Search by Last 50 Questions




Google
 

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