RawrUniversal / xerial

Automatically exported from code.google.com/p/xerial
0 stars 1 forks source link

Problem opening db with long name/path #87

Open GoogleCodeExporter opened 8 years ago

GoogleCodeExporter commented 8 years ago
What steps will reproduce the problem?
1. Create sqlite db file with a long name
2. Put the file in a folder 3 to 5 levels from the root
Ex:
C:\Program Files\E6 Networks\Dat1 Manager\File System Stats\Default 
\Intermediate DBs\testveryverylongName-localhost- 
c_users_sfarnklin_documents_axr-program-docs-101014131935-localhost- 
c_users_sfarnklin_documents_axr-program- 
docs-101014131935-1288632600166-AllFiles.db 

3. Open the file through xerial

DriverManager.getConnection("jdbc:sqlite:/"+path,"",""); 

What is the expected output? What do you see instead?
The file should be opened without any problems.
Instead I see the following exception.

java.sql.SQLException: [SQLITE_CANTOPEN]  Unable to open the database 
file (out of memory) 
        at org.sqlite.DB.throwex(DB.java:386) 
        at org.sqlite.NativeDB._open(Native Method) 
        at org.sqlite.DB.open(DB.java:91) 
        at org.sqlite.Conn.<init>(Conn.java:149) 
        at org.sqlite.Conn.<init>(Conn.java:49) 
        at org.sqlite.JDBC.connect(JDBC.java:86) 
        at java.sql.DriverManager.getConnection(DriverManager.java:582) 
        at java.sql.DriverManager.getConnection(DriverManager.java:185) 
        at com.f5.sat.SatReportQuery.createConnection(SatReportQuery.java:65) 

What version of the product are you using? On what operating system?
Xerial 3.6.16 and 3.7.2 
Windows &

Please provide any additional information below.
I am able to open the file properly if I use sqlite:

C:\javaPackages>sqlite3 "C:\Program Files\E6 Networks\Dat1 Manager 
\File System Stats\Default 
\Intermediate DBs\testveryverylongName-localhost- 
c_users_sfarnklin_documents_axr-program-docs-101014131935-localhost- 
c_users_sfarnklin_documents_axr-program- 
docs-101014131935-1288632600166-AllFiles.db" 

Original issue reported on code.google.com by hkos...@yahoo.com on 18 Nov 2010 at 7:14